I have been working with an excel speadsheet to track moving items from 1 remote location to another location. This is a 2 person task, basically, the person at 1 location, notates the spreadsheet when they ship an item, and the second person notates the spreadsheet when they receive the item. This process works fine, however, being the ever perfectionist I am, I am wondering if there is a way to web-erize this process. :)
Basically what I would like to do if create a table in html, and populate this table with rows for every week in the year. Now the items that are shipped are based on a specific date, so their would be a column notated that date. Then there would be several columns that would have user input. (where the 2 workers update the date sent, and date received.) - There would also be 1 additional column to indicate any comments for the shipment.
My 1st question - Is there a way to do this using php, without having to create a database, or is it possible to use something like jquery or ajax to fill each row as the change is made, using a button as a confirmation/acknowledgmen
t? if not - does anyone have any tips or suggestions on how to accomplish this?
2nd Question - Is it possible that when a row is updated, this script could send a quick generated email letting the other party know that the item has been acknowledged?
3rd Question - Would this script be able to archive data saved at the end of the year?
So - These questions are obviously progressive in nature.
Thank you all for your time, and help!