Cascading DropDown - Values displayed as ID - InfoPath Dev
in

InfoPath Dev

Cascading DropDown - Values displayed as ID

Last post 08-17-2012 05:12 AM by ErnestoM. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-16-2012 12:56 PM

    Cascading DropDown - Values displayed as ID

    I have my cascading dropdown functioning, and have published the form. when submitting an entry, the values are being returned as the ID for the selected item instead of the display name. Another post suggests using another field and rules to store the values. http://www.infopathdev.com/forums/t/23197.aspx If i use the qRules submit to SharePoint list, will it correct this issue? Thanks, jason
    Filed under:
  • 08-17-2012 05:12 AM In reply to

    Re: Cascading DropDown - Values displayed as ID

    Dropdowns have a displayName and a value. When referring to a SharePoint list, the displayName is typically some human-readable field, and the value is typically the ID of the list item. This is especially important if you have lookups.

    What you do is you have a second field in your schema (it could be hidden and not displayed in the canvas). You'll set up rules to set the value of that field to store the displayName (because, remember, the dropdown is storing only the ID). Then you can use that new field (displayName) however you need: as a promoted property, in a qRules mapping, etc.

    Hilary's blog post on the qRules command includes lookups in her example, so that might be a good reference if you're trying qRules.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.