Recently, we had a requirement from one of our clients, wherein they wanted a page where user had to enter the Account Name. We were required to validate that account name and then do further processing.<\/p>\n
In below code snippets, we are checking if the Account name entered by the user is valid by querying on Account table\/object directly in the JavaScript code. To simplify the code, we have used the variable AccountName in JavaScript to specify the account name. if (qr.size == 0)<\/em><\/span> }<\/em><\/span><\/p>\n }<\/em><\/span> <input type=”button” onclick=”CallSOQL();” value=”Call SOQL Query”\/><\/apex:page><\/em><\/span><\/p>\n ———————————————————————-<snip><\/p>\n By using the above given code, you can query on any object or custom object of Salesforce without writing code on controller side.<\/span><\/p>\n Greytrix offers GUMU™ for Salesforce – Sage 300 (Accpac) Integration<\/a> a best of breed solution for organizations to enhance their customer interaction.<\/p>\n<\/blockquote>\n About Us<\/strong><\/span> Greytrix<\/a>\u00a0has some unique solutions for Cloud CRM such as Salesforce integration with\u00a0Sage Enterprise Management (Sage X3<\/a>),\u00a0Sage Intacct, Sage 100\u00a0<\/a>and\u00a0Sage 300 (Sage Accpac)<\/a>. We also offer best-in-class Cloud CRM\u00a0Salesforce customization and development services<\/a> along with services such as Salesforce Data Migration<\/a>, Integrated App development<\/a>, Custom App development<\/a> and Technical Support<\/a> to business partners and end users.<\/p>\n Greytrix GUMU™ integration for Sage ERP \u2013 Salesforce is a 5-star app listed on Salesforce AppExchange<\/a>.<\/p>\n For more information, please contact us at\u00a0salesforce@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":" Recently, we had a requirement from one of our clients, wherein they wanted a page where user had to enter the Account Name. We were required to validate that account name and then do further processing. In below code snippets, we are checking if the Account name entered by the user is valid by querying\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[5,68,194,290,397,403,405,473],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-gumu-salesforce","tag-account-name","tag-custom-object","tag-javascript","tag-query","tag-salesforce-integration","tag-salesforce-integration-with-sage-300-erp","tag-salesforce-integration-with-sage-x3","tag-soql-query"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/comments?post=7"}],"version-history":[{"count":8,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/7\/revisions"}],"predecessor-version":[{"id":3960,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/posts\/7\/revisions\/3960"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/media?parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/categories?post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/salesforce\/wp-json\/wp\/v2\/tags?post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n———————————————————————-<snip>
\n <apex:page ><\/em><\/span>
\n <script language=”JavaScript1.2″ src=”\/js\/functions.js”><\/script><\/em><\/span>
\n <script src=”\/soap\/ajax\/9.0\/connection.js” type=”text\/javascript”><\/script><\/em><\/span>
\n <script id=”clientEventHandlersJS” language=”javascript”><\/em><\/span>
\n function CallSOQL() <\/em><\/span>
\n {<\/em><\/span>
\n sforce.connection.sessionId = ‘{!$Api.Session_ID}’;<\/em><\/span>
\n try<\/em><\/span>
\n {<\/em><\/span>
\n alert(‘Select Name, Id From Account ORDER BY Name’);<\/em><\/span>
\n var AccountName=” TEST ACCOUNT”;<\/em><\/span>
\n var qr = sforce.connection.query(“SELECT id,name FROM Account where Name='”+ AccountName +”‘”);<\/em><\/span>
\n var records = qr.getArray(“records”);<\/em><\/span>
\n alert(‘qr ‘+qr);<\/em><\/span>
\n }<\/em><\/span>
\n catch (error)<\/em><\/span>
\n {<\/em><\/span>
\n alert(error.faultstring);<\/em><\/span>
\n }<\/em><\/span><\/p>\n
\n {<\/em><\/span>
\n alert(“No Record found.”);<\/em><\/span>
\n }<\/em><\/span>
\n else<\/em><\/span>
\n {<\/em><\/span>
\n for (var i=0;i<qr.records.length;i++)<\/em><\/span>
\n {<\/em><\/span>
\n alert(qr.records[i].Name);<\/em><\/span>
\n }<\/em><\/span><\/p>\n
\n <\/script><\/em><\/span><\/p>\n\n
\nGreytrix<\/a>\u00a0as a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners across the globe. We offers Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that requires apex code incorporation into the Salesforce platform.<\/p>\n