Hello, I would like to be able to view various locations daily performance reports.
Is it possible to have several different forms within one table and then create a view or report for each of the locations? I was thinking to create forms that can be completed for each location and then be able to view a report based on location or other criteria in the future.
Best answer by Justin_Barrett
Alternately, you could do what @ScottWorld originally suggested—have the user select their location—and then use Airtable’s relatively new conditional options in the form design to only show those fields relevant to each location.
+352025 Update:
Yes, but assuming that all of your locations are submitting the same types of data, you would just need to create ONE form, and let the users choose their location at the top of the form.
Your location field would be a single-select field on your table, and your users would just choose a location from the list of locations.
Then you can have other fields conditionally appear and disappear based on the selection made.
Also, for a more powerful way of doing this, you would want to use Fillout’s advanced forms for Airtable.
Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to conditionally show and hide fields, update Airtable records using a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
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
The data for each location may be slightly different. Some information for each location will not be necessary for others.
Is it possible to create different forms for this reason within the same table?
If you have a suggestion that may meet this use case’s need, I am open to suggestions.
Thank you.
+35The data for each location may be slightly different. Some information for each location will not be necessary for others.
Is it possible to create different forms for this reason within the same table?
If you have a suggestion that may meet this use case’s need, I am open to suggestions.
Thank you.
Absolutely… just create as many different forms as you’d like, each with different fields on it!
But your best bet would probably be to use Fillout. See my post above for more info on this.
- ScottWorld, Expert Airtable Consultant
+21Alternately, you could do what @ScottWorld originally suggested—have the user select their location—and then use Airtable’s relatively new conditional options in the form design to only show those fields relevant to each location.
+35Alternately, you could do what @ScottWorld originally suggested—have the user select their location—and then use Airtable’s relatively new conditional options in the form design to only show those fields relevant to each location.
Ooh, that’s a fantastic idea from @Justin_Barrett that I didn’t even think about!
@Aline_Vida: Note that this new “conditional” logic only applies to forms, and it only applies to showing/hiding fields. So, for example, you couldn’t conditionally narrow down the choices in a single-select field based on the selection in another field. But, even given these restrictions, it sounds like it would still fit all of your criteria for a unified all-in-one form!
+35Thank you both for your time!
You’re welcome! :slightly_smiling_face: If you wouldn’t mind, could you please mark one of the comments above as the solution to your problem? That will help other people in the future who have a similar question. :slightly_smiling_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.