how to write a trigger on account object if the existing record then update some fields accordoing to you...











up vote
-1
down vote

favorite












how to write a trigger on account object(salesfroce) if the existing record then update some fields according to you else create a new Records ?



Thanks










share|improve this question


























    up vote
    -1
    down vote

    favorite












    how to write a trigger on account object(salesfroce) if the existing record then update some fields according to you else create a new Records ?



    Thanks










    share|improve this question
























      up vote
      -1
      down vote

      favorite









      up vote
      -1
      down vote

      favorite











      how to write a trigger on account object(salesfroce) if the existing record then update some fields according to you else create a new Records ?



      Thanks










      share|improve this question













      how to write a trigger on account object(salesfroce) if the existing record then update some fields according to you else create a new Records ?



      Thanks







      salesforce






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 10 at 2:49









      aklim

      1




      1
























          2 Answers
          2






          active

          oldest

          votes

















          up vote
          0
          down vote













          How about using upsert? It allows you to either insert record or update if it already exists. insert and update in a single, smart command.
          You want to update record, and if it does not exist, create new one.
          With upsert you can first try to obtain record (if nothing found, create new instance), then set your fields up, and finally, upsert it.



          Like:



          Account myAcc;
          try {
          myAcc = [ SELECT Id, Name FROM Account where Id='someIdImLookingFor'];
          myAcc.Name = 'My desired name';
          catch (Exception e) {
          myAcc = new Account(Name='My desired name');
          }
          upsert myAcc





          share|improve this answer






























            up vote
            0
            down vote













            'Upsert' is the best way to do that. If the record is present it helps you to update the record else create a new one.



            Account acctsList = [SELECT Id, Name, BillingCity FROM Account WHERE BillingCity = 'Bombay'];
            for (Account a : acctsList) {
            a.BillingCity = 'Mumbai';
            }
            Account newAcct = new Account(Name = 'Acme', BillingCity = 'San Francisco');
            acctsList.add(newAcct);
            try {
            upsert acctsList;
            } catch (DmlException e) {
            // Process exception here
            }





            share|improve this answer





















              Your Answer






              StackExchange.ifUsing("editor", function () {
              StackExchange.using("externalEditor", function () {
              StackExchange.using("snippets", function () {
              StackExchange.snippets.init();
              });
              });
              }, "code-snippets");

              StackExchange.ready(function() {
              var channelOptions = {
              tags: "".split(" "),
              id: "1"
              };
              initTagRenderer("".split(" "), "".split(" "), channelOptions);

              StackExchange.using("externalEditor", function() {
              // Have to fire editor after snippets, if snippets enabled
              if (StackExchange.settings.snippets.snippetsEnabled) {
              StackExchange.using("snippets", function() {
              createEditor();
              });
              }
              else {
              createEditor();
              }
              });

              function createEditor() {
              StackExchange.prepareEditor({
              heartbeatType: 'answer',
              convertImagesToLinks: true,
              noModals: true,
              showLowRepImageUploadWarning: true,
              reputationToPostImages: 10,
              bindNavPrevention: true,
              postfix: "",
              imageUploader: {
              brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
              contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
              allowUrls: true
              },
              onDemand: true,
              discardSelector: ".discard-answer"
              ,immediatelyShowMarkdownHelp:true
              });


              }
              });














              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53235618%2fhow-to-write-a-trigger-on-account-object-if-the-existing-record-then-update-some%23new-answer', 'question_page');
              }
              );

              Post as a guest















              Required, but never shown

























              2 Answers
              2






              active

              oldest

              votes








              2 Answers
              2






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes








              up vote
              0
              down vote













              How about using upsert? It allows you to either insert record or update if it already exists. insert and update in a single, smart command.
              You want to update record, and if it does not exist, create new one.
              With upsert you can first try to obtain record (if nothing found, create new instance), then set your fields up, and finally, upsert it.



              Like:



              Account myAcc;
              try {
              myAcc = [ SELECT Id, Name FROM Account where Id='someIdImLookingFor'];
              myAcc.Name = 'My desired name';
              catch (Exception e) {
              myAcc = new Account(Name='My desired name');
              }
              upsert myAcc





              share|improve this answer



























                up vote
                0
                down vote













                How about using upsert? It allows you to either insert record or update if it already exists. insert and update in a single, smart command.
                You want to update record, and if it does not exist, create new one.
                With upsert you can first try to obtain record (if nothing found, create new instance), then set your fields up, and finally, upsert it.



                Like:



                Account myAcc;
                try {
                myAcc = [ SELECT Id, Name FROM Account where Id='someIdImLookingFor'];
                myAcc.Name = 'My desired name';
                catch (Exception e) {
                myAcc = new Account(Name='My desired name');
                }
                upsert myAcc





                share|improve this answer

























                  up vote
                  0
                  down vote










                  up vote
                  0
                  down vote









                  How about using upsert? It allows you to either insert record or update if it already exists. insert and update in a single, smart command.
                  You want to update record, and if it does not exist, create new one.
                  With upsert you can first try to obtain record (if nothing found, create new instance), then set your fields up, and finally, upsert it.



                  Like:



                  Account myAcc;
                  try {
                  myAcc = [ SELECT Id, Name FROM Account where Id='someIdImLookingFor'];
                  myAcc.Name = 'My desired name';
                  catch (Exception e) {
                  myAcc = new Account(Name='My desired name');
                  }
                  upsert myAcc





                  share|improve this answer














                  How about using upsert? It allows you to either insert record or update if it already exists. insert and update in a single, smart command.
                  You want to update record, and if it does not exist, create new one.
                  With upsert you can first try to obtain record (if nothing found, create new instance), then set your fields up, and finally, upsert it.



                  Like:



                  Account myAcc;
                  try {
                  myAcc = [ SELECT Id, Name FROM Account where Id='someIdImLookingFor'];
                  myAcc.Name = 'My desired name';
                  catch (Exception e) {
                  myAcc = new Account(Name='My desired name');
                  }
                  upsert myAcc






                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited Nov 10 at 9:45

























                  answered Nov 10 at 8:13









                  ogrodowiczp

                  216




                  216
























                      up vote
                      0
                      down vote













                      'Upsert' is the best way to do that. If the record is present it helps you to update the record else create a new one.



                      Account acctsList = [SELECT Id, Name, BillingCity FROM Account WHERE BillingCity = 'Bombay'];
                      for (Account a : acctsList) {
                      a.BillingCity = 'Mumbai';
                      }
                      Account newAcct = new Account(Name = 'Acme', BillingCity = 'San Francisco');
                      acctsList.add(newAcct);
                      try {
                      upsert acctsList;
                      } catch (DmlException e) {
                      // Process exception here
                      }





                      share|improve this answer

























                        up vote
                        0
                        down vote













                        'Upsert' is the best way to do that. If the record is present it helps you to update the record else create a new one.



                        Account acctsList = [SELECT Id, Name, BillingCity FROM Account WHERE BillingCity = 'Bombay'];
                        for (Account a : acctsList) {
                        a.BillingCity = 'Mumbai';
                        }
                        Account newAcct = new Account(Name = 'Acme', BillingCity = 'San Francisco');
                        acctsList.add(newAcct);
                        try {
                        upsert acctsList;
                        } catch (DmlException e) {
                        // Process exception here
                        }





                        share|improve this answer























                          up vote
                          0
                          down vote










                          up vote
                          0
                          down vote









                          'Upsert' is the best way to do that. If the record is present it helps you to update the record else create a new one.



                          Account acctsList = [SELECT Id, Name, BillingCity FROM Account WHERE BillingCity = 'Bombay'];
                          for (Account a : acctsList) {
                          a.BillingCity = 'Mumbai';
                          }
                          Account newAcct = new Account(Name = 'Acme', BillingCity = 'San Francisco');
                          acctsList.add(newAcct);
                          try {
                          upsert acctsList;
                          } catch (DmlException e) {
                          // Process exception here
                          }





                          share|improve this answer












                          'Upsert' is the best way to do that. If the record is present it helps you to update the record else create a new one.



                          Account acctsList = [SELECT Id, Name, BillingCity FROM Account WHERE BillingCity = 'Bombay'];
                          for (Account a : acctsList) {
                          a.BillingCity = 'Mumbai';
                          }
                          Account newAcct = new Account(Name = 'Acme', BillingCity = 'San Francisco');
                          acctsList.add(newAcct);
                          try {
                          upsert acctsList;
                          } catch (DmlException e) {
                          // Process exception here
                          }






                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Nov 19 at 9:55









                          Sivaraman J

                          11




                          11






























                              draft saved

                              draft discarded




















































                              Thanks for contributing an answer to Stack Overflow!


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.





                              Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                              Please pay close attention to the following guidance:


                              • Please be sure to answer the question. Provide details and share your research!

                              But avoid



                              • Asking for help, clarification, or responding to other answers.

                              • Making statements based on opinion; back them up with references or personal experience.


                              To learn more, see our tips on writing great answers.




                              draft saved


                              draft discarded














                              StackExchange.ready(
                              function () {
                              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53235618%2fhow-to-write-a-trigger-on-account-object-if-the-existing-record-then-update-some%23new-answer', 'question_page');
                              }
                              );

                              Post as a guest















                              Required, but never shown





















































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown

































                              Required, but never shown














                              Required, but never shown












                              Required, but never shown







                              Required, but never shown







                              Popular posts from this blog

                              Paul Cézanne

                              UIScrollView CustomStickyHeader Resize height generates problems when scroll is too fast

                              Angular material date-picker (MatDatepicker) auto completes the date on focus out