Comprehensive Medication Tracking Google Sheets Script

Open Posted 16 minutes ago Paid on delivery Ends in 6 days
Open Paid on delivery Ends in 6 days

I want an app script written for google sheets that will allow people to enter these fields:

Client name (required field)

Client ID # (this one not required field)

Medication Name (required field), dosage (required), time and amount to take (required: such as example: Morning 1 tab daily), prescribed date (required), refill date (required), doctors name (not required).

There needs to be the ability to put in more than one medication (hopefully without reentering the clients name each time. There would be buttons for Searching, that would bring up a client's entire medication list including discontinued meds. A modify button, so that when a new refill comes in for an existing client one can simply modify the refill date of that med. and a button or option to check to discontinue a med (which would group it under discontinued meds for the individual client. I would like to be able to print a list of all clients and their medications grouped according to time of day. (morning, lunch, dinner, night). This would be a spreadsheet that can be viewed by all. I also want to be able to categorize clients as active or de-active after they leave. Yet, one could still search records be clicking active or de-active client. This is a link to something I saw similar to what I would like [login to view URL]

Google Sheets Excel Google Apps Scripts

Project ID: #39006032

About the project

10 proposals Open for bidding Remote project Active recently

10 freelancers are bidding on average $461 for this job

AwaisChaudhry

Hello, I understand you want a Google Sheets app script that helps in tracking medications for clients efficiently. The script will allow users to input crucial information like client name, medication details, and re More

$750 USD in 12 days
(1 Review)
6.4
ravinderkumar248

Hi there, I can create a Comprehensive Medication Tracking system os Google Sheets based on your requirements. Having worked extensively with Excel and Google Sheets, I am well-versed in designing complex templates an More

$250 USD in 2 days
(162 Reviews)
6.1
monicawriter99

Dear employer, I hold a Master's degree in Economics and statistics making me a suitable person for your project " Comprehensive Medication Tracking Google Sheets Script ". I have more than 3 years of professional expe More

$250 USD in 3 days
(17 Reviews)
4.6
andominori

Hi, It's nice to meet you I am new here, but I have enough skills in this part and I have done lots of projects like this. And familiar with Google Apps Scripts, Google Sheets and Excel. I have a relatively good und More

$455 USD in 7 days
(0 Reviews)
0.0
SourceOasisBPO

⚠️ IF YOU'RE NOT HAPPY YOU DON’T PAY ⚠️ I think we are the perfect fit for your project. Understanding the need for a clean, professional, and user-friendly Google Sheets app script for medication management, we offer More

$550 USD in 5 days
(1 Review)
0.6
Neefiqahh

Having been an HR management student with a deep penchant for innovation, meticulousness, communication and problem-solving, I am confident in my ability to deliver an app script that'll take your medication tracking s More

$500 USD in 7 days
(0 Reviews)
0.0
nikhilr34

This project involves creating a Google Apps Script to manage client medication records within Google Sheets. The solution will enable users to: - Input details such as Client Name, Client ID, Medication Name, Dosage More

$500 USD in 7 days
(0 Reviews)
0.0