Best practices: can this be done in a field

Topic Labels: Base design Data
1322 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

We are trying to determine if we can use Airtable to help with our perfume formula creations. Right now, we use one spreadsheet for each formula experiment. As we look at how to structure it in Airtable, we have thought that each experiment would be a new table, which would allow us to change and adjust the records for the parts per thousand [Inital Amount] for each ingredient. We are including an image of the table to help illustrate the idea. 

My question is whether this makes sense as a way of working with Airtable. Should each experiment be its own table or can this be done with each experiment being one field? Any insights you may have will be much appreciated. 

1 Reply 1

Loose thread.
Answered here.