Hi there, I’m new to the community so apologies in advance if this is posted in the wrong area.
What I’m attempting to do is use the Automations function (next to blocks) to send an email when a new record enters an Airtable view:
Trigger: When a record enters a view.
Action: send an email.
For the email address, I’m asking Airtable to lookup the email address from a linked record ValuesBy LinkedRecordId.
When I select this, I receive the following error in red: ValuesByLinkedRecordId cannot be converted to a string
When the action is changed to send a slack notification, that same email field shows a preview and appears in the body of the notification.
I’ve tried changing the email field to short text, adding quote marks and commas, all unsuccessful.
As a new user, I can’t attach screenshots to this topic. Hope this is enough info.