Search the help documentation

Search:

Can't find what you are looking for? Use the Feedback tab in your app to submit an issue, or email support@ qrimp.com.


idnamedescriptionParentTopic
deleteedit185Input Security RestrictionsTo add additional security around data Qrimp allows you to add white and black lists.

A Whitelist will only allow the characters specified in the list.

A Blacklist will strip out the characters specified in the list.

To add either functionality to a system the first step is Develop > System Tables.

<img src="/attachments/f4f304ca-0b5b-4e8c-89b1-85ee86b74279/Security5.jpg">

Then click on the t_groups WITHOUT the magnifying glass.

<img src="/attachments/abb21f03-1668-48e8-a0a7-82df4892155f/Security6.png">

To add the additional field to the table click on the Table Management Icon in the [Content Header]

<img src="/attachments/0ea6eb9a-40f6-4f4a-89d3-34398246ec58/S.png">

Scroll down to "Add a Column" and input either inputwhitelist or inputblacklist all one word

<img src="/attachments/d628e2dc-67b7-4906-a578-b097597ea4ba/Security8.png">

Once the column is added there are two steps. First you must log out and log in to make the change take effect. Then go back to the table and click Design > Field Layout to move the field to a usable spot.

It should look like this when complete. Now click the Edit Icon in the [Content Header] enter in the characters that can ONLY be entered. For this example lets say I don't want numbers. I will only include the 26 letters of the alphabet and click save.

<img src="/attachments/651ac779-8356-460b-8f2f-a3b3f84ea600/Security9.png">









The System Tables
deleteedit188Dependent Select BoxesSometimes it is convenient to allow users of your Qrimp application to filter the items in one select box by choosing an item in another select box. For example, when choosing to examine fuel economy by vehicle, because there are hundreds of different types of cars, you could let your users filter by Make, and then show only the particular models for that make in another box.

In this Help Topic, we will use another example that fits with our Campaign Contributions system, where when choosing a candidate to add a contribution for, you can filter the list by the candidates party. We'll end up with a dependent select box like the image below:
<img src="http://www.qrimp.com/blog/dependent_select_box.png" style='border:solid 1px navy' />

Here is a video that shows the dependent select boxes in action:
<div style='border:solid 1px navy'><object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="322" height="184" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/dependent_select_box_animated.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/dependent_select_box_animated.swf" width="322" height="184" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object></div>

To get started, we will first go to the Add New screen for the Contributions. Notice the default select box has only a list of candidates:
<img src="http://www.qrimp.com/blog/contributions_addnew.png" style='border:solid 1px navy' />

From the add new screen for contributions, select Design > Field Templates:
<img src='http://www.qrimp.com/blog/contributions_field_templates.png' style='border:solid 1px navy' />



Next, we will click the edit icon for the Candidate column. Since we have not modified the template for this field yet, Qrimp has created one for us automatically that looks like this:
<img src="http://www.qrimp.com/blog/default_candidate_field.png" style='border:solid 1px navy' />

To add a select box for Parties that will filter the candidates list, we will edit the field template to look like this:
<img src='http://www.qrimp.com/blog/candidate_field_template_with_filter_by_party.png' style='border:solid 1px navy' />

Notice we have inserted this block of text before the Candidate select box:
<noeval><blockquote style='border:solid 1px navy;background-color:lightgray'></blockquote></noeval>

This tells Qrimp to create a select box that will filter the Candidate select box and show only those candidates where the party is equal to the party we select in the Parties select box.

If we want to hide the Candidates select box until a selection in the Parties select box has been made, we can use code like this:
<noeval><blockquote style='border:solid 1px navy;background-color:lightgray;'> then <span id=Candidate_selectbox>Candidate</span></blockquote></noeval>

The span indicated with the id <strong>Candidate_selectbox</strong> is the location where Qrimp will display the list of candidates in the party that we choose in the Parties box. This example behaves like the video below:

<div style='border:solid 1px navy'><object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="387" height="342" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/dependent_select_box_hide_original_select.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/dependent_select_box_hide_original_select.swf" width="387" height="342" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object></div>

Your final output should be in this format:
<pre>
then <span id='TABLE_WITH_DATA_TO_FILTER_selectbox'>COLUMN_NAME</span>
</pre>
The code above is telling Qrimp to display a SELECT box with data that is used to filter another select box that ultimately has the list of items of which one is the desired selection for the field in this table.

So for example, if you are creating a trouble ticket system for equipment and have 100 pieces of equipment, each with an EquipmentType and you want to make it easy for your users to select just one piece of that equipment, you'd use a command like the following:
<pre>
then <span id='Equipment_selectbox'>Piece of Equipment</span>
</pre>



Field Templates
deleteedit1284"..." in the Grid ViewFields with a lot of data will be converted to a "..." to preserve space in the [grid view]. If you hover over the "..." you will see a small box pop-up that shows the data in that field.

<img class="border" src="attachments/developer.qrimp.com-5d91c5c7-914a-4d4e-a959-8d3053a9b772/dotsinthegridview.png" />

If you want to see the full text in the grid view, you will have to edit the field template (See <a href="db.aspx?t=helptopics&id=7&vid=11">Field Templates</a>) for that record. The easiest way to do this is to turn [design mode] on. Go to Design > Design Mode On.

<img class="border" src="attachments/developer.qrimp.com-987b9879-2d1b-4d51-8275-220c47408226/designmodeon.png" />

A gear icon will appear near the top right every field that has a field template. Click the gear to edit the template.

<img class="border" src="attachments/developer.qrimp.com-e57aead3-38e4-4a4c-aedb-c360d05180bb/designmodegridview.png" />

You can see that the "..." is coming from this template.

<img class="border" src="attachments/developer.qrimp.com-170722e7-844c-4dd3-8576-8c67456a5a58/editingafieldtemplate.png" />

Change the ... to <noeval>[DATA]</noeval>. Then click save.

<img class="border" src="attachments/developer.qrimp.com-b14d4142-58c9-438e-83f3-1ca5e62ca66b/re-enterthefieldtemplate.png" />

Your full field (description) will now appear.

<img class="border" src="attachments/developer.qrimp.com-b817d7ea-55aa-4d37-983a-b5486cd42ad4/itemtemplatefulldescription.png" />


Field Templates
deleteedit1286Design ModeDesign Mode is a tool that lets you quickly edit [Field Templates] to change the display of your fields in any table and any view.

To turn design mode on, go to Design > Design Mode On.

<img class="border" src="attachments/developer.qrimp.com-987b9879-2d1b-4d51-8275-220c47408226/designmodeon.png" />

A gear icon will appear near the top right every field that has a field template. Click the gear to edit the template.
Field Templates
deleteedit1287Add a Link to the Activity Log from the Grid ViewBy default, the [grid view] has an icon that lets you edit that record and an id link that you click to view the record detail ([Detail View]).

<img class="border" src="/attachments/developer.qrimp.com-b681d8c0-2b46-47b5-8d74-7f9c2521b0a3/clicktoeditclicktoviewdetail.png" />
<span class="small">The default icon and link in the grid view</span>

If you have activity logs on your site, you can add an icon that links to the activity log for that table.

<img class="border" src="/attachments/developer.qrimp.com-fdc13229-1b34-4337-a453-a84a837f3ddc/gridviewwithactivitylogicon.png" />
<span class="small">Our goal is to add an icon like this</span>

<h2>Copy the Link to the Activity Log</h2>
In this example, we will use the clients table.

Go to the grid view of the clients table.

<img class="border" src="/attachments/developer.qrimp.com-24a4d44c-5fe0-4b8a-b7bc-da044226d3f2/gotogridview.png" />

Click the id number "1" next to the first record.

<img class="border" src="/attachments/developer.qrimp.com-39db89c9-ed5b-494c-a891-f9db3ca1a9bf/clicktheidlink.png" />

----

You will see the Detail View. On the right of the detail view is the Activity Log for this client.

Click the link at the top of the box that says "ClientsActivityLog".

<img class="border" src="/attachments/developer.qrimp.com-c742f7ea-fa24-4bf7-a778-c30d98928972/clickclientsactivitylog.png"/>

----

You are now on the page that shows all of the activity for that client.

Go to the [location bar] of your browser and copy the url, starting at "db.aspx..."

<img class="border" src="/attachments/developer.qrimp.com-8bff1b55-d8ee-4b0f-9e5b-20b07bd563d1/copylinktoactivitylog.png" />

<h2>Open the field template</h2>
Go back to the grid view of the clients table.

<img class="border" src="/attachments/developer.qrimp.com-aa6d461b-25c3-4ee0-a1b3-e6966dd262aa/gobacktogridview.png"/>

----

Turn design mode on by going to Design > Design Mode On.

<img class="border" src="/attachments/developer.qrimp.com-987b9879-2d1b-4d51-8275-220c47408226/designmodeon.png" />

----

A gear icon appears near the top right every field. Click the gear above the id field to edit the template.

<img class="border" src="/attachments/developer.qrimp.com-fe340989-67a0-4011-8cb6-426485c93f05/clickthegearicon.png" />

----

A text box for the item template will appear. You will see some [HTML].

<img class="border" width="400" src="/attachments/developer.qrimp.com-aa8fed66-da02-43fd-91d0-6440b3121484/itemtemplatepopup.png" />

<h2>Paste the url into the template</h2>
You will have to paste the link you copied into this HTML code. Then you have to format it to make it a link.

The HTML in your textbox looks similar to this:
<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" title="View Details">[DATA]</a></textarea>

<h2>Make your url a link with anchor tags</h2>
Put your cursor between the two "a" tags after the edit icon:

<img class="border" src="/attachments/developer.qrimp.com-f9e6aeb9-b183-46c7-8058-06b1f9a98a88/pastethelinkintothefieldtemplate.png"/>

Paste the link into the HTML "db.aspx?t=ClientsActivityLog&orderby=1&orderby=1&OwningRecordID=1".

<img class="border" src="/attachments/developer.qrimp.com-3fa675b6-10c8-4a14-9e1a-fc1e2a500720/thelinkwithanchortag.png"/>

Change the OwningRecordID from "1" to <noeval>1287</noeval>.

<img class="border" src="/attachments/developer.qrimp.com-08c23893-0cb1-4ab5-b9c9-5321f4d37da8/thelinkwithsquarebrackets.png"/>

Then wrap the link with an "a" tag. Put the following text around your link:<textarea><a href="db.aspx?t=ClientsActivityLog&orderby=1&orderby=1&OwningRecordID=1287"></a></textarea>.

<img class="border" src="/attachments/developer.qrimp.com-f44dbd12-52d6-4ee4-9721-e4374499874e/thelinkhighlighted.png"/>
<span class="small">Type carefully! Every symbol is needed!</span>

<h2>Step 4: Add the icon</h2>
Put the image icon between the a tags. You can copy the img tag from below:
<textarea><a href="db.aspx?t=ClientsActivityLog&orderby=1&orderby=1&OwningRecordID=1287"> <img align=absmiddle src=/images/webexview.gif height=20 width=20 border=0 alt="edit"> </a></textarea>.

<img class="border" src="/attachments/developer.qrimp.com-8243f280-9c4e-43e2-bfb1-db2866f110ab/theimginthefieldtemplate.png"/>
<textarea><a href=db.aspx?t=tHelpTopics&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=ClientsActivityLog&orderby=1&orderby=1&OwningRecordID=1287"><img src="/images/ico_activitylog16.gif" height=20 width=20 align=absmiddle border=0 alt="ViewActivityLog"></a><a href="db.aspx?t=HelpTopics&id=[DATA]&vid=11" title="View Details">[DATA]</a></textarea>

Click Save!

<img class="border" src="/attachments/developer.qrimp.com-b70dad5f-be9d-4eb6-b357-0ef00550c590/savefieldtemplate.png" />

Now, you can click the icon to see the Activity Log for a client record!

<img src="/attachments/developer.qrimp.com-102eb6f5-65b2-4d6d-919d-967b7631903a/clicktheactivityloglink.png" />		Field Templates
deleteedit38Introduction to Tables<!--<nobreak-->
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].
<!--</nobreak>-->		An Introduction to Qrimp
deleteedit39Brief Intro to Data Modeling<h2>What is a data model?</h2>
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.

<h2>Why model data?</h2>
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.

<h2>Example</h2>
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 <strong>table </strong>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 <strong>names</strong> and <strong>hire dates</strong>, 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".

<strong>In other words...</strong>
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:

<a href="http://en.wikipedia.org/wiki/Table_(database)">Table (database)</a>
<a href="http://en.wikipedia.org/wiki/Relational_database">Relational Database</a>
<a href="http://en.wikipedia.org/wiki/Data_modeling">Data modeling (wiki)</a>
<a href="http://en.wikipedia.org/wiki/Database_normalization">Database normalization</a>
<a href="http://bytes.com/forum/thread585228.html">Database normalization discussion</a>.		An Introduction to Qrimp
deleteedit123Before 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
deleteedit79Group Menu VisibilityGroup 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
deleteedit80Add A Sub-Menu TabYou 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
deleteedit105Clear Menu CacheUnder 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
deleteedit155Tutorial - MenusHere you'll learn a little more about the system menus that come with all Qrimp apps and also how to control the visibility of menus for your users and anonymous browsers from the Internet. We'll also add read access for the anonymous users so they can see the data in your tables.

<object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="1026" height="786" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/2008-07-05_0157.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/2008-07-05_0157.swf" width="1026" height="786" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>		Menus
deleteedit1313Add a Menu LinkMenu links to your tables and to other areas of your app such as [Dashboard] and Admin, Develop and Design (if a user is permitted).

To add a menu tab, go to Develop > Manage Menus then click the Create Menu Item button.

Enter the following information:

Name: The word that will appear in the Menu Tab.

Link template: Enter the url that you would like users to land on when they click the tab. It is easiest to navigate to the data and the view (see Views) first, then copy/paste that url.

Parent Menu: Choose a top level menu tab to show your menu in a sub-menu below it.

Description (Optional): Enter a description.

Icon (Optional): Click the edit link and choose an icon.

Security: Select which groups can see the menu tab (See also [Group Menu Visibility]).
Menus
deleteedit1316Edit a Menu TabYou can change the text on a menu tab to say anything.

You can also edit where a user goes when they click on a menu.

If you want to change the link the menu tab goes to, first go to the table and view you want to change it to, then copy the <a href="db.aspx?t=HelpTopics&id=261&vid=11">url</a> to your clipboard.

<img class="border" src="attachments/developer.qrimp.com-4a60b8ae-9553-4b5d-bb91-656ca384dbc6/copyurl.png" />
-------

Now, go to Develop > Manage Menus.

<img class="border" src="attachments/developer.qrimp.com-dbb79dc0-6efa-4c51-9b2e-3dea23fd225b/developmanagemenus.png" />
----

Click "Edit Menu Item".

<img class="border" src="/attachments/developer.qrimp.com-8bb4f48f-a21d-4a8e-b95d-2d00450693ea/editmenuitem.png" />
----

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

<img class="border" src="attachments/developer.qrimp.com-b1cd5ea1-d527-46f2-bdc8-153798c462ad/clickonmenuitem.png" />

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

<img class="border" src="attachments/developer.qrimp.com-ec76b211-43de-4ba6-ada9-729d441c0e1a/addmenudetails.png" />
----

Now, try clicking on the menu tab to make sure it worked.
Menus
deleteedit1266Hide All Access to a tableBesides deleting a table, the best way to make sure that nobody sees it again is to use [Table Security] to make it so that all user groups have no [CRUD] permissions on the table.

Follow the instructions in [Table Security] but turn off all permissions, like this:

<img class="border" src="attachments/developer.qrimp.com-70a940d9-ffa3-47ba-8812-f7c5b034b9ae/maketableinactive.PNG" />

Table Security
deleteedit72Drop a ColumnTo 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!		Manage Tables
deleteedit124Table SettingsEverything 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
deleteedit265Changing a DatatypeTo change the [datatype] for a field, go to your table, then to Develop > Table Management.

Choose the field that you want to change and click 'change datatype'.

<img class="border" src="/attachments/c8ae671f-4210-4ab4-a9cf-848a68f2470d/ChangeDatatypeLink.png" />

In the dialog box, select a new datatype from the drop-down list.

<img class="border" src="/attachments/ab431970-6824-42f2-b9e1-164566e1d93b/ChangeDatatype.png" />

<h2>Before you Convert</h2>
Make sure your data is clean. Use the [grid edit] view and sort by the column you wish to convert to a drop-down.

You would not want to change this data to a drop-down:

Category:
Restaurant
Gas Station
Reeatruant
Restaurant
Grocery Store
Diner
Grocery STrore
Gas Station
Restaurant
GroceryStore

If you converted data like that, every time someone was picking from the drop-down they would see all the misspellings!

So take the time to correct them first.		Manage Tables
deleteedit1267Deleting a TableGo to Develop > Manage Tables

Find your table and click the delete link:

<img class="border" width="550" src="attachments/developer.qrimp.com-0ecb3fc3-22b8-470c-9df8-4be9df9de6b8/deletetable.png" />

You will be prompted to make sure you really want to delete the table:

<img class="border" src="attachments/developer.qrimp.com-f72f6273-f799-443e-a89d-3c71376c3c53/deletetablewarning.png" />

<strong>Deleting a table is final!</strong> If you are sure you won't ever need any of the data in this table again at any point in the future, go ahead and click yes.

If your table had relationships, you will be warned about those connections so that you do not have orphaned records.

Manage Tables
deleteedit1319Table ManagementDevelop > Manage Tables

You can click the edit link for the table to edit the columns and field types for your tables. You can also manage [group security] and [column security] as well. Click the settings link to change the title of the table, enter default templates and pick the field to show in drop downs or links to items in the table. You can also enter an [SQLSecurity] clause to restrict access to records in your table or [show and hide items in a drop down box].		Manage Tables
deleteedit17Notification SubscriptionsSend site administrators and users custom [Notifications] when new data is added to your Qrimp application or when people sign in.Notification Subscriptions
deleteedit154Tutorial - Email NotificationsIn this tutorial, you'll see how to add a notification so you can be alerted by email when changes are made to information in your Qrimp App. We also briefly jump into some table management to make a field a bit bigger. We'll also customize the notification template so that we see only information that meets certain criteria.

<object id="csSWF" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="1026" height="786" codebase="http://active.macromedia.com/flash7/cabs/ swflash.cab#version=9,0,28,0"><param name="src" value="http://www.qrimp.com/blog/2008-07-05_0124.swf"/><param name="bgcolor" value="#1a1a1a"/><param name="quality" value="best"/><param name="allowScriptAccess" value="always"/><param name="allowFullScreen" value="true"/><param name="scale" value="showall"/><param name="flashVars" value="autostart=false"/><embed name="csSWF" src="http://www.qrimp.com/blog/2008-07-05_0124.swf" width="1026" height="786" bgcolor="#1a1a1a" quality="best" allowScriptAccess="always" allowFullScreen="true" scale="showall" flashVars="autostart=false" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></embed></object>
Notification Subscriptions
deleteedit232Notification ParametersAfter you have subscribed a user to a notification (See: [Notification Subscriptions] [Notifications and Custom Notifications]), you can set notifications to be sent only when certain parameters are met. For example, you can send a notification to your sales rep Evelyn only when the order type is wholesale.

To set up a filtered notification, go to Admin > Notification Subscriptions and select the notification to filter.
<img class="border" src="/attachments/developer.qrimp.com-65b33786-c4ea-4bff-b3c0-98456fe4b17b/notifications subscriptions menu.png" />

Click the link on the far right that says 'Set Parameters'.
<img class="border" src="/attachments/developer.qrimp.com-bb13bf70-368a-4459-afb4-bcea6282eed4/notification subscription to filter.png" />

Now you are on the Notification Parameters page. At the top, you will see the notification you are setting up.
<img class="border" src="/attachments/developer.qrimp.com-d7159eda-767e-4f6a-936d-8288e408f9d2/notification to filter.png" />

If any previous filters have been set, you will see them under "Current Parameters".
<img class="border" src="/attachments/developer.qrimp.com-80fd93fb-7661-492e-b3f3-4ec7c4f0ee73/notifications current parameters.png" />

Select your parameters, then click "Save".
<img class="border" src="/attachments/developer.qrimp.com-911170fe-430e-44fc-8a21-5e58d6b65720/notifications set parameters.png" />

From now on, when a new Wholesale Order comes in, Evelyn will get an email about it. The email will look like this:

<img class="border" src="/attachments/developer.qrimp.com-f67575af-e944-48fc-93f4-be61bc05b119/notification parameters email.PNG" />

Note: Evelyn will no longer get an email for <em>every</em> order, only New Orders that are Wholesale. If you would like her to also get an email for every order, you must create a new, separate notification subscription.

You can change what the email notification says and what it looks like with [Notification Templates].





Notification Subscriptions
deleteedit234Notification Templates<!--<nobreak>-->
<p>Notification Templates determine the text, images, links and design elements that are in notifications.</p>

<h2>Existing Templates</h2>
<p>Qrimp comes with the following default notification templates: UPDATE, CREATEACCOUNT, APPROVEACCOUNT, PASSWORDRESET, LOGIN, NEWMAIL, ACCOUNTREQUEST, New Suggestion, and New Comment On Suggestion. Use these default templates as the basis for your notifications. You can Copy these to create your own notifications. This will give you a head start on the content that can be displayed. You can also add new templates and start from scratch. </p>

<h3>Update</h3>
<p>Update is by far the most frequently used notification template. This basic template can be used to inform users that new records have been added to tables in your database. </p>

<h2>What's in a Template?</h2>

<h3>Square Brackets</h3>
<p>Notification templates rely heavily on [Square Brackets] to pull information from your database to the email in an automated fashion. Using [Square Brackets] you can show a user the name of the app in the email, which table and item was affected, which user made a change, the date the change was made, and more. Start with the default notification templates and copy/paste pieces of square brackets notation into your notifications.</p>

<img class="border" src="/attachments/developer.qrimp.com-492da2f8-7ce0-44c4-bd44-68b7c0a2422b/notification%20template%20template.png">

<h3>CSS and HTML</h3>
<p>Users familiar with CSS can also include the "<'style'>" tag to put design elements in the notification, such as fonts, colors, borders, backgrounds and more. Depending on the user's email client, the styles may show up differently. If a recipient shows text-only emails, these design settings may not make it through.</p>
<!--</nobreak>-->		Notification Subscriptions
deleteedit107Creating a Look-up TableA 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
go to page: 1 2 3 4 5 6 7 8 9 10 243 records. Showing