General

Re: If/Then in submit to SP library

joe_detroit — Mon, 29 Jul 2013 14:21:16 GMT

Ok... haven't tried anything with xPaths so I'll have to read up on them.

Thanks for the help!

Re: If/Then in submit to SP library

Patrick Halstead — Sun, 28 Jul 2013 04:24:52 GMT

Hi Joe_Detroit,

The submit data connection doesn't support rules, but you can add an xpath with conditionality. Here's the trick:

concat(substring("UNAPPROVED", 1, 10 * (Field = 'NO')),' ', Field2)

In other words, if Field is your dropdown and it is 'NO', then Field2 (your form name) will be prefixed with "UNAPPROVED ".

Hope this helps.

Best,

Re: If/Then in submit to SP library

joe_detroit — Fri, 26 Jul 2013 10:39:03 GMT

Hi Jo-Anne--

Thanks, I'll give that a shot. I tried rules attached to the dropdown, but didn't think about the submit button.

Re: If/Then in submit to SP library

Jo-Anne Alfafara — Fri, 26 Jul 2013 04:40:57 GMT

Hi Joe,

You can try adding a field in your data source called "FormName" and add a rule in your submit button that sets its value. So, for example, add a rule with condition if dropdown is = NO, set value of FormName = concat("SomeFormTitle - ", "UNAPPROVED). Then, add another rule with condition if dropdown = X, set the value to of FormName to Y.

Hope that helps,

If/Then in submit to SP library

joe_detroit — Thu, 25 Jul 2013 17:46:02 GMT

Hi All...

Is it possible to do if/then logic in a submit to library connection? I want the word "UNAPPROVED" to be added to the filename if the restult of a dropdown is 'NO".

I tried using some rules attached to the dropdown that would populate a hidden textbox, but the submit function used the formula in the textbox as the filename. I didn't think that would work, but I figure it was worth a shot...

Thanks,

joe