Web based White Board - Day Viewer

Follow

Comments

16 comments

  • Avatar
    Matthew McGartland

    Is there any easy way to only display one warehouse's activities?

    0
    Comment actions Permalink
  • Avatar
    Martin Keller

    How can I display both OUT and BACK on the Day Viewer? I was trying to find the right references in the database, but I find it impossible to understand the db design.

    2
    Comment actions Permalink
  • Avatar
    David Lucchino (Edited )

    First off: the Day Viewer is amazing. As soon as I set it up at the shop everyone here fell in love with it. 

    ...And then someone had to ask if there's a way to have active/fully prepped jobs remain visible on the day viewer...

    I'm not a coder so i was wondering if there's a (simple) way to achieve this. Either way thanks so much for this awesome tool!

     UPDATE: Figured it out it's line 37 change the <> to =  If (aQuery.fieldbyname('Sum_PreppedQty').asstring = aQuery.fieldbyname('Sum_Quant').asstring) then
    begin

    set up a separate "Active book" and seems to work great. Thanks again for this awesome tool!

     

    2
    Comment actions Permalink
  • Avatar
    Noah Bard

    I am wondering if there is an answer to Mathew's question about only displaying one warehouse's activities?  Also I am wondering if there is displaying warehouse transfers in a separate way or on a separate screen in a similar method as David talked about with the Active Book.

    0
    Comment actions Permalink
  • Avatar
    Matias Kenny

    David 

     UPDATE: Figured it out it's line 37 change the <> to =  If (aQuery.fieldbyname('Sum_PreppedQty').asstring = aQuery.fieldbyname('Sum_Quant').asstring) then
    begin

    Did you replaced the line 37 for =  If (aQuery.fieldbyname('Sum_PreppedQty').asstring = aQuery.fieldbyname('Sum_Quant').asstring) then
    begin

    Could you how it looks like line 35 to 38 ?

    1
    Comment actions Permalink
  • Avatar
    Stephane Pilloud

    Hello , 

    Can you advise someone able to create a script for planner book , crew task ... ? 

    thanks 

    Stéphane 

    0
    Comment actions Permalink
  • Avatar
    David Lucchino

    Matias

     

    only change i made was:  replace <> with  =   in line 37

    everything else stays the same from daybook   

    1
    Comment actions Permalink
  • Avatar
    Southernlights & Services

    Hi

     

    just found this and have it up an running no problem.

    Trying to get my head around the script to expand to 7 day output.

    Cheers

    Lindsay

    0
    Comment actions Permalink
  • Avatar
    Keith Boreham

    A 7 day version would be cool. One thing I have been trying to figure out is how to get real dates into the column headers instead of Next Working Day and Next Working Day +1, etc...

    Also, I have modified mine quite a bit and have a few different flavors if anyone is interested. I might need to clean them up a bit first though. I have:

    Eqlists going Out

    Eqlists Coming Back

    All Transport requests including Transport Tasks.

    2
    Comment actions Permalink
  • Avatar
    Andrew Bartlett

    Hi Keith,

    I think you will find quite a bit of interest.... andrew@enlx.co.uk :-)

    I'm really keen to find a way to display to do equipment lists to be returned!  Transport display sound neat.

    Many thanks

    Andrew

     

    1
    Comment actions Permalink
  • Avatar
    Colin Paxton (Edited )

    We have tried a few different options page space wasn't working brilliantly on additional columns for us, everything seemed quite bunched up when we got much over 5 columns and the information became less useful. We have now moved to a list view that shows a little more information per a line but is more desktop friendly and has a load of links to further information (all in we now have about 40 "toolbox" pages) 

    Keith regarding dates if you just want the specific dates the easiest option is:

    For today: output.writeln(DateToStr(Now))

    For tomorrow: output.writeln(DateToStr(Now+1))

    For day after: output.writeln(DateToStr(Now +2))

    Challenge with this page is the "Next working Day" in the default file returns multiple days if you are looking at the end of the week. To get around that I would probably just copy the "if(curDay < 5) then" section up to the column headers and just get it to put in the correct dates based on which day of the week it is.

    If you want day names that is doable:

    First up in the variables section you need to define an array (this is basically just a list of different text items):

    var
    LongDayNames : array[1..7] of string;

    In the general code area you need to then populate the array:

    LongDayNames[1] := 'Sunday';
    LongDayNames[2] := 'Monday';
    LongDayNames[3] := 'Tuesday';
    LongDayNames[4] := 'Wednesday';
    LongDayNames[5] := 'Thursday';
    LongDayNames[6] := 'Friday';
    LongDayNames[7] := 'Saturday';

    Then where you want to output you need to: (The "DayOfWeek(Date)" function returns a number 1-7 based on the day of week)

    LongDayNames[DayOfWeek(Now)]

    Hopefully that makes sense!

    1
    Comment actions Permalink
  • Avatar
    Keith Boreham

    Thanks Colin, that is awesome! I will give it a whirl.

    Andrew, give me a couple days to see what type of cleanup will be required. Right now they are very customized to our business. I'll go in with broad strokes, but you might need to tweak them a bit for your business.

    2
    Comment actions Permalink
  • Avatar
    Southernlights & Services

    Colin and Keith. Fantastic.

     

    0
    Comment actions Permalink
  • Avatar
    Southernlights & Services (Edited )

    Quick question - what is the programming language? Delphi??

     

     

    0
    Comment actions Permalink
  • Avatar
    Colin Paxton

    nxscript is a variation of PascalScript and almost all the online resources related to that apply.

    There is a little information here:

    https://www.nexusdb.com/support/index.php?q=web_applications.htm

    The server also comes with a couple of example nxscript files which give a little more insight into how it works,

    1
    Comment actions Permalink
  • Avatar
    Keith Boreham

    I was able to finally get the dates into the column headers per Colin's suggestions. It turned out very good!

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk