Build google sheets -- 2
Budget: $30 – $250 USD
I want two tables on google sheets (connected) + google form for new entries.
Sheet #1:
This is where I have the list of the drug stores that store our medicines, as a list they must be shown, and what items (drugs) are still available there in numbers. See image 1
I want to keep track of the drugs that are available there, so the stores won’t be out of stock. how? This is where the sheet #2 comes into play. And the google form or manual edit of the amount of available stock in the drug stores.
Sheet #2:
This is where I keep record of places (pharmacies) I have visited on a daily basis, like a monthly to-do, days of the month should be added automatically and each day I visit lets say 10 pharmacies I enter names of the pharmacies, what items they need to be sent to them (name of drugs should open like a menu to select from- because we also add names of the drugs via a google form) and from what drug store they want the items to be sent plus the amount of each drug. And the said amount of drug must be deducted from selected drug store automatically, so I see what drug store is out of stock on sheet #1
So the project to work is like this:
Two person work for a company, which sells medicines.
One is responsible for the drug stores not to be out of stock by looking at sheet #1, and tells the drug stores to send an amount of some medicines to a pharmacy by looking at sheet #2 (a check mark should be next to the order for it to apply the deduction on sheet #1 and approve the order.
Sheet #2 another lerson works on, who visits pharmacies and asks if they are out of stock in our company’s brand drugs. Lets say 3 pharmacies request some amount of few medicines, this person next to a date, submits an order, where he/she fills the name of the pharmacy, name of drug, amount and selects which drug store. Lets say another check mark at the end to send the order to the other person to see..(where? Your idea :) ) and when he/she presses the check mark the amount of each drug from the selected drug store will be deducted.
To again fill the drug stores with our stock person number 1 can manually edit the numbers when he/she supplies the drug stores again and add the amount manually.
I think the idea is simple and there can be examples out there for a project like this.
Further details will be provided
Sheet #1:
This is where I have the list of the drug stores that store our medicines, as a list they must be shown, and what items (drugs) are still available there in numbers. See image 1
I want to keep track of the drugs that are available there, so the stores won’t be out of stock. how? This is where the sheet #2 comes into play. And the google form or manual edit of the amount of available stock in the drug stores.
Sheet #2:
This is where I keep record of places (pharmacies) I have visited on a daily basis, like a monthly to-do, days of the month should be added automatically and each day I visit lets say 10 pharmacies I enter names of the pharmacies, what items they need to be sent to them (name of drugs should open like a menu to select from- because we also add names of the drugs via a google form) and from what drug store they want the items to be sent plus the amount of each drug. And the said amount of drug must be deducted from selected drug store automatically, so I see what drug store is out of stock on sheet #1
So the project to work is like this:
Two person work for a company, which sells medicines.
One is responsible for the drug stores not to be out of stock by looking at sheet #1, and tells the drug stores to send an amount of some medicines to a pharmacy by looking at sheet #2 (a check mark should be next to the order for it to apply the deduction on sheet #1 and approve the order.
Sheet #2 another lerson works on, who visits pharmacies and asks if they are out of stock in our company’s brand drugs. Lets say 3 pharmacies request some amount of few medicines, this person next to a date, submits an order, where he/she fills the name of the pharmacy, name of drug, amount and selects which drug store. Lets say another check mark at the end to send the order to the other person to see..(where? Your idea :) ) and when he/she presses the check mark the amount of each drug from the selected drug store will be deducted.
To again fill the drug stores with our stock person number 1 can manually edit the numbers when he/she supplies the drug stores again and add the amount manually.
I think the idea is simple and there can be examples out there for a project like this.
Further details will be provided