The Form Designer lets you change the position of your elements on the page. By default, each field is on a new line on the left of a form.


By default, all fields line up on the left of a form

For space-saving or aesthetic reasons, you may wish to arrange forms with multiple fields on one line, or with more space between the lines.


Rearranged Form

A redesigned form will be presented the same way in detail view, edit view and when you are adding a new record. You can put the fields in any order.

When you are doing data entry in redesigned forms and you tab between fields, the tab will jump to the next field to the right.

-----

To rearrange the layout for a form, first go to your table.

Go to Design > Form Designer.



Wait a moment while the form designer loads.



Your form fields will show up against a dotted background.



Hover your mouse over the field you want to move and your cursor will turn into a multi-directional arrow indicating that you can move the field. Click and drag the field to a new spot.



Move all fields to their new spots. All new field positions are saved as soon as the item is dropped in the new spot.

Reset a Designed Form

If you would like to return to the left-aligned form. Go to Design > Form Designer and click the "Reset Defaults" link on the bottom of the right hand side of the page.

Always Re-Design a Form when you add a new field!

When you add columns, new fields float to the top left. After adding a new field, use the form designer to place it where you want it.

Read more about database tables on wikipedia.

Group Menu Visibility sets the visibility of Menus by User Groups.

Quick Group Menu Visibility

To change visibility of all menu tabs for a group go to Develop > Manage Menus. Click the button at the top that says "menu item visibility".

Select the user group you want to set menu visibility for.

Click the checkboxes on the right next to the menu items to make a menu tab visible to the user group. You can click the plus to show sub-menus.



Note: A user will only be able to see a table linked to in a menu if they have permissions to the table under Table Security.

Classic Group Menu Visibility

The old way of editing Group menu visibility. If you are on a mobile device, you can use this method to edit menu visibility. Go to Develop > Menus > on the left click the "Classic Menus" link. Click the name of the Menu Item. You are now in the detail view for that item.

On the right (the Footer), you will see a link that says "Group Menu Visibility". If any User Groups have permission to see the menu tab, you will see them listed here. You will also see a link that says "Add", click it to add menu tab visibility for more user groups.



Use the checkboxes to toggle visibility on or off.

Hidden, but not necessarily inaccessible

Note that Group Menu Security does not limit your users from accessing your tables. Hidden menu tabs can still be accessed if a user types in the /db.aspx to a table. For complete security set up Table Security.

You can create a Sub-tab that links to any area of your site - from an individual record, to a table in Grid View.

1. Go to the table, view, and item (if applicable) that you want to link to.

2. Go to Develop or any Menu Tab and at the bottom is "+ add submenu. (As seen below)




After you add the menu, you will see a message appear saying the menu has been added. The name of the menu, in this message, is a link to a page that will let you modify additional properties of the menu. Click the link to do the following:

Choose an icon
To choose an icon to represent your link (optional), click the "pick icon" link. Browse through the icon pages and when you see an icon you like, click on it. The icon will appear in the tab, to the left of the tab name.

Change Permissions
You can change permissions on new menus after they are created. If you do not change permissions, only members of your group can see it. For example, if you are logged in as an administrator, only administrators will be able to see the menu. If you'd like members of other groups to see the menu, click the Group Menu Visibility link in the right hand rail to add more groups to the list of those who can see it.

Some definitions of commonly used terms.

You can determine which User Groups have permission to see every field in every table. If you have recently added a field, you will need to set column security for your users to be able to see the new field.

First, you may wish to check that they have permission to see that table by checking the Table Security.

To change column visibility, go to the table you want to change security for, then go to Admin > Manage Tables.

Find your table then click the link below it that says "column security".



You will see a table listing all of your groups on the left hand side with the names of the columns along the top.

If there is a check mark at the intersection of the two fields, that user group can see that column.

Add Qrimp's POP3 Email account checker to display your email addresses with a message count in brackets beside the name of the email address, like this:

name@mywebmail.com (7 new)
mynickname@mydomain.com (10 new)

You can set up each email address to link to the sign in page for the email provider. Depending on your provider, you may also be able to add automatic sign in when you click on the link.

You must be a site admin to add POP accounts.

Go to Admin > POP Email Accounts.

In the name field, enter the text for the link. You can use the email address name ie: "name@mywebmail.com" or something like "My Web Mail Account".

In the userid drop-down list box, select the user who will check the account.

Enter the POP Server ie: mail.myprovider.com. If you are unsure what your POP Server address is, check email provider's help files.

In the popusername field, enter the email address, ie: name@mywebmail.com

Enter the actual current password for the email account. If you are creating a POP Account for someone other than yourself, you will have to get them to do this. The password will always be displayed as stars (**********) to every user.

Enter the url of your email service (the page you visit to check your account). If your provider allows for automated sign in using a url, you can enter the specified url, and use square bracketed field names to populate the required user-specific information from the Qrimp POP Email Accounts table, as follows: popusername poppassword

Do not enter anything in the lastupdatedate field. It will update automatically.

Enter 0 in the messagecount field.

That's it.

Modules add functionality to your app at the click of a button. Modules contain pre-built database tables, views, menus, operations and more.

Some parts of modules may be included in other modules. As an example a "Priorities" look-up table might be included both an events module and a tasks module.

There are simple modules such as look-up tables for countries or states or complex modules like the PayPal Order IPN.

A List of Current Modules

Note: Not all modules are available in all apps

Current Modules

Look-up tables are tables that are connected to other tables as drop-downs to make data entry easier. This is very convenient for oft-repeated data entry areas, such as country or say 'productcategory'. Enabling users to select data from a drop is great for data integrity, increasing accuracy and reducing spelling errors.

In this example, FurColor is a look-up table:

TeddyBears
Name: Fuzzy
Nickname:
FurColor: BrownWhiteBlueBlackBeige

I could only have this drop-down if I already have a FurColor table in my application.

See also Creating a Look-Up Table, Adding a Drop-Down Field, and Convert a Field to a Drop-Down.

You can set a default start page for each group in the User Group Settings. This determines which page any user in that group will see when they log in. By default, the start page for all user groups except anonymous is the Dashboard. The anonymous users group sees the login page by default, because they are not authorized to view any information unless you specify that they can.

You can change the default start page to almost any page or view in your app. Copy and paste a url with multiple Query String Parameters to sent user groups to very specific records and views.

Changing the Default Start Page

First, copy the url to the page you want your user group to go to. This could be something like "db.aspx?t=Projects&vid=11&id=4". This would take the user to the detail view for your Project with an id of 4.

Then, go to Admin > User Groups.

You will see a table showing existing user groups. Click the edit icon in the id column of the group you want to change.

Copy your url into the Default Start page field.

Click save.

To test, have a user from that group, log out and log back in to the system. When they log back in, they should start out at the new default start page.

If you don't change this setting, the default view is always the table/grid view, showing all of your data, dependent of course, on your Security rules.

On the Develop > Table Settings page, there is a field called "Defaultview" with a drop-down list that lets you choose among the many Views (these are basically page templates) in your application to set which one is the default for that table. This is handy if you want people to see your table laid out in a particular way.

If you would like to display your information on a page in a custom layout, and none of the pre-configured data Views match the data in the table or the desired layout effect, you can create your own view.

In the Menus, go to Design > Views and click "Add New"

Create a descriptive name for your view that will help you remember it. For example, if you are creating a view showing only the images from your table, with a border around them, name the view "Images With Borders". In the "Description" area, use Qrimp Square Brackets notation or urls to pull in data from your table.

Formatting your data with HTML and CSS
Enter HTML and inline CSS tags in the description field to control how your data is displayed.

For example, let's say we had a small inventory table with four fields: id, ItemName, Description and ItemCount. We'll want to display only the name of the inventory item.

We can get the using square brackets as such - ItemName

We can also style this information. Let's imagine that we wish to make the ItemName an h2 and we'd like to make in a div with a red background.

Here is what our HTML and square brackets would look like:




And here is what our result would look like:



This is just a basic example. Learn more about pulling data into page templates with Square Brackets

Under the Develop menu tab, you will see a menu called Clear Menu Cache.



Clearing your menu cache will update the menus to reflect any changes you have made. Menus are cached to improve system performance by alleviating the need to fetch the menu list from the database for each page view. The downside to this approach is that changes to menus aren't always immediately reflected. Logging out and relogging in will also clear the menu cache, so users will always have the latest menus when they log in.

You can use custom SQL statements get information about your existing tables and to manipulate your data.

The query builder is in Beta Mode. You can use it to generate your own custom queries for your database to return very specific resultsets or even execute UPDATE, INSERT, or DELETE statements, but of course be careful with these.

If you select a table from the query list and click "show sql," a select statement will appear. Click Run Query to return results.

You can save your queries also. If you have selected a table, then save a query, a link will appear to the right of the query list that you can click on to view the results in your browser and save a menu that will display these results for you. You can also use these results in Portals.

A look-up table lets you select data from a drop-down list in any one of your tables. Like this:


To let the system know which table you want to pick from, you have to create a look-up table.

Adding a look-up table with Import Data

If you are adding a look-up table with a lot of records, Import data is the fastest way to create it.

Go to Develop > Import Data.


Enter a Table Name.



Check the checkbox beside "First row contains field names".

In the box below, enter:

Clients
XYZ Company
ABC Inc
JKL Manufacturing
etc....

Then click "Import Data!". Leave the advanced features
unchecked for look-up tables.




See also Convert a Field to a Drop-Down and Adding a Drop-Down Field

The "Content Header" or "Header" is the area below the menu tabs and above your records. By default, this area contains the Action Icons that allow you to perform actions and navigate to different Views of your data.


A default content header with a custom message to users of the products table.

Content Headers are completely customizable with a combination of custom messages, HMTL, CSS and JavaScript. You can add Icons, error messages, warnings, shared data, external links, queries and more. (See: Headers and Footers).


A customized content header with fewer icons than normal.

Advanced: For CSS and Javascript in Content Headers

For CSS, declare #contentheader to style the content header.

Writing operations in Qrimp is similar to writing stored procedures. You can use existing operations as templates to build your new operations. To view existing operations go to Admin > Operations.

You can use wildcards with % around a word that you want to restrict your query on. ie: like '%overdue%'.

You can use operations in urls when you are creating Menus tabs, adding internal links, editing the action that is behind an action icon link or in any other internal Qrimp app links. An operation goes to the table in the url and performs a certain action on it.

Composing the URL
To use an operation in a link, simply add "&o=" plus the operation number to the url. An example of a url with an operation restriction would be:

http://myapp.qrimp.com/db.aspx?t=Clients&id=82&o=4.

When the user clicks this link, they will delete record 82 from the clients table.

Operation Permissions

If you create a link using an operation, and the user who can see it does not have permission to perform the operation, they will see the login screen and the error message "you do not have permission to _read__ the _Clients___ table". To give your user permission, you must set up the correct Table Security.

Some things are not yet possible with Qrimp. (We know, hard to believe!) Here's a list of things that have caused our users trouble in the past.

At Qrimp, we know that sometimes the easiest way to find something is with a search.

We have three default ways to search your app:

Site Search
Date Search
and
Table Search



Advanced users can also add a search form to the top of any Table see Table Search Box

If you have too many tables and/or a narrow browser window, you may find that your menu tabs overlap the Content header area of your site, obstruction your view of the Action Icons.

To resolve this issue, you can sometimes press Ctrl and the minus key (Ctrl-) to reduce the text size on the tabs and move them up.

We are working to resolve this issue.

To use synchronizer to work offline, you will have to have IIS7 web server software and the database SQL Server 2005 Express (free) installed on your computer.

Before you get started, think about what your application is for. Which information do you want to track? Which types of users do you want to have? Who will be able to view and change your data?

You may wish to start with a data model. If so, read our Brief Intro to Data Modeling.

Basic steps to creating a Qrimp app

1. Designing your data model
2. Create Tables
   • Option 1: Create Tables Manually
   • Option 2: Import Data
3. Entering and Editing Data
4. Customize your Application with
   • Views
   • Templates
   • Headers and Footers
   • Security
   • Menus

We recommend drawing out a list of tables and listing the columns you want to have before you get started. You can add additional tables, add rows, delete rows, change data types, and drop columns at any time, so nothing is set in stone. Having a structured idea of what type of database you will build before you start will save you time and help you mentally organize your information first.

There are many resources on the web that teach you about database methodology..

Of course, you can also get started with no learning, and figure it out as you go! A good place to start is by adding your first data table. There are two ways to add data: Create Tables and Import Data.

Everything in your Qrimp app is stored in a table, even information about tables. The Table Settings view allows you to modify information about those tables, including which field to use to represent information in the table and which HTML View Template to use as the default if no view is specified.

These icons generally appear in the Content Header, which is displayed at the top of your table below the Menus.

Default Icons

When you build a new table in your Qrimp application, icons are created automatically based on the functionality that is possible within that table and according to the User Groups permissions. You can add or delete icons if you need more or less functionality. You can even create new actions by writing your own operations then choosing icons from the /icons/crystal_project/32x32 and putting them in the Headers and Footers.

Editing Actions

Go to the table and view you want to change the actions for. Then go to Develop > Header/Footer. You will see the HTML for the icons. If nothing is listed, you will need to edit the default header / footer for your table, which is part of the table definition.

The following are some default icons you will see in your Qrimp app.

Views Icons

These icons allow you to change the way you are viewing the data. To learn more, read about Views.
Calendar View
Tree View
Grid View
Reports
Next Item - see NextPrevious
Previous Item - see NextPrevious

Data Editing Icons

Add records, edit or copy existing records, search and delete your data and more.
Create View
Search
View Headers and Footers
Design View
Delete
Cancel
Versioning

Advanced: Hiding Icon Labels in the Content Header

If you do not want to see the word that corresponds to the icon below the icon, you can change the stylesheet to #contentheader.label{display:none} or you can write a sql statement to remove them from all or selected tables. See Stylesheets, CSS and Using SQL Statements.

Use the following query strings options to query your data and drill down into particular records and even columns.

Use these query strings with Qrimp's JavaScript API and Square Brackets to build custom behaviors for your websites and share data on other websites.

Selecting the Data to Display

The most important query string parameter is t, which specifies the table from which to pull data. Since it's the most important, you'll probably use it with the ? like this:
?t=1005 or ?t=HelpTopics

For example, to display Help Topics in a Grid View, you would use this url:
db.aspx?t=HelpTopics

You could display the HelpTopics on the Calendar View like this:
calendar.aspx?t=HelpTopics

Or in a Tree View like this:
treeview.aspx?t=HelpTopics

You can use either the ID of the Table or the TableName. You can get a list of tables from the Develop > My Tables menu.

Formatting the Data

Another useful parameter is the vid parameter which specifies which layout format to use from the Views Table. With views, like with tables, we can use either the ID or the name of the view, like so:
&vid=1 Uses the Grid view.

Combine the t and vid parameters like this:
db.aspx?t=HelpTopics&vid=1 <-- Click it and see. View 1 is the default view, so usually you will not need to specify &vid=1, unless a default view has been specified in the Table Settings.

As another example, let's look at the Help Topics as a list of links:
db.aspx?t=HelpTopics&vid=14

Sorting your data

To order the results by a column, simply add &orderby= to the end and specify the column number to order by. Adding multiple orderby parameters, or values separated by commas will reverse the order. For example &orderby=5 will sort the fifth column ascending and &orderby=5,5 will sort the fifth column in descending order. The sorted column in a grid view will be highlighted. A quick way to sort your data by most recently created items first would be to order by the ID field descending like this:
db.aspx?t=HelpTopics&orderby=1,1

Filtering your data

You can filter your data many ways using the query string. If you would like to limit records to a particular value within a column add &columnname=value where columnname is the name of the column and value is the value for the filter. For example, to display a particular record you can reference that record by the ID.

Look in the location bar now and you will see:
/db.aspx&gotopage=2&pagesize=50&t=HelpTopics Which means, show the item from the HelpTopics table using view number vid and for the Help Topic with id equals ID.

If you would like to be more specific about your query, you can use query operators and query values like so
&columnnameop=
&columnnamequery=

For example, to show only Help Topics that contain the word Parameters in the name, you could use a query string like this:
db.aspx?t=HelpTopics&nameop=contains&namequery=Parameters

To show all help topics with created since May 1, 2008, you'd use this url: db.aspx?t=HelpTopics&createdateop=>&createdatequery=5/1/2008
contains : Find items that contain the query value, same as contains
like : Find items that are like the value, same as contains
not like : Find items that do not contain the query value
startswith : Find Items that start with the query value
= : Find items equal to the query value
<> : Find items not equal to the query value
>= : Find items greater than or equal to the query value
> : Find Items greater than the query value
< : Find items less than the query value
<= : Find items less than or query equal
in : Specify a list of items. Example: &idop=in&idquery=1,2,3
&pagesize= Determines how many records are shown. Do you want 20 Help Topic Links or 50 Help Topic Links By Default, the page size is pulled from the Table Settings
&hidecolumns= Determines which column names should be hidden Help Topics without the description field
&selectcolumns= Determines which column names should be pulled from the database. Show Id, Name and CreateDate
&noheader=true&nofooter=true Hides the page header and footer Help Topics sans Header/Footer These will be useful when using the Share Data feature when you want to include data, but not the menus and content in the right rail. We call it the footer because it appears at the bottom of the HTML source, even though it is rendered on the right hand side of the page. You can use Skins to change this behavior.
_fieldvalue=fieldname This parameter used in conjunction with the id= parameter will show only the contents of the specified column. For example, to show only the description for this Help Topic, use the following url:
db.aspx?t=HelpTopics&id=id&_fieldvalue=description
&qid= Allows you to specify one of your custom Ad Hoc Queries to filter the records or build complex joins among tables.

Users will see export options at the bottom of a table in the grid view, provided they are in a user group (see: User Groups) with the appropriate permissions.

Export options include .xls/.csv export Excel Export, XML export, and Share Data. You can also export your data as Insert Statements to be used in other database applications such as MySql etc.

Share data lets you add data to your dashboard, copy data into other records in your app, other Qrimp app, and even other websites.

Adding an item to your dashboard

See Portals.

Sharing data

There are two ways to get to the share data interface: the link below the grid view...


...and the Open Share icon in the Content Header


When you click the link or the icon, you will see the following popup:



You will see two boxes with HTML. The HTML on the left is for sharing within your app. The HTML on the left is for sharing on the web.

Copy and Paste HTML

Copy and paste a snippet of HTML code. You do not have to understand HTML to do this, but please go slowly and be sure to select and copy ALL of the text in the box!

You can paste this in a portal, a field template a description box, or any other text area in your app. Experiment! If something doesn't work, you can delete it.

This snippet of HTML code pulls in the data and the view (see: Views) and determines whether you are sharing an individual item or the whole table.

Sharing data internally

To share data within your Qrimp App, copy the text (Ctrl+c) from the first share data script and paste it (Ctrl+v) into any text field in any table. The table you have selected will magically pop into that area. The text field must be pasted into a table that is in the same app as the HTML.

Sharing data externally

To embed your data into a separate Qrimp application or display it on another domain, copy the text (Ctrl+c) from the second share data script and paste it (Ctrl+v) into any text field on one of your other Qrimp apps or on any website that allows you to embed HTML and/or scripts.

If Anonymous Access is not allowed for your data and you share the code in a publicly viewable area of your app, the data will not be visible (see: Table Security).

Custom HTML Templates for Shared Data

You can build your own HTML template to format the shared data so that it will appear in your host page exactly the way you want it. Use square brackets to insert particular data items into the HTML template.

Advanced: Sharing data to a local file

You can paste the code for your shared data into any file that you can view with your web browser (save as .html). The first time you are opening a local file that contains a script to pull in shared data, you will need to be online to access the data (does not apply to Qrimp Server users). If your data is not visible to 'Anonymous' users (see: Table Security), you will have to log in.

Once you have viewed the data, you can save the HTML to the file before closing for offline viewing.

Shared Data Display Options

Use Query String Parameters to sort and limit which data is displayed.

Use HTML and inline css to style your shared data.

Images in Shared Data

To ensure that the images and links referenced in your shared data area appear properly wherever you share them, use absolute urls rather than relative urls to reference them within your original table.

Who can share data?

The share data link is not visible to all users by default. To allow a group to share data, you must allow User Groups to view the export options.

Open Share Icon

To simplify the process of sharing data, you can add a module called Open Share Icon available under Admin > Add Module. This module will add an icon to your headers next to the search icon that will open a lightbox with the same content as clicking the share button below the grid view. The Share Icon will be visible on more pages and easier to access than the share link.

Read more about the Open Share Icon

Learn about other Export Options.

Page Layouts tell Qrimp how to display data. Page layouts come in two varieties: Grid and Repeater

Grid

Grid templates are similar to a spreadsheet or HTML table layout and are generally useful to show a lot of data in tables. In this display type, the cell template field applies to each row/column combination.

Repeater

Most all other templates will be the repeater type. In this display type, each record in the table is considered a cell. You can include values from each field in the row by using square brackets notation.

The next/previous arrow icons in the Edit View and Detail View of a record let you page through the items without changing your view.

Previous	Next

The next previous icons

To add the next/previous icons to the top of your records go to the table you want to add them in, then go to Develop > Header/Footer.

Copy and paste the following HTML with square brackets into the Header field of your Content Header

<noeval><td><a href="db.aspx?t=[t]&id=[PREVIOUSID]&vid=11" title="Previous Record"><img align=absmiddle class="noborder" src=[icontheme]/actions/previous.png alt="Previous Record"></a></td><td><a href="db.aspx?t=[t]&id=[NEXTID]&vid=11" title="Next Record"><img class="noborder" align=absmiddle src=[icontheme]/actions/next.png alt="Next Record"></a></td><tr><td> <a class="small" href="db.aspx?t=[t]&id=[PREVIOUSID]&vid=11" title="Previous Record">Previous</a></td><td><a class="small" href="db.aspx?t=[t]&id=[NEXTID]&vid=11" title="Next Record">Next</a></td></noeval>

Note: HTML formatting must be not have line breaks.

If you edit text or HTML in Headers and Footers and Field Templates and other System Tables, remove the spaces between your HTML tags before saving.

The description field of system tables automatically inserts a hard line break when you are entering text, so if you leave spaces between your HTML tags, you will notice extra spaces appearing once you have saved the item.

On the right of the Detail View for an item, you can see the "Item Footer". This is where Attachments and Related Data can be found. Though the item footer appears to the right by default, it can be moved with CSS to appear anywhere on the page.

Editing the Item Footer

To edit your Item Footer go to Develop > Header/Footer. The footer field corresponds to the footer. You can style the item footer using #rightcontent.


See also Headers and Footers and Related Data.

You can upload nearly any type of file as an attachment to your Qrimp app including Word, Excel, PDF, .jpeg, .mp3, .mpeg and other file types.

Each attachment is uploaded to a record in one of your tables.

Viewing Attachments

If attachments to a record exist, you will see a thumbnail or a link to the attachment in the right hand side of the detail view of the record. Images will be displayed as thumbnails. Other documents show an icon that represents the type of document you have uploaded. You will see thumbnails for up to six documents.


To open the attachment, click the link or thumbnail. To change what happens when you open an attachment using Attachment Viewers.

To view all of the attachments to all records in a table, click the attachments link above the thumbnails. You will be redirected to the Attachments table. From there you can sort by columns or use the search function to limit the results.

Adding an Attachment

To add an attachment, go to the detail view of the record you want to attach the item to. Then click the "add" link below Attachments in the right-hand column.

Select your file or files and click the upload button. Once you have uploaded your file(s), they will be attached to the item, and will appear in the right-hand column in the detail view.

To install and use Qrimp on your server behind your firewall, you will need to download and install the Qrimp Server binaries. Qrimp Server works on Microsoft Server with SQL Server 2000, 2005 and 2008 as a database.

Please contact us for more information about Qrimp Server Licensing.

Clean urls direct visitors to a shortened version of the web address (url) for your site. Clean urls help make web addresses "human readable" and improve search engine optimization (SEO) by indicating to the search engine that the page content at a web address is the same as the terms searched. This is great for public-facing websites, splash pages and any other site that you would like visitors to access easily, remember and link to.

Clean vs. Dirty

Dirty url:
http://demo.qrimp.com/db.aspx?t=Oscars&vid=1
Clean url:
http://demo.qrimp.com/Oscars

Creating clean urls

To create clean urls, go to Develop > Add Module > Clean URL Mapper. Once your clean url table is created, navigate to Design > Clean URL Map. Enter the 'clean url' that you would like users to type in and the 'dirty url' that is used to access the item directly.
Entering the clean and dirty urls
Click the add new icon . You will see two fields "dirty url" and "clean url".
Dirty Url
In the dirty url field, enter the part of the address of the table/id/view, starting at db.aspx like so: db.aspx?t=OscarsTable&id=1&vid=1. It is important to enter only the end of your url, starting at db.aspx. Do not enter the "http://oscars.qrimp.com/" or a backslash (/).
Clean Url
This is the name of the site to which you are directing traffic, for example "home". Enter only the word you want to appear after your site name in the url and nothing else.



Advanced Clean URLs
Full web address on the Qrimp platform contain the db.aspx page, your table name, the record number and the view. The link below shows the "American Gangster" Record of the Oscars table in detail view.
http://demo.qrimp.com/db.aspx?t=Oscars&id=3&vid=11

You can use Field names and view numbers in your clean url to make your web address "human readable". Replace spaces in your records with a plus sign.
http://demo.qrimp.com/Oscars/American+Gangster/11

The web address is hierarchical, from site name to table name to record name to view:
http://myapp/tablename/itemname/viewname

The itemname and viewname can be replaced with the number representing the ID for the entry as well:
http://myapp/tablename/25/11
Adding Static Content with Clean Urls
Use Clean Urls with a Pages table to manage static websites.
Watch this demo to learn more:



The clean url mapper will comb the Pages table for pages that contain the word in your clean url when executing a clean url.

The web.config file in the root folder of your IIS web application contains settings for your Qrimp App for the database, SMTP server (for sending email), and more. Below you will find a list of the configuration keys and what they mean.

To get to your web.config files here are the steps:
1. Open My computer C: Drive
2. inetpub
3. Qrimp
4. Scroll to the bottom and double click 'web', Microsoft Visual Studio should open and you will see the web.config files.

connectionstring

The connection string tells Qrimp how to connect to your database. It should be in a form that looks like the following. Add the values for your particular environment.

"database=;Password=;Persist Security Info=True;User ID=;Data Source=;"

The database is the name of the database containing your Qrimp App.

The User ID is the username of a user that has DBO rights to your database. DBO rights are needed so that you can create database tables and perform other operations within your database.
If you are unable to use DBO privileges for your web application, Qrimp will still work, but you will not be able to modify the database from the web.

The password is the password for the user.

The Data Source is the name of the physical server on which your database resides. If you are running your Qrimp Application on the same machine as the database, you can use (local) for the data source.

enablecaching

If enablecaching is "true" Qrimp will cache your database values. This will improve performance significantly, but does require clearing the cache in certain circumstances. In an pooled application environment, each application instance will have its own cache.

Any other value will disable caching.

showselectsastrees

In situations where you can access a Tree View for your drop down list boxes can also be displayed as trees. A value of "true" will show the data in these drop down list boxes as trees, any other value will show the data in a single list.

autoapproveaccounts

If you Automatically Approve Accounts, then users who fill out the Create Account page will be created assigned to the group id (see below) and instantly emailed a password they can use to log in to your Qrimp App. If you do not automatically approve accounts, then each new user will need to be manually approved and the Group can be set at that point.

autoapprovegroupid

This is the group id new users will be assigned to if you choose to Automatically approve accounts (see above).

requiresecureconnection

If this value is true, then users will be required to access your Qrimp App via an SSL encrypted line. This will require a secure certificate on your server and users must use the HTTPS:// url protocol.

ignoreselectcachetablename

If caching is enabled, then select lists are cached in their HTML form to improve performance. There are some instances where caching these select boxes can be problematic. In this case, you can disable caching for a particular table by setting this key to true. For example, to turn off select cache for the users table, you'd add this key to your web.config:

ignoreselectcachet_users=true

notificationemail

The notification email is the email that will appear in the from line of emails sent by your Qrimp App.

smtp-relay

The smtp-relay is the name of the email server you will use to send emails for notifications that occur within your Qrimp app.

smtp-username

The smtp-username is the username that will authenticate your SMTP session. Qrimp requires SMTP authentication to send emails to improve security and reduce the risk of spamming.

smtp-password

This is the password for your SMTP server.

AmazonAccessKeyId

This is the Amazon Access key that will allow you to perform remote backups and other functions that will be announced in future releases of Qrimp.

AmazonSecretKeyId

This is the Amazon secret key, see above.

With the Deployment Manager, you can push changes in an application to another application. This allows you to customize an application in a development environment, then move those changes to a test environment, then to a production environment.

We highly recommend you backup your target application before performing a deployment. If an error occurs during the deployment process or network connectivity is lost, your target application may be rendered unusable.

There are two ways to deploy your application:

1. Full Deployment

   If you click the check box by the Full Deployment option, an full copy of your application will be moved to the target application specified in the Application text box.
   
   This option will overwrite all system tables and user tables containing data for your application. If you would like to preserve information entered into your target application, do not check this box.
   
   Changes to your user tables, including new columns or new tables will be copied in a full deployment.

2. Default Deployment

   The default deployment scenario will copy all system tables except those that manage user configuration, including the following tables: Users, Groups, Attachments, Site Settings, User Groups, User Portals, and others like that. This will allow you to configure design and development aspects of your system while preserving user settings for different environments.
   
   Under the default deployment scenario, changes to the user tables are not deployed, only content of the system tables. If you add a column or table to your development environment, you will need to modify your target environment to include the new tables and columns before deploying your Qrimp App to the target system.

Usage

To use the deployment manager, use this suffix for your app:

synchronize.aspx?deploy=true

For example, if your app is http://localhost/qrimp, then the deploy url would be:

http://localhost/qrimp/synchronize.aspx?deploy=true

If you use the deployment manager frequently, you can add a menu. You can read more about Menus for help with this.

To view scripts that will allow you to use the data in your Qrimp application to run them in your own database.

Go to Admin > Backups

You can choose to download either create and insert statement or just insert statements.

By default, data in your application is only visible to individuals with usernames and passwords. The default user group "Anonymous" is used when you want to make your data accessible to the public, such as for an online store, a blog, or a company website. (See also User Groups.)

To allow your data to be visible on the internet, you must set each database table as visible to the Anonymous user group by using Table Security. You must also make sure that anonymous users have permission to see each menu tab by setting up Group Menu Visibility.

You can create your own queries using the Query Designer under the Develop menu.

Querying Data

To quickly show the SQL Statement for a particular table, select the table name in the drop down and click the show sql link. This selected table will be used for the templates for the data that is returned. Click Run Query to show the results.

Saving Queries

You can save your queries for use later. Specify the query to use by adding a &qid= parameter to the end of your querystring using the ID or the Name of the query you save. To keep your data secure, you must assign permissions to the query by group. When you first click the Save Query link, you will be presented with a list of Groups who you want to allow to view the Query Results. Click the view queries link to view, delete or modify existing queries.

Updating Data

The Query Designer will let you write ad hoc SQL statements against your database. You can run any statement you like, but we suggest using only SELECT statements to prevent damage to your database. If you are going to run statements to update your data, you should do a backup first, which is covered in Backing up your data.

You can back up your data with Qrimp Backup, which you will find below the Admin menu.

Qrimp Backup will allow you to backup your data in many ways, including SQL Scripts to insert your data into another database and create tables to store it. You can also download a full MS SQL Server backup of your data. This backup will be compressed and secured with a password to prevent tampering.

If you would like to restore your database to that backup, create a trouble ticket and we will assist you.

The JavaScript API will allow dramatically expand the capabilities of your system. In this help topic, we are going to spend a little time detailing the functionality you can accomplish rather quickly using a little bit of JavaScript. If you've used Share Data, you've already done a little bit of JavaScript Programming.

Background on JavaScript

There are many JavaScript Tutorials on the net to help you understand it better. JavaScript is a standard technology and has been in use for many years. We chose to use JavaScript because a lot of developers are familiar with it. Javascript can make your applications more accessible and platform independent.

Examples

Every Qrimp app comes with some features that are built using JavaScript. Share Data for sharing data and Field Templates for columns validation are built with Javascript. These validation routines are fairly standard. To try an example, go to Design > Field Templates on the Add New view for many of your tables.

Extensibility Options

In this Help Topic, we are going to concentrate on some of the techniques you can use to pull data out of Qrimp and use it in your custom programming activities. To get the most out of this topic, you should be familiar with the Query String Parameters first.

To make AJAX programming with Qrimp easier, we are using Matt Kruse's AjaxRequest.js from http://www.ajaxtoolbox.com/. If you are familiar with JavaScript and would like to use Dojo, Prototype, or some of the other common libraries in your site, Open a Ticket and we will help you with this.

Retrieving Data with AJAX

Because we are using the XMLHTTPRequest object the following functions will only get data from local urls within your Qrimp app. Attempting to use them with remote URLs will return a security error.

getUrlString(url) This method will download the url and return the content as a string. You can use this function to retrieve a particular value of a particular field for example. Click the button below to retrieve the name of the help topic indicated by the id you enter into the box:



Here is the JavaScript for the example above, click to copy it into your app: <br /><input type=text size=5 value="<a href=search.aspx?_field=name&itemname=id>id</a>" id=itemid><br /><input type=button onclick="document.getElementById('theresult').innerHTML='The name is: '+getUrlString('db.aspx?t=helptopics&id='+document.getElementById('itemid').value + '&_fieldvalue=name');" value="Try It!"> <br /><span id='theresult'></span>

getContent(url,element,clearcontent,startmsg) We could have stream lined the above example using this method, which will download the url and insert the content into the page element indicated by the element parameter. Try this example:


Clear Content

Here is the JavaScript for the Example, click to copy it into your app:<br /><input type=text size=5 maxlength=5 value="<a href=search.aspx?_field=name&itemname=id>id</a>" id=itemid2> <input type=button onclick="getContent('db.aspx?t=helptopics&id='+document.getElementById('itemid2').value + '&_fieldvalue=name','result2',document.getElementById('clearcontent').checked==true,'<img src=/images/ajax-loader.gif align=absmiddle> Retrieving name...');" value="Try It!"> <span id='result2'></span><br /><input type=checkbox id=clearcontent> Clear Content<br />

Special Query String Parameters

_INDICATESUCCESS=true will tell Qrimp to execute a command only returning only the status of the operation. If the message is a success it will return the value of the EXECUTE_SUCCESS variable, which is "Changes applied successfully." If the operation fails, the exception message will be returned.

_RETURNRESULT=true is used for creating new records or operations on individual items. For example, say you want to create a new record in a database table. If you append _RETURNRESULT=true to the URL querystring parameter list, the system will return just the single value response. For an INSERT operation that creates a new record, that result will be an integer number identifying the ID value of the new record.

Using &_RETURNRESULT=true can be very useful for creating parent child relationships. For example, you may want to create an Expense Report, get the ID of that new expense report, then create new expense line items under that Expense Report.

_RECORDCOUNT=true will return only the number of items that would be returned for a particular query string.

Special Pages for Programming

banner.aspx allows you to perform Mash Up operations that grab information from external websites. Use banner.aspx with the following Query String Parameters:

?importimage=imageurl&t=table&column=columnname&id=itemid
This command will retrieve an image from a remote website specified by imageurl and save it into your local Qrimp app. The value for the column specified and corresponding to the particular item indicated by itemid and the table will be set to the url for the local file. This functionality will allow you to ingest remote resources and use them locally within your Qrimp App. The imageurl specified need not be only an image, but could be a text file, html file, etc

?getrgb=imageurl will return the average hexidecimal color of a remote image. This is useful for determining, for example, if there are any storm clouds in a weather radar. If the average hex value is close to black, it's a clear day, if it is closer to red, it is very stormy.

?externalurl=urltodownload&starthtml=starthtmlstring&stophtml=stophtmlstring&t=table&column=columnname&id=itemid
This parameter group will download a remote resource and save the value contained in that resource between the specified start and stop html strings, display it with a link to the original resource, and if the user has rights to update the specified table, save it into the column specified.

This feature is used to create powerful mash ups that persist data from multiple locations around the net. The values saved in these columns can be used in Calculated fields, sorted, and used like any other data entered via the normal routes like HTML forms, etc.

You can use Square Brackets to use values in your database to build custom urls. Watch the External Data Sources demo on our Demos Page to get a visual idea of how to do this with Amazon's Online Store.

savedesign.aspx

This page is used to enable drag and drop Field Layouts, but can also be used to update fields in your database for a particular record with a particular value. Here are the query parameters:
savedesign.aspx?ptable=tabletoupdate&id=itemid&f=field&v=value

If the update is successful, the value EXECUTE_SUCCESS will be returned. Otherwise, a failure message will be returned.

Summary

The JavaScript API is a complete set of tools that remove all limits on your application. If you need additional support, please contact Qrimp Support.

Iterative Development is a development methodology that is based on building a project quickly, in a series of short development cycles that allow for frequent feedback between the developer and the purchaser/end user/testers of the system.

Iterative development can reduce development time as it allows the changes that the user requests to be implemented sooner in the development process, reducing the amount of work that has to be done or undone.

There is a fairly comprehensive article on iterative development at wikipedia.

Icons are used throughout Qrimp applications as visual cues. You can use icons anywhere in your application for any reason.


Qrimp has a large selection of icons to choose from

Using Icons in your HTML

To view all of the icons, go to Design > Icons/Icons List

Click the icon you wish to use.

Copy the filepath from the iconurl field and paste it into the "source" (url) of your img tag (src=).

Pull the image from the icons folder using a relative url, like this:
<br /><img src="/icons/crystal_project/32x32/actions/edit_add.png"><br /><br />This will pull in the icon, like so: <img src="/icons/crystal_project/32x32/actions/edit_add.png"> or so <img src="/icons/crystal_project/16x16/actions/edit_add.png">

See also: Icontheme
Action Icons

In this video demo, we get right down to business and import some data in one of our spreadsheets. This is the quickest way to get data into your Qrimp App and start building reports and adding information to your portal. In this demo, we also add a cross tab report to give us another view of our data.

In this 5 minute demonstration, you'll learn how to build stacked charts from your cross tab reports and custom drill down reports.

In this tutorial, you'll see how to add a notification so you can be alerted by email when changes are made to information in your Qrimp App. We also briefly jump into some table management to make a field a bit bigger. We'll also customize the notification template so that we see only information that meets certain criteria.

Here you'll learn a little more about the system menus that come with all Qrimp apps and also how to control the visibility of menus for your users and anonymous browsers from the Internet. We'll also add read access for the anonymous users so they can see the data in your tables.

Qrimp automates many of the software development tasks needed to manage relational information intuitively. Checkboxes for many-to-many relationships and spreadsheets to edit tabular data. In this tutorial we show you how to view those more intuitive interfaces for the information and add menus to get to those views easily.