{"id":528,"date":"2023-05-23T01:20:00","date_gmt":"2023-05-23T01:20:00","guid":{"rendered":"https:\/\/automatethemundane.com\/index.php\/2023\/05\/23\/hours-tracker-part-3-extending-the-user-table\/"},"modified":"2023-05-23T01:20:00","modified_gmt":"2023-05-23T01:20:00","slug":"hours-tracker-part-3-extending-the-user-table","status":"publish","type":"post","link":"https:\/\/automatethemundane.com\/index.php\/2023\/05\/23\/hours-tracker-part-3-extending-the-user-table\/","title":{"rendered":"Hours Tracker Part 3-Extending the User Table"},"content":{"rendered":"\n<p class=\"has-text-color\" style=\"color: rgba(120, 119, 116, 1)\">5\/22\/2023<\/p>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n<h1 class=\"wp-block-heading\">The Why<\/h1>\n\n\n<p class=\"has-text-color\" style=\"color: rgb(0, 0, 0)\">Extending standard tables in Dataverse refers to adding new fields and customizing an existing table, while creating a new table involves building a separate table with its own set of fields. Extending a standard table can be a good option if the data you need to add is related to the existing data model. However, if the new data is unrelated or requires a significantly different structure, creating a new table may be more appropriate. When considering whether to extend a table or create a new one, it is important to consider the long-term implications of your decision, such as how it will impact data management and usability.<\/p>\n\n\n<h1 class=\"wp-block-heading\">The How<\/h1>\n\n\n<p class=\"has-text-color\" style=\"color: rgb(0, 0, 0)\">There are two columns being added to the User Table. <\/p>\n\n\n<h2 class=\"wp-block-heading\">Custom<\/h2>\n\n\n<ol class=\"wp-block-list\">\n<li>Name-Role<\/li>\n\n\n\n<li>Type-Choice<\/li>\n\n\n\n<li>Choices-\n<ol class=\"wp-block-list\">\n<li>Lead<\/li>\n\n\n<li>Member<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/automatethemundane.com\/wp-content\/uploads\/2023\/06\/image-12.png\" alt=\"\"\/><\/figure>\n\n<\/div>\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/automatethemundane.com\/wp-content\/uploads\/2023\/06\/image-13.png\" alt=\"\"\/><\/figure>\n\n<\/div>\n\n<\/div>\n\n\n<h2 class=\"wp-block-heading\">Lookup<\/h2>\n\n\n<ol class=\"wp-block-list\">\n<li>Name-Team<\/li>\n\n\n\n<li>Type-Lookup<\/li>\n\n\n\n<li>Table-Team<\/li>\n<\/ol>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/automatethemundane.com\/wp-content\/uploads\/2023\/06\/image-14.png\" alt=\"\"\/><\/figure>\n\n\n<h2 class=\"wp-block-heading\">Relationship<\/h2>\n\n\n<p class=\"has-text-color\" style=\"color: rgb(0, 0, 0)\">From the user table select new Relationship then Many to Many<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/automatethemundane.com\/wp-content\/uploads\/2023\/06\/image-15.png\" alt=\"\"\/><\/figure>\n\n\n<p class=\"has-text-color\" style=\"color: rgb(0, 0, 0)\">Select the Project table as the other table<\/p>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/automatethemundane.com\/wp-content\/uploads\/2023\/06\/image-16.png\" alt=\"\"\/><\/figure>\n\n\n<p class=\"has-text-color\" style=\"color: rgb(0, 0, 0)\">In the next guide we will go over building all the forms and views for the tables. <\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>5\/22\/2023 The Why Extending standard tables in Dataverse refers to adding new fields and customizing an existing table, while creating a new table involves building a separate table with its own set of fields. Extending a standard table can be a good option if the data you need to add is related to the existing [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":259,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,6,35],"tags":[25,31,4],"class_list":["post-528","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-design","category-model-driven-app","category-tables","tag-dataverse","tag-forms","tag-mda","entry","has-media"],"jetpack_featured_media_url":"https:\/\/automatethemundane.com\/wp-content\/uploads\/2023\/06\/cover-7-scaled.jpg","_links":{"self":[{"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/posts\/528","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/comments?post=528"}],"version-history":[{"count":0,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/posts\/528\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/media\/259"}],"wp:attachment":[{"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/media?parent=528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/categories?post=528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/automatethemundane.com\/index.php\/wp-json\/wp\/v2\/tags?post=528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}