Need to make 2 tables and help on how to make 2nd to do what i need

Forum|Forum|5 years ago
January 11, 2020
2 replies
15 views

Tracy_H
New Participant

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:

+27

Kamille_Parks11
Brainy
Forum|Forum|5 years ago
January 12, 2020

[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].