Jump to content
  • 0
Batchini

Date Range Calendar event

Question

6 answers to this question

Recommended Posts

  • 0

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: 3359399
2. Create Table 2. The trigger will be the one to populate this table. Screenshot:

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

3359402

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

 

Hope this works for you.

-Barbie

Share this post


Link to post
Share on other sites
  • 0

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. 

Share this post


Link to post
Share on other sites
  • 0

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.zipimage.thumb.png.622c194302713c0e38cc952d5b50d93d.png

 

 

Share this post


Link to post
Share on other sites
  • 0
On 12/8/2019 at 4:50 PM, DefinitelyNot31337 said:

 image.thumb.png.622c194302713c0e38cc952d5b50d93d.png

 

 

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!

Share this post


Link to post
Share on other sites
  • 0
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/

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...