Considering many my posts will undeniably be grandiose suppositions and unconscious sophistry I would like to provide something practical solution for your attention!

           I’ve been experimenting with methodologies to log events and/or metrics in the most efficient manner. In the interest of disclosure, I would note that I am the Sales Manager of NFC Wireless Australia so access to the technology wasn’t a hurdle.

Most of these tags log the data to a spreadsheet – subsequently most of this data is logged to the aggregate QA spreadsheet.

I use NFC tags to quantify myself by measuring and logging time metrics regarding the most basic functions.

Wake/Sleep cycles
Calorie Consumption
Water Consumption
Caffeine and Nicotine
Bathroom stops
Work-on/Work-off

Find the anecdotal recount here.

          Quantification via NFC requires the combination of hardware and web-services.
The hardware: Phone and Tags
Services and Software: Encoding Application, Google Account and Drive, IFTTT, MAKER within IFTTT.


          Primarily, creation of a google sheet is necessary – pretty self explanatory.
Secondly, IFTTT provides the services needed to log time events with NFC tags. After establishing the necessary profiles – the IFTTT formula is,

IF = Maker application
THEN = Google Drive – Add new line to google spreadsheet.

This ‘add line function’ – Can be split into two variables being a static log or an on/off function. For the static log function, it’s easy enough and will automatically create a spreadsheet if one doesn’t exist. In order to function as on/off or in/out this formula must be used


[+Add ingredient] = OCCOUREDAT

Followed by
||| =IF(ISODD(ROW()), “Started”, “Stopped”) ||| =IF(ISEVEN(ROW()),ROUND(((DATEVALUE(REGEXEXTRACT(INDIRECT(ADDRESS(ROW(),COLUMN()-2,4)), “\w+ \d{2}, \d{4}”)) + TIMEVALUE(REGEXEXTRACT(INDIRECT(ADDRESS(ROW(),COLUMN()-2,4)), “\d{2}:\d{2}[A|P]M$”))) – ( DATEVALUE(REGEXEXTRACT(INDIRECT(ADDRESS(ROW()-1,COLUMN()-2,4)), “\w+ \d{2}, \d{4}”)) + TIMEVALUE(REGEXEXTRACT(INDIRECT(ADDRESS(ROW()-1,COLUMN()-2,4)), “\d{2}:\d{2}[A|P]M$”)))) * 24, 2),””)


            In the interest of disclosure, this is not my formula – it has been pulled from other MAKER apps after a long night of troubleshooting – hence the exact MAKER app eludes me.



           The MAKER webhook will call this function – this can be found in the Maker service Settings (IFTTT Settings>Services>Maker). From memory this was a pain in the ass but the webhook url will look like

            https://maker.ifttt.com/use/(your account URL number, it will appear in settings in MAKER)

           In order for the webhook to perform the function –

            https://maker.ifttt.com/trigger/(spreadsheetname)/With/key/(your account URL)

            Depending on the application the url would need to be changed to the desired spreadsheets name. Once we have this URL, we can encode this to an NFC tags.

            For the layman, NFC Tasks and NFC tools (from Wakdev) is what I would recommend due to the simplicity of the UI. For those who are computer savvy I would suggest NXP TagInfo and TagWriter. As NXP are manufacturers of these tags it’s a very powerful app. Once one of the applications are loaded up it is simply a matter of encoding the webhook.



             Smartlocks deserve a mention here – a phone needs to be unlocked for an NFC action to execute; the NFC tag is still scanned and the UID is read. Because of this, most of my tags  are programmed to be are recognised by my phone as a Smartlock.  The Smartlock function (on my s5) allows for me to scan with a locked phone (as long as it is ‘awake’) and when the UID is read, it will automatically unlocks and executes the function.

Hopefully, this process can assist with your own self-quantification.

Advertisements