Newbie Questions

Re: How to use the same drop-down list values for different fields?

Jimmy — Tue, 21 Sep 2010 12:57:33 GMT

Glad to help! :-)

Re: How to use the same drop-down list values for different fields?

appelgw — Tue, 21 Sep 2010 11:55:08 GMT

Jimmy,

That is just way too simple! Thanks for the 100% correct answer. It took me a total of 2 minutes to create the file, add it as a data source, and direct my drop-downs to it for their values. I even took the extra 15 seconds to set up a rule on the first drop-down to set the default value of the second drop-down to the value in the first drop-down. Amazing (non-code) stuff!

Re: How to use the same drop-down list values for different fields?

Jimmy — Tue, 21 Sep 2010 01:12:30 GMT

You can store your list of values in a secondary data source. Just use a text editor or something to make an XML structure like this:

<leaveTypes>
    <type>Illness</type>
    <type>Vacation</type>
    <type>National Holiday</type>
</leaveTypes>

Then save this in a file with an .xml extension, and use the data connection wizard to add this as a data connection. Remember to leave the "Query on open" checkbox checked.

How to use the same drop-down list values for different fields?

appelgw — Mon, 20 Sep 2010 21:27:30 GMT

I have an employee leave form that allows the Initiator to select from 11 different leave types.

Later in the forms workflow, the supervisor also selects a leave type, which may be different than the initiators.

Finally Payroll updates the final section of the form with what leave type is being applied, which may again be different than either the initiator or supervisor.

These three data fields must maintain their own values for auditing purposes.

I would like to use a static list for all three drop-down list boxes. I do not want to store this list in SharePoint, since the form gets routed to multiple sections (read sites). The only solution that I can think of is to retype the 11 leave types into all 3 drop-down list box properties windows. Is there an alternate solution? I'd love to do an xml solution, but I don't know how.