...
Click on ‘Add’ a table.
Enter the name of the table.
Auto-generate the table name to create the database table name and the model name.
If you want to be able to show updates from this table in the Audit report, enter ‘mayAudit’ into the flags section. You can also add other areas to have valid/invalid records, block deleting, and more. See the behavior and hook notes under flags.
Click on ‘Save’. The page will refresh.
Click on ‘Implement’ Table.
...
Adding a Field
Click on ‘Options’, then select ‘Fields’ next to the table you wish to add a field to
Click on ‘Add Field’, or if you want to modify a field, click on ‘Modify’ next to the field name.
Enter the name of the field and a brief description of the field, if applicable.
Auto-generate the ‘Database Column Name’, ‘Model Attribute Name’, and ‘Model Association Name’.
Select the data type (options include):
Text
Date/Time
File (single, multiple, with metadata)
Numeric (ie ‘real 6 3’ means 6 numbers before decimal place, 3 numbers after
Geolocation options
Enum List (this is a single select drop down menu option) **If enum, add the values that are available in the enum list.
Add behavior flags, if applicable (options and descriptions are outlined on the page). To add, type in the exact name of the flag listed and hit {Enter} on click on ‘Add to List’
Click on ‘Save’
Click on ‘Implement Field’.
...
6. Click on checkboxes for ‘Built in sort of table results’ and ‘Filterable table results’ to allow for sorting and filtering by columns in the table.
7. Click on ‘OK’
...
...
Menus
Add the page to specific menus
...
**If contract specific, the link will be the same as the page view (oneoffice/contract/name of table), except you need to add {url.contract} before the name of the table so that it identifies the specific contract in the URL. /oneoffice/contract/{url.contract}/bid-entry Example: /oneoffice/contract/complaints?contract={url.contract}
6. Click ‘Save’.
...
...