FAQ
How can we help?
Full Site Search

What Is an Independent Field, and How Does It Differ from a Subtable Field?

An independent/regular field on a Ragic sheet is a field where the Field Header and Field Value are horizontally aligned. For example, the following five fields are all independent/regular fields:

When presented on a Form Page, independent fields represent a one-to-one data point, meaning that an independent field in a single record can only store one Field Value.

For example, if a customer's contact information is stored as one Ragic record, and the customer has only one company name, one tax ID, etc., representing one-to-one data points, then the company name and tax ID should be set as independent/regular fields:

On the other hand, a Subtable in Ragic sheets has Field Headers and Field Values vertically aligned, meaning that the Field Headers are displayed horizontally. For example, the following four fields are all Subtable fields:

When presented on a Form Page, Subtable fields represent a one-to-many data point, meaning that under a single Ragic record, a Subtable Field Header can store multiple Field Values.

Continuing with the example above, if a customer's information is stored as a single record, and the customer has multiple contact persons, it is appropriate to use a Subtable to record multiple contact persons for one customer:

Top of Page

    Start Ragic for free

    Sign up with Google

    Terms of Service | Privacy Policy