In my Contact record I'm using a custom field of type date. I need to be able to create a new task record 30 days prior to the custom date field value. I tried using the standard process builder with following conditions:
Is null Boolean
Is changed Boolean
Upon create of new Contact records via the process builder
ISCHANGED() cannot be used because the value in the custom date field is
NEW but not
CHANGED and it will not enable scheduled action option. In other words the task I need to create 30 days prior to the custom date field will not work. To mention that I need this process to work on update as well.
Because it is obvious I cannot achieve what I need by using the standard Salesforce process builder I decided to use apex.
However the issue I face with apex here is the limit of apex scheduled jobs it is possible to submit up to max 100 batch jobs.
Please advise what else I can try to be able to create Task record 30 days prior to custom date field?