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
deleteedit1316Edit a Menu TabYou can change the text on a menu tab to say anything.

You can also edit where a user goes when they click on a menu.

If you want to change the link the menu tab goes to, first go to the table and view you want to change it to, then copy the <a href="db.aspx?t=HelpTopics&id=261&vid=11">url</a> to your clipboard.

<img class="border" src="attachments/developer.qrimp.com-4a60b8ae-9553-4b5d-bb91-656ca384dbc6/copyurl.png" />
-------

Now, go to Develop > Manage Menus.

<img class="border" src="attachments/developer.qrimp.com-dbb79dc0-6efa-4c51-9b2e-3dea23fd225b/developmanagemenus.png" />
----

Click "Edit Menu Item".

<img class="border" src="/attachments/developer.qrimp.com-8bb4f48f-a21d-4a8e-b95d-2d00450693ea/editmenuitem.png" />
----

Click the name of the menu tab you want to edit.

<img class="border" src="attachments/developer.qrimp.com-b1cd5ea1-d527-46f2-bdc8-153798c462ad/clickonmenuitem.png" />

Enter your new text in the name, or paste your url into the link field, then click Save.

<img class="border" src="attachments/developer.qrimp.com-ec76b211-43de-4ba6-ada9-729d441c0e1a/addmenudetails.png" />
----

Now, try clicking on the menu tab to make sure it worked.
Menus
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)
deleteedit74Edit ViewClick the edit icon (<img alt="Edit Icon" src="/icons/crystal_project/32x32/apps/kate.png">) in the [Action Icons] area to edit records in your table. You will see each of the fields in your table shown as textboxes, radio buttons, drop-down lists etc. Enter or edit text, select options from drop-down list fields, change radio button options and dates and more. To save, click the save button at the bottom of the page.

<img alt="Edit View"src="/attachments/2603fbe4-4e91-43f7-a7df-b7d11c64c9c5/Edit View.png" />		Views
deleteedit169EmailEmail 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.		Getting More Help
deleteedit190Embedding Data in your websiteIf you have a hosted website you can use Qrimp as the database to show data on that website using either EMBED code or IFRAMES.

<strong>Using Embeds</strong>
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.

<strong>Using IFRAMES</strong>

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.

<strong>Re-sorting the Data in an IFRAME</strong>
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';

<strong>Searching IFRAMES</strong>
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';

Communicate and Share
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
deleteedit59Enabling the Attachments SidebarTo keep the size of your Qrimp application small, the attachments sidebar is not automatically visible on every table. If you would like to see attachments on the right in the [detail view] of each record, the table must be created with 'Attachments' enabled. If you do not see the attachments box to the right of your item, this option may not have been turned on. You can add it by following the instructions below.

<h2>Creating Tables with Attachments Sidebar Enabled</h2>
When you add a table, click the checkbox beside "Enable Attachments” in the Advanced options. (See [Add a Table]).

<img alt="Enable Attachments Checkbox" src="/attachments/105659f8-adf8-4c89-8658-69cfbd79a23a/Capture.PNG">

<h2>Enabling Attachments Sidebar for Existing Tables</h2>
If you created a table without the attachments sidebar capability (see above), you will have to add some code that will turn this feature on for a table.

First, go to the table you want to add the sidebar to. Then go to Develop > Header/Footer (see [Headers and Footers]). Copy and paste the following HTML into the footer section:

<textarea height="200px"><div id="attachmentsdata" class="relateddata"><h4><a href="db.aspx?t=attachments&tableid=1006&itemid=59" title="View All Attachments...">Attachments</a></h4></div><a href="uploadfile.aspx?t=1006&id=59&vid=11" id="Attachmentsadd" title="Upload Attachments...">add</a><script>showHtml("attachments&tableid=1006&itemid=59&vid=21&orderby=1,1","attachmentsdata");</script></textarea>

<em>Note: be sure to change the id number (tableid=1006 and t=1006) of the table to the id of your table. (See [automaticids]</em>		Attachments
deleteedit63Entering and Editing DataTo enter data, go to the menu tab for your table, which appears on the top or left of your window. Hover over the tab, click the add icon in the sub-menu.

To edit records from the grid view, click the edit icon <img src="/images/edit.gif" /> next to the row you would like to edit.

To edit items from the [detail view] click the Edit icon <img src="icons/crystal_project/32x32/apps/kate.png" /> in the [Content Header].

Clicking on this icon takes you to the [Edit View].		Working with Data
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
deleteedit24Error MessagesWhen you are working with your Qrimp app, you may encounter error messages. The error messages will appear in red and should tell you what to do to correct the problem, if possible. Many of these occur if you are entering data that is not the correct type, or if your data model is not correct.

Sometimes you will see a warning at the top if you have just deleted a record. This may sometimes persist to a new table as you are navigating. Usually these types of warning messages will disappear if you refresh your browser or if you continue using your app as normal.

We will attempt to document the most common errors and warnings in this section.

If you come across blank pages or unexplained errors, please [contact us] or submit a Feedback blurb with a detailed explanation of what happened.
deleteedit75Excel ExportYou can export your data as an excel spreadsheet. Just look below your table when it is in grid view. Click the excel link to export!

<img src="/attachments/9075d7d3-3be5-43b0-bffc-a982ce70a068/ExportCSV_XLS.png">		Export Options
deleteedit129Export OptionsUsers will see export options at the bottom of a table in the [grid view], provided they are in a user group (see: [User Groups]) with the appropriate permissions.

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

<img src="/attachments/9075d7d3-3be5-43b0-bffc-a982ce70a068/ExportCSV_XLS.png">		Working with Data
deleteedit7Field TemplatesField Templates wrap every field in your database. By editing the field template, you can control how any field in any table for any view is presented. You can create user messages, style your fields, make fields links and more.

<img class="border" src="attachments/developer.qrimp.com-847ce764-46bd-49be-bd30-5f3a0b75cad8/thingsfieldtemplatescanchange.png">
<span class="small">Some of the other things you can change with field templates</span>

Field templates can have <a href="http://developer.qrimp.com/HelpTopics/HTML">HTML</a>, [CSS] and [JavaScript] code in them. In these help documents, we will give you some basic code that you can copy and paste into your field templates to customize your fields.

<img class="border" src="attachments/developer.qrimp.com-8b9ed061-279f-4cc0-8b3d-155bda49382a/wherethefieldtemplatesare.png">
<span class="small">The default field appearances for the grid view</span>

This grid view has an extra icon that lets you click it to view the record.

<img class="border" src="/attachments/developer.qrimp.com-a21b9b71-27d2-4d38-8ed1-07563eea1948/changedtemplatesingridview.png">
<span class="small">The id field template has a second icon in it</span>

<h2>Changing a Template</h2>
Go to the table and view for which you want to change a field template. Go to Design > Design Mode On.

Click the gear icon at the top of the column you want to change.

Enter HTML in the field to alter the appearance of your field.

<h2>Add icons with links</h2>
<textarea><a href=db.aspx?t=HelpTopics&id=[DATA]&vid=2 id="edititem"><img align=absmiddle src=/c6401/630.png height=20 width=20 align=absmiddle border=0 alt="edit"></a><a href=db.aspx?t=HelpTopics&id=[DATA]&vid=11 id="viewitem"><img align=absmiddle src=/images/webexview.gif height=20 width=20 border=0 alt="edit"></a><a href="db.aspx?t=HelpTopics&id=[DATA]&vid=11" title="View Details">[DATA]</a></textarea>

In the HTML above, the following link was not part of the default template. Adding this creates a link to the [detail view], that is an image (an icon).
<textarea><a href=db.aspx?t=HelpTopics&id=[DATA]&vid=11 id="viewitem"><img align=absmiddle src=/images/webexview.gif height=20 width=20 border=0 alt="edit"></a>
</textarea>

<h2>Change the color of a link</h2>
<textarea><span style="color:red;font-weight:bold">[DATA]</span>

Put a <span> with the style you want around the [DATA] tag.
</textarea>

<h2>Make a field a radio button</h2>
<textarea>[radios:yesno:[DATA]:autoupdate] </textarea>

<h2>Make a field a select box</h2>
<textarea>[select:States:[DATA]:autoupdate]</textarea>		Display and Design
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
deleteedit69focuson Query String Parameter<nobreak><img src="/attachments/3ddae741-1e95-4629-8d44-879dbec2b8e1/focusonQueryString.png"><br/>

<p>When entering a url into the link section of a Menu tab, add a query string parameter called "focuson" with a value of the name of a field in your table to make the cursor appear in that field when the page loads.</p>

<h2>Example</h2>
<p>Your users would like to have the mouse cursor in the Name field when they load a Contacts form, so you add &focuson=name to the end of the query string on the menu that takes them there (see [Menus]).</p>
</nobreak>		Query String Parameters
deleteedit238Forgot PasswordIf a user forgets his or her password, it is easy for them to reset it. Go to the login screen (https://myapp.qrimp.net/login.aspx) and click the link that says "login help".

<img class="border" width="300px" src="/attachments/developer.qrimp.com-b32c1468-a08b-4365-96cd-0e222c2f46a8/login%20help%201.png">

Enter the email address the user logs in with, select "Send a link to reset my password" and hit Send. Qrimp will send an email with a link that lets the user reset their password. For security purposes we do not send the actual password.

<img class="border" width="300px" src="/attachments/developer.qrimp.com-b0f77d4f-fdfa-4bf5-a9d0-b265281b8c4b/login%20help%20change%20password.png">		Logging in
deleteedit244Forgot UsernameIf a user forgets or loses his or her username, it is easy to reset.

Go to the login screen (https://myapp.qrimp.net/login.aspx) and click the link that says "login help".

<img class="border" width="300px" src="/attachments/developer.qrimp.com-b32c1468-a08b-4365-96cd-0e222c2f46a8/login%20help%201.png">

Enter the email address the user logs in with, select "Send my username" and click Send.

<img class="border" width="300px" src="/attachments/developer.qrimp.com-b0f77d4f-fdfa-4bf5-a9d0-b265281b8c4b/login%20help%20change%20password.png">

The user will receive an email containing the login information and a link. When the user logs in, they will be prompted to change their password.

<img class="border" width="300px" src="/attachments/developer.qrimp.com-e0f05091-6258-4ec4-91d5-0ae428e6ed92/username%20email.png">		Logging in
deleteedit77Form DesignerThe Form Designer lets you change the position of your elements on the page. By default, each field is on a new line on the left of a form.

<img class="border" width="500px" src="attachments/developer.qrimp.com-e302d1e8-161a-455a-b6e1-32fe34eccf5b/defaultformlayout.png" />
<span class="small">By default, all fields line up on the left of a form</span>

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

<img class="border" width="500px" src="attachments/developer.qrimp.com-e1019979-f8bb-4c79-9264-dac8391fe672/redesignedformdetailview.png" />
<span class="small">Rearranged Form</span>

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

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

-----

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

Go to Design > Form Designer.

<img class="border" src="/attachments/developer.qrimp.com-1a5e836e-74ea-4627-b775-0f72431164a0/formdesigner.png">

Wait a moment while the form designer loads.

<img class="border" src="attachments/developer.qrimp.com-a66d7239-3beb-4b0c-8ee5-85a4d7d27094/preparingtoloadformdesigner.png" />

Your form fields will show up against a dotted background.

<img class="border" src="/attachments/developer.qrimp.com-ffc8a453-de84-4ddd-800d-f946fb5843d4/formdesignerdottedbg.png" />

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

<img class="border" src="attachments/developer.qrimp.com-aa25f462-9347-4539-8931-684a2f9334f8/clickanddragfield.png" />

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

<img class="border" src="attachments/developer.qrimp.com-29d49d8e-d8b4-46b1-89d4-872264382d15/redesignedform.png" />

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

<img class="border" width="450" src="attachments/developer.qrimp.com-c73fd12c-06ce-4d77-9d7b-069919f3ed7f/resetdefaults.png" />

<h2>Always Re-Design a Form when you add a new field!</h2>
When you add columns, new fields float to the top left. After adding a new field, use the form designer to place it where you want it.

<img class="border" src="attachments/developer.qrimp.com-69f36ad0-a0f8-4bba-a6fc-256fb73ea708/addcolumn.png" />

Display and Design
deleteedit1291Form Field LayoutWe have changed the name of the form field layout feature. Please see [Form Designer].Form Designer
deleteedit168Forums<!--Qrimp forums let you talk with other Qrimp users. The forums are also frequented by Qrimp Support. We get email alerts when new topics are posted. The forums are a great way to capture knowledge for all Qrimp users.
<a href="https://developer.qrimp.com/db.aspx?t=1001&o=27">
Visit the Qrimp Forums</a>.

<img src="/attachments/037713fb-f4d1-4296-9f0e-c701304d22cb/QrimpForum.png">-->
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.		Getting More Help
deleteedit171Getting More HelpIf 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.

<h2>Contextual Help within your Qrimp App</h2>
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]
deleteedit259Grid EditGrid edit is a [view] that makes data entry faster.

You also use the Grid Edit view to re-order columns in your [database table]. See [reordering columns].

In grid edit, you look at multiple rows in your table, and you can click each field to edit it from the table, without going into each record.

To get to grid edit, go to the table you want to edit and select the "Grid Edit" sub-menu tab.

<img class="border" src="attachments/developer.qrimp.com-ce4f3be9-1b73-45e0-86e6-1a0614eb76d6/grideditmenu.png" />
--------
Click the field you want to edit. Edit your data. Click save when you are finished.

<img class="border" src="attachments/developer.qrimp.com-e705a79e-1bc2-437d-9cfe-595d4d2936df/gridediting.png" />

<h2>Advanced: Grid Edit Query String</h2>
Enter &_showeditgrid=true" in your query string to get a grid view for any table. (See [query strings]).		Entering and Editing Data
deleteedit46Grid ViewThe "grid view" or "list view" is a view of a [database table] formatted as a table. By default, a grid view shows you all of the rows and columns in a table. It is represented with this icon <img align="absmiddle" alt="List View" src="/icons/crystal_project/32x32/actions/view_text.png">.

You can usually get to the grid view by going to the menu tab and clicking the "grid view" sub-menu tab.

<img width="600" class="border" src="/attachments/developer.qrimp.com-f85a60de-50b6-40c5-9930-5a1cefe62109/defaultview.png">

By default, most views of your data have a link to the grid view in the [Content Header] above your data.

Click the id link or double click a row to view the record. Click the edit icon to edit.

<h2>Deleting and editing rows in grid view:</h2>
Next to the id field in most tables you will see two icons, a delete icon <img src="images/delete.gif" alt="delete icon"/> and an edit icon <img src="/images/edit.gif" alt="edit icon"/>.

Clicking the delete icon allows you to delete the row from the data table (it warns you if you want to delete first).

Clicking the edit icon allows you to change data in that row.

<img src="/attachments/4ec6c6cc-f65f-4668-bdc6-5837864d83d1/GridView1.png">

To add additional icons to your id columns, use [Field Templates].

Views
deleteedit79Group Menu VisibilityGroup Menu Visibility sets the visibility of [Menus] by [User Groups].

<h2>Quick Group Menu Visibility</h2>
To change visibility of all menu tabs for a group go to Develop > Manage Menus. Click the button at the top that says "menu item visibility".

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

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

<img class="border" src="/attachments/developer.qrimp.com-6eab9eac-92a4-42e9-9ead-6f5fc638e135/quickgroupmenuvisibillity.png" />

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

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

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

<img class="border" src="/attachments/2b035c93-a495-42cf-a39c-a12e54b21392/GroupVisibility.png">

Use the checkboxes to toggle visibility on or off.
<img class="border" src="/attachments/dc8623d3-7ee4-474d-8202-137f08a4f40f/2008-12-14groupmenuvis.png" />

<h2>Hidden, but not necessarily inaccessible</h2>
Note that Group Menu Security does not limit your users from accessing your tables. Hidden menu tabs can still be accessed if a user types in the /db.aspx to a table. For complete security set up [Table Security].		Menus
deleteedit23Headers and FootersIn Qrimp, the area above your tables is the "Header" and the area to the right is the "[Footer]". The Header is also known as the "[Content Header]" (#contentheader in [CSS]).

<h2>Default Headers and Footers</h2>
Each table has a default header, in most cases containing the [Action icons] that allow you to change [Views], see [Reports], add new items, edit, etc. Each of the default <a href="db.aspx?t=1006&id=176&vid=11">views</a> has its own Header showing icons relevant to that view. For example, if you are in already edit view, you will not see the edit icon in the header. Headers are also a great place to put a custom messages to your users, rss feeds, shopping carts, images, shared data or even [Custom CSS] specific to that item and view.

The default footer usually contains [Related Data], [Attachments] , related tables, or custom messages to users.

<h2>Changing Headers and Footers</h2>
To change the header or footer, go to the table and the view you are changing it for. Then go to Develop > Header/Footer.

<img src="/attachments/3b12cead-6669-46a6-83b7-00ac5329fb79/Heade_Footer.jpg"/>

If a custom header or footer exists for that table and view, you will see it in the list.

<img class="border" src="attachments/c3500bae-f1ad-4b79-8b4e-786752c82cb9/HeaderFooterHelp2.JPG" />

Click the small edit icon <img src="/images/edit.gif" />to open the header/footer for editing.

You will see a text box for the HTML for your Header and a separate text box with the HTML for your footer.

Change the HTML to create your custom message. Save a copy of the working Header or Footer HTML for reference while you are working. [Versioning] is enabled by default for all header/footer tables. To view previous versions of your header/footer, click the [Versioning] icon <img src="/icons/crystal_project/32x32/mimetypes/file_temporary.png"> once you have saved the custom header/footer.

<img class="border" src="attachments/d62d2971-740c-4fdc-beb5-a1b40859ae4a/HeaderFooterHelp3.JPG" />		Above and beside your data
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing