REF_ROW TO ENUMLIST

[bolognesiedalla]

Hello everybody. I am creating an app for interventions in the countryside. In each intervention I have the choice of land as an enumlist, to choose more land. I would like the reference of each intervention to be kept in the detail view of the land (in practice a ref-rows to the Enumlist). It's possible?

INTERVENTION TABLETABLE LANDDETAIL_VIEW OF A LAND

[Marc_Dillon · Accepted solution]

Make a Virtual Column, List type, Ref base type, with formula that just references the EnumList.

[bolognesiedalla]

thanks for the answer (much simpler than I thought lol). I tried to set it from the "TERRENI" table, but the result is this ... instead of the reference lines. What am I doing wrong?

[Marc_Dillon]

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column...

[bolognesiedalla]

I'm sorry I'm trying but I didn't understand the advice ... the error is in the formula of the new virtual column? how should i build it?

[bolognesiedalla]

SOLVED USE ALSO IN() EXPRESSION