Input from Google Sheets to EMR

Hello,
My clinic's workflow involves capturing patient check-in information via a kiosk. The data is then formatted and put in a Google Sheet (HIPAA compliant) and I finally figured a way to use TB to copy and paste the information into our EMR (AthenaHealth). This saves at least a minute off a 15-minute visit, which adds up if we see at least 100 patients a week. The best benefit is that it decreases the human capital needed to complete a visit.

If you watch the video, you can see Text Blaze dealing with weird inputs like free-text, drop-downs or radio buttons. There's an if-statement to take into account if a patient wanted to input an email (it's optional).

Here is a video of Text Blaze in action: TextBlaze EMR Input - YouTube

The preformatted data looks like this:
Marneus
Calgar
2/19/2000
26 Dol Road
15206
7281029831
mcalgar@gmail.com

{=split({clipboard},"\n")[1]}{key: tab}{wait: delay=+0.2s}
{=split({clipboard},"\n")[2]}{repeat: 8}{key: tab}{endrepeat}{wait: delay=+0.2s}
{=split({clipboard},"\n")[3]}{repeat: 6}{key: tab}{endrepeat}
{=split({clipboard},"\n")[4]}{key: tab}{key: tab}
{=split({clipboard},"\n")[5]}{key: backspace}{wait: delay=+0.1s}{key: tab}{key: shift-tab}{key: tab}{key: tab}{key: tab}{=split({clipboard},"\n")[6]}{key: tab}{=split({clipboard},"\n")[6]}{key: tab}{key: tab}{key: tab}{key: tab}{click}{key: tab}{key: tab}{if: contains({=split({clipboard},"\n")[7]},"@")}{=split({clipboard},"\n")[7]}{key: tab}{key: tab}{else}{key: tab}{click}{key: space}{key: tab}{endif}{click}{key: downarrow}{key: downarrow}{key: downarrow}{key: tab}{click}{key: uparrow}{key: enter}{click}{wait: delay=+0.1s}{key: tab}{key: uparrow}{key: enter}{click}{wait: delay=+0.1s}{key: tab}{key: uparrow}{key: enter}{click}{wait: delay=+0.1s}{key: tab}{click}{key: downarrow}{repeat: 15}{key: tab}{endrepeat}{key: enter}{key: tab}{key: tab}{key: tab}{click}{wait: delay=+0.1s}{key: downarrow}{key: downarrow}{repeat: 5}{key: tab}{endrepeat}{click}{key: space}{wait: delay=+0.1s}{key: backspace}{repeat: 4}{key: tab}{endrepeat}{click}{key: space}{wait: delay=+0.1s}{key: backspace}

2 Likes