hi. I want to do a dropdown list of suggested...

hi. I want to do a dropdown list of suggested value for a column that is taken from another table, and is conditional.

the issue is that I want to do it on Date values (not Text) can it be done? how? i saw this, and this is the most relevant but I could not make it work for me, yetโ€ฆ https://help.appsheet.com/expressions/using-expressions/suggested-values-for-a-column

where do i write the constrain? in the valid if or the formula?

second q: can it be done on virtual column? if so what do i write in the formula (if the constrain is need to be in the valid if)

Thanks! please help, I am in a loop regarding this for a while:) Ravid

0 6 403
6 REPLIES 6
Top Labels in this Space