Discussions

 View Only
  • 1.  Convert a Connected Table to Normal Table

    Posted 12 days ago
    Edited by Geoff Barrenger 12 days ago
    Greetings,

    In order to populate one of the tables in an application, a user is downloading a large CSV (over a million rows) from a database, and loading that CSV into google drive, so that it can be imported into QuickBase daily.   It is on replace mode.

    This means that records are only added/removed once a day - and not on a steady state.  Because of that, there is a delay throughout the day.

    We have an opportunity to have the records updated from this service in the json format - which would reduce manual effort, and give us a near real time view.

    We attempted a test, but the response was:
    {
      "data": [],
      "metadata": {
        "createdRecordIds": [],
        "lineErrors": {
          "1": [
            "You don't have permission to add records to this table."
          ]
        },
        "totalNumberOfRecordsProcessed": 1,
        "unchangedRecordIds": [],
        "updatedRecordIds": []
      }
    }



    Authentication was checked out, and service was able to add records to a non-connected table with the same authentication:

    {
      "data": [],
      "metadata": {
        "createdRecordIds": [
          1558344
        ],
        "totalNumberOfRecordsProcessed": 1,
        "unchangedRecordIds": [],
        "updatedRecordIds": []
      }
    }



    Is it possible to either:
    a) allow for a service to create/remove records into a connected table
    b) disconnect the google drive integration, and turn this into a regular table

    I would like to keep the existing table rather than create another, because there are many formulas, and relations to other tables.

    Hoping someone might be an expert in connected tables!



    ------------------------------
    Geoff Barrenger
    ------------------------------


  • 2.  RE: Convert a Connected Table to Normal Table

    Posted 12 days ago

    There is no way to add records to a Connected Sync Table. 

    but super easy to disconnect.

    Table Settings
    Google Drive Connection and click to disconnect.

    but once disconnected you cannot revert to connected.

    so for sure fully test you alternate method on another normal table first. 


    You can probably Copy the table to test and get all your fields set up.  Go to the Table Home page in old view and use the More... button. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------