- June 9, 2009 at 10:50 pm #217
I have a form that populates a table based on a connection to another form. I want to populate a drop-down menu with entries based on that table, but I don’t want entries to be repeated.
For example, if a column holds the names of colors, with five rows that say “Red,” two that say “Blue,” and three that say “Orange,” but no rows that say “Green,” the drop-down options would be “Red,” “Blue,” and “Orange”. If the table is re-loaded and now shows rows that contain “Green,” then “Green” would be added as an option in the drop-down.
Is this possible? The “Set Selection Items” behavior does not seem to have any options for dynamically choosing the entries.June 10, 2009 at 9:46 am #4599
Set Selection Items is not what you need here. To read from another form you need to set up a connection (as you indicated) although it would be expected to then show five Red, two blue as this is what is stored in the field.
If you do not want to show these repeating fields, then either on your source form or this form here, you would need to run scripts to identify and delete such duplicate information where using the Set Table Row script action will be of use where you can ‘scroll’ through your table rows to then write out what you need to then show to the other form.
You must be logged in to reply to this topic.