# \[App\]\[Pro\] Homey Easy Logger **URL:** \ **Category:** Apps\ **Tags:** tools\ **Created:** [February 4, 2023, 9:22pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021 "2023-02-04T21:22:25Z")\ **Posts on this page:** 20\ **Page:** 5
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [December 5, 2023, 8:21pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/81 "2023-12-05T20:21:20Z")
I’m not shure which script, but I guess there is a parse statement. Try to log the data before the parse. Looks like the input is not what you expect Something like this: console.log(‘input’, input); const textFromJSON = JSON.parse(input1); const t = Object.entries(textFromJSON); ---
**Author:** ![Haakon\_Stenbeck](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/haakon_stenbeck/32/79416_2.png) [@Haakon\_Stenbeck](https://community.homey.app/u/Haakon_Stenbeck)\ **Post date:** [December 5, 2023, 9:04pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/82 "2023-12-05T21:04:22Z")
[https://wiki.bwa.no/plugins/servlet/mobile?contentId=222593166#content/view/222593166](https://wiki.bwa.no/plugins/servlet/mobile?contentId=222593166#content/view/222593166) ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [December 6, 2023, 6:52am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/83 "2023-12-06T06:52:13Z")
Be aware that you cannot run this script directly without any input. You but aither create the flow or update script temporary to from const textFromJSON = JSON.parse(input); to const textFromJSON = JSON.parse(typical\_input); ---
**Author:** ![Haakon\_Stenbeck](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/haakon_stenbeck/32/79416_2.png) [@Haakon\_Stenbeck](https://community.homey.app/u/Haakon_Stenbeck)\ **Post date:** [December 6, 2023, 9:54am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/84 "2023-12-06T09:54:59Z")
I testet with from const textFromJSON = JSON.parse(input); to const textFromJSON = JSON.parse(typical\_input); ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/0/3039f0b925411bb301cb447ecd44524b19278843.png) ---
**Author:** ![Haakon\_Stenbeck](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/haakon_stenbeck/32/79416_2.png) [@Haakon\_Stenbeck](https://community.homey.app/u/Haakon_Stenbeck)\ **Post date:** [December 6, 2023, 9:55am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/85 "2023-12-06T09:55:36Z")
![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/9/8/984a269e7407668f9fff4d1c71cc15515ce8ee44.png) ---
**Author:** ![Haakon\_Stenbeck](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/haakon_stenbeck/32/79416_2.png) [@Haakon\_Stenbeck](https://community.homey.app/u/Haakon_Stenbeck)\ **Post date:** [December 6, 2023, 9:56am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/86 "2023-12-06T09:56:11Z")
![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/f/dfab1a11d45471a56772c59613fc62324670dfb2.png) I’ve made a flow with update new prices and then homeyscript with price, but I get no prices in the sheet ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [December 6, 2023, 10:07am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/87 "2023-12-06T10:07:39Z")
Looking good, see no issues here ---
**Author:** ![Haakon\_Stenbeck](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/haakon_stenbeck/32/79416_2.png) [@Haakon\_Stenbeck](https://community.homey.app/u/Haakon_Stenbeck)\ **Post date:** [December 6, 2023, 10:09am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/88 "2023-12-06T10:09:28Z")
![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/2/a207f476204f79add6c32ea32eb317cce9e1ee26.png) Do I have to wait for the new prices to be updated? ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [December 6, 2023, 10:34am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/89 "2023-12-06T10:34:23Z")
yes, it’s hard to test. But you can test by replacing #Priser with the example data from the script ---
**Author:** ![Haakon\_Stenbeck](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/haakon_stenbeck/32/79416_2.png) [@Haakon\_Stenbeck](https://community.homey.app/u/Haakon_Stenbeck)\ **Post date:** [December 6, 2023, 10:43am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/90 "2023-12-06T10:43:07Z")
Ok. Thanks. I’ll wait for the prices to be updated and then see ---
**Author:** ![Haakon\_Stenbeck](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/haakon_stenbeck/32/79416_2.png) [@Haakon\_Stenbeck](https://community.homey.app/u/Haakon_Stenbeck)\ **Post date:** [December 6, 2023, 11:45am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/91 "2023-12-06T11:45:36Z")
No price in the sheet ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/5/e514135d663d0b8f41a0b137cef722d10f596d67.png) Is there another way get the spreadsheet to put the prices in 24 cells? I can the the prices to look like this ---
**Author:** ![Haakon\_Stenbeck](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/haakon_stenbeck/32/79416_2.png) [@Haakon\_Stenbeck](https://community.homey.app/u/Haakon_Stenbeck)\ **Post date:** [December 6, 2023, 11:46am UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/92 "2023-12-06T11:46:06Z")
![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/6/7/67b03fab388a5177c9f0fff8ade290d5778f2b67.png) I can’t ask more questions due some rules that new users can’t post more than 3 posts 🥵 🧐 ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [December 6, 2023, 12:30pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/93 "2023-12-06T12:30:18Z")
You have probably trouble setting correct delimiter. This is how it looks like in my sheet ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/3/1303a9023b6b1739265c437bbe7e812f4b1b8642.png) ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 4, 2024, 5:33pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/94 "2024-02-04T17:33:17Z")
Hi, I have finished the 1. Setup step here and configured the Homey app. I want to log timestamps from my doorlock to the sheet. Not sure how to configure a script to make this work. Has anyone dine anything like this before? ---
**Author:** ![bwa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bwa/32/17852_2.png) [@bwa](https://community.homey.app/u/bwa)\ **Post date:** [February 4, 2024, 8:24pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/95 "2024-02-04T20:24:57Z")
You get a timestamp in first column automatically ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 5, 2024, 6:04pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/96 "2024-02-05T18:04:29Z")
Do you mean just use a flow directly from the doorlock, like this? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/8/881e303f1312ba079503234cafb2919da30c2c29.png) ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [February 5, 2024, 6:14pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/97 "2024-02-05T18:14:32Z")
You have to create a Sheet only ones. The next time you want to store the data, you only have to use the ‘Append multicell’ card. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/c/6/c61f98aeba0aba0a415b5a05de19e5204925818f.png) In this example, I have strored the Sheet Name in a variable. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/9/b97e2ec8b65d7b9b3d9ec7780aeeb015e94c0acf.png) ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 5, 2024, 6:25pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/98 "2024-02-05T18:25:18Z")
Thank you very much for the fast reply! So you don’t need to make a script to get out the values to the sheet? ---
**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\ **Post date:** [February 5, 2024, 6:29pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/99 "2024-02-05T18:29:28Z")
This can all be done in normal flows, in Advanced flows or in the old standard flows. You can insert all available Tags and/ or text, separate the fields with a semicolon ; ---
**Author:** ![Tirrazo](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/tirrazo/32/55444_2.png) [@Tirrazo](https://community.homey.app/u/Tirrazo)\ **Post date:** [February 6, 2024, 5:11pm UTC](https://community.homey.app/t/app-pro-homey-easy-logger/76021/100 "2024-02-06T17:11:42Z")
I have tried to make a test by looking at the video on Loom, but I get an error: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/1/f197a51ca7f55868ee85bfc3532548cdd8fab300.png) [Previous page](https://community.homey.app/t/app-pro-homey-easy-logger/76021.md?page=4) [Next page](https://community.homey.app/t/app-pro-homey-easy-logger/76021.md?page=6)