brian.curran's ProfileHi,
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.
DayBack Demo
14 posts
• Page 1 of 1
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
 Posted: Sat Nov 22, 2014 12:45 pm |
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
Posted: Sat Nov 22, 2014 2:14 pm 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? |
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
Posted: Sat Nov 22, 2014 3:11 pm Fixed it
 |
|
Posted: Sun Nov 23, 2014 7:06 am Glad you got everything figured out! Let us know if you have any other questions or feedback.
|
|
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
Posted: Sun Nov 23, 2014 9:45 am
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. |
|
Posted: Sun Nov 23, 2014 10:41 am 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
|
|
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
Posted: Sun Nov 23, 2014 11:46 am I can't find the CalendarRows table or those fields Jeff?
|
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
Posted: Sun Nov 23, 2014 11:49 am 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...
|
|
Posted: Sun Nov 23, 2014 4:21 pm 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
|
|
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
Posted: Sun Nov 23, 2014 5:10 pm 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? |
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
Posted: Mon Nov 24, 2014 1:38 am
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... |
|
Posted: Mon Nov 24, 2014 6:35 am 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.
|
|
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm |
Posted: Mon Nov 24, 2014 9:19 am 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... |
|
Posted: Mon Nov 24, 2014 9:48 am Makes sense.
|
|
14 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 2 guests
Delete all board cookies• All times are UTC - 8 hours Powered by phpBB© 2000, 2002, 2005, 2007 phpBB Group
