populated fields with source data

ServNowDev
Tera Guru

is there a way to populated data , same fields but different sections, for instance i have two sections with the same field the infomation section i want to populate with the original data that comes in and the others can change as needed so i want the orginal departure date that came in to stay the same if the date changes i only want it to change on the top departure date.

Thomas42_0-1696427614638.png

 

2 ACCEPTED SOLUTIONS

@ServNowDev 

 

I am not sure why do you want to store the actual data, but here is the way

 

1) Create a new field on target table say "actual_data"

2) Check the run script of transform map and In the run script of transform map, mention like this:

 

var data = {};
data.destination = source.u_destination;
data.departure_date = source.u_departure;
data.arrival_date = source.u_return;
target.actual_data = JSON.stringify(data);

 

If you want to hide this field on target table, you can write the UI policy on that to make it hidden

 

Now you have the data stored, in future if you want to use it in client script, you can read it as 

g_form.getValue("actual_data");

and in business rules as 

current.actual_data

 

I hope you understand the concept!

 

If my answer solved your issue, please mark my answer as  Correct & 👍Helpful based on the Impact.

View solution in original post

@ServNowDev 

 

Can you update the script as below 

 

var data = {};
data.destination = source.u_destination + "";
data.departure_date = source.u_departure + "";
data.arrival_date = source.u_return + "";
target.actual_data = JSON.stringify(data);

 

Also please use the proper backend name of the fields (whatever the backend names of fields in source table).

 

If my answer solved your issue, please mark my answer as  Correct & 👍Helpful based on the Impact.

 

View solution in original post

14 REPLIES 14

Prince Arora
Tera Sage
Tera Sage

@ServNowDev 

 

The short answer is NO

i would have to create all new fields and populate it using the source table it came from, import set table?

You can store the data in the fields from the source, and users can update it if necessary. However, if you want to keep a record of the original data, you can create a hidden field using a UI policy and store the data in JSON format within that field. This way, if you ever need the original data, you can simply read that hidden field to retrieve the actual data.

 

{

"destination":"",

"arival_date":"",

"departure_date":""

}

 

If my answer solved your issue, please mark my answer as  Correct & 👍Helpful based on the Impact.

do you have or know of tutorials for this option never done this before