How to make a Friends and Family test using Google Forms
The Friends and Family Test (FFT) is an important tool that allows patients and other people who use NHS services to give feedback on the experiences. Here is how you can create a simple online feedback form which you can send out to patients using Accurx!
The FFT is designed to be a quick and simple mechanism for NHS services to identify what is working well and improve the quality of patient experience. The NHS outlines that providers should make it as easy as they can for all patients and people using their services to use the FFT to give feedback. For more info on these guidelines and other tips and tricks for optimising your FFT, head to the official NHS FFT page and their detailed FFT guide ⭐
The FFT is made up of a single mandatory default question followed by at least one open free-text question so that people can express themselves in their own words. Use the NHS guide attached above to streamline these questions for your audience 👪
Below we’ve outlined how you can really easily set up an FFT using a couple of free online survey platforms and get this sent out to your patients in no time!
*Please note that we advise you to discuss the use of Google forms (including any other providers such as Microsoft Office) with your Data Protection/Information Governance officer first.
Creating a Google Form
You’ll need to log into a Google account in order to create a Google Form 👍
Create a new form
Head to https://docs.google.com/forms/.
Select the ‘Blank’ template under ‘Start a New Form’ (shown below)
Edit the title and description of your form
Here, you’ll want to clearly outline your service so users know what to base their feedback on. For example...
Thinking about your recent visit/your GP practice/your stay in the hospital/the service we provide etc.
Create your first question!
This will likely be the standard question for most settings. This question requires a 6-point response scale as shown below 👇
To set up multiple choice answers, select the drop-down to the right of your question.
Click on ‘Multiple choice’.
Click ‘Add option’ at the bottom of the options and add all 6.
You can edit each option by clicking on it!
Turn on the ‘Required’ toggle at the bottom so this question can’t be skipped.
Create your follow up questions
The NHS recommends a pair of free-text questions to follow up on the standard question (as shown in the screenshots below) 👇
To add a question, click the ➕ button in the toolbar to the right of your first question.
2. From the dropdown, select ‘Paragraph’, and write your free text question(s).
🌟 To save you a bit of time, we've made a template that you can duplicate into your Google Forms account. Click here to find it! 🌟
Set up a spreadsheet for the responses
Click on the 'Responses' tab at the top of the page.
Click the green icon on the right hand side to create a spreadsheet.
Click 'Create a new spreadsheet' and name the spreadsheet something so you can easily find the responses.
Click 'Create' and your Google account will create and link a spreadsheet with all of the questions populated. Every time you receive a new response to the Friends and Family survey it will appear in this spreadsheet.
⚡Top Tip: make sure the spreadsheet is shared with team members who need access to the results of the survey⚡
Adjust the settings and share with your patients
You need to make sure that your survey is accessible to everyone you share the link with. You’ll also need to ensure that all responses are anonymous.
Click on the ‘Settings’ tab at the top of the page.
Select ‘Responses’.
Ensure that both ‘Requires sign-in’ toggles are switched off.
Select ‘Send’ in the top right of your screen.
5. Click on the 🔗 link tab.
6. Shorten your URL by checking the box 👆 so it take up less space in your messages.
7. Copy your link, paste into a message, and send!
FAQs
How can I find data for a particular month?
How can I find data for a particular month?
Within Microsoft Forms, the responses are listed in chronological order. To extract data over a particular timeframe, you'll need to open a spreadsheet.
Under the responses tab click 'Open in Spreadsheet'. 💻
The data and time of each submission should be visible on the left-hand side. Scroll to the date you're looking for. 📆
Select the cells over this timeframe by clicking and dragging your mouse over the cells. 🐭
Copy this data by using CTRL + C on your keyboard. ⌨️
Paste the data in a new spreadsheet by using CTRL + V on your keyboard.
You can now share this spreadsheet with data on a particular month or timeframe with your colleagues or PCN.
My patients say they can't access the survey, why is this?
My patients say they can't access the survey, why is this?
If your patients click the link to the Friends and Family survey and are unable to view the questions you may need to double-check your settings 🔍
Accepting Responses ✅
When you click on ‘Responses’, please ensure that ‘Accepting responses’ is selected.
Shareable Link 🔗
Please make sure that you've provided the correct link to your patients in the post-appointment message.
When you click on ‘Send’ in the top-right corner, select the link icon 🔗 then copy the link 👇 That is the correct link to share with your patients.
Top Tip 💡 Click 'shorten URL' to reduce the length of your text and save on SMS Costs
If you still have any questions or concerns, feel free to chat with us using the green message bubble in the bottom right-hand corner of this page. 👉