- 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-04-2023 06:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 07:00 AM
i would have to create all new fields and populate it using the source table it came from, import set table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 07:07 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 07:19 AM
do you have or know of tutorials for this option never done this before