You can use CSS to style any part of your Qrimp app. If you only want the style to be applicable to a particular page, table or view, you can write the CSS in a style tag in views or headers and footers.

CSS stands for Cascading Style Sheets. This is the code that determines the colors and positions of elements in your web app.

You can change the look and feel of your site in an instant by changing the skin. The skin is the CSS code that determines the colors and positions of elements in your app.

To change your skin, go to Design > Skins.



Select a different skin from the drop-down and click "Select Skin".



Now your site will look different:

To delete a single attachment, go to the record that your item is attached to. Click the attachments link on the right-hand side at the top.



Click the delete icon next to the item you want to delete:



You will get a warning asking whether you are sure you want to delete this item. Click Okay to delete.



Your item will be deleted from your database.

User accounts need the appropriate security permissions to add attachments. An admin can grant permission to a user to upload attachments by going to Manage Users > Manage Security Groups and clicking "yes" under Enable Uploads. (See User Group Settings)

On the User Security Page you can allow or disable the following options by group:

AllowHTMLInFields

Should this user group be allowed to write HTML? HTML fields can change the appearance, color, style, font and layout of your data.

AllowScriptInFields

Should this user group be allowed to write scripts, such as Javascript? Scripts should only be given to trusted users, as they can be used to alter your system.

Allow Edit CSS

Can this user group to edit Cascading Style Sheets?

EnableUploads

Can this user group upload attachments to your Qrimp app?

Show Export Options

Can this user group see export options to export data from your tables?

Show related data

Should the group see related data?

Default Start Page

The default start page is what a user sees when they first log in. If you do not change this setting, all users see the Dashboard.

See Change the Default Start Page

Input Black List

If the user group has permission to enter HTML, which characters can they not enter?

To delete multiple attachments, go to the record that your items are attached to. Click the attachments link on the right-hand side at the top.



Click the checkboxes beside each item you wish to delete:



You will get a warning asking whether you are sure you want to delete all of these items. Click Okay to delete.



Your items will be deleted from your database.

To edit an existing custom view, go to the grid view of your table.

Choose the view you want to edit from the drop-down list of views.

Click the link that says "Edit View"



Edit your view to suit your needs.

See also Custom Views (Sorting and Filtering)

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



If you want to see the full text in the grid view, you will have to edit the field template (See Field Templates) for that record. The easiest way to do this is to turn design mode on. Go to Design > Design Mode On.



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



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



Change the ... to [DATA]. Then click save.



Your full field (description) will now appear.

JavaScript is a type of code that is used with to make the elements of a page interactive.

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



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

By 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).


The default icon and link in the grid view

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


Our goal is to add an icon like this

Copy the Link to the Activity Log

In this example, we will use the clients table.

Go to the grid view of the clients table.



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



----

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



----

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

Open the field template

Go back to the grid view of the clients table.



----

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



----

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



----

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

Paste the url into the template

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:
<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>

Make your url a link with anchor tags

Put your cursor between the two "a" tags after the edit icon:



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



Change the OwningRecordID from "1" to [id].



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


Type carefully! Every symbol is needed!

Step 4: Add the icon

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


<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=[id]"><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>

Click Save!



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

If you are entering new records that have very similar data to existing records, you can start from a copy of an existing record.

To copy a record, first go to the edit view of that record.

Click the "Copy" button at the bottom of the record. You will be taking to the detail view of your new record, and will need to click the edit icon again to enter the new data.



Be careful here and proceed slowly to make sure that you enter new data in the copied record, and do not overwrite the original record. Look at the location bar of your browser and check that the record has a higher id number than the original. (See AutomaticIDs).

You can hide columns for a view of a record or table using CSS.

Go to Develop > Header/Footer. In the header field, add the following style to hide the id, createid, and createdate fields. CSS is not supposed to be case sensitive, but just in case of browser bugs, make sure your div names are identical to the div in the HTML.



Notice that each field name is followed by the word div. So to hide another field named StartDate, you'd use this:



To do the same for Grid/Table views use this style definition in the header:

If your system was created from imported data, here are a few things you may wish to do:

Re-order columns

Change your Table Security

Add a Calendar List to your Dashboard

Change your skin

Change your logo

Set up Custom Views (Filtered and Sorted Reports of your data)
Edit an Existing Custom View

Convert a Field to a drop-down
Add a drop-down Field
Hide Inactive Fields from drop-downs
Change a field to a drop-down Make sure you have clean data first! Try out grid edit and sort by the field you want to convert to a drop-down.

We have changed the name of the form field layout feature. Please see Form Designer.

A radio button is an interface input to a datatype that has two options. It shows up as two small circles. When one option is selected, a dot appears in the selected circle.

Canceled:
No Yes

You can enter radios into field templates using square brackets.

[radios:yesno:[DATA]:autoupdate]

Every table in Qrimp is automatically assigned an id number. (See AutomaticIDs)

To find the id number of a table, go to Develop > Table Management.

Find your table in the list and note the id # that appears in brackets beside your table name.

You can hide fields from ever appearing in the grid view.

In this example, we are going to hide the 'email' field from the Clients table.

Go to your table.

Go to Design > Form Designer

Click the link on the right that says "Edit Column Labels"



Wait for the Grid Edit view to load.


Click HideinColumn for field you want to hide.


Change the field to say "Y" or "yes" to hide it.

If you are coming to Qrimp from WebOffice, this applies to you.

If you used the "name" or "address" datatypes when you built your WebOffice, the WebOffice back-up tool concatenates your separate name and address fields into one field. For example, if you had FirstName, MiddleName, LastName they would all be merged into one Name field.

If you want to re-separate the fields, follow the steps below. Note that there are two ways to pull the data into your app.

Step 1 for both options: Create Separate Fields

In your Qrimp app, Add columns for FirstName, MiddleName, LastName or Address1, Address2, City, State, ZIP, to the affected database table.

You now have to choices about how to get the separated data into those fields:

Option 1: Fast Qrimp Update Statement and Manual Review of Fields

Let your Qrimp rep know when you have separated your fields. A Qrimp support person will run a big update statement that will update all your records with the broken out data at no additional charge. You will need to review the data that is created, as it may have some problems which will need to be fixed manually. This option requires less work but doesn't give perfect results. Some of your data may not split properly depending on punctuation, spelling and symbols in the fields.

Option 2: WebOffice Custom View and Thorough Qrimp Update Statement

Create a custom view in your WebOffice that breaks the Name/Address fields out, then a Qrimp rep updates your app. Qrimp charges at our Hourly Rate for this service. Each table will take about 2 hours. This is more thorough than Option 1. It requires more work on your part, but gives the best results possible. This solution can be problematic if WebOffice does not provide a UniqueID field. A UniqueID field is only provided in some cases.

Steps to Complete Option 2

Go to your WebOffice. Create a custom view that breaks the NAME and ADDRESS fields out into individual columns for each portion of the name and address. This view must include the UniqueID of the record in the view.

Export your data to a .csv file, then import it into your Qrimp app as a new table. Name the new table "ClientMap".

Let your Qrimp rep know when you are finished with this and they will run an update query that updates all the records with what WebOffice exports in that custom view.

Note: If WebOffice doesn't provide the UniqueID, then we have to find some other field(s) to use as a unique identifier to update the records and that's not always possible depending on the data.