Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Nov 02, 2020 03:57 AM
Hello community,
I’m having a very very hard time finding out the perfect formula to activate my automation… :pleading_face:
Here the thing :
I offer a 14 days trial with my services and wanted to track this with airtable. Each time the status change, an email is sent to the client via automation. For exemple :
The point of entrance is airtable form, but the service is live once the field “update URL” which is a last modified field is updated. Here’s the formula :
IF({Interface supprimée}=1,“Interface supprimée :pensive: ”,
IF(DATETIME_DIFF(TODAY(), {Update URL},‘days’) >=14, “C’est fini”,
IF(DATETIME_DIFF(TODAY(),{Update URL},‘days’) >=7, “Plus qu’une semaine”,
IF(DATETIME_DIFF(TODAY(),{Update URL},‘days’) >=1, “Phase test”,
IF(DATETIME_DIFF(TODAY(),{Update URL},‘days’) =0, “Nouveau client” )))))
Problem is, this formula work fine when set with “date” but don’t work anymore when set with “last modified”. Date format are identicals, date are identicals :
When set on “date” :
When set on “last modified time” :
Anyone can help ??