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
    • 8 mths ago
    • Reported - view

    True, A Yes/No field has 3 states.

    • Cascade Cuts
    • Lisa_Hinkel
    • 8 mths 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
    • 8 mths 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
      • 8 mths 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
      • 8 mths 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
      • 8 mths ago
      • Reported - view

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

    • Rafael Sanchis
    • Rafael_Sanchis
    • 8 mths 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
      • 8 mths ago
      • Reported - view

      https://youtu.be/vTuL6CUI12w

      • Fred
      • 8 mths ago
      • Reported - view

      are you asking a question?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 8 mths ago
      • Reported - view

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

Login to reply

Content aside

  • 8 mths agoLast active
  • 10Replies
  • 67Views
  • 6 Following