Končano

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.

Skills: Administracija podatkovnih baz

See more: 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, 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, build location finder google maps postcode, sample php code form add edit view, build itinerary dates google maps, google virtual earth street view

O delodajalcu:
( 1 mnenje ) Benson, United States

Project ID: #15875103

Awarded to:

mohamedkaram93

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 More

$350 USD in 7 days
(0 Reviews)
0.0

6 freelancers are bidding on average $549 for this job

HawkLogixLLC

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

$833 USD in 10 days
(0 Reviews)
0.0
celalaybar

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 More

$750 USD in 7 days
(0 Reviews)
0.0
harpreetdhanoa19

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 More

$555 USD in 5 days
(0 Reviews)
0.0
$555 USD in 10 days
(0 Reviews)
0.0
softtronicstech

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 More

$250 USD in 10 days
(0 Reviews)
0.0