Additional Field Settings

Configuring Additional Field Settings

You can configure additional field settings apart from a default value and a field formatting from the Design Mode, under Field Settings > Basic.

Not Empty

Setting fields to "Not Empty" indicates that the field value should not be empty. Fields with this attribute will be marked with a red asterisk on the upper left side of the field title.

Unique

When you set a field as unique, the value of this field cannot be a duplicate.

This feature is most useful when you want to make sure that you do not register the same thing twice in your database, for example, a username, e-mail or phone number.

With this configuration, when a user tries saving a record with the same value for a field marked as "unique", not only would the database prevent the user from saving, but will also display a pop-up window that includes a link to the original saved record.

Subtable Unique

You will see this option in subtable field settings (which is different from the "unique" attribute of general table field settings). Checking this option will block users from entering duplicate subtable field value in an entry, but subtable values in other entries are not subject to this restriction.

Read Only

A field can be set as read-only, which means that the value of this field cannot be changed.

This feature is most useful for fields that are referenced from another sheet, autogenerated fields, or fields that have a default value set.

Column Span (Merge Cells)

You can merge cells on your forms to span columns so that a single field may look wider.

This is significantly different than the method to adjust the height of a row or the width of a column.

Do Not Clone

If you're creating many entries with similar data, sometimes it's useful to clone the entry instead of rewriting data.

If you use the clone entry function often, you can set the fields that should not be cloned while cloning an entry as "do not clone".

No Wrap Text

When this configuration is set, the text in this field won't be wrapped.

Barcode

Specifies that the value of this field will be displayed in barcode. (QR Code)

If you would like to generate other types of Barcode, such as Code 128, you may use the Barcode field type.

Hidden

Specifies that the field that will be hidden in the following:

1. Spreadsheet interface

2. Printer Friendly view

3. Excel download (and related export options)

4. Web embed form

The hidden field can be used to store values that you might need as constants, for formulas, and other use cases where the ability to view this value will not be practical for the user.

When used in a subtable, a hidden field will leave a gap, therefore while designing a form, please consider moving hidden fields to the end of the subtable.

Field Instruction

You can add field instruction to help user enter data to the field.

The configuration for field instruction can be found from left panel under design mode > Field Settings > Other.

This will add a (?) to the field header, and your instruction will show when user clicks on the (?).

Ignore record lock

When enabling this option, this field will remain unlocked after locking the record.

Manual Attributes

You can add manual attributes to the field. However, please do not use this feature unless instructed by Ragic support. For more details, please refer to this article.