I have a table called table2 which is filled in with a form, and I don’t want the users to have to fill in all their user information every time they use the form. So, I enabled ‘see who submitted response’ and created an automation which on form submission attempts to match the submitter’s email to an email in the user’s table, which is then copied into a linked email field in table2. This allowed me to filter the list of entries via the form so users only see their own entries. However, other linked fields in table 2 do not autopopulate.
I was hoping when the automation filled in the email address in the linked field of table 2, all the other linked fields would populate. Any suggestions on how to accomplish this?