-
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
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.