WEMO Ideas

Showing results for 
Search instead for 
Do you mean 
New Idea
0 Kudos

When using the IFTTT WeMo Insight Switch Channel, Triggers (e.g. 'Standby mode entered') include Ingredients (e.g. 'SwitchedToStandbyAt') that appear to be date/time stamps (e.g. 'August 30, 2014 at 03:35PM'). Unfortunately, if the Google Drive Channel is used to define an 'Add row to spreadsheet' Action, the 'timestamp' Ingredient is interpreted as text instead of a as a true timestamp that can be used in calculations or in charts. Moreover, the time is only displayed to the nearest minute, although there are applications where it would be useful to know the time to the nearest second.


Although spreadsheet functions can be used to extract a true timestamp, the resulting timestamps are still limited to the nearest minute, and it would be much simpler if a true timestamp were exported automatically.


I believe that this can be most easily remedied by changing the Ingredient value to look like 'August 30, 2014 03:35:15PM') by removing the word 'at' (twhich appears to disrupt the Google Sheet parsing of the timestamp) and adding seconds. An alternative would be to export the numeric serial number equivalent with a sufficient number of digits after the decimal point (5 or 6) to represent the nearest second, like '41881.649479'. This approach might be more confusing, because most people won't realize that all they need to do is choose an appropriate date/time format to make this display properly.