cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Cascading Drop Down List - Formatting Difference

Jump to solution

All,

Nintex form 2013.

SharePoint 2013

In 'live' environment, so can't upgrade to latest version of forms (yet).

Used the following Cascading drop downs and Nintex Forms for SharePoint technique to attempt to cascade 2 dropdown lists.

To the human eye all is correct. Yet when I add calculated value fields to my form, I see the 2 values don't actually match.

If I add a form variable i.e. replace(MyFormAutotask,"[0-9]*;#","") I can remove the 15;# .

What I can seem to figure out is how to get my ticket type drop down to reference the variable value, not the actually drop down value.

I've tried various SP calculated column  formulas, they remove the visible value text, not the hidden 15;# i.e:

Any ideas?

Thanks

Andrew

Labels: (1)
0 Kudos
Reply
12 Replies
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

Hi 

can you try using the parselookup in your expression? I can show you a screenshot later when I get online. 

Reply
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

OK to add to my explanation:

top highlight is expression: 

middle highlight is expression: 

bottom highlight is expression: 

Reply
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

this is a really excellent reply, Cassy Freeman‌ -- well done!

Reply
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

Thanks for the parselookup examples.

Yet, how can they be referenced when using a list lookup control used for cascading drop down controls?

0 Kudos
Reply
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

if you give your calculated control a name can you use that control to filter on?

0 Kudos
Reply
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

It doesn't seem like it because the control "values" underneath are actually ID number #, Title, not just the title text.

So if control 1 = Set up new user, the underlying value is 15;#Setup New User

Control 2= New Starter, the underlying value is 5;#Setup New User

15#, is different to 5#, I believe that's where the issue is.

0 Kudos
Reply
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

can you show me the underlying lists please?

values and settings.

0 Kudos
Reply
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

Auto task settings:

Auto Task value

Ticket Type

Ticket Type Settings

0 Kudos
Reply
Workflow Hero

Re: Cascading Drop Down List - Formatting Difference

Jump to solution

OK so i have created two lists the same as yours.  I have added the controls on my form and the second dropdown is filtered by the first.

TicketType List:

AutoTask List:

Lookup settings:

Ticket Type Control:

AutoTask Control:

Form in preview:

What is different about mine and yours?

Reply