Hi, I’m new to airtable and struggling to get the automations to work how I want. It worked for me yesterday so I know it can do it but failed today and I’m not sure what changed.
I’ve got a grid that collects data from forms that are submitted from people. I’ve also got another grid that already has a list of all the people the form is sent to. After they submit the form the data appears on the grid the form was made for, however I also want it to update the other grid with their answers (so I can see who hasn’t submitted the form and have a record of each day). I need it to recognize who is submitting the form from their name and find them on the other grid then add their answers to that grid in the correct columns.