0

Bulk edit yes/no

Start with a Yes/No field that has all rows set to Yes, when you do Bulk Edit for a Yes/No field and select a Constant value you are presented with an unchecked box.  When you preview the changes the values are not changed they remain as Yes. To get a change you need to go back select the box and then un-select it to get a change to No. This seems like a bug to me, is that the case? Or is Yes/No actually tristate; Yes/No/Null?

10 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 wk ago
    • Reported - view

    True, A Yes/No field has 3 states.

    • Cascade Cuts
    • Lisa_Hinkel
    • 3 wk ago
    • Reported - view

    Then the Bulk Editor should reflect that, have Yes/No/Empty choices as the field edit dialog has for the default value.

    • Cascade Cuts
    • Lisa_Hinkel
    • 3 wk ago
    • Reported - view

    Further testing reveals that the Checkbox behavior in record edit  does not match that in Bulk Edit, in that the record edit will only toggle between Yes/No you cannot get to a Null/Empty value. To get at Empty value in the record you need the Combobox type. This also makes the value being selected explicit in the Bulk Edit dialog. Otherwise  what an unselected value represents is not known.

      • Fred
      • 3 wk ago
      • Reported - view

      You can set Yes/No to null programmatically, but I do see your point. Yes/No start off as null then once you select a choice then it is either/or.

      You can recommend they make the Bulk Edit UI better by sending them an email.

      • Alain_Fontaine
      • 3 wk ago
      • Reported - view

       Just one little thing: if you don’t want the field to start with a null value, you can define a default value in the field definition. This will of course only work for the records created after setting the default.

      • Alan_Cooke
      • 3 wk ago
      • Reported - view

       Setting to required also forces Yes or No but not retroactively.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 3 wk ago
    • Reported - view

    I use it, but I don't know if these issue

    if TA = true then
    TA := false
else
    TA := true;
    AC := false;
    NC := false
end

    And change the last two 

    if AC = true then
    AC := false
else
    AC := true;
    TA := false;
    NC := false
end
    if NC_offen = true then
    NC := false
else
    NC := true;
    AC := false;
    TA := false
end
      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 wk ago
      • Reported - view

      https://youtu.be/vTuL6CUI12w

      • Fred
      • 3 wk ago
      • Reported - view

      are you asking a question?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 wk ago
      • Reported - view

       No , Fred I'm not sure if the theme is about this.

Login to reply

Content aside

  • 3 wk agoLast active
  • 10Replies
  • 53Views
  • 6 Following