Apr 05, 2018 02:49 PM
I am new to Airtable.
I have come over from FileMaker Pro.
I would like to know if there is a feature or app that can use a record as the basis for email: i.e. populate the to field and use the project name as the subject.
I do not want to send the record itself I just want to use it in this way.
Apr 05, 2018 11:03 PM
Something like this?
Apr 06, 2018 01:37 AM
Not really.
Thats what I don’t want: what I wasn’t is to populate an email with the data from a record in air table.
Apr 06, 2018 01:49 AM
You can use the fields that you want to populate the part of the email that you want. Seems to be what you want :thinking:
Apr 06, 2018 01:50 AM
Have you read this part?
You can also use variables in other parts of the email template. In constructing the email’s subject line, for example, you can have it say the name of the new deal record that was just created by using the Name variable.
Apr 06, 2018 02:06 AM
Hmmm.
That involves a new record though - so the record would have to be the message.
:thinking:
Might work…thanks very much for the input
Apr 06, 2018 03:08 AM
Hi Robert
Instead of Zapier, you could use Integromat and have it query the table periodically ( the maximum frequency depends on your account but it could be every minute). When it finds a record with a certain flag set (probably a single select field) it could then send the email and a final step would be to update the flag field to indicate the message is sent and avoid sending again.
With Integromat you could also, quite easily, have the same scenario send different messages based upon the value in a field (which could be the flag field) because it has branching logic capabilities.
Hope this helps - you can see more about Integromat here
Apr 09, 2018 10:39 PM
Sounds good! :slightly_smiling_face:
Apr 11, 2018 01:36 PM
This looks very interesting. Thanks for the share.
Jun 19, 2018 11:04 PM
@Robert_Sheldon
They just released this feature to send emails using sendgrid
https://support.airtable.com/hc/en-us/articles/360005572493-SendGrid-block