Search the help documentation

Search:

Can't find what you are looking for? Use the Feedback tab in your app to submit an issue, or email support@ qrimp.com.


idnamedescriptionParentTopic
deleteedit1328Checkboxes<textarea>[checkbox:[DATA]:autoupdate]</textarea>

Only use autoupdate if you want editing to be enabled from the view.		Square Brackets
deleteedit139Clean UrlsClean 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.

<h4>Clean vs. Dirty</h4>
Dirty url:
<a href="http://demo.qrimp.com/db.aspx?t=Oscars">http://demo.qrimp.com/db.aspx?t=Oscars&vid=1</a>
Clean url:
<a href="http://demo.qrimp.com/Oscars">http://demo.qrimp.com/Oscars</a>
<h4>Creating clean urls</h4>
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.
<strong>Entering the clean and dirty urls</strong>
Click the add new icon <img src="https://developer.qrimp.com/icons/crystal_project/32x32/actions/edit_add.png" />. You will see two fields "dirty url" and "clean url".
<strong>Dirty Url</strong>
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 (/).
<strong>Clean Url</strong>
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.

<object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="588" height="584" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/2008-06-14_1323.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/2008-06-14_1323.swf" width="588" height="584" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>

<strong>Advanced Clean URLs</strong>
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.
<a href="http://demo.qrimp.com/db.aspx?t=Oscars&id=3&vid=11">http://demo.qrimp.com/db.aspx?t=Oscars&id=3&vid=11</a>

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.
<a href="http://demo.qrimp.com/Oscars/American+Gangster/11">http://demo.qrimp.com/Oscars/American+Gangster/11</a>

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
<strong>Adding Static Content with Clean Urls</strong>
Use Clean Urls with a Pages table to manage static websites.
Watch this demo to learn more:

<object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="602" height="604" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/2008-06-14_1451.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/2008-06-14_1451.swf" width="602" height="604" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>

The clean url mapper will comb the Pages table for pages that contain the word in your clean url when executing a clean url.		Query Strings
deleteedit105Clear Menu CacheUnder the Develop menu tab, you will see a menu called <img src="/icons/crystal_project/32x32/actions/tab_duplicate.png" height=16 align=absmiddle /> Clear Menu Cache.

<img src="/attachments/143e278e-f99c-4b85-87ab-09640c611215/ClearMenuCache.jpg">

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.		Menus
deleteedit84Column Level SecurityYou 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".

<img class="border" src="attachments/developer.qrimp.com-a8c36b17-dad7-4f15-8c55-1f7e939ab98c/columnsecuritylink.png" />

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.

<img class="border" src="/attachments/9b777dc0-271f-4eeb-9500-3f16d11b4821/ColumLevelSecurity1.png">		Security
deleteedit200Communicate and ShareLearn to use Qrimp for messaging and share data that is in your Qrimp app.
deleteedit133Computed Column<nobreak>
<h2>What is a Computed Column?</h2>
A Computed Column is a [datatype] that allows you to calculate mathematical equations using numerical data from other columns in your table, concatenate strings from other fields or add and subtract dates.

For example, if you had a Products table with columns for price and tax rate, you could calculate price + tax. Computed columns allow you to take full advantage of Microsoft SQL Server 2005 Transact-SQL functions. You can read more about T-SQL functions at the <a href="http://technet.microsoft.com/en-us/library/ms174318.aspx">MSDN Library</a>.

<h2>Adding a Computed Column</h2>
You can only add a computed column after a table has been created. Go to your table, then go to Develop > Table Management. Enter a new column name under Add a column, and select computed column as the datatype.

<h2>Examples</h2>
<h3>Calculations with Numbers</h3>
Formulas with numbers are the same as we learned in school. To calculate Profit in a table with a Unit Price and a List Price, we enter a new column called Profit and in the formula box, enter "UnitPrice-ListPrice".

<img class="border" src="/attachments/3b54339c-9f76-4f4c-b450-20a081b29b12/ComputedColumn1.png">

<h3>Column with Dates</h3>
In this example, we calculate the number of days between two dates in our table. For more information about formulas you can use on dates, see the <a href="http://technet.microsoft.com/en-us/library/ms186724.aspx">Date and Time Functions</a> entry.

<img class="border" src="/attachments/eea0d7ea-4344-4c01-941c-a0c31c54c028/NewComputedColumn.png">

<h3>Concatenating Fields</h3>
Concatenation is putting two strings together into one string. To add a concatenated field, use the + sign. To make a full name from a first and last name, enter a new column called FullName and in the formula box enter "Lastname + ', ' + Firstname".

<a href="http://technet.microsoft.com/en-us/library/ms181984.aspx">Click here to read more about T-SQL String Functions</a>.
</nobreak>		Adding Columns
deleteedit1290Configuring Imported TablesIf your system was created from imported data, here are a few things you may wish to do:

<a href="db.aspx?t=HelpTopics&id=213&vid=11">Re-order columns</a>

Change your [Table Security]

<a href="db.aspx?t=HelpTopics&id=256&vid=11">Add a Calendar List to your Dashboard</a>

[Change your skin]

<a href="db.aspx?t=HelpTopics&id=180&vid=11">Change your logo</a>

<a href="db.aspx?t=HelpTopics&id=247&vid=11">Set up Custom Views (Filtered and Sorted Reports of your data)</a>
[Edit an Existing Custom View]

[Convert a Field to a drop-down]
[Add a drop-down Field]
[Hide Inactive Fields from drop-downs]
<a href="db.aspx?t=helptopics&id=265&vid=11">Change a field to a drop-down</a> Make sure you have clean data first! Try out [grid edit] and sort by the field you want to convert to a drop-down.

Working with Data
deleteedit140Configuring your web.configThe 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.

<h4>connectionstring</h4>
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 <b>database</b> is the name of the database containing your Qrimp App.

The <b>User ID</b> 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 <b>password</b> is the password for the user.

The <b>Data Source</b> 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.

<h4>enablecaching</h4>
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.

<h4>showselectsastrees</h4>
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.

<h4>autoapproveaccounts</h4>
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.

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

<h4>requiresecureconnection</h4>
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.

<h4>ignoreselectcache[tablename]</h4>
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

<h4>notificationemail</h4>
The notification email is the email that will appear in the from line of emails sent by your Qrimp App.

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

<h4>smtp-username</h4>
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.

<h4>smtp-password</h4>
This is the password for your SMTP server.

<h4>AmazonAccessKeyId</h4>
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.

<h4>AmazonSecretKeyId</h4>
This is the Amazon secret key, see above.		Qrimp Server
deleteedit110Content HeaderThe "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.

<img class="border" src="attachments/developer.qrimp.com-d26922e7-cfd9-41b7-bf0b-b117d3ff7c2f/contentheader.png" />
<span class="small">A default content header with a custom message to users of the products table.</span>

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]).

<img class="border" src="attachments/beedb418-951d-4e64-93a3-e2032bbf0101/2008-12-14contentheader.png" />
<span class="small">A customized content header with fewer icons than normal.</span>

<h2>Advanced: For CSS and Javascript in Content Headers</h2>
For [CSS], declare #contentheader to style the content header.		Above and beside your data
deleteedit1310Conversion failed when converting the varchar value 'Active' to data type intIf you get a conversion failed error, it is a problem with the [datatype]. If you are trying to create a view or other numerical calculation with the = operator symbol please change the = to contains.Error Messages
deleteedit1336Conversion failed when converting the varchar value 'Fred' to data type int.Text entered, number expected. This often occurs when Qrimp is expected the id # (See [AutomaticIDs]) of your record instead of the name.

If you can, find the id number of the item you need. For example, in the users table, Fred's ID is 4. If you enter 4, this error should go away.		Error Messages
deleteedit207Convert a Field to a Drop-DownTo convert a field to a drop-down (also known as pick-from or look-up table), first go to the table with the field you want to convert and go to Table Management.

<img class="border" src="/attachments/3f1407ef-0b8c-4d3a-bace-966c351ad865/Lookup1.jpg">

Beside the column you wish to convert, click the "Convert to Pick From List" link.

<img class="border" src="/attachments/622bbe93-f4ad-4e7d-b1ab-69b239a2fb7b/Lookup2.png">

You will get a warning pop-up asking you to confirm the change. Click okay. Once you have converted the field, you will notice a magnifying glass in your table management list and a link to the look-up table.

<img class="border" src="/attachments/f60ca418-8cdd-4f9b-8db2-4f5e4ea68c74/Lookup3.png">

As always when adding a new column, use the [form designer] to position the new field in your [Detail View]/[Edit View]/Add New View.		Creating a Look-up Table
deleteedit1288Copy a RecordIf you are entering new records that have very similar data to existing records, you can start from a copy of an existing record.

To copy a record, first go to the [edit view] of that record.

Click the "Copy" button at the bottom of the record. You will be taking to the [detail view] of your new record, and will need to click the edit icon again to enter the new data.

<img class="border" width="550px" src="attachments/developer.qrimp.com-109d412c-2d4f-40ac-82c9-bdd1d76762fb/copyarecord.png" />

Be careful here and proceed slowly to make sure that you enter new data in the copied record, and do not overwrite the original record. Look at the [location bar] of your browser and check that the record has a higher id number than the original. (See [AutomaticIDs]).

<img class="border" width="550px" src="attachments/developer.qrimp.com-06f38e6d-023f-44a5-ace5-f00b780cd058/copiedrecord.png" />		Add a Record
deleteedit177Copying a ViewThe easiest way to get started with creating a custom View is to copy an existing one and then modify it to suit your needs.
To copy a View, follow the following steps:

1.In the Menu, navigate to Design > Views

<img src="attachments/0bbdd80e-5990-44c6-98d5-04968c44cfb2/DesignViewCopy.jpg">

2.In the Page Templates grid, select the edit icon (<img src="/attachments/e88589d8-11ab-415a-96db-2f99d5a3d4d6/EditIcon.png">) next to the View that is similar to the one you want to create.

<img src="attachments/2defb493-d6b6-4856-a12b-ef2c4ecbf989/ViewPageTemplates.jpg">

3.Scroll down to the bottom of the page and click the Copy button: <img src="attachments/a19ee9e7-e360-4d13-a410-8e0167ff4d63/CopyButton.jpg">


4.Now click the edit button --<img src="attachments/2f4e8ee1-f590-4494-b445-6d65237db30b/EditButton.jpg"> -- and begin creating your new custom View.		Creating your own views
deleteedit107Creating a Look-up TableA look-up table lets you select data from a drop-down list in any one of your tables. Like this:
<img class="border" src="/attachments/96528c8f-71d0-4a7f-aa82-9cdb855b19d1/ClientDropDown.png">

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

<h2>Adding a look-up table with Import Data</h2>
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.

<img class="border" src="/attachments/ef4d0248-5e5a-4b93-97ca-c283b88af827/importdata.png"

Enter a Table Name.

<img class="border" src="/attachments/6d8a61f7-366c-42f6-99c0-4746a9ea6680/EnterTableName.png">

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.
<img class="border" src="/attachments/55744fd5-fa15-4c4f-ba22-0b4b094d2473/LookupTableCreation.png">

<img class="border" src="/attachments/535691ad-592b-4fad-9114-99e157a53c8e/Lookup4.jpg">

See also [Convert a Field to a Drop-Down] and [Adding a Drop-Down Field]		Add a Table
deleteedit187Creating a Portal with a Chart<a href="db.aspx?t=HelpTopics&vid=11&id=183">Charts</a> and <a href="db.aspx?t=HelpTopics&vid=11&id=57">Reports</a> make good additions to [portals] as they provide a quick overview of your data.

To add a chart to a portal page, first find the chart of your liking. For the example I'm going to use the most expensive zip codes by county year over year. Before you click the Share button don't forget to copy the script inside the text box. (Shown in figure 2)

<img src="https://developer.qrimp.com/attachments/0ab33145-8a74-4cd7-afa6-4ae6242c25fe/Chart8.png">

After you click the Share button it will take you to a Create portal page.

<img src="https://developer.qrimp.com/attachments/4e51b730-94a0-4e0a-abfe-449d93d4af08/Chart9.png">

After you click the create button you need to add it to your portal page which will be located in the [Header/<strong>Footer</strong>].

<img src="https://developer.qrimp.com/attachments/c1a68be3-2753-462f-a0b7-033e49aadf6b/Portal1.png">

After you add the portal subscription it should look like this:

<img src="https://developer.qrimp.com/attachments/d9b65d72-7919-43a1-b619-ceebe16b7dae/Chart10.png">






Dashboard
deleteedit1302Creating your own error messagesQrimp has several default error messages for when things go wrong. The Qrimp stylesheet also has a class called "error" which is red text by default. You can change this to make it more or less obvious.

<h3>Adding Error Messages</h3>
If you have added custom [JavaScript] or other functionality, you may wish to add your own error messages. To do this go Admin > Error Messages and fill out the required fields.		Javascript and JQuery in Qrimp
deleteedit104Creating your own viewsIf 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" <img src="/icons/crystal_project/32x32/actions/edit_add.png" />

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.

<strong>Formatting your data with HTML and CSS</strong>
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:

<style> #red{background:red;}</style>
<div id="red">
<h2>[ItemName]</h2>
</div>

And here is what our result would look like:
<style> #red{background:red;}</style>
<div id="red">
<h2>Inventory Item 1</h2>
</div>

This is just a basic example. Learn more about pulling data into page templates with [Square Brackets]		Views
deleteedit175CRUDIn every Qrimp app, there are five default [operations] that users can perform on a database: Create, Read, Update, Delete and Admin. To allow your users to perform these operations, give them the permission to do so using [Table Security].

You can create as many levels of access as you like. Add, remove, or adjust the configuration of existing operations to fine tune the capabilities your users have within your Qrimp Application.

Learn more about CRUD by searching the web.		Definitions
deleteedit1275CSSCSS stands for Cascading Style Sheets. This is the code that determines the colors and positions of elements in your web app.Definitions
deleteedit1274Custom CSSYou can use [CSS] to style any part of your Qrimp app. If you only want the style to be applicable to a particular page, table or view, you can write the CSS in a style tag in [views] or [headers and footers].Changing the Look and Feel of Your App
deleteedit179Custom Pagination Look and FeelTo create your own Custom Paging for your system you will have to write some [JavaScript].

First, you will call the subset of numbers from the database that you will want to use to create the custom pagination.

You can call the subset two ways: JSON or XML.

If you use JSON:

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; overflow:scroll white-space: nowrap ;">paginationJson = getUrlString('db.aspx?t=Inventory&vid=73&noheader=true&nofooter=true&_pagingInfo=JSON' + filterQueryString)</div>

This URL will pull the subset of numbers

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; white-space: nowrap ";">{"paginationInfo":{"pageSize":9,"numPages":9,"numRecords":79,"currentPage":1}}</div>

Then you must parse the information. In the example we pull the parser from the Yahoo JavaScript Library.

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; white-space: nowrap ;"> try {
var paginationInfo = YAHOO.lang.JSON.parse(paginationJson).paginationInfo;
}
catch (e) {
alert(e);
}</div>

Finally, you can assign the global variables and begin to manipulate the page to create your own Custom Pagination.

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; overflow: scroll; white-space: nowrap ";">numPages = paginationInfo.numPages;
currentPage = paginationInfo.currentPage;
numItems = paginationInfo.numRecords;
pageSize = paginationInfo.pageSize;</div>



If you use XML you will parse the information differently

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; overflow: scroll; white-space: nowrap ">try //Internet Explorer
{
xml=new ActiveXObject("Microsoft.XMLDOM");
}
catch(e)
{
try //Firefox, Mozilla, Opera, etc.
{
xml=document.implementation.createDocument("","",null);
}
catch(e)
{
alert(e.message);
}
}
var url = 'db.aspx?t=inventory&vid=73&qid=3&_paginginfo=true';
xml.async=false;
xml.load(url);
//<paginginfo><pagesize>25</pagesize><numpages>0</numpages><numrecords>92</numrecords><currpage>1</currpage></paginginfo>
document.write('numpages=' + xml.getElementsByTagName("numpages")[0].childNodes[0].nodeValue + '<br>');
document.write('pagesize=' + xml.getElementsByTagName("pagesize")[0].childNodes[0].nodeValue + '<br>');
document.write('numrecords=' + xml.getElementsByTagName("numrecords")[0].childNodes[0].nodeValue + '<br>');
document.write('currpage=' + xml.getElementsByTagName("currpage")[0].childNodes[0].nodeValue + '<br>');
</div>

As you can see XML does its own set of calls for the parsing. IE and other browsers are different so the beginning is checking to see what browser it is. Then the numbers get called in the query string just like JSON. The main difference is the way the strings are parsed.

Now you can manipulate the variables to the your type of Custom Pagination.

Here is an example of a 'footer' Custom Pagination for a shopping cart of items.

<div style="border: 2px black solid; font-family:monospace; background: #f3f3ff; padding: 1em; overflow: scroll; white-space: nowrap ">
function createItemListFooter () {

paginationJson = getUrlString('db.aspx?t=Inventory&vid=73&noheader=true&nofooter=true&_paginginfo=json' + filterQueryString);

try {
var paginationInfo = YAHOO.lang.JSON.parse(paginationJson).paginationInfo;
}
catch (e) {
alert(e);
}

numPages = paginationInfo.numPages;

currentPage = paginationInfo.currentPage;
numItems = paginationInfo.numRecords;

var paginationHtml = "";

for (var i = 1; i <= paginationInfo.numPages ; i++) {
if (i == 1) {
paginationHtml = paginationHtml + "<div id=page" + i + " class=\"selectedPage pageNumber\"><a href=\"#\" onclick=\"displayPage(" + i + ")\">" + i + "</a></div>";
} else {
paginationHtml = paginationHtml + "<div id=page" + i + " class=pageNumber><a href=\"#\" onclick=\"displayPage(" + i + ")\">" + i + "</a></div>";
}
}

if (paginationInfo.numPages > 1) {

paginationHtml = paginationHtml + "<div id=nextButton class=prevNextButtons><a href=\"#\" onclick=\"nextPage()\">Next</a></div><div id=prevButton class=\"prevNextButtons hide\"><a href=\"#\" onclick=\"previousPage()\">Previous</a></div>"
}

document.getElementById("itemListFooter").innerHTML = paginationHtml;
}

function displayPage (pageNumber) {

if (pageNumber != currentPage) {

YAHOO.util.Dom.removeClass("page"+currentPage, "selectedPage");
YAHOO.util.Dom.addClass("page"+pageNumber, "selectedPage");

if (pageNumber == 1) {
YAHOO.util.Dom.addClass("prevButton", "hide");
} else if (currentPage == 1) {
YAHOO.util.Dom.removeClass("prevButton", "hide");
}


if (pageNumber == numPages) {
YAHOO.util.Dom.addClass("nextButton", "hide");
} else if (currentPage == numPages) {
YAHOO.util.Dom.removeClass("nextButton", "hide");
}

currentPage = pageNumber;

displayItemList();

}

}

function nextPage() {
displayPage (currentPage + 1);
}

function previousPage() {
displayPage (currentPage - 1);
}
</div>

This code manipulates the JSON from the above example to create this:

<img src="https://developer.qrimp.com/attachments/664353d5-59b5-4408-90db-7a08300aefe3/PaginationFooter.png">

<img src="https://developer.qrimp.com/attachments/218508a3-c74d-404a-86e4-e52ca0e0cae5/PaginationFooter1.png">		Javascript and JQuery in Qrimp
deleteedit247Custom Views (Sorting and Filtering)To enable custom views, you must install the custom views module. Go to Develop > Add Modules. Scroll down to "Custom View By Reports" and click "Add module".

To add a new custom view, go to the [grid view] of your table. At the top of the page you will see a drop down that shows "View By". In the drop down, select "Add new view".
<img class="border" src="/attachments/developer.qrimp.com-5cf417dc-577b-47ba-b6e2-0f10b9a36501/custom views add new.png" />

Enter a Name for your view and select whether you want to make it the default view for yourself or all other users. Choose the columns you wish to appear in the view. Put the columns in the order you would like them in.
<img class="border" src="/attachments/developer.qrimp.com-5c26dc45-db4c-4c6a-859b-87f470f11700/custom views 1.PNG" />

If desired, you can add further sorting and grouping to your columns.

Note: You must select a column in the GroupBy section in order to add totals for your view.

<img class="border" src="/attachments/developer.qrimp.com-2eda0aab-df5f-49a6-9ffe-e04b1236e459/custom views sorting and grouping.png" />

You can also add optional filters to the view, to only show data that meets certain requirements.
<img class="border" src="/attachments/developer.qrimp.com-4e89830b-e98a-48f8-8917-e564829492da/custom views filtering.png" />

Select which users and/or groups can see the view:
<img class="border" src="/attachments/developer.qrimp.com-28f2f10b-1f33-4a20-adab-89a885b6fbc2/custom views permissions.png" />

Last but not least, click Save:
<img class="border" src="/attachments/developer.qrimp.com-93ddb351-22ea-4b1d-a018-2856d3973e14/custom views save.png" />

And then you have a view. This is a very simple view of Teams by year formed.
<img class="border" src="/attachments/developer.qrimp.com-655b7af9-1337-49e7-a310-a26357c3edb7/custom views teams by year.png" />
Views
deleteedit215DashboardYour dashboard is a collection of portals that you subscribe to. Dashboards make great home pages, as they give you an overview of what is happening in your app and/or your company.

To learn more about customizing your dashboard, read about <a href="db.aspx?t=HelpTopics&id=181&vid=11">Portals</a>.

<img class="border" width="600px" src="attachments/developer.qrimp.com-14857d23-63f4-4b4c-a3fd-a6a9f85a0a7d/calendarlistportalamongothers.png" />		Navigation
deleteedit198Data AnalysisGet deeper insight into your data with queries, reports and charts.
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing