I imagine it would be useful to calculate the next billing date in a monthly subscription. With PayHere, up until now, I do it in the Sheet.
For sure, though, technically, the next billing date is one of the API parameters.
Cheers! Would also be helpful if you want to do a feature like “This day last month”
For example, the ideal display would look like this:
“Week of: June 14, 2021 - June 20, 2021”
Thanks for any and all help!
I would think you could do the same thing @ThinhDinh did here, but change the formatting of the date math columns and add ‘Week of’ to the template.
Will try this out - thanks! Also - thanks too ThinhDinh!
I’m using the following to get midnight on the first day of the current month:
Which works fine, but what I need now is:
- Midnight on the first day of last month
- Midnight on the first day of 2 months ago
- Midnight on the first day of 3 months ago
Example: today is 27th August, I want 3 math columns that will return midnight on the 1st of May, June & July respectively. I’m thinking that the magic number 15 needs to come into play here, but struggling with it…
(I know I could do this easily enough with a bit of YC, but prefer not to resort to that unless there is no other option)
I believe this will work.
With X referencing the column just before’s timestamp.
I tested with some timestamps instead of Now just to make sure.
I could have also done it that way, but that’s not what I wanted
Wonderful, thank you!
Resurrecting this awesome thread. Found myself using this functionality a few times this past week. Here’s a way to switch between “today” and “last month” by writing the text value of
last month to a date column. The date column then acts as filter to display the correct leaderboard:
Thansk for sharing! I’m surprised it works with set columns.
It’s actually a choice component that’s writing that value, but ya, sure does!
@Robert_Petitto I was going to post this in your other thread about creating a membership app but since you mention it here - I have found that the payhere api doesn’t always update the “next_charge_at” field. According to the api docs it only updates that field during subscription creation or cancelation, but not for recurring payments. Have you found this to be different? I just set up a test subscription that renews daily to fully test this.
Here are the payment success fields that are passed through: Webhooks · Developers
Here is an example of it not passing the next_charge_at field:
Reading this thread because my new thought is to set a next payment field myself by adding a month or year to the last payment date if the subscription is still active.
I can confirm this happened to me as well. From that point I have always used math columns to calculate it myself.
Thanks for confirming! I realized I could easily do it with the addMonths argument in the make/integromat scenario too. I’ll post an update to that thread once I have it set.