Points disappear after 180 days

It is necessary to implement a system for the disappearance of the user’s points that he receives from purchases if he has not made purchases for 180 days, the points disappear all that he has saved up

  • Create a Math column using the formula Now-180. This will give you the date 180 days ago.
  • Create an if-then-else column:
    – If Purchase Date is on or after 180 days ago, then Purchase Points
  • Use a Rollup column through a Query to sum the output of the if-then-else column.
1 Like