Qrimp Help Documentation

id	name	description	ParentTopic
23	Headers and Footers	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]). <h2>Default Headers and Footers</h2> 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 <a href="db.aspx?t=1006&id=176&vid=11">views</a> 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. <h2>Changing Headers and Footers</h2> To change the header or footer, go to the table and the view you are changing it for. Then go to Develop > Header/Footer. <img src="/attachments/3b12cead-6669-46a6-83b7-00ac5329fb79/Heade_Footer.jpg"/> If a custom header or footer exists for that table and view, you will see it in the list. <img class="border" src="attachments/c3500bae-f1ad-4b79-8b4e-786752c82cb9/HeaderFooterHelp2.JPG" /> Click the small edit icon <img src="/images/edit.gif" />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 <img src="/icons/crystal_project/32x32/mimetypes/file_temporary.png"> once you have saved the custom header/footer. <img class="border" src="attachments/d62d2971-740c-4fdc-beb5-a1b40859ae4a/HeaderFooterHelp3.JPG" />	Above and beside your data
22	Operations	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 (<img class="noborder" align="absmiddle" src="/icons/crystal_project/32x32/apps/kfouleggs.png">). 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].	Advanced Development
20	Adding Skins	To change the look and feel of the site, go to the Design tab and click on [Skins]. Enter the url to your stylesheet. <img src="attachments/6c9fb3b8-6046-4d32-a767-ad3478d2a4f5/Skins.jpg"> To customize all of the elements that we use on our site, download the <a href='styles/twocolflexbannerbrochure.css'>default stylesheet </a> 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.	Changing the Look and Feel of Your App
19	Adding Columns	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". <img class="border" src="/attachments/e11af951-c4aa-4655-9407-2d768f6e1ade/AddColumn1.png"> Configure [Column Level Security] for your table.	Building Your System
18	Add a Table	To create a new table, go to Develop > Add a Table. <img class="border" src="attachments/27da6af9-4600-4320-b652-a48d42c45ebc/AddTable.jpg"> 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. <img class="border" src="attachments/b5f345e3-0d3f-49e7-b5e5-3cc95a3cc37b/AddTable1.png"> 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. <h2>Advanced Features</h2> 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]). <h2>See Existing Tables</h2> To see your tables go to Develop > [Manage Tables].	Building Your System
17	Notification Subscriptions	Send site administrators and users custom [Notifications] when new data is added to your Qrimp application or when people sign in.	Notification Subscriptions
16	Notification Subscriptions	<!--<nobreak>--> <p>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.</p> <h3>Adding Notifications</h3> <p>To subscribe a user to a notification, go to Admin > Notification Subscriptions. Click the Add New Icon <img src="/icons/crystal_project/32x32/actions/edit_add.png" />.</p> <p>Choose the table you want to send a notification for.</p> <img class="border" width="300px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/867d5c7f-48c4-4d82-8f51-3a3a8a68e988-custom%20notifications%20screen%201.png"> <p>Choose which operation triggers the notification. The most common operation is insert, which is when someone adds a new record to a table.</p> <img class="border" width="300px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/a0f6b54d-ccaa-4bfd-93ad-4daf13586bf8-custom%20notifications%20screen%202.png"> <p>Choose the user who will get the notification.</p> <img class="border" width="300px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/51cbd38d-9324-4cdb-bcc9-c5be69dae2c1-custom%20notifications%20screen%203.png"> <p>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]).</p> <img class="border" src="/attachments/developer.qrimp.com-1941ee44-967d-422c-8622-b802f1a72ddd/notifications%20screen%204.png"> <h3>Customized Notifications</h3> <p>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".</p> <p>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.</p> <p>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.</p> <!--</nobreak>-->	Communicate and Share
15	Site Settings	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.	Advanced Development
14	Manage Tables	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.	Working with Data
13	Table Security	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. <h2>Default Permissions</h2> 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. <strong>The Anonymous (public/not logged in) group, and new user groups that you add cannot see anything unless you give them permission.</strong> <h2>Adding Group Level Permissions to View a Table</h2> 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. <img class="border" src="attachments/developer.qrimp.com-86051ce6-0b93-4896-8c39-db1b42c5a94a/configuretablesecurity.png" /> <h2>Advanced: View Security Permissions for all Tables</h2> 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. <img class="noborder" align="absmiddle" src="/icons/crystal_project/32x32/actions/filefind.png">	Security
12	Assigning Users to Groups	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. <img src="/attachments/931603f9-0552-4351-9984-17befcb57aba/AssignUsertoGroup.png"> You must repeat this process for each user and each group. <h2>Bulk Assigning</h2> 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.	Managing Users
10	Menus	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. <h2>Default Menu Tabs</h2> 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. <em>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.</em> <h3>Dashboard or Home</h3>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]). <h3>Admin</h3>Menu for administrative options, such as account creation and security. <h3>Develop</h3>Develop is for tools such as table creation and views that facilitate back- and front-end data design and manipulation. <h3>Design</h3>Design is for front-end designer tools such as skins and page layouts. <h2>New Tables and Default Menu Tab Creation</h2> 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. <img class="border" src="attachments/developer.qrimp.com-cd1dba76-65d1-4b6f-9337-0877bde7f363/addingmenustonewtable.png" /> Use [Group Menu Visibility] to make menu tabs visible when you create new tables. <h2>Adding a Menu Tab</h2> To add a menu tab, go to Develop > Manage Menus then click the Create Menu Item button. Enter the following information: <ul> <li>Name: The word that will appear in the Menu Tab. </li> <li>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.</li> <li>Parent Menu: Choose a top level menu tab to show your menu in a sub-menu below it.</li> <li>Description (Optional): Enter a description.</li> <li>Icon (Optional): Click the edit link and choose an icon.</li> <li>Choose which groups can see the menu.</li> <li>Security: Select which groups can see the menu tab (See also [Group Menu Visibility]). </ul> <h2>Why can't I see a certain menu option?</h2> 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. <h2>Advanced: Classic Menus</h2> 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.	Navigation
8	An Introduction to Qrimp	<!--<nobreak>--> <h3>What is Qrimp?</h3> Qrimp is a web platform that allows you to create and operate your own custom information management system. <h3>How does it work?</h3> 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. <h3>What is Qrimp for?</h3> 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. <h3>How do I sign up?</h3> If would like to create a new web application for yourself or your company, go to<a href="http://www.qrimp.com/signup.html"> www.qrimp.com/signup</a>. If your company already has an app, speak to your administrator and they will create an account for you. <h3>How do I access it?</h3> 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 <a href="http://developer.qrimp.com/db.aspx?t=HelpTopics&id=138&vid=11" alt="Qrimp Server">Qrimp Server</a>). <h3>Who can see my data?</h3> 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 <a href=http://developer.qrimp.com/db.aspx?t=HelpTopics&id=4&vid=11>User Groups</a>). <h3>Does Qrimp work with ...?</h3> 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 <a href=http://developer.qrimp.com/db.aspx?t=HelpTopics&id=130&vid=11>Share Data</a>. <h3>What about my existing files?</h3> Qrimp lets you upload existing documents, such as Word, Excel, PDF, video, and other files. These documents are stored in Qrimp as attachments. See <a href="db.aspx?t=HelpTopics&id=137&vid=11">Adding Attachments</a>. <h3>Can you build my system?</h3> 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 <a href="http://www.qrimp.com/contact.html">contact us</a>. <!--</nobreak>-->
7	Field Templates	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. <img class="border" src="attachments/developer.qrimp.com-847ce764-46bd-49be-bd30-5f3a0b75cad8/thingsfieldtemplatescanchange.png"> <span class="small">Some of the other things you can change with field templates</span> Field templates can have <a href="http://developer.qrimp.com/HelpTopics/HTML">HTML</a>, [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. <img class="border" src="attachments/developer.qrimp.com-8b9ed061-279f-4cc0-8b3d-155bda49382a/wherethefieldtemplatesare.png"> <span class="small">The default field appearances for the grid view</span> This grid view has an extra icon that lets you click it to view the record. <img class="border" src="/attachments/developer.qrimp.com-a21b9b71-27d2-4d38-8ed1-07563eea1948/changedtemplatesingridview.png"> <span class="small">The id field template has a second icon in it</span> <h2>Changing a Template</h2> 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. <h2>Add icons with links</h2> <textarea><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></textarea> 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). <textarea><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> </textarea> <h2>Change the color of a link</h2> <textarea><span style="color:red;font-weight:bold">[DATA]</span> Put a <span> with the style you want around the [DATA] tag. </textarea> <h2>Make a field a radio button</h2> <textarea>[radios:yesno:[DATA]:autoupdate] </textarea> <h2>Make a field a select box</h2> <textarea>[select:States:[DATA]:autoupdate]</textarea>	Display and Design
6	The System Tables	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 <strong>yesno</strong>. 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].	Advanced Development
5	Adding Users	To add a user, go to Admin > Manage Users. Click the link that says "Add a New User" <img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/d518f04e-6263-42c2-aacb-86fb4e3f9154-add%20user%20screen%201.png"> Enter the user's information in the form and select a user group for them: <img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/d2b6612f-73c9-4d3f-9ec6-d507b59edbf7-add%20user%20screen%202.png"> Your user will get an email from support@qrimp.com with login and password information on their account. Make sure they check their spam! <img class="border" width="500px" src="http://f43a933af7ac34dcec6f-e68f0ae55bed6d6f943b932cc8d70ccb.r3.cf1.rackcdn.com/8b4d3cfd-f13a-44c8-89e3-89923298cf41-add%20user%20screen%203.png"> Repeat this for all users. If you have a large number of users <a href="http://www.qrimp.com/contact.html">please contact us</a> for information on bulk user creation.	Managing Users
4	User Groups	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. <h2>Default User Groups</h2> 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].	Managing Users
3	Security	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: <ul> <li>[Adding Users]</li><li>[User Groups]</li><li>[Assigning Users to Groups]</li><li>Change [Table Security]</li></ul>