How can "Forms"? help me?
Above are the forms created by the two forms tools - Google and Microsoft

How can "Forms" help me?

Let’s say you visited your doctor and s/he asks you to track something. This isn’t make believe. Here’s a real world example from my doctor, “I’d like you to track your blood pressure and keep a log of the readings.”

So, what to do?

  • First, I needed to get the thing that does this (fortunately my wife had already purchased one - SunMark model 132SM). Nice!
  • Next I had to create a log to track the readings. Now I could use a “Big Chief” tablet and a number two pencil. Put in column headings of: Date, Time, Systolic, Diastolic, Pulse, and Notes. I know that would probably be a problem because the tablet would probably be moved and then I’d have an excuse to not do it.
  • I could use a spreadsheet to do it via Google Sheets or Microsoft Excel. Both are cloud based and available on my phone (which is almost always with me). So that seems like an excellent option.
  • To quote Ron Popeil, “But wait, there’s more!” Both Google and Microsoft have another tool in the toolbox – Forms! Forms provides you with a way to automate filling out the spreadsheet and better yet you can save the form link to your phones home screen so it’s always a click away. You can also create a calendar reminder with the link should you need that extra reminder (I haven’t gone that far...yet).

So, what’s involved with creating a form?

  1. Open “Forms” in whichever tool you use.
  2. Create a “Form”
  3. Add questions:
  4. Google asks for a valid email as a question, Microsoft does not. This isn’t a useful question in this scenario. It is a critical question when you create a form with multiple people responding to it. See my piece on PAR for details.
  5. Enter “Systolic” – I selected “Text” as the field type because “numeric” wasn’t an option.
  6. Enter “Diastolic” – I selected “Text” as the field type because “numeric” wasn’t an option.
  7. Enter “Pulse” – I selected “Text” as the field type because “numeric” wasn’t an option.
  8. Then I add a “Notes” field to enter something which might have caused a change from the norm, for example “I just drank three cups of Cuban Coffee before taking my readings”
  9. Then “send” it to your email as a link or as a form. Either work.
  10. Voila – You have the form ready to go.

Once you have a fair amount of results to see them in a spreadsheet you return to the form and select that you want to review the data in a spreadsheet – and it’s all there and shareable. Sweet!

You might wonder how I figured this out. Well, I originally learned about forms using a phone database tool called “Memento” to track mileage for work. It was simple to use and tied to Google Sheets so I could fill out my mileage expense reports. I realized after switching phones and not having Memento that perhaps #Forms could do the same thing and it did. The shift in logic from miles to heartbeats was an easy one.

If you’re not using “Forms” whether #Google or #Microsoft, you might want to check it out.

要查看或添加评论,请登录

David Nelson的更多文章

  • AI and the service department.

    AI and the service department.

    Here is my reply to Dave Foy’s question regarding AI and the service advisor. What is the job of a Service Advisor? I…

    1 条评论
  • AI and the arts - Suno

    AI and the arts - Suno

    This post deals with AI, volunteering and Ukraine. I’ve been intrigued with AI and its capabilities for some time and…

  • Copilot and the DMS market...

    Copilot and the DMS market...

    A while ago I wrote about AI and referenced a search of DMS vendors and the search rendered “bupkiss”. This morning…

    1 条评论
  • Generational Change: Questioned and Answered

    Generational Change: Questioned and Answered

    Do you ever think about the changes you’ve seen in your lifetime? Or about the changes your parents and grandparents…

  • Competitive Advantage: R&R, Tekion, and CDK

    Competitive Advantage: R&R, Tekion, and CDK

    Ever wonder what AI thinks about the DMS vendors? A quick note on my selections. Yes, I have a Reynolds bias having…

  • AI/ChatGPT: Death of a Salesman?

    AI/ChatGPT: Death of a Salesman?

    I wondered about this question, do sales professionals need to worry about being replaced by AI the likes of ChatGPT?…

    1 条评论
  • Bard (Google's AI) and Automotive DMS...

    Bard (Google's AI) and Automotive DMS...

    You might be wondering, “What is #BARD?” According to #Google, “Bard is an AI experiment from Google.” Think of it as…

    2 条评论
  • SaleSTN - Sales Training & Negotiation

    SaleSTN - Sales Training & Negotiation

    OK. So I was watching the latest Last Week Tonight with John Oliver a few minutes ago and it made me think of a problem…

    2 条评论
  • Thoughts on leaving the cloud...

    Thoughts on leaving the cloud...

    I recently read an article by David Heinemeier Hansson entitled why we’re leaving the cloud (https://world.hey.

  • MachTer is ChatGPT 2.0

    MachTer is ChatGPT 2.0

    #MachTer is #chatgpt 2.0.

社区洞察

其他会员也浏览了