Hi everyone,
Iโm pretty new to Appsheet and Iโve been making great strides so far with the available resources. I am currently trying to create two ENUM fields that will populate two columns of data; โSourceโ and โDestinationโ.
The options in both will be similar; A,B,C,Dโฆand so forth. I would like to have the option selected in the โSourceโ field disabled in the โDestinationโ field and vice versa.
I.e. If option โAโ is selected in the โSourceโ field, then the available options in the โDestinationโ field should be โB,C,Dโฆโ. Basically everything except what was selected in the โSourceโ field.
I want this to work both ways, i.e. the user can start by selecting an option for either the โsourceโ or โdestinationโ and the alternate field will automatically limit the options available based on the users initial selection.
Lastly, I am using a stacked input mode so I would like the disabled option to be visible to the user, but for them to be unable to select it.
Any help would be greatly appreciated. Thanks in advance.
Solved! Go to Solution.
Try:
Table1[Transfers] - LIST([Destination])
And:
Table1[Transfers] - LIST[Source])
Thanks!
I think thereโs something I am failing to do. I have used the syntax;
Table1[Transfers] - [Destination] to get the enum options for โSourceโ
and
Table1[Transfers] - [Source] to get the enum options for the โDestinationโ
Yet I am still able to select the same option for โSourceโ and โDestinationโ which is what I want to have dynamically disabled based on what is selected in either field. I.e. โSourceโ and โDestinationโ cannot be the same.
If it offers any clarification, both fields are set to enum and are pulling values from the same range in the source data.
Try:
Table1[Transfers] - LIST([Destination])
And:
Table1[Transfers] - LIST[Source])
It works, thanks a bunch.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |