Help

Help with automation: Find record and update value by adding to a number field

Topic Labels: Automations
1701 1
cancel
Showing results for 
Search instead for 
Did you mean: 
qoob
5 - Automation Enthusiast
5 - Automation Enthusiast

I have two tables - one with orders and one with inventory. The workflow I want is that once the order is ticked as received, it would automatically either
a) find the existing item and update the stock level or
b) create a new item if the item is new and there is no existing item.

I'm focusing on a) now, since it's more complex. I was able to use Find records to find a unique match from the inventory table. Then I created a conditional action, that checks whether the amount of inventory items is exactly one.

The action is configured to run and match the record ID of the inventory item found in the previous step. For that record there exists a number field called "Current inventory" that has the value 500. In the order table there is a number field called "Processing amount", which has the value 17.

I'm able to update the Current inventory field with the value 500 -> 17, but what I want to do is add these together to get 517. What syntax should I use in the fields? I've tried

Current inventory + Processing amount -> doesn't work

SUM(Current invetory, Processing amount) -> doesn't work

qoob_0-1675409802624.png

 

Thanks!

1 Reply 1

I don't think you can do math within the automation fields like that actually.  You'd need to create a formula field that at would help you calculate the number you need, and the automation would use that formula field's value to update the record

If possible, I would recommend that you use a "Stock Movement" like table instead, and use a rollup with `SUM(values)` which should get you what you're looking for

Screenshot 2023-02-03 at 3.58.21 PM.png

Screenshot 2023-02-03 at 3.58.17 PM.png

Link to base