-
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 7 years, 10 months ago by Nick.
- This discussion was modified 7 years, 9 months ago by Forcetalks.
Log In to reply.
Popular Salesforce Blogs
Salesforce Sales Cloud Implementation - All You Need to Know
You’ve decided to use Salesforce, but now what? What do you need to be aware of? What comes out of the box and what will…
Why Need Salesforce Consulting Services For Your Business
Salesforce Consulting Services: Empowering Companies for Success during the Electronic Age In the present rapidly evolving enterprise landscape, harnessing the strength of technological know-how is…
Steps to enable Chatter and Social Media in Salesforce
Here we will learn how to enable social media and chatter in Salesforce. Let's start from a contact tab and see how it looks without…
Popular Salesforce Videos
Salesforce Admin Introduction - Salesforce Admin Tutorial
Salesforce Administrators work with stakeholders to define system requirements and customize the platform. To put it simply, they enable users to get the most out of…
Deep Dive into Salesforce Connected App
In this session, we will deep dive into Salesforce Connected app, its usage for Salesforce developers and admins, various options and configurations provided for Authentication…
Salesforce: Everything You Need to Know About Order Management
THE GOAL: Which Salesforce Order Management application is best? Well, that depends…. Salesforce offers three primary applications for order management, and they all work extremely…