Tree View
Tree
List View
Alphabetical List
Share
Share
Search:
id:
1274

name:

Custom CSS



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


ParentTopic:
 

id:
1275

name:

CSS



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


ParentTopic:
 

id:
1276

name:

Change your skin



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



ParentTopic:
 

id:
1277

name:

Delete an Attachment



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


ParentTopic:
 

id:
1278

name:

Attachment Permissions



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


ParentTopic:
 

id:
1279

name:

User Group Settings



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


ParentTopic:
 

id:
1282

name:

Delete Multiple Attachments



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


ParentTopic:
 

id:
1283

name:

Edit an Existing Custom View



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


ParentTopic:
 

id:
1284

name:

"..." in the Grid View



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






ParentTopic:
 

id:
1285

name:

JavaScript



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


ParentTopic:
 

id:
1286

name:

Design Mode



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


ParentTopic:
 

id:
1287

name:

Add a Link to the Activity Log from the Grid View



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


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


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




Click Save!



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



ParentTopic:
 

id:
1288

name:

Copy a Record



description:
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).



ParentTopic:
 

id:
1289

name:

Hiding columns with CSS



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


ParentTopic:
 

id:
1290

name:

Configuring Imported Tables



description:


ParentTopic:
 

id:
1291

name:

Form Field Layout



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


ParentTopic:
 

id:
1292

name:

Radio Button



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




You can enter radios into field templates using square brackets.

[radios:yesno:[DATA]:autoupdate]


ParentTopic:
 

id:
1293

name:

Find the ID number of a Table



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



ParentTopic:
 

id:
1294

name:

Hiding fields



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




ParentTopic:
 

id:
1295

name:

Separate name and address fields (From WebOffice)



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


ParentTopic:
 

go to page: 1 2 3 4 5 6 7 8 9 10 11 12 13 243 records. Showing