Skip to main content
Seabee_Tanker
Participant
August 8, 2023
Answered

How can I concatenate the answer to multiple fields into another?

  • August 8, 2023
  • 2 replies
  • 470 views

I would like to combine the following field names from my form into another field to generate a file name that users can copy and save.

  • Last_Name
  • First_Name
  • Department
  • Course_Start_Date

 

Once combined, I'd like the text to be formatted like this "Last_Name-First_Name-Department-Course_Start_Date-.pdf"

For example, "Smith-John-Finance-08 Aug 2023.pdf"

 

From what I've researched I assume that I will need to use Javascript, but I need help.

This topic has been closed for replies.
Correct answer Seabee_Tanker

This seems to work great:

Last_Name + "-" + First_Name + "-" + MAJCOM_COCOM + "-" + Course_Start_Date + "pdf"

var s = this.getField("Last_Name").valueAsString + "-" + this.getField("First_Name").valueAsString + "-" + this.getField("Department").valueAsString + "-" + this.getField("Course_Start_Date").valueAsString + "-" + this.getField("Course").valueAsString + ".pdf";

event.value = s.replace(/^, |, $/g, "");

2 replies

Nesa Nurani
Community Expert
Community Expert
August 8, 2023

Use this as custom calculation script of field where you want to show text:

var Lname = this.getField("Last_Name").valueAsString;
var Fname = this.getField("First_Name").valueAsString;
var Dep = this.getField("Department").valueAsString;
var CSD = this.getField("Course_Start_Date").valueAsString;

if(Lname&&Fname&&Dep&&CSD)
event.value = Lname+"-"+Fname+"-"+Dep+"-"+CSD+".pdf";
else
event.value = "";

Once all fields are filled, it will generate text.

Seabee_Tanker
Seabee_TankerAuthorCorrect answer
Participant
August 8, 2023

This seems to work great:

Last_Name + "-" + First_Name + "-" + MAJCOM_COCOM + "-" + Course_Start_Date + "pdf"

var s = this.getField("Last_Name").valueAsString + "-" + this.getField("First_Name").valueAsString + "-" + this.getField("Department").valueAsString + "-" + this.getField("Course_Start_Date").valueAsString + "-" + this.getField("Course").valueAsString + ".pdf";

event.value = s.replace(/^, |, $/g, "");