i need some help to understand if its possible to do it like I want
I have a database in excel that I want to upload to airtable and use to fetch data for users and trigger automation when a user asks for it.
- user that wants to get data will go to the form page
- user will log in using 2 fields from the table that will need to go to a table and validate it’s true.
- if the true user will be asked for his mail. (if it’s false he will ask to add the correct values again.)
- when adding his email he will get thank you message and now 2 things will happen:
a. one email with several fields from the table will be sent right away to the admin of the system to notify him about this user request.
b. after 1-hour the user will get the email with his requested data.
I will love to know if it’s possible and what is the best way to do it