-
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

[Presentation] Salesforce Security – An Encryption Guide For The Paranoid
If you are using Salesforce, you would be having a lot of data stored in Salesforce objects. Some of it would be sensitive data, and…

Top 5 Salesforce Integrations in 2024 That Improve Business
Salesforce is widely recognized as a leading CRM software tool for businesses aiming to streamline their marketing and sales processes. To fully unlock its potential,…

How To Get Benefits From Salesforce Marketing Cloud?
Salesforce Marketing cloud earlier known as Exact Target provides digital marketing and analytical software and services. Salesforce blazed a trail by creating marketing cloud and…
Popular Salesforce Videos
Product Rule Vs Price Rule Salesforce CPQ
Product Rule CPQ product rules help ensure sales reps are putting together the right products and bundles every single time. You don’t have to worry…
Salesforce enthusiasts welcomes you to the Trailhead! Skill up for the future.
A trailhead is defined as an outdoor space that is designated by an entity responsible for administering or maintaining a trail to serve as an…
Salesforce Marketing Cloud Automation Studio
Automation Studio is a Marketing Cloud application used to execute multi-step marketing and data management activities on an immediate, triggered, or scheduled basis. Use Automation…