Show Events without a date

Notes on our latest calendar for FileMaker 13,: DayBack
Posts: 11
Joined: Tue Apr 27, 2010 7:47 am
PostPosted: Sat Jun 30, 2018 2:35 am
Is there a way in DayBack to show 'unassigned' events? A customer wants to use their calendar for scheduling Jobs...

Apologies if this has already been answered.
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Jul 02, 2018 7:05 am
Good question. DayBack can show events that don't yet have a resource assigned: these show up in the "none' column on the scheduling screens. But there is no way to show an event that doesn't yet have a date in a stock copy of DayBack.

You can, however, modify the date calcs in DayBack for FileMaker to place a dateless event on the calendar: as an all-day event for the current date, for example. Once a dateless event is showing, dragging it to a new date/time will give it a real date =) Here's a movie of what I mean: https://vimeo.com/277998113

Hope that helps!

Here are the modified calcs referenced in that movie:

DBk_TimestampStartCalcNum:
Code: Select all
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 curent date; Add a semicolon to the end of the preceeding 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:
Code: Select all
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 curent 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:
Code: Select all
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 ==========================
John Sindelar
SeedCode
Posts: 11
Joined: Tue Apr 27, 2010 7:47 am
PostPosted: Mon Jul 02, 2018 8:03 am
Hi John

That's great, thanks! We'll implement that and will no doubt be back if we have other issues.... ;-)

Matt

Return to DayBack Calendar for FileMaker

Who is online

Users browsing this forum: No registered users and 4 guests

cron
(855) SEEDCODE
[email protected]
Follow us: