We upload data from our in-house SQL database to a website with information used to inspect various plants. I want my inspector to be able to go to that website prior to visiting the plant and download the inspection ticket with various fields prefilled from the database. (Example: Company name, number, contact name, phone number, address, specific plant information he/she needs to know prior to visiting the plant, etc.) This is easy as long as the inspector has a network connection. The problem comes in that many plants do not have Wi-Fi connectivity so the inspector needs to be able to download the inspection sheet prior to getting there. He would then need to SAVE it on his tablet, phone or laptop and then bring the form up while in the plant and offline and fill in the details of his visit (who he saw, how much time he spent, what issues that he might have seen,etc.). He/she needs to be able to once again save the data with the form so when the inspector gets back to a Wi-Fi connection he can email the form back to our office.
Is there a way to implement a form with data entered from a database, go off-line and enter more information, save it all and then go back online and email the data?