InfoPath – Using CONCAT

The term concatenate means to put pieces together to make a whole. In the case of InfoPath, the CONCAT function allows you to put any combination of the following elements of your InfoPath form together into one element:

  1. Field
  2. Function
  3. Text

Syntax

concat(fieldname, "text", function)
  • Fieldname – The name of a field from your form.
  • Text – Any text you enter must be enclosed in quotes.
  • Function – Any of InfoPath’s built-in functions.

Example:

Use the CONCAT function to give a form a name when submitting to a Sharepoint list.

concat(FullName, "-", today) would result in the form being named DebbieSilbert-11/10/06.xml.
Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *