How to Create a Template Builder?

By Sir Topham Hatt
in General Discussion

 Share

Recommended Posts

Grand Master

Sir Topham Hatt

Posted
Posted (edited)

I work in the transport industry and every day, we have to write plans for replacement buses.

We send these plans to a bus company.

Sometimes there may be three or four buses, sometimes there may be 20.

I was thinking whether there could be some sort of template that I can type in a few details and it sort of write the plan for me?

This may be something as simple as a HTML page but I have no idea where to start (and don't know HTML).

 

For example, this is what I would write:

0B00 cancelled:
1 x FS coach 23:00 Station 1 calling at all stations to Station 2, then set down as required to Station 4
1 x FS coach 23:35 Station 2 calling at all stations to Station 3, then set down as required to Station 4
1 x FS coach 00:05 Station 3 calling at all stations to Station 4

The BOLD ITALIC parts are all the bits that need changing depending on what bus plan I am creating but wanted to save time (and help with consistency) and have everything else pre-set as a template.
It would be great if there was a box that I can start typing in the different names of the stations and as I type, it start making suggestions (an extension to this is also searchable by a special 3 letter code that each station has).

Is a simple HTML page with a box that gets filled with the details the way forward?  Or is there something else I should look at (like Excel or Word?).  I did think about Access but I don't know many people who use that any more and all I remember is that you can make pretty buttons, although as it's a database sort of thing, then it could be perfect for this.

This must be able to be run locally - nothing online (again, for now - we use Sharepoint at work but think something simple for now should fit the bill).

I can't get too deep into this as the timetable changes twice a year so there needs to be some sort of manual input for timings instead of a database to select specifics (for now).

Thanks for any pointers.

Link to comment
https://www.neowin.net/forum/topic/1427814-how-to-create-a-template-builder/
Share on other sites
Grand Master

Sir Topham Hatt

Posted
  • Author
Posted (edited)

So far, I have this: 

<!DOCTYPE html>
<html>
<body>

<h1>Bus Template Planner</h1>

<form action="/action_page.php">
  <label for="thc">Train Headcode:</label>
  <input type="text" id="thc" name="thc">
  
  <label for="activity">is:</label>
  <select name="activity" id="activity">
    <option value="cancelled">cancelled</option>
    <option value="terminating">terminating at</option>
    <option value="starting">starting at</option>
  </select>

  <input type="text" id="lname" name="lname"><br><br>
  
  <label for="lname">Last name:</label>
  <input type="text" id="lname" name="lname"><br><br>
  <input type="submit" value="Submit">
</form>
  
  <label for="template">This box will have the completed template in it ready to copy:</label>
  <input type="text" id="template" name="template"><br><br>

</body>
</html>

What I need to do (to remind me as well as get some assistance on):

  • When someone selects either "terminating at" or "starting at" from the drop down box, a new box appears next to it where the user can type in the station name
    A development of this will be as the user is typing, it will automatically try and fill in matches using either a proper spelling (such as London St Pancras, or users can type in a short code and it'll fill in the actual name - SPT for St Pancras in this example).
     
  • As the user is filling in details, it'll automatically fill in the box at the bottom with the text as a sentence so the user can copy it and paste it in an email.
  • 2 months later...
Experienced

C:Amie

Posted
Posted

How comfortable are you with coding? If you want to go to town on that you can write a web service to do it, which you have said is out of scope for now. A static HTML file and JavaScript that contains all of the logic as well as the station names and lookups, while performing the searching without any sort of web query would be the next approach - do you have a web server to run this from or are you looking at running it off disk locally?

If you are less comfortable with programming, then doing this in Microsoft Access or FileMaker Pro could be a sensible compromise and would allow you to do most of what you asked - I appreciate that you said no database at this point, however if you have MS Office, it's pretty point and click vs SQL Server or MySQL.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Posts

    • PSA: Some other versions of Windows are losing support on October 14 too

      By Geezy · Posted

      Unlike Chromebooks and Windows there is no commercial push behind it so not many devices are shipping with it, although Steam Deck is an exception here. For people into PC gaming they are working on projects like Bazzite but it is an independent thing, not a commercial push. You can play MMOs on Linux. RuneScape, World of Warcraft, Eve Online, FF14, Elder Scrolls Online... Regarding professional work, most of what people do could be done on Linux, it would just be edge cases where this isn't possible.
    • Bulk Rename Utility 4.0.1.0

      By Copernic · Posted

      Bulk Rename Utility 4.0.1.0 by Razvan Serea Bulk Rename Utility is an easy to use file rename program (a.k.a. file renamer). Renaming multiple files and/or multiple folders has never been easier. It has a small memory footprint so it can be left running all the time without consuming all your memory. Add date/time stamps, replace numbers, insert text, convert case, add auto-numbers, process folders and sub-folders... plus a whole lot more! Bulk Rename Utility allows you to easily rename files and entire folders based upon extremely flexible criteria. Bulk Rename Utility is free of charge for personal, private use, at home. To use Bulk Rename Utility within a business entity, company or for commercial purposes, a commercial license is required. Bulk Rename Utility key features: Rename multiple files quickly, according to many flexible criteria. Rename files in many ways: add, replace, insert text into file names. Convert case, add numbers. Remove or change file extensions. Check the detailed preview before renaming. Add "Bulk Rename Here" to the Windows Explorer for quick access (optional). Directory recursion - process files/folders in all sub-directories too. Use Regular Expressions to rename files / folders. Use Javascript to rename files / folders. Rename files from an input text-file list (CSV). Create an Undo batch file. Log all renaming activity to a log file. Change file and folder date/timestamps (created, modified, accessed). Change file/folder attributes (hidden, read-only, archived). Rename photos using EXIF metadata (i.e. "Date Picture Taken", "Resolution" and other information embedded in all JPG photo files). Rename MP3 files using ID3 tags (a.k.a. MP3 ID3 tag renaming). Rename files using Windows File Properties (e.g. length, width, height, rate, publisher, title, etc). More than a hundred attributes for different file types. Change EXIF date taken information. Bulk Rename Utility 4.0.1.0 changelog: Added the ability to open a .bru file by double-clicking it while Bulk Rename Utility is already running. Added a popup error message if a .bru favourite file cannot be accessed when opening it. Added a popup error message if a .bru favourite file cannot be saved. Increased the supported line length in .bru files. Fixed an issue where the “Scanning... please wait” message was never dismissed when dragging a folder into Bulk Rename Utility. Fixed a crash when starting Bulk Rename Utility and auto-opening a .bru file that is no longer available Download: Bulk Rename Utility 4.0.1.0 | 11.5 MB (Free for personal use) Download: Bulk Rename Utility Portable | 20.7 MB View: Bulk Rename Utility Home Page | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware
    • PSA: Some other versions of Windows are losing support on October 14 too

      By eilegz · Posted

      nope only 21h2 sadly.
    • AdGuard is yet another app to block Windows Recall

      By Co-ords · Posted

      just remove the junk. Plenty guides online to show you how.
    • Fort Firewall 3.18.8

      By Copernic · Posted

      Fort Firewall 3.18.8 by Razvan Serea Fort Firewall is a simple and effective firewall application designed for Windows 7 and later versions. It offers a range of features to help you control and monitor your computer's internet access. With Fort Firewall, you can filter network traffic based on various criteria, such as network addresses, application groups, and even specific service names like SvcHost.exe. This allows you to have more control over which applications can access the internet and what type of data they can send or receive. One of the key features of Fort Firewall is its ability to limit the internet speed and usage for specific application groups. This can be particularly useful if you have certain applications that tend to consume a lot of bandwidth, such as video streaming or file sharing software. By limiting their access, you can ensure that other applications still have enough bandwidth to function properly. Fort Firewall also keeps track of your computer's internet traffic statistics, allowing you to see how much data has been sent and received over time. This information can be displayed in graphical form, making it easy to understand and analyze. Under the hood, Fort Firewall uses the Windows Filtering Platform (WFP) to monitor and control network traffic. This ensures that it integrates seamlessly with your Windows operating system and provides a reliable and efficient way to manage your computer's internet security. Fort Firewall 3.18.8 changelog: Driver: Fix connection's direction on reauth (#597). Driver: Rework paths handling (#593). UI: Show alert popup on startup too. UI: Update SQLite to 3.50.3 Download: Fort Firewall 64-bit| 6.3 MB (Open Source) Download: Fort Firewall 32-bit | ARM64 View: Fort Firewall Website | User Guide | Screenshot Get alerted to all of our Software updates on Twitter at @NeowinSoftware

  • Recent Achievements

    • Dedicated
      Amadou earned a badge
      Dedicated
    • One Month Later
      TheRingmaster earned a badge
      One Month Later
    • First Post
      smileyhead earned a badge
      First Post
    • One Month Later
      K V earned a badge
      One Month Later
    • Week One Done
      K V earned a badge
      Week One Done

  • Popular Contributors

    1. 1
      +primortal
      642
    2. 2
      ATLien_0
      243
    3. 3
      Xenon
      182
    4. 4
      neufuse
      154
    5. 5
      +FloatingFatMan
      123
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!