Populating Data from one table to another table through UI action,

Devi priyanka
Tera Contributor

I have some data in 'service location' table. that i want to populate in another table called 'CAR'. so, for that we have created a button in product table called 'Initiate car'. once you click on the button it should navigate to CAR table and the data in the service location should auto populate in CAR. using client script script. i have already write script for redirecting to the required url. Now i want the script to auto populate the field values from service location to CAR.

2 REPLIES 2

RoRoKT
Tera Contributor

Hi Priyanka,

After populating the data from the 'service location' table to the 'car' table are you intending to save and take the user to the newly created record or fill the values in the form and not save it, for manual submission?

If the goal is to create a 'CAR' record on the use of the 'initiate car' ui action. then a script include call from the UI action which will initialize a 'car' record set the values and insert(). 

If not creating a record just filling the information in the 'car' form so that the user manually saves then you can send the 'service_location' unique id in the parameter of the redirect link and on write an onLoad script to GlideAjax the record using the unique parameter and set value on the form.

 

BarnesB
Kilo Contributor

In a car rental system, efficiently populating data from one table to another is essential for managing bookings and customer information. For instance, when a customer rents a vehicle, their details need to be transferred from the Customers table to the Reservations table. This process ensures that the rental information is accurate and up-to-date. If you're looking for a reliable car rental service in Tiflis, visit https://race.com.ge for seamless booking and rental management.