using concat function to create filename on library submit - InfoPath Dev
in

InfoPath Dev

using concat function to create filename on library submit

Last post 08-24-2010 11:08 PM by Patrick Halstead. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-24-2010 10:49 AM

    using concat function to create filename on library submit

    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?

     

     

  • 08-24-2010 01:26 PM In reply to

    Re: using concat function to create filename on library submit

    Hi VernGraham,

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

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

     

  • 08-24-2010 11:08 PM In reply to

    Re: using concat function to create filename on library submit

    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!

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.