set the values of some columns in this row

AppSheet AppSheet Q&A
, , , ,
1

Hi,

I am using this action: set the values of some columns in this row

► Should I set any condition with this action like [_THISROW] condition or this action works on exact row without any previous settings.

► In the advance section of the above action I can see this:

Inputs… List of inputs that can be used in this action

What is use of this? Do you have resources or what is the best way to use this concept?

► If I have two tables orders and items

Item table has a ref column to order table.

now can put the above action on the item table that will be triggered only when the id of the row in item table is = the id of the row in order table.

Thanks indeed

1 Like
2

When you use the action “Set the values of some columns in this row” in AppSheet, it directly modifies the current row without needing extra conditions like [_THISROW], unless you specify them. To make this action conditional, set a condition in the Behavior > Only if this condition is true field, such as [Status] = “Pending”, to run the action only when the Status column has “Pending”.

In the advanced section, the Inputs field allows defining dynamic values or expressions for use in the action. This is useful for computing or fetching values dynamically based on the current row context.

1 Like
3

@mohssin365 Thanks very much

1 Like