SeedCode Support Forum

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.

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 ==========================

Hi John

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

Matt