Qrimp Help Documentation

id	name	description	ParentTopic
3	Security	Qrimp gives you many ways to control security and restrict who can see, access and change your data. By default, the account administrator is the only one who will be able to change security settings. You can change this by giving permission to other [user groups] to perform update [operations] on the [Table Security] table. You can give them permission to see the table by editing your [Menus]. Administrators have automatic rights to: <ul> <li>[Adding Users]</li><li>[User Groups]</li><li>[Assigning Users to Groups]</li><li>Change [Table Security]</li></ul>
8	An Introduction to Qrimp	<!--<nobreak>--> <h3>What is Qrimp?</h3> Qrimp is a web platform that allows you to create and operate your own custom information management system. <h3>How does it work?</h3> When you create an app, you get a url, such as http://myapp.qrimp.com, plus a login and password by email. When you log in to your Qrimp app you have the tools you need to build custom solutions for any type of software system and manage your data securely on the web. <h3>What is Qrimp for?</h3> Qrimp is used to create web-based software applications with forms, workflow, reporting, business rules, data views, design templates and more. You can start with your existing data or add data as you go. Some types of software that have been built on Qrimp include Customer Relationship Management, Inventory Management, Enterprise Resource Planning, Supply Chain Management, Knowledge Management, Digital Asset Management, Financial Management, Human Resources, Intranet and more. <h3>How do I sign up?</h3> If would like to create a new web application for yourself or your company, go to<a href="http://www.qrimp.com/signup.html"> www.qrimp.com/signup</a>. If your company already has an app, speak to your administrator and they will create an account for you. <h3>How do I access it?</h3> Qrimp systems are accessible online any time from any web browser, including mobile phone browsers. There is no software to download. If desired, Qrimp can be installed behind a firewall on a local machine (see <a href="http://developer.qrimp.com/db.aspx?t=HelpTopics&id=138&vid=11" alt="Qrimp Server">Qrimp Server</a>). <h3>Who can see my data?</h3> Qrimp systems are all private by default. If you would like to show data to the public, use the anonymous user group under security permissions (see <a href=http://developer.qrimp.com/db.aspx?t=HelpTopics&id=4&vid=11>User Groups</a>). <h3>Does Qrimp work with ...?</h3> Qrimp can integrate with external services for payment processing (PayPal, Authorize.Net), maps, UPS (shipping), Flickr, Twitter, RSS - anything with an API. You can also share data from your Qrimp application to external sites using <a href=http://developer.qrimp.com/db.aspx?t=HelpTopics&id=130&vid=11>Share Data</a>. <h3>What about my existing files?</h3> Qrimp lets you upload existing documents, such as Word, Excel, PDF, video, and other files. These documents are stored in Qrimp as attachments. See <a href="db.aspx?t=HelpTopics&id=137&vid=11">Adding Attachments</a>. <h3>Can you build my system?</h3> If you do not have the time or knowledge to build your system, the Qrimp Services team can provide help. If you'd like our help, please <a href="http://www.qrimp.com/contact.html">contact us</a>. <!--</nobreak>-->
24	Error Messages	When you are working with your Qrimp app, you may encounter error messages. The error messages will appear in red and should tell you what to do to correct the problem, if possible. Many of these occur if you are entering data that is not the correct type, or if your data model is not correct. Sometimes you will see a warning at the top if you have just deleted a record. This may sometimes persist to a new table as you are navigating. Usually these types of warning messages will disappear if you refresh your browser or if you continue using your app as normal. We will attempt to document the most common errors and warnings in this section. If you come across blank pages or unexplained errors, please [contact us] or submit a Feedback blurb with a detailed explanation of what happened.
81	Definitions	Some definitions of commonly used terms.
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.
171	Getting More Help	If you were unable to find the information you needed in this help documentation, or if you were unable to use the instructions to accomplish your goals, please email support@qrimp.com and let us know what you are trying to do or what you had trouble with. <h2>Contextual Help within your Qrimp App</h2> If you click the help link in the top right hand corner of your browser, near the search box for your Qrimp app, you'll be brought to the Help Topics with relevant help topics listed for you about the area where you were when you clicked the link. For example, if your managing users and you need help, click the help link and you'll be taken to the developer help topics with Manage Users right at the top of the list. If you had clicked the help link while managing a table and you want to know how to use [computed columns], you'd be shown the help topic on [table management]
196	Navigation	The topics in this section cover how users navigate your Qrimp app. How do users get to your data? Which actions are allowed from which places? Which messages are shown on forms?
197	Working with Data	This section explains how to get data into and out of your Qrimp app. You will learn how to add data, delete it, edit it, import it, export it and more.
198	Data Analysis	Get deeper insight into your data with queries, reports and charts.
199	Display and Design	Learn about how to display data in Qrimp and change the look and feel of your application with skins (CSS stylesheets). Change where form fields appear on a page.
200	Communicate and Share	Learn to use Qrimp for messaging and share data that is in your Qrimp app.
201	My Account	Everything you need to know to keep your account running.
209	Advanced Development	The features in this section will be useful to those with a web development background. Be cautious when implementing these features.
233	Logging in	First, make sure you have a Qrimp account. When you sign up, or when your admin creates an account for you, you get an email with your login info. Find this email. Now, go to your app ie: "https://myapp.qrimp.net". Enter the email address and your temporary password from your sign up email. Passwords are cAsE sEnSiTiVE! Be sure to type slowly and carefully when entering your password (or copy/paste). <img class="border" src="/attachments/developer.qrimp.com-3eafb22a-a65b-47d4-9d47-fc83d78eea78/log in screen.png" /> Once you are logged in, change your password. Memorize your new password, or write it down and keep it in a safe place. If you forget your password, click the link that says "login help" and request a new password. Please only contact us for help after you have tried all of the above. Lost passwords are a main use of support staff time and increase costs for all users. Take your time, be patient, follow the instructions and type carefully.
1297	Billing	Cover topics related to paying for your Qrimp account and Services
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
13	Table Security	Table security lets you set permissions for each of your tables by user group (see also [User Groups]). You can set Create, Read, Update, and Delete ([CRUD]) access. Administrators can change security at any time. <h2>Default Permissions</h2> By default, new tables are only accessible to the Administrator and Developer groups. You must add permissions for other user groups. The User and Tester groups can read data, but not create, update, or delete it. <strong>The Anonymous (public/not logged in) group, and new user groups that you add cannot see anything unless you give them permission.</strong> <h2>Adding Group Level Permissions to View a Table</h2> To set which user groups can access a table, go to Develop > Manage Tables > Find your table > Click the "Group Security" link. Or go to your table and choose the Table Management sub-menu (if available). From the table management page, click the link that says "Manage Group Security". Toggle permissions by clicking the checkbox or circle with a line through it. <img class="border" src="attachments/developer.qrimp.com-86051ce6-0b93-4896-8c39-db1b42c5a94a/configuretablesecurity.png" /> <h2>Advanced: View Security Permissions for all Tables</h2> To view all of your Table Security Records, go to Develop> Manage Tables > View System Tables > t_security > View. Depending on the size of your system, you may see hundreds or thousands of records. To find a record use the [search] feature. <img class="noborder" align="absmiddle" src="/icons/crystal_project/32x32/actions/filefind.png">	Security
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
1269	Managing Users	To manage users and user groups go to Admin > Manage Users.	Security
144	Anonymous Access	By default, data in your application is only visible to individuals with usernames and passwords. The default user group "Anonymous" is used when you want to make your data accessible to the public, such as for an online store, a blog, or a company website. (See also [User Groups].) To allow your data to be visible on the internet, you must set each <a href="db.aspx?t=helptopics&id=252&vid=11">database table</a> as visible to the Anonymous user group by using [Table Security]. You must also make sure that anonymous users have permission to see each menu tab by setting up [Group Menu Visibility].	User Groups
1279	User Group Settings	On the User Security Page you can allow or disable the following options by group: <img src="attachments/developer.qrimp.com-55fb2502-ce6e-4f6c-bdd7-1f85c6952a68/Usergroupsettings.png"> <h2>AllowHTMLInFields</h2> Should this user group be allowed to write [HTML]? HTML fields can change the appearance, color, style, font and layout of your data. <h2>AllowScriptInFields</h2> 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. <h2>Allow Edit CSS</h2> Can this user group to edit Cascading Style Sheets? <h2>EnableUploads </h2> Can this user group upload attachments to your Qrimp app? <h2>Show Export Options</h2> Can this user group see [export options] to export data from your tables? <h2>Show related data</h2> Should the group see [related data]? <h2>Default Start Page</h2> 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] <h2>Input Black List</h2> If the user group has permission to enter [HTML], which characters can they not enter?	User Groups
1300	Add a User Group	<span class="error"><em>Caution: If you add a user group, they will need permissions added manually to all tables and menus. They may also need permissions added to many [system tables] - portals (to see portals), queries, t_group_query, views etc. If any of this is done wrong, the user will not see things they should see.</em></span> To add a new user group go to Admin > Manage Users. Click the link on the top of the page that says "Manage Security Groups". <img class="border" src="attachments/developer.qrimp.com-8b442862-ce60-4548-813d-75777ddc0543/managesecuritygroups.png" /> ---- Click the "Add New" button to add a new security group. To edit the settings for an existing security group, click the edit icon. <img class="border" src="attachments/developer.qrimp.com-a46644f2-09a1-41a5-942e-3fd91e1c5d51/usergroupsettingeditusergrouporaddnew.png" />	User Groups
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.	Adding Users
25	Many-to-Many	A many-to-many relationship is a relationship between two <a href="db.aspx?t=helptopics&id=252&vid=11">database tables.</a> For example, a stuedent in university will have many teachers, and a teacher will have many students. The relationship between the two tables is a many-to-many relationship between students and teachers. <h2>Adding a Many-to-Many</h2> To add a many-to-many relationship first go to the table for which you'd like to create the relationship, then go to Develop > Add Many-to-Many. At the top of the page, you'll see the table you selected, and a drop down list of other tables in your system. Select the table to which you'd like to add the relationship and then name the relationship. Usually something simple such as TeacherStudents or UserTasks is best. Click create to add the relationship. You will see two links that allow you to view data in either of the tables. <h2>View the Relationship</h2> To view the relationship go to the detail view of any item in either of the two related tables. On the right hand side of the page, you will see a heading/link to the relationship. If there are related items, they will be listed below the link. There is also an add button so you can add new items. <h2>Advanced - viewing all relationships in your system. </h2> To see a list of all existing relationships, go to Develop > Many-to-Many.	The System Tables