Calendar Report
Hello, I need help with quickbase calendar report. I currently have a field called start date which has list of companies. I have a another field called frequency which is multiple choice field co...
Forum Discussion
I am currently working on an app where we want to do a CALENDAR REPORT based on the start date and frequency. This seems kind of unachievable on my part. I tried this formula for the occurrence based on the start date but somehow it displays wrong data.
If([Frequency] = "Daily",
ToText([Start Date]),
If([Frequency] = "Weekly",
ToText(ToDate(Month([Start Date]) & "-" & ToText(DayOfWeek([Start Date]) + 7) & "-" & Year([Start Date]))),
If([Frequency] = "Semi Monthly",
ToText(ToDate(Month([Start Date]) & "-" & If(Day([Start Date]) > 15, "01", "16") & "-" & Year([Start Date]))),
If([Frequency] = "Monthly",
ToText(ToDate(Month([Start Date]) + 1 & "-01-" & Year([Start Date]))),
""
)
)
)
)
ToText([Start Date]),
If([Frequency] = "Weekly",
ToText(ToDate(Month([Start Date]) & "-" & ToText(DayOfWeek([Start Date]) + 7) & "-" & Year([Start Date]))),
If([Frequency] = "Semi Monthly",
ToText(ToDate(Month([Start Date]) & "-" & If(Day([Start Date]) > 15, "01", "16") & "-" & Year([Start Date]))),
If([Frequency] = "Monthly",
ToText(ToDate(Month([Start Date]) + 1 & "-01-" & Year([Start Date]))),
""
)
)
)
)
Could you please provide some insights?
------------------------------
XYZ
XYZ
------------------------------
When you have a simply table report with say a single record in the whole table, there is no formula you can write will magically make a recurring set of multiple records.
A calendar report is simply a different format to view records, and so a record will only "start" on the calendar on a single date and not multiple dates.
I did have a need to do something similar for a client, but I had to set up a Pipeline process to create the future records. So unless you are willing to get into that complexity, there is no easy way.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
