Z
Zak
Hi,
I have a few questions: I have a userform in which i would like the user to
be able to enter customer details, the entered information should be stored
in a sheet in the spreadsheet where the form is kept. How do i do this? Does
each textbox in my form have a different code to tell it where to enter the
info?
fields in the form include:
customer name, tel no, address etc
I am also creating a form to allow for appointment bookings.. how can i tell
the system to show a pop up message saying 'double booking, please re-book'
if the user makes a double booking (would this code be in the textbox code?).
Can I also get something in real-time info, whereby it doesnt matter where in
the spreadsheet the user is but if an appointment booking time has come up it
notifies the user in some way (pop-up maybe?).
Also, would it be possible to move all the appointments from 1 sheets to
another sheet once they are all done, i.e. when the user selects the tick box
as ‘done’ the old info (all ‘done’ appointments) would go into a new sheet
called historic appointments..?
Similarly, if the user has a person cancel an appointment, the appointment
info would move to the cancelled appointments sheet..?
Thanks for all your help.
I have a few questions: I have a userform in which i would like the user to
be able to enter customer details, the entered information should be stored
in a sheet in the spreadsheet where the form is kept. How do i do this? Does
each textbox in my form have a different code to tell it where to enter the
info?
fields in the form include:
customer name, tel no, address etc
I am also creating a form to allow for appointment bookings.. how can i tell
the system to show a pop up message saying 'double booking, please re-book'
if the user makes a double booking (would this code be in the textbox code?).
Can I also get something in real-time info, whereby it doesnt matter where in
the spreadsheet the user is but if an appointment booking time has come up it
notifies the user in some way (pop-up maybe?).
Also, would it be possible to move all the appointments from 1 sheets to
another sheet once they are all done, i.e. when the user selects the tick box
as ‘done’ the old info (all ‘done’ appointments) would go into a new sheet
called historic appointments..?
Similarly, if the user has a person cancel an appointment, the appointment
info would move to the cancelled appointments sheet..?
Thanks for all your help.