Newbie Questions

Re: Validate entry in Combobox in repeating table

DavidLeung — Mon, 12 Jan 2015 17:08:36 GMT

Thank You. It is working now that I created a new form.

Not sure what went wrong with the old one.

Re: Validate entry in Combobox in repeating table

DavidLeung — Mon, 05 Jan 2015 16:41:23 GMT

Hi Hilary,

I tried to publish form with the rule on VxGL and received the following error (Screen shots below).

I changed "NOT" to "current() !=" and no error message but that's not what we want. Any suggestions?

THANKS.

Re: Validate entry in Combobox in repeating table

Hilary Stoupa — Fri, 02 Jan 2015 22:15:34 GMT

If the rule is on VxGL, I'd think this:

not(xdxDocument:GetDOM("VISA GL# Validation")/dfs:myFields/dfs:datafields/d:SharePointListItem_RW[d:GL_x0023_=current()])

Since current() refers to the node you are on - which is VxGL.

Re: Validate entry in Combobox in repeating table

DavidLeung — Fri, 02 Jan 2015 21:15:23 GMT

Rule is on VxGL.

Yes, I think I need "NOT" instead.

That was why initially I used "not equal" but I guess no rows found is not considered as not equal.

Is there a way to go around this?

THANKS Again.

Re: Validate entry in Combobox in repeating table

Hilary Stoupa — Fri, 02 Jan 2015 18:59:11 GMT

Hmmm - I wonder if instead you want:

not(xdxDocument:GetDOM("VISA GL# Validation")/dfs:myFields/dfs:datafields/d:SharePointListItem_RW[d:GL_x0023_=current()/../my:VxGL])

So, the validation rule fires if there is no row where the GL_x0023_ field matches the VxGL field - but what field is this rule currently on? Not VxGL?

Re: Validate entry in Combobox in repeating table

DavidLeung — Fri, 02 Jan 2015 18:46:18 GMT

Hi Hilary,

Here is validation rule:

current()/../my:VxGL != xdxDocument:GetDOM("VISA GL# Validation")/dfs:myFields/dfs:datafields/d:SharePointListItem_RW/d:GL_x0023_[.=current()/../my:VxGL]

"VxGL" is value entered in combo box.

"VISA GL# Validation" is secondary data source - I am trying to filter this using the VxGL.

Thanks and much appreciated.

Re: Validate entry in Combobox in repeating table

Hilary Stoupa — Fri, 02 Jan 2015 16:02:52 GMT

What does the validation rule look like? Change the first drop down to "the expression" to get the XPath.

Validate entry in Combobox in repeating table

DavidLeung — Wed, 24 Dec 2014 03:38:15 GMT

I have a GL account sharepoint list in a combobox/repeating table. The GL accounts in combobox are retrieved based on Users location. If a GL account is not in combobox, user can manually key in GL account. I need to validate this manually entered GL account. I have a secondary data source of the full GL account list. I am trying to filter the full GL account list with the manually entered GL account, then compare to see if the GL account is valid. I got it to work when a static value was used for filtering but it just wont work if I specifiy the entered value for filtering. Any suggestions how to get this to work? THANKS MUCH.