HELP! I have a base with a table where I have collected submissions for an upcoming conference. There are fields for Speaker 1 Name, Speaker 1 Email, Speaker 2 Name, Speaker 2 Email, etc. I am trying to pull all the data from every record to another "Speaker Management" table. So I need all the Speaker Name fields (Speaker 1 Name, Speaker 2 Name, etc) to go to a singular field (Speaker Name) in this "Speaker Management" table along with the corresponding email contact for the record.
The records are already there, but may update because I am using FillOut for people to update their submission content.
I appreciate any thoughts!