Filtering/organising Info from forms

[JWalker]

Hello,

I have created 3 forms connected to the same page (they need to be) and I was wondering if there is anyway to filter them on an Interface to only show those submitted on the same form.

Thanks. 😊

[Sho · Accepted solution]

Hello @JWalker ,

There is a Prefilled form feature.
By adding this feature and a single-select field, you can identify which form was used to fill out the form.
Prefilling a form via encoded URL | Airtable Support

[JWalker]

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?

[abhibavishi · Accepted solution]

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: 

https://airtable.com/shr12345678?source=Form1

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.

[ScottWorld]

You can also just create an automation that is triggered when a form is submitted, and update the appropriate field.

[JWalker]

Thank you for explaining it to me!