Data Connections

Re: using concat function to create filename on library submit

Patrick Halstead — Wed, 25 Aug 2010 06:08:26 GMT

If you're using the Fx dialog to create the concat, you may have to use commas instead of semicolons. Make sure you insert your fields using the button so that InfoPath adds the correct xpath. You can use single quotes or double quotes to insert the commas. Otherwise, Potemkine is "right on the money". Cheers!

Re: using concat function to create filename on library submit

Potemkine — Tue, 24 Aug 2010 20:26:43 GMT

Hi VernGraham,

Edit:You receive your error when you verify your formula or on submit?

try to replace , by ; like :concat(RemedyTicket;",";PrimDev;",";ProjName)

using concat function to create filename on library submit

VernGraham — Tue, 24 Aug 2010 17:49:34 GMT

I have enabled a data connection to submit an InfoPath form to a Sharepoint library which uses the concat function to name the file. However, I want to place a comma (or space, symbol, etc.) between the 3 fields that I have selected to concat. here is the valid argument that infoPath accepts.

concat(RemedyTicket, PrimDev, ProjName)

when it returns the values of the fields in the file name, it looks like a nonsenscial string with no seperators between the values in the 3 fields. (ie "ticketnumberprimdevinfoprojectnametext")

I would like to insert a charachter between the 3 fields (a comma and/or space), but InfoPath won't accept this syntax: concat(RemedyTicket,","PrimDev,","ProjName)

this way I would get a filename that would read like this: "ticketnumber, primdevinfo, projectnametext".

What do I need to do to make this work?