Forum Discussion

ArkadyGranik's avatar
ArkadyGranik
Qrew Cadet
8 years ago

Launch Google Sheets from QB and attach/link document to the record

I am trying to find a workaround for filling a form when there is no internet connection. One idea is to launch an existing GoogleSheet document, save it as a New Document and then either leave it an dedicated folder for syncing later or re-attach it to a record from which it was launched.

Does anyone have a view on whether this might work or maybe can suggest another way?

Arkady
  • Thank you.

    If I wanted to get the info back into QB, it can be opened in a spreadsheet and for copying and pasting in grid edit?

    I know of linking QB to CSV documents, but it seems quite rigid. People make errors in off-line forms, it would be good to amend field values or add records after importing them into QB. Is it possible to combine linking QB to CSV with this?

    Arkady
  • Maybe you should just have your users create a spreadsheet either with Excel or Google sheets and just import the spreadsheet manually. Then they will be able to grid edit in Quickbase.


    You are correct that if you use sync then you cannot directly edit your data once it's in Quickbase.
  • >I am trying to find a workaround for filling a form when there is no internet connection.

    This can be easily accomplished with a Service Worker using a sync event. Read here:

    https://wicg.github.io/BackgroundSync/spec/

    I have done this with QuickBase myself and it works flawlessly but you have to create your own form as QuickBase's native forms need an active network connection to work properly. When you create your own form and submit it while offline you may not be able to implement some features such as distinct fields as you do not have the ability to query QuickBase for existing field values when offline.

    We are very close to the release of Service Worker support in Microsoft's Edge browser but for the life of me I can't get a release date or any confirmed info our of my local Microsoft rep. More info will probably be available September 13 at this event:

    Save the date: Microsoft Edge Web Summit 2017 comes to Seattle on September 13th
    "You�ll learn how to use exciting new web platform features like Service Worker ..."
    https://blogs.windows.com/msedgedev/2017/06/20/save-the-date-edge-web-summit-2017-september-13th-sea...