InfoPath Dev

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?

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!

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!