Select IDs based on another column unique

[rvje]

Hello all,

for a unique list of tags {AHU-1A, AHU-1B, AHU-1C, AHU-1D, AHU-1E, AHU-1F, AHU-2A, AHU-2B} I want the list of IDs, it can be any ID.

For example if the ID is the row number the list will be: {1, 4, 5 ,6 ,7 ,9, 10, 11}

Is it posible?

[Suvrutt_Gurjar]

---

@rvje wrote:

I want the list of IDs, it can be any ID.

---

Are you looking for table keys?

What is a key? - AppSheet Help

[rvje]

Yes, I want a list of key values but the key value must represent a unique tag value

[Suvrutt_Gurjar]

Please elaborate with examples what you are looking for.

Also my request will be to go through the referred article on keys. Were you able to understand keys from the article. 

[rvje]

I want to go from this table called input data:

Equipment ID	Equipment Tag	Equipment Quantity
2gwiw7v20a	A1	8
qwqvlpq5tu	A1	9
o0u89o0vz8	A1	4
ao71gh8bj2	A2	3
jy817lgucy	A2	2
zpriey2q5a	A3	1
d3thik7iad	A4	1
idog9b3sb4	A5	4
ji6it51tnu	A5	5
3tjbshvtcz	A6	6

To this table called Equipment:

New equipment ID	Equipment Tag	Equipment Quantity
9q1bzxi363	A1	21
awdg95frqn	A2	5
npnmxe3nnj	A3	1
i35t8daby1	A4	1
0h4zd6ug2o	A5	9
ho1ynq2frw	A6	6

I want to use the add a new row to another table using values from this row, and execute an action on a set of rows. This last action is asking for a list of referenced rows.

So I want to select a list of "Equipment ID" which reference to a list of unique "Equipment Tag" to perform the copy, is that possible?

[Tommy62]

Geben Sie Ihrer Quelltabelle eine neue Spalte namens "ID" und struktieren Sie diese im Appsheet-Editor neu. Damit wird diese Spalte als Schlüsselspalte indiziert.

Alternativ kann man auch einfach Ihre vorhandene Spalte [Tag] als Schlüsselspalte auswählen.