I want to create a date field that provides me with the last delivery date if the service session contains the words "Food Pantry". That is a variable (field) that will interact between multiple objects. Specifically, the Service Session Object (pmdm__ServiceSession__c) and the Service Delivery Object (pmdm__ServiceDelivery__c).
I have the following variables:
- Service Name (Service_Name__c) - Delivery Date (pmdm__DeliveryDate__c) - Service Session (pmdm__ServiceSession__c)
My intention is to add that field to the client record and it will tell me when the client visit our Food Pantry last time. It should be something like: = Delivery Date IF Service Sessions contains "Food Pantry"
I have a manage picklist field name Age Category ("caseman__AgeCategory__c") and another field name Birthdate (Birthdate). I want to create a process builder that automatically change the picklist to the correct one based on the Age or Brithdate.
I'm trying to create a validation rule for the field Ethnicity (picklist) and Cultural Identify (Multi-select picklist). Every time Ethnicity equals "Hispanic or Latino", I want to required the field Cultural Identity. I was thinking in somehting like the following:
AND (ISPICKVAL(Ethnicity__c,"Hispanic or Latino")&& ISBLANK(TEXT(Identify_as__c)) )
Error: Field Cultural Identity is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions.
Hello All, I want to create an status field that display “Active” or “Inactive” according to the start date and the end date of an opportunity in comparison to TODAY’S DATE. I think it should be something like below.
Active IF TODAY is BETWEEN START DATE (npsp__Grant_Period_Start_Date__c) and END DATE (npsp__Grant_Period_End_Date__c), then display “ACTIVE” Inactive IF TODAY is LOWER START DATE (npsp__Grant_Period_Start_Date__c) and HIGHER END DATE (npsp__Grant_Period_End_Date__c), then display “INACTIVE”, IF NONE, NULL (BLANK).
I have a manage picklist field name Age Category ("caseman__AgeCategory__c") and another field name Birthdate (Birthdate). I want to create a process builder that automatically change the picklist to the correct one based on the Age or Brithdate.
I'm trying to create a validation rule for the field Ethnicity (picklist) and Cultural Identify (Multi-select picklist). Every time Ethnicity equals "Hispanic or Latino", I want to required the field Cultural Identity. I was thinking in somehting like the following:
AND (ISPICKVAL(Ethnicity__c,"Hispanic or Latino")&& ISBLANK(TEXT(Identify_as__c)) )
Error: Field Cultural Identity is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions.
Hello All, I want to create an status field that display “Active” or “Inactive” according to the start date and the end date of an opportunity in comparison to TODAY’S DATE. I think it should be something like below.
Active IF TODAY is BETWEEN START DATE (npsp__Grant_Period_Start_Date__c) and END DATE (npsp__Grant_Period_End_Date__c), then display “ACTIVE” Inactive IF TODAY is LOWER START DATE (npsp__Grant_Period_Start_Date__c) and HIGHER END DATE (npsp__Grant_Period_End_Date__c), then display “INACTIVE”, IF NONE, NULL (BLANK).
Is that possible, what i should do to achieve that i need to print an invoice after every purchase everyting is ready how can i add this functionally ?
