Using a Quickbase field formula to reference data in a google sheets cell
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...)
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...)
