I have a quote system for tractors built using google sheets, I am looking for the concept to be turned into a tablet friendly web based application. The page is essentially nothing more then a form with options that are dependent on other form fields.
So the user would select a tractor from a list and be brought to the options page which lists all the options available for that tractor with check boxes. The quote should be given an number and once all the required options are selected the final quote is formatted so it prints on an 8.5X11 sheet of paper with details about the tractor, photos, a itemized quote and finance estimates. The quote should be saved in a database and be retrievable by the number, editable, and reprint able.
The whole system should consist of about 4 pages, The first page should be a list of the available tractors with touch friendly buttons. I will draw up a sample of what I want. These should be pulled from the database as they will need to be updated from time to time. There should be headers with each series and each tractor under that series under it. Probably two tables, one for series, and one for models.
Once I select one of the tractors the next screen is a pretty simple form that looks very similar to the sheet I have now, The first section should show the tractor and its price, then a list of implements, which are specific to the tractor selected. The Implements table will include a list of tractors that the implement fits. The implements are selected by checking the box and the price and total quote amount should update as boxes are checked.
Under the Implements would be accessories, these are items that are universal and not specific to a tractor. These will have a parent and item setup, so the line would say "Finish Mower" and if you check it there is a drop down where you can select 48" 60" 72" etc. This again would be two tables, one for the parent item, and the table of all the specific items with all the details which would link to the Parent.
The next screen would ask for customer information, Name, Address, Phone, and e-mail. With an option to skip which would just assign a default anonymous customer. The last screen would be the final quote which needs to be formatted to print cleanly on paper. I have an example from another quote system for this page, its pretty basic.
The First page should have an option to open a previous quote by entering the quote number. This will be accessed by multiple people at the same time so it will need to be able to handle that, and I want some basic security, but I don't want to have to login over and over.
This is the sheet that this will be based on: [login to view URL]
66 freelancere byder i gennemsnit $2107 timen for dette job
I am ready to convert the 4 pages into web based application, Will it be accessible publicly? Any password protection needed? Can you share the sheet?