Columns serve as great tools to add structure to a worksheet.

Well, with advanced columns, the options become vast and exciting, on both web and mobile! Let's take a look at a few and how they are geared to build complex applications right on Grid.

Let's start with a short video that will explain some advanced columns that have not been dealt with in other articles:

[Advanced columns - Document, Sequence Generator, User Listing and Location Column]

Advanced Columns
These advanced columns are not only helpful but great fun to discover.
Document: As can be inferred, this column is storage for important documents in your GRID worksheet. It's most common use is for storing PDF files of approved documents, machine manuals, sensitive engineering drawings, customer POs etc.

Document Column
Do check out how to keep your important documents protected with the feature of data access right here.

Sequence Generator: The sequence generator is quite a hit amongst many users. Well, what's so exciting about it?
It allows you to create unique identifiers for your assets, customers, and more right in the worksheet.

Sequence Generator Column
Here is how it is set up.
The Prefix/Suffix section is used to create a format for UIDs and the counter lets you activate the UID from any particular number.

You can also make the sequence generator column editable by enabling the editable option.

User Listing: This column lets you tag a GRID user to a specific row on the worksheet. It also lets you set a notification/reminder or apply for data access on view/entry for the tagged user. You can also limit the users shown in the list to specific teams.

User Listing Column
Location: The location column also has the manual feature where you can manually list your location instead of the GPS coordinates. This works suitably well during surveys or when there is a requirement for capturing location while the data is being entered on mobile.

Location Column
The location column also has the auto manual feature where you can manually list your location instead of the GPS coordinates.
Do check out how to keep your important documents protected with the feature of data access right [here]

Try out more advanced columns like [Print Format], [Link to Worksheet], [Child Table] and [Formula]