You are viewing limited content. For full access, please sign in.

Question

Question

Merge multiple fields into one in Forms

asked on May 29, 2020

I would like to merge a few fields in a form into a single hidden field for later use.

In my example, I have employee first name, last name, and employee number.  All of these are separate fields on the form.  

I would like to have a hidden field that merges these three into a single line field.  (i.e LastName, Firstname - Employee Number) to use in a later step in the process (including the dash).

Is this possible?

0 0

Answer

SELECTED ANSWER
replied on May 29, 2020

Yes, you can use a hidden field with the Concatenate function. 

=CONCATENATE(LastName,", ",FirstName," - ",EmpNum)

2 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.