Search:

id:
157

name:

Workflow

description:

Workflow in a business software application controls how a user navigates the data in an application to complete business processes. It is a series of operations or tasks, done in a particular order.

Using Qrimp you can create custom workflows to control which pages are presented to a user and when.

The three main tools used to set up custom workflows with Qrimp are Views, Headers and Footers and Field Templates.

Pull data into your views, add NextPrevious arrows to your headers and footers, controlling the action on the buttons, and placing instructions and more in your field templates are a few ideas of how you can guide users through data entry processes.

ParentTopic:

id:
158

name:

Paying with PayPal

description:

Paying for your Qrimp hosted application is easy. We use PayPal. If you have used PayPal before, it should be fairly straightforward. We've outlined the process below.

From the Qrimp sign-up page, click the "Sign up" Button.

On the next screen, select the plan you would like and click the "Pay Now" button.

Sign in to your PayPal account or select "Pay with Credit Card" if you do not have one.

ParentTopic:

id:
159

name:

Cancelling PayPal Subscriptions

description:

The following is from the PayPal website and tells you how to cancel your Qrimp subscription. We added screenshots to make it easier.

A subscription can be canceled up to the day of the next scheduled payment.

1. Log in to your account
2. Click the My Account tab.
3. Click the History subtab.
4. Choose the Subscriptions field from the Show drop-down menu.

5. Check the From box and change the date back to your subscription date.
6. Click Search, and then click Details.

7. Click Cancel Subscription.

ParentTopic:

id:
160

name:

Time Zone Awareness

description:

Time Zone Awareness allows you to set your system up so that each user sees the date and time information associated with their data in the correct time zone for their location.

If you are an existing Qrimp user, you will be asked to choose your time zone next time you log in. If not, you will be asked to chose a timezone at your first login.

ParentTopic:

id:
161

name:

Date Formats

description:

Sometimes you want to display dates in a particular format that suits the context. Maybe you only want to display the time or the day. You can do this with square brackets notation like so:

Where datevalue is any valid date including square bracket notation references to column names or the current system time [CURRENTDATETIME] and validdateformat is a string built from the components below.

Examples:

MM/dd/yyyy hh:mm tt produces [CURRENTDATETIME]

ddd, dd MMM yyy HH:mm:ss GMT zz produces [CURRENTDATETIME] (this is the format for XML)

Here are more options for date formats

d - Short date
%d - Day number
M?d - Month and day number
dd - Day number, two digits
ddd - Abbreviated day name
dddd - Full day name
f - Full (long date, short time)
%f - Fractions of second, one digit
s^f - Seconds and fractions of second, one digit
ff - Fractions of second, two digits
fff - Fractions of second, three digits
ffff - Fractions of second, four digits
g - General
%g - Era (eg. A.D.)
y-g - Year and era (eg. 5-A.D.)
gg - Era (eg. A.D.)
h - Hour (1-12) (Doesn't seem to work)
%h - Hour (1-12)
h-m - Hour and minute
hh - Hour (01-12)
H - Hour (0-23) (Doesn't seem to work)
HH - Hour (00-23)
m - Month name and date
%m - Minute (0-59)
hh_m - Hour and minute (0-59)
mm - Minute (00-59)
M - Month name and date
%M - Month number (1-12)
M d - Month number and day number
MM - Month number (01-12)
MMM - Month abbreviation
MMMM - Month name
s - Standard sortable date/time
%s - Seconds (0-59)
s^ff - Seconds (0-59) and fraction of seconds
ss - Seconds (00-59)
t - Long time
%t - First letter of AM/PM designator
hh t - Hour and first letter of AM/PM designator
tt - AM/PM designator
y - Short date
%y - Year (0-99)
m-y - Month and year
yy - Year (00-99)
yyyy - Year (0000-9999)
z - Doesn't work
%z - Whole hour time zone (-12 to 13)
Zone:z - Zone - and whole hour time zone (-12 to 13)
zz - Whole hour time zone (-12 to 13) with two digits
zzz - Time zone in hours and minutes})

ParentTopic:

id:
163

name:

Installing Qrimp on Windows Vista

description:

The following instruction guide works with Windows Vista and Windows 7 Home Edition or better.

Installing Internet Information Services

When installing IIS on Windows Vista Home, be sure to include ASP.NET as in this more detailed installation guide:
http://learn.iis.net/page.aspx/28/installing-iis-70-on-windows-vista/

Installing SQL Server Express

For Microsoft Vista, you can install either the 2005 or 2008 editions of SQL Server Express.

To install SQL Server 2005 Express with Advanced Services SP2, including advanced tools such as the management studio, reporting services, and full-text search, from http://www.microsoft.com/express/2005/sql/download/default.aspx. It is the 234MB download file.

To install SQL Server 2008 Express with Advanced Services, you have two options:
- Leverage a single installer to install SQL Server 2008 Express and all the prerequisites, use the following link:
  - http://www.microsoft.com/express/sql/download/
- Manually install SQL Server 2008 Express and all the prerequisites individually, use the following link:
  - http://www.microsoft.com/downloads/details.aspx?FamilyID=b5d1b8c3-fda5-4508-b0d0-1311d670e336&DisplayLang=en
  - Note: Make sure that you follow the steps outlined in the Instructions section

Tips for installing the SQL Server:

Include all the options when selecting what features to install
Use "Mixed Mode" for the security model
Rember the password created for the sa account because it will be used in the connection string in the web.config (see below).

Once SQL Server is installed, open the management studio. Log in as sa using the password you created. Create a new database called "intranet" with the default settings. The name you provided for the new database will be used in the connection string in the web.config (see below).

Installing Qrimp

You should have received an email with a personalized Qrimp downloadable zipfile with a password designed for only your use. Download that file and unzip the contents as follows.

Note, if you want to run qrimp from http://localhost instead of http://localhost/qrimp then you'll need to copy the contents of the qrimp folder to the wwwroot folder.

File Upload Security Settings

Add modify rights for the following directories:

c:\inetpub\wwwroot\qrimp\attachments
c:\inetpub\wwwroot\qrimp\fileicons

to IIS_IUSRS group by right clicking on the folder in Windows explorer, choosing properties, clicking edit button, clicking ok to the permissions prompt, clicking IIS_IUSRS, click the checkbox by Modify in the list below.

Install .NET 3.5

You can download the redistributable from http://www.microsoft.com/downloads/details.aspx?familyid=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en

Reboot

A reboot here is necessary to let all the components come together. You may also want to use Windows Update to add any service packs that are necessary now.

Configuring IIS and Qrimp

From the Control Panel, under Computer Management > Services and Applications > Internet Information Services

Drill down to ComputerName > Web Sites > Default Web Site > qrimp

Right click choose Convert to Application

Either modify the web.config or the application settings > connectionstring to point to the intranet database created above. If you use notepad, you'll have to run notepad as Administrator to save the file.

Accessing Qrimp Locally

After all this is finished, type this into your browser:

http://localhost/qrimp (if you are using the default qrimp folder) or
http://localhost (if you moved Qrimp to the root url, which we prefer)

Now you will step through a couple install screens. Qrimp will download the latest database configuration files from the Internet, create your database, and register the installation with us. After that you are good to go. You can synchronize with an application online by visiting http://localhost/qrimp/synchronize.aspx or http://localhost/synchronize.aspx and entering the details for another Qrimp application.

Potential Problems

Directory browsing is not allowed
If you get an error that directory browsing is not allowed, then you probably forgot to add ASP.NET to the list of IIS technologies to install. See the first step above.

SQL Server Connection Problems
If you access the url and it redirects you to a page asking you to configure the database settings, but you have already configured them in the web.config, then your SQL Server instance may be configured to accept Windows Authentication only, see: http://support.microsoft.com/kb/555332

To enable mixed mode authentication, see this tutorial on the web:
http://www.hostmysite.com/support/vps/windows/mixedmode/

Blank Page Displayed
If you access Qrimp through the browser, but see a blank page, then there may be a problem with some of the security settings for IIS, which needs to write temporary files to the system.

You can test this by creating a test.aspx file in the wwwroot folder and trying to access it via http://localhost/test.aspx If you see an error indicating access is denied to c:\windows\temp or something like that, see this page for help enabling the correct security on that folder: http://geekswithblogs.net/ranganh/archive/2005/05/13/39582.aspx

ParentTopic:

id:
165

name:

Automated Backup Process

description:

If you'd like to set up an automated process, here's how to do it.

Issue a form post to your application like this:
https://yourqrimpappurl/login.aspx
txtUsername= {your username}
txtPassword= {your password}
uid=true

You can also use a get, but then the logs show the query string in some server setups. Better to use a post.

Now, the response will contain a GUID representing the user who just logged in. Next, download a file from the following url using GET:
https://yourqrimpappurl/inserts.aspx?backup=true&download=true&uid={uid from above}

or more securely using FORM Post to:
https://yourqrimpappurl/inserts.aspx
backup=true
download=true

and then save the result to a local .zip file. By default, the filename will include the Qrimp app URL and the date and time in the file name, but you can save it as whatever filename you like.

Your file will be encrypted and zipped up and locked with a password to prevent tampering. If you ever need to restore your database to one of these points in time, then email Qrimp Support or Open a Trouble Ticket and we will restore your system. Additional fees may be required for certain hosted plans or download accounts.

Enterprise customers can backup their database to Amazon S3 in an automated fashion like this as well. Please contact Qrimp Support for more information about how to do this. We will soon be adding backup to Mosso CloudFS for databases smaller than 5 GB.

Also, remember, this does not copy the attachments, it only backs up the data. If you would like to copy attachments as well, use Synchronizer with automation.

ParentTopic:

id:
166

name:

Automating Synchronizer

description:

If you would like to automate the synchronization process to create a redundant fail over system for disaster recovery, you will want to automate your Synchronizer on an hourly or daily interval.

Automating Synchronizer will allow you to create two systems that are identical up to the last synchronize -- including data and file attachments.

Because the synchronize process takes a bit of time itself, remote copies of applications are not identical and should not be considered identical. Using Synchronizer in this way is fine for remote sites that are all copies of a master. In this way, your system can be set up as a Content Delivery Network to serve users in remote locations on Qrimp nodes closer to them. You can also Automate Qrimp Publisher in this way to push static copies of your site to remote servers around the globe.

Imagine a scenario where your data management happens inside a firewall and you publish content to a CDN outside your firewall. You could first deploy your application from inside the firewall to a secure node in the cloud. Remote nodes around the world could be set to automatically synchronize from that remote node, then publish their contents using templates customized to the locale of the visitors hitting those nodes.

If you would like to configure Qrimp to deliver your information in this way, please contact Qrimp Support.

ParentTopic:

id:
167

name:

Help Topics

description:

The Qrimp Help Files will teach you what you need to know to build and maintain your Qrimp app.

If there is a topic missing, or something is unclear, please contact us to let us know.

ParentTopic:

id:
168

name:

Forums

description:

The Qrimp forums are currently closed. If you are interested in a forum venue for discussing your app with other users, please email support to place your vote for re-opening the forum system.
Thank you.

ParentTopic:

id:
169

name:

Email

description:

Email support is available for paying customers. We also offer email support to customers during any free trial periods. Email support at qrimp dot com.

For issues that we can't resolve via email, we can set up a Webinar, or even log in to your account remotely, with your permission. Just contact us, we will work with you.

ParentTopic:

id:
170

name:

Webinar

description:

If you have a bug that cannot be resolved, or would like hands on tutoring, please request a webinar using our trouble ticket system, contact Qrimp Support, or fill out our information request form and indicate some days and times that are good for you.

Webinars let us show you our screen while we move the mouse around so you can see how we do things. In a webinar, we can also browse to your web application and give you control of our browser so you can log in. We can then help you from directly within your system and you can see what we are doing right on your screen. A webinar is a great way to learn more about Qrimp and how to perform these tasks yourself later.

ParentTopic:

id:
171

name:

Getting More Help

description:

If you were unable to find the information you needed in this help documentation, or if you were unable to use the instructions to accomplish your goals, please email support@qrimp.com and let us know what you are trying to do or what you had trouble with.

Contextual Help within your Qrimp App

If you click the help link in the top right hand corner of your browser, near the search box for your Qrimp app, you'll be brought to the Help Topics with relevant help topics listed for you about the area where you were when you clicked the link. For example, if your managing users and you need help, click the help link and you'll be taken to the developer help topics with Manage Users right at the top of the list.

If you had clicked the help link while managing a table and you want to know how to use computed columns, you'd be shown the help topic on table management

ParentTopic:

id:
175

name:

CRUD

description:

In 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.

ParentTopic:

id:
176

name:

Views

description:

Views are ways of displaying data on the page. Qrimp can display data in a table, a photo gallery, XML, or a large number of other layouts. Views are also used to let you edit data or rearrange it on a page. Advanced developers can also use views as page templates to add new layouts using HTML and Qrimp's square brackets notation. Qrimp also has Custom Views (Sorting and Filtering)

Basic Views

Frequently used views are linked to by default in the Content Header with the following icons:
Calendar View

Tree View

Grid View

(Also called list view or table view).
Grid Edit

Each Qrimp app comes with many default views.

Creating links to Views (for menu tabs and more)

In the location bar of your browser, you'll see the url you are on ie: "http://myapp.qrimp.com/db.aspx?t=customers&id=2&vid=11". The vid=11 tells the app to use view 11, which is the detail view. Changing the vid in your url will show you a different view. Note that if you are on a custom page or a page with a clean url) you will not see the vid. (See also Query String Parameters) Click the "Customers" tab to see the following screen, customers, displayed in Grid View (vid=1).

Try to open a table with the XML View, which has an id of 19. Go to a table and edit the query string in the URL so that "vid=19". Qrimp will apply the XML View to the data being returned on the page.

Here is a list of fields for a template and what they mean:

Name

This is the name of the view for easy reference or for adding to the query string using the vid=name parameter. You can also use the ID of the view.

Description

A description of your view

Displayid

This tells Qrimp how to display the data, do you want your data in a table format like in the grid view or do you want it in a list. Most views you create will be a repeater. These controls are based on the ASP.NET Repeater Control and the DataGrid Control.

Header

The header content will appear above any data that is pulled from the database.

Footer

The footer content will appear below any data that is pulled from the database.

ItemTemplate

The item template is the HTML code that formats the display. If you are using a Repeater type view, then this HTML will format one complete record from the database. In a table type view, the item template will be applied to each column. In the table view, if there is no item template, then the template for the column is obtained from the Field Templates.

CellTemplate

In a repeater view, this should probably always be [DATA]. If you'd like to wrap the item template with an extra bit of HTML, you can add it here.

PageSize

How many records to display by default. You can override this setting in the url using the &pagesize= parameter.

ContentType

The content type tells the browser how to display the data. If blank, text/html is assumed. If you want to display xml, use text/xml.

EnableWiki

If EnableWiki is true, square bracketed items will be hyperlinked.

Advanced: Building a New View

The easiest way to create your first View is to copy an existing view and then modify it. To copy a View, Go to Design > Views > Select the edit icon next to the View you want to copy > Scroll down to the bottom of the page > click the Copy button > Click the edit icon > edit the HTML > Save your edits with a new name.

ParentTopic:

id:
177

name:

Copying a View

description:

The 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

2.In the Page Templates grid, select the edit icon (

) next to the View that is similar to the one you want to create.

3.Scroll down to the bottom of the page and click the Copy button:

4.Now click the edit button --

-- and begin creating your new custom View.

ParentTopic:

id:
179

name:

Custom Pagination Look and Feel

description:

To 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:

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

This URL will pull the subset of numbers

{"paginationInfo":{"pageSize":9,"numPages":9,"numRecords":79,"currentPage":1}}

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

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

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

numPages = paginationInfo.numPages;
        currentPage = paginationInfo.currentPage;
        numItems = paginationInfo.numRecords;
	pageSize = paginationInfo.pageSize;

If you use XML you will parse the information differently

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);
//250921
document.write('numpages=' + xml.getElementsByTagName("numpages")[0].childNodes[0].nodeValue + '
');
document.write('pagesize=' + xml.getElementsByTagName("pagesize")[0].childNodes[0].nodeValue + '
');
document.write('numrecords=' + xml.getElementsByTagName("numrecords")[0].childNodes[0].nodeValue + '
');
document.write('currpage=' + xml.getElementsByTagName("currpage")[0].childNodes[0].nodeValue + '
');

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.

 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 + "" + i + "
";
	  } else {
	    paginationHtml = paginationHtml + "" + i + "
";
          }
        }

        if (paginationInfo.numPages > 1) {

          paginationHtml = paginationHtml + "Next
Previous
"
        }

        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);
      }

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

ParentTopic:

id:
180

name:

Changing the Logo

description:

You can change the logo that appears in the top left corner of your app to your company logo. Save a copy of your logo with a maximum width of 150 pixels and a maximum height of 80 pixels.

First, upload your logo as an attachment in your Qrimp app. See Adding Attachments

Copy the url where your image is located ie: http://mysite.qrimp.com/attachments/12345mylogo.png

There are two ways to change the logo:

Changing your logo in the skin (CSS)

Go to Design > Skins

Search the skin for #logo. Change or add the background element so the url for the background is the file location of your image, as below. Every character as symbol is needed, so type carefully!

#logo{
background: transparent url("http://mysite.com/attachment/12345mylogo.png") no-repeat scroll 0%;
top: 25px;
left: 1px;
width: 200px;
height: 100px;
}

Remove the logo altogether

If you just want to remove the logo, you can comment out the 'background' line for the logo style, like this:

#logo{
/*background: transparent url("http://mysite.com/attachment/12345mylogo.png") no-repeat scroll 0%;*/
top: 25px;
left: 1px;
width: 200px;
height: 100px;
}

Or mark it as none:

#logo{
background: none;
top: 25px;
left: 1px;
width: 200px;
height: 100px;
}

Adding a logo to a Custom Header

Below the Edit Skin section you can create a custom site header see Site Header. You can enter whatever HTML you wish in there, including the image link to your logo image. Note that if your logo is contained in a div called #logo, the CSS from the default Qrimp app skin, positions.css, will also apply to the div.

If you do this, the existing contents of your table header, such as your login link and search form will be overwritten, so be sure to include these in your site header as well.

ParentTopic:

id:
181

name:

Portals

description:

Portals are windows to your data that appear in boxes on your dashboard. Your Dashboard is a collection of portal boxes. Each user must add or subscribe to their own set of portals. A user can either add a portal from the grid view or subscribe to a portal.

Adding a Portal from Grid View

To add a portal from the grid view:

Go to the table you want to get data from > go to the bottom of the grid view > click the link that says "Share".

A box will appear with a button that says "Add to Dashboard". Click the Add to Dashboard button.

Enter a name for your dashboard.

Another link will appear that lets you view your dashboard

Your portal window has been added.

Moving Portals

To move a portal, go to the top right corner of the square. Hover over the icon that looks like two windows

". It will turn to a multi-directional arrow

. Click and drag the arrow to move the portal to a spot before another portal square. The square you are moving it in front of will turn green.

Resizing Portals

To resize a portal, click the magnifying glass icon in the top right

. You can change it to be large, small or medium.

Customize Portal Background Colors

To choose a new background color for a portal, click the palette icon in the top right

. Different colors can help you quickly find data that looks the same.

Advanced: Manually Editing Portals

To edit a portal, click on the edit icon in the top right corner of the square

. This will take you to the edit view of that portal in the Portals table. Note: You can see all of the records in the portals table by going to Design > Portals.

Name: The Name of your portal window. Use a name that describes which data will appear in the portal and how it will appear. For example "Logins by Date", "Unpaid Bills" or "Red Shoes - Thumbnail images". The name you choose will appear in the header of the portal.

Description: Describe your portal to help you remember what it's about.

Template: Copy and paste a ShareData script. The ShareData script is much like an embed tag. It links to your data, storing the table id, the sort on your data, search information, hiddencolumns and whatever else you tell it to. Advanced: add styles to your portals by using inline styles in the template field.

Link: The Portal Link specifies where the user will go if they click on the portal header.

Deleting Portals

To delete a portal from your home page, click the red X in the top left hand corner. You will be unsubscribed. To resubscribe, simply go to Home and find the link in the top left of the page that says "Add Portal".

ParentTopic:

id:
182

name:

Adding a User Group

description:

Under Admin > User Groups you will find the default Groups: Administrators, Developers, Testers, Users and Anonymous. To add a new group, click the "Add New" Icon in the Content Header. Select the group security permissions you would like the user group to have and click Save.

ParentTopic:

id:
183

name:

Charts

description:

A Help Topic to step through the value of Qrimp's Charts.

In every grid view in your Qrimp Application at the bottom of the data there are a few default buttons.

Qrimp does offer a few canned Reports but to get your hands dirty with your data Qrimp has Custom and Cross Tab Reports.

When you are in the Grid View, one of the default buttons in the Content Header is Reports. If you click on that you will get a screen similar to this

Once you are at this screen you can now see the buttons in the Content Header that say Custom and Cross Tab Reports.

Here is an example of a Cross Tab Report. The data is from 2006 and 2007 Most Expensive Zip Codes in the US ranked by Average Median Sale Price. The Report compares the Counties year over year.

To CHART this Cross Tab report we can go to the bottom of the data and click 'Chart' it will take you to a screen like this.

There are several ways to change the look and feel of your chart.

Lets begin with the Chart Title. The Chart title will appear above the Chart.

The View Next button allow you to scroll through various charts to represent the data in a different way. Here is the same chart as above after Clicking "View Next". You can also use the Drop Down Menu located to the left of the "View Next" button.

The Show Top field allows for adjust of records you want to see. In the two images below is of the same Chart but different amount of records displayed just by changing the "Show Top" field.

The Order By Column allows you to switch the order by which the graph is displayed. By default it is ascending but the radio button next to the field allows you to order by descending as well. This can be seen in action in the two images below.

The Dimensions of the Chart can be changed to make the graph more readable. This might be used if the data set is large and the default width and height need to be expanded. The first image is the default size and the second image changes the width and height to make the graph a little more readable.

Sometimes on the x-axis the labels get jumbled together, like the first image below. To make the graph a little more readable there is a Rotate Names radio button that will rotate the names vertically, like in image two.

The "Animate" radio button adds a little functionality to your Chart. If you check the button and click "Show Chart" it will build the Chart right before your eyes. Watch the video below to see it in action.

Sometimes the graphs don't tell the whole picture. By adding values to a chart the User will know the exact amount. So, by clicking the radio button next to "Show Values" the Values will appear on top of the bars, like in image two.

To make graphs more readable you can add colors to distinguish between each type of bar. By clicking on the palette a color picker box will appear (image 2) and because I have three different labels I will click three different colors. There is no need to close the box each time.

The Share button can be used to add Charts to your Portal page. Here is a help topic that will walk you through the process. Creating A Portal with a Chart

ParentTopic:

id:
185

name:

Input Security Restrictions

description:

To add additional security around data Qrimp allows you to add white and black lists.

A Whitelist will only allow the characters specified in the list.

A Blacklist will strip out the characters specified in the list.

To add either functionality to a system the first step is Develop > System Tables.

Then click on the t_groups WITHOUT the magnifying glass.

To add the additional field to the table click on the Table Management Icon in the Content Header

Scroll down to "Add a Column" and input either inputwhitelist or inputblacklist all one word

Once the column is added there are two steps. First you must log out and log in to make the change take effect. Then go back to the table and click Design > Field Layout to move the field to a usable spot.

It should look like this when complete. Now click the Edit Icon in the Content Header enter in the characters that can ONLY be entered. For this example lets say I don't want numbers. I will only include the 26 letters of the alphabet and click save.

ParentTopic:

id:
186

name:

Retrieving id for new elements

description:

If you use JavaScript to create a new item, you may want to retrieve the ID of the element just created. To do this, use the _returnresult=true option in the querystring.

For example, submitting a querystring like the following will create a new item in the Person table with a name of Linda.

var id = getUrlString('db.aspx?t=person&name=linda&o=5&_returnresult=true');

You can now use the value in ID to add information to other tables that is related to the person Linda. Like this:

var taskid = getUrlString('db.aspx?t=tasks&name=Register+for+intranet&person=' + id + '&o=5&_returnresult=true');

ParentTopic:

id:
187

name:

Creating a Portal with a Chart

description:

Charts and Reports 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)

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

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

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

ParentTopic:

id:
188

name:

Dependent Select Boxes

description:

Sometimes it is convenient to allow users of your Qrimp application to filter the items in one select box by choosing an item in another select box. For example, when choosing to examine fuel economy by vehicle, because there are hundreds of different types of cars, you could let your users filter by Make, and then show only the particular models for that make in another box.

In this Help Topic, we will use another example that fits with our Campaign Contributions system, where when choosing a candidate to add a contribution for, you can filter the list by the candidates party. We'll end up with a dependent select box like the image below:

Here is a video that shows the dependent select boxes in action:

To get started, we will first go to the Add New screen for the Contributions. Notice the default select box has only a list of candidates:

From the add new screen for contributions, select Design > Field Templates:

Next, we will click the edit icon for the Candidate column. Since we have not modified the template for this field yet, Qrimp has created one for us automatically that looks like this:

To add a select box for Parties that will filter the candidates list, we will edit the field template to look like this:

Notice we have inserted this block of text before the Candidate select box:

[select:Parties:Candidateparty]

This tells Qrimp to create a select box that will filter the Candidate select box and show only those candidates where the party is equal to the party we select in the Parties select box.

If we want to hide the Candidates select box until a selection in the Parties select box has been made, we can use code like this:

[select:Parties:Candidateparty] then Candidate

The span indicated with the id Candidate_selectbox is the location where Qrimp will display the list of candidates in the party that we choose in the Parties box. This example behaves like the video below:

Your final output should be in this format:


 then COLUMN_NAME

The code above is telling Qrimp to display a SELECT box with data that is used to filter another select box that ultimately has the list of items of which one is the desired selection for the field in this table.

So for example, if you are creating a trouble ticket system for equipment and have 100 pieces of equipment, each with an EquipmentType and you want to make it easy for your users to select just one piece of that equipment, you'd use a command like the following:


 then Piece of Equipment

ParentTopic:

id:
189

name:

Number Formats

description:

You can format numbers using square brackets like this:

Some formats you can use include those listed at the Microsoft Developer Network: http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx

ParentTopic:

id:
190

name:

Embedding Data in your website

description:

If you have a hosted website you can use Qrimp as the database to show data on that website using either EMBED code or IFRAMES.

Using Embeds
Most savvy web users have seen the embed feature on news, music or video sharing sites. Embed codes contain HTML that links back to a database and pulls in and displays information in other websites. To learn more, visit the Share Data help topic.

Using IFRAMES

Before you create your IFRAME, write a query string (see Query String Parameters) that displays data the way you want it. Then write an IFRAME where the SRC of the IFRAME is the url to your Qrimp database query string. Then copy/paste the IFRAME into your website to display the results.

Re-sorting the Data in an IFRAME
When you want to re-sort the data or query it, you can use JavaScript to update the SRC tag of the IFRAME and the results will be redisplayed automatically. For example:

document.getElementById('results').src='http://mydatabase.qrimp.com/db.aspx?t=products&orderby=productcode';

or

document.getElementById('results').src='http://mydatabase.qrimp.com/db.aspx?t=products&orderby=color';

Searching IFRAMES
You can search your IFRAMES BY using a query string with search parameters. For example, to search for products where the product name contained the word "vinyl", you'd do something like this:
document.getElementById('results').src='http://mydatabase.qrimp.com/db.aspx?t=products&productnameop=CONTAINS&productnamequery=vinyl';

ParentTopic:

id:
193

name:

Default Template

description:

When you build a database, data can be displayed in different ways. For example, sometimes the data appears in a select box, a table or grid view, and if it is a record related to another one, sometimes it appears on the right hand side when viewing a main record.

Let's say we have a table called Transactions that has many Payments associated with it. When creating a Payment, a select box will appear prompting the user to select a Transaction to associate with the new payment. If, after creating the payment, the transaction selected in the drop down box is viewed, the right hand rail will show a list of Payments associated with the Transaction record.

In this case, Qrimp will try to be smart about how it shows those records in the right hand rail so you can understand exactly which payments those are. Because screen space in the browser is limited, Qrimp chooses just a single piece of information to display. It does this in a particular order:

If a field exists in the table called "Name" that data is shown.
If no Name field exists, Qrimp finds the first text field with 100 or fewer characters to represent the record.
If no no text fields with less than 100 characters is found, Qrimp shows the ID for the record.

Sometimes this strategy is suboptimal, meaning, you want to "help" Qrimp understand how to present the data to your application's users. To help Qrimp, each table in your database has Table Settings which you can use to describe how Qrimp should display the data in it.

There are two fields on the Table Settings page that you can use to tell Qrimp how to display the data, the first is the default field which appears near the top of Table Settings Edit screen. If you want Qrimp to display data from only one field in your table in the right hand rail or in select boxes, choose a column in the Default Field drop down.

The Second field is the Default Template, which can be seen near the bottom of the page. If you want to create a template for records in the table that contains information for several columns, use the Default Template.

Continuing from the example above, let's have a Payments table with just the ID, Amount, PaymentDate, and PaymentMethod. The PaymentMethod is a pickfrom the PaymentMethods table. In this table, there is no text field to represent the payments, so we want to create a Default Template using the Payment Amount and the Payment Method. Since the Payment Method is a pick from, we need to use Square Brackets to represent this.

To accomplish our goals, we will create a Default Template as follows:


$[Amount] - [PaymentMethods:[PaymentMethod]]

This use of Square Brackets tells Qrimp, that when displaying a Payment, format the data using a dollar sign, then the Amount of the payment, followed by the name of the payment method used, which is retrieved from the PaymentMethods table using the value in the PaymentMethod field of the particular Payment record.

ParentTopic:

id:
194

name:

Enabling Google Fonts

description:

If you'd like to take your Qrimp app to the next level of design, you'll probably want to add some new fonts. The Google Fonts API
http://code.google.com/apis/webfonts/ is the best way to make using more fonts easy!

For Google Fonts to work with IE, you must include a STYLE tag as the first line in the HEAD tag. To do this, we have a custom feature to modify the first line of your Qrimp app's HEAD tag.

This help file will walk you through the steps required to add the ability to modify your head tag.

First, you must add the HeadOptions column to the t_stylesheets table.

Choose Develop > Manage Tables
View System Tables
Find t_stylesheets (id: 16)
Click Edit for that table.
In the Add New Column section, enter headoptions for the column name and choose Single Line Text up to 255 characters as the data type
Click the Add Column button
Stay on this page to continue to the next part of this task.

Second, you need to update the headoptions field for the style sheet for which you want to include extra fonts.

To do that, at the top of the Edit t_stylesheets page, you'll see a link to t_stylesheets with a magnifying glass to the left of it.

Click that link. It will take you to /db.aspx?t=16 and show you a list of your stylesheets.

Click the edit icon (

) in the row of the stylesheet you want to enable fonts.

Paste the text box below into the headoptions field:

The code above includes ONLY the Smokum font, you'll need to update the list of fonts to include the fonts you want to add to your site. For example, to include Smokum and Bevan, you'll use the text in the following input:

For more information about creating the proper Google Fonts import link, please visit Google Font's getting started page:
http://code.google.com/apis/webfonts/docs/getting_started.html

ParentTopic:

id:
195

name:

Site Header

description:

The site header is an area of your Qrimp app that appears near the top of every page and every view. This is where you can find the logo, the login div, and the search bar. If you want to change just the logo, visit the help topic on Changing the Logo first.

Editing the Site Header

Go to Design > Skins. In the area under "Change Site Header and Footer" marked "Header" enter your HTML content and click save. Be cautious, as any changes you may have entered in the skin above will be lost when you save the site header/footer.

Replicating Look and Feel with Site Header

One of the fastest ways give a Qrimp app the same 'look and feel' as an existing site that you wish to migrate to Qrimp, is to copy the content from the page head or banner area near the top of the originating page.

To do this, copy the HTML and CSS from the originating page. If you have footer content, do the same, but copy and paste it into the Footer text box. You will surely have to make a few tweaks to width etc, and pull in any images, but this is a great 'head start'.

Warning

Since the site header can include any HTML, there is a chance that you can really disrupt the normal operation of your Qrimp app. For this reason, we strongly recommend you copy the Default Skin into another skin before you make changes. This way, you can make changes outside the normal site that your other users are using. Then, when the Header is working correctly, you can copy it into the Default Skin's Header for everyone else to enjoy too.

If you really break the site header, you can switch back to the Default Skin that works and then delete the new skin you were working on and start over or correct any issues.

If you are copy/pasting HTML from another website, be sure it doesn't include any FORM tags for search forms or other HTML. We recommend you start slowly with only minor changes.

ParentTopic:

id:
196

name:

Navigation

description:

The topics in this section cover how users navigate your Qrimp app. How do users get to your data? Which actions are allowed from which places? Which messages are shown on forms?

ParentTopic:

id:
197

name:

Working with Data

description:

This section explains how to get data into and out of your Qrimp app. You will learn how to add data, delete it, edit it, import it, export it and more.

ParentTopic:

id:
198

name:

Data Analysis

description:

Get deeper insight into your data with queries, reports and charts.

ParentTopic:

id:
199

name:

Display and Design

description:

Learn about how to display data in Qrimp and change the look and feel of your application with skins (CSS stylesheets). Change where form fields appear on a page.

ParentTopic:

id:
200

name:

Communicate and Share

description:

Learn to use Qrimp for messaging and share data that is in your Qrimp app.

ParentTopic:

id:
201

name:

My Account

description:

Everything you need to know to keep your account running.

ParentTopic:

id:
203

name:

HTML

description:

What is HTML?

HTML stands for Hyper Text Markup Language, it is how web pages are made. Knowledge of HTML will help you modify the way your Qrimp application is displayed, but is not required to use a Qrimp app.

Working with HTML

You can see the HTML for any web page by using the Developer Tools in your web browser. You can also right-click and select View Source or View Page Source.

You can use HTML in a Qrimp app when editing records, in the Header/Footer for records, in Views, and in Field Templates. You will need to make sure that your user group has permission to edit HTML (See User Groups.

Here are some resources to help you learn HTML.
W3C Schools HTML Tutorial
Dave Raggett's Getting Started with HTML
EchoEcho.com's HTML Tutorial
Interactive Tutorial for Beginners

ParentTopic:

id:
207

name:

Convert a Field to a Drop-Down

description:

To 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.

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

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.

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.

ParentTopic:

id:
208

name:

Widgets

description:

You can also add widgets to your form to create borders around groups of text entry fields or to otherwise spruce it up. Watch the video below for more a demonstration of widgets.

ParentTopic:

id:
209

name:

Advanced Development

description:

The features in this section will be useful to those with a web development background. Be cautious when implementing these features.

ParentTopic:

id:
210

name:

Javascript and JQuery in Qrimp

description:

Make your Qrimp App more dynamic with JavaScript and JQuery.

ParentTopic:

id:
212

name:

Importing Large Datasets

description:

The following tips and tricks will help you import large datasets. If you are working with a small dataset, you can use the menu item Develop > Import data. See Import Data.

Copy Paste from Excel to Form

Keep the number of rows under 10,000 and the width less than 8,000 characters. We've noticed IE pastes large data sets better than Firefox. Sometimes the browser will crash if you try to paste a very large data set into a text field. So if this happens, try using one of the methods below. You can also paste this data into a .txt file and upload it using the Tab delimited file method described below.

Tab Delimited File Upload

One flat file import can be many megabytes, but upload time will depend on your connection speed. Since this is just one flat file, only a single table will be built. All the data should be consistent, meaning all date fields should be valid dates, numbers should all be numbers, no letters in the number fields. These rules apply to all import methods.

Excel 97/2000 .xls Import

File size < 20 MB, < 100,000 records per sheet, fewer than 20 sheets. Match sheet names to table names in Qrimp. Use this if you want to build the relational model to support multiple data sets automatically. Each sheet will be a table.

Importing Large Datasets

If you are converting an existing application or have extremely large sets of data you need to import, then the web is not a viable option. Because network latency, script timeouts, and other factors designed for a high scale environment like a web application are not designed to accommodate very long running batch processes, we need to import large sets without using the web.

Qrimp Hosted

If you are using Qrimp's Hosted solution, you can import data using the Rest-like API. This could take a while with millions of records to import, so in a scenario like this, it may always be best to contact support first. You can also download the Qrimp Server Installation and use the method described below.

Qrimp Enterprise Solution

If you are using the Enterprise solution installed on your local network, there are many options available for importing data. You will probably want to get help from someone experienced with Microsoft SQL Server to perform one of these import options. The first step to importing a large data set with Qrimp installed is to define the application. This is usually easiest using Qrimp's web interface to define tables manually. This process will create the underlying primary keys, foreign keys, and support tables needed to run your Qrimp application. A more difficult, but more flexible way is to define the data model directly using SQL Management Studio, export from UML, Earl, or some other relational modeling tool. For this to work, each table must have an INT IDENTITY field named id. The next step is to get the data into your data model.

Data Transformation Services (DTS)

Qrimp is built on top of the Microsoft SQL Server product, so getting data into Qrimp is similar to migrating data between any existing databases. The best way we have found is to use Microsoft's DTS to import the data. Here are a few resources on the Web to help you understand how to use DTS to import your data. Creating a DTS Package with SQL Server 2005 Creating a DTS Package with SQL Server 2008 Data import / export with SQL Server Express using DTS Wizard You can download DTS for SQL Server 2005 Express here: http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi Download More Microsoft SQL Server 2005 Express Tools Here

ParentTopic:

id:
213

name:

Reordering columns

description:

To reorder the columns in a table, go to the grid edit view of the table. Click and hold the column header of the column you wish to rearrange. A multi-directional arrow icon will appear and a red line will show to the left side of the column you are moving. Hold and drag the column to its new position. All views will be updated to reflect your new column order.

ParentTopic:

id:
214

name:

Site Footer

description:

The site footer is used mainly if you have build an external website with Qrimp. Information in the footer will generally appear on all pages on the site. Web developers typically put information in the footer that is less important, such as copyright date, site developer, terms of service, contact links, etc.

Editing the Site Footer

Go to Design > Skins. In the area under "Change Site Header and Footer" marked "Footer" enter your HTML content and click save. Be cautious, as any changes you may have entered in the skin above will be lost when you save the site header/footer.

Replicating Look and Feel with Site Header/Footer

One of the fastest ways give a Qrimp app the same 'look and feel' as an existing site that you wish to migrate to Qrimp, is to copy the content from the footer near the bottom of the originating page.

To do this, copy the HTML and CSS from the originating page. If you have header content, do the same, but copy and paste it into the Header text box. You will surely have to make a few tweaks to width etc, and pull in any images, but this should start you off on the right foot.

ParentTopic:

id:
215

name:

Dashboard

description:

Your 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 Portals.

ParentTopic:

id:
221

name:

Document Folders

description:

Navigating Document Folders

To view your document folders go to Documents > Document Folders

You will see your top level document folders. Top level folders may or may not contain subfolders.

Click a folder name to drill into the folder and see the subfolders under it. You can see the "breadcrumbs" trail above your folders, which shows you which level you are at.

Keep drilling in until you find your documents!

Adding a document and creating new folders

To add a document, go to your document folders. At the top you will see a link that says "Add Document". Click the link and enter your data in the fields. To create folders, type slashes "/" between the folder names in the Folder field.
When you enter folders and subfolders, these are created new if they do not exist.

Adding documents to existing folders

To add documents to folders that already exist, navigate to the folder you want your document to go into and THEN click the "Upload Document" link.

Bulk folder creation

If you would like to bulk import folders or replicate your existing folder system, please contact us for a quote.

ParentTopic:

id:
224

name:

Changing your favicon (tab image)

description:

You can change the image that appears in a browser tab.

First, create or find your favicon. It should be 16 pixels wide and 16 pixels high. Although it is created as a png or jpg, you will need to re-save it as a .ico. Your operating system may ask if you wish to do this, say yes.

Then navigate to Design > Skins

Scroll to the bottom of the skin and click the link that says Upload Images.

Upload your image.

After it uploads, you will see the attachment detail view. Look on the right hand side under attachments and click on the image of your favicon. It will take you to your attachment url.

Copy the attachment url to your clipboard. Only copy the part starting at the word "attachments", ie: "/attachments/app.qrimp.com-c035e92e-b45d-4e88-b92c-31e0472fb5e9/img.ico".

Now, go to Design > Clean URL map.

Click the add new button at the top.

In the CleanUrl field, enter "favicon.ico". In the DirtyUrl field, paste the file location from your clipboard and add a slash "/" in front of the word attachment.

Depending on your browser, it may take up to several days for your new favicon to appear. Favicons are stored in the browser cache and we're not sure why sometimes they take so long to refresh. You can sometimes see it sooner by checking your site on a different computer. There may be problems with certain combinations of operating system/browser. If your favicon does not populate within a couple of days, let us know.

ParentTopic:

id:
225

name:

Messaging Module

description:

Install the messaging module to send messages in your Qrimp app. See Adding Modules

Sending Messages

To send a message, go to Messages > Compose New.

Select the user(s) to send the message to by clicking a username, or enter an email address into the users box. Messages sent to external recipients via email will not be logged in the Messages table by default.

Logging messages sent to external email addresses

To track messages sent to external email addresses go to Develop > Manage Tables. Select the Messages table and click "edit". Add a field called ToEmail with a data type of Email Address.

Creating Contacts Automatically

You can set up your Qrimp app to automatically create an entry in your Contacts table when you send an email to a new external contact. If you do not have a contacts table, create a table with at minimum the fields mentioned below. If you already have a Contacts table, go to Develop > Manage Tables, select Contacts > edit, and add the following columns:

Name - Single Line Text 100 Description - Multiline text 500 or greater Email - Email Address

Now when you send a message to an external email, the Name and Email fields will both show the email address. The description field will indicate that the contact was created from a message from within your Qrimp app. You can edit these fields later with more details.

Logging Contact Interactions

If you have or create an Interactions table, you can log interactions with existing contacts using the Qrimp messaging system. First, follow the instructions above for "Creating Contacts Automatically". Then add a table called Interactions, or add the following columns to your Interactions table:

Name - Single line Text 255 ContactId - Pick From Contacts InteractionDate - DateTime Description - Multiline Text 5000+

Click the check boxes for auditing and versioning.

Once you've built the contacts and interactions table, messages you send to external users from your Qrimp app will be logged. This data makes a great addition to a CRM and can be very useful on Reports.

Messaging about items in your database tables

To use this feature, you must be comfortable with query string urls.

You can add the ability to see messages about an item in a table. First, add two additional fields to the messages table:

TableId - Pick From Table Settings ItemId - Number without Decimals

To send a message about a particular item, you must type in a url table that references the table you are mentioning. If you include a parameter to the tableid and itemid of an entity in your Qrimp App, the message will be created with the tableid and itemid specified. You can create the link like this: messages.aspx?t=messages&compose=new&tableid=1000&itemid=1

In this case, the message will be logged as being sent about item 1 in the table 1000.

ParentTopic:

id:
226

name:

Messages

description:

Install the messaging module to send messages in your Qrimp app. See Adding Modules

Sending Messages

To send a message, go to Messages > Compose New.

Logging messages sent to external email addresses

To track messages sent to external email addresses go to Develop > Manage Tables. Select the Messages table and click "edit". Add a field called ToEmail with a data type of Email Address.

Creating Contacts Automatically

Name - Single Line Text 100 Description - Multiline text 500 or greater Email - Email Address

Logging Contact Interactions

Name - Single line Text 255 ContactId - Pick From Contacts InteractionDate - DateTime Description - Multiline Text 5000+

Click the check boxes for auditing and versioning.

Messaging about items in your database tables

To use this feature, you must be comfortable with query string urls.

You can add the ability to see messages about an item in a table. First, add two additional fields to the messages table:

TableId - Pick From Table Settings ItemId - Number without Decimals

In this case, the message will be logged as being sent about item 1 in the table 1000.

ParentTopic:

id:
230

name:

Adding Modules

description:

Modules are sets of database tables that add functionality instantly.

To add a module go to Develop > Add Module

Your module is added instantly. You may see new menus across the top that allow you to access the new tables. Sometimes you will not, for example, the "Countries" module simply adds the countries table to your list of tables. You can then use this as a look-up table (see Look-up Tables) in your other tables.

ParentTopic:

go to page: 1 2 3 4 5 243 records. Showing

Qrimp Help Documentation

Workflow

Paying with PayPal

Cancelling PayPal Subscriptions

Time Zone Awareness

Date Formats

Here are more options for date formats

Installing Qrimp on Windows Vista

Installing Internet Information Services

Installing SQL Server Express

Installing Qrimp

Install .NET 3.5

Reboot

Configuring IIS and Qrimp

Accessing Qrimp Locally

Potential Problems

Automated Backup Process

Automating Synchronizer

Help Topics

Forums

Email

Webinar

Getting More Help

Contextual Help within your Qrimp App

CRUD

Views

Basic Views

Creating links to Views (for menu tabs and more)

Name

Description

Displayid

Header

Footer

ItemTemplate

CellTemplate

PageSize

ContentType

EnableWiki

Advanced: Building a New View

Copying a View

Custom Pagination Look and Feel

Changing the Logo

Changing your logo in the skin (CSS)

Remove the logo altogether

Adding a logo to a Custom Header

Portals

Adding a Portal from Grid View

Moving Portals

Resizing Portals

Customize Portal Background Colors

Advanced: Manually Editing Portals

Deleting Portals

Adding a User Group

Charts

Input Security Restrictions

Retrieving id for new elements

Creating a Portal with a Chart

Dependent Select Boxes

Number Formats

Embedding Data in your website

Default Template

Enabling Google Fonts

Site Header

Editing the Site Header

Replicating Look and Feel with Site Header

Warning

Navigation

Working with Data

Data Analysis

Display and Design

Communicate and Share

My Account

HTML

What is HTML?

Working with HTML

Convert a Field to a Drop-Down

Widgets

Advanced Development

Javascript and JQuery in Qrimp

Importing Large Datasets