I’m sure this is very easy, but I’m struggling to figure this out.
Table A and Table B both have the same exact “full name” (i.e. first and last name) listed for contacts. Each table, however, features different information for the respective contacts. The outside database from which I’m manually importing this data via CSV doesn’t combine all of this information into a single table; hence, what I’m endeavoring to accomplish inside of Coda!
If I create a relation field between the two tables using the “full name” columns from each, then how can I tell the two tables via a formula to automatically line up the data using the identical “full name” relation columns from each table?
Thank you for the help, and take care.