@Robert_Petitto I’m using your method of updating membership status in the users table. I’m using the api call to Payhere.co using the Date Time to update the account status, however, I’m incurring massive update fees because i just loops every second causing multiple updates for how many rows I have in the users table. I blew threw $200+ in a few hours by having that active. Is there a work around to avoid the update waste?
Ya, at the time of this video, there wasn’t a “refresh after” field. Make sure you set this to a value that you’re comfortable with. The only downside is that there will be a delay from the time a user pays to when it shows up in the app. If you need something more instant, then you can leverage a service like Make (https://www.make.com/en/register?pc=robert) to accept a webhook from payhere that then calls Glide.
Here’s how I typically make this happen:
Thanks for the fast reply @Robert_Petitto I’m working on something pretty cool that I think will benefit the Glide Community as a whole. Mind taking a look? I can send you the url.