Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

creating a link to form with prefill from another table

Topic Labels: Automations Data Formulas
579 1
cancel
Showing results for 
Search instead for 
Did you mean: 
NitaiLS
6 - Interface Innovator
6 - Interface Innovator

Hi,

I have two tables I work with:

1. table of employees,

2. Table of events

3. table of enrollment to each event.

I want people to enroll to events each time an event is created.

I created an enrollment form in the enrollment table to insert the data there. I created a formula in the employee table that an automation sends a mail with a link to the form for each of them.

However, I need the formula to prefill the event name and type to this form, and so there are two prefills to be made on the same formula from two different tables:

1 employee table - the name of the employee and, more importantly, their email

2. event table: Event name and type.

Reminding the location of the formula is in the employee table

Any Idea how I can insert the event name and type into the formula?

Nitai

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

I would check out @kuovonne’s Prefilled Forms extension for Airtable, which guides you through the creation of your prefilled links.

Also, you may want to explore Fillout’s advanced forms for Airtable, which let you create Airtable records or update existing Airtable records via a form — with or without prefilling.