Enumlistref data is not label

AppSheet AppSheet Q&A
1

i created a ref enumlist and i was expecting to get the labels on the data source, but it is inserting the key values instead. Print of the fórmula and the columns bellow:

3X_1_4_14e667e796bfbd14f8146649f5e2c8075300e7f5.png
3X_1_4_14e667e796bfbd14f8146649f5e2c8075300e7f5.png700×507 16.3 KB

3X_6_6_66a788a13af884803f47f5b74a744296b19fb045.png
3X_6_6_66a788a13af884803f47f5b74a744296b19fb045.png799×377 17.5 KB

3X_6_1_611b5b62277d5c10b540a46d2472bef8eea1deec.png
3X_6_1_611b5b62277d5c10b540a46d2472bef8eea1deec.png1259×366 22 KB

2

ATR:

i was expecting to get the labels on the data source

Nope.

ATR:

it is inserting the key values instead

Yep.

That’s how Ref works.

1 Like
3

I know how to fix it now, i’ll create a column that has the key column name from the table i want, and then do the enumlist from it, after that i’ll do the unique() formula.
Thanks Steve

1 Like