Dynamically supplying field names to combo boxes in the Form Designer

Chris Dunlop

February 04, 2012 01:34

Hello.  I'm trying to set up 2 combo boxes in a form.  The first one has a list of field names that the user can choose between.  I want the 2nd combo cox to be populated with the unique values of the field the user selects.  Is this possible?  I know you can insert '{0}' in the Where Clause - can you do something similar for the Display Field and Value Field?

On a related note, I like the way the new combo box sorts and displays unique values.  However, for number fields, it looks like it first converts them to string and then sorts them, which puts them out of order (1,10,11,2 etc).  Is there a way around this?

 

Thanks

Chris

0

• 

  Permanently deleted user

  February 05, 2012 16:48

  Hi Chris,

       It is currently impossible to do what you suggest in the first part of your question. We are working on allowing parameters in form items for a future release, I will make a note of your use case and see if it can be solved by the new feature.

       For the sorting of the data, I will log a defect. We should be able to pick up the field type and do the correct sorting according to the type.

       Thanks for your feedback.

  Cheers,

  Christian.

  0
• 

  Permanently deleted user

  December 06, 2012 06:43

  We have the same situation as previously in this post,  where users pick a field they wish to query and we have to go to another form to display the pulldown list of the field they displayed.  since I build the lists prior to the either  form coming up, I would to be able to specify which list will be used in the form with the results of the field choice pulldown.  Has that dynamically selected data sources for pulldown fields been exposed yet?

  J

  0

Please sign in to leave a comment.