worksheets

[alfresco]

I would like to have the ability to add general comments or notes to worksheets even the pre formatted worksheets such as Landscape Areas.  Often additional information would be advantageous   Thanks.

[Pat Stanford]

In Reports (Database fields), all data must be either integral to the object (ie dimensions, class, layer, etc.) or in a Record.Field combination. It can be ANY record.field that you want.

 

So create a Record (named MyNotes [ or whatever you want the name to be]) with a Field (named Note1 [OWYWTHTB]). 

 

Attach this record to the objects to be displayed in your report.

Create a new column in the report with a formula of =MyNotes.Note1.

 

Now anything you type into that column will be stored in the record and recalled when you recalculate the worksheet. You can edit the data either in the worksheet or in the Data pane of the OIP.

 

Having to attach the record to each object makes it less than ideal, but this is currently the only way to get freeform text entry in to a database.

 

Some PIOs (Doors, Windows, maybe others) have User Fields in the PIO Record that could be used for this instead of the custom record format.