Skip to main content

need help figuring out how to create a usable database


I am making a database that people fill out using the form it then populates a table however i would like another table to take that information and sort by item and tally the # of items


right now lets say 10 people say they are making x # of joey pouches and they entered a form for each person then the table for that form shows 10 rows each making a different # of joey pouches

I need a table that say Joey pouches and x # in total

how would i set it up ? for some reason it’s escaping me lol I know how to do that in ms access but not in airtable


thanks for any help 🙂

[Table 2] will have a {Product Name} field, a {Form Responses} field, and a {Count} field.


{Form Responses} will be a Link to Another Record field type which connects to [Table 1]. When people fill out your form, they’ll be selecting from rows in eTable 2], one of which would say “joey pouches”.


{Count} will be a Rollup type field which will sum up the quantity field from

.

Welcome Tracy! Seems like you’re in good hands with Kamille :grinning_face_with_big_eyes:

Terms & Conditions