Controls

Re: Setting the default value of a text box to be the "Display name" from a drop down list box

whizzconsult — Fri, 17 Dec 2010 17:44:02 GMT

Hi guys, I am getting the same error as Patrick mentioned above. Has anyone figured out the correct way to access the display name as opposed to the value?

Thanks

Leland

Re: Setting the default value of a text box to be the "Display name" from a drop down list box

Patrick — Tue, 17 Jun 2008 17:16:14 GMT

Hi Clay,

Thanks for the response. I was out of the country for a while, so I just got a chance to look at this.

The concat formula you replied with...do I type that when the "Edit XPath (advanced)" is checked? or does it not matter?

I tried typing that in and here's what it looks like in the formula field:

concat(SOFST_CircuitQuantity_drop, "x", display[value=SOFST_CircuitType_drop], " @ ", display[value=SOFST_PortBandwidth_drop])

I'm getting this error: "display/value" does not point to a valid location path of a field or group.

Maybe I misunderstood what you meant me to try. Any ideas?

Thanks

Re: Setting the default value of a text box to be the "Display name" from a drop down list box

Clay Fox — Thu, 05 Jun 2008 19:45:53 GMT

Hey Patrick.

You would just need to backtrack.

If you know the values then just use a filter to get the display field.

concat(txt1, "x", display[value=ddl1], "@", display[value=ddl2])

So you just need to reference your secondary SP lists and look up the display field value where the value fields = what was selected.

Hope that helps.

Setting the default value of a text box to be the "Display name" from a drop down list box

Patrick — Wed, 04 Jun 2008 18:12:21 GMT

Hi,

I have a situation in which I hope there's a simple solution...

I have a few controls, 2 text boxes and 2 drop down list boxes. The drop downs are receiving their entries from 2 SharePoint Lists and have different columns feeding the "Display name" and "Value" properties in each.

DDL1: Linked to Secondary Data Source (DS2)

DDL2: Linked to Secondary Data Source (DS3)

Txt1: Linked to Main Data Source

Txt2: Linked to Main Data Source

I would like to use the concat() function to take the "Display name" entries from Txt1 and each list box and show the result in the Txt2. When I do this, it shows me the "Value" from each drop down instead of the "Display name".

This is an example of my formula:
concat(Txt1, "x", DDL1, " @ ", DDL2)

I am wondering how to show the "display name" of each text box instead of each value. I assume this is done with XPath, but I'm still learning.

Formula:

concat(SOFST_CircuitQuantity_drop, "x", SOFST_CircuitType_drop, " @ ", SOFST_PortBandwidth_drop)

"Edit XPath (advanced)"

concat(../../../my:SOFST_Network_Tab_sec/my:SOFST_CircuitQuantity_drop, "x", ../../../my:SOFST_Network_Tab_sec/my:SOFST_CircuitType_drop, " @ ", ../../../my:SOFST_Network_Tab_sec/my:SOFST_PortBandwidth_drop)

I am using IDs as the values for each drop down, which are in the form of numbers with dashes: # - # - # # - # # #

The output looks like this:

3x3-7 @ 3-7-10-375

The desired output would look like this:

3xT1 @ 4.5 Mbps

I hope I gave enough information. Any help is much appreciated, as always. You guys are great!