Hi, I’m new to MAKE.com and thought I could figure out an automation for my client but it is taking way longer than expected without experience/training. Hoping to get help with this scenario quickly then get back to training.
I want to automate amazon sales orders into an airtable inventory database but need to do some aggregating by day/product and sum quantity and prices before adding the record. I have started my scenario but am having trouble with some of the calculations. Not sure what I have is the most efficient workflow so if there is something that uses fewer operations I’m open to that as well. Here is where I’m at…
This is a small dataset - 6 rows (bundles) of data that I made into 2 bundles (one for each day/product combination in the dataset). Now I want to sum quantity and price - discounts which is where I’m getting stuck… HELP!