i get messages from different devices into a google spreadsheet. These messages are different depends on source device name and time interval and status..
I need someone with google spreadsheet scripting knowledge (google apps script), to write a script to automate reading the messages in sheet one and put the status in a table in sheet two :
1- search sheet1 in a loop for each of these 4 Devices and get the string.
2- extract from that string The TAG name , STATUS and time interval
3- put status in an existing table in the device row under the correspondent TAG and interval .
The status of a device should then be updated if there is a new message for that device.
4- give color green to positive status and red to negative status.
9 pekerja bebas membida secara purata €16/jam untuk pekerjaan ini
Hi. I'm professional programmer with experience over 20 years. I need to look to your spreadsheets and discuss another questions. See my completion rate and feedbacks. Regards, Alex.
Hi.. I saw your project and want to help with it if you will accept my proposal. Of course I cannot convince you but I can give you an assurance of a good job. Thanks.