Hi - new here - this is probably an easy question. I did search the forums but perhaps not using the correct terminology.
I am trying to create an aggregate view summarizing data from a form people are filling out on a website.
They are selecting from a dropdown indicating their geographical location - there are 40 or so selections to choose from.
I then want to count all the people that choose a particular region and display that data
People who chose A = 23
People who chose B= 16
and so on…
I am close…I have created a linked table based on the selection - problem is that the drop down field can only be a dropdown field (field A) - I cannot also link that field to the new table displaying the aggregate data.
So my solution was to make a new field (field B) in the initial table and link that - it works, but only if I manually copy the value from field A to field B.
So my question is - when someone fills out the form online, how to I make the Table automatically copy the entry from field A to field B to summarize the data.
Please and thanks!