As many of you know, columns types are organized using categories. These categories are oversimplified, but keeping this simple will help you figure out which type of column you need.
Today let’s focus on the Automatic category. You might ask yourself, “What does Automatic means here?”. The answer is simple. When a column type is set as « automatic », it will be automatically set and updated only by RowShare and users cannot manually edit values.
Take a closer look at the Creation date and Last Write date types:
- The first, Creation date, automatically displays the creation date of a row. Even if this column is added after your rows, the date displayed will remain the original creation date. It will never change!
- Last write date, allows to know the date of the last modification of your line. It is automatically updated by RowShare on each change on a row.
These dates are expressed in local time. You can even change your time zone manually from your account.
What’s the use?
These columns enable you to save time when adding rows in your tables. It will allow you to better monitor your activity. The displayed values are guaranteed: no one can manually modified these data. As far as I am concerned, I really like to use these types to protect answers before a deadline or to check when my contributors are updated their rows.
And some examples
These two types of columns will be very useful in many situations such as:
- Follow-up task or appointment: to ensure you reporting in the right time
- Organization contest: to take into account that the answers submitted in time
- Event registration: to know the date when the answer was given and so whether it is still relevant or to accept people in order of registration
- Business goals and sales forecast: To ensure that each well revaluates its projections every month
- Monitoring project progress: the last write date here ensures accurate monitoring