Ragic Logo
<< Creating a sheet Table of Contents Auto generated field values >>

Field types

Ragic supports different field types that could be specified from the Design Mode while designing a sheet. The field type is defaulted to Free Text, which allows the user to enter content without restrictions, but Ragic will try to determine what field type you need when you enter a field name. While this works in most cases, the application will generally work better if you specify the right field types. The Field Type can be set in the left sidebar, under the Basic tab in the Design Mode.

We will explain some of the field types available in Ragic below:

Free Text

The default field type. Users can enter whatever they want under these fields, and there are no length restrictions for text input.

Selection

Users may select a value from the dropdown menu, with values that you have supplied in the "Choices" box in the Design Mode.

This field can also work like a text filter that displays the options available while the user types, when there are many choices to choose from. It is also possible to set a value as the default value.

If you need to set different categories, such as options that will display results connected to what is selected previously in another selection field, you can set cascaded selections.

Multiple Select

This field type works pretty much like the Selection field, but lets users pick from multiple choices with checkboxes.

Checkbox

This field type works similar to the Selection field, but shows the option with icon.

By default, there will be two options, Yes and No.

You may also refer to the table below to add different or more options:

Options Icon
X
Important
Star
Green
Yellow
Red
Blue
Black
White

Select from other Sheet

Users can select values that are referenced from another sheet when inputting to this field. You can select the sheet to be linked from the Design Mode. This sheet could be from any applications that you have under your account. Clicking on the dropdown menu will make a panel pop out that will display detailed information from the referenced sheet. For example, in the "order form" displayed in the image below, the "customer" field is set to "select from other sheet", in which the user will be able to pick from a list of customers to be set as the customer related to the order form that is being filled.

The Select from other Sheet field can also work like a text filter that displays the options available while the user types.

If you need other values to load when you select a value from another sheet, you can set this with the link & load linking type instead.

File Upload

Users can upload a file as the value of the field, which will be shown as a downloadable link.

While there are no restrictions that Ragic has on what type of files can be uploaded, if you would like to restrict the file type that users upload, type the file name extension in the file name extension filter. If more than a single file name extension should be accepted, please use a comma (,) to separate them.

If the upload file is an audio or video file, Ragic will display a media player for supported files so that you can stream your media.

Audio files will be displayed in an audio streamer. The supported audio files are .mp3 and .ogg

Video files will be displayed in a video streamer. The supported video files are .mp4, .ogv, and .webm

When there is a media streamer present, the upload file can still be downloaded by double-clicking on the upload field.

If you'd like to upload files to multiple existing records, you can use the mass file upload feature.

Image Upload

The user can upload an image as the value of the field, which will be displayed as a thumbnail in this field.

Users can view and download this image in a lightbox upon clicking on the thumbnail, provided they have the necessary access rights to the sheet.

If you'd like to upload images to multiple existing records, you can use the mass file upload feature.

Select User

Lists the users of this account to choose from.

It's also possible to specify a certain user group that this user can be selected from, or have the selected user be from the same user group as the submitter.

If you choose "Set selected user as entry owner", the person that is chosen as the value for this entry will have the same accesss right as the person who created this entry. This access right will enable a user to see an entry when his role is "survey user", or enable him to edit an entry when his role is "bulletin user".

Please view this documentation on assigning an entry to a user for more information.

Select Group

Lists the groups of this account to choose from. If you choose "Set selected group as entry owner", all users in the group that is chosen as the value for this entry will have the same access right as the person who created this entry. This access right will enable the users of a group to see an entry when their role is "Survey User", or enable them to edit an entry when their role is "Bulletin User".

Date

Specifies that the field is a date. A date picker will appear when the user clicks on the field. You can also choose a date format from the formatting options in the Design Mode listed under "Format Type".

If you have a time formatting applied, the date picker will show a date and time picker.

Formulas can be applied on dates in order to calculate dates.

Another common usage for the date field is to create a time stamp. This can be done by assigning a default value to the date field.

Date fields can trigger reminders, or help you remember dates by adding fields to your favorite calendar application.

Numeric

Specifies that the field is a numeric value. You can also choose a format from the formatting options in the Design Mode listed under "Format Type".

Numeric fields are most commonly used with formulas.

Auto Generate

The value of the field will be automatically generated by Ragic. This is a great help for generating system ID and document numbers. You can choose from a list of formatting options provided in the Design Mode, or customize by writing your own.

The user will see the field Auto Generate when they are entering data to the form.

Ragic will generate a number or string according to your formatting.

For more information about this field, please see the Auto Generated Field Values section.

Signature

A digital signature can be added to this field by the user via mouse or trackpad.

Rich Text Editor

The Rich Text Editor field type gives your users options to format text being written in this field, as well as inserting images, tables, and links. When editing this field, the Rich text editor window will pop up with various options that will help with the styling of content being added.

Barcode

You can use the Barcode field type to generate a Barcode. There are a selection of Barcode types you can generate in Ragic, such as Code 128 and QR Code.

Alternatively, you can configure additional field settings to display the value as a Barcode. (Code 128)

Money

Similar to the field type Number, this field specifies that the field type is a money field which you can apply formulas to. You can edit the currency format from the formatting options in the Design Mode listed under "Format Type".

Exchange Rate

Ragic will automatically fetch the latest exchange rate in the specified currency combination as its value. You can use this exchange rate in formulas to calculate the currency based on the latest exchange rate data.

Reviewer

You can assign specific users to review specific entries by setting up a "Reviewer field".

E-mail

The value of this field will be formatted as a link to the e-mail. Clicking on the value of an e-mail field will act according to your browser settings, such as launching an e-mail application.

Phone

The value of this field will be formatted according to the format type that you specify in the Design Mode. Clicking on the value of a phone field will act according to your browser settings, such as launching a conferencing application.

Address

The value of this field will be recognized as an address and clicking on the value will take you to google maps.

URL

The value of this field will be recognized as a link, and clicking on the value will take you to the linked website.

Special Format

The value of this field will be formatted according to universal standards that you can specify.

There are some options that are available such as SSN (Social Security Number) and VIN (Vehicle Identification number), but you can also enter your custom format too.

Top of Page
<< Creating a sheetTable of ContentsAuto generated field values >>
Learn more about Ragic: Why we created Ragic | Webinars | User Guide.
Keep in touch: Blog | Email | Facebook | Twitter.
Ragic, Inc. | +1 888-666-8037 | Terms | Privacy