How to apply same action to ALL rows in same column?

[JannikMM]

Hi there,

I’m building a simple shopping list app. One of the columns is called “quantity”. Whenever the shopping list is “cleared” I want to reset all rows back to “zero”. However how can I select all rows or alternatively apply the same action to all rows? The list is long and I don’t want to select one by one.

Thx

Jannik

[Steve]

You’ll need an action (Behavior > Actions) of type Data: execute an action on a set of rows to identify the affected rows and apply another action, of type Data: set the value of a column, to set the quantity to zero in each affected row.

[JannikMM]

Hi Steve,

Thx for your reply. However following your directions I would still need to check rows one by one right? I am looking for a way to check all rows at once (like “Select all”). Sorry if I misunderstood your reply. In case, could you be so kind to help me out with an example. I basically want to reset all rows where value of column “Quantity” is greater than zero. So action 1: Identify all columns where value of column quanity > 0 and action 2: Multiply with 0. Something like that. Is this the right approach and if so, could you kindly help me on how to do this?

br

Jannik

[Steve]

There is no “Select all” option, so the best you can do to automate the process is use actions. Start with this:

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

[JannikMM]

Thx Steve. I saw a youtube demo from may 2018 with the exact same question. Here the appsheet guys said they’d prioritize a select all function. Guess they didn’t get to it…