To rename a table, navigate to your table, then go to Develop > Manage Tables > Find your Table in the list.

Below the name field, there is a link "rename table". Click on it. Choose a new name for your table and click save.

Caution: Default sub-menus will be renamed to the name of the new table

Rarely, but sometimes, renaming tables can be problematic if you have other tables or data in your application that refers to the table you want to rename.

You can add a link to the footer (#rightcontent) of a table that makes it easy to create a new related item (in a different table). One example of related data is the "add attachments" link that you see in almost every table.

In this example, let's say we wanted to be able to quickly look at Poll Numbers associated with that particular candidate. To do this, we'll add a link in the footer of the table.

Advanced

You can edit a url (link) to either show or hide columns in a table.

You can use the hide or select parameters to edit the url in your location bar and change the data that is displayed when you re-load your page.

You can also paste links to modified query strings into Menus, the Content Header, Field Templates and Views.

Hidecolumns

Hidecolumns hides the columns you specify. If you are looking at a table and it is too long, and you don't want to add custom views (sorting and filtering), you can quickly edit the url to hide a few of these columns, but every time you refresh the page, you will have to re-hide them.

To hide a columns edit the url as follows:
"https://myapp.qrimp.net/db.aspx?t=mytablename&vid=11&hidecolumns=id,description,priorityid,partnershipagreement"

If you want to save this link as a menu tab, copy it from your location bar and type it into the linktemplate field of your menu tab (See edit a menu tab).

Note: Hidecolumns retrieves all of the columns from the database and pulls them into your browser, then hides them from view. For this reason, hidecolumns uses more bandwidth than selectcolumns.

Selectcolumns

You can retrieve and display only the particular columns you select using "selectcolumns" in your query string (url). A selectcolumns query is written as follows:
"db.aspx?t=tasklist&selectcolumns=name,duedate,priorityid"

Because showing columns only pulls back the selected columns, it uses less bandwidth than hiding columns.

Every Qrimp app comes with a set of icons built in. To view all of the icons included with your Qrimp app go to Design > Icons List.

Changing your default IconTheme
Each user can choose which icon size they wish to use in their Content Header when they are logged in. You can choose 16x16 icons or 32x32 icons.

To change a user's icon settings, go to Admin > System Tables. Find the t_settings table. You will see a list with all of your users in the userid column and their chosen icon style in the icontheme column. Click on edit icon in the row that contains the record you would like to change.



When you are in Edit View, go to the icontheme field and change the display size from 16x16 to 32x32 or vice versa.



Using Your Custom Icons
Qrimp plans to allow you to add your own icon set if you wish. At the present time, this is only possible if you choose the same naming convention for your iconset as is used for the crystal project icons (names must include folders in url).

If Qrimp has 1000 icons in one set and 100 in another, and you set an icon to point to one of the 900 we don't have and change the icon theme, then they'll be broken images.

Using the Default IconTheme in your urls
When you are writing a url and want to link to an image automagically, you can use square brackets around the word icontheme to create a link to it in a url. Qrimp will automatically display whichever icon theme you have chosen. For example, /icons/crystal_project/32x32 will insert /icons/crystal_project/32x32. You must be sure to write the folder location for the urls correctly. Follow this example: /icons/crystal_project/32x32/actions/1day.png

To 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!

The following is a list of special words that are used in the code and cannot be used as the name of a table or column.

Click the edit icon () 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.

You 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!

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

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


By default, all fields line up on the left of a form

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.


Rearranged Form

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.



Wait a moment while the form designer loads.



Your form fields will show up against a dotted background.



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.



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

Reset a Designed Form

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.

Always Re-Design a Form when you add a new field!

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.

Read more about database tables on wikipedia.

Group Menu Visibility sets the visibility of Menus by User Groups.

Quick Group Menu Visibility

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.



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.

Classic Group Menu Visibility

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.



Use the checkboxes to toggle visibility on or off.

Hidden, but not necessarily inaccessible

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.

You 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)




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:

Choose an icon
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.

Change Permissions
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.

Some definitions of commonly used terms.

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



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.

Add Qrimp's POP3 Email account checker to display your email addresses with a message count in brackets beside the name of the email address, like this:

name@mywebmail.com (7 new)
mynickname@mydomain.com (10 new)

You can set up each email address to link to the sign in page for the email provider. Depending on your provider, you may also be able to add automatic sign in when you click on the link.

You must be a site admin to add POP accounts.

Go to Admin > POP Email Accounts.

In the name field, enter the text for the link. You can use the email address name ie: "name@mywebmail.com" or something like "My Web Mail Account".

In the userid drop-down list box, select the user who will check the account.

Enter the POP Server ie: mail.myprovider.com. If you are unsure what your POP Server address is, check email provider's help files.

In the popusername field, enter the email address, ie: name@mywebmail.com

Enter the actual current password for the email account. If you are creating a POP Account for someone other than yourself, you will have to get them to do this. The password will always be displayed as stars (**********) to every user.

Enter the url of your email service (the page you visit to check your account). If your provider allows for automated sign in using a url, you can enter the specified url, and use square bracketed field names to populate the required user-specific information from the Qrimp POP Email Accounts table, as follows: popusername poppassword

Do not enter anything in the lastupdatedate field. It will update automatically.

Enter 0 in the messagecount field.

That's it.

Modules add functionality to your app at the click of a button. Modules contain pre-built database tables, views, menus, operations and more.

Some parts of modules may be included in other modules. As an example a "Priorities" look-up table might be included both an events module and a tasks module.

There are simple modules such as look-up tables for countries or states or complex modules like the PayPal Order IPN.

A List of Current Modules

Note: Not all modules are available in all apps

Current Modules

Look-up tables are tables that are connected to other tables as drop-downs to make data entry easier. This is very convenient for oft-repeated data entry areas, such as country or say 'productcategory'. Enabling users to select data from a drop is great for data integrity, increasing accuracy and reducing spelling errors.

In this example, FurColor is a look-up table:

TeddyBears
Name: Fuzzy
Nickname:
FurColor: BrownWhiteBlueBlackBeige

I could only have this drop-down if I already have a FurColor table in my application.

See also Creating a Look-Up Table, Adding a Drop-Down Field, and Convert a Field to a Drop-Down.

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

Changing the Default Start Page

First, copy the url 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.