Ragic supports different field types that can be specified from Design Mode while designing a sheet. The default field type is 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 well in most cases, the application will generally work better if you manually select the correct field type. The Field Type can be set from the left sidebar, under the Basic tab in 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 this field, and there are no length restrictions for text input.
Users select a value from the dropdown menu of values previously entered into the Choices box while in Design Mode during sheet creation.
When there are many choices to choose from, this field can also work like a text filter, displaying available options as the user types. It is also possible to set a value as the default value.
If you need to create subcategories or display results connected to a previous selection field, Ragic allows you to set cascaded selections.
This field type works exactly like the Selection field, but it allows users to check their preferred option rather than typing and clicking.
This field type works similar to the Selection field, but displays options with icons rather than option names.
By default, there will be two options: Yes and No.
To sort the values in the checkbox field on the Listing Page, you can include their sorting order within parentheses ( ). This will number the icons as a prefix next to the icon name. The text in ( ) will only be displayed in Design Mode.
If you would like to add icons aside from the default grey and green checkmarks, please refer to the following table:
Users can select values that are referenced from another sheet when entering data into this field. You can select the sheet to be linked from Design Mode. Sheets can be uploaded from any applications created from 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 sheet 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 previous customers when completing the pending order.
The Select from other Sheet field can also work like a text filter that displays available options as the user types.
If you need to load other values when selecting a value from another sheet, you can click here to use Linking and Loading Fields instead.
Users can upload a file as the value of the field, which will be shown as a downloadable link.
While Ragic has no restrictions on what type of files can be uploaded, if you would like to restrict user uploads, just type the acceptable filename extensions into the Filename Extension Filter. The size limit for a single upload is 1GB. If accepting more than a single filename extension, please use a comma (,) to separate them.
If you upload an audio or video file, Ragic will automatically display a media player for streaming supported files.
Audio streaming supports .mp3 and .ogg files.
Video streaming supports .mp4, .ogv, and .webm files.
While integrated media streaming is provided, the uploaded files 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.
Users can also upload an image as a field value, which will be displayed as a thumbnail in this field.
Users can view and download this image in a lightbox image gallery by clicking on the thumbnail, provided that 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.
Choose from a preset list of account users.
It's also possible to specify a certain user group that this user can be selected from, or to 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 rights as the person who created the entry. Access rights give users permission to access or modify sheets. For example, Survey users have limited read rights only, while Bulletin users are able to edit existing entries and create new ones.
Please view this documentation on Assigning an entry to a user for more information.
Lists the groups from this account to choose from. If you choose Set selected group as entry owner, all users in the selected group will have the same access rights as the person who created this entry.
Specifies that the selected field is a date. A Date Picker will appear automatically when the user clicks on the field. You can also choose a date format from the formatting options listed under Format Type in Design Mode.
Note: If you also have time formatting applied, the Date Picker will allow you to set both options.
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.
If you want to set Reminder to send birthday e-mail automatically to customers every year or payment request to clients every month, you can create Recurring Date Field.
For the recurring Cycle, there are three options: Yearly, Monthly and Weekly.
When choosing Yearly, the recurring value will be month and day. For Monthly, the value will be the day of every month. For Weekly, the value will be the day of every week.
Specifies that the selected field is a numeric value. You can also choose a format from the formatting options listed under Format Type in Design Mode.
Numeric fields are most commonly used with Formulas.
The value of the selected field will be automatically generated by Ragic. This is a great help for generating system IDs and document numbers. You can choose from a list of formatting options provided in the Design Mode, or customize the values by writing your own filing codes.
When clicking on a field to enter data, users will see the Auto Generate option.
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 via mouse or trackpad.
You can set the background image for a signature field by uploading an image or linking to the URL of an image.
The Rich Text Editor field type gives users text formatting options, as well as the ability to insert images, tables, and links through use of a pop-out menu. There is also space for content editing and style notes.
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 Codes.
Alternatively, you can configure Additional field settings to display values as Code 128 Barcodes.
The Masked Text field type is similar to the Free Text field type, but can additionally be configured to display only the last N digits of text, as well as full details for select users.
Users with access rights can click the Preview to see the full information.
Note: The masked text field cannot be edited. For data security purposes, the field value will be cleared when you try to edit content in a Masked Text field.
Similar to the Number field type, this field type sets the selected field as a money field that you can apply formulas to. You can edit the currency format from the formatting options listed under Format Type in Design Mode.
Ragic will automatically fetch the latest exchange rate for 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 rights 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 link will prompt your web browser to respond according to its settings, such as by launching an e-mail application.
The value of this field will be formatted according to the format type that you specified in Design Mode. Clicking on the value of a phone field will prompt your web browser to respond according to its settings, such as by 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 preprogrammed options available such as SSN (Social Security Number) and VIN (Vehicle Identification number), but you can enter custom formats here as well.