Database Design Documentation
How can we help?
Full Site Search

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.

Ignore record lock

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

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 (?).

Manual Attributes

Note: Please do not use this feature unless instructed by Ragic support.

To add manual attributes to a field, you can enter the Design mode of the form page, select the field, and navigate to Field Settings > Other > Manual attributes on the left side of the page.

After entering your parameter to the Manual attributes configuration, click the "+" button next to it.

You might notice the entered parameter is now cleared, which means it has been added to the field.

Before exiting the design mode, please don't forget to save your design changes.

To remove an attribute, simply try to add an empty attribute value to an attribute and the attribute will be removed.

Top of Page Table of Contents

Start Ragic for Free

Sign up with Google