Thanks alot guys
@Ice68 @KnoxVegas
@KnoxVegas
I don't have access to a hosting or a server at the moment, so I'm actually using Google's API's.
I use their forms for Driver signups/elogs however rather than show the default form, I simply copy the html I need such as form_href, input_names etc. I can then style the forms however I want.
When the forms are submitted I simply intercept it and redirect our members to my own landing page, rather than google sending me to theirs. There is a gottcha using this method, and that's form validation. Google does validate the data if you tell it to do so, however if I were to do this, my re-direct intercept wouldn't work, so I have to do a little frontend validation, simple for cosmetic purposes and then we screen all forms that have been submitted and accept/reject them.
Another gottcha is we have certain fields(office-only) that need to be included in the forms, such as status(reject,pending,accept), however we can simply hide them from the viewport. Yes a user can un-hide them and enter their own values but one way we counter that is to color code the fields which can only be done in the cloud by people who have access to the spreadsheets.
We use the spreadsheets more like database tables for storing certain things(cargo's data, city data, user data, elog data) and can then query them using ajax.
Pretty good readup about it here
https://anandexcels.wordpress.com/2013/11/01/query-function-in-google-sheets/
Other than that its just a plain old proboards forum, which I have heavily modified and created some plugins for, so i'm sure you could do something similar with wordpress.
Unfortunately I have to use their slow ass editor in the browser, which makes coding more difficult than it needs to be, difficult to test and so on, it's also very difficult to optimize the frontend because of the workarounds I have to do, but oh well.
Hope that answered your question, cheers