DayBack Demo

Support for our integrated Contact Manager, Calendar, and Project Tracker.
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: Sat Nov 22, 2014 12:45 pm
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.
Posts: 142
Joined: Thu Nov 01, 2012 2:36 pm
PostPosted: 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
PostPosted: Sat Nov 22, 2014 3:11 pm
Fixed it :)
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: 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
PostPosted: Sun Nov 23, 2014 9:45 am
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.
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: 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
PostPosted: 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
PostPosted: 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...
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: 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
PostPosted: 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
PostPosted: Mon Nov 24, 2014 1:38 am
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...
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: 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
PostPosted: 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...
SeedCode Staff
SeedCode Staff
Posts: 475
Joined: Wed Jan 02, 2013 11:47 am
PostPosted: Mon Nov 24, 2014 9:48 am
Makes sense.

Return to SeedCode Calendar

Who is online

Users browsing this forum: No registered users and 1 guest

cron
(855) SEEDCODE
support@seedcode.com
Follow us: