cancel
Showing results for 
Search instead for 
Did you mean: 
Automation Master
Automation Master

FormData is being a jerk!

Jump to solution

Hello friends.

I am no stranger to FormData. I have parsed many a repeating section. However ... for whatever reason .... the FormData in my current item is just.. nothing. Something is wacky. I have connected FormData to a multi-line column, I have added that column to the view ... nothing.

It's also no longer giving me back XML, it's giving me this kind of thing BEFORE it goes into the Forms Repeating Section UDA ( via Vadim Tabakman ) .... ("variablename" in place of all variables for censoring)

<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><VariableNametype="System.Double">2222</VariableName><VariableName type="System.Double">2359</VariableName><VariableNametype="System.Double">6.1</VariableName><d3a775e7-2f2f-45f4-9b69-5c081ad273d0 /><VariableNametype="System.String">98.1</VariableName><VariableNametype="System.Double">20</VariableName><VariableNametype="System.Double">2265</VariableName><VariableNametype="System.Double">0.2</PercentOversizeDecimal><VariableNamewtype="System.Double">6.8</VariableName><VariableNametype="System.String">true</VariableName><VariableNametype="System.Int32">1</VariableName><VariableNametype="System.String">98</VariableName></Item></Items></RepeaterData>Sample ID: ID-123

And this kind of nonsense AFTER it comes back from the UDA...  (SEE FURTHER COMMENTS FOR MORE DETAILS & UPDATES)

222223596.198.12022650.26.8true198

The repeating section is named the same as it always has been

.. and it used to work. Nothing has really changed, I've checked variable names against this.. everything comes back blank or 0. 

I feel like I must be missing something REALLY stupid. What should I check?? Am I crazy, this SHOULD come back LOOKING like XML, right??

rhia

Labels: (2)
0 Kudos
Reply
19 Replies
Automation Master
Automation Master

Re: FormData is blank!

Jump to solution

You guys ever seen this before? 

0 Kudos
Reply
Automation Master
Automation Master

Re: FormData is blank!

Jump to solution

this doesn't seem to be whole FormData XML, it looks like you already picked just repeater part out of it.

"Sample ID: ID-123" at the end of your sample doesn't belong to repeater data. it breaks validity of XML so that's likely the reason UDA do not provide expected results.

btw, it's better to create multiline text field(s) in list dedicated to (each) repeating section on list form...

0 Kudos
Reply
Automation Master
Automation Master

Re: FormData is blank!

Jump to solution

Hi Marian - thank you - I do have a dedicated column ("FormData" - multiline) which I've connected the repeating section to. ...But nothing is there. Completely blank.

And, I agree with what you're saying in that it doesn't look like the whole FormData XML ... but that's what it's giving me before going into the UDA Smiley Frustrated 

0 Kudos
Reply
Automation Master
Automation Master

Re: FormData is blank!

Jump to solution

Hi Rhia Wieclawek‌,

first of all I would rename the column! (deleted & created new one to be extra sure column's internal name is not preserved)

there is already existing hidden FormData column. so it might happen sometime is updated one column and sometimes the other. that would explain those broken data.

Reply
sojanm
Nintex Newbie

Re: FormData is blank!

Jump to solution

It will be blank if the column created is multiline and it is not plain text

0 Kudos
Reply
sojanm
Nintex Newbie

Re: FormData is blank!

Jump to solution

You can't connect the form data to a column. But you can update the column with FormData using workflow. So It should be the repeater control data that is connected to the column. Make the multiline column as plain text and try. Something went wrong with the QueryXMLData control.

0 Kudos
Reply
Automation Master
Automation Master

Re: FormData is blank!

Jump to solution

Ah, good point, I've done this now - using XMLData - and I can update the column to have the data needed, which looks like the "BEFORE" in the original post. 

0 Kudos
Reply
Automation Master
Automation Master

Re: FormData is blank!

Jump to solution

So after trying this on a new item, the UDA is running, and now I'm getting this:

Workflow Status

<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><beada732-0784-4577-97fd-467e31954290 type="System.String">Test&amp;#160;Failed&amp;#160;-&amp;#160;Variable Name NWF.FormFiller.Functions.GetValue(&amp;#39;382522f

and it terminates there.

Well, at least I have something more pointed to investigate.

0 Kudos
Reply
Automation Master
Automation Master

Re: FormData is blank!

Jump to solution

Okay I'm kind of working out loud here..

This is the fail point:

NWF.FormFiller.Functions.GetValue(&amp;amp;amp;#39;382522f3-e8e8-43a1-94cb-13c03e961a07&amp;amp;amp;#39;, sourceContext, &amp;amp;amp;#39;string&amp;amp;amp;#39Smiley Wink&amp;lt;/beada732-0784-4577-97fd-467e31954290

 

Now I just have to figure out what ^ that is. Smiley Indifferent

0 Kudos
Reply