Flic Home

    Community

    • Login
    • Search
    • Popular
    • Users

    Counting with Flic in Google Sheets or Excel

    General Discussion
    4
    4
    3048
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • hjalteworm
      hjalteworm last edited by

      Hi guys,

      I just had a baby and have the idea to use Flics to build the most awesome diaper-changing-station with hue lights that are red at night to not disturb the little angles eyes. That part is easy to set up.

      But I also want to keep track of the number of changed diapers, contents etc:-)That part is more difficult.

      Any of you know if it is possible to count pushes of buttons in a Google Sheets, Excel or similar? I know that there is a simple "count" action in Flic, but I need the data to be exportet. I am sure most other uses for counting with Flic would also benefit from being accessible outside of the app.

      Hope someone can help!

      Thanks a bunch,

      /Hjalte

      1 Reply Last reply Reply Quote 1
      • christian.genco
        christian.genco last edited by

        I got daily counters working from flic to google sheets by keeping one sheet that adds a new row with the timestamp a flic button is pressed (via. IFTTT) and another sheet that counts the number of rows on the first sheet that match a given day.

        Here's what the first sheet () looks like:

         2022-03-21 at 8.49.47 PM.png

        Here's what the second sheet looks like:

         2022-03-21 at 8.49.34 PM.png

        The formula I use in the second sheet is:

        =COUNTIFS(Sheet1!A:A, ">="&A2, Sheet1!A:A, "<"&A3)
        
        1 Reply Last reply Reply Quote 0
        • vjdjr0
          vjdjr0 last edited by

          This is definitely possible, but not quite the way you think.

          I suggest using IFTTT so that every time the flic is pressed, it triggers some other app to do something. We're an Apple household, so a good choice would be to trigger adding an iOS reminder (with the date/time, perhaps) to a specific list. From there, any peek at the list will note the number of items on it.

          1 Reply Last reply Reply Quote 0
          • chuan137
            chuan137 last edited by

            I think you need an App, wired up with the official app, getting the counts and send it to whereever you want on internet.

            The button itself is just a bluetooth device, it won't connect to the internet by itself.

            The problem is probably, it might be you or your wife is doing the job, so the paired device is not always connected.

            I don't whether you could let your PC do the job easily

            1 Reply Last reply Reply Quote 0
            • First post
              Last post