<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><style>
p {
margin: 0;
}
span.fr-emoticon.fr-emoticon-img {
background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle;
}
span.fr-emoticon {
font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0;
}
blockquote {
border-left: solid 2px #5e35b1; color: #5e35b1; margin-left: 0; padding-left: 5px;
}
blockquote blockquote {
border-color: #00bcd4; color: #00bcd4;
}
blockquote blockquote blockquote {
border-color: #43a047; color: #43a047;
}
table.grid {
border-collapse: collapse;
}
table.grid td,
table.grid th {
border: 1px solid #ddd;
}
.fr-fic.fr-dib {
display: block; margin: 5px auto;
}
.fr-fic.fr-dib.fr-fir {
text-align: right; margin: 5px 0 5px auto;
}
.fr-fic.fr-dib.fr-fil {
text-align: left; margin: 5px auto 5px 0;
}
.fr-fic.fr-dii {
float: none; margin: 5px auto;
}
.fr-fic.fr-dii.fr-fil {
float: left; margin: 5px auto;
}
.fr-fic.fr-dii.fr-fir {
float: right; margin: 5px auto;
}
img.fr-dib.fr-fir {
margin-right: 0; text-align: right;
}
img.fr-dib.fr-fil {
margin-left: 0; text-align: left;
}
img.fr-dib {
margin: 5px auto; display: block; float: none;
}
img.fr-bordered {
box-sizing: content-box; border: solid 5px #CCC;
}
img.fr-shadow {
box-shadow: 10px 10px 5px 0px #cccccc;
}
img.fr-rounded {
border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;
}
</style><style>
p {
margin: 0;
}
span.fr-emoticon.fr-emoticon-img {
background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle;
}
span.fr-emoticon {
font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0;
}
blockquote {
border-left: solid 2px #5e35b1; color: #5e35b1; margin-left: 0; padding-left: 5px;
}
blockquote blockquote {
border-color: #00bcd4; color: #00bcd4;
}
blockquote blockquote blockquote {
border-color: #43a047; color: #43a047;
}
table.grid {
border-collapse: collapse;
}
table.grid td,
table.grid th {
border: 1px solid #ddd;
}
.fr-fic.fr-dib {
display: block; margin: 5px auto;
}
.fr-fic.fr-dib.fr-fir {
text-align: right; margin: 5px 0 5px auto;
}
.fr-fic.fr-dib.fr-fil {
text-align: left; margin: 5px auto 5px 0;
}
.fr-fic.fr-dii {
float: none; margin: 5px auto;
}
.fr-fic.fr-dii.fr-fil {
float: left; margin: 5px auto;
}
.fr-fic.fr-dii.fr-fir {
float: right; margin: 5px auto;
}
img.fr-dib.fr-fir {
margin-right: 0; text-align: right;
}
img.fr-dib.fr-fil {
margin-left: 0; text-align: left;
}
img.fr-dib {
margin: 5px auto; display: block; float: none;
}
img.fr-bordered {
box-sizing: content-box; border: solid 5px #CCC;
}
img.fr-shadow {
box-shadow: 10px 10px 5px 0px #cccccc;
}
img.fr-rounded {
border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;
}
</style><style>
p {
margin: 0;
}
span.fr-emoticon.fr-emoticon-img {
background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle;
}
span.fr-emoticon {
font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0;
}
blockquote {
border-left: solid 2px #5e35b1; color: #5e35b1; margin-left: 0; padding-left: 5px;
}
blockquote blockquote {
border-color: #00bcd4; color: #00bcd4;
}
blockquote blockquote blockquote {
border-color: #43a047; color: #43a047;
}
table.grid {
border-collapse: collapse;
}
table.grid td,
table.grid th {
border: 1px solid #ddd;
}
.fr-fic.fr-dib {
display: block; margin: 5px auto;
}
.fr-fic.fr-dib.fr-fir {
text-align: right; margin: 5px 0 5px auto;
}
.fr-fic.fr-dib.fr-fil {
text-align: left; margin: 5px auto 5px 0;
}
.fr-fic.fr-dii {
float: none; margin: 5px auto;
}
.fr-fic.fr-dii.fr-fil {
float: left; margin: 5px auto;
}
.fr-fic.fr-dii.fr-fir {
float: right; margin: 5px auto;
}
img.fr-dib.fr-fir {
margin-right: 0; text-align: right;
}
img.fr-dib.fr-fil {
margin-left: 0; text-align: left;
}
img.fr-dib {
margin: 5px auto; display: block; float: none;
}
img.fr-bordered {
box-sizing: content-box; border: solid 5px #CCC;
}
img.fr-shadow {
box-shadow: 10px 10px 5px 0px #cccccc;
}
img.fr-rounded {
border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;
}
</style><p><strong>In this guide we will cover:</strong></p><p><strong>- What are Custom Tables?</strong></p><p><strong>- Creating Custom Tables</strong></p><p><strong>- Displaying Custom Tables</strong></p><p><strong>- Custom Fields on Custom Tables</strong></p><p><strong>- Auditing Custom Tables</strong></p><p data-pasted="true"><strong>- Access Control</strong></p><p><br></p><p><br></p><p><strong>Admin Guides:</strong></p><ul><li><strong><a data-fr-linked="true" href="https://usehalo.com/haloitsm/guides/1436/" id="isPasted" target="_blank" rel="noopener noreferrer">Custom Tables</a></strong></li></ul><p><br></p><p><strong><span style="font-size: 14pt;">What are Custom Tables?</span></strong></p><p>Custom tables allow you to store information against various entities in table format, this can either be just for reference or to used to support other automation functionalities such as <a data-fr-linked="true" href="https://usehalo.com/haloitsm/guides/2041" id="isPasted" target="_blank" rel="noopener noreferrer">Dynamic SQL Lookup Fields</a> and <a data-fr-linked="true" href="https://usehalo.com/haloitsm/guides/2241/" id="isPasted" target="_blank" rel="noopener noreferrer">Custom SQL Query for Licence/Subscription Count on Recurring Invoice Lines</a> . Custom fields are stored within a custom table, as a column, therefore when creating custom tables you must create the table itself and the fields that will be used as the table columns. In this guide we will run through how to create custom tables. <strong><br></strong></p><p><br></p><p><span style="font-size: 14pt;"><strong>Creating Custom Tables</strong></span></p><p>Custom Tables are created under Configuration > Custom Objects > Custom Tables.</p><p><br></p><p>All Custom Tables are shown here in one list and the entity is chosen during the creation of the Custom Table. Once the Custom Table is created a field list tab will show and custom fields can be added that will show on the custom table. For creation of custom fields please see the <a data-fr-linked="true" href="https://usehalo.com/haloitsm/guides/1938/" id="isPasted" target="_blank" rel="noopener noreferrer">custom fields </a>guide.</p><p><br></p><p><strong><em>Note: Set the "Link to another entity" field upon creation, as this cannot be edited later.</em></strong></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImI1ZmM1NWRkLTdiY2UtNGIzYy05ZWNkLWZlNDc0MTM3ZmE1YiJ9.C5V3QUKaFc_mCtXS8eovsJmHnh3czjRgJfuOsMRgpVE" class="fr-fic fr-fil fr-dib" width="1015" height="666"></p><p><strong><span style="font-size: 10pt;">Fig 1. Creating a custom table</span></strong></p><p><br></p><p>The entity the custom table is linked to will determine where the custom table appears in your instance/what entity it is stored against. For example, if you select 'Area' as the entity to link to, the custom table will appear against all customer profiles. From v2.238+, selecting "Do not show this field on the Client details" on the Custom Field holding the Custom Table to hide it from Client records. </p><p><br></p><p>For a breakdown on what each field within the custom table configuration is used for, check out <a data-fr-linked="true" href="https://usehalo.com/haloitsm/guides/1436" target="_blank" rel="noopener noreferrer">Custom </a>Tables. </p><p><br></p><p>Once you have completed the details of your custom table save the table then head to the field list tab. </p><p><br></p><p>Here, you will configure what the fields in your custom table will be, when adding a field you will be prompted to create a new custom field. Each field will be used as a column in the table. The fields added here have the same configuration options as custom fields.</p><p><strong><span style="font-size: 10pt;"><img data-fr-image-pasted="true" src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImU5ODdlODJjLWE5ZmMtNDAzYi1iMzZiLWM3ZjFiYjkxYjNiNyJ9.y-DYRXVDYPhl-ocOmkbC73PlnyBZUmDpmGwD16q-n_A" width="681" height="619" style="box-sizing: inherit; border-style: none; cursor: pointer; padding: 0px 1px; user-select: none; text-align: left; color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; max-width: none !important;" id="isPasted" class="fr-fil fr-dib"></span></strong><strong id="isPasted"><span style="font-size: 10pt;">Fig 3. Creating a custom field</span></strong></p><p><br></p><p><strong id="isPasted"><span style="font-size: 11pt;"><em>Note: Calculated custom fields can be created for custom tables (using "Input Type" "Calculated"). Allowing you to have the value of the column determined by other values in the table, useful for totals columns. </em></span></strong><em><span style="font-size: 11pt;"><br></span></em></p><p><br></p><p><span style="font-size: 11pt;">The order of your field list will determine the order of the table columns, with the top field in the list being the leftmost column in the table. In the Figure 4 example the field 'Column C' will be the leftmost column. </span></p><p><strong><span style="font-size: 10pt;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjlkNjlkZmVjLThkYjktNDNjZi04MTk5LWQwZDEyNTlhZDc2MSJ9.uLe__1sqjTNmIzIpyXD8ZYne_-BuY1uld5dsKG8zN00" class="fr-fic fr-fil fr-dib" width="1413" style="width: 1415px; height: 449.481px;" height="449"></span></strong></p><p><strong><span style="font-size: 10pt;">Fig 4. Ordering custom table fields</span></strong></p><p><strong><br></strong></p><p><strong><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFkZmY4NjVkLTAxYWItNGE4NS1hMDY5LTQ4NjFjYjNhNjBlMyJ9.fwMxWZKsYuPtmFkXVItbHXT5JAjoim9r1VtfjS4HPgI" class="fr-fic fr-fil fr-dib" width="1285" style="width: 1287px; height: 285.287px;" height="285"></strong></p><p><strong><span style="font-size: 10pt;">Fig 5. Custom table with ordered columns</span></strong></p><p><strong><br></strong></p><p><strong><em>Note: Fields can be re-ordered by dragging and dropping the top left of the field. </em></strong></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjkxZTE1YTBlLTQ5MzMtNGJjNi1hMTgzLWFlNGFjYTIwNjhhYyJ9.b9J1tbsB-wysv8TX9QSOxTr5r0L-ktVHaUkxVwbYt5k" class="fr-fic fr-fil fr-dib" width="558" style="width: 560px; height: 317.364px;" height="317"></p><p><strong><span style="font-size: 10pt;">Fig 6. Re-ordering columns/fields</span></strong></p><p><br></p><p><strong><span style="font-size: 11pt;">Restrict Access to Custom table fields</span></strong></p><p><span style="font-size: 11pt;">You can restrict which agents can access fields within a custom table, based on their role. Useful when you would like agents to have access to the table, but not particular columns of data in this table, such as if it contains sensitive information. </span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">To do this, edit the field under the custom table you would like to restrict access to, using the pencil icon. </span></p><p><strong><span style="font-size: 10pt;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM0NjYyNGYwLWQ3NTgtNGQ4YS05OTcxLWEzZWVkY2I4OWNhMyJ9.kzmYuZrKOVakSURrI9XQZaSOjNY-WxiUJveGL8nn7WE" class="fr-fic fr-fil fr-dib" width="978" style="width: 980px; height: 310.38px;" height="310"></span></strong></p><p><strong><span style="font-size: 10pt;">Fig 7. Edit Custom field under Custom table</span></strong></p><p id="isPasted"><br></p><p><span style="font-size: 11pt;">Then configure the read/modify access to 'Restrict based on Role' and add in the roles that have access to read/modify the values in this field (column). In the Figure 8 example, only agents with the administrator role will be able to read and modify values in column C.</span></p><p><br></p><p><strong><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgwODMxYjcxLWZjYTAtNDA2NS1hMmZhLTA3MGVlMzQzZjFhOCJ9.txJupkre9IO6_PgTILGvsueOh6-v4xjd5Cnf06v1rvM" class="fr-fic fr-fil fr-dib" width="472" style="width: 474px; height: 501.336px;" height="501"></strong></p><p><strong>Fig 8. Read and modify restrictions against a table field</strong></p><p><br></p><p><span style="font-size: 14pt;"><strong>Displaying Custom Tables</strong></span></p><p><span style="font-size: 12pt;"><strong>Displaying a Custom Table Linked to an Entity</strong><br></span></p><p><span style="font-size: 11pt;">Custom Tables will not appear right away for any of the entities. For the custom table to show you need to create a custom field to 'store' the table in, the field must be for the same entity as the table and have the type of field as "Table".</span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">The correct table then needs to be chosen from the "Link to Table" options. Once this custom field is created the custom table it is linked to will show up instead of the custom field. </span></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVhYzIzNTZmLTZmMjctNDA4NC04ODhkLTdkY2QxY2IwMWY3ZiJ9.lbIhosEGaGy4YEscAU0-YRH--NQpHGumtB9SvGkykYI" class="fr-fic fr-fil fr-dib" width="1012" height="616"></p><p><strong><span style="font-size: 10pt;">Fig 9. Creation of a custom field linked to a custom table</span></strong></p><p><br></p><p><span style="font-size: 11pt;">You can have a custom field to 'store' the table in created automatically when the table is created. To do this enable "Create a Custom Field for this table" when creating the custom table. Keep in mind this setting will only show after "Link to another entity" has been set.</span></p><p><strong><span style="font-size: 10pt;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjMwZDE2NzA5LTFkZjUtNDcxOS04YjNmLTMyMjNhOWQ5YWFhYSJ9.PMfkx_CzqBu6Tk8LfEewiHgf3tQTW3bhQ5KOWDziG0s" class="fr-fic fr-fil fr-dib" width="910" style="width: 912px; height: 602.251px;" height="602"></span></strong></p><p><strong><span style="font-size: 10pt;">Fig 10. Create a Custom Field for this table</span></strong></p><p><strong><br></strong></p><p>When checked, a field will be created for the linked entity automatically. </p><p><br></p><p>To add the custom table to a ticket type, the custom field would need to be added to the field list of that specific ticket type.</p><p><br></p><p data-pasted="true"><span style="font-size: 12pt;"><strong>Displaying a Custom Table Not Linked to an Entity</strong></span></p><p><span style="font-size: 11pt;">Custom tables not linked to an entity can be added to their own module in the navigation menu. Allowing agents to view an add entries to the table without needing access to the Configuration module. </span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjliYTZmMjk5LTVlZDQtNDZkZC04MTg2LTc4ZDA4MmZkZTk1NyJ9.KkBPQQZoK8jnh_2LeAv6FnslUgvTRrumzpAWc5lQxgo" class="fr-fic fr-fil fr-dib" width="864" style="width: 866px; height: 460.55px;" height="461"></span></p><p><span style="font-size: 10pt;"><strong>Fig 11. Custom Table in own Module</strong></span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">To do this, simply enable "Show as Navigation Area" against the custom table.</span></p><p><span style="font-size: 11pt;"><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImU1OTg1N2VhLTI1YjYtNDBmYy1iN2IzLTY0MWU5YTM2NjI3NiJ9.AiE2nW8gtAWqLiwSJaFpAik5nww2LMuQ8FPd_ld3Fq4" class="fr-fic fr-fil fr-dib" width="695" style="width: 697px; height: 486.475px;" height="486"></span><span style="font-size: 10pt;"><strong>Fig 12. Set custom table to show as navigation area</strong></span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Then, set which agents should be able to see the table using the <a href="https://usehalo.com/haloitsm/guides/2426" target="_blank" rel="noopener noreferrer" style="font-size: 11pt;">access control </a>for the table. Only agents with access control will see the module. <br></span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;">Now, a new module will appear in the navigation menu, named after the custom table. </span></p><p><span style="font-size: 11pt;"><br></span></p><p><span style="font-size: 11pt;"><em><strong>Note: Configuration for the table (such as the columns and access control) can still only be set from the Configuration area.</strong></em></span></p><p><br></p><p><strong><span style="font-size: 14pt;">Adding rows to the table</span></strong></p><p><span style="font-size: 11pt;">Once the table is created and visible against the entity you can add rows of data using the 'Add' button against the table. When adding data you will be able to complete all the columns (fields) for that row. If you would only like one of the cells in this row to be populate just leave the other fields (columns) blank and add a new row. <br></span></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM3Mjc0NTg3LTZhYTgtNGQyMC04OGJmLTc1NTg1NzE1YjQyNyJ9.uypxX9S4VG_fAI44D4QsIc6A96QavL5u5NTfoRm95ds" class="fr-fic fr-fil fr-dib" width="1665" style="width: 1667px; height: 272.414px;" height="272"></p><p><strong><span style="font-size: 10pt;">Fig 13. Adding data to table rows</span></strong></p><p><br></p><p><strong><span style="font-size: 12pt;">Adding multiple rows at Once</span></strong></p><p>You can enable the below checkbox on a "single-selection" custom field. </p><p><br></p><p><em><strong>Note: This field can only be enabled for one field per table.</strong></em></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjIzZDE1ZDIzLTlhNmItNGM2Yy04ODk5LTQyNTc0MDQ4YzRmZiJ9.3R4GKK-mmXmbdi4BhQgFBeBUvZH_icBePyg8PZ5z3Cc" class="fr-fic fr-fil fr-dib" width="557" height="63"></p><p><strong><span style="font-size: 10pt;">Fig 14. Multiple value option</span></strong></p><p><br></p><p>When enabled, you can select multiple values in a similar way to a multi-select field, but each field will be on a new row, instead of multiple on a line.</p><p><br></p><p>For instance, this table has a single-select with the checkbox enabled, another single-select with it disabled, and a multi-select.</p><p><br></p><ul><li>The single-select with the checkbox enabled can select multiple values, but they appear in individual rows each.</li><li>The single-select with the checkbox disabled can only select one at a time.</li><li>The multi-select can select multiple values, and they all appear within the same row.</li></ul><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImY0M2Q1OGRlLWRhYjktNDRmOS05NDAyLTljZmY4ZGExODY5NiJ9.3d_hbrM0QqCM3Vi9i8v3Ur5FPgmWxWNyUrCZXQTS3ho" class="fr-fic fr-fil fr-dib" width="180" height="313"></p><p><strong><span style="font-size: 10pt;">Fig 15. Adding field values to the table</span></strong></p><p><br></p><p>The table will appear like below.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjQwNWJiYjYzLTcyYzQtNDVlMC1hYjUwLWYzOWJhZGQ0NzI3YiJ9.Qg2cgiJ1POj2zaVhRLGSmZlEbXD_dT0K6v2YcR2OaJA" class="fr-fic fr-fil fr-dib" width="1185" height="234"></p><p><strong><span style="font-size: 10pt;">Fig 16. Custom table with various value selection configuration</span></strong></p><p><br></p><p>If you are adding multiple types of fields at once, like the configuration in Figure 15, the values for the "Single (Disabled)" and "Multiple" columns are shown multiple times for each row that is created by the single-select with the checkbox enabled.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijc0NTZmOWUwLWJjYjQtNDU2OC05OWFhLThjNjU5MjNkMmZiYiJ9.lgFZHqC0zO80C5oY69h8AuA9W4p7_fJ7voT7NOZ0Woc" class="fr-fic fr-fil fr-dib" width="1193" height="138"></p><p><strong><span style="font-size: 10pt;">Fig 17</span></strong><strong><span style="font-size: 10pt;">. Fields shown on multiple lines</span></strong></p><p><br></p><p data-pasted="true"><strong><span style="font-size: 14pt;">Auditing Custom Tables</span></strong></p><p>You are able to audit changes made to the rows of custom tables via Halo's reporting tool. </p><p><br></p><p><strong><em>Note: Currently only custom tables that are linked to an entity are audited. If you have a standalone custom table, changes made to this will not appear in the audit table. </em></strong></p><p><br></p><p>To do this navigate to the reporting module and click 'new' to create a new report.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVkNDhhNGMxLTM1ZGUtNDA3YS1hYWQ4LTU1YjQ0NWMyNmJiNyJ9.P-E5zQMh-f2NGfER8Dr0hZpjAEqSVaUli9NZcc9S-Nw" width="562" style="width: 564px; height: 250.562px;" height="251" class="fr-fic fr-dii"></p><p><strong><span style="font-size: 10pt;">Fig 18. Creating a new report in Halo's reporting module</span></strong></p><p><br></p><p>If you are not comfortable with SQL then you only need to write a very simple query of 'select * from audit', which selects everything from the Audit table. Before hitting 'Load Report', you can then easily apply filters for the returned data on the 'Preview Report' tab. Whichever entity your custom table is linked to is the table that you will want to filter on. For example, if I have a custom table linked to the 'area' entity (Figure 19a), meaning it is linked to customers, then I would filter on the area table in the auditing report (Figure 19b).</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImQxYTVjYmRmLWE3YzktNDNmYi1iZTAyLWVjMGQ2MjNlOGI3NyJ9.2SB1T45XukZ4BqGmt76nQ9e_xK_s1ije1e-Y4SqADD0" class="fr-fic fr-fil fr-dib" width="234" style="width: 236px; height: 200.373px;" height="200"></p><p><strong><span style="font-size: 10pt;">Fig 19a. A custom table linked to the 'Area' (customers) entity</span></strong></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjkzZjU3NTNjLWQwNDQtNGI0Ny1iNWQ5LTY3NGNhM2EyMTVkNiJ9.rA0__heLBYDRp2PNxEVaHur7hBu7_M_vB2vVRT4qRr4" width="665" style="width: 667px; height: 247.703px;" height="248" class="fr-fic fr-dii"></p><p data-pasted="true"><strong><span style="font-size: 10pt;">Fig 19b. An example audit report on changes made to customers today showing changes made to a custom table (versions earlier than 2.226.1 will not have the table name or row ID included in the returned data)</span></strong></p><p><br></p><p data-pasted="true"><strong><span style="font-size: 14pt;"> </span></strong><strong><span style="font-size: 14pt;">Access Control </span></strong></p><p>Access Control can be set on Custom Tables to determine which Agents can view and edit the Table. For more information on Access Control see our guide linked <a href="https://usehalo.com/haloitsm/guides/2426" target="_blank" rel="noopener noreferrer">here</a></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImYzZDFlMjhkLWUxZDUtNDFlZS04ODkwLTQzY2QyMDMxN2ZjOSJ9.gKHAz5W-YD7OqKkqDXdl0O7sZZndJSRn01kRV13bIxk" class="fr-fic fr-fil fr-dib" width="1155" style="width: 1157px; height: 261.132px;" height="261"><strong><span style="font-size: 10pt;">Fig 20. Access Control</span></strong></p><p><br></p><p>You can choose to grant "Read and Modify (Add/Edit/Delete Data)" Access Control, allowing the Agent to make changes to row data without access to the overall Table configuration. </p>
