Checkbox and other controls using reference data

Comments

6 comments

  • Avatar
    Nathan H

    It is a bit of a workaround but if you could live with radio buttons rather than a check box you could do this with three fields.

    Field 1 - a hidden (a.k.a. not mobile visible) drop down populated by reference data (I think this could also be just a hidden text or number field as well but I haven't tested that)

    • I just used a small reference data file like this (works for choosing FALSE as the default)

    • I also tried it like this (works for choosing TRUE as the default)

    Field 2 - a multiple choice field with radio button style with 2 choices (True and False).  I set the default value to True.  then made this field conditionally appear only if Field 1 has the value TRUE

    Field 3 - another field just like Field 2 but with the default value set to to False.  then made this field conditionally appear only if Field 1 has the value FALSE

    This works and allows the desired radio button to be selected by reference data.

    For what its worth it also works as multiple choice fields with the checkbox style - although that allows potentially choosing neither or both in addition to just one or the other.  That might not be what you want depending on your desired outcome.

    Of course you could easily use 1 and 0 or Yes and No, T and F, etc.

    This would also work with the actual checkbox field - if it supported a default choice (which doesn't seem to be a thing unless there is some unknown automagic GoCanvas code that can be added to cause that).

    I hope that helps.

    2
    Comment actions Permalink
  • Avatar
    Brian Garcia

    That works but...it'd be nice to simply set a single field via reference data as originally requested. The work around approach makes a bit of a mess for reporting/data extraction.

    2
    Comment actions Permalink
  • Avatar
    Nathan H

    I get that.  I agree it would be good to be able to populate the checkbox (and every possible field type) with reference data.  I'm also not a fan of workarounds / band-aids, but sometimes they can get us by while waiting on a feature.  Just throwing it out as an option.

    1
    Comment actions Permalink
  • Avatar
    Matthew Hase

    Has the feature request been looked at again? 

     

    In the process of creating custom checklist which needs to pull site specific data from a reference sheet. 

    1
    Comment actions Permalink
  • Hi Mike,

    I tried a bunch of different ways to try to make this work with our backdoors and couldn't get it quite right. For the record, you can do reference data with dropdowns as well. So you could do dependent reference data to a second drop down, but even then to over-ride the default you'd still have to type in the other option. Interesting feature request though! 

    0
    Comment actions Permalink
  • Avatar
    Sara Kaplow, Community Manager

    So there's a little bit of a goofy way to get at this type of functionality. It may not work for everyone, but from the user's side, it definitely replicates the idea. 

    In the App Builder, you have your original Reference Data field (I just did a simple one called Field 1, and the options are A, B, C, and D). Then you have a Static Text field based on that selection. Then you have a checkbox field with spaces for the field label, so it appears label-less, and looks like the static text is the label. Something like this: 

    Here's what that ends up looking like on mobile: 

    Otherwise, conditions are your best bet, though I recognize those can get pretty lengthy. 

    0
    Comment actions Permalink

Please sign in to leave a comment.