Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Employee Records with Multiple Entries

Topic Labels: Base design
473 2
cancel
Showing results for 
Search instead for 
Did you mean: 

In our airtable we have an employee tab and each employee can have multiple state licenses or memberships they belong to. Someone set up our employees to as duplicates for each state but the employee should be just one entry and the multiple licenses under that one entry. Can someone give some advice on the best way to accomplish this? Should it be a data entry field for each license? See attached.

2 Replies 2

Hi @Lindsay_Hier,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

Since you are a new member, there is no attachment to your post.

Your question depends on your requirements. What do you want to do with this data afterwards? You can put all the licenses in one Multi Select field if you want. That would be easy to do.

BR,
Mo

You could make the Licenses field a multi-select field and list the licenses as options. You then only need one employee in the table and can select the licenses they have in the Licenses field.

Is that what you’re trying to do?

Alternatively, you can create a Table with different types of Licenses. Link to that table from the Employees Licenses field, and then you can select the appropriate licenses per employee.