Retrieve the value of a field from the same record in a new row process (BOT)

Hi everyone, I created a bot that every time I add a record in table A it adds 5 records in table B like this:
The activator of the bot is precisely the event configured as follows:
Data change -> Adds only -> Table A

In the process below I selected the item "Run a data action" and then "Adds new rows" in table B with the following values:

ID (type text) = UNIQUEID()
DATE (date type) = TODAY()
CMT (percentage type) = "100%"
KG (type number) = [a column of table A]
RIP (type number) = 1
TON (type number) = b[KG] * b[RIP] ---> here I get the error: "Arithmetic expression '(b[KG] * b[RIP])' has inputs of an invalid type 'Unknown' .
N.B. "b" is the table that I called that for simplicity.

I can't understand why and yet they are the same type, I tried to cast using NUMBER() function but I always get 0 ( NUMBER(b[KG]) * NUMBER(b[RIP]) ) if I try to insert as expression only b[KG] the error becomes this "The expression is valid but its result type 'List' is not one of the expected types: Number"

I would like TON to be equal to the product of the value entered in KG by the value entered in RIP in the same entry so that it is calculated row by row dynamically.

What am I doing wrong? Is there someone who can help me?

Thank you

0 4 140
4 REPLIES 4
Top Labels in this Space