You need to sign in to do that
Don't have an account?
Ramk123
Update Long Text area field based multi Select Pick list Value selected
I have Review(Multi-Select Picklist) field with values following.
101(Previous grant)
101(No Expectation)
101(Sufficient Income)
101(Long Term)
Based on the above values selected update Review Log (Long Text Area) field.
I tried like below, but am getting an error message like "Error Field Review__c may not be used in this type of formula "
IF(INCLUDES( Review__c, "101(Not Unforeseen)"), "$Label.X101_Not_Unforeseen", NULL ) + BR() +
IF(INCLUDES( Review__c, "101(Previous grant)"), "$Label.Previous_grant", NULL ) + BR() +
IF(INCLUDES( Review__c, "101(No Expectation)"), "$Label.No_Expectation", NULL ) + BR() +
IF(INCLUDES( Review__c, "101(Sufficient Income)"), "$Label.X101_Sufficient_Income", NULL ) + BR() +
IF(INCLUDES( Review__c, "101(Long Term)"), "$Label.X101_Long_Term", NULL )
Note: Long Text referring from Label
Appreciate quick help on this!
101(Previous grant)
101(No Expectation)
101(Sufficient Income)
101(Long Term)
Based on the above values selected update Review Log (Long Text Area) field.
I tried like below, but am getting an error message like "Error Field Review__c may not be used in this type of formula "
IF(INCLUDES( Review__c, "101(Not Unforeseen)"), "$Label.X101_Not_Unforeseen", NULL ) + BR() +
IF(INCLUDES( Review__c, "101(Previous grant)"), "$Label.Previous_grant", NULL ) + BR() +
IF(INCLUDES( Review__c, "101(No Expectation)"), "$Label.No_Expectation", NULL ) + BR() +
IF(INCLUDES( Review__c, "101(Sufficient Income)"), "$Label.X101_Sufficient_Income", NULL ) + BR() +
IF(INCLUDES( Review__c, "101(Long Term)"), "$Label.X101_Long_Term", NULL )
Note: Long Text referring from Label
Appreciate quick help on this!
Use the apex trigger and below are the sample.
Please try it and let me know if you facing any issues.
Thanks & Regards,
Sakthivel Madesh
All Answers
from which way you are trying to update Review Log (Long Text areafield), using trigger/workflow field update/process builder?
Please confirm to help further!
Thanks & Regards,
Sakthivel Madesh
Thank you much for the quick response!
The above formula I wrote in Review(Text area) field.
Workflow, Process builder, and Trigger are also a good idea.
Could you please suggest me the best solutions?
Thank you much for the quick response!
If possible workflow/Process builder, otherwise Trigger.
Could you please suggest me the best solutions?
Thanks,
Ramesba
Use the apex trigger and below are the sample.
Please try it and let me know if you facing any issues.
Thanks & Regards,
Sakthivel Madesh