You need to sign in to do that
Don't have an account?
Ravikant kedia
I have a problem in formula field.
I have 10 checkbox fields with labels Checkbox1, Checkbox2, Checkbox3, Checkbox4, ------ So on .
And I have a formula field that return selected checkbox label with comma(,) separated values like Checkbox1, Checkbox2, Checkbox3, and so on.
Example : I select 4 chekbox , Checkbox 1, Checkbox 3, Checkbox 9, Checkbox 5 and formula will return Checkbox 1,Checkbox 3, Checkbox 5, Checkbox 9.
So how i can implement this functionality in minimum step as possible .So please help me to resolve this issuse as soon as possible.
Thanks in Advance.
And I have a formula field that return selected checkbox label with comma(,) separated values like Checkbox1, Checkbox2, Checkbox3, and so on.
Example : I select 4 chekbox , Checkbox 1, Checkbox 3, Checkbox 9, Checkbox 5 and formula will return Checkbox 1,Checkbox 3, Checkbox 5, Checkbox 9.
So how i can implement this functionality in minimum step as possible .So please help me to resolve this issuse as soon as possible.
Thanks in Advance.
It looks like that is not possible using formula field. you must need to use apex trigger for it.
Below is apex trigger with trigger handler class which you can use for your scenario.
Here some assumption
Trigger is for account object = you can use your object
Result_Field__c = Text or TextArea field where you want to display the result like comma separated string
Apex Trigger
Apex Class
Thanks and Cheers,
Jigar
Greetings!
1. First, Null Check of all the checkboxes.
2. Then check IsBlank of the checkboxes.
3. If all true,
4. In the true body, write your logic.
If you find your Solution then mark this as the best answer.
Thank you!
Regards,
Suraj Tripathi