Skip to content
English
Sign in
Contact us
  • There are no suggestions because the search field is empty.

2 | Multi-Venue - Limiting a Prize Setup 1 per Account

Learn how to provides a workaround for Multi-Venue organisations where the client wants to only be able to issue 1 x Prize setup per account. An example is a Birthday Reward once a year.

This article provides a workaround for Multi-Venue organisations where the client wants to only be able to issue 1 x Prize setup per account.

An example is a Birthday Reward once a year.

Problem

  • Prize promos within a multi-venue setup do not limit 1 x prize promo per account for all Venues
  • The current design is that the Prize will trigger once per Venue per Account

Solution

  • Set up a custom or Bepoz report with the Account activity or AccPromo activity
  • Create a Custom Account Flag to be enabled and disabled
  • Setup a scheduled job called: Acc Flag from Report
  • Account Profile to exclude or include with said Custom Account Flag
  • Example of a Custom Report for Birthday Month to prevent multiple rewards if the customer attends multiple venues within the same month
  • The below select script creates a report from AccPromo Table and only selects the PrizePromoID linked to the Birthday Reward, it then finds the month from a column called DateLastDate (Last Used Date) and then Get the current Month from the System
  • This then generates a list of all Birthday Prizes awarded within the current month
SELECT * FROM AccPromo WHERE PrizepromoID= 1 and MONTH(DateLastday) = MONTH(GetDate())




  • The second step: Create a Custom Account Flag. (Boolean) which the Schedule Job will flag on and off




  • The third step: Create a Schedule job called: Acc Flag From Report
    • Specify the Bepoz or Custom report
    • Specify the Custom Account Flag that needs to be triggered
    • Specify the interval time you want the Scheduled Job to be executed


  • The Last Step: Specify the Custom Flag within the Account Profile, in the above example we want to exclude any Members from being rewarded more than once in their Birthday Month
    • Set the Custom Flag to Is False
    • Any Account that has the Bday Prize Given set to true, will not populate in the Account Profile and will be unable to be rewarded a second time



  • NOTE: Once the calendar month changes for example from February to March all accounts that are flagged will be unflagged and next year will be able to be rewarded again