Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How can I filter my records via the form that generated them

Topic Labels: Formulas
Solved
Jump to Solution
452 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all!

I have a couple of survey forms in one table - one is for user group X, the other is for a different user group Y. Questions are similar, so I want responses in the same table but want to be able to filter view the records by each user group (eg by form that was used to generate the record).

I thought that generating record IDs would indicate the source of which form (and therefore which user group) created the record, but it seems to be random. Is another way I can extract and filter which form generated which record?

Thanks!!

1 Solution

Accepted Solutions

Welcome to the community, @Lauren_Lundholm!

Sadly, Airtable doesn’t offer this capability.

You could do it with JotForm, which offers native Airtable integration (and offers so much more flexibility than what Airtable offers).

Alternatively, if you wanted to do it natively in Airtable, you would need to create additional fields in your table that are “temporary fields” that only exist on certain forms. You would need to make those fields REQUIRED on your forms, so that when somebody submits a form, the VERY PRESENCE of information in that temporary field lets you know which form was submitted.

This temporary field could be as simple as a checkbox that says: “Check this box before submitting the form.” Or, it could even be a field where you collect real information in it — and then you could create some automations in Airtable to move the real information from the “temporary field” into the “permanent field” where that information needs to live.

It’s a big hassle all the way around, and I would highly recommend sending an email to support@airtable.com to request that they please improve their forms in the way that you asked about. So many people are in need of this.

See Solution in Thread

3 Replies 3

Welcome to the community, @Lauren_Lundholm!

Sadly, Airtable doesn’t offer this capability.

You could do it with JotForm, which offers native Airtable integration (and offers so much more flexibility than what Airtable offers).

Alternatively, if you wanted to do it natively in Airtable, you would need to create additional fields in your table that are “temporary fields” that only exist on certain forms. You would need to make those fields REQUIRED on your forms, so that when somebody submits a form, the VERY PRESENCE of information in that temporary field lets you know which form was submitted.

This temporary field could be as simple as a checkbox that says: “Check this box before submitting the form.” Or, it could even be a field where you collect real information in it — and then you could create some automations in Airtable to move the real information from the “temporary field” into the “permanent field” where that information needs to live.

It’s a big hassle all the way around, and I would highly recommend sending an email to support@airtable.com to request that they please improve their forms in the way that you asked about. So many people are in need of this.

Hi Scott! Thanks so much for your quick reply, it feels really good to know it’s not just me - really thought it would be a simple feature to add in, but it’s been puzzling me for a couple of weeks now! :grinning_face_with_sweat:

Fixed it as you suggested, with a hidden checkbox present on one of the forms. Seems to work for now. Will pass on the recommendation to air-table.

Thanks for making my first airtable community posting experience so positive :star2:

Hi @Lauren_Lundholm,

You’re welcome! :grinning_face_with_big_eyes:

Oh, just to clarify, your checkbox can’t be hidden on the form itself. That’s another major flaw in Airtable’s forms — any hidden fields don’t get their values submitted to Airtable. :sleepy: :slightly_frowning_face: Please add that into your email to Airtable as well! :slightly_smiling_face: