Field where choices can only be used once - please help!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-10-2023 02:48 PM
I have been asked to create multiple choice list fields where the choice options can only be used once similar to rating lunch options in order of preference. You cannot have two first preferences.
Lunch My Preferences
Chicken | Second preference |
Beef | Third preference |
Veg | First preference |
I need to create a input method to capture data similar to the table below. In each column, each value must be unique. For instance, users should not be able to rate Cost as the 'Highest' for both Avoid and Mitigate.
I was planning to create a new table to store records representing each row (Avoid, Mitigate, Transfer, Accept) and then creating fields (columns) for the various ratings (Cost, Disruption, Ability to Implement, etc.)
Few questions for the community:
1.) In a parent/child relationship, is it possible to restrict the use of a choice option once it has been used in another child record?
2.) If you have ever fulfilled a similar requirement, what did you works the best. I am open to any idea you are willing to share.
3.) Is it possible to create a chart like the example below on the parent form to capture the users ratings and ultimately use the rating values to derive priorities?
Cost | Disruption | Ability to Implement | Effectiveness | Efficiency | |
Avoid | Highest | Most Disruptive | Highest | Highest | Highest |
Mitigate | Second Highest | Second Most Disruptive | Second Highest | Second Highest | Second Highest |
Transfer | Second Lowest | Second Least Disruptive | Second Lowest | Second Lowest | Second Lowest |
Accept | Lowest | Least Disruptive | Lowest | Lowest | Lowest |

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-10-2023 06:22 PM