I have been using appsheet for a few months, mainly dabbling and I have been able to figure out most everything with this forum but I am having trouble with something and I was hoping someone could help me out. I have read a lot of different options on the forum but haven't been able to find the best way to do this successfully.
My app is for tracking events (workshops and lectures) as well as event sponsorship details. I am trying to find the best and most effective way to automatically contact around 10 individual companies I work with to request if they will sponsor an event. I need to keep the emails personalized and separate and include information related to both the event as well as the sponsors contact detail. Here is my table structure
1) Events Table: This table has all the event details (date, location, etc)
2) Sponsors Contact Table: This is a list of different sponsors I work with and their contact details (name, email, company).
3) Event Sponsorship: This table is intended to have rows with details regarding the sponsorship status for a particular event. Each row is for one sponsor and has a reference column to the Event Table.
First thing I need help with is to automatically add rows to the Event Sponsorship table so that each sponsor has 1 row PER event to so that the status of the sponsor can be seen as a reference when looking at an event detail.
My next goal, is to work on automatically sending emails to each sponsor one time per event. I can trigger it with a yes/no column or an action. The email needs to be able to have details from the Sponsors contact table first name, company as well as details from the event (such as location, date, title, etc). I know I can make 10 individual emails and customize them but I am trying to make it more scalable so that that won't be necessary.
Any help would be appreciated.
LinkedIn
Twitter
