Save iSpindel data in Google Sheets

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
-- Sla iSpindel data op in Google spreadsheet (via Google Forms)
-- dzVents script
data return {
    on = {
        devices = {
            'ispindel_Tilt',
        },
    },
    execute = function(domoticz, device)
        
        urlstart = "https://docs.google.com/forms/d/e/6LbYe73FbYFpuYpRnrI1uftkgg1FAIpQLJ8jcO2ZseiScyXnOgZuqivM/formResponse?"
        Omgevingstemperatuur = '&entry.957634191=' .. domoticz.devices('Omgevingstemperatuur').rawData[1]
        Temperatuur = '&entry.1426070478=' .. domoticz.devices('ispindel_Temperatuur').rawData[1]
        Tilt = '&entry.2009669143=' .. domoticz.devices('ispindel_Tilt').rawData[1]
        Plato = '&entry.671292995=' .. domoticz.devices('ispindel_Gravity').rawData[1]
        Batterij = '&entry.633183568=' .. domoticz.devices('ispindel_Batterij').rawData[1]
        Signaal = '&entry.1387325523=' .. domoticz.devices('ispindel_Signaal').rawData[1]
        
        url = urlstart .. Omgevingstemperatuur .. Temperatuur .. Tilt .. Plato .. Batterij .. Signaal
        domoticz.openURL(url) 
        
    end
}
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX