Help

Help for a new base

Topic Labels: Base design
Solved
Jump to Solution
1430 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Claudio_Chiappi
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone, I am quite new to the Airtable world and for this I ask you for help.
I have 1 base with 1 Employees table (with all the personal data) and 1 table with the relative data
refresher courses and related expiration dates, type of certification, etc.
(each employee can participate in many courses)
What is the correct setting of the 2 tables like the definition of the primary fields?
Thanks 1000

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

This is subjective and depends on the type of data you’re storing. I generally recommend using whichever field yields the most unique or descriptive values as the primary field. For Employees that is probably their full name, email address, or employee ID, or perhaps a formula that concatenates any of those fields together

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

This is subjective and depends on the type of data you’re storing. I generally recommend using whichever field yields the most unique or descriptive values as the primary field. For Employees that is probably their full name, email address, or employee ID, or perhaps a formula that concatenates any of those fields together

Great recommendation @Kamille_Parks! I like how simple and effective it is. In the past, I’ve leaned more towards using a formula for the primary field and just reading attributes from the rest of the record. It can be complicated or just complex. Its always good to keep the less is more mentality.
Chris