At present only short and long text fields can look at reference data. It would be helpful if we could populate a checkbox (true/false) with data from reference sources. This would allow reference data to 'suggest' an appropriate True / False and the user can switch between them if they agree or otherwise. At present, the user has to type in True/False if they want to switch.
6
Comments
Please sign in to leave a comment.
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!
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)
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.
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.
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.
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.
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.