What is an Administrator?
The first userid and password is administrative level. It can not be deleted and has access to all pages. Only administrative accounts can create other accounts. Other administrative accounts can be added by checking administrative on the account settings page when it is created. General accounts cannot create accounts. They only have access to pages that have been published, created by them, or are shared with them.

How do I make a menu?
In the settings menu click menu create. Enter a title (used as a link so be descriptive, but short). There are many more options, but you can go with the defaults and click submit. Three new options appear; edit/add, menus, and input. To add a link to a menu or input form all you need is their object id. Click menus or input and select and copy the row with the object id you want. Go to edit/add, paste it, and then submit. Now you have content. You can change the descriptions or use the settings to hide it. Until you publish, only you and an administrator will be able to view the menu. Any time you need to get back to the settings page go to your personal menu and choose the share or settings link next to the menu name.

What is the Main Menu?
The main menu shows links to published menus and input forms. It has a link to the personal and settings menu. By default it is the menu that comes up when you first log in, but your account can be set to go to any page first. Published menus and input forms have an option not to be shown in the main menu and can instead be shown in other menus, or not at all.

What is the Personal Menu?
Your personal menu lists all the menus, tables, and input forms you own. It also shows pages that have been shared. You have full access to change the settings of these pages by clicking the link next to the page name. Unpublished pages can only be accessed through your personal menu. Administrators can view all pages including those that no longer have an owner.

What is Publish?
A published page is available in the main menu and can be used by all users. The first option in the settings page for input forms, menus, and tables is a checkbox to publish. An unpublished page is only available to the author, to others by sharing, or to an administrator.
    1. Unpublished and not shared – Author and administrator
    2. Unpublished and shared – Author, specific shared users, administrator
    3. Published – All users
Publishing a page does not give everyone rights to settings. Settings can only be accessed by the author, administrators, and by shared users.

How do I make changes?
In your personal menu there is a link at the top left for the settings menu. The settings menu has a link to update your account information or create new input forms or menus. As you create new input forms and menus they will be listed in your personal menu.

What do I have access to?
Administrative accounts have access to everything and are the only accounts that can add new users. General users have access to published pages, pages they create, or pages shared with them by other users.

What is Sharing?
Sharing allows an owner of a page to share full rights with another user. The share menu lists all personal profiles and also the profiles that currently own the page. Choose from that list to add someone.

How do I change my Account Settings?
In the settings menu choose My Account Password (Edit). Your account id and personal profile cannot be changed, but all other information can, including your password. Only an administrator can create an account.

How do I make a database table?
In the settings menu choose Database Table Create. Enter a unique table name. You can have up to 255 columns. For each column you need to select a data type.

MS Access	SQL Server	Definition
Yes/No	BIT	(Integer: 0 or 1) True/False, Yes/No, On/Off
Number (Byte)	TINYINT	(Positive Integer 0 -> 255)
Number (Integer)	SMALLINT	(Signed Integer -32,768 -> 32,767)
Number (Long Integer)	INT	(Signed Integer -(2^31) -> (2^31)-1)
(no equivalent)	BIGINT	(Signed Integer -(2^63) -> (2^63)-1)
Number (Single)	REAL	(Floating precision -1.79E + 308 -> 1.79E + 308)
Number (Double)	FLOAT	(Floating precision -3.40E + 38 -> 3.40E + 38)
Currency	MONEY	(4 decimal places, -(2^63)/10000 -> ((2^63)-1)/10000)
Date/Time	DATETIME	(Date+Time 1753-01-01 -> 9999-12-31, accuracy of 3.33 ms)
Text/Memo	VARCHAR	(Variable-length non-Unicode string to 8,000 characters)

I lost my password.
If you lose your password an administrator will need to delete your account and recreate it with a new password. If you are the administrator contact us and we can reset your password.

What are view, update, delete and add?
Input forms allow any combination of these options. If the input form is view only, no changes can be made. Update allows changes to individual cells. Add will append new rows. Delete removes rows. A combination of view and add would allow both of these options, but not update and delete. More than one input form can be created for the same table. So you could publish an input form with fewer rights and keep an unpublished one with full rights.

How do I copy from Excel?
Select the area in Excel and copy (ctrl-c). Click on the top left destination cell in the Input Web Wizard and paste (ctrl-v). The add view will add additional rows if they are needed. If some of the cells copied from Excel are beyond the last column of the input form they will be ignored. Databases have a fixed number of columns. You can also copy from other sources and from inside the input web wizard. This includes being able to select either rows or columns.

What are short cut keys?
The browser has limited short cut keys. Here are some of the keys that have been added to the Input Web Wizard to select and modify data in cells.

Keystroke	Command
Alt-S	turn off multiple cell paste and use browser default
Ctrl-C/Ctrl-Ins	copy selection area
Ctrl-Home/Ctrl-End	beginning/end of input form
Ctrl-Up/Down	up/down to first/last cell in column
Ctrl-V/Shift-Ins	paste selection area
Ctrl-X/Shift-Del	cut selection area
Ctrl-Left	last cell in row
Ctrl-Right	first cell in row
Ctrl-A	select all
Enter	move to next cell
Home/End	move to first/last cell in current row
Right/Left	move right/left next cell
Shift-Tab	move to previous cell
Tab	move to next cell
Up/Down	move up/down column next cell
Shift	In combination with above selects an area
Left Click-Drag	select Area
Click Headers	select row/column

How do I turn an input form into a report?
Create an input form. Click view. Unclick update, delete and add. Use the where option to show only certain data for each column. This works the same as the where row at the bottom of the menus. This option is available on the settings page under Change settings of a column. Choose the column and click go. When you add the input form to the menu you can call it a report or view in the title to indicate that it is view only.

How many input forms can I have?
There is no specific limit to how many input forms you can have. Your service offers a specific number of database tables and storage space. The basic service offers 20 database tables and 100 megabits of space. You can have several input forms for the same table. There is a small amount of settings data stored in the database to create an input form, but the data in the table uses the majority of the memory.

Return to Top