You need to sign in to do that
Don't have an account?
Jeff Rozner 39
I'm trying to check or uncheck Checkbox field, if another Field that is a Picklist has a value that matches a picklist value
Kind of a noob, sorry fo not knowing the right answer here...does this seem to be on the right track?
IF(ISPICKVAL(Status, "Subscribed"),
Marketing_Cloud_Subscriber__c.Status__c = False;
else if (ISPICKVAL(Status, "Unsubscribed"),
Marketing_Cloud_Subscriber__c.Status__c = True;
IF(ISPICKVAL(Status, "Subscribed"),
Marketing_Cloud_Subscriber__c.Status__c = False;
else if (ISPICKVAL(Status, "Unsubscribed"),
Marketing_Cloud_Subscriber__c.Status__c = True;
there are 3 possible picklist values: subscribed, unsubscribed , and no preference. i want to set the value of the status checkbox to "Checked" (or True, I guess) if the picklist value equals 'unsubscribed" ,to set the value of the status checkbox to "Unchecked" (or False, I guess) if the picklist value equals "subscribed"
Please try out the below formula:
If( text( Testing_Checkbox__c ) =='subscribed' || text(Testing_Checkbox__c) =='preference',false,true )
Here Testing_Checkbox__c is the Picklist field holding 3 values ( subscribed, unsubscribed , no preference.)
NOTE : : Since you got 3 values, assuming that one value has to be checked and the remaining two will be unchecked.
In this , As of now i am only Checking the Unscribed Field to Checked and for other two values its unchecked.
You can try tweaking this based on your requirement or let us know if my any changes in the requirement.
Regrds,
Rabi