How to create automatically records in one table using another table data?

Shubhashis · ‎02-03-2022

I have two tables in my app-Table A and Table B.

Table A is an user table ,where user can put their data and also update that in future. The fields are - Account name, Input days and Onsite/offshore.

Table B is a read-only table and not seen by the user. The fields are - Account name, Input days, Onsite/offshore, month and median rate.

So, when any records is created in Table A ,at the same time that record will be created in Table B with same account name, same input days and same onsite/offshore. But no duplicate record should not be there. The unique combination is-Account Name and onsite/offshore. The user only can update the table A by edit the input days and same change should be reflect in table B also.

So, please help me with BR for this requirement.

Rajat_Choudhary · ‎02-03-2022

Please use below rectified code.

(function executeRule(current, previous /*null when async*/) {

// Add your code here
var table2= new GlideRecord('x_snc_aob_test1_dashboard_baseline_input');
table2.addQuery('account_name',current.account_name);
table2.addQuery('onsite_offshore',current.onsite_offshore);
table2.query();
if(table2.next()){
table2.baseline_input=current.baseline_input;
table2.update();
}
else{
var table2a= new GlideRecord('x_snc_aob_test1_dashboard_baseline_input');
table2a.initialize();
table2a.account_name=current.account_name;
table2a.onsite_offshore=current.onsite_offshore;
table2a.baseline_input=current.baseline_input;
table2a.insert();
}

})(current, previous);

Please mark the answer as correct and helpful.

Hope this answers will be helpful.
Please mark the answer as helpful and correct.

Best Regards,
Rajat Choudhary

View solution in original post

shloke04 · ‎02-03-2022

Hi,

I would strongly recommend that duplicating data is not all a good practice. So instead of creating a BR and duplicating the records and making it complex, please follow the approach below:

1) In your Table B, you must be having some reference which must be linking it to Table A.

2) Using that Reference field , if the intent is to just show the data then you can dot walk in using Form layout on Table B and show all the field along with it's value in Table B.

Can you explain on what is your use case here to assist you in the correct direction?

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Vaishnavi Lathk · ‎02-03-2022

Hello,

i tested with below code in my persona instance. i create custom number field on my custom table and its string type field and it has copied the incident number to the custom number field.

var gr = new GlideRecord('incident');
gr.query();
while(gr.next()){

var gr1 = new GlideRecord('u_custom');
gr1.initialize();
gr1.u_name= gr.short_description;
gr1.u_number = gr.number;
gr1.insert();

}