Using a Quickbase field formula to reference data in a google sheets cell

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
  • (Edited)
I have a Google Sheets spreadsheet that has a specific cell that contains a number that is updated regularly. Is it possible in Quickbase to build a formula in a field that can pull that data from that Google Sheets field?
Notes:
1) It shouldn’t be an issue to get the URL of the cell within the Google Sheets file. 2) the numerical contents of the Google Sheets cell change frequently so the Quickbase field would need to reference that URL and update on refresh. 3) Guessing i’d need to use something like ToNumber as well, so that I could use that numerical data that’s pulled from GSheets in other Quickbase formulas that would perform calculations with it?

For example.. in an open, published Google Sheets spreadsheet, cell D3 has a string in it. The URL is https://docs.google.com/spreadsheets/d/e/2PACX-1vTgvViM81ui6k0ZvxI09oZR89PT3ecAhmPRsDjG-QmWY-A_ph0XB... 
(which only returns the data in that one cell, D3)
So the question is whether it's possible to reference this cell's data in a Quickbase formula?
Something along the lines of a formula:
ToNumber("https://docs.google.com/spreadsheets/d/e/2PACX-1vTgvViM81ui6k0ZvxI09oZR89PT3ecAhmPRsDjG-QmWY-A_ph0XB...)
Photo of Sam

Sam

  • 90 Points 75 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 28,144 Points 20k badge 2x thumb
I was able to query a google spreadsheet cross domain as indicated in the following screenshot of manually entering the script in the console::