LinkedIn
Twitter
Does the INPUT function not work in use cases where we want to ADD new rows?
EDITED: Realized there is confusion. By "ADD action" I am referring to the type "add a row to another table using values from this row" - NOT the ADD button action.
I have a use case, where I want to pre-assign certain rows to a Used Items child table. These rows are identified from an Items table based on a type column in the Parent row. When an initial Save is performed on the Parent, the list of Items are identified by the type and then a row is to be added to the Used Items table for each of these identified Items. To do this, I need to carry over the Parent ID to assign to each of the Used Items rows.
It appears however, that I cannot pass arguments using the INPUT() function to an ADD action of type "add a row to another table using values from this row". The parameters will not even show up. Is this true? We can only pass arguments to "update" type actions? Or am I missing something?
I am aware of other ways to achieve my goal but using the INPUT() function is the most efficient and elegant. I am surprised, if the use case above is not supported.
EDITED: Adding Images of configured Actions
ADD action ("add a row to another table using values from this row") with implemented INPUT() function
After saving, no "Add" area is provide in the calling action to set the "tx" parameter with an argument.
FYI, I am using an old work around. I added a "Variables" table that I can temporarily INSERT a variable data row. Then look up the "value" from that Variables row to assign in the ADD action (instead of using the INPUT() function) and then lastly delete the variable row. It is user based so each user gets their own data row should they be performing the same process at the same time in the app. It works well just not as efficient or elegant as the INPUT() function could be.
Create an action
Formula (insert the field from your table)
Input(Nome, [Nome1])
A pop up appears for you to enter the field value
