Create a nice looking form in the front end (visible to anyone in wordpress) where a user can input information. No need to allow/change user permissions.
1. Create a form with about 20 input fields. Fields are mostly text, with some dates, radio buttons and dropdowns (based on the respective column)
2. Once this data is submitted, it goes to the MySQL database where it is saved
3. All data that is in table needs to be shown to users in a table format in wordpress webpage (the wordpress theme is already done, just need basic css so the table looks nice). The table should be able to be organized when clicking the header column and searchable.
4. Form would be part of a WordPress site but all code should be native PHP/MySQL
The form should be editable by admin (or given instructions to us on how to edit) and the mysql table should be a new table in Wordpress.
I am attaching an excel sheet. Only the first and third sheets have the information to be used. Includes test data.
The third tab are the variables for some of the info in the first sheet
For sheet #1 cell H1, for example, that would be a drop down menu with the variables that are in sheet #3, A2.
Note: The second sheet can be Ignored for now, nothing to be done with that sheet.
There is more work to be done if your bid is a good price and the work is done correctly.