How would one go about creating an Enum or Enumlist, where one of the values is only selectable once.
In my app, I’m trying to allow a customer to have multiple addresses. So far so good. The user can use an Enum/Enumlist to assign those addresses the values…
So a company can have multiple shipping addresses, but only ONE main address. So if a person tries to select “MAIN” for a company that already has a main address, I would like it to ideally remove the main value from the other address and assign it to the new one.
Is this possible? Or should I simply have a valid_if check telling them to go remove the other main address first?
Thanks!
Check the section “Preventing Duplicate Field Values” from this article… help.appsheet.com - List Expressions and Aggregates List Expressions and Aggregates help.appsheet.com
@Greg_Huston This app might also be helpful for you: https://www.appsheet.com/samples/Only-allow-values-that-havent-been-chosen-in-dropdown?appGuidString...
User | Count |
---|---|
39 | |
29 | |
23 | |
23 | |
13 |