Hi,
I am getting this error while trying setting initial value for a Ref column on my AppSheet form.
"The expression is valid but its result type 'List' is not one of the expected types: Ref"
Tables:
Banks: Bank Name, Default (Y,N)
Transactions: Date, Bank Name, Amount, .....
Banks table has multiple banks but only one is Default = Y at a time. When I open Transactions form, I want default bank to be selected automatically. Then user should have a choice to change the bank, if needed.
This query for setting initial value failed.
Select(Banks[Bank Name],([Default]="Y"),False)
Appreciate your help.
-------------------------------------------------------------------
Issue solved by using this formula
LOOKUP("Y", "Banks", "Default", "Bank Name")
Another way is to wrap the formula with ANY() like as ANY(Select(Banks[Bank Name],[Default]=TRUE))
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |