Hi to all.
I have a fairly simple question.
I need to create an input type action.
Get a number (negative or positive) from the user and add this number to the value stored in the table cell.
That's all.
I tried something like that:
([Amount] + NUMBER(INPUT(value, 0)))
... but it doesn't work.
What is the column name the user is entering their number into? [Amount]?
Where is the value stored in the table? Column/Row How are you retrieving it?
It seems like you have two options:
Using the first option with the virtual column will provide the most immediate results since it won't rely on a bot for calculation. A bot could then run afterwards that updates the [Amount] column to the virtual column total, and then deletes the value in the [Addition] so it can be updated again in the future
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |