Qrimp Help Documentation

id	name	description	ParentTopic
77	Form Designer	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. <img class="border" width="500px" src="attachments/developer.qrimp.com-e302d1e8-161a-455a-b6e1-32fe34eccf5b/defaultformlayout.png" /> <span class="small">By default, all fields line up on the left of a form</span> 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. <img class="border" width="500px" src="attachments/developer.qrimp.com-e1019979-f8bb-4c79-9264-dac8391fe672/redesignedformdetailview.png" /> <span class="small">Rearranged Form</span> 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. <img class="border" src="/attachments/developer.qrimp.com-1a5e836e-74ea-4627-b775-0f72431164a0/formdesigner.png"> Wait a moment while the form designer loads. <img class="border" src="attachments/developer.qrimp.com-a66d7239-3beb-4b0c-8ee5-85a4d7d27094/preparingtoloadformdesigner.png" /> Your form fields will show up against a dotted background. <img class="border" src="/attachments/developer.qrimp.com-ffc8a453-de84-4ddd-800d-f946fb5843d4/formdesignerdottedbg.png" /> 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. <img class="border" src="attachments/developer.qrimp.com-aa25f462-9347-4539-8931-684a2f9334f8/clickanddragfield.png" /> Move all fields to their new spots. All new field positions are saved as soon as the item is dropped in the new spot. <img class="border" src="attachments/developer.qrimp.com-29d49d8e-d8b4-46b1-89d4-872264382d15/redesignedform.png" /> <h2>Reset a Designed Form</h2> 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. <img class="border" width="450" src="attachments/developer.qrimp.com-c73fd12c-06ce-4d77-9d7b-069919f3ed7f/resetdefaults.png" /> <h2>Always Re-Design a Form when you add a new field!</h2> 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. <img class="border" src="attachments/developer.qrimp.com-69f36ad0-a0f8-4bba-a6fc-256fb73ea708/addcolumn.png" />	Display and Design
78	Data Table	Read more about <a href="http://en.wikipedia.org/wiki/Table_(database)">database tables</a> on wikipedia.	Definitions
79	Group Menu Visibility	Group Menu Visibility sets the visibility of [Menus] by [User Groups]. <h2>Quick Group Menu Visibility</h2> 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. <img class="border" src="/attachments/developer.qrimp.com-6eab9eac-92a4-42e9-9ead-6f5fc638e135/quickgroupmenuvisibillity.png" /> 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]. <h2>Classic Group Menu Visibility</h2> 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. <img class="border" src="/attachments/2b035c93-a495-42cf-a39c-a12e54b21392/GroupVisibility.png"> Use the checkboxes to toggle visibility on or off. <img class="border" src="/attachments/dc8623d3-7ee4-474d-8202-137f08a4f40f/2008-12-14groupmenuvis.png" /> <h2>Hidden, but not necessarily inaccessible</h2> 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].	Menus
80	Add A Sub-Menu Tab	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) <img src="attachments/688755d9-43d3-4673-9a8c-5a70bc0f9835/AddSubMenu.jpg"> 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: <strong>Choose an icon</strong> 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. <strong>Change Permissions</strong> 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.	Menus
81	Definitions	Some definitions of commonly used terms.
84	Column Level Security	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". <img class="border" src="attachments/developer.qrimp.com-a8c36b17-dad7-4f15-8c55-1f7e939ab98c/columnsecuritylink.png" /> 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. <img class="border" src="/attachments/9b777dc0-271f-4eeb-9500-3f16d11b4821/ColumLevelSecurity1.png">	Security
91	Check POP3 Email Accounts	Add Qrimp's <a href="http://en.wikipedia.org/wiki/Pop3">POP3 Email</a> 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.	Communicate and Share
98	Modules	Modules add functionality to your app at the click of a button. Modules contain pre-built [database table]s, [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. <h2>A List of Current Modules</h2> <em>Note: Not all modules are available in all apps</em> <span id=Modulesbodydata> <h4>Current Modules</h4> </span> <script> getContent('db.aspx?t=Modules&vid=1&orderby=2&hidecolumns=id,description,status,scripturl,createid,createdate&noheader=true&nofooter=true' ,'Modulesbodydata'); </script>	Building Your System
99	Look-up Tables	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: <b>TeddyBears</b> Name: Fuzzy Nickname:<input type=text size =20 id=name name=name maxlength=50 > FurColor: <select name="datatype0"><option value='pickfrom_accounttypes'>Brown</option><option value='pickfrom_t_furcolor'>White</option><option value='pickfrom_t_users'>Blue</option><option value='pickfrom_t_views'>Black</option><option value='pickfrom_yesno'>Beige</option></select> 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].	Definitions
102	Default Start Page	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. <h2>Changing the Default Start Page</h2> First, copy the <a href="db.aspx?t=helptopics&id=261&vid=11">url</a> 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.	User Group Settings
103	Default View	If you don't change this setting, the default view is always the table/grid view, showing all of your data, dependent of course, on your [Security] rules. On the Develop > [Table Settings] page, there is a field called "Defaultview" with a drop-down list that lets you choose among the many [Views] (these are basically page templates) in your application to set which one is the default for that table. This is handy if you want people to see your table laid out in a particular way. <img src="/attachments/1a26b6f1-f45e-4fc2-b502-a9f2f88c1c54/DefaultView.jpg">	Views
104	Creating your own views	If you would like to display your information on a page in a custom layout, and none of the pre-configured data [Views] match the data in the table or the desired layout effect, you can create your own view. In the [Menus], go to Design > [Views] and click "Add New" <img src="/icons/crystal_project/32x32/actions/edit_add.png" /> Create a descriptive name for your view that will help you remember it. For example, if you are creating a view showing only the images from your table, with a border around them, name the view "Images With Borders". In the "Description" area, use Qrimp [Square Brackets] notation or urls to pull in data from your table. <strong>Formatting your data with HTML and CSS</strong> Enter HTML and inline CSS tags in the description field to control how your data is displayed. For example, let's say we had a small inventory table with four fields: id, ItemName, Description and ItemCount. We'll want to display only the name of the inventory item. We can get the using square brackets as such - [ItemName] We can also style this information. Let's imagine that we wish to make the ItemName an h2 and we'd like to make in a div with a red background. Here is what our HTML and square brackets would look like: <style> #red{background:red;}</style> <div id="red"> <h2>[ItemName]</h2> </div> And here is what our result would look like: <style> #red{background:red;}</style> <div id="red"> <h2>Inventory Item 1</h2> </div> This is just a basic example. Learn more about pulling data into page templates with [Square Brackets]	Views
105	Clear Menu Cache	Under the Develop menu tab, you will see a menu called <img src="/icons/crystal_project/32x32/actions/tab_duplicate.png" height=16 align=absmiddle /> Clear Menu Cache. <img src="/attachments/143e278e-f99c-4b85-87ab-09640c611215/ClearMenuCache.jpg"> Clearing your menu cache will update the menus to reflect any changes you have made. Menus are cached to improve system performance by alleviating the need to fetch the menu list from the database for each page view. The downside to this approach is that changes to menus aren't always immediately reflected. Logging out and relogging in will also clear the menu cache, so users will always have the latest menus when they log in.	Menus
106	Using SQL Statements	You can use custom SQL statements get information about your existing tables and to manipulate your data. The query builder is in Beta Mode. You can use it to generate your own custom queries for your database to return very specific resultsets or even execute UPDATE, INSERT, or DELETE statements, but of course be careful with these. If you select a table from the query list and click "show sql," a select statement will appear. Click Run Query to return results. You can save your queries also. If you have selected a table, then save a query, a link will appear to the right of the query list that you can click on to view the results in your browser and save a menu that will display these results for you. You can also use these results in Portals.	Data Analysis
107	Creating a Look-up Table	A look-up table lets you select data from a drop-down list in any one of your tables. Like this: <img class="border" src="/attachments/96528c8f-71d0-4a7f-aa82-9cdb855b19d1/ClientDropDown.png"> To let the system know which table you want to pick from, you have to create a look-up table. <h2>Adding a look-up table with Import Data</h2> If you are adding a look-up table with a lot of records, [Import data] is the fastest way to create it. Go to Develop > Import Data. <img class="border" src="/attachments/ef4d0248-5e5a-4b93-97ca-c283b88af827/importdata.png" Enter a Table Name. <img class="border" src="/attachments/6d8a61f7-366c-42f6-99c0-4746a9ea6680/EnterTableName.png"> Check the checkbox beside "First row contains field names". In the box below, enter: Clients XYZ Company ABC Inc JKL Manufacturing etc.... Then click "Import Data!". Leave the advanced features unchecked for look-up tables. <img class="border" src="/attachments/55744fd5-fa15-4c4f-ba22-0b4b094d2473/LookupTableCreation.png"> <img class="border" src="/attachments/535691ad-592b-4fad-9114-99e157a53c8e/Lookup4.jpg"> See also [Convert a Field to a Drop-Down] and [Adding a Drop-Down Field]	Add a Table
110	Content Header	The "Content Header" or "Header" is the area below the menu tabs and above your records. By default, this area contains the [Action Icons] that allow you to perform actions and navigate to different [Views] of your data. <img class="border" src="attachments/developer.qrimp.com-d26922e7-cfd9-41b7-bf0b-b117d3ff7c2f/contentheader.png" /> <span class="small">A default content header with a custom message to users of the products table.</span> Content Headers are completely customizable with a combination of custom messages, [HMTL], [CSS] and [JavaScript]. You can add [Icons], error messages, warnings, shared data, external links, queries and more. (See: [Headers and Footers]). <img class="border" src="attachments/beedb418-951d-4e64-93a3-e2032bbf0101/2008-12-14contentheader.png" /> <span class="small">A customized content header with fewer icons than normal.</span> <h2>Advanced: For CSS and Javascript in Content Headers</h2> For [CSS], declare #contentheader to style the content header.	Above and beside your data
111	Writing Operations	Writing operations in Qrimp is similar to writing stored procedures. You can use existing operations as templates to build your new operations. To view existing operations go to Admin > Operations. You can use wildcards with % around a word that you want to restrict your query on. ie: like '%overdue%'.	Operations
112	Using Operations in urls	You can use operations in urls when you are creating [Menus] tabs, adding internal links, editing the action that is behind an [action icon] link or in any other internal Qrimp app links. An operation goes to the table in the url and performs a certain action on it. <strong>Composing the URL</strong> To use an operation in a link, simply add "&o=" plus the operation number to the url. An example of a url with an operation restriction would be: <strong>http://myapp.qrimp.com/db.aspx?t=Clients&id=82&o=4</strong>. When the user clicks this link, they will delete record 82 from the clients table. <h2>Operation Permissions</h2> If you create a link using an operation, and the user who can see it does not have permission to perform the operation, they will see the login screen and the error message "you do not have permission to _read__ the _Clients___ table". To give your user permission, you must set up the correct [Table Security].	Operations
113	Known Issues	Some things are not yet possible with Qrimp. (We know, hard to believe!) Here's a list of things that have caused our users trouble in the past.
115	Search	At Qrimp, we know that sometimes the easiest way to find something is with a search. We have three default ways to search your app: [Site Search] [Date Search] and [Table Search] Advanced users can also add a search form to the top of any Table see [Table Search Box]	Navigation
116	Menu Tabs Hide Action Icons	If you have too many tables and/or a narrow browser window, you may find that your menu tabs overlap the [Content header] area of your site, obstruction your view of the [Action Icons]. To resolve this issue, you can sometimes press Ctrl and the minus key (Ctrl-) to reduce the text size on the tabs and move them up. We are working to resolve this issue.	Known Issues
122	Synchronizer	To use synchronizer to work offline, you will have to have <a href="http://learn.iis.net/">IIS7</a> web server software and the database <a href="http://www.microsoft.com/sql/editions/express/default.mspx">SQL Server 2005 Express</a> (free) installed on your computer.	Working Offline, Backing Up, Getting Data out
123	Before You Start	<!--<nobreak>--> <p>Before you get started, think about what your application is for. Which information do you want to track? Which types of users do you want to have? Who will be able to view and change your data?</p> <p>You may wish to start with a data model. If so, read our [Brief Intro to Data Modeling].</p> <h2>Basic steps to creating a Qrimp app</h2> <ol><li>Designing your data model</a></li><li>[Create Tables] <ul> <li>Option 1: Create Tables Manually</li> <li>Option 2: Import Data</li> </ul></li><li>[Entering and Editing Data]</li><li>Customize your Application with<ul> <li>Views</li> <li>Templates</li> <li>Headers and Footers</li><li>Security</li> <li>Menus</li></ul></li></ol> <p>We recommend drawing out a list of tables and listing the columns you want to have before you get started. You can add additional tables, add rows, delete rows, change data types, and drop columns at any time, so nothing is set in stone. Having a structured idea of what type of database you will build before you start will save you time and help you mentally organize your information first.</p> <p>There are many resources on the web that teach you about database methodology.<!--We have gathered some links for you here: <a href="db.aspx?t=HelpTopics&id=55&vid=11">Designing your data model</a-->.</p> <p>Of course, you can also get started with no learning, and figure it out as you go! A good place to start is by adding your first data table. There are two ways to add data: [Create Tables] and [Import Data].</p> <!--</nobreak>-->	An Introduction to Qrimp
124	Table Settings	Everything in your Qrimp app is stored in a table, even information about tables. The Table Settings view allows you to modify information about those tables, including which field to use to represent information in the table and which HTML View Template to use as the default if no view is specified. <div class=warning>Renaming tables with the rename link can cause trouble if anything else in the app or on the internet links to the table. Try updating just the name in the name box or the Title of the table first.</div>	Manage Tables
126	Action Icons	These icons generally appear in the [Content Header], which is displayed at the top of your table below the [Menus]. <img src="attachments/16a4647b-af66-4cc7-8048-a4602798d624/ActionIcons.png"> <h2>Default Icons</h2> When you build a new table in your Qrimp application, icons are created automatically based on the functionality that is possible within that table and according to the [User Groups] permissions. You can add or delete icons if you need more or less functionality. You can even create new actions by writing your own [operations] then choosing icons from the /icons/crystal_project/32x32 and putting them in the [Headers and Footers]. <h2>Editing Actions</h2> Go to the table and view you want to change the actions for. Then go to Develop > Header/Footer. You will see the HTML for the icons. If nothing is listed, you will need to edit the default header / footer for your table, which is part of the [table definition]. The following are some default icons you will see in your Qrimp app. <h2>Views Icons</h2> These icons allow you to change the way you are viewing the data. To learn more, read about [Views]. <img src="/attachments/d8b7ffcf-fc7d-4ec9-ae46-a5428e455455/CalendarIcon.png"> [Calendar View] <img align=absmiddle src="icons/crystal_project/32x32/actions/view_tree.png" alt="Tree View"/> [Tree View] <img align=absmiddle src="icons/crystal_project/32x32/actions/view_text.png" alt="Grid View"/> [Grid View] <img align=absmiddle src="/icons/crystal_project/32x32/mimetypes/spreadsheet_document.png" alt="Reports"/> [Reports] <img align=absmiddle src=/icons/crystal_project/32x32/actions/next.png alt="Next Item"> Next Item - see [NextPrevious] <img align=absmiddle src=/icons/crystal_project/32x32/actions/previous.png alt="Previous Item"> Previous Item - see [NextPrevious] <h2>Data Editing Icons</h2> Add records, edit or copy existing records, search and delete your data and more. <img align=absmiddle src="icons/crystal_project/32x32/actions/edit_add.png" alt="Add New"/> Create View <img align=absmiddle src="icons/crystal_project/32x32/actions/filefind.png" alt="Search"/> [Search] <img align=absmiddle src="icons/crystal_project/32x32/apps/kmenuedit.png" alt="Edit Table Display"/> View [Headers and Footers] <img align=absmiddle src="/icons/crystal_project/32x32/mimetypes/kivio_flw.png" alt="Design"/> [Design View] <img align=absmiddle src="/icons/crystal_project/32x32/actions/cancel.png" alt="delete"> [Delete] <img align=absmiddle src="/icons/crystal_project/32x32/actions/undo.png" alt="Cancel"> [Cancel] <img align=absmiddle src="/icons/crystal_project/32x32/mimetypes/file_temporary.png"> [Versioning] <h2>Advanced: Hiding Icon Labels in the [Content Header]</h2> If you do not want to see the word that corresponds to the icon below the icon, you can change the stylesheet to #contentheader.label{display:none} or you can write a sql statement to remove them from all or selected tables. See [Stylesheets], [CSS] and [Using SQL Statements].	Content Header