Action on a set of rows:

0 9 292
9 REPLIES 9

Iโ€™m not sure what the problem is. You should have an expression in the โ€œReferenced Rowsโ€ part of the action that produces a list of all of the keys of the rows that need to be acted upon. When you test that, to you get a list of the correct keys?

My problem is that i have only one row filled up instead of the 30 row with the same key.

The same key? Each record should have a unique key.

bellow the lnk to the app:

Thanks @Christophe_Schneider! I wasnโ€™t able to open the app. Iโ€™m not sure why.

Was I right about the keys? Does each record in your table have a unique key?

2X_f_f3da65285602cde73d77a6c43f92b68595e6c63b.png
2X_6_6a66cd20ef548e59b348e6f732ef62b0e834c24d.png
2X_6_6497e6d98cc46926881331d105695fe56bb3c384.png
2X_4_483628f5691f6200376473bd559411460a41c8f1.png

To find out if the keys are unique, you would need to look inside the key column in the spreadsheet.

@Kirk_Masden is correct. The Key column must have unique values in order to uniquely identify each row.

In your โ€œsuivi ficheโ€ table the column โ€œReference ficheโ€ is set as the Key. But in your original screenshot that column does NOT have unique values. If you need this column value as it is in order to โ€œtieโ€ the different rows together, then instead use the โ€œ_RowNumberโ€ as the Key - for now.

I would then strongly recommend adding a new column and using it as the Key. AppSheet does provide a function for this if you are entering data through the app. There are other ways as well. Just ask when you are ready to tackle it.

Top Labels in this Space