{"id":6431,"date":"2020-07-07T20:47:36","date_gmt":"2020-07-07T20:47:36","guid":{"rendered":"https:\/\/max-drake.cc\/?p=6431"},"modified":"2020-07-08T17:54:39","modified_gmt":"2020-07-08T17:54:39","slug":"honeycode-timesheet-app-part-1","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=6431","title":{"rendered":"Honeycode Timesheet App &#8211; part 1"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Welcome Early Bird All-Access Patron&#8217;s &#8211; An exclusive post for you <\/h3>\n\n\n\n<p>This is extra information about the video on &#8220;Honeycode Timesheet App &#8211; part 1&#8221; that is acvailable exclusively for you. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Big picture stuff first- Honeycode API<\/h3>\n\n\n\n<p>In my previous overview video I stated that the power of Honeycode would be when you connect into AWS environment. <\/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=\"Honeycode basic start app and overview of app compared to GlideApp\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/OS_HEfB0XhI?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>Well, you can via an <strong><a href=\"https:\/\/honeycodecommunity.aws\/t\/getting-started-with-honeycode-apis\/790\" target=\"_blank\" rel=\"noreferrer noopener\">API interface<\/a><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1011\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-1011x1024.jpg\" alt=\"\" class=\"wp-image-6435 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-1011x1024.jpg 1011w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-296x300.jpg 296w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-768x778.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-50x51.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-49x50.jpg 49w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-100x100.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-99x100.jpg 99w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-632x640.jpg 632w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-640x648.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-758x768.jpg 758w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-1024x1037.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey-1067x1080.jpg 1067w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_37_00-Getting-Started-with-Honeycode-APIs-Knowledge-Center-_-Developer-Tools-Honey.jpg 1195w\" data-sizes=\"(max-width: 1011px) 100vw, 1011px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1011px; --smush-placeholder-aspect-ratio: 1011\/1024;\" \/><\/figure>\n\n\n\n<p>The issue is you have to be on the <strong><a href=\"https:\/\/www.honeycode.aws\/pricing\" target=\"_blank\" rel=\"noreferrer noopener\">Plus or Pro plans<\/a><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"737\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-1024x737.jpg\" alt=\"\" class=\"wp-image-6436 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-1024x737.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-300x216.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-768x553.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-50x36.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-69x50.jpg 69w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-100x72.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-139x100.jpg 139w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-890x640.jpg 890w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-640x460.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode-1067x768.jpg 1067w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_38_45-Pricing-_-Amazon-Honeycode.jpg 1162w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/737;\" \/><\/figure>\n\n\n\n<p>Which are a bit steep. So that is a setback. Although presumably only one of you needs to be on the plan to develop the apps and the other 19 in your team can benefit from them for free. <\/p>\n\n\n\n<p>So that is exciting. But a real pain that you have no access via the freee tier to learn\/play with it. If the Patreon support is sufficient I&#8217;d consider going onto it to build some powerful apps. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Honeycode Resources<\/h3>\n\n\n\n<p>While fossiking through the documentation I came across some spreadsheet Stuff:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Honeycode Functions<\/h4>\n\n\n\n<p><strong><a rel=\"noreferrer noopener\" href=\"https:\/\/honeycodecommunity.aws\/t\/honeycode-functions\/90\" target=\"_blank\">This article<\/a><\/strong> has a list of functions, there are some that are unique to honeycode and a list, alphabetically, of other ones they use. I&#8217;d been looking for that resource earlier, so nice to find it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"878\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--878x1024.jpg\" alt=\"\" class=\"wp-image-6440 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--878x1024.jpg 878w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--257x300.jpg 257w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--768x896.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--50x58.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--43x50.jpg 43w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--100x117.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--86x100.jpg 86w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--549x640.jpg 549w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--640x747.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--658x768.jpg 658w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--1024x1195.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help--926x1080.jpg 926w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_59_04-Honeycode-Functions-Knowledge-Center-_-Functions-Formulas-Honeycode-Help-.jpg 1123w\" data-sizes=\"(max-width: 878px) 100vw, 878px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 878px; --smush-placeholder-aspect-ratio: 878\/1024;\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Findrow &amp; Vlookup<\/h4>\n\n\n\n<p>This is an <strong><a href=\"https:\/\/honeycodecommunity.aws\/t\/findrow-a-better-vlookup\/120#findrow-vs-vlookup\" target=\"_blank\" rel=\"noreferrer noopener\">interesting article on these two functions<\/a><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"887\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--887x1024.jpg\" alt=\"\" class=\"wp-image-6437 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--887x1024.jpg 887w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--260x300.jpg 260w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--768x887.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--50x58.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--43x50.jpg 43w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--100x115.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--87x100.jpg 87w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--554x640.jpg 554w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--640x739.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--665x768.jpg 665w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--1024x1182.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help--936x1080.jpg 936w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_48_51-FindRow_-A-Better-VLookup-Knowledge-Center-_-Tables-Data-Honeycode-Help-.jpg 1088w\" data-sizes=\"(max-width: 887px) 100vw, 887px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 887px; --smush-placeholder-aspect-ratio: 887\/1024;\" \/><\/figure>\n\n\n\n<p>I did find it useful to pull data from one table across to another by looking up a cell. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">How to add a picklist<\/h4>\n\n\n\n<p><strong><a rel=\"noreferrer noopener\" href=\"https:\/\/honeycodecommunity.aws\/t\/how-to-add-a-picklist-dropdown-menu-to-a-table\/1859\" target=\"_blank\">This article<\/a><\/strong> sorted out my problem of <strong><span style=\"background-color:#fcb900\" class=\"background-color\">#VALUE<\/span> <\/strong>being displayed.  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"890\" height=\"958\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art.jpg\" alt=\"\" class=\"wp-image-6438 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art.jpg 890w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-279x300.jpg 279w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-768x827.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-50x54.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-46x50.jpg 46w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-100x108.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-93x100.jpg 93w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-595x640.jpg 595w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-640x689.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_50_45-How-to-Add-a-Picklist-Dropdown-Menu-to-a-Table-Knowledge-Center-_-How-To-Art-713x768.jpg 713w\" data-sizes=\"(max-width: 890px) 100vw, 890px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 890px; --smush-placeholder-aspect-ratio: 890\/958;\" \/><\/figure>\n\n\n\n<p>I was trying to put in <strong>COLUMN FORMULA<\/strong> for the picklists with the table formatting, and that did not work. You need to leave it blank (<em>I wasted a hell of a lot of timewith that issue)<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"342\" height=\"755\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_53_45-Films-TV.jpg\" alt=\"\" class=\"wp-image-6439 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_53_45-Films-TV.jpg 342w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_53_45-Films-TV-136x300.jpg 136w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_53_45-Films-TV-50x110.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_53_45-Films-TV-23x50.jpg 23w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_53_45-Films-TV-100x221.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_53_45-Films-TV-45x100.jpg 45w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_53_45-Films-TV-290x640.jpg 290w\" data-sizes=\"(max-width: 342px) 100vw, 342px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 342px; --smush-placeholder-aspect-ratio: 342\/755;\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Timesheet project issue<\/h3>\n\n\n\n<p>A slow and frustrating day. I had been planning on using the Table to do the formatting and then using the App Wizard to build the app from the table. That plan did not work.<\/p>\n\n\n\n<p>Main issue when I was trying to drive the app from the Table was that the formatting and <strong>COLUMN FORMULA<\/strong>E were not propagating correctly. I was getting a lot of data that was inputted into the forms that was not going into the Table.  I rebuilt the app a number of times and made new tables but the issue persisted. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"273\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-1024x273.jpg\" alt=\"\" class=\"wp-image-6432 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-1024x273.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-300x80.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-768x205.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-50x13.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-187x50.jpg 187w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-100x27.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-375x100.jpg 375w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode-640x171.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_00-TimeSheetCSV-_-Amazon-Honeycode.jpg 1476w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/273;\" \/><\/figure>\n\n\n\n<p>The other issue I had was the Project Name, linked to the Project Table was not showing on the INPUT FORM, even though you could pull down and select different items it still only showed<strong> <span style=\"background-color:#fcb900\" class=\"background-color\">#VALUE<\/span><\/strong> as per the images below<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"475\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-1024x475.jpg\" alt=\"\" class=\"wp-image-6433 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-1024x475.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-300x139.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-768x356.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-50x23.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-108x50.jpg 108w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-100x46.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-216x100.jpg 216w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-1381x640.jpg 1381w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV-640x297.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_37-TimeSheetCSV.jpg 1435w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/475;\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"479\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-1024x479.jpg\" alt=\"\" class=\"wp-image-6434 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-1024x479.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-300x140.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-768x359.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-50x23.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-107x50.jpg 107w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-100x47.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-214x100.jpg 214w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-1370x640.jpg 1370w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV-640x299.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-17_22_23-TimeSheetCSV.jpg 1453w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/479;\" \/><\/figure>\n\n\n\n<p>The issue was solved when I formatted the column correctly with the picklist method, as shown above, in linked article. Once I&#8217;d NOT filled in the <strong>COLUMN FORMULA<\/strong>  it worked fine. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Breaking down the steps. Step , pushing data into Table from INPUT FORM<\/h4>\n\n\n\n<p>I have a tendancy to carry on repeating the same mistakes until I get a bit of distance to reflect on the procedure. So I went back to first principles, uploaded a new worksheet from a CSV file and did nothing with the TABLE and used the wizard to build the app. <\/p>\n\n\n\n<p>At this point I focussed on getting a row of data into the Table. This is done by:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li> Filling in the Input fields on the Input Form <\/li><li>Pressing the Done Button, <\/li><li>This has an automation behind it and takes the variables in the Input fields and copies them to the Table column fields. <\/li><\/ol>\n\n\n\n<p>Where I was going wrong was not looking at the Automation process. I was trying to put the wrong data into the Table. Oops!<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Variables versus Table Columns<\/h4>\n\n\n\n<p>This is the issue that caused my confusion. The Data Cell object is a variable, it has the name <strong>Project Name<\/strong>, but to use that Data Cell as a Variable you call it by  <strong>$[Project Name]<\/strong>. If you use <strong>[Project Name]<\/strong> without the <strong>$<\/strong> then you are describing the column in the table instead.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"631\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-1024x631.jpg\" alt=\"\" class=\"wp-image-6441 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-1024x631.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-300x185.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-768x473.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-50x31.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-81x50.jpg 81w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-100x62.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-162x100.jpg 162w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-1039x640.jpg 1039w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-640x394.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode-1247x768.jpg 1247w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_19_49-T-_-Amazon-Honeycode.jpg 1440w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/631;\" \/><\/figure>\n\n\n\n<p>So when you use <strong>[Project Name]<\/strong>[Code] it is referencing the Table column, not the Data Cell Variable, so of course you&#8217;ll get <strong><span style=\"background-color:#fcb900\" class=\"background-color\">#NAME? <\/span><\/strong>as its comparing it with something that has not been created until you push the DONE button and copy the data from the form to the Table. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"713\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-1024x713.jpg\" alt=\"\" class=\"wp-image-6442 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-1024x713.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-300x209.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-768x535.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-50x35.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-72x50.jpg 72w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-100x70.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-144x100.jpg 144w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-919x640.jpg 919w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-640x446.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode-1103x768.jpg 1103w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_18-T-_-Amazon-Honeycode.jpg 1450w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/713;\" \/><\/figure>\n\n\n\n<p>When you use the variable it works fine. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"735\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-1024x735.jpg\" alt=\"\" class=\"wp-image-6443 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-1024x735.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-300x215.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-768x551.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-50x36.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-70x50.jpg 70w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-100x72.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-139x100.jpg 139w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-892x640.jpg 892w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-640x459.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV-1070x768.jpg 1070w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_20_31-Films-TV.jpg 1393w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/735;\" \/><\/figure>\n\n\n\n<p>Then when you press the Done button, it takes the variable that you have inputted into the Data Cell field and copies it across to the Table Column as a Value (<em> in this case<\/em>)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"857\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-1024x857.jpg\" alt=\"\" class=\"wp-image-6444 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-1024x857.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-300x251.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-768x643.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-50x42.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-60x50.jpg 60w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-100x84.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-119x100.jpg 119w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-765x640.jpg 765w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-640x536.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-917x768.jpg 917w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV-1290x1080.jpg 1290w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/2020-07-08-18_35_43-Films-TV.jpg 1418w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/857;\" \/><\/figure>\n\n\n\n<p>So that was a day&#8217;s work figuring that out, a bit slow of me. So I haven&#8217;t had time to focus on the time issue of getting the correct calculation for that. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Time &amp; Duration<\/h3>\n\n\n\n<p>This had me mogodored for a while. Google Sheets uses a numberfrom a specific date, I think its seconds from that specific time, so you can use a formula to convert it into a specific date and time, so since its a simple number , for start\/finish times you just subtract one number from another and then convert into a time or a duration. <\/p>\n\n\n\n<p>I was messing around with formats, there are Date\/times, Dates 7 Time where time is hh:mm:ss and for luch periods I just wanted to use a number, say 1 1\/2  hours = 1.5, amd 1\/4 hour = .25. <\/p>\n\n\n\n<p>So how do you reconcile the two different formats? <\/p>\n\n\n\n<p>You have to reduce to the common denominator, which is minutes in this case.<\/p>\n\n\n\n<p>For start and end times find the hours and multiply them by 60 to convert to minutes. So for the End time, say 15:30, you can use the function =Hours([End]) * 60 to get the hour component of the time and turn that into mnutes. <\/p>\n\n\n\n<p>You would then find the minutes of each =Minutes([End])<\/p>\n\n\n\n<p>Then add =Hours([End]) * 60+Minutes([End])  to get the End time in minutes, then do the same for the start and subtract one from the other. <\/p>\n\n\n\n<p>Thus you&#8217;ll have the interval between End and Start in minutes. <\/p>\n\n\n\n<p>Then multiply the [Lunch]* 60 to get lunch in minutes , subtract that from the previous subtotal and you&#8217;ll have actual working time. Divide that by 60 to get the hours and fractional hours. <\/p>\n\n\n\n<p class=\"has-background has-pale-cyan-blue-background-color\">=(((HOUR([End])*60+MINUTE([End]))-(HOUR([Start])*60+MINUTE([Start])))-([Lunch]*60))\/60<\/p>\n\n\n\n<p>A bot of a tedious method , but it works. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Timesheet progress<\/h3>\n\n\n\n<p>A<strong>t this point we have App &amp; Data doing the following:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Overall summary tab showing all timesheet inputs, by everyone who has the app. Currently I&#8217;m the only one using it so its all my data.<\/li><li>Have delete tab if we want to remove a row of data<\/li><li>Have an input tab that allows us to select a project and put time against that project in 2 ways. 1\/ By Start time, End time and unch breaks(or total breaks) or 2. By just putting in a Total hour for a day on a specific project. <\/li><li>So can work on multiple projects and book them in the timesheet on the same day. <\/li><li>The row of data is inputted against the user ( this uses the <strong><span style=\"background-color:#fcb900\" class=\"background-color\">$[SYS_USER]<\/span><\/strong> variable) that identifies who is logged into the app and inputting data (based on your login to the Honeycode app. <\/li><li>All the people who have the app can put timesheet data into it. Everyone using this app cabn see everyone elses data, so this is the Manager App.<\/li><\/ul>\n\n\n\n<p><strong>Where to next? <\/strong><\/p>\n\n\n\n<p>There are a few paths we can take from here:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Filter to only show the logged in user&#8217;s timesheet information. The User App<\/li><li>Chunk the information into manageable lumps, eg Duration, say filter to a start\/end date, or by week, or month<\/li><li>Filter by project and by start\/end date<\/li><li>Sum up hours to date within a specific timeframe, or do a running total of hours on the project. <\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">End comment<\/h3>\n\n\n\n<p>I am finding that Honeycode is not that intuitive, I&#8217;m expecting the Table to act like a normal spreadsheet ( Excel \/Google Sheets) but it doesn&#8217;t. <\/p>\n\n\n\n<p>I thought I could drive the app from the Table, but that doesn&#8217;t seem to be the case. Maybe when I&#8217;m a bit more familiar with it I may be able to. I did spend an awful lot of time formatting columns and that seemed to disappear when you went back and re-looked at the Table column formatting. And it didn&#8217;t seem to propogate down the rows as they were created either. <\/p>\n\n\n\n<p>There is a logic in there somewhere but I&#8217;m finding it hard to get to grips with. For the amount of time I&#8217;ve spent I&#8217;m quite disappointed with my progress. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome Early Bird All-Access Patron&#8217;s &#8211; An exclusive post for you This is extra information about the video on &#8220;Honeycode Timesheet App &#8211; part 1&#8221; that is acvailable exclusively for you. Big picture stuff first- Honeycode API In my previous overview video I stated that the power of Honeycode would be when you connect into [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6448,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[454,455],"tags":[],"class_list":["post-6431","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all-access-patron","category-honeycode-aws"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/202.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/07\/202.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\/6431","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=6431"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/6431\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/6448"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}