Qdabra qRules

Re: Dynamically complete ChangeSubmitURL link

Deeayrian — Mon, 18 Feb 2013 19:31:33 GMT

Blonde moment. I was going into the FX field and trying to do the concat function but what I was doing wrong was putting quotes around the my:dept field, which converted it to string. Duh! Guess I was just a bit quote crazy because I know better than that :o)

Thank you so much for your very quick and helpful reply Ernesto!

Re: Dynamically complete ChangeSubmitURL link

ErnestoM — Mon, 18 Feb 2013 19:25:17 GMT

Hi-

It looks like InfoPath is reading this as a literal string:

ChangeSubmitUrl /submit=SharePoint Library Submit /url=http://<site location>/my:dept

And not as a formula.

To have InfoPath use this as a formula, you'll need to click fx when setting the value of the field to get the Formula screen. Then you can use the concat function to create this

concat("ChangeSubmitUrl /submit=SharePoint Library Submit /url=http://<site location>/",my:dept)

my:dept is underlined and in bold to show that you would use the Insert Field or Group option to add that field.

This way InfoPath interprets this as a formula, and gets the value of the my:dept node.

Hope this helps!

Dynamically complete ChangeSubmitURL link

Deeayrian — Mon, 18 Feb 2013 19:18:31 GMT

I am using the ChangeSubmitURL command. I have about 20 different dept libraries the form could be submitted to. I created an external list to use as the drop down selection which would specify the library to submit to. Instead of creating a separate action rule for each library, I am hoping to find a way to dynamically change the submit to library based on what was chosen from the drop down field. For example, I am trying to use this as the submit command: "ChangeSubmitUrl /submit=SharePoint Library Submit /url=http://<site location>/my:dept" where my:dept is the library name based upon the dept chosen in the drop down field. However, when I do that, the my:dept field doesn't update to the dept link. It just stays as my:dept.

Is there a way to dynamically change the library it submits to?