Tamamlanmış

Customer registration and attendance tracker using macros in Google sheets.

I run fitness classes. I want to track when customers come to class and be able to note if they haven't attended for a while.

I know that there are on line solutions, but these are all far too complex

I would like the solution to be in Google sheets, although please recommend if it can be done in another product.

While all the functionality can be done in sheets, i want it to be done with macros in a way that looks good.

There are three parts to this I require:

1) a process which records new customers along with their email addresses and mobile numbers.

2) a record attendance macro. Which first asks the instructor to record the class name and date, then records the customer names. I want the customers to be able to type their name, then to select it from a drop down. Only existing customers can be recorded. New ones need to be added prior to signing in.

3) a macro which sorts the customers by attendance and produces a list highlighting those that haven't been for a period of time ( say greater than 3 weeks but less than 8 weeks). This is exported as a text string to be inserted into my email .

I think this is all. I would be grateful to hear your ideas and comments.

Thanks

Mat

Beceriler: Excel, Visual Basic, PHP, Veri İşleme, Yazılım Mimarisi

Daha fazlasını gör: add extra fields customer registration oscommerce contribution, activity log user macros excel sheets, employee attendance system using, google sheets attendance template, how to take attendance using google sheets, google sheets 2018, employee attendance tracker google sheets, where's google sheets, google sheets time tracking, google sheet link, google form clock in and out, chat consultants online using msn google skype, using tcadmin google apps email, simple customer registration form php, software company customer registration form, creating expense tracker using j2me netbeans, steps creating expense tracker using j2me netbeans, steps expense tracker using j2me netbeans, develop time attendance sysm using vbnet, sample registration pages available using ajax

İşveren Hakkında:
( 3 değerlendirme ) Seascale, United Kingdom

Proje NO: #21071862

Seçilen:

NishchayTech

GOOGLE SHEETS IS THE BEST TOOL FOR YOUR PARTICULAR USE CASE. ATTENDANCE SYSTEM and NEW CUSTOMER REGISTRATION with GOOGLE FORMS can be made. I have built MANY similar Google Sheets with many macros. I can build yours to Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 100%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(61 Değerlendirme)
5.7

Bu iş için 9 freelancer ortalamada £122 teklif veriyor

StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on Daha Fazla

£150 GBP in 3 gün içinde
(39 Değerlendirme)
6.4
egtechsolution2

i just ready your project description cearfully . in this case i can suggest you to build your own plartfrom to handel this . i can also develop the system what you need. we also can build this project accroding you . Daha Fazla

£90 GBP in 9 gün içinde
(23 Değerlendirme)
4.9
veinjobinfo

Hello, This is Sanjay, Web Application developer with pretty good experience in industry. I have been in this industry from 5+ years and such jobs are my daily practice.I am assure you that we have a well experienced Daha Fazla

£135 GBP in 15 gün içinde
(22 Değerlendirme)
4.4
zeligztech

Hi there, I see you are looking for an experienced Web developer to design a website. I am an experienced developer and can provide you a quality website as per your requirement. I am a full stack web developer hav Daha Fazla

£150 GBP in 7 gün içinde
(1 Yorum)
2.0
partgreat801

⭐LOW RATE! HIGH QUALITY&SPEED!⭐ I read your project . Your project is very interesting. I have ever been similar project with your project. I have 8+ years of experience working with Web development and design like :(S Daha Fazla

£135 GBP in 3 gün içinde
(1 Yorum)
2.0
Krazzaq47

Hi I have read your requirements and wants to discuss it with you. For more information please ping me. Regards

£135 GBP in 7 gün içinde
(3 Değerlendirme)
2.0
zuberypima

Hi i hope am the best choice for this project because of my experience and hard working , so please let me in. I can offer you a discount because of give this [login to view URL] me for more negotiations . Thank you

£55 GBP in 5 gün içinde
(0 Değerlendirme)
0.0
zubair4848

Hi there I am a professional electrical power engineer with experience in Project and personnel management and i am proficient in different macros for attendance and payroll and this project of yours is related to area Daha Fazla

£150 GBP in 3 gün içinde
(0 Değerlendirme)
0.0