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

Well, with advanced columns, the options become all the more 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 in other articles:



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
Was this article helpful?
Cancel
Thank you!