Ragic Logo
Sign in Sign up
Ragic Developer Center
  • Follow Ragic!
  • Ragic RSS FeedRSS
    Subscribe by Email

  • Latest Posts
  • Popular Posts
  • Tags
  • Search
  • Back to Support Home Ragic User Manual

    Ragic User Manual


    How to use This Document

    Readers can either linearly read this document from beginning to end or just jump or browse those sections that interest them most. If there is something that you need to know before you read an article, we will provide you with a reference link guiding you to the right place.

    1. What This Document Covers

    This document aims to tell you all you need to know for using and developing in Ragic Builder by providing an extensive coverage of the Ragic Builder platform, from the basic overview of the system interface to the more advanced topic on data structures or form design techniques.

    2. How this Document is Structured

    Using Ragic Builder is designated to give you a comprehensive understanding of Ragic Builder’s fundamental functions and interfaces. It covers basic operations users can do with the system interface and the enterprise desktop.

    Ragic Builder in 5 minutes is a quick hands-on tutorial that guides you through the steps of manipulating data for a form. Afrer reading this article you can get the essentials of Ragic Builder and start using it to manage your data.

    Introducing the User Interface demonstrates operations users can do with the user interface of Ragic Builder.

    Exploring the Basics describes the elements that comprise the overall Ragic Builder database application and gives examples to show you how to use them.

    Taking a Bird’s Eye View of an Application shows the reader another convenient tool, that is, Reports, offered by Ragic.

    Developing with Ragic Builder provides everything you need to know for developing application with Ragic Builder.

    Getting Started uses real-world examples to illustrate the fundamentals on developing applications with Ragic Builder.

    Mastering Ragic Builder describes in detail the features of the design mode interface and discusses how to use the provided controls of the interface to create an application.

    Ragic Builder Advanced introduces some more advanced topics regarding the Ragic Builder platform, focusing on the features that might hamper users with little to no programming background to use.

    Terms and Glossaries compile a collection of all terms used in Ragic Builder and gives brief explanation for each term. Links to related articles in the other section will be provided as well.

    Key Combinations For convenience, Ragic Builder has some handy keyboard shortcuts that you can press while creating or using the database. This section lists all the keyboard shortcuts offered by Ragic.

    3. Intended Audiences

    Articles in Using Ragic Builder is primarily intended for users who have little to no prior experience with Ragic Builder. Basically for correctly using Ragic Builder, it is advised that you get acquainted with all aspects illustrated in this section.

    Developing with Ragic Builder assumes no background of any programming knowledge. However, it is intended for users who already understand how to use Ragic Builder and try to develop applications of their own. So make sure you’ve read "Using Ragic Builder" before diving into this section.

    Part I. Using Ragic Builder

    Using Ragic is designated to give you a comprehensive understanding of Ragic’s fundamental functions and interfaces. It covers basic operations users can do with the system interface and the enterprise desktop.

    Ragic Builder in 5 minutes is a quick hands-on tutorial that guides you through the steps of manipulating data for a form. After reading this article you can get the essentials of Ragic Builder and start using it to manage your data.

    Introducing the Environment demonstrates operations users can do with the user interface of Ragic Builder.

    Exploring the Basics describes the elements that comprise the overall Ragic Builder database application and gives examples to show you how to use them.

    Taking a Bird’s Eye View of an Application shows the reader another convenient tool, that is, Reports, offered by Ragic.

    Chapter 1. Ragic Builder in 5 minutes

    Greetings. Welcome to Ragic! After reading this article you can immediately get the essentials of Ragic Builder and start using it to manage your data.

    1.1. Listing Page

    You will see a listing page as the image above shows as soon as you enter a Ragic Builder database application. The listing page displays 25 entries of the data per page. You can quickly find the data you are interested in here. See below for detailed operation.

    Browse data

    The number of entries that the listing page can display in one page is limited. Once the data exceed 25 entries, you can click "Previous" and "Next" on the right of the operation panel, or press the PageUp/PageDown key on your keyboard to load other pages.

    The listing page may only show a portion or summary of the data. To see the details, you can click any entry you're interested to go into the detail page.

    Enter Editing Mode

    The listing page we see after entering a database form is in Browsing Mode. You can browse the data here. If you want to add or modify data, you have to enter Editing Mode first.

    You can click "New Entry" to enter a blank detail page where you can add a new entry to the database.

    Click "Edit Data", the current listing page will switch to Editing Mode. You can modify all data displayed here.

    Download data

    If you need to export the data in the database for some purpose, click the "More Actions" button and select "Download as Excel File" or "Download as Text File" from the option menu.

    Search data

    There are 2 ways to search data in listing page. The basic method is to click the button at the right of the header field, then choose default value or enter some key words to filter the data.

    If the basic filter isn't enough for you, you can use the advanced query function. Just click the "Filter" button, and then set the rules in the setting page.

    1.2. Detail Page

    After clicking an entry on the listing page, you will be forwarded to a detail page which displays detail information about the chosen entry.

    Browse other entries

    1. Click "Back Listing" or press "←" on your keyboard to go back to the listing page and search for the next data.

    2. Click "Previous" or "Next" to view the previous or next entry.

    Delete Entry/Edit data

    Only the system administrator has the right to delete entries. If you're not system administrator, you won't see the "Delete Entry" button.

    Not every user has the privilege to edit date, depending on the access rights the user has. Users who can see the "Edit Data" button on the operation panel do have the right. After clicking "Edit Data" to enter Editing Mode, you can modify the data.

    Download data

    If you need to export the current entry for some purpose, click the "More Actions" button and select "Download as Excel File" or "Download as Text File" from the option menu.

    Comments

    When you have some opinion, question or issue regarding the entry, you can click "Comments" at the bottom right corner, and key in your messages.

    Histroy

    Click "History" at the bottom right corner, you can see the record history of the current entry.

    1.3. Editing Mode

    When you click "New Entry" in listing page or "Edit Data" in detaill page, the system is switched to Editing Mode, where you can modify or enter new data.

    After typing some data, click "Save Edit" or press "Ctrl+S" to save the data.

    Click "Back Listing" or press Esc on your keyboard to abort the modification and go back to browsing mode.

    Chapter 2. Introducing the Environment

    This section demonstrates operations users can do with the Ragic Builder.

    Account Home tells you what is Account Home and how to access it.

    Menu Bar describes the functions Menu Bar offers.

    Account Toolbar The account toolbar always appears on the upper part of user’s environment. Shortcuts to various functions that Ragic offers can be found here. This article quickly shows you what can be done with the toolbar.

    2.1. Account Home

    This article tells you what is Account Home and how to access it.

    What is Account Home?

    Account Home serves as the portal, i.e., the entry point to all your applications. Applications either built by you yourself or installed from Ragic's public app gallery are all listed here.

    As the image above shows, Account Home displays all database applications and forms your account have. There is a full text search tool and shortcuts for all apps on the left side. On top of users' environment is Account Toolbar, and Menu Bar is below it. We'll introduce them in the following articles.

    How to access Account Home?

    You should be directed to your Account Home right after you login. If not, you may click the [youraccount Home] on Account toolbar or "Home" on Menu Bar, as figure below shows.

    Switching desktops

    Account Home is on a per-account basis. At times people may invite you to use their own applications. You'll be able to join other people's home and switch to and from their home and yours freely, if you accept the invitation.

    See Also

    Menu Bar describes the functions Menu Bar offers.

    Account Toolbar The account toolbar always appears on the upper part of user’s environment. Shortcuts to various functions that Ragic offers can be found here. This article quickly shows you what can be done with the toolbar.

    2.2. Menu Bar

    There are six functions in Ragic Builder Menu Bar. Some of them are only for the administrators. If you're not the administrator, you may only see parts of the functions. Here we shortly introduce them one by one.

    1. Home: Click here to return to Account Home.

    2. Reports: Charts, rankings, and pivot table reports are auto generated by Ragic Builder. You can look at different reports for each form that you created here.

    3. Data: It's only for the system administrators. You can import, backup and restore data for your account here.

    4. Notifications: The top of this page shows recently updated entries in all applications of your account. At the bottom, you can set the E-mail notification.

    5. Design: It's only for the system administrators. You can create new forms/apps, modify the existing forms/apps and change their look and feel.

    6. Admin: It's only for the system administrators. You can manage the users and groups in your account.

    2.3. Account Toolbar

    Account toolbar always appears on top of users' environment. Shortcuts to various functions Ragic provides for you are listed here. See the following figure to find where it is.

    Each link in the account toolbar, from left to right, is described below respectively.

    1. Ragic Builder: Click here to return to Ragic.com's homepage.

    2. Account Home: You can switch Account Home here.

    3. Settings: Change your password here.

    4. Support: From here you can submit questions or bugs you found to the online support database. In addition, you can find the link to Ragic's community and documents here.

    5. Learn Ragic: For you to learn more about ragic from different point of view.

    6. Sign out: Log out from the account you are using.

    7. Languages: Choose the language you would like to use. Currently we support Traditional Chinese, Simplified Chinese, and English.

    See Also

    Account Home if you still are not familiar with the Account Home.

    Menu Bar describes the functions Menu Bar offers.

    Chapter 3. Exploring the Basics

    Exploring the Basics describes the elements that comprise the overall interface of the Ragic platform and gives examples to show you how to use them.

    A Quick Introduction to Database Interface walks you through the overall database interface of Ragic Builder.

    Listing Pages and Detail Pagesd illustrates the different between these two pages. A must read for starters.

    Data and Access Rights Data in Ragic Builder are protected by Ragic Builder’s access control mechanism. Read this article to learn what access rights Ragic Builder offers.

    Understanding the Three Modes in Ragic Check this to know how the three modes, “Browsing Mode, Editing Mode, and Design Mode,” work in Ragic Builderc.

    Browsing Data teaches how to browse, filter, and sort the data in Ragic Builder with detailed step by step examples.

    Creating Data teaches how to create a new entry in Ragic Builder with detailed step by step examples.

    Editing Data teaches how to edit data in Ragic Builder with detailed step by step examples.

    Deleting Data teaches you how to delete an entry in Ragic Builder.

    Download as Excel Files describes how to export your data to a external Excel file.

    3.1. A Quick Introduction to Database Interface

    Before diving into details, let’s first introduce the fundamentals that every user should know.

    As the following figure shows, basically the interfaces can be seperated into serveral different parts.

    Account Toolbar/Menu Bar

    The upmost part is the account toolbar and menu bar that we already discussed in prior article.

    Operation Panel

    Below the menu bar is operation panel. Users can use the buttons and links to edit data, create new entry, set filters etc... . Detailed explanation on each operation will be discussed in later articles.

    Mode Indicator

    Below the operation panel, you'll find a narrow pane with some text on it. This is the status bar which is used to indicate you your current mode. There are three modes: Browsing Mode, Edit Mode, and Design Mode in Ragic Builder. For more about how different modes work, read Understanding the Three Modes in Ragic. And the text on the right side tell you your access right to the current form.

    Database Interface

    The center part that occupies the most space of the screen is the main area of the database. Data you created are shown here.

    Full Text Search

    On the upper left side is full text search function. You can enter the term that you would like to look for, and Ragic will return all entries in every form that contain your query term.

    Switch between forms/apps

    You can switch to other forms or applications from the shortcuts on left side. Click any app to see the forms in the app. Click any form to enter it.

    See Also

    Account Toolbar This article quickly shows you what can be done with the toolbar.

    Browsing Data teaches how to browse, filter, and sort the data in Ragic with detailed step by step examples.

    3.2. Listing Pages and Detail Pages

    You might notice that through the documents, we keep mentioning about listing pages and detail pages. In this article, we hope to clarify for new comers who are not that familiar with these two.

    Simply put, in Ragic Builder, listing pages and detail pages actually are two kindes of views associated with a form. The listing page lists the summaries of all the data in the form. For example, the following figure demonstrates a human resource management application. Its Employees form contains 212 entries of data. This figure is the listing page that shows the first 25 entries.

    The detail page is a specific page that shows the detail information of any entry on the listing page. To access the detail page of an entry, just click on the entry in the listing pages. For example, the following figure is the detail page of the entry with Employee Number 00002.

    In later articles, we will keep using listing pages and detail page. So it is adivsed to keep these two terms in your mind.

    See Also

    Browsing Data teaches how to browse, filter, and sort the data in Ragic with detailed step by step examples.

    3.3. Data and Access Rights

    Access control plays an important role in the Ragic platform. It protects all the resources in users’ applications from unauthorized access, modification, or disclosure. This article briefly introduces the five access rights Ragic Builder offers for users. For more details about the access control mechanism in Ragic Builder, read Authorization Management in later section of the documents.

    Types of Access Rights

    There are totally five types of access rights offered by Ragic Builder, as the list shown below.

    1. No Rights: No need to explain. You cannot do anything if granted this kind of rights.

    2. User: You can read and write your own entry if granted this right.

    3. Viewer: This type of rights grants users read access to all entries but no write access at all.

    4. Power User: This type of rights grants read access to all entries and gives write access to the user’s own entry, but no write access to other users’ entries.

    5. Admin: Users with this right have full read and write access to all entries.

    As a user, you only need to know that every operation you take needs certain kinds of access privileges to be granted beforehand, be it viewing data or writing data. Therefore, if in some situations, you find that you cannot do certain actions. First and foremost make sure that whether you are granted corresponding privileges or not. The following figure is the pop-up dialog indicating that user has insufficient privlege to edit data.

    To figure out the access rights you have, check the right part of the mode indicator, as the following figure shows.

    See Also

    Authorization Management for more about how to control the access rights in Ragic Builder.

    3.4. Understanding the Three Modes in Ragic

    In Ragic Builder, there are three modes: Browsing Mode, Editing Mode, and Design Mode. Understanding how different modes are switched and accessed is crucial for users in making the most out of Ragic Builder.

    The Mode Indicator

    It is easy to know what current mode is. Just pay attention to the Mode Indicator. It is in the upper part of the screen, right below the operation panel. See the following figure if you can’t find it. From the figure you can see that it is in Browsing Mode.

    Browsing Mode

    In browsing mode, you can browse the listing of the data. Or you can browse a specific entry for detail. Notice that you can delete data while reading a specific entry while under this mode.

    Editing Mode

    As the name suggests, you can make change to the existing data in the Editing mode. In addition, you can create or modify data under this mode. Clicking on New Entry or Edit Data button switches you to this mode.

    Design Mode

    In Design Mode, you design the form itself. To access Design Mode, click on "Modify Design" in the upper right corner of operation panel. Once switched to Design Mode, you can freely add, modify, or delete fields in the form. Moreover, you can change the name of, set attributes for, or apply validation rules to fields. Notice that you might not have the access right to access Design Mode though if you are not the owner of the application or are not granted the highest privileges to the application.

    Do not worry too much about this mode now since this mode is mostly for Ragic Builder Developers. Come back and read the Developing with Ragic Builder section of the document if you are already familiar with the fundamentals and plan to develop a Ragic Builder application on your own.

    Summary

    In this article, we introduced the three different modes used in Ragic, that is, the Browsing Mode, the Editing Mode, and the Design Mode. You can browse the data in Browsing mode, edit data in Editing Mode, and design the form in Design Mode. Familiarizing yourself with the three modes helps the understanding of the concept and operation of Ragic Builder platform.

    See Also

    A Quick Introduction to Database Interface if you are not familiar with the overall database environment of Ragic Builder.

    Browsing Data to learn how to browse, filter, or sort data.

    3.5. Browsing Data

    Typically a listing page is displayed when you enter an application. From this page, you can browse all or read specific entry of data. The following figure demonstrates a listing page that contains 212 entries of data.

    In the Listing Page, clicking on any entry brings you to its detail view. In the detail page, clicking "Back Listing" on operation panel brings you back to the listing page.

    Read Listing Pages and Detail Pagesd to know more about them.

    By default Ragic display 25 entries of data per page. You can click "Previous" and "Next" on the top right corner to view more data if the number of entries is more than 25. The following figure shows the paging control.

    Sorting Data

    In the listing page, you can simply sort the data by clicking the field headers. Clicking the header once lists the data with descending order. Clicking it twice reverses the order. Clicking it the third time will unset the sorting. You can figure out what the current order is by seeing the small triangle next to the field header after you click it. You can sort any type of field in the page, ranging from simple text, number, to even date. For example, the following figure demonstrates sorting the data by Employees' name with ascending order.

    Filtering the Data

    In addition to sorting, Ragic Builder further offers Filter tool that makes it easy to find the target data. Now let's see how to create a filter to filter out our data step by step.

    First click "Filter" button on the operation panel as the following figure shows. And then the filter setting page displays.

    All the fields in your form are listed in the Filter setting page. You can set your filter rule in any field. If the input type of the field is "Selection", you can select items from the dropdown list.

    Take our human resource management application for example, say we want to filter out our data so that we can find employees who live in Illinois. Just select "IL" in the field "Region".

    When the setting is done, click "Query" button on the operation panel. Then only the emplyees living in Illinois display in the listing page as the figure below shows.

    Filter setting is not limited to only one rule. You can add as more rules as you like to further limit the dataset returned. Click "Reset" button to clear the rules you set.

    You can save the rules you just made, so that you don't have to do all the settings next time. All you need to do to save the rules is to click "Save Query" button and give it a name.

    For example, we set the filter to find out the employees who live in Illinois belong to the sales department. To save this setting, we click "Save Query" button and name it "IL&Sales". Next time we just neet to click "IL&Sales", and then we can proceed to filter.

    Hotkey Reference

    For convenience, Ragic Builder has some handy keyboard shortcuts that you can press while browsing the data to perform some often-used functions.

    In Listing Page

    to previous entry
    to next entry
    to the detail page of the entry
    PageUp to previous page(if more than one page and not at the 1st page)
    PageDown next page(if more than one page)

    In Detail Page

    to previous field
    to next field
    back to the listing
    PageUp previous entry if not the first entry
    PageDown next entry if not the last entry

    See Also

    Listing Pages and Detail Pagesd illustrates the different between these two pages. A must read for starters.

    Creating Data teaches how to create a new entry in Ragic Builder with detailed step by step examples.

    3.6. Creating Data

    You can create data from either the listing page or the detail page.

    Creating Data from the Listing Page

    To create a new entry from the listing page, first make sure you are in Browsing Mode and in the listing page. Click the New Entry button on the upper left corner of the interface. A form appears afterwards and the mode will be switched to Editing Mode. Enter new data and press Save Edit button on the top left corner to save the data. After saving, you can go back to the listing page. The newly created data will be shown as the first entry of the list.

    For example, if we want to add a new entry for our human resource management application. First access the listing page. Click the New Entry button, as the following figure shows.

    Next, enter some data in the form. Notice that the status bar now indicates we are currently in the Editing Mode.

    Then click the Save Edit Button. The data is created then. The new data will be shown as the first entry of the list.

    Creating Data from the Detail Page

    We can also create new entry from the Detail Page. First make sure you are in the detail page and in Browsing Mode. Type the key 'n' on your keyboard. A form appears afterwards and the mode will be switched to Editing Mode. Input new data and press Save Edit button on the top left corner to save the data.

    Discarding the Data

    Notice that the data you entered will not be saved until you hit the Save Button. Therefore if you finally decide to discard the new entry, just click the Back Browse Button in the operation panel and confirm that you are going to leave the page and the data will not be saved.

    Hotkey Reference

    For convenience, Ragic Builder has some handy keyboard shortcuts that you can press while creating the data to perform some often-used functions.

    n to create a new entry
    Ctrl + S to save the entry
    Esc for going back to browsing mode

    See Also

    Listing Pages and Detail Pagesd illustrates the different between these two pages. A must read for starters.

    Browsing Data to learn how to browse, filter, or sort data.

    3.7. Editing Data

    From previous articles we have learned that the listing page shows all the data associated with the form and the detail page is the detail view of a specific entry of the list.

    We can edit the data both in the listing page and in the detail page. It may pose challenge to users if not knowing the difference between editing under listing page and edting under detail page. Therefore this article tries to clarify the feature in detail by examples.

    Editing Data from the Listing Page

    You can directly edit data that appear on listing page. For example, if we want to edit the data of our human resource management application. First go to the listing page. Click the Edit Data button on the top left corner, as figure below shows.

    Notice that we are switched to Editing Mode now. And you can edit any data on current page. Let’s make some change to the data. In the following figure we modify the name of the employee whose employee number is 00119 from 'Ahmed Lowery' to 'Ahmed McCammon'.

    Press Save Edit. The following figure shows that the data are updated. And that’s all for editing data from the listing page.

    Editing Data from the Detail Page

    We can also edit any existing entry from the Detail Page. First click any entry that you are going to modify in the listing page. Make sure you are in the Browsing Mode. In the detail page, click Edit Data button on the top left corner. Notice that we are switched to Editing Mode now. Modify the data, as the following figure shows.

    Press Save Edit. The data will be saved.

    Hotkey Reference

    For convenience, Ragic Builder has some handy keyboard shortcuts that you can press while editing the data to perform some often-used functions.

    e Edit data
    Ctrl + S Save the entry
    Esc Back to the browsing mode

    See Also

    Browsing Data to learn how to browse, filter, and sort the data.

    Deleting Data to know how to delete data.

    3.8. Deleting Data

    To delete data, first make sure you are under Browsing Mode. If you are in the listing page, find the data that you would like to remove and click it. After entering the detail page, click on the Delete Entry button on the operation panel. A pop-up dialog will be displayed for you to reconfirm the action. Click OK to delete the data. Click cancel to abort the action. In the following figure, we click 'Delete Entry' to remove the data of employee number 00119.

    See the following figure, the entry will be deleted if we click 'OK'.

    Notice that you cannot undo the deletion. So make sure to double check beforehand at every attempt to delete the data.

    3.9. Download as Excel Files

    You may find the need to export data to an Excel file at one point or another. Ragic Builder offers a convenient tool to do the job for you.

    Click on "More Actions" button in the operation panel. Select "Download as Excel File" from the option menu. Depending on your browser settings, from the pop-up window you can choose to save the file to your local drive.

    To export a detail page as an Excel file, access the detail page of any specific entry. Click on "More Actions" button in the operation panel. Follow the screen instruction and save the file to your local drive. Downloaded file is shown as the following figure.

    The position of fields and data is exactly the same as those in the database.

    See Also

    Listing Pages and Detail Pagesd illustrates the different between these two pages. A must read for starters.

    Chapter 4. Taking a Bird’s Eye View of an Application

    Reports helps users quickly get a high level view with the application. This section tries to demonstrate how users can leverage Reports to do their jobs.

    A Guide to Reports illustrates the composition of Reports and tells you how to utilize them.

    Using Pivot Table Pivot table is a powerful tool for visualizing data. This article explains how to use pivot table in Ragic Builder to summarize and aggregate data.

    4.1. A Guide to Reports

    The purpose of Reports is to provide the users with general information about the application. It shows for each form in the application a chart with analyzed and summarized stats.

    Accessing the application dashboard

    Click "Reports" in Menu Bar and you can access chart or pivot table for any form in your account as the figure below shows.

    Chart and Ranking

    Chart and Ranking summarize data in each of your forms. Notice that neither the charts nor the rankings will be generated if the form does not contain any selection fields. You will see lines of text indicating that only categorized data can be analyzed and ask you to redesign your forms. Follow the instructions if you find adding selection fields in your forms appropriate. Take the following figure as an example, it highlights a chart and a summary report for the Bug Tracking System we created.

    Notice that you can further control the presentation with the provided dropdown menu beside the chart or on top of the ranking. Try it out!

    See Also

    Using Pivot Table Pivot table is a powerful tool for visualizing data. This article explains how to use pivot table in Ragic Builder to summarize and aggregate data.

    4.2. Using Pivot Table

    Pivot table is a powerful tool for visualizing and summarizing great amount of data. Looking at a whole bunch of data won't give you the big picture. A pivot report worths a thousand words. Ragic Builder automatically creates pivot reports for all the forms you created. You can click on any number in the reports to see what the number is composed of.

    Accessing Pivot Table for a Form

    To access the pivot table for a specific form, enter the Reports page. Click the "Pivot" link beside the name of any form. See the following figure.

    Pivot Table Explained

    The view of the pivot table is comprised of several components: the row, the column, and the summary of the data. The data immediately reflects users' change to the control for x and y axis. Take our human resource management application as an example. In the listing pages of the Employees form, it is not easy to get the picture about the overall status of employees' region data.

    Now for example we would like to ask how many employees are from Nevada? Let’s first access its pivot table. From the pivot table, change the row to be Region, and then change the column to be Department. See the changes of the data. Now we can answer the previous question in a glance. There are totally six employees who are from Nevada, and one of them is in RD department, as shown in the following figure.

    See Also

    A Guide to Reports to learn what Reports is and what is it comprised of.

    Part II. Developing with Ragic Builder

    This section provides everything you need to know for developing application with Ragic Builder.

    Getting Started uses real-world examples to illustrate the fundamentals on developing applications with Ragic Builder. You can learn how to create a database application from scratch.

    Mastering Ragic Builder covers the features of the design mode interface in detail and discusses how to use the provided controls of the interface to create an application.

    Ragic Builder Advanced This section introduces some more advanced topics ragarding the Ragic Builder platform, focusing on Ragic Builder features that might hamper users with little to no programming background. It is advised to finish the previous two sections before reading articles under this section.

    Chapter 5. Getting Started

    In this section, we use real-world examples to illustrate the fundamentals on developing applications with Ragic Builder. Hopefully this can help you quickly get started.

    Creating your Ragic Builder Account

    Introducing the Design Mode Interface talks about the overall design interface in Ragic Builder.

    Creating Database From Scratch

    About the Auto-generated Listing Page Ragic Builder generates a listing page for every form you created. This article explains in example how the listing page is generated.

    Designing the Listing Page

    Creating Database From Excel teaches you how to import your excel to creat a new database.

    5.1. Creating your Ragic Builder Account

    After clicking the Sign Up link in Ragic's homepage, you first choose a plan for your database, and a registration form will be displayed, as the following figure shows.

    1. Your e-mail address: You need to use this e-mail to sign in to Ragic Builder.

    2. Account URL: It will be a unique URL for your account desktop. You can check if your account name was taken before you register by pressing the 'Check Availability' button.

    You will receive a confirmation e-mail after sign up. Please click on the confirmation link in the email to complete your registration. After registration, you can start using Ragic Builder right away!

    5.2. Introducing the Design Mode Interface

    After reading this article, you will be familiar with the design interface. It is important before you get designing your own database application.

    When you're going to create a brand-new database, click "Design" in Menu Bar and then click the "Ragic Application Builder" link under "Create New Application". You'll see a blank form in Design Mode.

    If you want to modify an existing form, click "Modify design" in the operation panel to enter Design Mode. Typing "D" from keyboard brings you to Design Mode as well. Or you can click "Design" in Menu Bar and choose the form(or listing) you want to modify in "Design Ragic Applications" page.

    The figure below is our human resource management application in Design Mode.

    Operation Panel

    There are a couple of buttons in Operation Panel. We introduce briefly here and will explain in detail in the following articles.

    You can set field attributes by clicking the "Field Setting" button.

    To input descriptions such as column explanations, you could move your cursor to the top bar and change the "Editing Form Fields" to "Editing Description", and then set the font size or color of the description through "Desc Style".

    The access right of the page could be modified by clicking "Form Setting" and selecting the "Access Rights" tab.

    The "Filter" button on the right side is to set the fixed filter so that users just can read data after filtering when they are browsing in the database.

    All of the modifications will not be valid until you click "Save Edit". If you want to abort the modifications, just click "Exit Designer".

    Database Interface

    The main screen is a WYSIWYG area under design mode. You can create any kinds of fields you want, drag and drop those fields, and adjust their width, height and even column span, enabling you to present your data in a more user friendly way.

    5.3. Creating Database From Scratch

    This article demonstrates how to create a database application step by step.

    Step 1: Click "Design" in Menu Bar and then click the "Ragic Application Builder" link under "Create New Application"

    Step 2: Enter the name of the field that you would like to create. You can decide the location of the field by using your mouse or keyboard up↑/ down↓/ left←/ right→.

    Step 3: When you are done with your design, you can click on the “Field Setting” button in the operation panel. You need to select the field name before setting the attribute. In the figure below, "Customer Number" is the field we select .

    Step 4: When you save your design for the first time, you have to fill in the database name and URL in the pop-up window. Click Save Application after filling those names.

    Step 5: Click the "Exit Designer" button to exit the design mode, and then press the “Back Listing” button. You can see a listing page automatically generated for you from the form that you just designed.

    Step 6: If you want to remove some fields that you don’t want in the listing, click "Modify design" in the operation panel to enter Design Mode.

    Select the field that you want to remove, press “Delete” or “Backspace” on you keyboard. The field will disappear form the listing. In the following figure, we remove the Address field from the listing page.

    As the figure below shows, the Address field is gone.

    Remember to save your modification before exiting design mode. The modification to the design will not be in effect until you save.

    Now you can use the database application you just created!

    5.4. About the Auto-generated Listing Page

    It’s advised to read Listing Pages and Detail Pagesd in the Using Ragic Builder section before reading this article.

    Ragic Builder generates a listing page for every form you created. By default the generated listing page enumerates all the fields in your form. However, if there are too many fields, it may interfere with the readability of the page and as well cause the page rendering to be a bit slower.

    To demonstrate how Ragic Builder generates a listing page for us, here let’s create a form first. Give it two fields, one called Name and the other called Description, as the following figure shows.

    Click "Save Edit" in the operation panel to save the form. Click "Exit Designer" in the operation panel to exit. You’ll see a page exactly like the form we just created then. Now let’s click "Back Listing" in the operation panel. Check how the page looks now.

    We can see that the two fields are now listed horizontally with a blank line right below it. This is the auto-generated listing page that Ragic Builder create for you after you create a form.

    To enhance the readability of the listing page, we can delete fields and modify column width to better utilize the space. Detailed information can be found in Designing the Listing Page. The following two points can help you in the process of forming the listing page:

    1. Is this field representative enough?

    2. Will the field enhance the efficiency on search?

    After deciding which fields go to listing pages, adjust the column width according to the expected data length. We suggest you place fewer fields in the listing page if you found the page rendering slow.

    See Also

    Listing Pages and Detail Pages to know the different between these two views.

    Designing the Listing Page to know how to design the listing page.

    5.5. Designing the Listing Page

    By default the listing page lists all fields. You can better utilize the space of the screen by changing the column widths according to the length of the data or deleting unwanted fields. It will be more convenient for users to search their data as well. Click "Modify design" in the operation panel to enter Design Mode. In later sections, we will introduce you how to delete fields and adjust column width step by step.

    Deleting Fields

    1. To delete the unnecessary field, first you need to select it, and then press "Delete" on you keyboard.

    2. Fields right next to the deleted ones will be automatically moved left. If you accidentally deleted necessary fields, do not save, just leave Design Mode and redo.

    As the figures below show, we deleted the field "Address" first. And then the fields on the right side automatically moved left.

    Adjust Column Width

    1. Adjust the grid line between two fields, as shown in the following figure.

    2. Save Edit then Exit Designer and you're done.

    5.6. Creating Database from Excel

    In this article, we will show you how to create a database application from an excel file. Following the steps in the import wizard, you'll have a simple prototype of your Ragic Builder database. You can modify the database design later to make it more suitable for your need.

    Step 1: Click "Design" in Menu Bar and then click the "Upload Excel" link under "Create New Application"

    Step 2: Click on “Browse”, choose the Excel file you want to upload. The file size should not exceed 10MB.

    Please make sure the first column of your Excel file table is a field that you can use to identify an entry, such as "Customer Name". It's not a good idea to use "Industry" as your first column.

    A good example of first column:

    A bad example of first column:

    Step 3: Click on “Upload” or “Next” when you are done with your selection.

    Step 4: The row colored in blue is the table header, if you want to assign another row as the header, just left click on it. Click on “Next” when you are done, as the following figure shows.(Pick another worksheet at the drop-down box if needed.)

    Step 5: Decide the destination of your uploaded file. Since we are going to creat a new database, we don't need to change the setting in this step. Just click on "Next". If you want to import the file to an existing database as a new sheet, pick the database at the drop-down box.

    Step 6: You can set the Hard Link[1] here to link your fields to existing fields in your Ragic Builder database. Click on "Choose Linked Field " under the field name, and you can choose the field from the popup window. If you don't neet any Hard Link, just ignore this step and click on "Next".

    Step 7: Choose the Input Type for your field by click on the drop-down box.

    Step 8: Enter the name and URL of this new database, and click “Import and Create!”.

    Step 9: Click on the link and you'll see your newly created database.

    The figure below shows the database we just created. A triangle appears in the columns we set as multiple select values.



    [1] Please refer to Linking Data

    Chapter 6. Mastering Ragic Builder

    This section describes in detail the functions and technics you need to know when creating a Ragic Builder application.

    Authorization Management sheds some light on the authorization mechanism used in Ragic Builder.

    Creating a Subtable Subtable is a powerful technique for modeling data that have one-to-many relationships. This article demonstrates how to create a subtable with a example.

    Introducing the Field Setting Panel Ragic Builder offers various settings for fields. This section tries to illustrate some of them.

    Setting Input Type for Fields introduces the five data types that you can use in Ragic Builder.

    Editing Descriptions briefly describes what Descriptions means in Ragic Builder.

    Making Database More Attractive Read this article if you want to make your application more eye appealing.

    6.1. Authorization Management

    Ragic Builder's authorization mechanism is all about managing users and groups. We suggest you first divide users into serveral different groups and configure each form's access right based on the groups. In the following sections, we introduce you how to manage a user, create a custom group, and assign suitable privilege for groups.

    Managing Users

    Click "Admin" in Menu Bar and then select the links under "Ragic User Management" when you want to create or manage the users for your application.

    When you first enter User Listing page, you'll find your account in the users table, as the following figure shows.

    Click "Create a new user" to create new users for your applications. Fill in username and email address and click the "Create a new user" button, as the following figure shows. After you hit the button, Ragic will send the default password to the user's e-mail account automatically. And later you can come back to the user list to assign groups for the users.

    After creating a new user, you can go back to User Listing page and click any user in the list to change the settings. Applicable settings are listed below. Refer to the figure below to know where they are.

    1. User Full Name: You can click on Change Name to give the user a new name.

    2. Groups: By default you can assign three different groups for your users. For more about groups, read the following section.

    Managing Groups

    By default, users can be divided into four groups:

    1. Everyone: Those who connect to your database and are not added to other groups belong to this group.

    2. User: Ordinary users of the database. Usually can only browse or modify partial data.

    3. Manager: The manager of the database. Usually configured to be able to browse and modify all data to help system administrator managing the database.

    4. SYSAdmin: By default, you yourself is the system administrator. If you assign another user as a system administrator, he/she will have the same privilege as you do. A system administrator can alter the design of the form or add, delete,and modify all data.

    If the default groups are not sufficient for you or your company, you can freely define your own groups. Click "Create New Group" link under "Ragic Group Management in Ragic System Administration page, as shown in the following figure.

    Fill in name and description about the group and click the "Create a new group" button to save the group and that's all.

    After a new group is created, you can assign users to that group. To assign users to certain groups, just follow the steps described in "Managing Users" section. For example, in the following figure, we assign John@ragic.com to the new group, Div1, that we previously created.

    Assigning Access Rights to Groups

    Access privilege is configured independently on a form basis. You can hit "Form Setting" button in Design Mode and then click "Access Rights" tab to change the access privilege for different groups. Notice that if custom groups are defined, they'll be displayed together with the default groups, as shown in the following figure.

    Currently there are five kinds of privileges.

    1. No Rights: Cannot read, create, or modify any data.

    2. User: Can create new data. Can read and modify data of their own.

    3. Viewer: Can read all data in the database. Cannot create and modify data.

    4. Power User: Can read all data in the database. Can create new data and modify the data of their own.

    5. Admin: Can read, create, modify any data in the database.

    You can authorize each group according to your needs. Do remember to set the access privilege in each form to ensure the security of your applications.

    6.2. Creating a Subtable

    A subtable is a table in a form. It might not be clear to explain it in words. Therefore please see the figure below. In this figure, fields about an employee’s education comprise a subtable. It lists the employee’s education in a table.

    So why is it so imporant that we want to discuss it in a separate article? A subtable itself is a great tool to both form and present your data. It can be used to model the data that have one-to-many relationship in realistic world.

    How to Create a Subtable?

    It is pretty simple and straight forward to create a subtable. Let's create an empty sheet first.

    In the empty form, we give it two fields, name and phone. Now let’s create a subtable for it. Say we want to list his past work experience as a subtable. First give it a previous company field. Then place a title field right next to the previous company field, as the following figure shows.

    See how the page looks right now. If you want to create a subtable, horizontally list the fields of the subtable together and you are done. Remember to Save Edit before leaving Design Mode.

    Summary

    Every form can contain unlimited numbers of subtables. Every subtable can keep multiple records. And each entry of a subtable can contain even more subtables. Clicking any data in the subtable directs you to the form in a deeper level. With the help of subtables, users can establish hierarchical relationship between data, which is a powerful way for modeling data, thus making it a distinguishing feature of Ragic Builder.

    6.3. Introducing the Field Setting Panel

    The Field Setting Panel is the core component when you design your form. You can set the input type, formatting, validation rule, data linking relationship, or formula…etc. of a field within the panel.

    Accessing the Attribute Panel

    To access the attribute panel, simply click on any field for which you would like to set the attributes. Click Field Setting in the operation panel. Then the Field Setting panel displays. You can drag and drop the panel by placing your mouse cursor on the title bar of the panel.

    Settings in the panel are grouped by tabs. The default selected tab is the 'Basic' tab. In the Basic tab you can see the name, the External Id, or the input type of the field you choose. Play around the panel and be familiar with what you can do in this panel. If you find some attribute to be difficult to understand, try click the question mark beside it. It will show you a brief explanation of the usage of the setting.

    External ID

    Ragic Builder use External ID to identify where the field is located in the database. The system gives every field an unique External ID automatically after you save your design.

    In general, once External ID is given, it won't be changed. The only exception is when you set "Hard Link"[2] to a field. The system will change External ID of the field, so that the two fields you set link can have the same External ID.

    6.4. Setting Input Type for Fields

    Input type is the data type of fields. The default input type is free text. You can change the input type from Field Setting Panel, as the following figure shows.

    Input Type

    There are a couple of types that you can choose from. Select the most suitable one for your data.

    1. Free Text: Ordinary text data.

    2. Selection: Data can be selected from a drop-down menu.

    3. Multiple Select: Multiple data can be selected from a drop-down menu.

    4. Link Other Sheet: Data can be selected from other form in your account.

    5. File Upload: Can upload a file.

    6. Graphic Upload: Can upload a graphic.

    Editing Selection

    If you set the input type to selection, you need to edit the value of the selection.

    You can enter your options in the right side of the Basic tab of the Field Setting panel, as the follwing figure shows.

    6.5. Editing Descriptions

    Your database application is completed after allocating fields and configuring the corresponding attributes. Good enough. But we can make it better.

    Field descriptions can be served as usage guide or column explanation, or can be used to indicate data grouping. We can add field descriptions so that users can more easily understand the application.

    In design mode, press the Editing Fields button on top and change it to Editing Descriptions. Then you can input descriptions to illustrate the meaning of the field or to suggest the input format.

    You can use the Desc Style button to change the font color, background color, or size of the description. For more about the settings, read Making Database More Attractive.

    6.6. Making Database More Attractive

    Ragic Builder provides users with functions for customizing the look and feel of their database applications.

    Operation Panel and Database Icon

    The art design of Operation Panel and Database Icon is the best way to show the user's or the company's style and to make your application different. It will also make your user interface more beautiful.

    When you create a new database application, the background picture of Operation Panel and database icon are given by default. You can change both of them for the whole database, or just for a specific form of the database. In the following sections, we'll explain how to do it.

    Click "Design" in Menu Bar. Now you are in "Designing Ragic Applications" page. Find the application you want to modify. Hover your mouse to the name of the application and click "Style" at the drop-down box if you want the style change for the whole database. Or you can just click the "Style" link of any form to change the style for the form only.

    In the Style Setting page you can see it has three major parts. The upper two parts are for Operation Panel design, and the bottom part is for the setting of database icon.

    Backgroud Picture of Operation Panel

    There are dozens of pictures Ragic Builder provides for you to choose from. You can click any picture and see how it looks in operation Panel right away, as the figure below shows. You can also upload your own picture if you can't find any suitable one in Ragic Builder.

    Text Style of Operation Panel

    By default the text color in Operation Panel is white. If you change the background picture to a lighter one and the white text can't be read clearly, you need to choose "Dark Header Text".

    Database Icon

    There are dozens of icons Ragic Builder provides for you to choose from. Or you can upload your own design, as the figure below shows.

    After you are done with the settings, please click "Save Changes" button on the Operation Panel.

    Database Form

    From Editing Descriptions, you might already know that you can add descriptions to your forms. But barely adding descriptions next to the fields might not be enough because sometimes we would like to make those plain descriptions more obvious to attract our users. Therefore, Ragic Builder provides users with a Desc Style tool for customizing the look and feel of the descriptions.

    To access the desc style tool for a specific form, click on any description you previously created. Then click the Desc Style button in the operation panel. A tiny pop-up window shows after the click. And then you can change the look and feel with the tools in this pop-up.

    Font type

    You can change the font type of descriptions by the first three buttons: B, I and U, meaning Bold, Italic, and underlined respectively.

    Alignment

    You can align the description to left, center, or right by the three buttons in the upper middle of the pop-up window.

    Colors and Backgrounds

    The A button can change the font color of the description. The button following the A is for changing the background color.

    Description Button

    The last button of the upper row is for you to create a hyperlink for the descriptions. Enter URL for the descriptions. Next time if the description is clicked, a new winodw with the url will be displayed.

    Font Family and Size

    You can change the font family and size of your description form the second row.

    See Also

    Editing Descriptions if you are not yet familiar with how to add description to your forms.

    Description Buttons to learn how to utilize the function that you can add external links to description in Desc Tool.



    [2] Please refer to Linking Data.

    Chapter 7. Ragic Builder Advanced

    This section introduces some more advanced topics ragarding the Ragic Builder platform, focusing on the features that might hamper users with little to no programming background.

    Linking Data Fields can be referenced using Soft Link and Hard Link. This article introduces the two linking strategy that Ragic Builder offers.

    Description Buttons can make a description into a hyperlink, thus enabling users to connect to other Ragic Builder databases or other external websites.

    Using Formula to Calculate Data Ragic Builder supports formula. Basic arithmetic operators like +, -, *, and / are all supported. This article introduces how to use formula properly.

    Using Regular Expression to Validate Data In Ragic Builder, you can use regular expressions to validate users’ input data. Read this article to learn how to do it.

    Administering Ragic Builder Server You can install your own Ragic Builder Server locally. Read this to know how to do it.

    7.1. Linking Data

    Hard Link

    You can reference a field that exsits in another form via setting Hard Link to connect two different forms. Duplicated external ids are not allowed in one form.

    Soft Link

    You can retrieve data that exists in other fields via setting Soft Link. Setting Soft Link will not change the field's external id. The field itself is still different from the field it retrieves data. Therefore, if you later modify the retrieved data, the source data will not be affected.

    Listen To

    With the configuration of listen to, we can bring in data based on the field we selected. Listen to will be valid only if it is set together with either Hard Link or Soft Link.

    If the data in listen to changed, the system will bring in the data linked to listen to. If there are more than one entry linked to this value, you can change the input type to selection.

    7.2. Description Buttons

    You can create description buttons for users to connect to other Ragic Builder databases or other external websites.

    First we place our description in a form. And then we set the connection via the link button. See the following figure if you still can't find it. It is in the Desc Style button.

    Internal Connection

    There are two part in the connection string, database url and page parameters.

    database url

    The url of the target database. The default domain is Ragic, so we don't need the http://www.ragic.com prefix here. For example, You can type "/demo/sales" to create a url connecting to the "sales" database under "demo" account.(http://www.ragic.com/demo/sales)

    page parameters

    There might be many forms in a database and there might be many levels of data in a form. We can suffix the parameters to the url to connect to the exact data we want. The first parameter is separated by "?" sign with the url. Parameters each are separated by "&" sign. Applicable parameters are as follows:

    1. fn: This parameter determines which form we would like to connect to. The first form would be "1_Sheet+1". The second form would be "2_Sheet+2". This rule applies no matter what names we give to our forms.

    2. dm: This parameter determines which level we connect to. Users will be directed to listing page if this parameter is not present. The first level is "index". The second level and so forth is determined by the external id of the top left corner, such as "10000888".

    3. edit: Which means go directly to edit mode after clicking the link. There is no correspondent value of this parameter.

    For example, if we want to link to the first level of the second form of the sales database under demo account and go directly to edit mode after clicking the link, the link will look like "/demo/sales?fn=2_Sheet+2&dm=index&edit"

    External Link

    Directly type the complete url of the website in the popup window, as the following figure shows.

    7.3. Using Formula to Calculate Data

    Ragic Builder supports formula. Basic arithmetic operators like +, -, *, and / are all supported. You can do simple static arithmetics like 6*(5+3) or you can create a formula whose value changes depending on the designated fields.

    Field Reference

    Before using formula, know that in Ragic Builder, a field can be refered using field reference. A field reference is comprised of its column id and row number. Take the following figure as an example, the cell in the figure is referenced as A2.

    To create a formula whose value changes according to certain fields, you need to refer the fields using field references.

    Writing the Formula

    Inputing the formula in Ragic Builder is simple and straightforward. First make sure you are under design mode. Click on the field that you would like to apply the formula. Click Field Setting in the operation panel. Turn to the tab that is titled "Formula". Enter your formula into the formula field.

    For example, we want the Sum field to be the sum of X and Y. In the following figure, we first open the Field Setting panel for the Sum field. In this example, X is at A2 and Y is at A3, so in the Formula setting of the panel, we set the formula to A2+A3.

    Later when you create or edit an entry, the value of Sum field will be automatically calculated based on X and Y, as the following figure shows.

    Formula Type

    "Formula Type" is at the upper right corner of "Formula" tab. We explain the two types below:

    1. Defaulting: The default value of the field is based on the result of the formula. But users can modify the value when editing the entry.

    2. Strict: The value or the fields will always be the result of the formula. Even if the user modify the value, the new value won't be saved into the database.

    For example, we set two fields, "D" and "S", the same formula, which is equals the field "Sum". But we give the two fields different Formula Type. Formula Type of the field "D" is "Defaulting", and Formula Type of the field "S" is "Strict".

    We go into Editing Mode, as the figure below shows. When the value of "Sum" is 14, both "D" and "S" have the same value, 14, which is automatically generated according to the formula we set. But we change the value of both fields to 16 to see what will happen.

    After saving our change, we go back to Browsing Mode. As the figure below, you can see that the value of "D" is 16 which is entered by us. But the value of "S" remains 14, the same with the value of "Sum".

    Formula for Subtables

    It is a common use case that you want to aggregate numbers in a subtable. Ragic Builder does offer some hands-on functions for users. Functions are used with field reference as a prefix followed by a dot sign, and finally followed by the function itself.

    1. C10: Simply putting a field reference sums up all data under the field.

    2. C10.COUNT: The count function is for counting item numbers.

    3. C10.ACC: The acc function can accumulate the data in the subtable.

    7.4. Using Regular Expressions to Validate Input Data

    Regular expression is a powerful tool for a broad range of applications, such as text manipulation and analysis. In Ragic Builder, you can use regular expressions to validate users’ input data. You are not required to be a master of regular expressions to use the validation that Ragic Builder supports. However, if you are going to customize the validation rules other than those rules that are already built by Ragic Builder, we suggest you read some other articles about regular expressions beforehand to get a better grasp of it.

    Using the Prebuilt Validation Rules

    First make sure you are under design mode. Click on the field that you are going to apply the validation rule. Click field setting in the operation panel. From the panel, select the “Validation” tab. See figure below if you cannot find it.

    In the validation tab, you can see that there are three prebuilt rules. As the name suggests, Not Empty means data in the field cannot be empty. So if you want to make a required field, use this rule. The second one “000~999” means that the field only accept numbers in the range from 000 to 999. The last one validates that the input data is in correct email format.

    Clicking on the prebuilt rules, you can see their corresponding examples and expressions. Select the one you would like to use, and then click OK. The field is now set with the validation rules you assigned. Remember to save your design before exiting design mode.

    Using Cusomtized Validation Rules

    Basically the steps are the same as what we did above. But you don’t need to select from the prebuilt rules. Just type in your custom regular expressions in the Validation field and then click OK, the field is now set with your cusom rule. Remember to save your design before exiting design mode.

    7.5. Administering Ragic Builder Server

    You can install your own Ragic Builder Server locally! All you need is a computer that is always up with a static IP address and permanent Internet access. You can install it on either Windows or Linux.

    Installation

    Install JDK

    JDK version 6.0 or above is recommended.

    Download and unzip Ragic Builder

    Please contact us for your copy of Ragic Builder. After getting the copy, unzip it to the computer where you would like to run Ragic Builder Server.

    Place your license file

    We will provide each Ragic Builder installation with a license, which is a zip file with two files in it: license.xml and sig. Please simply put both of these files under the cust directory of your Ragic Builder.

    Don't have a license? Apply for a developer license now!

    Set Environment Variables

    Please set the following two environment variables:

    1. RAGIC_HOME points to your Ragic Builder installation directory.

    2. JAVA_HOME points to your Java installation directory.

    Start Your Ragic Builder

    Go to your Ragic Builder's "bin" directory, and execute ragic.bat for Windows, and ragic.sh for Linux.

    Create Accounts and Start Building

    After you successfully ran Ragic Builder, you can go to http://localhost on that computer to see whether Ragic Builder is working or not.

    If Ragic Builder is setup successfully , you would see a login screen. Please go to registration page to create an account on your server. The accounts on your server is separate from ragic.com. You can create as many accounts as you need as long as you don't exceed your license limit.

    Configuration

    Your Ragic Builder configuration file is located at conf/ragic.properties. Generally it looks like this:


    # If SSL enabled, must create ./keystore file for java key
    # Must provide password to enable
    SSL_ENABLED=false
    SSL_PASSWORD=
    SSL_KEY_PASSWORD=
    SSL_TRUST_PASSWORD=
    SSL_KEYSTORE=./keystore
    SSL_TRUSTSTORE=./keystore
    # For sending out notifications
    # If left blank, no notifications will be sent
    SMTP_SERVER=
    SMTP_SENDER_EMAIL=
    # Should always be true for Ragic Builder
    USE_WAR=true

    The settings should be pretty straightforward, just remember to restart your Ragic Builder after you make your modifications to those properties.

    Backup

    All the data files are contained in the "cust" folder. To backup your Ragic Server, simply backup all the files in the "cust" folder. For busy servers, we recommend you shutdown the Ragic Server during backup to avoid incomplete backups.

    Terms and Glossaries

    D

    Detail Page

    The detail view of a specific data entry.

    E

    E-mail Id

    An attribute of a field. If set, system will send an e-mail with a URL with which the creator of the entry can identify herself as owner of this e-mail.

    Enterprise Desktop

    Enterprise desktop is the portal, i.e., the entry point to all your applications.

    Entry

    An entry is one record of data of the form.

    External ID

    The unique ID for a data field. The external ID will be shown as ‘undefined’ until you save your form.

    F

    Field Name

    The name of a data field.

    H

    Hard Link

    When two fields are hard linked, they point to the exact same field data and relation.

    I

    Input Type

    Type of an input element, such as free text, selection, or upload.

    Insert Merge

    An attribute of a field. If the input value of a field already exists, the system references the existing value instead of creating a new one.

    L

    ListingPage

    The listing page lists all the data assoicated with the form.

    S

    Soft Link

    When a field soft links another one, it only references the list of value of the other field.

    Subtable

    A subtable is a data structure used to model the data that have one-to-many relationship.

    Key Combinations

    For convenience, Ragic has some handy keyboard shortcuts that you can use for performing some often-used functions.

    Browsing Data

    In Listing Page: to previous entry

    In Detail Page: to previous field

    In Listing Page: to next entry

    In Detail Page: to next field

    In Listing Page: to the detail page of the entry

    In Detail Page: back to the listing page

    Page Up

    In Listing Page: to previous page(if more than one page and not at the 1st page)

    In Detail Page: to previous entry if not the first entry

    Page Down

    In Listing Page: to next page(if more than one page)

    In Detail Page: to next entry if not the last entry

    Creating Data

    n

    to create a new entry

    Ctrl+S

    to save the entry

    Esc

    for going back to browsing mode

    Editing Data

    e

    to edit data

    Ctrl+S

    to save the entry

    Esc

    for going back to browsing mode

    comments powered by Disqus