Ditutup

data entry and management system with google calendar and spreadsheets

I run a small guitar studio with three teachers. We currently use google Calendar to keep track of our lessons and google docs to keep track of our payments. We are looking for someone to setup a few spreadsheets and app scripts to pull information from the Calendar into a weekly report spreadsheet, where each teacher can view the lessons they have coming up this week, and as they occur record payments, lesson notes, and other data. That data then needs to be collected into a monthly ledger spreadsheet to keep track of the payments, and also sent to each student's individual sheet keeping track of their lesson notes and payments also. Finally we need a running tally of where someone is in their lessons to be sent back to the calendar where we can reference it easily. this will be a number 1/2, 3/4 based on which lesson of their prepaid block they are on.

I believe all this to be possible using an appscript to pull data from the calendar to a spreadsheet, then using importrange etc. to send it around to other spreadsheets, and then finally another appscript to send it back to the calendar.

So we would like to have the following files:

Weekly Reports for each teacher collecting: Student Name, Time, Date, Notes, Attended, Length, Block, Paid, Method, Payment Notes. The names, times and dates should be populated automatically from the calendar, the teacher then fills out the rest of the data.

Student Database with a file for each student containing: Name, Address, Phone, Email, Birthdate and then a running list of lesson notes and a payment history (all of which can be compiled from the weekly reports).

Payment Ledger containing: Name of Payee, Name of Student, Date, Amount, Method, Payment Notes, Name of Teacher its coming from. This too should be gathered from the weekly reports.

When people pay for their block of 4 lessons, we need the system to keep track of which lesson of the 4 they're on and push it back to the calendar for easy reference, so that past events show up as johnny 3/4 etc.

let me know if you have any questions.

Thanks!

Kemahiran: Enjin App Google

Lihat lebih lanjut: google docs weekly calendar, calendar app data entry, you pull and pay, using google spreadsheet, track 1 data, teachers pay teachers, scripts for google spreadsheets, pull and pay, need of tally, google spreadsheets scripts, google scripts spreadsheet, google docs scripts, google. docs, docs. google, data entry management system, appscript google, appscript, app engine email, where is google docs, teachers email address, spreadsheet google, google spreadsheet scripts, google google docs, google docs is, docs.google.docs

Tentang Majikan:
( 0 ulasan ) United States

ID Projek: #4050046

4 freelancers are bidding on average $500 for this job

Viqtor

Hi, can help.

$250 USD dalam 7 hari
(6 Ulasan)
4.5
norberto108vw

Hi, please take a look at this url: marcaconsulta.appspot.com. I seems to be close to what you want. It is missing the docs docs integration. It is still under development, if you have any difficult to access the ap Lagi

$300 USD dalam 7 hari
(0 Ulasan)
0.0
wannadream

I can help you to pull out the data and help you to build a new customized system.

$700 USD dalam 7 hari
(0 Ulasan)
0.0
GeorgeKazi

Hi! Please see your inbox

$750 USD dalam 14 hari
(0 Ulasan)
2.8