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
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
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
deleteedit1315Manually Subscribing Users to PortalsYou can 'subscribe' to existing portals.

Go to Design > Portals. You will see a list of Portals. Click the name of the portal you want to subscribe to. On the right, click the top link that says "Portal Subscriptions".

Click the names of the users who should see that portal on their [Dashboard].		Dashboard
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)
deleteedit1313Add a Menu LinkMenu links to your tables and to other areas of your app such as [Dashboard] and Admin, Develop and Design (if a user is permitted).

To add a menu tab, go to Develop > Manage Menus then click the Create Menu Item button.

Enter the following information:

Name: The word that will appear in the Menu Tab.

Link template: Enter the url that you would like users to land on when they click the tab. It is easiest to navigate to the data and the view (see Views) first, then copy/paste that url.

Parent Menu: Choose a top level menu tab to show your menu in a sub-menu below it.

Description (Optional): Enter a description.

Icon (Optional): Click the edit link and choose an icon.

Security: Select which groups can see the menu tab (See also [Group Menu Visibility]).
Menus
deleteedit1311PayPal Order IPN ModuleHelp Topic coming soon.Modules
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
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
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
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
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
deleteedit1302Creating your own error messagesQrimp has several default error messages for when things go wrong. The Qrimp stylesheet also has a class called "error" which is red text by default. You can change this to make it more or less obvious.

<h3>Adding Error Messages</h3>
If you have added custom [JavaScript] or other functionality, you may wish to add your own error messages. To do this go Admin > Error Messages and fill out the required fields.		Javascript and JQuery in Qrimp
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)
deleteedit1300Add a User Group<span class="error"><em>Caution: If you add a user group, they will need permissions added manually to all tables and menus. They may also need permissions added to many [system tables] - portals (to see portals), queries, t_group_query, views etc. If any of this is done wrong, the user will not see things they should see.</em></span>

To add a new user group go to Admin > Manage Users.

Click the link on the top of the page that says "Manage Security Groups".

<img class="border" src="attachments/developer.qrimp.com-8b442862-ce60-4548-813d-75777ddc0543/managesecuritygroups.png" />

----

Click the "Add New" button to add a new security group.

To edit the settings for an existing security group, click the edit icon.

<img class="border" src="attachments/developer.qrimp.com-a46644f2-09a1-41a5-942e-3fd91e1c5d51/usergroupsettingeditusergrouporaddnew.png" />		User Groups
deleteedit1299I created a new field but my users can't see itSee [Column Level Security].Adding Columns
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
deleteedit1297BillingCover topics related to paying for your Qrimp account and Services
deleteedit1296How Qrimp Handles DatesQrimp only has a date/time field. It does not have a time field. If you need to enter a time, you must do so in the date/time field, like so: 4/17/2003 10:30 AM. (See [datatypes]). If you want to have an event occur the same time every day, without setting the day, you can use the recurring feature of the calendar.

All dates and times are stored in the database in Universal Time Code (UTC). If you enter a time with your date, it's converted to UTC before the value is persisted (stored in the database).

<img class="border" src="attachments/developer.qrimp.com-369f30c4-7b58-4a8b-bb96-ce5ac1a09557/starttimeendtime.png" />
<span class="small">Entering dates and times together into Qrimp's date/time field.</span>

If you enter a time with the date, Qrimp stores the time AND the date in that field.

If you enter only a date, Qrimp will store the time as midnight. If you don't enter a time, time zone conversion is not performed on the date/time value in queries. If you just enter 4/17/2003 without a time, it will store it as 4/17/2003 00:00:00.

Dates without 00:00:00 are not converted using [Time Zone Awareness].

If you do enter a time when you do your data entry, the date/time is converted into the user's time zone before being compared to any query parameters.

This is only true of the search engine, query string parameters and the custom view builder. If you write a custom query using the query builder, you may need to accommodate the time zone yourself (depending on the query).

We have a square brackets value called <noeval>-5</noeval>.
Time Zone Awareness
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
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
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
deleteedit1292Radio ButtonA radio button is an interface input to a [datatype] that has two options. It shows up as two small circles. When one option is selected, a dot appears in the selected circle.

<label class="datalabel move" for="Canceled">Canceled:</label>
<span class="radiobtn" style="white-space: nowrap;"><input name="Canceled" tabindex="8" id="CanceledN" type="radio" value="N"><label for="CanceledN">No </label></span><span class="radiobtn" style="white-space: nowrap;"><input name="Canceled" tabindex="7" id="CanceledY" type="radio" value="Y"><label for="CanceledY">Yes </label></span>

You can enter radios into [field templates] using [square brackets].

[radios:yesno:[DATA]:autoupdate]		Definitions
deleteedit1291Form Field LayoutWe have changed the name of the form field layout feature. Please see [Form Designer].Form Designer
deleteedit1290Configuring Imported TablesIf your system was created from imported data, here are a few things you may wish to do:

<a href="db.aspx?t=HelpTopics&id=213&vid=11">Re-order columns</a>

Change your [Table Security]

<a href="db.aspx?t=HelpTopics&id=256&vid=11">Add a Calendar List to your Dashboard</a>

[Change your skin]

<a href="db.aspx?t=HelpTopics&id=180&vid=11">Change your logo</a>

<a href="db.aspx?t=HelpTopics&id=247&vid=11">Set up Custom Views (Filtered and Sorted Reports of your data)</a>
[Edit an Existing Custom View]

[Convert a Field to a drop-down]
[Add a drop-down Field]
[Hide Inactive Fields from drop-downs]
<a href="db.aspx?t=helptopics&id=265&vid=11">Change a field to a drop-down</a> Make sure you have clean data first! Try out [grid edit] and sort by the field you want to convert to a drop-down.

Working with Data
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
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing