Filtering/organising Info from forms

Hi,

Thank you for responding, however, this isn't what I'm looking for as I don't want to refill anything I just want to be able to see which form was used for the event request. We have 3 different versions some they range in how much is required to be filled out/number of questions. Is there any way to organise them in an Interface?

Hey @JWalker,

What @Sho mentioned in their answer is a good solution. You should create a hidden field in your AT form and pass a value to it using preFilled URL, so that you can know which form was used to submit a record.

For example: 

You can create a single-select field in your base called source. 

For Form 1, you add source as a hidden field and prefill it by saying: 

Repeat the same for each form. 

And then in the Interface, you can just apply the filter on each form to filter by the source record.

There is another very easy way to figure out which form was submitted. You can create 3 different automations — one for each form being submitted. Then, have the automation automatically update the newly-created record with the name of the form.

On the topic of prefilling forms:

Many people are prefilling forms in order to update existing records with a form.

Kuovonne created the Prefilled Forms extension for Airtable, which makes it very easy to create a prefill link in Airtable. You can also learn more about prefilling a form in Airtable in this Airtable support article.

However, instead of creating prefilled links, I would recommend using Fillout’s advanced forms for Airtable, because no prefilled links are required if you are trying to update an existing record with a form..

Fillout is 100% free, and it offers hundreds of other advanced features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I do not typically recommend using prefilled links, because Airtable’s prefilled links come with serious downsides that you will want to be aware of:

1. You will have to continually send out updated prefilled links to your users that always contain the newest data. If the user accidentally clicks on an outdated link, they will be taken to old data in the form. So they would never be able to re-use a link or bookmark a link as an “Update My Account Profile” link.
2. Airtable does not allow prefilled fields to be LOCKED, meaning that a user can always override a prefilled field (even if it’s hidden). If you need a prefilled field to be locked & hidden, then you can always use Fillout to hide and lock defaults.
3. Airtable’s prefilled links do not work with all field types… particularly attachment fields or lengthy long text fields that exceed URL limits.
4. If you need the data to remain private or secure, Airtable’s prefilled links reveal all the data within the link. With Fillout’s links, you get one simple, non-changing link per user that doesn’t reveal any data, and you can even add multiple different layers of security to the form if necessary, including SSO login or email login.
5. Airtable’s prefilled links still won’t update old records… they always create new records, and then you will need to write an automation that handles the overwriting of the old data.
6. You lose all the advanced features of Fillout’s forms.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thank you for explaining it to me!