0

Update Multiple Records... of a Multiple Choice Field

I asked this how-to question n Facebook and got replies essentially saying it can't be done easily. I've run into this issue before, and making changes to multiple choice fields is too much work. My feeling is it should be easy. There should be an add or remove value option in the dropdown selection menu.

5 replies

null
    • Fred
    • 2 wk ago
    • Reported - view

    I didn't know you wanted a Bulk Edit code. It would look very similar to the button code I posted.

    You can choose Assign calculated value and put this for the code:

    let selectedArray := numbers(Lettering);
    array(selectedArray, [choicenumber])
    

    change choicenumber to the choice number you want.

      • Mr_K
      • 2 wk ago
      • Reported - view

      @fred  Ninox does not like the formula.

      • Fred
      • 2 wk ago
      • Reported - view

      I was guessing Lettering was the multichoice field. Is it?

      • Mr_K
      • 2 wk ago
      • Reported - view

       No, but I fixed that and now it works. Thanks.

    • Fred
    • 2 wk ago
    • Reported - view

    Interestingly this doesn't work on dynamic multi choice fields through the Bulk Edit. Looks like dynamic multi choice fields need to be updated by a button.

Content aside

  • 2 wk agoLast active
  • 5Replies
  • 35Views
  • 2 Following