|1325||Building Your System||Everything you need to know about how to build an app in Qrimp.||
|1326||Working Offline, Backing Up, Getting Data out||
|1327||Add My Task List to a Portal||A list of tasks on your [Dashboard] can help you see what you need to do this week. You will need to have a tasks table.|
In your menus, go to Tasks.
<img class="border" src="attachments/developer.qrimp.com-e9fb95cf-d97d-4c1b-8196-e71bd73a331e/gototasksmenu.png">
You will see a list of all tasks.
<img class="border" src="attachments/developer.qrimp.com-91655928-9af7-49a0-be3c-19d658c27e8e/taskslist.png">
Search the tasks list for tasks that are assigned to you.
<img class="border" src="attachments/developer.qrimp.com-feb0c8af-bc8b-4307-b95c-30737f509286/tasksassignedtodropdownsearch.PNG" />
Now that you see a list of tasks assigned to you, look at the bottom of the page, below the tasks. There is a link that says "Share". Click the share link.
<img class="border" src="/attachments/developer.qrimp.com-057e6e67-b784-4916-bce7-684f1f5cdeb6/tasksassignedtodemo.png" />
You will see an add to Dashboard button. Click "Add to Dashboard".
<img class="border" src="attachments/developer.qrimp.com-561532ae-f328-47cc-b2ae-7a0e63a8ef41/addcalportaltodashboard.png " />
Name your new tasks portal.
<img class="border" src="attachments/developer.qrimp.com-ac5166f6-5553-4623-89ae-d8bc32c38087/calltheportaltasks.PNG" />
Click the "View Your Dashboard Now" link.
<img class="border" src="attachments/developer.qrimp.com-79941e05-8151-4c16-bd7e-81ac824eea07/viewdashboardnowcalportal.png" />
Your tasks are now a portal window on your dashboard.
<img class="border" src="attachments/developer.qrimp.com-58e4733a-4a82-4b0a-8cc0-9a62c384250f/tasksportal.png" />
Only use autoupdate if you want editing to be enabled from the view.
|1329||lockedoutusername||<em>Note: This help topic is a stub and will be expanded. Please contact firstname.lastname@example.org if you are interested in using this feature and cannot follow these instructions.</em>|
Admins can use the squarebrackets variable "lockedoutusername" to create a notification template called "ACCOUNTLOCKOUT" and then subscribe to that in the admin notifications area.
If someone tries to log in and fails a bunch of times and their account is locked out, the subscribers to that notification will get an email letting them know that a user in their app is having trouble and they can meet the issue head-on. The notification template can include a link to a help topic that explains what to do if an account is locked out.
|1330||Caching||Caching is a way that data from your website is stored temporarily in your browser to make your browsing experience faster. Caching is very common on the internet. Stored data is kept in your browser's cache, and can be cleared from your browser. Qrimp makes use of caching.|
<a href="http://en.wikipedia.org/wiki/Web_cache">Wikipedia article on caching</a>
|1331||Legacy Fields Imported from WebOffice||Through out your newly imported Webex WebOffice system, you may find some fields with names like these:|
Owning Record ID, Owning App ID, Modified or Created, Activity Flags, and some others that can be confusing.
We've adapted the first one, Owning Record ID to point to the original record in your system.
The last three are no longer used. Qrimp tracks the createid and createdate in separately. The modified date is stored in the Audit Logs. You can hide the last three unused fields by adding adding the following to your Qrimp App Skin, via Design > Skins.
|1333||Table Search Box||To add a search box to the top of any table, first go to the table and the view you want to add it for.|
Then go to Develop > Header/Footer.
At the very end of the [HTML] in the [ContentHeader] add:
Search: </textarea>. Click Save.
|1334||Add a radio button||[radios:yesno:[DATA]:autoupdate]||Square Brackets
|1335||Add Select List with Square Brackets||An Introduction to Qrimp">||Square Brackets
|1336||Conversion failed when converting the varchar value 'Fred' to data type int.||Text entered, number expected. This often occurs when Qrimp is expected the id # (See [AutomaticIDs]) of your record instead of the name.|
If you can, find the id number of the item you need. For example, in the users table, Fred's ID is 4. If you enter 4, this error should go away.
|1337||All query parameters in the list for menuid must be numeric.||You may come across this error when re-ordering your menu tabs. You can ignore it, it doesn't seem to have any effect.||Error Messages
|1338||Sorting in Grid Edit||You cannot sort by the 'id' or 'name' column in [Grid Edit].||Known Issues
|1339||Entering Currency Amounts||If you have chosen currency as your [datatype], there is no need to enter the $ with the amount. |
If you do this, you will get an error message stating you have entered a value that was not the correct type. (See [Error Messages]).
|Entering and Editing Data
|1340||Long drop-downs - search||If you're selecting from a drop-down list that is very long, it can be hard to find what you're looking for. We have a field template that can provide a different interface for this - one that lets you search through the drop-downs rather than scroll.|
<textarea><noeval>That table does not exist. </noeval></textarea>
Please <a href="http://www.Qrimp.com/contact.html">contact us</a> if you are interested in this feature.
|1341||Hidden Page Variable||Qrimp has a special hidden HTML form field called "page" that allows you to configure where the user goes to after clicking a link, creating or saving records.|
To modify the location the user goes to, Design > Design Mode ON. Go to the form from which you want to control where the user goes to after clicking the button.
Click the gear near the buttons. You'll find in that HTML a hidden INPUT form field called "page". You can change this variable to a URL that you'd like the user to go to after submitting the form. This URL can contain variables that are updated with values from the saved form you can also use [square brackets] to include SERVER variables like the HTTP_REFERER to send the user back to the page they were on when they clicked the edit or add new link.
<h2>Add a Create and Add Another button</h2>
Sometimes, you may want the ability to quickly create a lot of items at once. On the add new item screen (vid=8 in the url), you'll want to edit the header footer, add the button, and then when that button is clicked, change the value of the hidden page variable so that it sends the user back to the page you are on, rather than going to the detail view of the newly created item.
Here's how to do that. First, be sure design mode is on according to the instructions above. Then, go to the Add New form where you want to create many items quickly.
Click the gear next to the save buttons at the bottom. A lightbox will appear with the HTML for the Create and Cancel buttons. We'll add another button. To do that, copy the Text that starts with the Less than sign and INPUT type=submit. Select all of that text through to the Greater than sign. That's one HTML tag for the create button. Copy and paste it.
Change the value of the pasted INPUT button to "Create and Add Another". You'll need to have all of that text including the quotes so your browser knows to include all of it on the button. Now, we need to add another attribute to the input tag that changes the hidden PAGE variable. Add onclick='$("#page").val(document.location.href);' somewhere inside the newly copy/pasted INPUT field.
Your new HTML inside the lightbox should look like what is in the TEXTAREA below. In most cases, you can probably just copy/paste this HTML into your lightbox area to get the results we've described here.
Click save. Now you can click the "Create and Add Another" button to quickly add a lot of items to the same table.
|1342||Default Fields||A default field is the field from any table that is displayed in a related table or on the calendar view.|
<img class="border" width="550" src="http://developer.qrimp.com/attachments/developer.qrimp.com-b6d0bb35-3e7a-4294-9174-523e20fd428a/defaultfieldinrelateddata.png" />
If no default field is selected, Qrimp will use the first text field in your table as the default field. If there is no text field, Qrimp will use whichever field comes first.
<h2>Changing the Default Field</h2>
To change the default field, go to your table, then click the Table Management sub-menu.
At the top of the table management page, click the link that says "Configure Table Settings".
In the defaultfield drop-down, select the name of the field you want to appear.
<img class="border" src="http://developer.qrimp.com/attachments/developer.qrimp.com-4470af98-dea4-4014-994e-61ddb6092df5/changedefaultfieldtodescription.png" />
In this example, we will change the field from being the name of the timesheet to the description.
|1343||Users aren't receiving their temporary password email||Qrimp sends many emails every day and sometimes those emails are blocked|
by email settings at the recipient end. In this case, the user will not
receive their username and password email when you create their account.
The long-term solution is to add Qrimp's support email account to your
email filtering software's safe list. ConstantContact maintains a help
topic on <a href="http://support2.constantcontact.com/articles/FAQ/2753">how to add safe senders in many different email programs</a>.
Sometimes the above step won't work or you need an administrator to help,
but in the meantime, you need to get your new users into the system. The
best way to do this is to follow our guide on <a href="//developer.qrimp.com/db.aspx?t=helptopics&id=1318&vid=11">How to reset a users password in Qrimp</a>.
IMPORTANT: When you click the Approve account in the final step, write down or
copy/paste the temporary password so you can share it with the new user
via email or in person.