Here’s a simple mod to show unscheduled (dateless) events in DayBack Calendar.
This is great for events that haven’t yet been pinned down. They’ll get “UNSCHEDULED” appended to their name and show up on the current day until they’re dragged to an actual date/time. Here’s a movie of this in action:
Instructions
If you’d like to make this change in your copy of DayBack, here are the field definition changes mentioned in the movie above:
DBk_TimestampStartCalcNum:
Let ( [ //============= Assign your date and time fields here ========================== ds = DateStart ; // Your event's start date field ts = TimeStart ; // Your event's start time field // Mod for showing dateless events on the current date; Add a semicolon to the end of the preceding line ds = If( not IsEmpty (ds) ; ds ; GetAsDate ( Get ( CurrentTimestamp ) ) ) // End modification //============= You shouldn't have to edit below this line ========================== ]; GetAsNumber ( Timestamp ( ds ; Max ( ts ; 0 ) ) ) )
DBk_TimestampEndCalcNum:
Let ( [ //============= Assign your date and time fields here ========================== ds = DateStart ; // Your event's date start field de = DateEnd ; // Your event's date end field ts = TimeStart ; // Your event's time start field te = TimeEnd ; // Your event's time end field // Mod for showing dateless events on the current date ds = If( not IsEmpty (ds) ; ds ; GetAsDate ( Get ( CurrentTimestamp ) ) ) ; // End modification //============= You shouldn't have to edit below this line ========================== spanmidnight = not IsEmpty ( te ) and te < ts ] ; GetAsNumber ( Timestamp ( If ( spanmidnight and IsEmpty ( de ) ; ds + 1 ; Max ( ds ; de ) ) ; If ( IsEmpty ( te ) ; Max ( ts ; 0 ) ; te ) ) ) )
And the beginning of the DBk_WebViewerSource field:
Let ( [ //============= Assign your event fields here ========================== sc_sourceNumber = 1 ; // The source number as defined in the "Source No" layout sc_id = id ; // the unique ID or primary key of your event record. Often, it's serial number. sc_startDate = If ( IsEmpty ( DateStart ); GetAsDate( Get ( CurrentTimestamp ) ); DateStart ) ; sc_startTime = TimeStart ; sc_endDate = DateEnd ; sc_endTime = TimeEnd ; sc_summary = Summary ; sc_summaryCalc = If ( IsEmpty ( DateStart ); "UNSCHEDULED - ") & DBk_EventSummaryCalc ; //Read only sc_description = Description ; sc_resource = Resource ; sc_status = Status ; sc_contactID = id_contact ; sc_contactName = SampleContacts::NameFull ; sc_projectID = id_Project ; sc_projectName = SampleProjects::Name ; sc_location = Location ; sc_tags = DBk_Tags ; //============= Do not edit below this line ==========================
Enjoy!