How should I form an expression in an App Formula to set the value of a dropdown (ref) list based on the value of another column AND if the value does not match then list all of the values in the drop down. This expression works, with one problem Iโd like to solve:
IF([TranType]=โTRANSFERโ,โCash Transferโ ,Items[Name])
This is set in the App Formula of the โItemโ column, which is a dropdrown ref containing the list of values from the Items table. If the TranType column = โTRANSFERโ set this col to โCash Transferโ else List the Names from the Items table.
The problem is that it just sets the Item column to all of the values in a comma delimited list, instead of a dropdown format. Any help will be greatly appreciated by this newby.
Solved! Go to Solution.
Set Valid If to:
IF(
("TRANSFER" = [TranType]),
LIST("Cash Transfer"),
Items[Name]
)
Then set Initial value to:
IFS(
("TRANSFER" = [TranType]),
"Cash Transfer"
)
Optionally set Editable? to:
("TRANSFER" <> [TranType])
See also:
Set Valid If to:
IF(
("TRANSFER" = [TranType]),
LIST("Cash Transfer"),
Items[Name]
)
Then set Initial value to:
IFS(
("TRANSFER" = [TranType]),
"Cash Transfer"
)
Optionally set Editable? to:
("TRANSFER" <> [TranType])
See also:
Thanks, so much. Works great.
User | Count |
---|---|
16 | |
12 | |
8 | |
4 | |
2 |