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:
The default field type. Users can enter whatever they want under these fields, and there are no length restrictions for text input.
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.
This field type works pretty much like the Selection field, but lets users pick from multiple choices with checkboxes.
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.
If you would like to add more icons other than the default grey check and green check, please refer to the following table:
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.
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. The file size limit is 1GB. 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.
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.
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.
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".
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.
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.
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.
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.
A digital signature can be added to this field by the user via mouse or trackpad.
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.
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)
The Masked Text field type is similar to the field type Free Text, but as an additional feature this field can be configured to display only the last N digits, as well as the user group that can access the complete information.
Clicking on Preview button for the users who have the correct access rights will show you the complete information.
Please note that the masked text field cannot be edited. For the data security purpose, the field value will be cleared when you try to edit the content in masked text field.
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".
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.
You can assign specific users to review specific entries by setting up a "Reviewer field".
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.
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.
The value of this field will be recognized as an address and clicking on the value will take you to google maps.
The value of this field will be recognized as a link, and clicking on the value will take you to the linked website.
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.