List ref dropbox

[CYRIL]

Hi,

I want insert in column J by a ref list of column B

when i do it

, i have this the text of list in column F :

but i want a droplist with the text list in a column B(date)

how can i do that ?
thanks

[Marc_Dillon]

Set column B as the “Label” column, instead of column F.

[CYRIL]

Thanks
But in the table, an other column is use as label for an other ref

[Marc_Dillon]

I don’t quite understand exactly what you were saying in your first post. Does the dropdown column in question need to be a Ref type?

There’s always the possibility of creating a Virtual Column in the ref’d table, set as the Label, that utilizes CONTEXT() expression to return different label values in different cases (like from different Form Views).

Otherwise you may just need a concatenated Label value, that shows both pieces of data all the time.

help.appsheet.com

CONTEXT()

Information about the running app.

[CYRIL]

Hi,
I need to insert the data in column F from column B with a dropdown,

also in this dropdown, I want to have the data text in column B

In the table from AppSheet, I cannot define column B as label because another column is already defined as label for another ref

Thanks for your help

[Marc_Dillon · Accepted solution]

Does setting valid_if = table[column B], and changing Ref to Enum work for your needs?

[CYRIL]

Hi,
Yes, a Enum work !!
Thanks