{"id":5554,"date":"2019-05-03T14:05:17","date_gmt":"2019-05-03T14:05:17","guid":{"rendered":"https:\/\/max-drake.cc\/?p=5554"},"modified":"2019-05-31T08:38:05","modified_gmt":"2019-05-31T08:38:05","slug":"free-glideapp-for-project-defect-list-moving-completed-items-to-another-sheet","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=5554","title":{"rendered":"Free GlideApp for Project Defect list moving COMPLETED ITEMS to another sheet"},"content":{"rendered":"\n<p>Following on from the 2 previous videos relating to this app, after a task has been completed, an email can be sent to the project manager, and others via the app to advise of its completion.  <\/p>\n\n\n\n<p>So we need to take this item off the TO DO list and move it to another list, and possibly another app, where the completed work can be inspected by someone, either the Project Management Team, or the Design team, such as the Architect\/Engineer.   See the video:<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Free GlideApp for Project Defect list moving COMPLETED ITEMS to another sheet- vid 3 of 4\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/UyrDmeKy4kc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>So I wanted a method to move any items completed\nfrom the To DO list to the DONE , but needs inspecting list. \n<\/p>\n\n\n\n<p>The method is to copy the row of data to a new\nsheet and delete the old row. \n<\/p>\n\n\n\n<p>I followed these articles by Jacorre, that are\nvery good, in my opinion:<\/p>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\">How To Move Rows of Data Between Google Sheets:\n<a href=\"https:\/\/www.jacorre.com\/tutorial\/move-rows-between-google-sheets\/\">https:\/\/www.jacorre.com\/tutorial\/move-rows-between-google-sheets\/<\/a><\/p>\n\n\n\n<p class=\"has-background has-pale-cyan-blue-background-color\">How To Create Custom Menus in Google Documents and\nSpreadsheets:\n<a href=\"https:\/\/www.jacorre.com\/tutorial\/custom-menus-google-documents-spreadsheets\/\">https:\/\/www.jacorre.com\/tutorial\/custom-menus-google-documents-spreadsheets\/<\/a><\/p>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\">How To Display a Message in Google Documents and Spreadsheets: <a href=\"https:\/\/www.jacorre.com\/tutorial\/display-message-google-documents-spreadsheets\/\">https:\/\/www.jacorre.com\/tutorial\/display-message-google-documents-spreadsheets\/<\/a><\/p>\n\n\n\n<p>The code that I developed for the app is <strong><a href=\"https:\/\/docs.google.com\/document\/d\/1OUcGTw6jIzApQZh8vdrX9tih8twCRNTNhIXPXL0_0Rg\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"here (opens in a new tab)\">here<\/a><\/strong>.<\/p>\n\n\n\n<p>In the first video  I developed a Defects List app: <\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Free Defects List mobile app for contractors to repair work using free GlideApps- vid 1 of 4\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/eexpLOcqBsw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>In the next video I wanted  to send an automatic email to project manager when a task had been completed by someone on site and confirmed change of status in the app. <\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Free GlideApp for Project Defect list with Email notification of repair- vid 2 of 4\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/Fyvo3qJz40A?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Actual app link: <a href=\"https:\/\/defects-list.glideapp.io\/\">https:\/\/defects-list.glideapp.io\/<\/a><\/p>\n\n\n\n<p>Spreadsheet link: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1lKW5JFdX41mao2H-uVhxvVTR1NmplhPYpqkK_vxv-CY\/edit#gid=1010704303\">https:\/\/docs.google.com\/spreadsheets\/d\/1lKW5JFdX41mao2H-uVhxvVTR1NmplhPYpqkK_vxv-CY\/edit#gid=1010704303<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Iterations<\/h3>\n\n\n\n<p>The principle of moving data from a sheet after repairs completed works. This is a crude method. <\/p>\n\n\n\n<p>Using this method alone, you could filter the columns in ascending\/descending order by the True\/False columns and only move the tasks across that have been completed in a one off process. You could do that daily or weekly. In some ways I&#8217;d think about doing it on a daily basis just in case a Designer\/approve was coming to site for another reason, and so could check the work and approve\/reject it. If you left it for a weekly process then you could miss out on the ad-hock potential of designers visiting the site.<\/p>\n\n\n\n<p>The next step is to have a single button that will run an iteration through the spreadsheet so that it moves all fixed items across to the fixed sheet. <\/p>\n\n\n\n<p>A further process of automation could be added is that it was done automatically on a daily basis, so that Project Manager did not even have to open the sheet. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Next step<\/h3>\n\n\n\n<p>I think the development of an approving app for accepting\/rejecting the work may be a worthwhile effort. It would be interesting to see if the rejected ones could be sent back to the TO DO list. Actually, I did a video on this here:<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Free GlideApp for Defects list approve reject work by designers- Vid 4 of 4\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/GX3YlrsTIQA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>This brings up some thoughts about &#8220;NOTES&#8221; in the app. There maybe notes that the contractors\/subcontractors want to communicate with each other that have no relevance for the designers, whereas other notes\/comments may need to be passed on to designers. Also designers rejecting work need to advise why an item is still unacceptable too. <\/p>\n\n\n\n<p>It would be good if you could upload photos from an inspection. Maybe the email process needs to be utilised to send the Project Manager the photos that could be uploaded for a specific fault? <\/p>\n\n\n\n<p>Another thought on this subject is to use Google Forms , that allows for file uploads. Maybe there is a way to upload images, or maybe only one image, to a particular item. That way information can be conveyed without visiting site and could speed up the process. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">End comment<\/h3>\n\n\n\n<p>From my previous exploration about automation of tasks, I think the Google Sheet Scripts have the potential to take some of the mundane processes and automate them. <\/p>\n\n\n\n<p>I&#8217;m pleased that the moving of data from one sheet to another is possible, as well as deleting the row from the original sheet. It keeps things tidy. I also like the Script menu to allow the management of the scripts within the spreadsheet. This simplifies the process of running the scripts., and the notification pop-up is also handy, I think I may need to refine that too. <\/p>\n\n\n\n<p>This is almost becoming a practical, viable app. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Following on from the 2 previous videos relating to this app, after a task has been completed, an email can be sent to the project manager, and others via the app to advise of its completion. So we need to take this item off the TO DO list and move it to another list, and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5556,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[204,32,441,265,417,42,29],"tags":[425,428,422,427,53,54,430,426,423,420,421,255,434,429,424],"class_list":["post-5554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-automation","category-power-bi","category-glide-apps","category-google-docs","category-mobile","category-productivity","category-web","tag-adding-value","tag-am","tag-asset-management","tag-defects-list-app","tag-facility-management","tag-facility-operations","tag-fm","tag-fm-productivity","tag-free-building-maintenance-app","tag-free-mobile-app-creator-with-no-coding","tag-glideapps","tag-google-sheets","tag-move-completed-rows-to-a-new-sheet-using-google-sheets-script","tag-simplifying-data","tag-visualise-assets"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/05\/2019-05-04-13_58_30-Glide-\u2013-amazing-apps-without-code.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/05\/2019-05-04-13_58_30-Glide-\u2013-amazing-apps-without-code.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5554"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5554\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/5556"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}