Formula for calculating end date of license

[FortGjort_Trani]

My sister can somehow calculate the value for the field End date in her head. Can someone please give me the formula that she is using, as I need to use a formula? :grinning_face_with_big_eyes:

https://airtable.com/shrWJArPUxWUy7HG2

[FortGjort_Trani]

Jeremy_Oglesby:

But the main thing, the first thing I am suggesting, is to think of Licenses as records, one new record (row) per new license (whether the license is an original or a renewal of an original). And those License records can be linked to a Client record, one Client record per client you have.

That’s basically how it’s setup in my “real” base. What I’m showing in here is just a small portion of it as it’s in Swedish :slightly_smiling_face: Creating a new record when a field hits a certain criteria was an interesting idea though! I’m trying to test it right now.

[Jeremy_Oglesby]

No, you can’t use formulas, but you can enter the same date that occupies the “End Date” field of the record that triggered the automation:

[FortGjort_Trani]

That’s a smart solution! Thanks! You don’t happen to know how to make the formula in my original question? :slightly_smiling_face: Kamille came close but the last date was wrong.

[Jeremy_Oglesby]

I wouldn’t want to try to figure that out with a formula – which is why I made the suggestion I did. It’s definitely a challenge, and I’m sure @kuovonne could figure it out in little time. But it’s not how I would approach the problem, so I’m not terribly motivated to try and figure it out.

[Kamille_Parks]

FortGjort_Traning:

Kamille came close but the last date was wrong

The example given didn’t add up correctly to begin with, unless there was some alternate reasoning why the renewal date for 2022-02-01 is 2023-11-01 (21 months) instead of 2024-02-01 (24 months) when the listed {Length (months)} value is 24, not 21.

Jeremy_Oglesby:

I wouldn’t want to try to figure that out with a formula

The formula isn’t that complex when you break it down, I removed it because it appeared this was already being worked on by a consultant and I didn’t want to undercut their business by answering a redundant question for free.

[FortGjort_Trani]

Kamille_Parks:

The example given didn’t add up correctly to begin with, unless there was some alternate reasoning why the renewal date for 2022-02-01 is 2023-11-01 (21 months) instead of 2024-02-01 (24 months) when the listed {Length (months)} value is 24, not 21.

The example I gave you was wrong, your formula was right!

[FortGjort_Trani]

I think your solutions might be better. I’m trying to set up an automation but I can’t get it to work: Test are OK but nothing happens when I turn on the automation. Can you see why?

[Kamille_Parks]

If you’ve asked a question in one thread on the forums, please don’t ask it again somewhere else.

Test are OK but nothing happens when I turn on the automation Automations

I have created a two step automation where the condition is based on a date. If any of the dates in a certain field is before today, which they all are, the automation is supposed to update that record and create a new one. The test works fine but nothing happens when I turn the automation on. Why? :slight_smile: This is my automation: Sign in - Airtable [Screenshot 1] [Screenshot 2] [Screenshot 3] [Screenshot 4] [Screenshot 5]

Assuming your trigger is “When record matches conditions” or “When record enters a View”, if the record(s) in question already met those conditions/was in that view when the Automation was turned on, the Automation will not run for that record(s). From the Automation’s perspective nothing has changed therefor there was no trigger, therefor the Automation shouldn’t run.

You can cut and paste the date value back into the field to force the Automation to run.

[FortGjort_Trani]

Sorry about that! I’ve responded to your post in the other thread.