Hello community! I may be in over my head but so far I love the way Airtable organizes things but can’t get it to work for me yet. I am a producer and have an ecommerce website and sell about a dozen items online using Webflow. I am trying to set up a base to help me track my sales and inventory and because some of my products come in different sizes and colors and I am having a real hard time extracting the pertinent information from my imported orders CSV file and organizing it so that I can use it. Here is a screenshot of my imported table, maybe I just need the right formula? Thanks in advance.
At first glance, I would use multi select field for your option field, that is if the options will be the same, but different selection for each customer. You might also want to remove the quotation marks from each of the options, since it might interfere with other field options i.e. Formulas. Also, would you be able to just use 200ml, without the word “size”? It can make the data cleaner. Just thought I would ask.
Hope these suggestions will help, as you begin your journey into Airtable.