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
deleteedit1318How to reset a user's passwordPreface: If the user has attempted to log in several times and failed, their account my be locked out and they will need to wait until the lockout expires. Please tell them to wait and try again in 10 minutes.

If you still need to reset the password, simply enter the user's email address on the login help screen and tell Qrimp to email them a link to reset their password. Please see <a href="help#238">Help Topic #238: Forgot Password</a> for more info.

You can also send them a new temporary password by reapproving their account.
<ol><li>Go to Admin > Manage Users
<li>Click the table view icon
<li>Click the username in the Username field of the table view, the left most name in default Qrimp setups.
<li>You will now be looking at the approve user account.
<li>Verify the correct user group
<li>Click approve, the user will receive a new email with a username and temporary password.
</ol>
TIP: You may want to write down or copy/paste the temporary password for the
new user in case they do not receive the email notification.

NOTE: Sometimes due to email configuration settings, new users will not
receive their username/password email notification. If you reset a password
or create a new account and the user does not receive the email, here's
what to do when <a href="help#1343">Users aren't receiving their temporary password email</a>
Logging in
deleteedit1283Edit an Existing Custom ViewTo edit an existing custom view, go to the [grid view] of your table.

Choose the view you want to edit from the drop-down list of views.

Click the link that says "Edit View"

<img class="border" src="attachments/developer.qrimp.com-c31964c8-6dd8-4d6b-acb8-77bb3e6e898b/editexistingview.png" />

Edit your view to suit your needs.

See also [Custom Views (Sorting and Filtering)]
Custom Views (Sorting and Filtering)
deleteedit1301Links from my Views give me an errorIf you want to be able to click a record from a view and go to that record, you must include the id column when you are creating your view.Custom Views (Sorting and Filtering)
deleteedit1314Default View on the Custom View BuilderThe default in the custom view builder is a modified version of the [Grid View].

You can modify the default view with:

[Grid Edit]
[Reordering Fields]
[Hiding Fields]
[Column Level Security]
Links in the [Menus]
[Field Templates]

There is not any way to delete this default view from your list at this time.
Custom Views (Sorting and Filtering)
deleteedit66Showing and Hiding Columns with the Query String<h2><em>Advanced</em></h2>
You can edit a <a href="db.aspx?t=helptopics&id=261&vid=11">url</a> (link) to either show or hide columns in a table.

You can use the hide or select parameters to edit the url in your location bar and change the data that is displayed when you re-load your page.

You can also paste links to modified [query strings] into <a href="db.aspx?t=HelpTopics&id=10&vid=11">Menus</a>, the [Content Header], [Field Templates] and <a href="db.aspx?t=HelpTopics&id=176&vid=11">Views</a>.

<h2>Hidecolumns</h2>
Hidecolumns hides the columns you specify. If you are looking at a table and it is too long, and you don't want to add [custom views (sorting and filtering)], you can quickly edit the url to hide a few of these columns, but every time you refresh the page, you will have to re-hide them.

To hide a columns edit the url as follows:
"https://myapp.qrimp.net/db.aspx?t=mytablename&vid=11&hidecolumns=id,description,priorityid,partnershipagreement"

If you want to save this link as a menu tab, copy it from your location bar and type it into the linktemplate field of your menu tab (See [edit a menu tab]).

<em>Note: Hidecolumns retrieves all of the columns from the database and pulls them into your browser, then hides them from view. For this reason, hidecolumns uses more bandwidth than selectcolumns.</em>

<h2>Selectcolumns</h2>
You can retrieve and display only the particular columns you select using "selectcolumns" in your query string (url). A selectcolumns query is written as follows:
"db.aspx?t=tasklist&selectcolumns=name,duedate,priorityid"

Because showing columns only pulls back the selected columns, it uses less bandwidth than hiding columns.
Query Strings
deleteedit128Query String ParametersUse the following [query strings] options to query your data and drill down into particular records and even columns.

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

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

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

You could display the HelpTopics on the [Calendar View] like this:
<a href="calendar.aspx?t=HelpTopics"><b>calendar</b>.aspx?t=HelpTopics</a>

Or in a [Tree View] like this:
<a href="treeview.aspx?t=HelpTopics"><b>treeview</b>.aspx?t=HelpTopics</a>

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

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

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

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

<h2>Sorting your data</h2>

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

<h2>Filtering your data</h2>

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

Look in the location bar now and you will see:
<a href=/db.aspx&t=HelpTopics&vid=1&gotopage=9&orderby=4>/db.aspx&t=HelpTopics&vid=1&gotopage=9&orderby=4</a> Which means, show the item from the HelpTopics table using view number 1 and for the Help Topic with id equals 128.

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

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

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

To find the id number of a table, go to Develop > Table Management.

Find your table in the list and note the id # that appears in brackets beside your table name.

<img class="border" src="attachments/developer.qrimp.com-bdbc81bf-d9fd-42ec-a709-8404428a4f06/clientstableid.png" />
AutomaticIDs
deleteedit4User GroupsUser Groups are group profiles that help you manage sets of users and control access and permissions to your data. User groups are often based on job function, such as HR or accounting, or by access level, such as administrator or anonymous.

<h2>Default User Groups</h2>
Your Qrimp app has five default user groups: Administrator, Developer, Tester, User and Anonymous. The Administrator Group has the most default privileges, while the Anonymous group, which refers to public (not logged in) users, has none. You can change these settings on a table by table basis using [Table Security] and/or [Group Menu Visibility].
Managing Users
deleteedit5Adding UsersTo add a user, go to Admin > Manage Users. Click the link that says "Add a New User"

<img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/d518f04e-6263-42c2-aacb-86fb4e3f9154-add%20user%20screen%201.png">

Enter the user's information in the form and select a user group for them: <img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/d2b6612f-73c9-4d3f-9ec6-d507b59edbf7-add%20user%20screen%202.png">

Your user will get an email from support@qrimp.com with login and password information on their account. Make sure they check their spam!

<img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/8b4d3cfd-f13a-44c8-89e3-89923298cf41-add%20user%20screen%203.png">

Repeat this for all users. If you have a large number of users <a href="http://www.qrimp.com/contact.html">please contact us</a> for information on bulk user creation.
Managing Users
deleteedit12Assigning Users to GroupsBy default, every Qrimp application comes with the following [user groups]: Administrator, Developer, Tester, User and Anonymous. You may wish to create additional groups based on specifics of your organization, such as "Accounting", "Editors" or "Human Resources".

By default the first user is an Administrator. Administrators can see most tables by default.

To add a user to a group go to Admin > Assign User to Groups. Click the add new icon.

You will see two drop-down boxes. Choose the user from the first, and the group from the second. Click the Create button.

<img src="/attachments/931603f9-0552-4351-9984-17befcb57aba/AssignUsertoGroup.png">

You must repeat this process for each user and each group.
<h2>Bulk Assigning</h2>
To bulk assign users to groups, go to the gridedit view of your users table. There is no link to this by default so you will have to type in a url: http://myapp.qrimp.net/db.aspx?t=t_users&_showeditgrid=true Replace myapp with your app name.
Managing Users
deleteedit182Adding a User GroupUnder 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.Managing Users
deleteedit1270Deleting a UserTo delete a user, go to Admin > Manage Users.

Click the name of the user you want to delete:

<img class="border" src="/attachments/developer.qrimp.com-e624ebb2-0412-447f-a283-5f180dba3538/clickusername.png" />

In the [ContentHeader], click the red X delete button:

<img class="border" src="/attachments/developer.qrimp.com-c6a1fe39-81aa-48b4-9e45-7a7ff3f3c146/userdeleteormakeinactive.png" />

If the user has created records, or has permissions associated with their account, you will either need to delete or reassign those records:

<img src="attachments/developer.qrimp.com-d46cd829-58fe-4e81-a885-6bc04deab9c7/cantdeleteuserbecauserecords.png" />
Managing Users
deleteedit1272Marking a User Inactive (Not Enabled)If you want to not let someone use your system anymore, but you want to keep the historical data associated with them, you can mark them inactive. This can be more convenient than [deleting a user] because a) you get to keep all of their data and b) you don't have to reassign all of their data.

Do make a user inactive go to Admin > Manage Users. Then click the users name.

Change the radio button enabled to 'no'.

<img class="border" src="attachments/developer.qrimp.com-ed30c5f1-5256-420c-b4b0-06e9b60a44d3/makeuserinactive.png" />
Managing Users
deleteedit102Default Start PageYou can set a default start page for each group in the [User Group Settings]. This determines which page any user in that group will see when they log in. By default, the start page for all [user groups] except anonymous is the [Dashboard]. The [anonymous users] group sees the login page by default, because they are not authorized to view any information unless you specify that they can.

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

<h2>Changing the Default Start Page</h2>

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

Then, go to Admin > User Groups.

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

Copy your url into the Default Start page field.

Click save.

To test, have a user from that group, log out and log back in to the system. When they log back in, they should start out at the new default start page.
User Group Settings
deleteedit1295Separate name and address fields (From WebOffice)If you are coming to Qrimp from WebOffice, this applies to you.

If you used the "name" or "address" datatypes when you built your WebOffice, the WebOffice back-up tool concatenates your separate name and address fields into one field. For example, if you had FirstName, MiddleName, LastName they would all be merged into one Name field.

If you want to re-separate the fields, follow the steps below. Note that there are two ways to pull the data into your app.

<h2>Step 1 for both options: Create Separate Fields</h2>

In your Qrimp app, <a href="db.aspx?t=HelpTopics&id=19&vid=11">Add columns</a> for FirstName, MiddleName, LastName or Address1, Address2, City, State, ZIP, to the affected database table.

You now have to choices about how to get the separated data into those fields:

<h2>Option 1: Fast Qrimp Update Statement and Manual Review of Fields</h2>
Let your Qrimp rep know when you have separated your fields. A Qrimp support person will run a big update statement that will update all your records with the broken out data at no additional charge. You will need to review the data that is created, as it may have some problems which will need to be fixed manually. This option requires less work but doesn't give perfect results. Some of your data may not split properly depending on punctuation, spelling and symbols in the fields.

<h2>Option 2: WebOffice Custom View and Thorough Qrimp Update Statement</h2>
Create a custom view in your WebOffice that breaks the Name/Address fields out, then a Qrimp rep updates your app. Qrimp charges at our [Hourly Rate] for this service. Each table will take about 2 hours. This is more thorough than Option 1. It requires more work on your part, but gives the best results possible. This solution can be problematic if WebOffice does not provide a UniqueID field. A UniqueID field is only provided in some cases.


<h3>Steps to Complete Option 2</h3>
Go to your WebOffice. Create a custom view that breaks the NAME and ADDRESS fields out into individual columns for each portion of the name and address. <strong>This view must include the UniqueID of the record in the view</strong>.

Export your data to a .csv file, then <a href="db.aspx?t=helptopics&id=62&vid=11">import it</a> into your Qrimp app as a new table. Name the new table "ClientMap".

Let your Qrimp rep know when you are finished with this and they will run an update query that updates all the records with what WebOffice exports in that custom view.

Note: If WebOffice doesn't provide the UniqueID, then we have to find some other field(s) to use as a unique identifier to update the records and that's not always possible depending on the data.
Configuring Imported Tables
deleteedit158Paying with PayPalPaying 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 <a href="http://www.qrimp.com/signup.html">sign-up page</a>, 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.

Billing
deleteedit159Cancelling PayPal SubscriptionsThe 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.
<img src="attachments/6bc9e2f3-5360-4f88-9125-cb1fe80414a0/ppsubscriptionsdropdown.JPG" />
5. Check the From box and change the date back to your subscription date.
6. Click Search, and then click Details.
<img src="attachments/52ba7245-98a1-4c5a-902d-c90b2d3dfa73/ppsubscriptionsdetailslink.jpg" />
7. Click Cancel Subscription.
<img src="attachments/56f00d36-c3fa-42cf-99c3-6db5efb4ebc0/cancel button.JPG" />
Billing
deleteedit1298Hourly ServicesQrimp can provide technical services such as those performed by a programmer, DBA, or data entry and formatting.

Our current hourly rate is $150/hr and our minimum billing increment is 15 minutes.
Billing
deleteedit20Adding SkinsTo change the look and feel of the site, go to the Design tab and click on [Skins]. Enter the url to your stylesheet.

<img src="attachments/6c9fb3b8-6046-4d32-a767-ad3478d2a4f5/Skins.jpg">

To customize all of the elements that we use on our site, download the <a href='styles/twocolflexbannerbrochure.css'>default stylesheet </a> and edit the properties you would like to change.

To get your CSS files onto the server, create a project you'll use to manage your style sheets and upload the CSS file as an attachment. Then use the url of the attached file as the URL you paste in the URL box.
Changing the Look and Feel of Your App
deleteedit70IconthemeEvery Qrimp app comes with a set of icons built in. To view all of the icons included with your Qrimp app go to Design > Icons List.

<strong>Changing your default IconTheme</strong>
Each user can choose which icon size they wish to use in their [Content Header] when they are logged in. You can choose 16x16 icons or 32x32 icons.

To change a user's icon settings, go to [Admin] > [System Tables]. Find the t_settings table. You will see a list with all of your users in the userid column and their chosen icon style in the icontheme column. Click on edit icon in the row that contains the record you would like to change.

<img src="/attachments/506118aa-6f10-4062-ba05-bedbda15faf7/Picture 5.png">

When you are in [Edit View], go to the icontheme field and change the display size from 16x16 to 32x32 or vice versa.

<img src="/attachments/1ca1d94c-230b-4089-81fb-e41f742e6c41/Picture 4.png">

<strong>Using Your Custom Icons</strong>
Qrimp plans to allow you to add your own icon set if you wish. At the present time, this is only possible if you choose the same naming convention for your iconset as is used for the crystal project icons (names must include folders in url).

If Qrimp has 1000 icons in one set and 100 in another, and you set an icon to point to one of the 900 we don't have and change the icon theme, then they'll be broken images.

<strong>Using the Default IconTheme in your urls</strong>
When you are writing a url and want to link to an image automagically, you can use [square brackets] around the word icontheme to create a link to it in a url. Qrimp will automatically display whichever icon theme you have chosen. For example, [ /icons/crystal_project/32x32 ] will insert /icons/crystal_project/32x32. You must be sure to write the folder location for the urls correctly. Follow this example: /icons/crystal_project/32x32/actions/1day.png
Changing the Look and Feel of Your App
deleteedit180Changing the LogoYou 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:

<h2>Changing your logo in the skin (CSS)</h2>

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. <strong>Every character as symbol is needed, so type carefully!</strong>

#logo{
background: transparent url("http://mysite.com/attachment/12345mylogo.png") no-repeat scroll 0%;
top: 25px;
left: 1px;
width: 200px;
height: 100px;
}
<h2>Remove the logo altogether</h2>
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;
}

<h2>Adding a logo to a Custom Header</h2>
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.
Changing the Look and Feel of Your App
deleteedit194Enabling Google FontsIf 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
<a href="http://code.google.com/apis/webfonts/">http://code.google.com/apis/webfonts/</a> 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 (<img src="/images/edit.gif" />) in the row of the stylesheet you want to enable fonts.

Paste the text box below into the headoptions field:
<input type=text value="<style>@import url(http://fonts.googleapis.com/css?family=Smokum);</style>" size=100 />

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:
<input type=text value="<style>@import url(http://fonts.googleapis.com/css?family=Smokum|Bevan);</style>" size=100 />

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

Changing the Look and Feel of Your App
deleteedit195Site HeaderThe 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.

<h3>Editing the Site Header</h3>
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.

<h3>Replicating Look and Feel with Site Header</h3>
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'.

<h2>Warning</h2>
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.
Changing the Look and Feel of Your App
deleteedit214Site FooterThe 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.

<h3>Editing the Site Footer</h3>
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.

<h3>Replicating Look and Feel with Site Header/Footer</h3>
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.
Changing the Look and Feel of Your App
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing