How would I periodically change a Field's value in "the background"?

Need help Database
1

Hello, and thanks for reading.

I am trying to build out a store that has dynamic pricing. That is, whenever someone purchases an item (my album), the price of it doubles for the next person to buy it. To keep the price reasonable, I’d like to have the price “decay” at a rate of, say, 1% an hour. I’m close to figuring out how to double the price upon purchase, but I have no idea how to do changes in “the background” to a Field’s value. I have a thing called “Askprice” with a Field “Amount”.

How can I create time based changes to database entries?

Thanks in advance,
Bill

2

Backend Workflows

1 Like
3

cool, thanks, i’ll look into that.

preciate ya