I am new to Airtable, and need some help. I have linked a form to a table that may be filled in several times by the same person. Each time, the person has to identify him-herself with their ‘client number’, and then give some information, including a number (the number of products they are willing to buy). I am interested in recording these operations, but I also want another table where the sum of these numbers appear, sorted by client numbers.
How do I make Airtable continuously recognize by itself the ‘client number’, and then add the corresponding value in the client’s “account” (in another table)? And what happens if a client doesn’t write his/her client number correctly?
Thank you a lot!