Build google sheets
Budget: $30 – $250 USD
I want two tables on google sheets (connected)
1- a table where I keep record of places I have visited on a daily basis, and add notes to them -the places are pharmacies, I visit them and see if they're out of stock in our brand or not? what they need to be added to their stock (further details later)
2- a table for the drug stores that store our medicines, (they're around lets say 10 stores) I want to keep track of the drugs that are available there, how? when I send drugs (in the table #1) to the pharmacies, I specify from which drug store I sent the medicines, by doing that the amount of medicines from the drug stores should be deducted and be shown next to the drug store name which items are available there.
for table 1 it can be like a monthly track and report, each day, how many pharmacies have been visited, what they ordered (name of medicine and amount, from which drug store)
* the items (medicines) should have a google form like page where I will be able to add new medicines.
I know this has to be more in detail. will give more explanation later.
1- a table where I keep record of places I have visited on a daily basis, and add notes to them -the places are pharmacies, I visit them and see if they're out of stock in our brand or not? what they need to be added to their stock (further details later)
2- a table for the drug stores that store our medicines, (they're around lets say 10 stores) I want to keep track of the drugs that are available there, how? when I send drugs (in the table #1) to the pharmacies, I specify from which drug store I sent the medicines, by doing that the amount of medicines from the drug stores should be deducted and be shown next to the drug store name which items are available there.
for table 1 it can be like a monthly track and report, each day, how many pharmacies have been visited, what they ordered (name of medicine and amount, from which drug store)
* the items (medicines) should have a google form like page where I will be able to add new medicines.
I know this has to be more in detail. will give more explanation later.