Using the label format in the SQL Request control

  • 11 December 2015
  • 1 reply
  • 0 views

Badge +8

When I use the SQL Request control with one of the choice formats (dropdown, checkbox, option) I can split the results into display and value fields.  For a label field I've been outputting the results with the same column (or alias) for both display and value (since both are required) but would like to be able to send different columns to the display and value fields.  Can you do this?  There is no analog to the parseLookup() function for label formats.

 

Thanks,

Bruce


1 reply

Badge +3

I used the workflow to query the field to get the rest of the values and then populated the other columns using workflows.  The form is limited to value and text.

Reply