Solved: Add all rows of this table with status column = xx... - Page 2

MAAK · 09-07-2022 07:05 AM

Hi. I'm trying to send all rows of an 'order' whos status is 'xxx', to the 'invoice' table with a single action. I can get this to function with selecting each row then performing an action but I want it to work with a single click. I don't want to have to select rows in a table view individually when there is data that can select the rows.

Aurelien

my filter is
FILTER("Order Line item", OR([Status]="Invoice", [Status]="Back Order", [Status]="Sample"))
So it only put rows with the status "invoice" into the invoice table yet i want any of those 3 status's to go.

Are you sure about the syntax of "Back Order" and "Sample" in your table ? If you try the "test" feature of the expression fied, do you get the expected result ?

Also it put rows applicable to all customers rather than just for the customer whos page the button is on. I tried to filter for THIS customer but dont know how to combine it all into one expression

What about this:

FILTER("Order Line item", 
  AND(
      [_THISROW].[customer]=[customer], 
      OR(
         [Status]="Invoice", 
         [Status]="Back Order", 
         [Status]="Sample"
      )
   )
)

where:
[_THISROW].[customer] is the customer from the table in which the FILTER() expression is evaluated
=[customer] is the customer from the table "Order Line item"

For reference:

FILTER() - AppSheet Help

View solution in original post

Add all rows of this table with status column = xxx, to another table, with a single action