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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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
Photo of Arkady

Arkady

  • 112 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
VisiApps has an off line solution.
Photo of Arkady

Arkady

  • 112 Points 100 badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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.
(Edited)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,402 Points 20k badge 2x thumb
>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...