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

Thomas42_0-1696507994748.png

confirmed that the backend names are correct and that data is showing on the source table

 

This WORKED! thanks

palanikumar
Mega Sage

You can't keep same field. I suggest you to create to field with same column label. You can prepopulate the field with the same value as other field and then allow user to change values only in the second field.

 

Thank you,

Palani

Thank you,
Palani

when importing data through a transform map it will only map once, will i need to populate the second set with a transform script?

You can map both the fields with same source. There is no restriction on field mapping 

Thank you,
Palani