Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 29, 2024 03:38 AM
Hi. I've bumped into an issue when I want to send an automated email based on a field containing an email address. I've got two fields, one lookup that shows me the email address based on a selection from Email-Committee List. Help articles suggest using this formula -->>
Solved! Go to Solution.
Jun 29, 2024 06:52 AM
Hi Marcin,
Looking at your screen capture, It does not look obvious that the problem comes from the value passed for "send mail to".
I think you should try replacing the Gmail action with standard Airtable send mail action to check if the problem realy comes from this value.
Jun 29, 2024 04:52 AM
Hello Marcin,
Why do you use this calculation field?
You could pass the lookup field value as the mail adress in the automation:
Is it because you may have more that one address in your lookup field? If so, you just need to separate addresses with a comma.
Regards,
Pascal
Jun 29, 2024 06:28 AM
Jun 29, 2024 06:52 AM
Hi Marcin,
Looking at your screen capture, It does not look obvious that the problem comes from the value passed for "send mail to".
I think you should try replacing the Gmail action with standard Airtable send mail action to check if the problem realy comes from this value.
Jun 29, 2024 08:13 AM
Hmm, could you try re-testing your trigger step to make sure that your automation's using the latest data and testing it again?
If this issue is occuring when the automation runs this is a different story though. It's difficult to troubleshoot that without seeing how you've set it up, so if you could provide a read-only invite link to a duplicated copy of your base with no data in it I could try to take a look at it for you
Jun 29, 2024 04:24 PM
@TheTimeSavingCo @Pascal_Gallais- Thank you both. I've set the automation to use the airtable email and funnily enough but automations fired. The gmail one is still showing an error on the testing page but it works though.