Jan 11, 2020 10:17 AM
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 :slightly_smiling_face:
Jan 12, 2020 10:16 AM
[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 [Table 2]
, one of which would say “joey pouches”.
{Count}
will be a Rollup type field which will sum up the quantity field from [Table 1]
.
Jan 12, 2020 11:54 AM
Welcome Tracy! Seems like you’re in good hands with Kamille :grinning_face_with_big_eyes: