340
I have number field say "seqno"of type whole number consists of sequence number starts from "500000"on entity "B" ,when entity "A" record is loaded the "seqno" value is loaded to entity A from B and on save of entity A record the sequence number on B should be increment by 1. Here entity A and B does not have any lookup. How can i achieve this.
Hi Sandy,
You can refer following js code:
Share
Report
All responses (
Answers (
function number ()
{
Xrm.WebApi.online.retrieveMultipleRecords("new_test", "?$select=new_seqno&$orderby=createdon desc&$top=1").then(
function success(results) {
for (var i = 0; i < results.entities.length; i ) {
var new_seqno = results.entities[i]["new_seqno"];
var new_seqno_formatted = results.entities[i]["new_seqno@OData.Community.Display.V1.FormattedValue"];
if(new_seqno ==null)//the lastest test(B) record seqno field is null, create a new record with 50000
{
var entity = {};
entity.new_name = "test500000";
entity.new_seqno = 50000;
Xrm.WebApi.online.createRecord("new_test", entity).then(
function success(result) {
var newEntityId = result.id;
},
function(error) {
Xrm.Utility.alertDialog(error.message);
}
);
}
else // create a new record with seqno 1
{
var seqno = new_seqno 1;
var entity = {};
entity.new_name = "test" seqno;
entity.new_seqno = seqno;
Xrm.WebApi.online.createRecord("new_test", entity).then(
function success(result) {
var newEntityId = result.id;
},
function(error) {
Xrm.Utility.alertDialog(error.message);
}
);
}
}
},
function(error) {
Xrm.Utility.alertDialog(error.message);
}
);
}
And Crm Rest Builder is a good tool to build request.
This is the download page for it: https://github.com/jlattimer/CRMRESTBuilder
1.retrieve one most recent test record.
2.Create test record(B) with specific seqno value.
3.Add the js code to OnSave event of the custom (A) entity.
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Thanks for your response, i am new to flows is there any possible way to achieve this with Javascript
Hi Sandy,
The flow can achieve it, here are steps:
In my example, custom(A) entity and test(B) entity have no relationship
1.Go Power Automate(https://us.flow.microsoft.com/en-us/ ) to create an Automated flow.
2.Create the Trigger event – in this case I have set the trigger to fire when a custom record is created.
2.Add ‘List records’ step, Retrieve one test record with a most recent Created On date value.
3.Add ‘compose’ step to get seqno value from ‘List records’ step.
Once you do this and fill in the fields, Flow takes care of the Apply to each loop. So don’t get confused by this and look for a Apply to each. You don’t need to do this.
4.In ‘Apply to each’ step, add ‘condition’ step to check seqno value is null or not.
(1) In ‘Yes’ branch,
Add ‘Compose’ step to convert seqno value to int and add 1.
Add ‘create a new record’ and fill seqno field with the value of ‘compose2’ step.
(2) In ‘No’ branch, add ‘create a new record’, fill seqno field with the 500000 value.
5.Save and test the flow.
The following is the overview of the flow:
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156