Entering a number and calculating it.

[Yura_Yusko]

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.

[lynchk21]

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?

[Yura_Yusko]

For now, I can only provide a new value.

I would like that instead of entering a new value.

The quantity was changed by the given value.

For example, there were 87, we submit 22 and get 109 as a result.

Because now you have to count it yourself and immediately enter 109.

The value that was entered does not need to be saved at the moment.

[lynchk21]

It seems like you have two options:

1. Make a separate column for your addition (lets say [Addition]) and then either run a bot or have a virtual column that calculates the two columns together
2. Make a bot that run anytime you make an edit to the [Amount] column. After to submitted the new value, the bot would need to calculate [_THISROW_BEFORE].[Amount]+[_THISROW_AFTER].[Amount] and then update the column to match. 

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