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
deleteedit80Add A Sub-Menu TabYou can create a Sub-tab that links to any area of your site - from an individual record, to a table in [Grid View].

1. Go to the table, view, and item (if applicable) that you want to link to.

2. Go to [Develop] or any Menu Tab and at the bottom is "+ add submenu. (As seen below)

<img src="attachments/688755d9-43d3-4673-9a8c-5a70bc0f9835/AddSubMenu.jpg">


After you add the menu, you will see a message appear saying the menu has been added. The name of the menu, in this message, is a link to a page that will let you modify additional properties of the menu. Click the link to do the following:

<strong>Choose an icon</strong>
To choose an icon to represent your link (optional), click the "pick icon" link. Browse through the icon pages and when you see an icon you like, click on it. The icon will appear in the tab, to the left of the tab name.

<strong>Change Permissions</strong>
You can change permissions on new menus after they are created. If you do not change permissions, only members of your group can see it. For example, if you are logged in as an administrator, only administrators will be able to see the menu. If you'd like members of other groups to see the menu, click the Group Menu Visibility link in the right hand rail to add more groups to the list of those who can see it.		Menus
deleteedit145Ad hoc queriesYou can create your own queries using the <img src="/icons/crystal_project/32x32/apps/kexi.png" align=absmiddle height=16 width=16 /> Query Designer under the Develop menu.

<img src="attachments/d6d7df44-aee7-45a6-afdc-65b37f5bb980/AdHocQuery.jpg">


<h4>Querying Data</h4>To quickly show the SQL Statement for a particular table, select the table name in the drop down and click the show sql link. This selected table will be used for the templates for the data that is returned. Click Run Query to show the results.

<img src="attachments/65621552-9ab3-4361-90f0-4065980f7a04/RunQuery.png">

<h4>Saving Queries</h4>You can save your queries for use later. Specify the query to use by adding a &qid= parameter to the end of your querystring using the ID or the Name of the query you save. To keep your data secure, you must assign permissions to the query by group. When you first click the Save Query link, you will be presented with a list of Groups who you want to allow to view the Query Results. Click the view queries link to view, delete or modify existing queries.

<img src="attachments/83e48c3f-9210-4fa6-82ed-b30966c60eeb/SavingQuery.png">

<h4>Updating Data</h4>The Query Designer will let you write ad hoc SQL statements against your database. You can run any statement you like, but we suggest using only SELECT statements to prevent damage to your database. If you are going to run statements to update your data, you should do a backup first, which is covered in [Backing up your data].
Data Analysis
deleteedit84Column Level SecurityYou can determine which [User Groups] have permission to see every field in every table. If you have recently added a field, you will need to set column security for your users to be able to see the new field.

First, you may wish to check that they have permission to see that table by checking the [Table Security].

To change column visibility, go to the table you want to change security for, then go to Admin > Manage Tables.

Find your table then click the link below it that says "column security".

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

You will see a table listing all of your groups on the left hand side with the names of the columns along the top.

If there is a check mark at the intersection of the two fields, that user group can see that column.

<img class="border" src="/attachments/9b777dc0-271f-4eeb-9500-3f16d11b4821/ColumLevelSecurity1.png">		Security
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
deleteedit76XML ExportYou can export your data tables in XML format. Go to the grid view of your data table. Below your table you will see Qrimp export options. Click on the XML link. You will see the document tree of your page in XML format. You can then copy and paste the XML and do whatever you please with it.Export Options
deleteedit189Number FormatsYou can format numbers using square brackets like this:

<textarea>
</noeval>

If you'd like to format 123456 like 123,456 you would use the following code:

<noeval>[formatnumber:<number>[DATA]</number><format>{0:#,###.##}</format>]

</textarea>

Some formats you can use include those listed at the Microsoft Developer Network: <a href="http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx">http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx</a>		Square Brackets
deleteedit1289Hiding columns with CSSYou can hide columns for a view of a record or table using CSS.

Go to Develop > Header/Footer. In the header field, add the following style to hide the id, createid, and createdate fields. CSS is not supposed to be case sensitive, but just in case of browser bugs, make sure your div names are identical to the div in the HTML.

<input type=text size=100 value="<style>#iddiv,#createdatediv,#createiddiv{display:none}</style>">

Notice that each field name is followed by the word div. So to hide another field named StartDate, you'd use this:

<input type=text size=100 value="<style>#StartDatediv{display:none}</style>">

To do the same for Grid/Table views use this style definition in the header:
<input type=text size=100 value="<style>.id,.createdate,.createid{display:none}</style>">		Headers and Footers
deleteedit1294Hiding fieldsYou can hide fields from ever appearing in the [grid view].

In this example, we are going to hide the 'email' field from the Clients table.

Go to your table.

Go to Design > Form Designer

Click the link on the right that says "Edit Column Labels"

<img class="border" src="attachments/developer.qrimp.com-a99ef66a-5c09-4205-b09c-6f8bdaf42fb1/editcolumnlabelsbutton.png" />

Wait for the Grid Edit view to load.
<img class="border" src="/attachments/developer.qrimp.com-b6e4be8d-660e-416f-ac43-b3839862dc3f/gridedit.png" />

Click HideinColumn for field you want to hide.
<img class="border" src="attachments/developer.qrimp.com-5595a57b-0aef-4c3d-be49-f630fff69e9a/clickthehideintablefield.png" />

Change the field to say "Y" or "yes" to hide it.

<img class="border" src="attachments/developer.qrimp.com-4d99e679-3a53-4f7a-ace2-651fb3203c01/makeitso.png" />
Grid View
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
deleteedit137AttachmentsYou can upload nearly any type of file as an attachment to your Qrimp app including Word, Excel, PDF, .jpeg, .mp3, .mpeg and other file types.

Each attachment is uploaded to a record in one of your tables.

<h2>Viewing Attachments</h2>
If attachments to a record exist, you will see a thumbnail or a link to the attachment in the right hand side of the [detail view] of the record. Images will be displayed as thumbnails. Other documents show an icon that represents the type of document you have uploaded. You will see thumbnails for up to six documents.
<img src="/attachments/3a94e630-8601-4710-8313-483ed15552c3/attachmentthumbs.PNG">

To open the attachment, click the link or thumbnail. To change what happens when you open an attachment using [Attachment Viewers].

To view all of the attachments to all records in a table, click the attachments link above the thumbnails. You will be redirected to the Attachments table. From there you can sort by columns or use the search function to limit the results.

<h2>Adding an Attachment</h2>
To add an attachment, go to the [detail view] of the record you want to attach the item to. Then click the "add" link below Attachments in the right-hand column.

Select your file or files and click the upload button. Once you have uploaded your file(s), they will be attached to the item, and will appear in the right-hand column in the [detail view].

<img src="/attachments/c2edc05c-7776-4b97-b65f-52aba415bde8/Attachments.png">		Working with Data
deleteedit1274Custom CSSYou can use [CSS] to style any part of your Qrimp app. If you only want the style to be applicable to a particular page, table or view, you can write the CSS in a style tag in [views] or [headers and footers].Changing the Look and Feel of Your App
deleteedit106Using SQL StatementsYou can use custom SQL statements get information about your existing tables and to manipulate your data.

The query builder is in Beta Mode. You can use it to generate your own custom queries for your database to return very specific resultsets or even execute UPDATE, INSERT, or DELETE statements, but of course be careful with these.

If you select a table from the query list and click "show sql," a select statement will appear. Click Run Query to return results.

You can save your queries also. If you have selected a table, then save a query, a link will appear to the right of the query list that you can click on to view the results in your browser and save a menu that will display these results for you. You can also use these results in Portals.		Data Analysis
deleteedit112Using Operations in urlsYou can use operations in urls when you are creating [Menus] tabs, adding internal links, editing the action that is behind an [action icon] link or in any other internal Qrimp app links. An operation goes to the table in the url and performs a certain action on it.

<strong>Composing the URL</strong>
To use an operation in a link, simply add "&o=" plus the operation number to the url. An example of a url with an operation restriction would be:

<strong>http://myapp.qrimp.com/db.aspx?t=Clients&id=82&o=4</strong>.

When the user clicks this link, they will delete record 82 from the clients table.

<h2>Operation Permissions</h2>
If you create a link using an operation, and the user who can see it does not have permission to perform the operation, they will see the login screen and the error message "you do not have permission to _read__ the _Clients___ table". To give your user permission, you must set up the correct [Table Security].		Operations
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
deleteedit1309Name input maximum is 50, but 64 characters were submittedYou will get this error or something similar to it if you are trying to enter data that is longer than the amount of characters specified in the [datatype] for that [database table].

To fix this error, go back and enter shorter data, or if you are an admin, you can extend the length of the field using [Table Management].		Error Messages
deleteedit215DashboardYour dashboard is a collection of portals that you subscribe to. Dashboards make great home pages, as they give you an overview of what is happening in your app and/or your company.

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

<img class="border" width="600px" src="attachments/developer.qrimp.com-14857d23-63f4-4b4c-a3fd-a6a9f85a0a7d/calendarlistportalamongothers.png" />		Navigation
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing