Updating Linked Records from another Table

[NitaiLS]

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

[ScottWorld]

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.