Courtney Baker

Co-founder @ Rosy
😎
Building power(ful) tools for landlords to take care of their rental properties.

Scheduled Analytic Emails using Airtable Data and Zapier or Integromat

😎
Hi All,

I've scoured a bunch of different posts about people trying to schedule Zaps to run on a schedule (or delay). I'm trying to do something slightly different and can't find a solution. In short, I'm trying to trigger an automation that grabs some analytic info out of a static view - no new records created or no new records in a new view (which is big Airtable/Zapier limitation). I'd like to grab this information every Sunday at 7pm and create an email in Gmail to go out as a weekly report.Β 

If I try to use Zapier and use the Schedule trigger, the only trigger options are 1) a new record, 2) new record in a view or 3) a search for a record can be done. The first 2 options won't work for what I'm trying to do. I can do a search for a record in Airtable but if I have multiple records that I want to report out the same analytics for, Zapier will only return 1 record.

I'm not as well versed in Integromat but I imagine that it's a much better tool for what I'm trying to do.Β 

Any insights would be much appreciated.Β 
Like Comment

Zapier Formatter - Text Split All to Fields

😎
Hey Makers,

I'm trying to split text to multiple items that I can use in different fields in another step. It works fine for names but not email addresses for some reason.

AndrewJDavison I found your response on the Zapier community forum. I tried this and it worked for names (https://community.zapier.com/ask-the-community-3/line-item-usage-358)

From an Airtable record with a lookup array [Jane Smith, John Smith] returns:
output__Item 1: Jane Smith
output__Item 2: John Smith

which is exactly what what I want it to return

Unfortunately, when I try the same formatting steps for email addresses in an array I get the following output where the item numbers are the same:

output:
0:
Β  Β Item 1: janesmith@email.com
1:
Β  Β Item 1: johnsmith@email.com

The problem is, when I try to use them as inputs later on in the workflow, the only selection I can use from this step is 'Output Item 1: "janesmith@email.com, johnsmith@email.com"' (an array, not separate items).Β 

Any thoughts? I reached out to Zapier support but it seems that they are closed today.
Like Comment

Conditional counts, lookups, and rollups

😎
Airtable is on fire with the new releases. This is has been a big product request -Β 

https://support.airtable.com/hc/en-us/articles/360046636794-Conditional-counts-lookups-and-rollups
Like Comment

Hey everyone, I'm Courtney, co-founder of Rosy based in Washington DC

😎
I co-founded my 2nd company (Rosy) in 2016 after spending a few years in home automation and residential sustainability.Β 

Rosy is a bootstrapped (so far) start-up that is building power tools to make it easier for landlords to manage their rental properties.Β  We've been using several no-code tools for the past few years to prototype out a lot of things that we've gone on to custom build.Β 

I'm excited to finally join the Makerpad community. We're looking forward to some of the more advance tutorials coming out and hope to be able to help others out along the way. Β 

Like Comment