HomeContact Us
Placeholder Picture
ApplicationsTechnicalVideoGetting Started

Technical..

Terms How it all fits together Creating a new Listforms form overview Creating a new Listforms form detail Copying and install an existing form and database Barcode Printing Barcode Reading Linking Listforms database to external program Creating a new Listforms form overview SQL
Terms

Click here to go to the  "Terms" page >>

How it all fits together

Click here to go to the "How it all works" page >>

Adding new users , changing passwords, etc

Click here for the video "Adding users and changing passwords" page >>
To add a users, and assuming you have 'admin permissions' ,  go to the main page and select 'Admin' then 'Access Control' 

Placeholder Picture


The  'List Users' page displays all the current users and their roles and permissions  ,  gives the user the option to edit or delete and existing user (see #3) , and provides the ability to search the list of existing users by entering all / or part of the name (see #2).   To add a user , press the 'Add New' (see #1)  

Placeholder Picture


The 'Insert User' page allows us to to add the 'User name ' (required)  , the user's email , first and last name, and the password / password confirmation (required).  THen press 'Submit'

Placeholder Picture


The 'List Users' page will be re-displayed  - but this time the new user  is in the list (see #1) .  Not that the default role is 'Minimal' (see #2).  To change the role, or any other setting for the user, press the 'edit icon (see #3).   To delete the user, press the  delete icon , the 'X'  just below the edit. For our purposes, press the edit icon.

Placeholder Picture


The 'Edit User' screen displayes, and allows you to edit, the existing user info. To change the 'Role', (see #1) , click on the new desired role. After pressing 'Submit', the 'List User's page will be displayed again, with the updated role.

To change the password select 'Change password' (see #2) 

Placeholder Picture


The 'Change Password' form will be displayed.  Enter the new password, and confirm the new password - then press 'Submit'.  The password will be updated and the 'List Users' form will be re-displayed.

Placeholder Picture



How to add edit your own help files

Click here to go to the "Edit Your Own Help Files" >>

Creating a new form and loading it to Listforms - overview (newformoverview)

Click here to see Overview of creating a new form >>
Click here to see Typical form controls (textboxes, lists, etc) >>
Click here to see How cascading fields work >>

Creating / editing a form - details  (newformdetail)

Click here to go to Details of creating a new form >>


Copying and install an existing form and database from Listforms or another user (package)

The easiest way to get stated in Listforms is to use, or at least start with, an application that someone else already created. Listforms makes this a 10 second or less task.

If someone has already sent you a link to a package, just click on the link and the package (app and the database) will install automatically for you.
Listforms does not guarantee any application, in anyway, but this page lists applications that were developed internally or that we believe to be both useful, functional, and safe.

How to add a package (application) and create one for sharing video >>


Barcode Printing   (bar code printing)

In order to accommodate the maximum number of user situations , we have created a free Google spreadsheet program that actually prints the labels. Google spreadsheets are free and online, requiring no external program to be loaded, work with just about any office printer,  and , if your printer is "unusual" you can easily change the online spreadsheet to work with virtually any printer. 

First Time - 2 Minutes Setup
1) If you don't have a Google account (often called a gmail account) , create one and logon.

2) Click on this link : https://docs.google.com/spreadsheets/d/1ifM4Nw0iuTlfkiGW87yDiH6cL9NhNfnztaVmVtEHIaY/edit?usp=sharing
and the "shared" version of the barcode spreadsheet will be displayed.   Save you version by selecting "File" and "Make a copy..."  .
You may call it any name you would like.  Select the "3 Column Barcode" tab at the bottom of the spreadsheet.

3) Copy the url (web address) of the newly saved spreadsheet  ( this is YOUR copy of the spreadsheet - and you can share with whomever you like) .

3) With the spreadsheet open, also open MIDSTT.

4) Go to MIDSTT "Settings" page (reached from main page) and copy the URL of the spreadsheet into the field called
"URL (web link) to YOUR copy of Google Sheet Barcode Printing spreadsheet". Then set both the "nextlot", and "lastlot" to 10,001, and 10,000.

5) Submit and save the changes to "Setting", then go back to the main page and select the Admin, 'Database Access'.

6) Note the Server, Port, and database name from "Server Information" to the spreadsheet. And the Username and password from "Read-Only Credentials"

7) Go to the MIDSTT NonSeqential tab on the spreadsheet and copy the vales from above into the corresponding fields on the spreadsheet.

8) Close the spreadsheet.


To print labels - in 30 seconds or less
1) From the MIDSTT main page, select "Print Barcode Labels"

2) The "Location labels" option will print the labels for the location already entered into MIDSTT.

3) Unlike Location Labels, Lot Labels are actual printed BEFORE the lot exists, and are actually scanned into MIDSTT at the time or receipt or manufacture in order to create the lot. Because of that, MIDSTT remembers the number of the last lot label you printed and and the new print run starts from there. In other words, all you have to know is how many new labels you want to print.

4) After selecting the Locations or Lots selection and entering the quantity of labels, if printing lot labels, then press submit.

5) The next screen provides the hot link to the the spreadsheet and labels

6) The '3 Columns Barcode ' tab will show the created barcodes.

7) With the labels (Office supply 30 labels per sheet, 2.625 wide by 1 inch) in your printer  
      Highlight the labels you want to print,  
      Press "ctrl P" , or "Print" from the spreadsheet File Menu.
      Select options "Selection",  "No gridlines", "Actual Size" and "Portrait"
      Press the "Print" button and the labels will print.  

Barcode reading  (bar code reading)

Barcodes are a great way to ensure accuracy and reduce labor cost of data collection - but they are almost always "optional" . ACCURATE typing yields the same result as a barcode scan. Labels , with or without the barcodes, are NOT optional , at least not optional on inventory items.

Fortunately barcode printing and scanning is now available on any budget. As the 'Barcode Printing' section showed, barcodes are now as cheap as office mailing label stock. Barcode scanning MAY be as cheap as free and , depending on the situation, can range to many hundreds of dollars.

Barcode reading can take three different routes -
1) Barcode scanning using a smartphone or tablet. Scanning is as simple as pushing a button but has limited reading range range (8 to 12 inches).

2) Scanning using a Bluetooth scanner. A scanner is "paired" to the browser device (PC, smartphone, tablet) and then just pull the trigger to scan. These devices can be $50 or less for short range scanners , under two feet, to many hundred dollars for long range scanners.

3) Using an "all-in-one" barcode scanner AND browser device. This combines a permanently linked browser device and scanner. THese can range from under a thousand to several thousand dollars.

This section will cover the first case, using a smartphone to scan barcodes. This approach uses software on a smartphone or tablet (at the time of this writing, iPhone's barcode scanning did not work within a browser and cannot be recommended).

Software scanners on a smartphone use the on board camera. To activate, typically, the user only has to select a text field on the web page , or any place the keyboard normally pops up. On the on-screen keyboard is typically a special key with a bar code symbol on it. To scan the barcode the camera is pointed at, all you have to do is press the barcode button.

There are free products available , we have had good luck with "Tec-it" which costs about $3.99 per phone. (note : easier NOT to install the Demo version of Tec-it first) . It is easily available on "Google Play". We do NOT recommend the free version and suggest you NOT install it as it makes installing the $3.99 version more difficult to install.

Placeholder Picture

Tec-its popup keyboard
 

Linking to the Listforms database (Google spreadsheet example)


Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.


email notifications (automated)


Emails may be sent either via a simple url (so a web address that is either clicked can actually send an email) or the email may be run based upon a Listforms timer. If the email is sent based upon a timer, the timer may first run a SQL statement and then incorporate the results of SQL statements into the email (note that .

Example 1 ) Send an email via a user's click on a form. The user of a purchase order form want to the selected vendor an acknowledgment that the purchase order was created. After the initial form is submitted a second form pops up with a link. If the user clicks the link and email with the particulars of the order is sent to the vendor.

Example 2) A timer is created that wakes up on an interval basis and runs one or more SQL commands. The SQL command may update the database or , create an emails that is automatically sent.

Sending an email WITHOUT a timer
From the 

Placeholder Picture

There are a variety of ways to create url addresses.  They may be 'static', in other words typed in and never changing, or they may be dynamic and created based upon previous responses and/or database values  (see CoffeeCup programming, and AJAX)

Placeholder Picture

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.

Placeholder Picture

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.

Placeholder Picture

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.

Placeholder Picture

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.

Placeholder Picture

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.


JavaScript and AJAX

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.

SQL

SQL, often reffered to as "Structured Query Language" is a standardized way of talking to most (80%) databases, including Oracle mySQL, and Microsoft's SQL Server.  Every client has their own mySQL database in Listforms that they are granted full access to. In addition, teh Listforms forms use SQL to pull data, including AJAX, SQL triggers are also supported.