We have a cricket club comprising of some friends. I want to simplify how we maintain our attendance cum fine register.
some details are as follows:
Total Number of members: 25 to 28
We play weekly once on Wednesday, from 10 PM to 12 PM.
We take attendance on Monday from 1 PM on our whatsapp group.
The first sixteen who reply yes get to play.
In order to maintain discipline we have formed certain rules and fines:
1. If a person doesnt report before 9.55 PM he has to pay a fine or Rs. 100.
2. If a person says yes and then say no or doesnt turn up, then he has to pay Rs. 300.
3. If the total number of players is less then 16 on ground, the remaining players have to pay a fine of Rs. 100
4. If a person doesnt wear the team t-shirt, he has to pay a fine of Rs. 100
5. If the total number of players playing is less than 16, that group fund will contribute Rs. 1000/- towards total expenses.
6. If a person doesnt come for consecutive 3 weeks, he has to pay a fine of Rs. 1000/-
Requirements:
1. i want to use a google form to take attendance on monday afternoon.
2. another google form is needed to take attendance on the playing day, which is wednesday, this form should also let admin enter details like, late fine, no t-shirt, person who has backed off.
3. the sheet should automatically calculate fine as per above set rules.
4. there should be 2 levels of control, once is admin, second is assitant.
5. admin has full control
6. assitant can issue form on Monday to take the count, and he can then take attendance on Wednesday.
I have given more or less all the details, if you think that a small app can be more efficient than google sheets, you are free to advice.
Thank you
Hello,
Utilizing my expertise in google forms and google sheets and all relevant techniques such as usage of advanced formulas, I will create the tool as described on this job post.
Please revert to discuss further in order to finalize ASAP.
Look forward to work together soon.
Thanks,
Devashish
Hi There,
I have understood your requirement for Google Form development with automation in calculation
With combination of forms and sheets, we can establish 100% automated procedure as you mentioned
I have done many projects in Google Sheet automation
Please contact me for further discussions
Thanks & Regards,
Hello... I read your project description. I am interested in your project. I understand your project very clearly. I am expert in this field.
Send me message and let's discuss further.
Thanks
hi my name is Ganesh i am android developer i had developed many android apps i had seen your requirement. I can give you better results as per your requirement.
Hi there,
I am an experienced Software Engineer with more than three years of experience. I can develop a robust solution for you that can manage your club members, track attendance and charge penalties accordingly. Here's a proposal for you to consider instead of Google App Script:
1. A desktop Electron application that you can install on your computer and it can manage all your data
2. Add, remove and edit member details
3. Gather attendance data from Google Sheets (attendance via Google Form as you wanted)
4. Fine calculation if rules are broken
5. Email notification when user is added and when fines are accrued
The application will also offer an export option that will export the data in excel sheets. Let me know what you think of my proposal. Thanks for your time and consideration.
Hi, I am an expert in Data Entry with good command over eccel and Google sheets. Let's connect for a wonderful experience and hassale free project delivery
Hi,
I can able to do this work. I have very good knowledge in spreadsheet. I understand the the project proposal. If you give me I will finish it in a week
Sir, that is the good question you asked me, If you will give me opportunity to work in your company at this post I think that, by using my skills and knowledge I will play an important role in the upliftment of your company and I will prove it. I am quick learner and very honest with my work surely Sir, one day you will feel proud for appointing me here
Greetings!
For this job, what you will get when you hire me?
1. Fast results
2. Detail-oriented workmanship
3. Excellent organizational skills
4. Highly proficient in e-mail handling, typing, and transcription
5. Strong Microsoft Office skills (Word, Excel, PowerPoint, Outlook)
I'm new here in Freelance but I've done some works outside the platform. Please consider me for this job and you will not regret it. I'm looking forward to working with you. Thanks!
Cheers,
Loren
Hi I have worked with google forms and google sheets for making quiz and feedback and also surfed with all the features over there so I can be sure that I can make your work done properly.
Hello! This seems rather doable, I'd suggest you'd use Google sheets to complete this task as through sheets your data will be far more acsessable, primarily for assistants.
In my free time I do things of very similar topics! Primarily in google sheet data sheets focused around large groups and collecting data. This will not be too difficult.
Will you primarily be using a phone or computer for data management? I can make the sheet further availible for whichever you would prefer.