Deleted <20 characters>

@RedKnight , I like your idea of modifying the column headers as you mentioned in post 174 . I tried doing something similar for the device name as well, but I’m not having success. Here’s what I did, do you have any suggestions? def shortdisplayname(evt) { String name = evt.displayName.trim() if (…

Somebody could post the full solution please? I dont understand how to log events in google Sheets, bypassin the app. Thanks!

Hi to everybody! Hi! I need some help, loggin HEM. I have one location, 2 HEMs, Google Sheets app installed and every thing works fine for 2 years. Now I add a new location, new hub, same GoogleSheet app. New Google sheet, but it does not work. I got this error [image] Line 283 said this: […

Hi all, This app is great. It worked first time for me and has been running fine for a week now. Is it possible to have more than one instance of the logging app? I would like to log my heating devices to one google sheet and my lighting devices to a separate google sheet. Many Thanks Tim

EDIT-added some webcore examples… Since the first post no longer points to this SmartApp, posting the link to working version again… [image] loverso-smartthings/googleDocsLogging SmartThings Google Sheets Logging. Contribute to loverso-smartthings/googleDocsLogging development by creati…

It looks like posts have been deleted, because what was post 154 back in 2016 is now post 125 and dropping. Just use the URL with /36719/154 at the end: [image] [OBSOLETE] Log events to Google Sheets [see post /36719/154 for Github repo and v1.1] Community Created SmartApps …

@RedKnight would you kindly be able to tell me what to adjust in the code to export a British dd/mm/yyy format? I’ve tried adjusting line 238 with various combinations but the results just turn out jibberish. My Sheet is set to a UK time zone plus column formatting seems to have no effect. Any othe…

Hi Shinedown78, are you talking about what you want to see in the Google Sheet output? That’s handled by simply formatting that column in the Sheet itself. I can show you how easily, if you can’t figure it out. Sometimes a problem can be that you think the CSchwer code is outputting a date-numeric v…

Thanks for the quick response. My issue is that the date data placed into the sheet is in American Format - I understand how to format the column dates, the issue is that when dates such as the 1st Dec list (11/01/2020) Google thinks it is the 11th of January and does not format it in any way, as i…

I completely understand the problem with mm/dd vs dd/mm; of course, everyone wants it in their preferred format. In fact I use yyyy/mm/dd for dates in my Sheet… Are you sure you’re getting a date value in the Google Sheet? To test, see if you can reformat it to any other date format. If you can’t, …

[OBSOLETE] Log events to Google Sheets [see post /36719/154 for Github repo and v1.1]

SmartApps & Automations Community Created SmartApps

jlv October 5, 2020, 2:25pm 467

It looks like posts have been deleted, because what was post 154 back in 2016 is now post 125 and dropping. Just use the URL with /36719/154 at the end:

[OBSOLETE] Simple Event Logger

Topic		Replies	Views
[OBSOLETE] Simple Event Logger Community Created SmartApps smartapp_misc , logging , google	569	54670	January 12, 2023
Google Sheets Charts Devices & Integrations log , charts , smarttiles , logging , data	83	20318	October 17, 2022
ROUNDUP: Data Logging and Charting Solutions FAQ charts , logging , data	33	34002	May 10, 2022
Aeotec home energy meter V1(DSB09104-ZWUS) log to spread sheet General Discussion	2	1543	January 10, 2019
Google Sheets event logger Automation Ideas	3	836	June 16, 2023

[OBSOLETE] Log events to Google Sheets [see post /36719/154 for Github repo and v1.1]

Related topics