1. What are Website Plug-ins?

Ragic applications come with a variety of useful Website Plug-ins that could be embedded on your website, or sent as a separate link to others. These website plug-ins become available automatically as you create the sheets in your applications.

This means that you could embed forms to your website that will be stored in your database once they are submitted, or give access to your customers and clients to search your database, or even view your entire database.

2. Embedding your Database with the Web Embed Tool

To view the website plug-ins that are available, click on the Tools menu on either the listing page or form page, and select Embed This Sheet under Share in the menu.

After following the steps in the wizard, Ragic will give you an HTML code snippet that you can copy & paste to the place where you want to embed the plug-in on your website. You will also see a form link for you to simply send out to directly use the plug-in as a standalone page.

Ragic also supports embedding on wordpress with a wordpress plug-in.

3. Types of Website Plug-ins

Deciding on how your viewers will be viewing your database is the key when choosing which type of website plug-in to use. Here is a condensed guide to choosing the correct plug-in depending on your purposes (click on the plug-in name for more information).

Embeds your database in an iframe with the Ragic UI you see on your account

Once you choose the type of the website plug-in, you may also tune the layout of your embedded forms with custom CSS.

3.1. Database Viewer

The database viewer is a simple listing of all the entries that your website user has access to. You can grant access to your entries with Ragic's access rights, which also gives you the option to make the entire database public if needed.

You can configure different types of layouts listed below on the first step after picking "Database Viewer" as your web embed type.

Just like the listing page - form page transition, your viewers would be able to click on the entries to view the more detailed form page.

3.1.1. Database Viewer Layout Types

The table layout shows your records with a bare-bones list, which is displayed according to how you display your listing page.

The block layout has a little more flexibility, it will display your records in rows according to the fields you would like to pick in this configuration. Simply hover on the fields that are displayed in the preview to change the field that is mapped to.

The album layout is suitable if you have images in your database. This layout shows an image as a thumbnail, and your records will be arranged in a grid. Like the block layout, you can hover on the fields that are displayed to change the fields they are mapped to.

3.2. Database Query

The database query form allows your users to query your Ragic database with the criteria available for each field you decide to add.

You can pick which query fields will be shown as default, as well as the order you would like the fields to appear in, on the configuration page. To do so, click "Set Default Query Field"

The query fields will be displayed in accordance to the field types in your sheet. For example, if your field is a selection field, the query form can show multiple selection options in a dropdown menu so that the query can be made in multiple categories.

After the query is submitted, users of your form will be able to view records that fit into their query criteria with the database viewer layout type you pick in the next step.

Just like the listing page - form page transition, your viewers would be able to click on the entries to view the more detailed form page.

3.3. Database Form

The database form gives you the option to embed a form that your users can fill. The forms will automatically be saved as entries in your database when submitted by your users.

You can slightly tune the way your form is displayed for some field types, such as selection fields. Clicking on the "change type" text on the bottom of fields in the configuration will switch a selection field from a dropdown menu to radio buttons.

3.4. Database Search

The search results will be displayed similarly to the database viewer with the criteria that was entered. After the search is submitted, users of your form will be able to view records that fit into their query criteria with the database viewer layout type you pick in the next step.

Just like the listing page - form page transition, your viewers would be able to click on the entries to view the more detailed form page.

3.5. Raw Embed

Embed the exact same spreadsheet UI you see on Ragic with an iframe on your website. This is not a bare-bones HTML form or list, so it will be different from the other embedding options above. Users will need to log in to your account if you don't have public sheets set up.

On your settings for the raw embed, you will have the options of defaulting to create a new entry or not, showing the search sidebar, and showing the top form buttons to users.

After setting up, you can copy and paste the embed code and use it to embed Ragic on your website.

Users will be able to do full text searches from the search icon on the upper right corner, similar to how full text searches are done within your Ragic database sheets.

4. Access Rights

One great advantage of using the Web plug-in is that you do not need to purchase user licenses for users of the Web plug-in if your sheets are set as public (except for the raw embed).

On the other hand, if you didn't set your sheets as public while using Web plug-ins, visitors will see a log in page if they are not logged in.