Tree View
Tree
List View
Alphabetical List
Share
Share
Search:
id:
1296

name:

How Qrimp Handles Dates



description:
Qrimp 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).


Entering dates and times together into Qrimp's date/time field.

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 [UTC_OFFSET].


ParentTopic:
 

id:
1297

name:

Billing



description:
Cover topics related to paying for your Qrimp account and Services


ParentTopic:
 

id:
1298

name:

Hourly Services



description:
Qrimp 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.


ParentTopic:
 

id:
1299

name:

I created a new field but my users can't see it



description:


ParentTopic:
 

id:
1300

name:

Add a User Group



description:
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.

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".



----

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

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



ParentTopic:
 

id:
1301

name:

Links from my Views give me an error



description:
If 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.


ParentTopic:
 

id:
1302

name:

Creating your own error messages



description:
Qrimp 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.

Adding Error Messages


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.


ParentTopic:
 

id:
1305

name:

The item has been deleted.



description:
This error appears when an item is deleted.



To continue using your app, just click any button and then navigate back to what you were doing.


ParentTopic:
 

id:
1306

name:

You entered a value that was not the correct type.



description:
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.


ParentTopic:
 

id:
1308

name:

You have not included NumCurrentUsers in your column list above.



description:
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.



ParentTopic:
 

id:
1309

name:

Name input maximum is 50, but 64 characters were submitted



description:
You 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.


ParentTopic:
 

id:
1310

name:

Conversion failed when converting the varchar value 'Active' to data type int



description:
If 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.


ParentTopic:
 

id:
1311

name:

PayPal Order IPN Module



description:
Help Topic coming soon.


ParentTopic:
 

id:
1313

name:

Add a Menu Link



description:
Menu 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).


ParentTopic:
 

id:
1314

name:

Default View on the Custom View Builder



description:
The 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.


ParentTopic:
 

id:
1315

name:

Manually Subscribing Users to Portals



description:
You 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.


ParentTopic:
 

id:
1316

name:

Edit a Menu Tab



description:
You 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 url to your clipboard.


-------

Now, go to Develop > Manage Menus.


----

Click "Edit Menu Item".


----

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



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


----

Now, try clicking on the menu tab to make sure it worked.


ParentTopic:
 

id:
1317

name:

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



description:
Once 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 [HTML] tag, such as


ParentTopic:
 

id:
1318

name:

How to reset a user's password



description:
Preface: 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 Help Topic #238: Forgot Password for more info.

You can also send them a new temporary password by reapproving their account.
  1. Go to Admin > Manage Users
  2. Click the table view icon
  3. Click the username in the Username field of the table view, the left most name in default Qrimp setups.
  4. You will now be looking at the approve user account.
  5. Verify the correct user group
  6. 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 Users aren't receiving their temporary password email


ParentTopic:
 

id:
1319

name:

Table Management



description:
Develop > 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.


ParentTopic:
 

go to page: 1 2 3 4 5 6 7 8 9 10 11 12 13 243 records. Showing