Inputing data into a table via action button.

[kempyboffin]

I want to be able to enter any date of my choosing in the date cell, enter an integer into the input cells and then when I click on the action button have it put the data into a separate table that is arranged in date order from oldest date to newest date.

I dont want it to accept a date that is into the future. Also if data has already been entered on a given date, and then another set of data is entered on the same date, I want the newest set of data to override the last data.

Also I don't want it to allow data to be entered if no date is entered at all.


I need the table to be organised in a way that I can calculate the addition of all the inputs (integers) on a given date, and run certain conditions if a total on a given day is equal to zero.

Also when the button is clicked, I would like it to reset the values in the input fields to 0.


Help would be greatly appreciated as this has had me stumped for quite a while.

Cheers,