I am new to airtable and would like to have some assistance from this community.
I will try to explain what I want to build and hope that you can help me with some guidance how to do this.
I want to create a database of let’s say 100 customers. Each customer has a couple of parameters that can change each year. For example: Total number of employees = 10, etc…
Now I would like that on 2 different moments of each year these customers receive an template e-mail where we ask to fill in the potential changes of these parameters. If they complete this proces, the new data has to be send to the database and be filled into a new e-mail template that automaticle will be send to an e-mailadres that is also listed in the database in the record of this costumer.
In a perfect world I would like to gather the new data via VideoAsk by Typeform.
I hope this is a clear example.
Please feel free to ask further questions or give more advice then asked for.
Thank you in advance.
Hope you guys can help this amateur.