Help with an easy form for logging jobs

Discussion in 'Programming' started by Fullhouz, Feb 5, 2013.

  1. Fullhouz

    Fullhouz Member

    Joined:
    Feb 6, 2001
    Messages:
    46
    Likes Received:
    0
    First, I'm a dirt engineer, not a programmer. This is probably a stretch as a programming question but a little more than a shared spreadsheet. We've used a paper log form for 40 years and it seems there has got to be a better way using a database form/web app/google doc, maybe/some new tablet tool. The paper log book is used by 30 or so managers to log clerical jobs. When the clerical staff finishes a job, then they'll complete the log book entry. In simple terms, here is what the app needs to do:

    Located on the WAN, nonpublic; no security;
    simple table entry with 6 labeled columns, no wizards needed;
    entries need to include hyperlinks to .doc/.pdf on the network;
    open field entries shouldn't be necessary while using lookup tables for easy-of-use;
    each job is one row in the table;
    jobs only need to be kept for 3 days max;
    each day a new blank form is started and previous day's form is available;
    many concurrent users entering data;
    tool tips would be a plus;
    as another plus, would like to automatically email the requester when the clerical job is finished;

    So is there something out there off-the-shelf or do you have a suggestion for me?

    Thanks in advance.
     
  2. Loading...

    Similar Threads - easy form logging Forum Date
    What is the preffered way of checking if a form is submitted in php? Programming Apr 27, 2017
    How do I turn off the “NioEndPoint” Logging in Spring Boot? Programming Apr 21, 2017
    Web Form Length Question / Opinions Programming Jan 11, 2017

  3. EagleKeeper

    EagleKeeper Discussion Club Moderator<br>Elite Member
    Staff Member

    Joined:
    Oct 30, 2000
    Messages:
    42,600
    Likes Received:
    1
    If the entries are not completely concurrent; then a spreadsheet on a shared drive will work.
    New worksheet for each day.
    User opens worksheet, updates and closes sheet

    Now if you want two users to be enter/updating at the same time; then you may need to go to a simple database type system.

    There are free SQL based databases and you just need a front end with some smarts for the users.

    The most difficult part is designing the front end form to make the end user comfortable/hand holding
     
  4. Fullhouz

    Fullhouz Member

    Joined:
    Feb 6, 2001
    Messages:
    46
    Likes Received:
    0
    A dozen clerical folks will kept this form open all day so I think this kills the spreadsheet idea. So any suggestions on which database platform is the easiest to work with?

    Our IT department is exclusively using Oracle but I'd prefer to keep it simple with something stand-alone, if possible.
     
  5. Ken g6

    Ken g6 Programming Moderator, Elite Member
    Moderator

    Joined:
    Dec 11, 1999
    Messages:
    12,651
    Likes Received:
    295
    This sounds to me like a job for a bug or project tracker system. Free software for this kind of thing includes BugZilla and Trac - though Trac is strongly oriented toward software and the Subversion version control system. A lot of companies lately seem to prefer the commercial product Jira, which can be hosted on their site or your own.
     
  6. Markbnj

    Markbnj Elite Member <br>Moderator Emeritus
    Moderator

    Joined:
    Sep 16, 2005
    Messages:
    15,688
    Likes Received:
    8
    We use Bugzilla. It's functional but has an interface only its creator could love. Jira is very good, imo.
     
  7. Leros

    Leros Lifer

    Joined:
    Jul 11, 2004
    Messages:
    21,883
    Likes Received:
    6
    Im a big fan of Jira.
     
  8. KB

    KB Diamond Member

    Joined:
    Nov 8, 1999
    Messages:
    4,649
    Likes Received:
    14
    A lot of people might say bad things about it, but Microsoft Access is a tool built for these situations. m ight be cheap to hire somebody to build it for you.
     
  9. EagleKeeper

    EagleKeeper Discussion Club Moderator<br>Elite Member
    Staff Member

    Joined:
    Oct 30, 2000
    Messages:
    42,600
    Likes Received:
    1
    Access had the problem that there was a database control file being created during updates by the program itself. Such precluded others from getting to the database in a write configuration. Ran into that back in '97.

    I do not know if it has been fixed.

    To use it as a back end with a simple interface program works well; I have implements multiple applications for small businesses that do not have the time/skills to use a large commercial program of setup something like Rally/Jira.

    Most times; the turn around for a prototype is within a week; the screens are simple and rules followed that were defined by the client. This way there is no real rework needed. They got what they asked for. :thumbsup:
     
  10. douglasb

    douglasb Diamond Member

    Joined:
    Apr 11, 2005
    Messages:
    3,163
    Likes Received:
    0
    Google docs spreadsheet might work.
     
  11. BigDH01

    BigDH01 Golden Member

    Joined:
    Jul 8, 2005
    Messages:
    1,487
    Likes Received:
    4
    Is there a way to make opening a new tab the default behavior for clicking on a link in Jira?
     
  12. Munashiimaru

    Munashiimaru Junior Member

    Joined:
    Jan 14, 2013
    Messages:
    23
    Likes Received:
    0
    Then 20 years later when it's become a monster that can not be satiated due to feature creep someone will be demanding to convert it to a real database.
     
  13. BigDH01

    BigDH01 Golden Member

    Joined:
    Jul 8, 2005
    Messages:
    1,487
    Likes Received:
    4
    MS Access Sharepoint Edition.