Here is my situation. I have 2 tables.
Populates based on information submitted by the client. Fields include: name, email, subdivisions they live in, a description of a problem and an empty field with the name of the ambassador of that subdivision.
Has information about the ambassadors responsible for client of certain subdivisions.
Fields include: name email and an array of subdivisions they are responsible for.
I want to autopopulate the Ambassador field in Table A with the name of the ambassador responsible with that subdivision.
The program would need to look at the subdivision name in table A, then check which ambassador has that subdivision in table B and then fill the empty field in table A with the name of the appropriate ambassador.
I am hoping a IF (Find) would work but I can’t think of how to look into other tables
I tried by automating update record. I was trying to update a record if a record was created and add the name of the appropriate ambassadors but I can only choose 1 table at a time and does not seem to work
Ultimately I would like to airtable to send an email to the ambassador with the information of the client and the description of the problem the client is facing.
Thanks so much!