Pre-Load Form Option to Multi-Select People and then Automate Email

[Aaron_Reynolds_]

Not sure how to search for this so if it is out there already please point me in the direction…

I am wanting to use a synced database that gets updated with a list of People’s Names and their email information (I can figure this out). I then want to have an option on our form that allows the person submitting to choose in the list multiple people that is populated from the synced database that is updated with current names and emails.

I then want to create an automated Submitted email that would go to everyone who was selected on the form to receive the communication it was submitted. And then one more automation once the Status is changed to Completed that goes again to the same people that were selected to receive the communication.

Is this possible?

[Aaron_Reynolds_]

Even if I can start with getting a drop down to populate based on a Column from another table. Is this possible?

[Hannah_Wiginton]

Hey there @Aaron_Reynolds_BHS,

This is possible with On2Air Forms. It allows you to customize your drop-down to specific filters. You can also prefill the form with data and create URLs that are specific to whoever is completing the form.

On2Air | Accomplish Anything with Airtable – 3 Jun 20

On2Air: Forms | On2Air

On2Air: Forms allows you to create and configure advanced forms using your Airtable data completely integrated with the powerful features of third-party form builders. Enhance your Airtable forms with more options, such as prefilled data, custom...

Here’s an example

On2Air | Accomplish Anything with Airtable – 25 Oct 20

How to Display Filtered Records and Record Info in Airtable Forms | On2Air

If you’re using forms in Airtable, there are many times you probably want to filter the records shown in your form fields and also display images or other data. In this post, we’ll cover how you can filter your forms to show users specific info and...

[Aaron_Reynolds_]

I’ll check that out, thanks!