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?
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.
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |