giuseppe
-
Conditional display in calendar
How can I do to view events in the calendar only with certain conditions? I have a table with records including a data filed and a status field (multiple choice).…
-
Warning message for expiring TO DO
I would like to have a warning message when the "TO DO" are about to expire and when they are expired. So I tried to build this formula: if days(Data, today()) > 0 and 'Stato TO DO' !…
-
There is way to choose a color coding in external calendar based of different tables?
I am an event photographer and I need to synchronize both the events for a specific date and the leads for specific dates in an external calendar (google, ical),…
-
Sum with multiple condition (dates and multiple choise field)
Hi, I searched a lot but found nothing that is right for me. I have this formula. Basically I would like to sum the expenses between one date and another but which have as their parameter a specific…
-
extrapolate number of month of current year from 2 dates
Hi, I need to extrapolate how many months of the current year there are between 2 dates. For example: I have 2 dates 05/01/2021 and 05/01/2022. I would like to know how many months of the current…
-
Formula for calculate total of recurring expenses
Hi, I've been looking but can't find a simple solution to my problem. I have recurring expenses recorded in records where there is a start date and an end date.…
-
Formula to search records with dates
Hi I'm looking for a formula to obtain as a result the records that have a date between a date that I can insert through a date field and another that I can insert into another date field.…