You are viewing limited content. For full access, please sign in.

Question

Question

lookup checkbox

Forms
Updated February 8, 2021
asked on February 1, 2021

Hello, 

I have a form that performs a SQL Lookup. I currently have the current services/strategies listed in a text box and the user must update the services/strategies from the text. How can I have the checkboxes auto-populate from the lookup? More than one checkbox can be checked. I currently have no CSS assigned to the checkbox field (#q210). Thanks in advance! 

 

0 0

Replies

replied on February 8, 2021

Unfortunately, I don't believe it is possible to populate a checkbox field via Lookup directly (I've never found a way to do that anyway).

Two ways I've addressed needs to do this in the past:

  1. If the lookup is dependant upon data from an earlier task rather than on the immediate form, I do the SQL query and population of the form in LFWorkflow.  You can get the field values populated via LFWorkflow such that the next user task in LFForms displays the checkboxes already marked.
    -otherwise-
  2. Have the field lookup populate the values into a hidden field(s), such as a single-line field or a dropdown field, and then use Javascript to mark the checkboxes based on the values that were loaded to the hidden field(s).
2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...