Master Sheet
Track the books, images and materials connected to your events
This master sheet brings together the key assets linked to each event, giving you a single view of all associated books, images, and promotional materials.
You'll see image previews for the jacket, author, and book AI where available, helping visualise what’s connected to each session.
This layout gives a similar experience to the person master sheet—offering consistent formatting and a linked detail view.
Each asset is tied to an author, a festival year, and an event record—ensuring all data points are easily traceable.
Below is a complete list of the properties on the Asset Master Sheet table, showcasing all the properties that can be recorded for assets involved in the festival.
| Property Name | Property Type | Description |
|---|---|---|
| Title | A single line of text | Title |
| asset_number [Dynamic] | An incrementing numeric ID for each record | For monitoring |
| Record ID [Dynamic] | Unique identifier of the record | ID |
| Type | Select a single value from a list of options. | Includes - Book Information, Festival Artwork, Non Book Event Info |
| ISBN-13 | A single line of text | Book ISBN |
| genre | Select a single value from a list of options. | Includes - Adult, Family, Childern, Young Adult |
| Age Range | A single line of text | Myriad of differing values |
| Book AI | A field allowing image and file attachments. | Author Information |
| Book Jacket Image | A field allowing image and file attachments. | Book Jacket Image |
| Book Author Image | A field allowing image and file attachments. | Author Image |
| Book Publisher | A single line of text | Publisher name |
| Book Requested | An on/off checkbox. | Boolean value |
| Book Received | An on/off checkbox. | Boolean value |
| Book Publicist Name | A single line of text | Name of publicist |
| Book Publicist Email | A single line of text | Email of publicist |
| Book Publicist Phone Number | A single line of text | Phone number of publicist |
| Event records [Dynamic] | Link to records from the event table. | The link to the event(s) |
| created [Dynamic] | Date and time when this record was created. | |
| created_by [Dynamic] | Person who created this record. | |
| updated [Dynamic] | Date and time when this record was last modified. | |
| updated_by [Dynamic] | Person who last modified this record. | |
| Festival Assets | A field allowing image and file attachments. | Images |
| Author | Link to records from the person table. | Author link to person table |
| Author in Event [Dynamic] | String (non-clickable) of Author | Author name |
| Festival Year | Link to records from the Festival table. | Identifier for year |
| Other Information / Notes | A long text field that supports formatted text | Asset notes |
| Event Order (from Event) [Dynamic] | A numeric ID for each event in order | Event order in numeric form |