{"id":6451,"date":"2020-07-10T16:53:12","date_gmt":"2020-07-10T16:53:12","guid":{"rendered":"https:\/\/max-drake.cc\/?p=6451"},"modified":"2020-07-10T16:53:15","modified_gmt":"2020-07-10T16:53:15","slug":"amazon-honeycode-timesheet-app-part-3-budget-budget-screen-notifications","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=6451","title":{"rendered":"Amazon Honeycode Timesheet App Part 3- Budget, budget screen &#038; notifications"},"content":{"rendered":"\n<p>This video is accessible for Patrons on the All-Access Patron tier. To gain access please subscribe. <\/p>\n\n\n\n<p>This is the 3rd video on using Honeycode to make a mobile timesheet app.  I will review the app so far and what we have done, and then proceed on with adding a pro-active part of budget oversight for the team. <\/p>\n\n\n\n<p>In this app we will be adding budget and budget oversight screens as well as notifications based on setpoints in budget expenditure. <\/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=\"Amazon Honeycode Timesheet App Part 3  Budget, budget screen &amp; notifications\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/oi27wsjfzlM?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<h3 class=\"wp-block-heading\">Budget <\/h3>\n\n\n\n<p>To add budget to the project all we need is another column in our table with the total budget sum.<\/p>\n\n\n\n<p>We have hours on our timesheet and we need to convert the time spentinto a sum, based on who is doing the work. <\/p>\n\n\n\n<p>This exercise is based on charging out a service by hourly rate. There is the rate you pay the employee and the rate you charge to the client. The chargeout rate usually has a multiplier of the employees pay rate. <\/p>\n\n\n\n<p>This is because the hour charged by that employee working on that specific clients project has to include things like Office rental, software and computers, desk, furniture etc, as well as holiday pay and also support staff salaries and part of managers salaries, marketing etc. <\/p>\n\n\n\n<p>A simple way to do this is to add a multiplier, in the region of 2.5-4 So:<\/p>\n\n\n\n<p><strong>Employee hourly rate x Multiplier = Charge out rate. <\/strong><\/p>\n\n\n\n<p>There will be different levels of employees, say draughtsperson, engineer and project manager, all of who&#8217;s base salary is different and their multipliers may be different too. <\/p>\n\n\n\n<p>So to recognise this, we need a new table , we will call it _R, where we will have the Employee, their base salery &amp; the multiplier to give standard charge out rates for each employee. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Linking<\/h3>\n\n\n\n<p>now we need to link that data , as a lookup in the Timesheet Table to find the chargeout rate of each employee for a project, so we can get the sum of work that person has done on that project for that day. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"590\" height=\"274\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_38-_R-_-Amazon-Honeycode.jpg\" alt=\"\" class=\"wp-image-6452 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_38-_R-_-Amazon-Honeycode.jpg 590w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_38-_R-_-Amazon-Honeycode-300x139.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_38-_R-_-Amazon-Honeycode-50x23.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_38-_R-_-Amazon-Honeycode-108x50.jpg 108w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_38-_R-_-Amazon-Honeycode-100x46.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_38-_R-_-Amazon-Honeycode-215x100.jpg 215w\" data-sizes=\"(max-width: 590px) 100vw, 590px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 590px; --smush-placeholder-aspect-ratio: 590\/274;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"349\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-1024x349.jpg\" alt=\"\" class=\"wp-image-6453 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-1024x349.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-300x102.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-768x261.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-50x17.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-147x50.jpg 147w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-100x34.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-294x100.jpg 294w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode-640x218.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_01_52-_T-_-Amazon-Honeycode.jpg 1492w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/349;\" \/><\/figure>\n\n\n\n<p>So we use the Findrow function to look up the person in the _T table and compare with the _R table to find a match, then copy across the ChargeOutRate column information. <\/p>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\"><strong>=FINDROW(_R,&#8221;_R[Person]=[Person]&#8221;)[ChargeOutRate]<\/strong><\/p>\n\n\n\n<p>So now we can multiply the employees chargeout rate by the hours that they have put against that project, to get a sum. This sum can now be deducted from the overall project budget to see how much of the budget is left. How to we do that? <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Linking Timesheet to Projects <\/h3>\n\n\n\n<p>So we can sum each row of the timesheet to get that rows sum. We need to gather all the sum&#8217;s related to that project together and compare with the project budget. <\/p>\n\n\n\n<p>So, 2 steps, 1. Filter all specific project data together in one place, then 2\/ sum that sub-total specific to that project. <\/p>\n\n\n\n<p>So, on the Projects table we filter all the rows in the Timesheet Table that are specific to a single project<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"272\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-1024x272.jpg\" alt=\"\" class=\"wp-image-6454 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-1024x272.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-300x80.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-768x204.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-50x13.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-188x50.jpg 188w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-100x27.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-377x100.jpg 377w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode-640x170.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_13_40-_P-_-Amazon-Honeycode.jpg 1191w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/272;\" \/><\/figure>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\"><strong>=filter(_T,&#8221;_T[Project Name]=[Name]&#8221;)<\/strong><\/p>\n\n\n\n<p>That then shows the number of rows in the Timesheet Table that are specific to that project. <\/p>\n\n\n\n<p>Next we need to sum that Filter formula<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"289\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-1024x289.jpg\" alt=\"\" class=\"wp-image-6455 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-1024x289.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-300x85.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-768x217.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-50x14.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-177x50.jpg 177w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-100x28.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-355x100.jpg 355w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode-640x180.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_16_56-_P-_-Amazon-Honeycode.jpg 1142w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/289;\" \/><\/figure>\n\n\n\n<p>So we need to Sum the previous formula and add Sum as the relevant column.  A bit confusing. There is a column called sum in the Timesheet Table, it should be Total but we used Tot for hours, so I used sum instead. <\/p>\n\n\n\n<p>Then we are using the =SUM() function to add up all of the rows relating to that project. <\/p>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\">=<strong>SUM<\/strong>(filter(_T,&#8221;_T[Project Name]=[Name]&#8221;)<strong>[Sum]<\/strong>)<\/p>\n\n\n\n<p>So now we have the total spend, to date, on that project we can subtract <strong>Budget &#8211; SpentToDate= CurrentBudget<\/strong><\/p>\n\n\n\n<p>So we can use <strong>SpentToDate\/Budget<\/strong> to get a Percentage of total budget. <\/p>\n\n\n\n<p>Depending who we want to show what information (only percentage or currentBudget and total budget we can adjust our app to suit. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">User Interface of App<\/h3>\n\n\n\n<p>So we make a new screen <em>(in fact the app wizard already made a screen so I&#8217;m using that one<\/em>) and we use COLUMN LIST to create new filterable list of Budget data, adding a filter for Name (Project Name). <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"721\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-1024x721.jpg\" alt=\"\" class=\"wp-image-6456 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-1024x721.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-300x211.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-768x541.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-50x35.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-71x50.jpg 71w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-100x70.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-142x100.jpg 142w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-909x640.jpg 909w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-640x450.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode-1091x768.jpg 1091w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_25_14-TS-Filter-_-Amazon-Honeycode.jpg 1499w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/721;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"788\" height=\"850\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode.jpg\" alt=\"\" class=\"wp-image-6457 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode.jpg 788w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-278x300.jpg 278w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-768x828.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-50x54.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-46x50.jpg 46w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-100x108.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-93x100.jpg 93w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-593x640.jpg 593w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-640x690.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_26_32-TS-Filter-_-Amazon-Honeycode-712x768.jpg 712w\" data-sizes=\"(max-width: 788px) 100vw, 788px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 788px; --smush-placeholder-aspect-ratio: 788\/850;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"626\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-626x1024.jpg\" alt=\"\" class=\"wp-image-6458 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-626x1024.jpg 626w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-183x300.jpg 183w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-50x82.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-31x50.jpg 31w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-100x164.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-61x100.jpg 61w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-391x640.jpg 391w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode-469x768.jpg 469w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_27_00-TS-Filter-_-Amazon-Honeycode.jpg 627w\" data-sizes=\"(max-width: 626px) 100vw, 626px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 626px; --smush-placeholder-aspect-ratio: 626\/1024;\" \/><\/figure>\n\n\n\n<p>So the app now has this new screen  interface <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"612\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-1024x612.jpg\" alt=\"\" class=\"wp-image-6459 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-1024x612.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-300x179.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-768x459.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-50x30.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-84x50.jpg 84w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-100x60.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-167x100.jpg 167w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-1070x640.jpg 1070w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-640x383.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter-1284x768.jpg 1284w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_29_11-TS-Filter.jpg 1465w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/612;\" \/><\/figure>\n\n\n\n<p>I discussed about filtering this to only projects specific employees are working on, but I didn&#8217;t build that. In an office with 50 projects you may want to add that filter. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Notifications<\/h3>\n\n\n\n<p>What happens when budgets blowout, or do you want to add trigger points at cirtain percentages of budget spend? Honeycode can do that via automations. <\/p>\n\n\n\n<p>A lot of time people are focussed on getting the work done, so do not review budgets frequently enough. <\/p>\n\n\n\n<p>One simple way of getting them to check on budget progress in the app is every time they add a new row of data and press the button, the app takes them, through an automation, to the budget page, that way they can look at where the budget is. <\/p>\n\n\n\n<p>Another way is notification flags. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"529\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-1024x529.jpg\" alt=\"\" class=\"wp-image-6460 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-1024x529.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-300x155.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-768x397.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-1536x794.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-50x26.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-97x50.jpg 97w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-100x52.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-194x100.jpg 194w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-1239x640.jpg 1239w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-640x331.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode-1486x768.jpg 1486w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_12-Automation1-_-Amazon-Honeycode.jpg 1585w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/529;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"621\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-1024x621.jpg\" alt=\"\" class=\"wp-image-6461 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-1024x621.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-300x182.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-768x466.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-1536x932.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-2048x1242.jpg 2048w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-50x30.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-82x50.jpg 82w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-100x61.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-165x100.jpg 165w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-1055x640.jpg 1055w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-640x388.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-1266x768.jpg 1266w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-1781x1080.jpg 1781w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-1920x1164.jpg 1920w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_37_37-NZMoH20200503.xlsx-Excel-scaled.jpg 1600w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/621;\" \/><\/figure>\n\n\n\n<p>The very bottom<strong> attach link to app:<\/strong> you can choose your app that will be notified and this will show in the Bell notification in the bottom left corner of the Honeycode interface on the PC or on the icon on your mobile device (see below) will have a notification showing this issue. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"270\" height=\"540\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/Screenshot_20200711-143813_resized_20200711_023846593.jpg\" alt=\"\" class=\"wp-image-6462 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/Screenshot_20200711-143813_resized_20200711_023846593.jpg 270w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/Screenshot_20200711-143813_resized_20200711_023846593-150x300.jpg 150w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/Screenshot_20200711-143813_resized_20200711_023846593-50x100.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/Screenshot_20200711-143813_resized_20200711_023846593-25x50.jpg 25w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/Screenshot_20200711-143813_resized_20200711_023846593-100x200.jpg 100w\" data-sizes=\"(max-width: 270px) 100vw, 270px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 270px; --smush-placeholder-aspect-ratio: 270\/540;\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">End comment<\/h3>\n\n\n\n<p>This has been quite a fun app to build. The Honeycode has some hidden depths that allow it to do some fun stuff. <\/p>\n\n\n\n<p>I enjoyed making this app and there has been a good bit of learning. <\/p>\n\n\n\n<p>I didn&#8217;t touch on it above but I did in the video regarding privacy issues and what you choose to display on the app. Also data in the tables and privacy is based on who has access to the actual build of the app. Maybe you use dummy data while collaborating with other when building the app and then UNSHARE\/REMOVE them from accessing the AppBuid when the app goes live. <\/p>\n\n\n\n<p>Ultimately you may need to build 4-5 apps so that specific privacy issues are managed. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>This video is accessible for Patrons on the All-Access Patron tier. To gain access please subscribe. This is the 3rd video on using Honeycode to make a mobile timesheet app. I will review the app so far and what we have done, and then proceed on with adding a pro-active part of budget oversight for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6463,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[455,417],"tags":[],"class_list":["post-6451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-honeycode-aws","category-mobile"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_51_46-Photos.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-11-14_51_46-Photos.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\/6451","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=6451"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/6451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/6463"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}