Excel Integration - Dynamic Combo / List Box

Joseph Flesche

• January 12, 2024 13:26

I have a requirement to provide dynamic list boxes (based on row criteria) to end users. This is not a problem when using the page within DSP; the field configuration is setup as follows.

 

When I enable Excel Integration on the page configuration and download the Excel Integration file, the drop down box does not appear.

In troubleshooting, I removed the List Where Clause on the field configuration within DSP and the Excel list box works without an issue.

To try to find possible alternatives for my requirement, I was trying to look at the Excel list box configuration. But these Excel files are locked for editing thus I cannot see the Excel list box configuration. Is the Excel List Box a Named Range? Or is each individual Excel row list box configured separately?

Any suggestions on how to setup a row by row list box within Excel Integration?

0

• 

  Joseph Flesche

  • April 03, 2024 04:34

  Eric Weldon,

  Please let me know if this is something that is possible with Excel Integration.

  0
• 

  PSA Support

  • April 03, 2024 13:21

  Hey Joe,

  The list boxes are driven off a hidden worksheet named "boaListData". It's not possible to have DSP generate an Excel file with dependent drop down lists but it is possible to do that in Excel (I've used this article in the past: Easy Steps Excel Dependent Drop Down List Data Validation (contextures.com)). 

  1

Please sign in to leave a comment.