List ref dropbox

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 :
image

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

how can i do that ?
thanks

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

1 Like

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

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.

1 Like

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

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

1 Like

Hi,
Yes, a Enum work !!
Thanks

2 Likes