Salesforce Interview Preparation Toolkit Formula and Validation Rules in SalesForce

Please download to get full document.

View again

of 18
46 views
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.

Download

Document Related
Document Description
BISP is committed to provide BEST learning material to the beginners and advance learners. In the same series, we have prepared a complete end-to end Hands-on Beginner’s Guide for SalesForce. The document focuses on some common interview questions related to Formulas and Validation Rules. Join our professional training program and learn from experts.
Document Share
Document Tags
Document Transcript
  Salesforce Interview Preparation Toolkit Formula and Validation Rules in SalesForce CRM Description:  BISP is committed to provide BEST learning material to the beginners and advance learners. In the same series, we have prepared a complete end-to end Hands-on Beginner’s Gide !or Sales orce. The docment !ocses on some common interview #estions related to ormlas and $alidation %les. &oin or pro!essional training program and learn !rom e'perts. History: Version Description Change Author Publish Date0.1 Initial Draft Chandra Prakash har!a10  th  Apr 01#0.1 $e%ie&'1 A!it har!a 10  th  Apr 01# www.bispsolutions.com www.bisptrainigs.com www.hyperionguru.com Page 1  Question : 1 SAP_Account_Id__c and Navison_Account_Id__c are two Text fields, Sell_to__c and Ship_to__c are two checkboxes. The rule should ensure that a record which has either SAP_Account_Id__c or Navison_Account_Id__c filled in or both!, can be saved onl if either Sell_to__c and Ship_to__c or both! are checked. Solution : #o to Setup  $ Create  $ Objects  $ Select ob%ect na&e'x( Sap Account!, then )o to down select *alidation rule +lick on New  button, ou can see below. Then write here validation rule ou can see below. Note : If ou need !ot c ec# bo$ c ec# use t is Validation% www.bispsolutions.com www.bisptrainigs.com www.hyperionguru.com Page   - IS/0AN SAP_Account_Id__c ! , IS/0AN Navison_Account_Id__c ! ,I2 Sell_to__c 3 false, true ,false! ,I2 ship_to__c 3 false, true ,false! ! Question : & +reate a validation rule that when 4 _+heck__c is unchecked, the Text2ield1__c and Text2ield__c should have no values. Solution : /elow is validation ule .. Code : - 'M(C ec#((c)) F*+S, -  OR' IS!+*N.' /e$tField1((c 0 - IS!+*N.' /e$tField&((c 0 0 0 0 www.bispsolutions.com www.bisptrainigs.com www.hyperionguru.com Page 5  Question  : Validation rule for currenc wit & decimal 2alues,$ample :  *alid( 1.66, 1.16, 1.61, 1.78Not *alid( 1, 1.1, 1.6,1.65 Solution : NO/'R,3,4'5rice((c-6789;<7%;=1>789;=&>600 Question ? : Appl to for&ula to the field which depends on so&e other field. I created a picklist field which contains /-9, +lass:A, +lass:/, +lass:+. If an one selected /-9 in that picklist field then auto&aticall Ticket fare has to reflect as 166,if the selected +lass:A then ;7 has to reflect and so on. Solution :   www.bispsolutions.com www.bisptrainigs.com www.hyperionguru.com Page <
Search Related
Next Slide

102_12_Yoshida

We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x