Hi everyone, I’m a new airtable user who needs some advice how to perform the following task efficiently. I want to track some subscriptions like this:
The renewal date column should auto increase under this circumstances:
If interval monthly:
And {Renewal Date} <= Today()
{Renewal Date} = DATEADD({Renewal Date}, 1, ‘months’)
If interval yearly:
And {Renewal Date} <= Today()
{Renewal Date} = DATEADD({Renewal Date}, 1, ‘year’)
I have already tried several ways, but I am not very satisfied with them. Thank you :slightly_smiling_face:
