I keep getting closer to remembering the difference between a spreadsheet and AirTable, but I have a Base design that is just eluding me.
Initially I have a 2 table Base that need to be linked.
Table 1 has a list of people in my organization along with critical information. The primary field will obviously be the members name (we are small enough that I am not concerned with duplicates, or can handle them if necessary).
Table 2 will be continuously built through form input by the organization members. Primary field will be a date/time stamp as that is really the only unique identifier on this Table.
I want to link the two tables through the name field, but I am not sure the best way to do it, particularly since there may be some mismatch between the name in Table 1, and the name entered on the form for Table 2.
I was originally considering having people entering First Name and Last Name, and then using concatenate to join them, but I couldn’t find a way to have a field be both a linked field and a formula field, so I think I will just go with having the whole name entered.
Is there a way to design the Base such that I can somehow link the tables by either:
- There is an exact name match
- There is a close name match, and is there a way to determine that and make the link to Table 1
- Undetermined match that I can hand adjust later (although I hope this will be minimal.
Any advice appreciated!