Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 28, 2021 07:24 PM
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:
Any advice appreciated!
Solved! Go to Solution.
Feb 28, 2021 10:59 PM
Airtable doesn’t do automatic linking of records based on values in text/date/formula/number fields. All linking is done manually through linked record fields only.
So, on your form, you could add a linked record field and have people choose their name from the list in the linked record field.
That would be the easiest way to do it.
(You also don’t need to worry about duplicate names — Airtable can distinguish between 2 records with the same name.)
Feb 28, 2021 10:59 PM
Airtable doesn’t do automatic linking of records based on values in text/date/formula/number fields. All linking is done manually through linked record fields only.
So, on your form, you could add a linked record field and have people choose their name from the list in the linked record field.
That would be the easiest way to do it.
(You also don’t need to worry about duplicate names — Airtable can distinguish between 2 records with the same name.)
Mar 01, 2021 06:02 AM
I wondered about that. Not my first preference, but I guess people are used to it by now.
Let me try it, and if I can get it to work, I will come close this topic.
Thanks!
Mar 01, 2021 10:50 AM
Ok, I created it. There is actually a very nice (unplanned) feature that came with this. It is quite likely that the event being reported in the form will involve multiple people, and now all involved can be entered on one (or two) forms!
Thanks!
Mar 01, 2021 10:50 AM
(just an aside) Oh, that’s great if Airtable can distinguish between identical names. I don’t think my people can!
Mar 01, 2021 11:05 AM
Fantastic! Glad to hear that this will work out nicely for you! :slightly_smiling_face: