How to do First-In-First-Out?

Topic Labels: Scripting extentions
1157 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

So I have a situation where I simply want to calculate cost-of-goods sold. Allocation is done based on FIFO, however I could only find one reference to a script here:

Does anyone have a working script? Or is there a non-script way to do this that I’m just not getting it (admittedly I’m new to Airtable). I’m surprised this is not an extremely common problem–I don’t see much in the forums or other websites.

Any help would be appreciated :). Many thanks :pray:

1 Reply 1
4 - Data Explorer
4 - Data Explorer


I’m new to Airtable myself. Just wanted to check in and ask if you’ve gotten FIFO to work in Airtable? Looking for similar solution.