Qrimp gives you many ways to control security and restrict who can see, access and change your data.

By default, the account administrator is the only one who will be able to change security settings. You can change this by giving permission to other user groups to perform update operations on the Table Security table. You can give them permission to see the table by editing your Menus.

Administrators have automatic rights to:

• Adding Users
• User Groups
• Assigning Users to Groups
• Change Table Security

User Groups are group profiles that help you manage sets of users and control access and permissions to your data. User groups are often based on job function, such as HR or accounting, or by access level, such as administrator or anonymous.

Default User Groups

Your Qrimp app has five default user groups: Administrator, Developer, Tester, User and Anonymous. The Administrator Group has the most default privileges, while the Anonymous group, which refers to public (not logged in) users, has none. You can change these settings on a table by table basis using Table Security and/or Group Menu Visibility.

To add a user, go to Admin > Manage Users. Click the link that says "Add a New User"



Enter the user's information in the form and select a user group for them:

Your user will get an email from support@qrimp.com with login and password information on their account. Make sure they check their spam!



Repeat this for all users. If you have a large number of users please contact us for information on bulk user creation.

The system tables are the core tables that govern the basic functionality of Qrimp applications. Only administrators can see system tables. Some system tables will be hidden from even the administrators, as modifying or deleting these tables can cause serious system errors. The system tables are the Qrimp equivalent to the system tables on your operating system. If you find that you need access to system tables that you do not have permission to edit from your account, please contact support at qrimp.com.

You will probably get along quite well without changing any system tables. Most of them run in the background, but are essential to different parts of the application and the tables you will create. For example, every application has the system table yesno. This table one of the default Look-up Tables for yes/no drop-down lists in new tables you create. It will be used by any table that has yes/no radio buttons as a data entry option. You can see this when you Create Tables and choose your datatype.

If you are creating admin accounts, you'll want to make sure only expert users have access to these tables.

To learn more about enforcing access rules read Table Security.

Field Templates wrap every field in your database. By editing the field template, you can control how any field in any table for any view is presented. You can create user messages, style your fields, make fields links and more.


Some of the other things you can change with field templates

Field templates can have HTML, CSS and JavaScript code in them. In these help documents, we will give you some basic code that you can copy and paste into your field templates to customize your fields.


The default field appearances for the grid view

This grid view has an extra icon that lets you click it to view the record.


The id field template has a second icon in it

Changing a Template

Go to the table and view for which you want to change a field template. Go to Design > Design Mode On.

Click the gear icon at the top of the column you want to change.

Enter HTML in the field to alter the appearance of your field.

Add icons with links

<a href=db.aspx?t=HelpTopics&id=[DATA]&vid=2 id="edititem"><img align=absmiddle src=/c6401/630.png height=20 width=20 align=absmiddle border=0 alt="edit"></a><a href=db.aspx?t=HelpTopics&id=[DATA]&vid=11 id="viewitem"><img align=absmiddle src=/images/webexview.gif height=20 width=20 border=0 alt="edit"></a><a href="db.aspx?t=HelpTopics&id=[DATA]&vid=11" title="View Details">[DATA]</a>

In the HTML above, the following link was not part of the default template. Adding this creates a link to the detail view, that is an image (an icon).
<a href=db.aspx?t=HelpTopics&id=[DATA]&vid=11 id="viewitem"><img align=absmiddle src=/images/webexview.gif height=20 width=20 border=0 alt="edit"></a><br />

Change the color of a link

<span style="color:red;font-weight:bold">[DATA]</span><br /><br />Put a <span> with the style you want around the [DATA] tag.<br />

Make a field a radio button

[radios:yesno:[DATA]:autoupdate]

Make a field a select box

[select:States:[DATA]:autoupdate]

What is Qrimp?

Qrimp is a web platform that allows you to create and operate your own custom information management system.

How does it work?

When you create an app, you get a url, such as http://myapp.qrimp.com, plus a login and password by email. When you log in to your Qrimp app you have the tools you need to build custom solutions for any type of software system and manage your data securely on the web.

What is Qrimp for?

Qrimp is used to create web-based software applications with forms, workflow, reporting, business rules, data views, design templates and more. You can start with your existing data or add data as you go. Some types of software that have been built on Qrimp include Customer Relationship Management, Inventory Management, Enterprise Resource Planning, Supply Chain Management, Knowledge Management, Digital Asset Management, Financial Management, Human Resources, Intranet and more.

How do I sign up?

If would like to create a new web application for yourself or your company, go to www.qrimp.com/signup. If your company already has an app, speak to your administrator and they will create an account for you.

How do I access it?

Qrimp systems are accessible online any time from any web browser, including mobile phone browsers. There is no software to download. If desired, Qrimp can be installed behind a firewall on a local machine (see Qrimp Server).

Who can see my data?

Qrimp systems are all private by default. If you would like to show data to the public, use the anonymous user group under security permissions (see User Groups).

Does Qrimp work with ...?

Qrimp can integrate with external services for payment processing (PayPal, Authorize.Net), maps, UPS (shipping), Flickr, Twitter, RSS - anything with an API. You can also share data from your Qrimp application to external sites using Share Data.

What about my existing files?

Qrimp lets you upload existing documents, such as Word, Excel, PDF, video, and other files. These documents are stored in Qrimp as attachments. See Adding Attachments.

Can you build my system?

If you do not have the time or knowledge to build your system, the Qrimp Services team can provide help. If you'd like our help, please contact us.

Menu tabs are used to navigate your Qrimp application. A menu tab can lead to database tables, pages where you can work with your data or even a particular record, or a function, such as "add a new record". You can completely customize your menus.

Default Menu Tabs

A Qrimp administrator will see three default top-level tabs: Admin, Develop and Design. When you hover over a menu tab you will see the sub-tabs for that menu. Quick tip: To see a brief description of what each of the Admin, Develop or Design sub-menu tabs does, click the top level link.

Dashboard or Home

Most Qrimp apps are set up with a Dashboard or Home Tab. This is blank when your app is first created. Dashboards are usually used as a collection of Portals, but can be customized to anything. The home page is set in User Group Settings (see: User Groups).

Admin

Menu for administrative options, such as account creation and security.

Develop

Develop is for tools such as table creation and views that facilitate back- and front-end data design and manipulation.

Design

Design is for front-end designer tools such as skins and page layouts.

New Tables and Default Menu Tab Creation

When you create a new database table, under the advanced options section below the rows, there is a checkbox for "Add Menus" that is selected by default. If you do not want to see a menu tab for a table (such as for minor tables like drop-down tables), unselect this checkbox.



Use Group Menu Visibility to make menu tabs visible when you create new tables.

Adding a Menu Tab

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.


• Choose which groups can see the menu.


• Security: Select which groups can see the menu tab (See also Group Menu Visibility).
  

Why can't I see a certain menu option?

Qrimp users only see menu tabs that they have permission to see. If you can access Develop > Manage menus, you can set up which menus you can see. If not, please contact your app Administrator.

Advanced: Classic Menus

Menu tabs and sub-tabs are stored in the Menus table. The Menus table can be found under Develop > Manage Menus. Below the links to manage your menus is a link to classic menus. This will let you manage the data the same way data is managed in a regular table.

By default, every Qrimp application comes with the following user groups: Administrator, Developer, Tester, User and Anonymous. You may wish to create additional groups based on specifics of your organization, such as "Accounting", "Editors" or "Human Resources".

By default the first user is an Administrator. Administrators can see most tables by default.

To add a user to a group go to Admin > Assign User to Groups. Click the add new icon.

You will see two drop-down boxes. Choose the user from the first, and the group from the second. Click the Create button.



You must repeat this process for each user and each group.

Bulk Assigning

To bulk assign users to groups, go to the gridedit view of your users table. There is no link to this by default so you will have to type in a url: http://myapp.qrimp.net/db.aspx?t=t_users&_showeditgrid=true Replace myapp with your app name.

Table security lets you set permissions for each of your tables by user group (see also User Groups). You can set Create, Read, Update, and Delete (CRUD) access. Administrators can change security at any time.

Default Permissions

By default, new tables are only accessible to the Administrator and Developer groups. You must add permissions for other user groups. The User and Tester groups can read data, but not create, update, or delete it. The Anonymous (public/not logged in) group, and new user groups that you add cannot see anything unless you give them permission.

Adding Group Level Permissions to View a Table

To set which user groups can access a table, go to Develop > Manage Tables > Find your table > Click the "Group Security" link. Or go to your table and choose the Table Management sub-menu (if available).

From the table management page, click the link that says "Manage Group Security".

Toggle permissions by clicking the checkbox or circle with a line through it.

Advanced: View Security Permissions for all Tables

To view all of your Table Security Records, go to Develop> Manage Tables > View System Tables > t_security > View.

Depending on the size of your system, you may see hundreds or thousands of records. To find a record use the search feature.

On the Table Management page, you can access all of the custom data tables you and authorized users have created. Go to the Develop > Manage Tables to access a list of tables that have been created in your application. If you have not created any tables, this list will be blank.

You can create your first table in just a few minutes using data you already have in a spreadsheet (see Import Data) or by entering columns manually (see Add a Table).

You can also download pre-built Modules which are "Solution Accelerators". A module is a set of database tables and relationships that gives you a head start on your custom web application.

Site Settings let you change settings for your app.
You can change the size of the icons that appear in the header/footer for your tables.

userid:

stylesheetid:

mailboxid:

mailformatid:

languageid:

regionid:

cityid:

icontheme: This is the folder from which you can set icons for inbuilt icon themes. Two icon sets are available medium icons at 32x32 pixels and mini icons at 16x16 pixels. To change from one size to another, simply replace the 16x16 for 32x32 or vice versa.

Set up notifications in your Qrimp app to send an email to a user when data is added, deleted or edited. For example, you can set up an email to a sales rep when a table is updated.

Adding Notifications

To subscribe a user to a notification, go to Admin > Notification Subscriptions. Click the Add New Icon .

Choose the table you want to send a notification for.

Choose which operation triggers the notification. The most common operation is insert, which is when someone adds a new record to a table.

Choose the user who will get the notification.

Then choose a notification message. You can see and edit the content of a notification message by going to Admin > Notification Templates. (See also: Notification Templates).

Customized Notifications

You can get very specific about when to send a notification. For example, you may wish to only notify a sales rep, if a website visitor creates a new order with an order type of "Wholesale".

To customize, go to your list of user notifications and click the link that says "customize". Enter the parameters for your notification. Now the user will only get this notification when that specific criteria is met.

You will see an option at the right to "Customize filters for this notification subscription". Click the link then Search to further restrict notifications. For example, you could choose to only receive an Email notification when someone inserts a Project into the Projects table with the word "Human Resources" in it.

Send site administrators and users custom Notifications when new data is added to your Qrimp application or when people sign in.

To create a new table, go to Develop > Add a Table.



Provide names for the table and columns, select a datatype for each column, and specify whether a column (field) should be required to have data in it in order for the record to save.



Fields contain the specific data about the "thing" your table is for. For example, if I created a table for TeddyBears the columns might be Name, FurColor, EyeColor etc.

All fields will get an id number, which helps us track the particular item. (See automaticids. The first teddy I enter will have an id of 1, the second 2, etc.

Advanced Features

After you have entered the field names, you can choose to enable additional options, Auditing (createdate and createid), Versioning (record history), Attachments, Menus and Tree View (folder display).

At the bottom of the table creation page, click the Create Table button. Qrimp will create the table in the database. After the table is created, you should make sure that your User groups have the correct permissions to the table (See Table Security).

See Existing Tables

To see your tables go to Develop > Manage Tables.

You can add additional fields to any table in your Qrimp app.

Go to Develop > Manage Tables. Find your table in the list. Add the bottom of the page you will see a section called "Add a Column". Enter a name for your field in the table and a datatype and click "Save" or "Add Column".



Configure Column Level Security for your table.

To change the look and feel of the site, go to the Design tab and click on Skins. Enter the url to your stylesheet.



To customize all of the elements that we use on our site, download the default stylesheet and edit the properties you would like to change.

To get your CSS files onto the server, create a project you'll use to manage your style sheets and upload the CSS file as an attachment. Then use the url of the attached file as the URL you paste in the URL box.

Operations allow system users to perform actions upon data in your application. Operations are analogous to stored procedures. The five types of operations that users can perform on a database are Create, Read, Update, Delete and Admin.

* Create - Users can create entries in the table.

* Read - Users can view items in the table.

* Update - Users can update existing records.

* Delete - Users can delete information from the table.

* Admin - Full Permission. Users can add and remove fields from the table, rename columns, and rename the table. Admin rights also allow them to control security on the table.

Qrimp has additional default operations such as add notifications, gettree, etc.

To view the operations in your system go to Admin > Operations (). Access to the Operations table is restricted to Administrators by default.

To allow your users to perform operations, you must first make sure they have the security privileges to do so. You can control operation privileges using Table Security.

You can also write your own operations to set up specific functionality based on particular tables, etc. Qrimp has a generic operation statement writing language that should be fairly intuitive to advanced database administrators. Learn more about Writing Operations and Using Operations in urls.

In Qrimp, the area above your tables is the "Header" and the area to the right is the "Footer". The Header is also known as the "Content Header" (#contentheader in CSS).

Default Headers and Footers

Each table has a default header, in most cases containing the Action icons that allow you to change Views, see Reports, add new items, edit, etc. Each of the default views has its own Header showing icons relevant to that view. For example, if you are in already edit view, you will not see the edit icon in the header. Headers are also a great place to put a custom messages to your users, rss feeds, shopping carts, images, shared data or even Custom CSS specific to that item and view.

The default footer usually contains Related Data, Attachments , related tables, or custom messages to users.

Changing Headers and Footers

To change the header or footer, go to the table and the view you are changing it for. Then go to Develop > Header/Footer.



If a custom header or footer exists for that table and view, you will see it in the list.



Click the small edit icon to open the header/footer for editing.

You will see a text box for the HTML for your Header and a separate text box with the HTML for your footer.

Change the HTML to create your custom message. Save a copy of the working Header or Footer HTML for reference while you are working. Versioning is enabled by default for all header/footer tables. To view previous versions of your header/footer, click the Versioning icon once you have saved the custom header/footer.

When you are working with your Qrimp app, you may encounter error messages. The error messages will appear in red and should tell you what to do to correct the problem, if possible. Many of these occur if you are entering data that is not the correct type, or if your data model is not correct.

Sometimes you will see a warning at the top if you have just deleted a record. This may sometimes persist to a new table as you are navigating. Usually these types of warning messages will disappear if you refresh your browser or if you continue using your app as normal.

We will attempt to document the most common errors and warnings in this section.

If you come across blank pages or unexplained errors, please contact us or submit a Feedback blurb with a detailed explanation of what happened.

A many-to-many relationship is a relationship between two database tables. For example, a stuedent in university will have many teachers, and a teacher will have many students. The relationship between the two tables is a many-to-many relationship between students and teachers.

Adding a Many-to-Many

To add a many-to-many relationship first go to the table for which you'd like to create the relationship, then go to Develop > Add Many-to-Many.

At the top of the page, you'll see the table you selected, and a drop down list of other tables in your system. Select the table to which you'd like to add the relationship and then name the relationship. Usually something simple such as TeacherStudents or UserTasks is best.

Click create to add the relationship. You will see two links that allow you to view data in either of the tables.

View the Relationship

To view the relationship go to the detail view of any item in either of the two related tables. On the right hand side of the page, you will see a heading/link to the relationship. If there are related items, they will be listed below the link. There is also an add button so you can add new items.

Advanced - viewing all relationships in your system.

To see a list of all existing relationships, go to Develop > Many-to-Many.

Use attachment viewers to control how attachments are displayed (with img tags or embeds). We have included default displays for several common types of attachments:


To change how an attachment type displays, go to Admin > Attachment Viewers. Edit the itemtemplate field you want to change. For example, if the attachment file is an mp4 file, embed a Quicktime plugin in the itemtemplate to make the file play in Quicktime.

This is tree view:




Use Tree View if your information has sub-categories and you want to see a drop-down folder "explorer-style" view of it.

Adding a Table with Tree View

You can only add tree view at the moment you are creating table. To enable tree view, simply click the tree view checkbox at the bottom of the create table page.

Navigating to your Tree View

Look for the following icon in your table header:

Adding the tree view icon

Use the following url to add the tree view icon: src="/icons/crystal_project/32x32/actions/view_tree.png" alt="Tree View"/

Versioning shows you a history of all changes made to a record in your database. This is great for SOX compliance (Sarbanes Oxley).

Enable Versioning

You can only enable versioning when you Create Tables or Import Data. To enable, check the checkbox beside Versioning.

To see your version history for an item, go to the item and click on the icon in the Content Header. You will see a side-by-side comparison of the new version and the version that was saved previously. Choose older versions from the drop-down list containing version edit dates and times.

Versioning may not be available for some items.

Tables are the core of a Qrimp database application. All of your data is stored in tables. Once you have created tables, you can enter data, delete tables and rows, add columns, view Reports, choose different data views and more.

A table in your Qrimp application is composed of many records (also known as fields or items) stored in columns. Each field will contain data about a particular item in a table. For example, if I create a table for TeddyBears the fields might be Name, FurColor, PurchaseDate, etc.

Each field has an id number, which helps you track that item. The first bear I enter into the TeddyBear table will have an id of 1.

You can see the tables in your application by going to Develop > Manage Tables. You can change the way the data in a table is displayed with Views, and change the way it is navigated to using Navigation options.

See also Definitions: database table.

What is a data model?

A data model is an organized overview of the data you need to keep track of, like a blueprint for your application. When you create a data model, you decide which "things" you want to store information about, and which information about those things is important.

Why model data?

Mapping out a data model before you start building your database will help you build a more efficient system. Data modeling is not required to build a Qrimp app.

Example

Let's say I have a grocery store. When I think about my information, I decide that I want to track the following "things":

- Employees
- Stock
- Suppliers

Information in a database is stored in tables. So in my database application, I will have three tables: Employees, Stock, and Suppliers. In each table, I enter further details about the things you want to keep track of.

In the grocery store example, I would create a table for each of these "things". I would also want to track certain information about each item, so I would add several columns in each table. For example, I would want to track my employees names and hire dates, so I'd add columns for those.

In a database, it's best to break down column names into the most detail possible. Rather than tracking "EmployeeName: Jane Doe" it's best to track "FirstName: Jane" and "LastName: Doe".

In other words...
What you have to do is think of the tables you'd like to create and decide which information you want to store. The tables will be the things we want to keep information about (ie: Books), and the columns will be specifics about that thing (ie: Author). Remember - Qrimp allows for Adding Columns if you think of something else you want to track later.

You create a table by navigating to Develop > Create Tables.

Once you have a basic set of data tables, you can manage your application by Adding Columns to existing tables and by creating more tables. You can also Import Data if you already have your information in spreadsheets or .csv files. Most applications, including Quickbooks, MS Outlook, banking websites and more allow for .csv export of data.

Here are some good links to help you get started with the concept of data modeling:

Table (database)
Relational Database
Data modeling (wiki)
Database normalization
Database normalization discussion.

Auditing keeps track of who created an entry into the table and when. Adding auditing to your tables will allow you to use the date search feature to find all items created on a particular date.

You can also use auditing to quickly find all the items created by a particular user or setup security so that users can only see the items they have created.



Please note the warning. To have the functionality to sync with your laptop you must select Auditing and Versioning.

See Look-up Tables.

A datatype is a type of data. Some data types include currency, decimals, text, date/time, yes/no and look-up tables. Choosing a datatype allows you increase data accuracy by restricting which kind of information users can enter when they are creating new records.

Data Accuracy

Choose a datatype that accurately describes which type of data a field will contain will make your application more efficient and less error-prone. It will also make any reports and charts you generate more precise. Think carefully about which datatype is most appropriate for your field. If you create a field called HireDate in your Employees table, choose the datatype date/time, users will only be able to enter properly formatted dates. If you chose a less specific datatype, such as Multi-line text, employees could enter the entire story of how they were hired in the HireDate field.

The "grid view" or "list view" is a view of a database table formatted as a table. By default, a grid view shows you all of the rows and columns in a table. It is represented with this icon .

You can usually get to the grid view by going to the menu tab and clicking the "grid view" sub-menu tab.



By default, most views of your data have a link to the grid view in the Content Header above your data.

Click the id link or double click a row to view the record. Click the edit icon to edit.

Deleting and editing rows in grid view:

Next to the id field in most tables you will see two icons, a delete icon and an edit icon .

Clicking the delete icon allows you to delete the row from the data table (it warns you if you want to delete first).

Clicking the edit icon allows you to change data in that row.



To add additional icons to your id columns, use Field Templates.

You can add records to a database table from anywhere you see the "Add New" icon (a piece of paper with a green plus sign).

Adding a New Record

Navigate to the grid view of the table you want to update and add a row to that table by clicking the add new icon in the Content Header. All records added to your tables are given AutomaticIDs.

In Qrimp, you can use Square Brackets "[]" to create links. This is similar to functionality available in Wikipedia and WordPress. Square brackets can also be used to insert server variables and session values, display a field as a select box or radio button and more.

Creating Links with Square Brackets

The data in these Help Files is stored in a table called Help Topics. The current record has the Name "Square Brackets". To create a link to the Help Topics table type in [Help Topics]. To link directly to the Square Brackets record type in [Square Brackets]. You can also link to a record in a table with square brackets by using the name of the table followed by a colon and the record id, like this: [HelpTopics:48].

Limitations of Square Brackets for Linking

If there are multiple records in your database with the same name or if the Name field is edited, your square brackets link will not work.

Links to Default Items

You can use square brackets in the HTML for links to make links more flexible and generic (see also [query string urls]). Normally when writing the HTML for a url, you would write &t=customers, but if you write &t=[t] the link will go to the 'current' table or 'default' record. Links with square brackets are most commonly used in [Menus], the [Content Header], [Views] and [Field Templates]. For example, imagine this link: is in the Content Header of my customers table. When I click the link, I will go to the create view (view 8) of the customers table. Square brackets pull in the closest item. [t] will pull in the current table. [id] will pull in the current id.

Square Brackets to pull in DATA

Use [DATA] between the a tags to pull in the data from the linked record.

Square Bracket Select Lists

When displaying a form with a column or field that is a pick-from (drop-down), Qrimp displays a select box in HTML so the user can choose from the list. Behind this is a template. The template looks like this:

[select:[table_name]:[id]]

and produces this:

[select:[table_name]:[id]]

You can show a "friendly name" for items in the detail view, rather than the id number of the field. (See also [AutomaticIDs]

For example if you have an address table with a foreign key to the states table, when displaying the address, you'd like the state name to be displayed instead of the unique id for the state. To do this, you'd use something like the following:

[states:[id]] where [id] is the ID of the element to be displayed from the states table.

If this item is being displayed in the grid view, you can dynamically insert the Foreign key ID value into the square brackets like this:

[states:[DATA]] uses the data in the database for this cell to grab the state name. By default, Qrimp will display this notation in the web page with a link back to the detail page for the table and item specified by [DATA]. To show only the data without the link back to the item, use [states:[DATA]:nolink].

[t_users:[DATA]] Will pull back a list of users and show the current user.

Square Brackets and Server Variables

Here's a full list of server variables. You can also read more about Working with Server Variables.

To use the drag-and-drop calendar, go to the calendar view of a table.

Now when you put your mouse over the mini calendar icon in front of the task name, the cursor will change to the move pointer, on Windows machines, it's usually a cross with arrows. On Macs, it's a little hand.

Click and hold this icon to drag the task to another day on the calendar. The due date for the task will automatically update to the day you dragged the task to.

Design view or the Form Designer lets you re-arrange the location of the fields on the screen. Design view is used exclusively for the Detail View and Edit View

To design a view for a table, go to the table and view you want to change, then go to Design > Form Designer. Your page will reload with a dotted background. Click and hold the the field you want to move until a multi-directional arrow appears, then drag and drop it in its new location.



You can also move the "Save/Copy/Cancel" buttons that appear at the bottom of a page.

All tables with a date field (Date/Time datatype) will be viewable on a Calendar. When the Calendar view is available, the calendar icon appears near the top of the page in the Content Header. A link to the calendar view also appears by default in sub-menu tabs.

The Calendar View opens for the current month. You can select other months and years from the drop-downs at the top of the page. You can also go to a day view.

Tables with CreateDate and Other Date Fields

If you choose the Auditing option when creating your table, your table will be given a "createdate" field, which means that when you click on the Calendar View icon, you will see a calendar of when items were created.

If there is more than one Date field in a table, the Calendar will show items with the FIRST date column by default. Once you are in the Calendar, you will be able to choose to show the calendar with items from another date field using a drop-down box.



For example, if I have a Projects table with two date fields "Start Date" and "End Date", when I first open the table in Calendar view, I will see items that Start on days in the month I am in. If I want to see when items end, I can choose "End Date" from the "View By" drop-down box at the top left of the view.

Changing Due Dates with Drag and Drop

You can drag and drop an item on the Calendar and the selected date field will update the item to the new date.

Click the reports icon to view reports.

You can also filter the reports by clicking the on the Reports page.

When you create one-to-many relationships between your tables, links to the related tables will appear by default on the right hand side of the page. If those related tables contain data, you will see the data rows listed.

Adding More Related Data
You may also see the option to add related data. For example, if I am in sub-project 2 and I wish to add another sub-project section, I click the "+ add..." and it takes me to a new sub-project, already configured to be related to sub-project 2.



If you have enabled Attachments to your table, you will see a list of attachments with the related data.

Read more about Adding Attachments.

Read more about Headers and Footers.

To keep the size of your Qrimp application small, the attachments sidebar is not automatically visible on every table. If you would like to see attachments on the right in the detail view of each record, the table must be created with 'Attachments' enabled. If you do not see the attachments box to the right of your item, this option may not have been turned on. You can add it by following the instructions below.

Creating Tables with Attachments Sidebar Enabled

When you add a table, click the checkbox beside "Enable Attachments” in the Advanced options. (See Add a Table).

Enabling Attachments Sidebar for Existing Tables

If you created a table without the attachments sidebar capability (see above), you will have to add some code that will turn this feature on for a table.

First, go to the table you want to add the sidebar to. Then go to Develop > Header/Footer (see Headers and Footers). Copy and paste the following HTML into the footer section:

<div id="attachmentsdata" class="relateddata"><h4><a href="db.aspx?t=attachments&tableid=1006&itemid=<a href=search.aspx?_field=name&itemname=id>id</a>" title="View All Attachments...">Attachments</a></h4></div><a href="uploadfile.aspx?t=1006&id=<a href=search.aspx?_field=name&itemname=id>id</a>&vid=11" id="Attachmentsadd" title="Upload Attachments...">add</a><script>showHtml("attachments&tableid=1006&itemid=<a href=search.aspx?_field=name&itemname=id>id</a>&vid=21&orderby=1,1","attachmentsdata");</script>

Note: be sure to change the id number (tableid=1006 and t=1006) of the table to the id of your table. (See automaticids

Naming a Table

When you are creating a table, the table name should be the thing you want to keep track of, ie: "Customers", "Projects" or "TeddyBears". The name you choose should not have spaces and cannot be from the list of Reserved Words.

Creating Fields

Fields are also known are records and are sometimes referred to as columns.

A Field name for the data we want to collect about our "thing" is the type of data we want to keep track of. For example, we may wish to store our TeddyBears Names, so we enter "Name" in the first field. Other fields we may want to keep track of would be FurColor, DateAcquired, Height, etc. The name you choose should not have spaces and cannot be from the list of Reserved Words.

Selecting Field Data Types

Next we have to decide which type of data "BearName" is (see datatype). We choose which type of data this will be from the datatype drop-down list. If the datatype is a number, a date/time, or text, we choose from the first part of the drop-down list. BearName would be plain text, so we choose "Single-line text - 50 characters". We limit the length of the field to 50 spaces, because we don't want people to enter a lot of text in this field.

Creating from a Look-up Table

If we already have a table called 'FurColor' that lists colors of fur, we could choose furcolor from a drop-down/pick from/look-up table when we were choosing the datatype for the FurColor field. This would enable users entering data in the FurColor field to choose from a drop-down list of fur colors. You can choose these when the data entry options for a field already exist in a separate table. This will link the fields to other tables in your database. See Look-up Tables

Number with decimalsNumber without decimalsDate/TimeText (2 characters)Text (50 characters)-- picklist from --accounttypesfurcolort_userst_viewsyesno

If you have your data in excel spreadsheets, .csv files or tab delimited format, you can use the Data Import feature. This is a fast way of getting a large amount of data into your Qrimp database. Import data is also the best way to create drop-downs.

To import data, simply copy/paste a spreadsheet or .csv file into a text box and Qrimp will create your table(s) for you. You can also type data into the text box.

To use the data import feature, go to Develop > Import Data. If you do not see an import data link, go to Develop > Create Tables, then click the Import Wizard link near the top of the page.



To make sure your table is created properly, use "clean" data and prepare it in a spreadsheet or text editor as follows:

Put the name of the column in the top row and all of the data to be in that column in the column below it.

The following data is in the correct format for import:

FirstName Position Salary
John Cashier $30,000
Christina Cashier $32,000

Note that if you are using a text editor, there should be tabs between each item (where the spaces are above).

When you are ready to import your data, copy and paste it into the text box, or upload a file. Check the box beside "First row contains field names", unless you are using the importer to import data into an existing table.


Some simple data, ready to import.

----
Choose Advanced Options.

If this is a lookup table, do not enable any advanced options.
----
Wait for the data to be imported.


----

You will see your newly imported data.

---
Now you must:
Give permission to your users to see this table with Table Security. If you are adding this field to an existing table (if it's a lookup table), you will need to configure Column Level Security.

Data Import Tips

1. Field names must start with a letter and can only contain letters, numbers and _. Spaces will be converted to _.
2. Data must be in tab-delimited format
3. If you want the data to be searchable, it needs a description field
4. Don't edit the data after you paste it, it will look funny because the lines wrap in the box, but it's okay, we'll take care of it. If you edit the data, your data table may not be created correctly.

If you have a name for your sheet, Qrimp will automatically name the data tables it creates with that name.

Multiple Sheet Import
You can import a spreadsheet file with multiple sheets. The data from each sheet will be created as a separate table, and relationships will be implied and constructed from and between your tables automatically.

To enter data, go to the menu tab for your table, which appears on the top or left of your window. Hover over the tab, click the add icon in the sub-menu.

To edit records from the grid view, click the edit icon next to the row you would like to edit.

To edit items from the detail view click the Edit icon in the Content Header.

Clicking on this icon takes you to the Edit View.

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.