How to populate List box values ?

I was trying to populate list box based on date selections, But the list box shows only field name instead of field values. The highlighted box in the below picture shows only column name in the list box. Any idea on this, please?

When I ran the app, I am ending up on the following screen.

Based on radio button selection, I want to populate the list box values dynamically from the database(using dynamic input) based on my date selections. But list box is not updating. is it to populate list box dynamically?

Developer Tools

Input

Tips and Tricks

Best Practices

Apps

Dynamic Processing

Interface Tools

Accepted answers

jrgo

@anil_m

Interface questions are generated when the workflow is initially loaded. In order to dynamically populate your list box is to create a chained app that would generate a data file, which would be you list, and can be loaded when the second chained app is loaded.

You should be able to find various examples throughout community on how to create chained apps.

Hope this helps!

Jimmy

All comments

jrgo

@anil_m

You should be able to find various examples throughout community on how to create chained apps.

Hope this helps!

Jimmy

JasonTrippet

@jrgo

I've created a 3-app chain in order to do exactly what you describe, but the interface tool (List Box in my case) always seems to cache the options that it processes from the first run, and ignores any updates to the connected input data file on subsequent runs. Here's a snapshot of the tools in question, starting with the "end" of the first app, that outputs a data file with a set of choices: App 1.jpg

And it's chained to the next one, that (I thought) would read the same data file and use it to populate the list box:

App 2.jpg

But when the values in the data file change on subsequent runs, the list box always presents the same values to the user, regardless of what's currently populated in the data file. As an experiment, I even deleted the data file from its directory and ran the second app, and it presented the same choices, didn't throw any "file not found" error.

I found this thread from a couple of years ago that seemed to come close to addressing the issue, but I couldn't make sense of what I had to do with a macro to achieve the "Q-to-Q" connection it described instead of the "anchor-to-Q" connection that I'm currently using.

Jason

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335