Discussions

Expand all | Collapse all

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

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

     
    Posted 01-31-2018 22:19
    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...)


  • 2.  RE: Using a Quickbase field formula to reference data in a google sheets cell

    Posted 02-01-2018 12:12
    I was able to query a google spreadsheet cross domain as indicated in the following screenshot of manually entering the script in the console::