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
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="http://www.Qrimp.com/contact.html">contact us</a> if you are interested in this feature.

Square Brackets
deleteedit1288Copy a RecordIf you are entering new records that have very similar data to existing records, you can start from a copy of an existing record.

To copy a record, first go to the [edit view] of that record.

Click the "Copy" button at the bottom of the record. You will be taking to the [detail view] of your new record, and will need to click the edit icon again to enter the new data.

<img class="border" width="550px" src="attachments/developer.qrimp.com-109d412c-2d4f-40ac-82c9-bdd1d76762fb/copyarecord.png" />

Be careful here and proceed slowly to make sure that you enter new data in the copied record, and do not overwrite the original record. Look at the [location bar] of your browser and check that the record has a higher id number than the original. (See [AutomaticIDs]).

<img class="border" width="550px" src="attachments/developer.qrimp.com-06f38e6d-023f-44a5-ace5-f00b780cd058/copiedrecord.png" />		Add a Record
deleteedit213Reordering columnsTo 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.

<img class="border" src="attachments/developer.qrimp.com-1cd04005-3933-4475-8b37-998704321f50/grideditreorder.png" />		Grid View
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
deleteedit1305The item has been deleted.This error appears when an item is deleted.

<img src="attachments/developer.qrimp.com-8944c5d8-3d75-4717-973d-801417172079/theitemhasbeendeleted.png" />

To continue using your app, just click any button and then navigate back to what you were doing.		Error Messages
deleteedit1306You entered a value that was not the correct type.If you are doing data entry, you may get this error if the data in one of your records does not match the [datatype] for that field.

If you are entering a number (with or without decimals) please don't enter commas.

You will also get this error if you are in a custom view ([Custom Views (Sorting and Filtering)], but do not have the id column included in the view, and you attempt to click through a link to a record.		Error Messages
deleteedit1308You have not included NumCurrentUsers in your column list above.Occurs in [Custom View (Sorting and Filtering)].

If you are trying to add totals or subtotals, you must first add a column to your view.

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
deleteedit1310Conversion failed when converting the varchar value 'Active' to data type intIf you get a conversion failed error, it is a problem with the [datatype]. If you are trying to create a view or other numerical calculation with the = operator symbol please change the = to contains.Error Messages
deleteedit1317You must enter a value for itemtemplate. Please click your browser's back button and enter somethingOnce you edit a field template, you can no longer leave it blank.

If you try to leave it blank, you will get this error message:

"You must enter a value for itemtemplate. Please click your browser's back button and enter something for itemtemplate."

If you really want to leave the template blank, you can enter an empty <noeval>[HTML]</noeval> tag, such as
<textarea><a></a></textarea>		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
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
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
deleteedit111Writing OperationsWriting operations in Qrimp is similar to writing stored procedures. You can use existing operations as templates to build your new operations. To view existing operations go to Admin > Operations.

You can use wildcards with % around a word that you want to restrict your query on. ie: like '%overdue%'.		Operations
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
deleteedit133Computed Column<nobreak>
<h2>What is a Computed Column?</h2>
A Computed Column is a [datatype] that allows you to calculate mathematical equations using numerical data from other columns in your table, concatenate strings from other fields or add and subtract dates.

For example, if you had a Products table with columns for price and tax rate, you could calculate price + tax. Computed columns allow you to take full advantage of Microsoft SQL Server 2005 Transact-SQL functions. You can read more about T-SQL functions at the <a href="http://technet.microsoft.com/en-us/library/ms174318.aspx">MSDN Library</a>.

<h2>Adding a Computed Column</h2>
You can only add a computed column after a table has been created. Go to your table, then go to Develop > Table Management. Enter a new column name under Add a column, and select computed column as the datatype.

<h2>Examples</h2>
<h3>Calculations with Numbers</h3>
Formulas with numbers are the same as we learned in school. To calculate Profit in a table with a Unit Price and a List Price, we enter a new column called Profit and in the formula box, enter "UnitPrice-ListPrice".

<img class="border" src="/attachments/3b54339c-9f76-4f4c-b450-20a081b29b12/ComputedColumn1.png">

<h3>Column with Dates</h3>
In this example, we calculate the number of days between two dates in our table. For more information about formulas you can use on dates, see the <a href="http://technet.microsoft.com/en-us/library/ms186724.aspx">Date and Time Functions</a> entry.

<img class="border" src="/attachments/eea0d7ea-4344-4c01-941c-a0c31c54c028/NewComputedColumn.png">

<h3>Concatenating Fields</h3>
Concatenation is putting two strings together into one string. To add a concatenated field, use the + sign. To make a full name from a first and last name, enter a new column called FullName and in the formula box enter "Lastname + ', ' + Firstname".

<a href="http://technet.microsoft.com/en-us/library/ms181984.aspx">Click here to read more about T-SQL String Functions</a>.
</nobreak>		Adding Columns
deleteedit1268Add an Active/Inactive Field<h2>Creating an Active (y/n) Field on an Existing Table</h2>
You may want to mark certain fields inactive. For example, you may have clients that you no longer work with.

Go to the Clients table > click the Table Management sub-menu, or go to table management, find your table in the list and click edit. Add a column called "Active" and make the datatype a yes/no. Click "Add Column". (See [Adding Columns]).

<img class="border" src="attachments/developer.qrimp.com-8d08eab0-68a2-4801-902c-caf536017d54/activeyesno.png" />

Use the [Form Designer] to arrange the new field.

<img class="border" width="600" src="attachments/developer.qrimp.com-45b68ac7-85c7-4771-a2bc-394b36726725/addcolumn.png" />

Update your clients and mark them Active yes or no. [Grid Edit] makes this faster.
<img class="border" src="attachments/developer.qrimp.com-2794f56f-b832-4795-a241-6db680a32290/activeyngridview.png" />

You may also wish to [Hide Inactive Fields from Drop-Downs]		Adding Columns
deleteedit1299I created a new field but my users can't see itSee [Column Level Security].Adding Columns
deleteedit107Creating a Look-up TableA look-up table lets you select data from a drop-down list in any one of your tables. Like this:
<img class="border" src="/attachments/96528c8f-71d0-4a7f-aa82-9cdb855b19d1/ClientDropDown.png">

To let the system know which table you want to pick from, you have to create a look-up table.

<h2>Adding a look-up table with Import Data</h2>
If you are adding a look-up table with a lot of records, [Import data] is the fastest way to create it.

Go to Develop > Import Data.

<img class="border" src="/attachments/ef4d0248-5e5a-4b93-97ca-c283b88af827/importdata.png"

Enter a Table Name.

<img class="border" src="/attachments/6d8a61f7-366c-42f6-99c0-4746a9ea6680/EnterTableName.png">

Check the checkbox beside "First row contains field names".

In the box below, enter:

Clients
XYZ Company
ABC Inc
JKL Manufacturing
etc....

Then click "Import Data!". Leave the advanced features
unchecked for look-up tables.
<img class="border" src="/attachments/55744fd5-fa15-4c4f-ba22-0b4b094d2473/LookupTableCreation.png">

<img class="border" src="/attachments/535691ad-592b-4fad-9114-99e157a53c8e/Lookup4.jpg">

See also [Convert a Field to a Drop-Down] and [Adding a Drop-Down Field]		Add a Table
deleteedit17Notification SubscriptionsSend site administrators and users custom [Notifications] when new data is added to your Qrimp application or when people sign in.Notification Subscriptions
deleteedit154Tutorial - Email NotificationsIn this tutorial, you'll see how to add a notification so you can be alerted by email when changes are made to information in your Qrimp App. We also briefly jump into some table management to make a field a bit bigger. We'll also customize the notification template so that we see only information that meets certain criteria.

<object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="1026" height="786" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/2008-07-05_0124.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-07-05_0124.swf" width="1026" height="786" 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>
Notification Subscriptions
deleteedit232Notification ParametersAfter you have subscribed a user to a notification (See: [Notification Subscriptions] [Notifications and Custom Notifications]), you can set notifications to be sent only when certain parameters are met. For example, you can send a notification to your sales rep Evelyn only when the order type is wholesale.

To set up a filtered notification, go to Admin > Notification Subscriptions and select the notification to filter.
<img class="border" src="/attachments/developer.qrimp.com-65b33786-c4ea-4bff-b3c0-98456fe4b17b/notifications subscriptions menu.png" />

Click the link on the far right that says 'Set Parameters'.
<img class="border" src="/attachments/developer.qrimp.com-bb13bf70-368a-4459-afb4-bcea6282eed4/notification subscription to filter.png" />

Now you are on the Notification Parameters page. At the top, you will see the notification you are setting up.
<img class="border" src="/attachments/developer.qrimp.com-d7159eda-767e-4f6a-936d-8288e408f9d2/notification to filter.png" />

If any previous filters have been set, you will see them under "Current Parameters".
<img class="border" src="/attachments/developer.qrimp.com-80fd93fb-7661-492e-b3f3-4ec7c4f0ee73/notifications current parameters.png" />

Select your parameters, then click "Save".
<img class="border" src="/attachments/developer.qrimp.com-911170fe-430e-44fc-8a21-5e58d6b65720/notifications set parameters.png" />

From now on, when a new Wholesale Order comes in, Evelyn will get an email about it. The email will look like this:

<img class="border" src="/attachments/developer.qrimp.com-f67575af-e944-48fc-93f4-be61bc05b119/notification parameters email.PNG" />

Note: Evelyn will no longer get an email for <em>every</em> order, only New Orders that are Wholesale. If you would like her to also get an email for every order, you must create a new, separate notification subscription.

You can change what the email notification says and what it looks like with [Notification Templates].





Notification Subscriptions
deleteedit234Notification Templates<!--<nobreak>-->
<p>Notification Templates determine the text, images, links and design elements that are in notifications.</p>

<h2>Existing Templates</h2>
<p>Qrimp comes with the following default notification templates: UPDATE, CREATEACCOUNT, APPROVEACCOUNT, PASSWORDRESET, LOGIN, NEWMAIL, ACCOUNTREQUEST, New Suggestion, and New Comment On Suggestion. Use these default templates as the basis for your notifications. You can Copy these to create your own notifications. This will give you a head start on the content that can be displayed. You can also add new templates and start from scratch. </p>

<h3>Update</h3>
<p>Update is by far the most frequently used notification template. This basic template can be used to inform users that new records have been added to tables in your database. </p>

<h2>What's in a Template?</h2>

<h3>Square Brackets</h3>
<p>Notification templates rely heavily on [Square Brackets] to pull information from your database to the email in an automated fashion. Using [Square Brackets] you can show a user the name of the app in the email, which table and item was affected, which user made a change, the date the change was made, and more. Start with the default notification templates and copy/paste pieces of square brackets notation into your notifications.</p>

<img class="border" src="/attachments/developer.qrimp.com-492da2f8-7ce0-44c4-bd44-68b7c0a2422b/notification%20template%20template.png">

<h3>CSS and HTML</h3>
<p>Users familiar with CSS can also include the "<'style'>" tag to put design elements in the notification, such as fonts, colors, borders, backgrounds and more. Depending on the user's email client, the styles may show up differently. If a recipient shows text-only emails, these design settings may not make it through.</p>
<!--</nobreak>-->		Notification Subscriptions
deleteedit72Drop a ColumnTo drop a column, first make sure that you are viewing the table that you want to drop the column from.

Next, go to Develop > Table Management. You will see a list of your tables with several options below each. Click the 'edit' option. You will see a form showing the fields in your table, with an options column on the right. Under the options column click the 'delete' link in the row for the column you wish to drop. You will be prompted before you can delete the column.

Be careful! Deleting a column will delete any data that you have entered into the table!		Manage Tables
deleteedit124Table SettingsEverything in your Qrimp app is stored in a table, even information about tables. The Table Settings view allows you to modify information about those tables, including which field to use to represent information in the table and which HTML View Template to use as the default if no view is specified.

<div class=warning>Renaming tables with the rename link can cause trouble if anything else in the app or on the internet links to the table. Try updating just the name in the name box or the Title of the table first.</div>		Manage Tables
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing