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.