Hiding options from dropdown values

We have an editable grid, in the second column if the user selects "primary" on more than one row; the grid displays an error.

Is there a way to hide the "Primary" option from the consequent dropdown values; if the user selects "Primary" on any of the columns?



OriginalPostID-216959

OriginalPostID-216959

  Discussion posts and replies are publicly visible

Parents
  • You can also do like if Ownership Role has primary than use difference from dropdown choice value and choice label to take out the Primary.

    if(contains(ri!GridVariableSubset.ownershipRole, cons!choiceValue[index of primary]),
    difference(cons!choiceValue, cons!choiceValue[index of primary]),
    cons!choiceValue
    )

    If you want already selected value of grid should remove from drop down than directly use difference of union of selected value from choice value.
Reply
  • You can also do like if Ownership Role has primary than use difference from dropdown choice value and choice label to take out the Primary.

    if(contains(ri!GridVariableSubset.ownershipRole, cons!choiceValue[index of primary]),
    difference(cons!choiceValue, cons!choiceValue[index of primary]),
    cons!choiceValue
    )

    If you want already selected value of grid should remove from drop down than directly use difference of union of selected value from choice value.
Children
No Data