Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Script to adjust a column value in one view based on another

Topic Labels: Scripting extentions
181 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I use Airtable to manage product production. I have one view that is for my product records, “MFG”, and there are several categories for each record in that view. I have another view for “Ingredients”, and at present I have to manually adjust the amount of the ingredient every time I produce something in order to maintain an accurate inventory level.

Is there a way for me to trigger a recalculation of that ingredient amount when I move the record in the “MFG” view into a category created to initiate that trigger?

Does this make any sense at all? I want to be able to, when I produced a batch of something, have all ingredients used in that batch automatically deducted from the record in the “Ingredients” view. In the “MFG” view, each ingredient has its own column, and each of those columns has its own record in the “Ingredients” view.

If anyone can point me toward learning resources or help in any way, I’d really appreciate it. Maybe this is an impossible task?

0 Replies 0