Altair Posted December 6, 2019 Report Share Posted December 6, 2019 Hi, I have a simple submission form where there two Date Fields (StartDate and EndDate) and I want the dates between them in my Calendar Report. Is there a way to use the Do While Loops here? Quote Link to comment Share on other sites More sharing options...
Nuke354 Posted December 6, 2019 Report Share Posted December 6, 2019 You can do that using the new Do- While in the table triggers. The firs thing you need to do is to get the difference between days of the two Dates using a variable, Then, using this variable you can iterate the insertion in your dummy table where the range of dates will be marked on the calendar. You can put an identifier field so that these dates are grouped based different criterias (ID's, Authentications). You can check out this trigger for reference: Quote Link to comment Share on other sites More sharing options...
ParkLoey Posted May 30, 2021 Report Share Posted May 30, 2021 Hiya there! Just wanted to add this tech tip that caspio released: https://howto.caspio.com/tech-tips-and-articles/common-customizations/render-date-range-in-calendar-datapage/ Assuming you want to make multiple entries in your calendar based on the start and end date, this might be helpful for you Quote Link to comment Share on other sites More sharing options...
PotatoMato Posted June 9 Report Share Posted June 9 Hi! Just to update, Caspio has added an article to disable past or future dates: https://howto.caspio.com/tech-tips-and-articles/disabling-past-or-future-dates-in-calendar/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.