Date Range Calendar event

[Kuroshi]

I have a start date  and end date in my table I want the Calendar show every day of the date range on the calendar how to achieve this?

[Barbie]

Hi @Batchini,

What I suggest is to create a triggered action and add 3 tables. Below are the steps on how to:
1. Create Table 1. You will store here all of the information about Events. Screenshot:
2. Create Table 2. The trigger will be the one to populate this table. Screenshot:

3. Create the table 3. This will consists of the maximum number of days that the event can last. Screenshot:

4. Lastly, create a trigger that will populate the table two. Please refer to this:

 

Hope this works for you.

-Barbie

[Barbie]

Just to add information on this you may want to visit our How to article on how to quickly understand what is triggered action: https://howto.caspio.com/tables-and-views/triggered-actions/

[Glitch]

To explain more about this trigger, I implemented this to my app as well. The reason why we need a dummy table is because this will be the static value of until how many days can an event last. If you only set the row up to 30, the maximum days of events will be 30. 

[DefinitelyNot31337]

h3110,

 

With the recent Caspio Release 20 comes an improvement in Triggered Actions called "Variables" and "Do-While Loop". These allow you to achieve this workflow without having to specify a dummy table.

 

Attached are the screenshot of the Trigger, and the Table Design Used.

 

Hope this helps.

 

Happy H4x1ng-

-DefinitelyNot31337

 

Tables_2019-Dec-09_0543.zip

 

 

[shaferam]

On 12/8/2019 at 4:50 PM, DefinitelyNot31337 said:

 

 

 

This is fantastic and was exactly what I needed. thank you!

A couple of questions:

With the above triggered action the last day doesn't post. How do I fix this? (what did I miss?)

Is there a way to make any kind of color change with the change of an event? For example, event 1 lasts 10 days with event 2 starting immediately after on day 11. What visual cue can I create so the user quickly sees the change from event 1 to event 2?

thanks!

[SinJunYoung]

On 7/21/2020 at 2:12 PM, shaferam said:

Is there a way to make any kind of color change with the change of an event? For example, event 1 lasts 10 days with event 2 starting immediately after on day 11. What visual cue can I create so the user quickly sees the change from event 1 to event 2?

 

For this question, we may need to use JavaScript. But this might help and additional custom codes may be able to help: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/

[ParkLoey]

Hi guys! Just wanted to add to this thread the recent caspio tech tip that was released!

https://howto.caspio.com/tech-tips-and-articles/common-customizations/render-date-range-in-calendar-datapage/

- LOEY

[Kurumi]

Hi - Good news! Caspio has a new Tech tip called Downloading Appointments to Calendars Using ICS Files. To know more on how to implement it in the DataPage, you can check it here: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/download-appointments-to-calendars-using-ics-files/

[PotatoMato]

Hi! Just to add, Caspio has also an article that enables you to download Calendar events as PDF: https://howto.caspio.com/tech-tips-and-articles/downloading-calendar-events-as-pdf-files/

 

-Potato

[Flowers4Algernon]

Hello! Just wanted to share this article in case you may also want to search for data in a date range.