-
What is the formula syntax when making a checkbox True or False from values collected from a Text Field?
I have Master Detail object, named Agent__c, with a lookup text field named, Member__c, it has a child object related to it, Badges__c. Up to 6 related records can be created for the Member__c field [BadgeName01, BadgeName02, etc.] and each related record named differently (see below) and I would like to create 6 separate checkboxes to show True when any of the 6 related records has a value.
I am going to create 6 custom checkboxes with values of:
Check Awards__c
Check Paper__c
Check Rock__c
Check Scissor__c
Check Water__c
Check Air__cIf a value is present from the Member__c field, it should trigger a True value on the checkbox relating to it.
Can someone help me out on this one?
Below is more information about the objects and fields names.
When a member is created, it creates an Id according the which record is created.
The Member__c field choices are:Member Awards
Member Paper
Member Rock
Member Scissor
Member Water
Member AirAPI Custom Object Names:
Agent__c [contains the Member__c record field]
Badges__c [contains the badges name record field]
CheckXXXX__c [contains the True/False values and should be located on the Agent custom object]This is my diagram, hope it helps!
Thank you in advance!
-
This discussion was modified 8 years, 7 months ago by
Nick.
-
This discussion was modified 8 years, 7 months ago by
Forcetalks.
-
This discussion was modified 8 years, 7 months ago by
-
2 Replies
-
Hi Nick,
You can do this using salesforce automation tool like workflow and Process builder. As per the above requirement you have to create multiple workflow rule for each field update(checkbox) and same goes for process builder.
I think best way to achieve this to write a trigger on Agent that will update your checkbox field by checking member name.
Here is code that I have written that is working fine in my org.
trigger UpdateAgent on Agent__c (before insert) {
Set<Id> setOfmember = new set<Id>();
Map<Id, Badges__c> mapToStoreMemberName;
String member;for(Agent__c agent : trigger.new){
setOfmember.add(agent.Member__c);
}mapToStoreMemberName= new Map<Id, Badges__c>([select id, Name from Badges__c where id in : setOfmember]);
for(Agent__c agent : trigger.new){
member = mapToStoreMemberName.get(agent.Member__c).Name;
if(member == 'Member Awards'){
agent.Check_Awards__c = true;
}
else if(member == 'Member Paper'){
agent.Check_Paper__c = true;
}
else if(member == 'Member Scissor'){
agent.Check_Scissor__c = true;
}
else if(member == 'Member Water'){
agent.Check_Water__c = true;
}else if(member == 'Member Air'){
agent.Check_Air__c = true;
}}
}
Please do let me know if you face any issues.
-
Hi Ravi,
Thank you for taking the time to write out this APEX trigger. I tested it out in sandbox, and pushed to production and with some slight modifications, it is working just great! I had gone down the path of creating these in process builder, but was getting a little messy.
I appreciate this!
Many thanks!
Log In to reply.
Popular Salesforce Blogs
What is Dreamforce? : A Brief Overview
With Dreamforce 2019 around the corner, the buzz has already started doing rounds on social media. For the Trailblazers (employees, community members, customers, and partners), Dreamforce is…
Top Considerations in Choosing the Right Salesforce Development Partner
Salesforce is the world’s leading and one of the most powerful CRM platforms that can redefine your digital journey, foster stronger brand loyalty and engagement,…
CRM Implementation Made Easy: A Step-by-Step Guide for Success
According to CIO magazines, almost one-third of the CRM efforts fail. But why? Well, the wrong CRM implementation makes it difficult for businesses to manage…
Popular Salesforce Videos
Reassign Leads using Lead Assignment Rule on Update/Upsert | Salesforce Tutorials | #SalesforceBolt
In this vlog, we will do some work around Assignment Rules. As you are aware Assignment Rule can be trigger on Insert actions. Either it…
Top 4 Ways Sales Leaders at Salesforce Use Einstein Analytics
Here's a peek behind the curtain at four of the top ways sales leaders at Salesforce use Einstein Analytics to manage pipeline and coach their…
Difference between Profile and Roles in Salesforce
Learn about the difference between Profile and Roles? Watch this video and do let us know if you have any questions or concerns.
