9 Replies - 1006 Views - Last Post: 22 July 2010 - 06:03 AM

#1 ninechances  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 188
  • Joined: 08-February 10

Schedule Saving

Posted 21 July 2010 - 03:39 PM

I'm designing an online schedule (weekly) for a company and had a few questions.

I have a table that contains the days of the week across the top and everyones name (in drop down boxes) under each day so that a manager can choose someones name to make schedule changes. When the manager is done, I want them to be able to save the entire schedule as is. How can I achieve this? I don't want code. I just want suggestions.
Is This A Good Question/Topic? 0
  • +

Replies To: Schedule Saving

#2 macosxnerd101  Icon User is online

  • Self-Trained Economist
  • member icon




Reputation: 10807
  • View blog
  • Posts: 40,288
  • Joined: 27-December 08

Re: Schedule Saving

Posted 21 July 2010 - 04:01 PM

Moved to Web Development. :)

You'll probably want to use a server-side language like PHP, ASP, or ColdFusion to insert the data into a database of some sort, so you'll want to look up some SQL as well.
Was This Post Helpful? 0
  • +
  • -

#3 ninechances  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 188
  • Joined: 08-February 10

Re: Schedule Saving

Posted 21 July 2010 - 04:59 PM

so all the names should be inserted into the database first? Seems kinda lame seeing as how I would have to add someone to the DB each time someone new was hired.
Was This Post Helpful? 0
  • +
  • -

#4 macosxnerd101  Icon User is online

  • Self-Trained Economist
  • member icon




Reputation: 10807
  • View blog
  • Posts: 40,288
  • Joined: 27-December 08

Re: Schedule Saving

Posted 21 July 2010 - 05:02 PM

Actually, that's exactly how databases work, be it a SQL Database, an XML file, or a text file. Look, you're storing those people's information on the HTML file anyways. The benefit of computers is that you get to automate the processing.
Was This Post Helpful? 0
  • +
  • -

#5 ninechances  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 188
  • Joined: 08-February 10

Re: Schedule Saving

Posted 21 July 2010 - 05:25 PM

So I guess I could have an option for the managers to just add/delete someone's name to/from the database on the HTML file so I don't have to worry about it?

and then it would automatically update the drop-down menu's?

This post has been edited by ninechances: 21 July 2010 - 05:26 PM

Was This Post Helpful? 0
  • +
  • -

#6 macosxnerd101  Icon User is online

  • Self-Trained Economist
  • member icon




Reputation: 10807
  • View blog
  • Posts: 40,288
  • Joined: 27-December 08

Re: Schedule Saving

Posted 21 July 2010 - 05:36 PM

HTML is nothing more than a tool to display data. The form elements can hold the values, that tools like Javascript (on the client side) as well as server-side languages like the above mentioned can process.

So you could have a prompt to delete managers, but the list would have to be dynamically created from a database query which a server-side language would be responsible for. The server-side language would also be responsible for recieving the updates and processing them.

As for an instantaneous update, there are a few ways to do that. Take a look into technologies like AJAX and jQuery, which are both Javascript tools.
Was This Post Helpful? 0
  • +
  • -

#7 ninechances  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 188
  • Joined: 08-February 10

Re: Schedule Saving

Posted 21 July 2010 - 06:19 PM

an instantaneous update of the DB or the page?
Was This Post Helpful? 0
  • +
  • -

#8 macosxnerd101  Icon User is online

  • Self-Trained Economist
  • member icon




Reputation: 10807
  • View blog
  • Posts: 40,288
  • Joined: 27-December 08

Re: Schedule Saving

Posted 21 July 2010 - 06:21 PM

The page, sorry. :) I was talking about the drop-down menu being updated.
Was This Post Helpful? 0
  • +
  • -

#9 ninechances  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 188
  • Joined: 08-February 10

Re: Schedule Saving

Posted 21 July 2010 - 06:32 PM

right. kind of like if you had 2 drop-downs on a website - one with a state and the other was blank, you choose a state and the other drop-down populates with the cities.

- OR - in my case. you wouldn't be able to just select the same employee to work a morning shift more than once - assuming 4 total people could be scheduled for a morning shift.
Was This Post Helpful? 0
  • +
  • -

#10 macosxnerd101  Icon User is online

  • Self-Trained Economist
  • member icon




Reputation: 10807
  • View blog
  • Posts: 40,288
  • Joined: 27-December 08

Re: Schedule Saving

Posted 22 July 2010 - 06:03 AM

You'll need some client side assistance with something like Javascript if you don't want to do a complete page reload or redirect.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1