Add subscription type like monthly?

azu commented 3 years ago

How to record monthly donation?

azu commented 3 years ago

Google App Scripts Integration?

Images

User who use subscription type can install helper GAS script
GAS script use ClockTriggerBuilder and create new record from subscription item.

Require

azu commented 3 years ago

Should subscription items be another sheet? For example, the "Subscription" sheet.

I concern about how to stop subscriptions.

azu commented 3 years ago

kishikawakatsumi commented 3 years ago

It would be great to support for recurring donations. But meantime, it would be nice adding a small feature to duplicate existing records.

If so, we can easily add our recurring donations by simply duplicating last month's records and just changing the date.

azu commented 3 years ago

If so, we can easily add our recurring donations by simply duplicating last month's records and just changing the date.

Ah, It's reasonable. I've created it as a new issue. https://github.com/azu/philan.net/issues/19

azu commented 3 years ago

I've implemented the clone feature in #20

azu commented 3 years ago

Data Table image:

 [StartDate, EndDate, Every?, to, URL, amount, why?]

We need to define Every? format. What format is suitable?

Probably, this lifecycle is バラバラ.

毎月1日が決済日となっています。

継続寄付は、お申し込み時点では決済されません。お申込みされてから直近の決済日（毎月10日、土日祝日にあたる場合は翌営業日）に決済されます。カード会社によって締め日・引き落とし日が違うので一概には言えませんが、決済日の翌月か翌々月にお引き落としがあります。

Probably, We would not need to get closing date strictly.

is even enough?

azu commented 3 years ago

cron format may be fit this case.

azu commented 3 years ago

Different approach:

azu / philan.net