Featured Support Questions: September 2016

We answer hundreds of support questions each month from Ocean users about everything from creating forms to choosing a tablet. We chose a few recent customer questions that we think may be helpful to other users. Have a question you would like answered for next month? Let us know by submitting a ticket here! (please note in the description that you would like to see this featured as a newsletter topic!)

Q: I’m creating a form with scored responses, and I want to generate an average score. However, some questions may be left unanswered by patients. How do I create a rule that averages only those questions with a response?

A: You can easily add a formula in Ocean forms to automatically calculate average scores. You simply add an item in the form, and under question type, you select “Formula”. You can then use the “Scripting and More” tab in the editor to add the desired formula.

Generating a simple average is straightforward if you can always assume a fixed number of answered questions (if you require a response to all questions). For example, for five questions with refs “q1”, “q2” etc., your formula would look like this:
( q1.p + q2.p + q3.p + q4.p + q5.p ) / 5

However, it gets a bit trickier if you only want to count a question when it’s answered. Using the above example, if q3 was left blank, you would only want to only divide by 4. That means you need to calculate the denominator by adding 1 for each answered question. You can do it like this:
( q1.p + q2.p + q3.p + q4.p + q5.p ) / (q1.r != ” ? 1 : 0) + (q2.r != ” ? 1 : 0) + (q3.r != ” ? 1 : 0) + (q4.r != ” ? 1 : 0) + (q5.r != ” ? 1 : 0)

Want to understand how this works? Here’s the explanation:

The “.r” is the literal response, so q1.r == ” means the answer is blank, q1.r == ‘N’ is “No”, q1.r == ‘Y’ is “Yes”. The statements (q1.r != ” ? 1 : 0) are javascript shorthand for saying “use 1 if q1.r isn’t empty; otherwise use 0”.

Q: We recently started using Ocean and we keep being asked for our shared encryption key on different client terminals. How can we prevent this?

A: For security reasons, each browser needs to be individually authenticated with the shared encryption key at least once. This means that when various machines in the same clinic open the browser to Ocean for the first time, they will receive this message. Also, if the default browser is changed, the message will appear the first time Ocean is opened in the new browser. It shouldn’t happen twice on the same machine in the same browser.

To prevent clinicians from seeing this message in TELUS PS Suite, you can perform a one-time quick task on each client computer. First, click Ocean, then Portal or Email Patient on the custom form, then click Remove. This has a handy feature that automatically passes the encryption key to the browser to skip the entry process.

Q: We have multiple active tablets running. Is there a way of identifying which patient last used a specific tablet?

If the patient completed a form on the tablet, you can export the “form completed” audit records for the day. You can do this from the Ocean Portal by clicking on the Admin->Reports tab and exporting the audit report. It shows the mac address and the Ocean ref (you can then look for the Ocean ref in the patients tab in the Ocean Portal).