Expiry Dates and Gift Cards or Loyalty Points

Yep good idea as love to help but tied up writing software in our own DB ATM :weary Once done onto EFTPOS integration and then I look back here.

I keep an eye on your thread GLUCK.

1 Like

Last Thought: (as cannot help myself :scream:)

Once you have the Expiry Test done -

  1. Run a Trigger each day to run a Report to a Disk file - see exporting data.
  2. Using SCRIPT read each line and use a ENTITY DATA UPDATE on the Custom Field to wipe it.

Quite simple actually.
Check some of my threads on FILE MONITOR I have all the code for doing this except the Date Handling :grinning:

this seems like a headache to me lol… ill have to read into it.

Ive not really used scripts, ill do a search. Ive posted now so see if someone can come show me the right direction too

I think you may just need to verify using entity selected or changed event. It does not need to be automatically for every members, only need to know if that member status still valid today.