HI I am trying to knock up a quick form to enable me to put together a list I can use to post to ebay. I am using software that makes listing and shipping easier and it allows the use of an excel sheet.

I need the form to start at a specific number when it adds the data to my spreadsheet. How do I go about doing this . Has any one else tried doing this?

Hi Andy,
Do you mean you need it to index to the next high value at each submission?

Thats correct eric.

Basically I have a lot of second hand Radio control parts I need to list. It takes long time to list them all and they all need a unique number as I also take a photo of the item and it needs to be numbered so I send the correct one listed.

I need then in excel as I use the list to populate a shop as well as ebay...some items are just not suitable to sell on ebay but can sit on a shop site for months without costing anything if they dont sell.
When I sell an item on ebay it might also be listed in the shop so I need to set it as sold ASAP, hense the need for unique numbers also lol

I already have 128 items listed in my spread sheet so I would also like to be able to tell my form to use a specific number 00129 and then index to the next high value at each submission.

This is not ultra important as I can just re-number once I have listed a bunch of items. etc etc

I know how to do this in Mysql. How are you generating the values to show in the spreadsheet? I would think you could grab the value out of the csv after submission. Your going to need some php.

I thought it would not be that simple lol.

Everything starts of simple and gets harder the more complex software gets.

For example I use sixbit ebay listing software and can export an excel sheet so I can see what we have sold for example. To find a program capable of allowing me to view that data one record at a time it seems like I have to go for a full blown data base and all the learning curve that entails.

I then decide to use a simple form to add items to that excel sheet so I can import the recently added items to the sheet .... into ebay .....and I find it not really that simple I need to use php which I have never tried to learn lol

Seems like I can do 90% of what I need to achieve and the last 10% is either impossible , costly or time consuming lol