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
  • The best way I can think of doing this is having a conditional and statement to change the choice labels and choice values.

    It would look something like:
    if(
    or(
    /*Condition to check that the primary choice is in the current row if selected*/
    tointeger(wherecontains(cons!PRIMARY_CHOICE, index(ri!cdt,"ownershipRole",{})) = ri!index,
    /*Condition to check that none are selected*/
    rule!APN_isEmpty(wherecontains(cons!PRIMARY_CHOICE, index(ri!cdt,"ownershipRole",{})))
    ),
    rule!listOfAllChoices,
    rule!listOfAllChoicesSansPrimary)
Reply
  • The best way I can think of doing this is having a conditional and statement to change the choice labels and choice values.

    It would look something like:
    if(
    or(
    /*Condition to check that the primary choice is in the current row if selected*/
    tointeger(wherecontains(cons!PRIMARY_CHOICE, index(ri!cdt,"ownershipRole",{})) = ri!index,
    /*Condition to check that none are selected*/
    rule!APN_isEmpty(wherecontains(cons!PRIMARY_CHOICE, index(ri!cdt,"ownershipRole",{})))
    ),
    rule!listOfAllChoices,
    rule!listOfAllChoicesSansPrimary)
Children
No Data