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?