Apex Code Development You need to sign in to do that
Don't have an account?
Jeff Horne NGO Connect
We are running NGOC and manage our membership through rollups at the account level. We also are using Mailchimp as our email client. The issue I am having is the the field "Primary Membership Status" is no longer being updated. For Mailchimp to sync it looks for people whose status is "Active". "Active" members are those whose "Primary Membership Expiration Date" is greater that today's date. So if they have not yet reached their expiration date their status will be "Active" If it is past that date the status would change to "lapsed". How fo I get this job to run and update all account each night?
Scott Haleo
Hytechpro
Thank you for the reply. Sorry if I don't know what you mean by complete requirement. I need a trigger to happen nightly that updates the feild, "Primary Membership Status". This field is controlled by a date feild. When someone purchases a membership, that membeship is active for a a year before it expires. ie.. if I purchase today my "Primary Membership Status" will become Active. On August 19, 2017 that status will change to "Lapsed" if I do not renew. Currently the memberships are activating without issue. The problem is when the membership lapses the account is nbeing updated as such.