- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 06:54 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 08:49 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 10:59 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-05-2023 05:13 AM
confirmed that the backend names are correct and that data is showing on the source table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-05-2023 07:02 AM
This WORKED! thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 07:02 AM
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
Palani
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 07:03 AM
when importing data through a transform map it will only map once, will i need to populate the second set with a transform script?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 07:06 AM
You can map both the fields with same source. There is no restriction on field mapping
Palani