SeedCode Support Forum

Hi,
Great demo file, really pleased to see repeating events as I will be able to ditch my Excel/iCal combo'...

I need to colour code calendar events based on their Job Type and have noticed that using the Status affects the colours. If this is the only way to display different colours, how do I rename the status elements?

Or, is their another way to achieve the above?

Thanks
Brian.

Ok, found this:
http://www.seedcode.com/pmwiki/index.ph ... ventColors

I have added x4 Job Types as "Projects"

It needs to be mapped on the colors tab of the Source No X layout.
For this, I chose "id_Project" and in Browse mode, this displays as "P00001"

You use that field in your colors calc: the field SampleEvents::DBk_ColorCalc.
"sts = Status" changed to "sts = id_Project"

You've mapped your field to the label "status" in the field SampleEvents::DBk_WebViewerSource
"status = Status" changed to "status = id_Project ;"

And the value in your field is one of the values of the Status Filters shown on the "Filters" tab of the calendar/
This works if my filter value is "P00001" but if I choose a different filter, it reverts back to Blue.

Any suggestions?

Fixed it

Glad you got everything figured out! Let us know if you have any other questions or feedback.

jeffalmquist wrote:Glad you got everything figured out! Let us know if you have any other questions or feedback.

Thanks Jeff, I have 10,000 event records starting 24th Nov through to 31st Dec 2015.
I can filter these records by Status and by Resource when in Calendar layouts but I also need to filter by Date and Time too. I'm using the calendar as a running sheet of jobs that need to be performed between two times on differing days.

E.g.
From 24/11/2014 at 17:00 to 25/11/2014 at 08:00

I tried the above whilst in the "Event List" layout but couldn't set the time for some reason. Any help would be great...

Thanks
Brian.

There isn't built-in support for "manually" filtering beyond the implicit date range associated with the different views. If you wanted to do something like that, you would have to somehow adjust the timestamp values in the CalendarRows::DateRangeStartAutoGlob and CalendarRows::DateRangeEndAutoGlob fields. HTH -Jeff

I can't find the CalendarRows table or those fields Jeff?

Ah, that table is called CalendarInterface now. I'll take a look at those fields but I'm not sure I know what I'm doing...

Sorry, I didn't realize you were talking about the NEW calendar (DayBack). It does look like those fields are in the CalendarInterface table now (sorry, DayBack's still new to me, too). I think the custom date-range filter you're describing (if I'm understanding you correctly) will still involve a custom modification though. You can hire us to do it for you if you like. You'll just need to purchase a three-hour implementation package and let us know exactly the behavior you're looking for. -Jeff

I'm trying to find a work-around Jeff. I have duplicated the "Event List" layout then sorted it by "DateStart" then "TimeStart".

This gives me a great looking layout for printing out, as I've added the fields that I need and each job is in a grouping. I'm wondering whether I can add a number field to sort on and then do a find based on that?

jeffalmquist wrote:You'll just need to purchase a three-hour implementation package and let us know exactly the behavior you're looking for. -Jeff

Ok thanks Jeff, I purchased the original Calendar several years ago but didn't get around to implementing it. I'll wait to see what the upgrade cost is before buying any support...

I'm not sure what you mean by adding a number field for finding/sorting, but the Pro Calendar file is unlocked so certainly you can modify it however you like.

Just for info, I added the Events::DBk_MilestoneSort field to the layout and I type in a "y" for every record I want to view. I can then perform a Find on this field for every record that contains a "y".

This found set is then printed out. It's a little clunky and prone to error but it works. However, I would much rather fetch a group of records that have a Date/Time start that is in a date range that could be specified in a filter.

Thanks...

Makes sense.