Thanks for this community. I can see that sometimes people have questions about formulas and most of the time they get help. I can also see that some people asked before about formulas for recurring tasks. But since every usecase is different, I would like to share the following with you:
Right now I have a database that includes the fields Frequency and Due today.
In Make.com I created a scenario that checks once a day if Due today = true. And it will get all entities where due today = true, after that some actions will take place outside of Fibery.
Inside the Frequency field I would like to add these options:
Daily: every day or daily
Weekly: every week or weekly
Monthly: every month or monthly
Yearly: every year or yearly
Specific days of the week: every Monday, every Monday and Friday
Specific days of the month: every 15th, every last day
Specific months: every 14 Jan, 14 Apr, 15 Jun, 15 Sep
Every X days/weeks/months: every 3 days, every 2 weeks, every 6 months
Start and end dates: every day starting Aug 3, every day until Aug 3
“Every other” frequencies: every other day, every other week, every other month
I tried multiple times to create a formula with AI “Generate using AI”, at first I tried to add every day of the week. However, my prompts are not as good I think. This is the formula that AI created:
If(
Frequency.Name = WeekdayName(Today()) or
Frequency.Name = "Daily" or
(Find(Frequency.Name, "Every") >= 0 and
Find(Frequency.Name, "1") >= 0 and
Day(Today()) = 1),
true,
false
)
Right now only the weekdays are working most of the time. It’s not working properly on the first day of the month. But it’s difficult without extensive formula knowledge to add options mentioned before, to the formula.
How to get all options mentioned above working? Is it even possible to get it working or are these options not possible with formulas?
Are you trying to write a formula that will be true if today’s day matches the criterion defined by the select field called ‘Frequency’?
If so, then I think it’s impossible for some of the options you have proposed.
For example if Frequency is ‘every Monday’ then it’s no problem to decide if today is Monday or not. And similarly for ‘every 15th of the month’.
But how can a formula know what to do for ‘every week’? Or ‘every other month’?
I also think it is impractical to use a single field for all these options. Imagine you want 'every day since Aug 3‘ but you also want 'every day since Aug 4‘ and '… Aug 5‘ etc.
The choices in the dropdown would be virtually infinite.
How about you consider breaking down the elements of the recurrence definition into separate parts:
start date (can be empty)
end date (can be empty)
recurrence unit (e.g. day, week, month, year)
periodicity
relative position
So, the following settings:
1 Jan 2025
empty
month
2
15
would mean the 15th of every second month, i.e. 15 Feb 2025, 15 April 2025, 15 June 2025, etc.
And the following:
empty
31 Dec 2025
week
1
3
would mean the third day (Wednesday) of every week until 31 Dec 2025.
I think your chances of creating a formula that works would be a bit higher.
By the way, what’s the underlying problem you’re trying to solve?
But I understand that it’s not possible to do that in Fibery.
We have a private Discourse community for our company. (Thanks for creating the Discourse Fibery connection!) You can see “Channel Performance”, “Editing Mian”, “Editing Sam”, these are categories. Under these categories you can see the recurring tasks, like “Daily task”, “Uploading”, “Editing”, Thumbnails".
On the right you can see the fields Frequency and Extra. If you fill in field Extra you can choose to add a weeknumber to the topic title.
Every morning a Make automation searches for entities that have a field with TRUE, and Fibery tasks (entities) will be used to create new topics.
If we add these options to the overview, it will be more complicated to use for users who are not that technical. But I appreciate the suggestion to create multiple fields. I’ll try to create a formula for this.
