Can database lookup fill chekbox options? I don't seem to have that option in the Lookup Rules setup - it simply doesn't see checkbox fields.
Hi Lidija,
Unfortunately, it isn't a feature yet. Hopefully it will be sooner but here is what I resorted to where I needed selection of multiple values from a database.
Use a table/collection field with a drop-down/text field tied to a look-up from a database. Users can add multiple rows of values.
Regards,
Adarsh
that is correct, there is no Lookup Rules for checkboxes or radio buttons.
What we have been doing is using hidden single fields instead. We fill up the field with the value from database and then in javascript we a say "if value from hidden field is XYZ then check the box, else leave it alone"
Not currently but we are looking into it for a future release. Thanks for the request
Any progress on this feature?
Hello, this feature would still be very helpful if released. Any update?
This feature would be helpful for us also.
The feature has been added in Forms 12 for the new Form designer: https://doc.laserfiche.com/laserfiche.documentation/12/systemadmin/en-us/content/intro-laserfiche-12-changelog.htm
Thanks Rui, This is great to hear!
I was wondering Rui, is there functionality to make the available choices for the checkbox using a lookup table?
I know there is a way to import choices using a .csv or .txt file, but I wanted to know if there was a way to connect it directly to a lookup table.
Hi Eugene, I think the feature "Lookups can be used to populate checkbox" should be what you are looking for. You can define lookup rule like this:
I forgot to reply @████████, but this worked perfectly for me! Thank you so much, I appreciate your assistance.