Hello, I'm trying to use airtable to email callers templated information about products.
I have a grid view where I can enter an caller's email, select from product list (a, b, c), then use the Button feature to trigger a SendGrid email that contains information about the selected product that is retrieved from a lookup table (a - info text, b-info text, and so on).
This all works very smoothly except I would like to create a Form to enable staff to use this process without having to interact with the grid view.
So I would like to somehow automate the pressing of the "Send email with SendGrid" button once the Form is submitted/record created. Is there a way to do this?
Thanks for any ideas you have.