Change One or More Data Values in Current Table

[Nikita_Derevian]

Something very simple, but can’t seem to get to work. The app is a shopping list.

I only have one table and two rows (other than an row ID number). One is item and the other is status - available or not. Once items are bought, we would like to reset all items at once rather that manually select them.

I have made:

1. action to execute an action on a set of rows
2. action to set the values of some columns in this row

The action (1) to reset the item column does not work. Is this because they are both on the same table?

Thanks

[bonameblisto]

Nikita_Derevianko:

Is this because they are both on the same table?

No
Are you correctly fill “Referenced Rows” value for Action1?

[Nikita_Derevian]

Because I’m looking to reset the whole column, the referenced rows is supposed to be just the [column itself] right? This does not work as Appsheet is saying it needs to be a ‘list’.

I tried select function on this, "select(SheetName[ColumnName],[ColumnName]=“Out of stock”,false). Also doesn’t work.

What am I doing wrong please?

Thanks

[Aurelien]

Hi @Nikita_Derevianko

If you intend to select rows, then you need to select the key_column.
More preferably, you will want to use FILTER expression.
It will be something like this:

SELECT(SheetName[keyColumn],
   [ColumnName]=“Out of stock”
)

Or:

FILTER("SheetName",
   [ColumnName]=“Out of stock”
)

About that:

Nikita_Derevianko:

I’m looking to reset the whole column

you may want to try alternatively:

FILTER("SheetName",
   true
)

or
SheetName[keyColumn]
(not sure about this last one)

For reference:

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Nikita_Derevian]

Great, the first one worked!

Thanks a lot for your comments Andre and Aurelien, I’ve been struggling with this for some time now!