Form filling without internet connection

Question

Dear All,We have a site survey form, one page of which needs to be completed whilst walking around buildings where internet connection is not always good enough. Other pages can be created and filled in QB later. The "on-site" page is a table with about 10 headers. I am mulling over a few ideas:1. Use paper for the page that should be completed on site and just append it as a PDF to the rest of the form that will be in QB2. Use google sheets and QB sync. In this case I need to work out how to deal with forms completed in google sheets after they are synced with QB - each "on-site" page needs to belong to a separate survey. Also, will I need to convert each google sheet into a CSV document manually?3. Try QB grid edit - it seems that is needs internet connection only when it is saved.I would be grateful for any pointers, thanks in advance.Arkady

mcfneil · Answer

I have never used this service, but found it in a google search:
https://www.surveycto.com/product/index.html

Another options is to have a fillable PDF that can be attached or synced into the app.

Or you can get really fancy and use the google form code and make a mock sheet that then syncs with the internet once connected.
https://developers.google.com/apps-script/reference/forms/

Again, not ideal, but short of creating a separate app that needs to be downloaded to the device, thats about all I can think of.

_anomdiebolt_ · Answer

This is one of the primary use cases for Service Workers using a feature called background sync.

In a nutshell you create a simple custom form in a code page, place all the needed files in a cache so they are available offline and then you define in your Service Worker a background sync event listener that will arrange to automatically submit the form when network connectivity is regained. You can background sync any number of requests (not just one) and they will all magically appear in QuickBase when you regain network access.

bobfaulk · Answer

Do you know anyone that can create that form and connectivity for my app?

_anomdiebolt_ · Answer

This is ridiculously simple to do using Service Workers. Contact me off-world using the information in my profile if you want to pursue this:https://getsatisfaction.com/people/dandiebolt

Forum Discussion

Form filling without internet connection

4 Replies

Related Content

Filter records based on table connection

Connected table not updating when record is changed in the connected database

See you on the Internet... Connect with The Qrew in February!

Connected Table Error

Pipelines - Connected Table Refresh

Recent Discussions

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting