- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 24, 2025 07:54 AM
Hi,
I am a complete beginner with Airtable. I am managing a pool of freelance artist and thouhgt that Airtable could be very useful. I would like to have a form for new artist to submit their skills and skill level for each skill, which then automatically populates in my Artist' list. I know how to create a form and collect various basic information, including skills. But, I don't know how I can let artist choose a skill level for each skill they have. Lets say the artist choose "Photohop, and Premiere". I would like for them to be able to choose their proficiency for each software or skill.
I could simply create 3 versions of each skill and assign Expert, Mid, and Beginner. but that doesn't sound efficient, and I thought Airtable is about efficiency.
So if you look at my screenshot, what I would think I would need, is a non-static field (look-up) that assigns a value inside the Artists card .
Is this doable?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2025 04:04 AM
Hey @vivilama!
According to best practices, this should be handled in the following way:
1. One table for Artists
2. One table for Skill Levels
2. One table for Skills (could also be a single select under Skill Levels)
Skill Levels table should have at least three fields (other than the primary field):
1. Artist (linked record field to Artists table)
2. Skill (linked record field to the Skills table)
3. Skill Level (number, single select, rating, or similar)
The idea with the above architecture, is that for each Artist you'll have one or multiple records created on the Skill Levels table.
E.g.
Mike | Skill A | 10
Mike | Skill B | 5
Mike | Skill C | 7
This is great and probably the way to go for you in terms of database architecture. However, you will hit a limitation when trying to get such info via form. Reason: Airtable native forms do not allow for submissions pushing information to multiple tables. Please check and upvote the feature request here!
However, you can currently bypass such limitation if you use Fillout -form provider. Fillout's free plan is super generous, have direct integration with Airtable, and will allow you to push data into multiple tables (with their Parent/Child form structure for handling linked records creation)
If you'd like to dig deeper into it, and get some further insights, feel free to grab a slot on my calendar using this link! I'd be happy to help out.
Mike, Consultant @ Automatic Nation
