1. What are validation rules?
Validation rule contains an error condition and error message. If evaluation of error condition results in true value, record is not saved, and the error message is generated. Validation rules can be attached to fields. They are executed when a record is created or updated.
2. Can we avoid deletion of records through validation rules?
No. Validation rules fire in insert and update operation.
3. Can we bypass validation Rules?
Validation rules can never be bypassed. If we have upload records and need to bypass validation, then deactivate validation rule and upload records. After upload, again activate validation rule.
4. Is it possible to fire validation only for records which is being getting updated not to newly inserted records?
Yes, We can use ISNEW() function which will return true whenever new record is getting created in validation rule. We can use this function and check our criteria only if ISNEW() function is returning false(means record is being updated).
5. Is there is any way through which validation rule is bypassed while doing upload through data loader but not when user is creating record from user interface?
Yes. Create a checkbox field as API upload and make this field hidden in page layout. Create a validation rule and in evaluation criteria first check if checkbox is false and then check other validation criteria.
Whenever user upload record through data loader, specify value for this checkbox as true in .csv file and then upload it to salesforce. While upload, validation rule will fire and will find checkbox value as true so it will not check other criteria and system will allow to upload records.
6. What is the difference between ISBLANK() AND ISNULL()?
ISNULL() works only for number data type fieds, if we don't populate with value for number fields it will return true.
ISNULL() won't support TEXT data type fields because text fields never become null.
ISBLANK() supports both number as well as text data types.
7. What are cross object formula fields?
Cross-object formulae span two or more objects by referencing merge fields. By using this you can refer parent fields from child record.
8. What are different ways to make field required in salesforce?
Yes. First create a roll up summary field on parent which calculates the total count of child records. Now write a validation rule on parent object which checks if previous value of total count is less than new value. If yes, then display error message.
Suppose field name is total_count__c in parent object then validation rule criteria will be:
Priorvalue(total_count__c) <total_count__c
When we delete the child record then roll up summary field value will get reduced by 1. System will update the parent record roll up summary field which will fire the validation rule and avoid user from deleting child record.
Validation rule contains an error condition and error message. If evaluation of error condition results in true value, record is not saved, and the error message is generated. Validation rules can be attached to fields. They are executed when a record is created or updated.
2. Can we avoid deletion of records through validation rules?
No. Validation rules fire in insert and update operation.
3. Can we bypass validation Rules?
Validation rules can never be bypassed. If we have upload records and need to bypass validation, then deactivate validation rule and upload records. After upload, again activate validation rule.
4. Is it possible to fire validation only for records which is being getting updated not to newly inserted records?
Yes, We can use ISNEW() function which will return true whenever new record is getting created in validation rule. We can use this function and check our criteria only if ISNEW() function is returning false(means record is being updated).
5. Is there is any way through which validation rule is bypassed while doing upload through data loader but not when user is creating record from user interface?
Yes. Create a checkbox field as API upload and make this field hidden in page layout. Create a validation rule and in evaluation criteria first check if checkbox is false and then check other validation criteria.
Whenever user upload record through data loader, specify value for this checkbox as true in .csv file and then upload it to salesforce. While upload, validation rule will fire and will find checkbox value as true so it will not check other criteria and system will allow to upload records.
6. What is the difference between ISBLANK() AND ISNULL()?
ISNULL() works only for number data type fieds, if we don't populate with value for number fields it will return true.
ISNULL() won't support TEXT data type fields because text fields never become null.
ISBLANK() supports both number as well as text data types.
7. What are cross object formula fields?
Cross-object formulae span two or more objects by referencing merge fields. By using this you can refer parent fields from child record.
8. What are different ways to make field required in salesforce?
- While field creation, specify required field as true.
- Through page layouts
- Validation rule
- Apex trigger
Yes. First create a roll up summary field on parent which calculates the total count of child records. Now write a validation rule on parent object which checks if previous value of total count is less than new value. If yes, then display error message.
Suppose field name is total_count__c in parent object then validation rule criteria will be:
Priorvalue(total_count__c) <total_count__c
When we delete the child record then roll up summary field value will get reduced by 1. System will update the parent record roll up summary field which will fire the validation rule and avoid user from deleting child record.
Tks very much for your post.
ReplyDeleteAvoid surprises — interviews need preparation. Some questions come up time and time again — usually about you, your experience and the job itself. We've gathered together the most common questions so you can get your preparation off to a flying start.
You also find all interview questions at link at the end of this post.
Source: Download Ebook: Ultimate Guide To Job Interview Questions Answers:
Best rgs
IEEE Project Domain management in software engineering is distinct from traditional project deveopment in that software projects have a unique lifecycle process that requires multiple rounds of testing, updating, and faculty feedback. A IEEE Domain project Final Year Projects for CSE system development life cycle is essentially a phased project model that defines the organizational constraints of a large-scale systems project. The methods used in a IEEE DOmain Project systems development life cycle strategy Project Centers in India provide clearly defined phases of work to plan, design, test, deploy, and maintain information systems.
DeleteThis is enough for me. I want to write software that anyone can use, and virtually everyone who has an internet connected device with a screen can use apps written in JavaScript. JavaScript Training in Chennai JavaScript was used for little more than mouse hover animations and little calculations to make static websites feel more interactive. Let’s assume 90% of all websites using JavaScript use it in a trivial way. That still leaves 150 million substantial JavaScript Training in Chennai JavaScript applications.
This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.
ReplyDeleteSalesforce Training in Chennai
Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
ReplyDeleteAndroid Training in Chennai
Ios Training in Chennai
Sorry to be frank and straignt forward, I have been attending interviews from 3 months, None of them asked like this STRAIGHT forward questions, these are very good for those TRAINERS but Not at all for Real time interviews.
ReplyDeleteWhat kid of questions were you asked?
DeleteThis comment has been removed by the author.
ReplyDeleteFor Ques#9 conditions should be Priorvalue(total_count__c) >total_count__c
ReplyDeleteI think NO...
Deleteand Author made no Mistake...
This comment has been removed by the author.
DeleteValidation rule can be bypassed by selecting "ignore validation" in user detail page.The provided answer is not correct.
ReplyDeletePlease explain how this is possible. Thanks.
DeleteThis is an awesome post. Really very informative and creative contents.
ReplyDeleteios app Devlopment company in chennai
This is brilliant. Kudos!
ReplyDeleteSmart Outsourcing Solutions is the leading web development, ecommerce solution, offshore outsourcing development and freelancing training company in Dhaka Bangladesh please
ReplyDeletevisit us: seo service company in bangladesh
seo service in bangladesh
In 9th question this is the correct logic:
ReplyDelete"PRIORVALUE( counting__c ) > counting__c"
I mean use > symbol.if you have used < , then you'll not be able to retrive the deleted child back from the recycle bin.
Yeah i think he is right,it's working
DeleteCan we bypass validation Rules?
ReplyDeleteYes -using Permission Set we can bypass validation Rules
Thank you for sharing.
ReplyDeleteData Science Online Training
Python Online Training
Salesforce Online Training
ReplyDeleteThanks, this is generally helpful.
Still, I followed step-by-step your method in this salesforce cpq online training
salesforce cpq course
Really helpful content. These are all repetitive and very important questions which interviewers asks all the time. Thank you!!
ReplyDeleteThanks, this is generally helpful.
ReplyDeletesalesforce cpq training
Visit us: salesforce cpq course
This article will outline all the different strategies you should be aware of when it comes to soccer.
ReplyDeletebest ias coaching in india
Escort Service In Gurgaon - Our call girls agency is ready to meet your all needs. They are enjoying most seductive female call Girls from different parts of the World. Have you ever date any female in your life? If no then you do not know the real taste of dating fun with a call girl. Then our Gurgaon Escorts service will help you to tackle your dreams with one of the independent female escort agencies.
ReplyDeleteEscort Service In Gurgaon
https://www.kajalvermas.com/escort-service-in-gurgaon/
very very informative post for me thanks for sharing
ReplyDeleteBlockchaincClassroom Training Course in Bangalore
Very interesting blog.Thanks for sharing.
ReplyDeleteVisit us: ui path online training
Visit us: uipath training in hyderabad
Visit us: ui path course in bangalore
Call girls in noida Noida Call girls escort girls noida escort girls in noida escort services in noida noida escort escort delhi Call girls noida Call girls service noida Call girls in noida Call girls in noida escort services delhi high profile Call girls in noida noida Call girls Call girl services in noida noida escort girls escorts in noida Call girls services in delhi escort girls in noida desi Call girls in noida cheap Call girls in noida Delhi Call Girls Noida Call girls Independent Call girls in Delhi Escort girls in noida escort services in delhi Escort girls in noida Escorts in noida Call girls in gurgaon Escort Services in noida
ReplyDeletecall girl in noida
call girls in noida
noida escorts service
escorts in noida
call girl in noida
ReplyDeletecall girls in noida
noida escorts service
escorts in noida
escort service in noida
noida escorts
Call girls in south delhi
south delhi Call girls
escorts in south delhi
south delhi escorts
delhi escorts
call girls in delhi
Delhi Call girls
Call girls
escorts
russian girls in delhi
escorts in delhi
delhi russian escorts
Russian escorts in delhi
escorts in delhi
ReplyDeletedelhi escorts
Call girls in delhi
delhi call girls
call girls
escorts
call girls delhi
escorts service in delhi
independent escorts in delhi
independent call girls in delhi
call girls in Aerocity
escorts in aerocity
escort services in Gurgaon
Call girls in Gurgaon
Gurgaon Call girls
Delhi Call girls whatsapp number
call girls whatsapp number
escort whatsapp number
call girls near me
escorts near me
women seeking men
women seeking men in delhi
call girl in Gurgaon
call girls in Gurgaon
Gurgaon escorts service
escorts in Gurgaon
escort service in Gurgaon
Gurgaon escorts
Call girls in south Gurgaon
Gurgaon Call girls
escorts in gurgaon
ReplyDeletegurgaon escorts
gurgaon escort
call girls in gurgaon
gurgaon escort service
escort services
call girls gurgaon
call girls in aerocity
escorts in aerocity
aerocity escorts
call girls whatsapp number
call girls whatsapp group
escorts service in mahipalpur
call girls in mahipalpur
escorts in mahipalpur
women seeking men in delhi
hot videos
call girls in delhi
delhi escorts
escorts in delhi
call girls in South delhi
call girls in Aerocity
call girl near me
ReplyDeletecall girls near me
call girls whatsapp number
call girls whatsapp group
escort service in noida
call girl in noida
call girls in noida
noida escorts service
escorts in noida
call girls in mahipalpur
mahipalpur escorts
escorts in mahipalpur
mahipalpur escort service
cheap escorts in delhi
cheap delhi escorts
cheap call girls in delhi
delhi call girls
women seeking men in delhi
call girl near me
ReplyDeletecall girls near me
call girls whatsapp number
call girls whatsapp group
escort service in noida
call girl in noida
call girls in noida
noida escorts service
escorts in noida
call girls in gurgaon
gurgaon escorts
escorts in gurgaon
gurgaon escort service
escorts in delhi
delhi escorts
call girls in delhi
delhi call girls
women seeking men in delhi
cheap call girls in delhi
cheapdelhi escorts
cheap escorts in delhi
call girls in delhi
escorts in delhi
call girls whatsapp number
ReplyDeletecall girls whatsapp group
escort service in noida
call girl in noida
call girls in noida
noida escorts service
escorts in noida
call girls in mahipalpur
mahipalpur escorts
escorts in mahipalpur
mahipalpur escort service
cheap escorts in delhi
call girls in delhi photos
delhi call girls photos
women seeking men in delhi
women seeking men
Hot And Sexy Independent Model Escort Service In Delhi Unlimited Enjoy Genuine 100% Profiles And Trusted Door Step Call Girls Feel Free To Call Us 24/7Hours Opens Thanks..
ReplyDeleteCall girls in Noida
Noida Call Girls
Escorts in Noida
Noida Escorts
Do you Need Instant Loan from $2,000 to $50,000,000.00 with no collateral required and receive a no obligation loan approval.We welcome the opportunity to show you how effective we are at helping our clients obtain the money they need to succeed. Our professional staff is available for a Free Consultation.At Patiala legitimate company Pvt , contact us now 2% interest rate, both long and short term cash reply to us (Whats App) number: +919394133968 patialalegitimate515@gmail.com
ReplyDeleteMr Jeffery
salesforce online training in hyderabad
ReplyDeletesalesforce online training hyderabad
Liên hệ Aivivu, đặt vé máy bay tham khảo
ReplyDeletevé máy bay đi Mỹ Vietnam Airline
đăng ký bay từ mỹ về việt nam
khi nào có chuyến bay từ đức về việt nam
giá vé máy bay từ moscow về hà nội
các chuyến bay từ anh về việt nam
chuyến bay từ pháp về việt nam
Chi phi cho chuyen gia nuoc ngoai
HOW I GO MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY LAST WEEK. Email for immediate response: drbenjaminfinance@gmail.com
ReplyDeleteHello everyone, Am here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr.Benjamin Scarlet Owen he holds all of the information about how to obtain money quickly and painlessly via Email: drbenjaminfinance@gmail.com
and consider all your financial problems tackled and solved. Share this to help a soul right now, Thanks
Data Validation Security System
ReplyDeleteData Validation Security System - Pharmacies: Monitoring and recording of the environmental conditions of medical supplies storage Captemp.com.
tiktok jeton hilesi
ReplyDeletetiktok jeton hilesi
referans kimliği nedir
gate güvenilir mi
tiktok jeton hilesi
paribu
btcturk
bitcoin nasıl alınır
yurtdışı kargo
Watch and Download world's famous Turkish action drama Kurulus Osman Season 3 in English on link below
ReplyDelete👇
Kurulus Osman Season 3
Kurulus Osman Season 3 Episode 1
On link below
Kurulus Osman Season 3 Episode 1
Crypto trading course
Join on link below
Crypto quantum leap
YouTube course
Be a professional YouTuber and start your carrier
Tube Mastery and Monetization by matt
Best product for tooth pain ,
Cavity ,
Tooth decay ,
And other oral issues
Need of every home
With discount
And digistore money back guarantee
Steel Bite Pro
Admin please remove the unwanted comments
ReplyDeleteWelcome to the future! Financing made easy with Prof. Mrs. DOROTHY LOAN INVESTMENTS
ReplyDeleteHello, Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. DOROTHY JEAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via profdorothyinvestments@gmail.com
We invest in all profitable projects with cryptocurrencies. I'm here to share an amazing life changing opportunity with you. its called Bitcoin / Forex trading options, Are you interested in earning a consistent income through binary/forex trade? or crypto currency trading. An investment of $100 or $200 can get you a return of $2,840 in 7 days of trading and you get to do this from the comfort of your home/work. It goes on and on The higher the investment, the higher the profits. Your investment is safe and secured and payouts assured 100%. if you wish to know more about investing in Cryptocurrency and earn daily, weekly OR Monthly in trading on bitcoin or any cryptocurrency and want a successful trade without losing Contact MRS.DOROTHY JEAN INVESTMENTS profdorothyinvestments@gmail.com
categories of investment
Cryptocurrency
Loan Offer
Mining Plan
Business Finance Plan
Binary option Trade Plan
Forex trade Plan
Stocks market Trade Plan
Return on investment (ROI) Plan
Gold and Silver Trade Plan
Oil and Gas Trade Plan
Diamond Trade Plan
Agriculture Trade Plan
Real Estate Trade Plan
YOURS IN SERVICE
Mrs. Dorothy Pilkenton Jean
Financial Advisor on Bank Instruments,
Private Banking and Client Services
Email Address: profdorothyinvestments@gmail.com
Operation: We provide Financial Service Such As Bank Instrument
From AA Rate Banks, Cash Loan,BG,SBLC,BOND,PPP,MTN,TRADING,FUNDING MONETIZING etc.
İnstagram takipçi satın al! İnstagram takipçi sitesi ile takipçi satın al sende sosyal medyada fenomen olmaya bir adım at. Sende hemen instagram takipçi satın almak istiyorsan tıkla:
ReplyDelete1- takipçi satın al
2- takipçi satın al
3- takipçi satın al
Welcome to the future! Financing made easy with Prof. Mrs. DOROTHY JEAN INVESTMENTS
ReplyDeleteHello, Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. DOROTHY JEAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via profdorothyinvestments@gmail.com
We invest in all profitable projects with cryptocurrencies. I'm here to share an amazing life changing opportunity with you. its called Bitcoin / Forex trading options, Are you interested in earning a consistent income through binary/forex trade? or crypto currency trading. An investment of $100 or $200 can get you a return of $2,840 in 7 days of trading and you get to do this from the comfort of your home/work. It goes on and on The higher the investment, the higher the profits. Your investment is safe and secured and payouts assured 100%. if you wish to know more about investing in Cryptocurrency and earn daily, weekly OR Monthly in trading on bitcoin or any cryptocurrency and want a successful trade without losing Contact MRS.DOROTHY JEAN INVESTMENTS Email profdorothyinvestments@gmail.com
YOURS IN SERVICE
Mrs. Dorothy Pilkenton Jean
Financial Advisor on Bank Instruments,
Private Banking and Client Services
Email Address: profdorothyinvestments@gmail.com
Operation: We provide Financial Service Such As Bank Instrument
From AA Rate Banks, Cash Loan,BG,SBLC,BOND,PPP,MTN,TRADING,FUNDING MONETIZING etc.
thank you sir i liked your post very much can you give me any tip so that i can start my new blog i try very hard to make a good block but i can not make so sir please help me
ReplyDeleteGurgaon Sector 74 Service Girls
Gurgaon Sector 76 Service Girls
Gurgaon Sector 80 Service Girls
Gurgaon Sector 81 Service Girls
Gurgaon Sector 82 Service Girls
Gurgaon Sector 83 Hot Service Girls
What Is Salesforce in Hindi
ReplyDeleteVery good information.
ReplyDeleteSalesforce Training
kya aap bhi chhote penis se pareshan hain toh aap fr aap market se penis size badhane ki dava oil use karke bada aur mota kare skte hain aise karne se aap ka ling bhi bada hoga aur uska size mota hoga aur sath hi sath aapki sex karni ki timing bhi badegi
ReplyDeleteThe principal region is in choosing the lawyer and the subsequent region is botches made in the wake of choosing the lawyer.
ReplyDeleteBrain Injury Attorneys