Skip to main content
Participant
November 18, 2007
Question

I don't know what I'm doing, but I know what I want

  • November 18, 2007
  • 3 replies
  • 567 views


I do wish that I could post a picture with this, so that it would be easier to understand. Please forgive my ignorance, I've never thought forms could be so complicated...

I have this scheduling form in mind. There are two columns and 30 rows: Date, checkbox. If an individual chooses to do an event for a particular day, they check a box. Their name is inputed in a text box and once the form is submitted, the checked box is replaced with the person's name.

I've built the table, all I need is to run some kind of script. I appreciate any help

This topic has been closed for replies.

3 replies

Inspiring
November 18, 2007
quote:

Originally posted by: noo-bee


I do wish that I could post a picture with this, so that it would be easier to understand. Please forgive my ignorance, I've never thought forms could be so complicated...

I have this scheduling form in mind. There are two columns and 30 rows: Date, checkbox. If an individual chooses to do an event for a particular day, they check a box. Their name is inputed in a text box and once the form is submitted, the checked box is replaced with the person's name.

I've built the table, all I need is to run some kind of script. I appreciate any help



You don't need their name in a check box unless you want to allow them to change it. Give all your checkboxes the same name. Then on your action page you will have a list of dates to work with.
noo-beeAuthor
Participant
November 18, 2007
Dan,

Can you give me an example. I don't understand your solution. Thanks
Inspiring
November 18, 2007
quote:

Originally posted by: noo-bee
Dan,

Can you give me an example. I don't understand your solution. Thanks

Create a form with two text boxes having the same name but different values. Check them both and submit the form. Do a cfdump of your form.
November 18, 2007
Consider naming the check boxes and text box uniquely. For example, the text boxes could be named name1, name2, name3, etc, and the checkboxes ck1, ck2, ck3, etc. This makes it easy to validate, and hooks up the check boxes with the appropriate name.
Inspiring
November 18, 2007
You can always upload an image to a free hosting service like www.imageshack.us, then post a link here.

Do you just want to display the name next to the selected dates, insert them into a db, ...?

noo-beeAuthor
Participant
November 18, 2007
Thank you so much for the quick responses. Here's a page to view the form: http://blackicerugby.com/xmas%20schedule.html

The purpose of this form is to help set up a schedule for my workers. They could simply log online and choose a date, type in their name and once submitted, their name will populate in the box where the checkbox is located. The following two pages shows the process visually:
1. http://blackicerugby.com/xmas%20schedule1.html
2. http://blackicerugby.com/xmas%20schedule2.html

Really, I have the process in my head, but I don't know how to write in script or whatever language I would need.
I would hate to complicate it by asking, "How can I put an option (administrator access only) to change the schedule, if I need to (i.e. add or remove a worker from the spreadsheet)?

cheers