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

Question

Question

Fill a field using other fields

asked on February 12, 2018 Show version history

HI,

I am trying to fill a field in a form using variables of other field values on the same form. I tried using form variables but it is not being populated.

Actually, I am trying to create a unique reference code here. For eg: HR/2018/1.

Where HR is the department, 2018 is the year and 1 is a unique number called from stored procedure. All this values are called in the same form through different fields. I want all of these called into a single field called reference number.

Thanks in advance.

0 0

Replies

replied on February 12, 2018

Hi Shibin

Create a Single Line field called Reference Number and under the advanced tab, you can use a CONCATENATE formula to  stitch them all together.

Example

=CONCATENATE(department,"/",YEAR,"/",UniqueNo)

3 0
replied on February 12, 2018

Thank you Steve. That does the job.

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

Sign in to reply to this post.