Table of Contents
Log Sheets
A LOGSHEET field type embeds a mini spreadsheet on each feature on your layer. It is intended to be used as a daily or periodic log of readings, inspections, or test results. Each row of the log sheet records one set of readings (ie. one day). And each column represents the different types of readings you want recorded such as Date, Pressures, Test results, or even notes. You cannot go back and edit previously logged rows. This is by design so that you can trust that your data will not be tampered with.
How To Setup
To add a log sheet to a layer, go to the Add/Remove Fields screen for that layer, click "Add new field", and then select LOGSHEET as the field type. Next you will be prompted to define your log sheet's columns. Take care in doing this because once you have finished setting up this new log sheet you will not be able to go back and rearrange the order of your columns. You can always come back to this setup screen and add new columns. And you can hide obsolete columns by erasing the column name. But you can not re-order the columns. To view your log sheet and start entering data, click on any feature on that layer and then locate and click on the new log sheet field found on the feature form.
Export
When viewing a log sheet you can click the "Export" button to download that data to a CSV file. Alternately, you can select Export Log Sheets from the map's Export menu to download a combined CSV file containing log sheet data for all features of this layer.
Clear
A "Clear" button will appear on the log sheet form if you are an Account Manager. This provides a manager to erase all rows from the log sheet at the end of the month or year so that you can start over with a clean slate.