wayne186
Posts: 30
|
| Posted: 07/17/2006, 12:11 PM |
|
Hi, I am using the Calendar form on one of the pages of my website and I have it working correctly where it is returning all records for each respective day in month view.
I want to have the option to allow the users to go to a weekly view because the page is too big to display on a single page with all of the records in a month. Is it possible to create a week view? I know we can create a year, quarter and month but no less?
The other thing I am struggling with is to be able to add a link on the form (next to Day) which the user selects and sends them to my Add_new_appointment page and sends that respective days date in the url. I have added a link called appointment_date with the following properties:
Name: appointment_date
Visible: Yes
Control Source Type: Database Colum
Control Source: appointment_date
Data Type: Date
Format: dd-mm-yyyy
Default Value:
Content: Text
Href Type: Page
Href Source: appointment/newappointment.ccp with parameters as ?s_appointment_date={appointment_date}&
Convert URL to: None
Remove Parameters:None
Preserve Parameters:None
DBFormat:
I have also tried using the options
Control Source Type: Special Value
Control Source: CurrentProcessingDate
The url link works in that it takes me to the correct page and the parameter ?s_appointment_date= is at the end of the url but it does not complete it by placing the date at the end. The link shown in the calendar DOES have the date shown in the link as the correct date so I do not understand where I am going wrong?
Any help would be greatly appreciated.
Thanks
Wayne
|
 |
 |
peterr
Posts: 5971
|
| Posted: 07/17/2006, 6:05 PM |
|
There is no weekly view in the calendar, however, you can use the Grid or Report to display the list of calendar items within the week, possibly grouped by date.
As for passing dates via URL, the instructions from this example work for me: http://examples.codecharge.com/CCSExamplePack2/Calendar...endarSearch.php
You only need to configure the "Parameters" tab of the link as described. Everything else is optional.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wayne186
Posts: 30
|
| Posted: 07/17/2006, 6:45 PM |
|
Peter - thanks very much for your reply, I got the passin date problem fixed using your suggestion thanks. But I am still unclear about the use of the grid or report to display the list of calendar items within the week period. Are you saying I should edit the existing calendar that I built using the Calendar builder or should I be building an entirely new grid or report?
thanks
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/17/2006, 10:01 PM |
|
Sorry, I meant that you would need to create a new page with new grid or report.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wayne186
Posts: 30
|
| Posted: 07/25/2006, 3:42 PM |
|
Hi - I have been trying to do this for days now and I can not figure it out. To be honest with you I am not capable of much beyond using a builder and then going in after the fact and changing things around like the builder put in a label and I want a link or I wanted to add to a builder. The calendar does not offer much in the way of letting me play with it - even as much as putting a simple button next to the navigator to link to another page.
Are there any tutorials out there that can help me build a weekly view calendar? Way too many records to display by month - currently I want to report on the following columns from my database:
Table: Appointment
appt_cancel
appt_id
appt_fullg
appt_bath
Table: Pet
pet_name
Currently it looks like this 
You can see where I changed the date label to a link and other things - but I am just plum stuck on how to do this. Any help would be appreciated.
thanks
Wayne
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/25/2006, 9:19 PM |
|
Quote wayne186:Are there any tutorials out there that can help me build a weekly view calendar?
No, because of what I wrote above: Quote :There is no weekly view in the calendar,
Why don't you use the report or grid as discussed? Here is a standard grid sample, which you could nicely group by date: http://examples.codecharge.com/Portal/Events.php
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wayne186
Posts: 30
|
| Posted: 07/26/2006, 1:46 PM |
|
Quote :Why don't you use the report or grid as discussed?
I wanted to display 5 days in one page view so that I can see tuesday through saturday in each column and be able to navigate to the next week or previous week or month as you do in the calendar.
I do not know how to do this. I know how to create a page with one days view manually or create a calendar to create a month view but nothing in how to do it for a week view.
Any ideas? 
|
|
|
|
peterr
Posts: 5971
|
| Posted: 07/26/2006, 2:25 PM |
|
This could be difficult without a Weekly Calendar feature. For now I can only recommend displaying 5 days in a grid (instead of 1 day) and group the results by day.
Unless someone else has done it differently...?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
WKempees
|
| Posted: 07/26/2006, 2:34 PM |
|
Have been following this discussion.
Have used Calendar rather intensivly and even did some experimenting with
for this case.
agree with Peterr:
Without WeeklyView , missed by me too, this is not a Calendar capability.
|
|
|
|
wayne186
Posts: 30
|
| Posted: 09/30/2006, 7:40 PM |
|
I have been trying for a long time to get this weekly calendar view working and I have still had no success.
What do you think are the chances for weekly views to be put into the next release of CCS? I find it a little strange that a monthly, quarterly and yearly view was built but not a weekly? How hard would this be for the developers to put in?
I am trying to do it at the moment using the reports builder but I do not know how to create it so I have 7 columns (a form in each column which only has 1 day in the report).
How would I create a navigator that lets me move from one week to the next and limit each form to only show one day of records?
cheers
|
|
|
|
Wkempees
|
| Posted: 10/02/2006, 2:33 AM |
|
Interesting question.
I am (low priority) experimenting with this and hope that CCS will beat
me to it, by releasing such functionality out-of-the-box.
It is a hard one.
Walter
|
|
|
|
wayne186
Posts: 30
|
| Posted: 10/02/2006, 10:02 AM |
|
As I apply more thought - here is what I have tried. I created a table with 5 columns (the shop is only open 5 days a week). In each column I have placed a table, I want the table to only shows one day. I want to pass a variable (I normally do this in the url) for the date it is s_appointment_date then I want each table to reference this variable and table one will simply be the appointments for that day. Table 2 will look at the variable and add one day (I have been messing with the date_add sql statement but it appears that I can not use the sql statement and reference the variable s_appointment_date in it. Table 3 will do the same but add 2 days to the date and so on. Each form in the table has the Data source properties set to SQL and then I do the sql statement:
SELECT * FROM `poochies_appointment` WHERE ( DAYOFYEAR( NOW() ) > DAYOFYEAR( DATE_SUB(appointment_date,INTERVAL 1 DAY) ) AND| DAYOFYEAR( NOW() ) <= DAYOFYEAR( DATE_SUB(appointment_date,INTERVAL 1 DAY) )+1 )
I keep messing with the statement but it is hard for me because I am not that familiar with it. Any sql help would be appreciated and if anybody knows how to bind it to take the date from the url and then add 1, 2, 3 & 4 days to it would be the most ideal method right now?
thanks
Wayne
|
|
|
|
