Solved: Sum a number of row values by bulk actions - Page 2

Pratyay_Rakshit · 03-31-2020 11:40 PM

Can I sum a number of values that I select using a bulk action, and copy the same to another sheet?

I believe that the action type “Execute an action on a set of rows” is needed to be used.

First the original action, the values are copied from the original table and copied to a new table, where the ‘referenced’ action sums the values from the newly rows.

Am I at all on the right track?

Steve

Thanks!

Let’s start with the yellow triangles. A yellow triangle means the column’s value for the row does not match the key column value of a row in the referenced table. For instance, this:

tells us that Halder Traders does not occur in the key column of the User bill submissions table. It’s the AppSheet equivalent to a 404 - Page not found error on the internet.

Similarly:

tells me GST/91/2019-20 and GST/90/2019-20 are not key column values in the User bill submissions table.

Looking at the User bill submissions table column list (thanks for including this!), I see the key column is named Key:

It appears to me you want the user to select a supplier name, then choose one or more bill numbers from the bill numbers for the chosen supplier only, omitting bill numbers for other suppliers. My proposal for this as follows:

Change the type of the Supplier Name column of the Supplier Payment Form table to Ref with the same referenced table. This column doesn’t really need to be an Enum.
Remove the Valid If expression for the Supplier Name column of the Supplier Payment Form table. AppSheet should automatically generate a reasonable dropdown list.
Change the type of the Bill number column of the Supplier Payment Form table to Text, matching the type of the Bill number column in the User bill submissions table.
Remove the Valid If expression for the Bill number column of the Supplier Payment Form table. The AppSheet dependent dropdown feature should automatically generate a reasonably-filtered dropdown of bill numbers once the supplier name is chosen. If not, you can instead use this as the Valid If expression:
```
SELECT(
  User bill submissions[Bill Number],
  ([_THISROW].[Supplier Name] = [Supplier_Name])
)
```
Change the type of the Bill amount column of the Supplier Payment Form table to Price to match the type of the Bill value column of the User bill submissions table.

Replace the existing expression for the Bill amount column of the Supplier Payment Form table with this:

SUM(
  SELECT(
    User bill submissions[Bill Value],
    IN([Bill Number], [_THISROW].[Bill number])
  )
)

Let me know what happens.

View solution in original post