Search the help documentation


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

deleteedit1343Users aren't receiving their temporary password emailQrimp sends many emails every day and sometimes those emails are blocked
by email settings at the recipient end. In this case, the user will not
receive their username and password email when you create their account.

The long-term solution is to add Qrimp's support email account to your
email filtering software's safe list. ConstantContact maintains a help
topic on <a href="">how to add safe senders in many different email programs</a>.

Sometimes the above step won't work or you need an administrator to help,
but in the meantime, you need to get your new users into the system. The
best way to do this is to follow our guide on <a href="//">How to reset a users password in Qrimp</a>.

IMPORTANT: When you click the Approve account in the final step, write down or
copy/paste the temporary password so you can share it with the new user
via email or in person.
Adding Users
deleteedit1342Default FieldsA default field is the field from any table that is displayed in a related table or on the calendar view.

<img class="border" width="550" src="" />

If no default field is selected, Qrimp will use the first text field in your table as the default field. If there is no text field, Qrimp will use whichever field comes first.

<h2>Changing the Default Field</h2>
To change the default field, go to your table, then click the Table Management sub-menu.

At the top of the table management page, click the link that says "Configure Table Settings".

In the defaultfield drop-down, select the name of the field you want to appear.
<img class="border" src="" />

In this example, we will change the field from being the name of the timesheet to the description.

Table Settings
deleteedit1341Hidden Page VariableQrimp has a special hidden HTML form field called "page" that allows you to configure where the user goes to after clicking a link, creating or saving records.

To modify the location the user goes to, Design > Design Mode ON. Go to the form from which you want to control where the user goes to after clicking the button.

Click the gear near the buttons. You'll find in that HTML a hidden INPUT form field called "page". You can change this variable to a URL that you'd like the user to go to after submitting the form. This URL can contain variables that are updated with values from the saved form you can also use [square brackets] to include SERVER variables like the HTTP_REFERER to send the user back to the page they were on when they clicked the edit or add new link.

<h2>Add a Create and Add Another button</h2>
Sometimes, you may want the ability to quickly create a lot of items at once. On the add new item screen (vid=8 in the url), you'll want to edit the header footer, add the button, and then when that button is clicked, change the value of the hidden page variable so that it sends the user back to the page you are on, rather than going to the detail view of the newly created item.

Here's how to do that. First, be sure design mode is on according to the instructions above. Then, go to the Add New form where you want to create many items quickly.

Click the gear next to the save buttons at the bottom. A lightbox will appear with the HTML for the Create and Cancel buttons. We'll add another button. To do that, copy the Text that starts with the Less than sign and INPUT type=submit. Select all of that text through to the Greater than sign. That's one HTML tag for the create button. Copy and paste it.

Change the value of the pasted INPUT button to "Create and Add Another". You'll need to have all of that text including the quotes so your browser knows to include all of it on the button. Now, we need to add another attribute to the input tag that changes the hidden PAGE variable. Add onclick='$("#page").val(document.location.href);' somewhere inside the newly copy/pasted INPUT field.

Next, add an attribute to the HIDDEN page variable that we can use to tell JavaScript which input value to update. Just add id="page" inside the HTML tag for the hidden input variable named page.

Your new HTML inside the lightbox should look like what is in the TEXTAREA below. In most cases, you can probably just copy/paste this HTML into your lightbox area to get the results we've described here.
<textarea><INPUT type=submit value=Create name=op class=button> <INPUT type=submit value="Create and Add Another" name=op class=button onclick='$("#page").val(document.location.href);' > <INPUT type=hidden value=5 name=o><input type=hidden id=page name=page value="db.aspx?t=HelpTopics&vid=11&id={id}"> <a class=button href="javascript:history.back()" title=Cancel>Cancel</a></textarea>

Click save. Now you can click the "Create and Add Another" button to quickly add a lot of items to the same table.

Form Designer
deleteedit1340Long drop-downs - searchIf you're selecting from a drop-down list that is very long, it can be hard to find what you're looking for. We have a field template that can provide a different interface for this - one that lets you search through the drop-downs rather than scroll.

<textarea><noeval>That table does not exist. </noeval></textarea>

For this to work, you must create and include a page called "manufacturersearch" with javascript that will make it work.

Please <a href="">contact us</a> if you are interested in this feature.

Square Brackets
deleteedit1339Entering Currency AmountsIf you have chosen currency as your [datatype], there is no need to enter the $ with the amount.

If you do this, you will get an error message stating you have entered a value that was not the correct type. (See [Error Messages]).
Entering and Editing Data
deleteedit1338Sorting in Grid EditYou cannot sort by the 'id' or 'name' column in [Grid Edit].Known Issues
deleteedit1337All query parameters in the list for menuid must be numeric.You may come across this error when re-ordering your menu tabs. You can ignore it, it doesn't seem to have any effect.Error Messages
deleteedit1336Conversion failed when converting the varchar value 'Fred' to data type int.Text entered, number expected. This often occurs when Qrimp is expected the id # (See [AutomaticIDs]) of your record instead of the name.

If you can, find the id number of the item you need. For example, in the users table, Fred's ID is 4. If you enter 4, this error should go away.
Error Messages
deleteedit1335Add Select List with Square BracketsAn Introduction to Qrimp">Square Brackets
deleteedit1334Add a radio button[radios:yesno:[DATA]:autoupdate]Square Brackets
deleteedit1333Table Search BoxTo add a search box to the top of any table, first go to the table and the view you want to add it for.

Then go to Develop > Header/Footer.

At the very end of the [HTML] in the [ContentHeader] add:
</textarea>. Click Save.
Square Brackets
deleteedit1331Legacy Fields Imported from WebOfficeThrough out your newly imported Webex WebOffice system, you may find some fields with names like these:

Owning Record ID, Owning App ID, Modified or Created, Activity Flags, and some others that can be confusing.

We've adapted the first one, Owning Record ID to point to the original record in your system.

The last three are no longer used. Qrimp tracks the createid and createdate in separately. The modified date is stored in the Audit Logs. You can hide the last three unused fields by adding adding the following to your Qrimp App Skin, via Design > Skins.
Import Data
deleteedit1330CachingCaching is a way that data from your website is stored temporarily in your browser to make your browsing experience faster. Caching is very common on the internet. Stored data is kept in your browser's cache, and can be cleared from your browser. Qrimp makes use of caching.

<a href="">Wikipedia article on caching</a>
deleteedit1329lockedoutusername<em>Note: This help topic is a stub and will be expanded. Please contact if you are interested in using this feature and cannot follow these instructions.</em>

Admins can use the squarebrackets variable "lockedoutusername" to create a notification template called "ACCOUNTLOCKOUT" and then subscribe to that in the admin notifications area.

If someone tries to log in and fails a bunch of times and their account is locked out, the subscribers to that notification will get an email letting them know that a user in their app is having trouble and they can meet the issue head-on. The notification template can include a link to a help topic that explains what to do if an account is locked out.
Square Brackets

Only use autoupdate if you want editing to be enabled from the view.
Square Brackets
deleteedit1327Add My Task List to a PortalA list of tasks on your [Dashboard] can help you see what you need to do this week. You will need to have a tasks table.

In your menus, go to Tasks.

<img class="border" src="attachments/">
You will see a list of all tasks.

<img class="border" src="attachments/">
Search the tasks list for tasks that are assigned to you.

<img class="border" src="attachments/" />

Now that you see a list of tasks assigned to you, look at the bottom of the page, below the tasks. There is a link that says "Share". Click the share link.

<img class="border" src="/attachments/" />

You will see an add to Dashboard button. Click "Add to Dashboard".

<img class="border" src="attachments/ " />
Name your new tasks portal.

<img class="border" src="attachments/" />
Click the "View Your Dashboard Now" link.

<img class="border" src="attachments/" />
Your tasks are now a portal window on your dashboard.

<img class="border" src="attachments/" />
deleteedit1326Working Offline, Backing Up, Getting Data out
deleteedit1325Building Your SystemEverything you need to know about how to build an app in Qrimp.
deleteedit1324Above and beside your dataAbove your data, you generally find the Header and below, you find the footer, or 'rightcontent' or [item footer].Navigation
deleteedit1323Changing the Look and Feel of Your AppYou can change the colors, fonts, logos and more in your Qrimp app.Display and Design
deleteedit1322Table SearchTo search a table, click on the search icon <img class="noborder" align="absmiddle" src="/icons/crystal_project/32x32/actions/filefind.png"> in the [Content Header].

<img class="border" src="attachments/" />

You will see a dialog box that will allow you to enter criteria for your search:

<img class="border" src="/attachments/12e532dc-8bc0-46c0-b26b-11494d7d4bbb/searchdialogbox.png">

Choose a search filter from the drop-down list of operators (contains, greater than, equals, etc.) to limit the results of your search. For example, if we only wanted to find modules that contained the word "tasks" in the description field, our search would look like this:

<img class="border" src="/attachments/fca0436d-1a11-4662-8b1a-9e6a22b370a5/searchfilter.png" />
deleteedit1321Date SearchTo search by date, look near the top right of your app. You will see a calendar icon. Click on the icon.

<img class="border" src="attachments/" />

Click a date then click search.
<img class="border" src="attachments/" />

Your search results appear. They are linked to the database records, so click them to go to the record.
<img class="border" src="attachments/" />
deleteedit1320Site SearchTo search your entire site (all tables in your Qrimp app), use the search field at the top right of your app.

<img class="border" src="attachments/" />

You will see a list of any tables that contain the word or number you searched for.

Click the link to go to that table or record.

deleteedit1319Table ManagementDevelop > Manage Tables

You can click the edit link for the table to edit the columns and field types for your tables. You can also manage [group security] and [column security] as well. Click the settings link to change the title of the table, enter default templates and pick the field to show in drop downs or links to items in the table. You can also enter an [SQLSecurity] clause to restrict access to records in your table or [show and hide items in a drop down box].
Manage Tables
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.
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
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing