Build a behavioral log in Google form/sheets/docs

I work with a residential treatment center that treats minors. I would like to transition their behavioral log to Google suite. The log should work like this. Staff while logged in to their google account (provided by the treatment center) would open a google form to make a log entry. The form would include the name of the resident the entry is concerning (if this could be done with a dropdown that would be great), a rating on a five point scale (1=calm/happy 5=Out of control) checkboxes for any flags that apply (attention medical, attention mental health, run-risk, suspicious behavior, etc.), a place for the entry of text (long form... one sentence to multiple paragraphs. When submitted the entry is placed in a google sheet. So far that is the easy part (other than the dropdown of names). I have already created this form that logs that info to a spreadsheet. This second part is where I really need help. Staff should also be able to read the log in a convenient way without looking through months of entries. They should be able to search by date or date range and see the entries for those dates. They should also be able to search for all entries about a particular resident. And they should be able to search for all entries with a 5 point scale rating above a 3, for example. While viewing the log, staff should not be exposed to the "raw data" or be forced to do formatting to get the data into a readable format, nor should they be able to change the data while viewing it. Security is critical. Only authorized users should be able to enter or view data.

Znanja: Administracija podatkovnih baz

Več: build an ios and android application to view 360 degree and 3d vr animation videos for google cardboard, build an ios and android application to view 360 degree and 3d vr animation videos (for google cardboard), dive log google docs, using google forms to track behavior, google form behavior log, google form student behavior, discipline referral google form, google forms add ons, behavior tracking sheet template, progress monitoring google forms, google forms for special education, javascript, google app engine, googlescripts, build location finder google maps postcode, sample php code form add edit view, build itinerary dates google maps, google virtual earth street view, build tgp money google, google thumbnail parameter street view

O delodajalcu:
( 1 ocena ) Benson, United States

ID projekta: #15875103



Hi there, It seems that Google Script web application will be the right option for your case. First of all, regarding security, the web app will be only accessible for users within your G suite domain, just like whe Več

$350 USD v 7 dneh
(0 mnenj)

6 freelancerjev ponuja v povprečju za $549 na tem delu


Looking for quality services that can meet your goals and objects beyond the expectations. You’re at right place.

$833 USD v 10 dneh
(0 Ocen)

Hello. I can do second part using Google Apps Script HTML Service. Google provides interaction by custom HTML interface using AJAX. So, I can create an interface as HTML. Staff can use this HTML interfa Več

$750 USD v 7 dneh
(0 Ocen)

Hello, I am an experienced Clinical Trial Specialist/PubMed Expert/Medical Researcher. I am an expert in Medical/Pharma/Health/Nutrition Research. I worked for trial trove project of Citeline intelligent soluti Več

$555 USD v 5 dneh
(0 Ocen)
$555 USD v 10 dneh
(0 Ocen)

Hi, I can help you here. I would be able to create an application within google scripts. That will access the sheet and query for the data. You can authorize that app to users just like how you can authorize any Več

$250 USD v 10 dneh
(0 Ocen)