Forum Discussion

GeoffBarrenger's avatar
GeoffBarrenger
Qrew Captain
2 years ago

Convert a Connected Table to Normal Table

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
------------------------------
    • ben_simon's avatar
      ben_simon
      Community Manager

      Glad to hear it! First ones through the wall always get bloody. Thanks for helping us break in the new system, we'll iron out all the issues and get us back to having the experience people in The Qrew deserve. Thanks Geoff.

  • ben_simon's avatar
    ben_simon
    Community Manager

    Thanks for sharing the above screenshots Geoff. I'll have to work with the vendor to figure out why that's appearing for your account. In the interim, I've made another adjustment to your role. If this STILL doesn't work, than I'll have to have the vendor take a deeper look at your profile specifically.

  • Hi MarkShnier__You - I'm responding on an old message because I can't create new posts!! I sent an email to community@quickbase.com  but am hoping you might be able to help out - any ideas??  haven't had a question I couldn't have answered without searching the forums until now - so I guess when the replatform of the message boards happened I lost the ability to create posts!  thank you! geoff.barrenger@ralphlauren.com

    • ben_simon's avatar
      ben_simon
      Community Manager

      Hey Geoff, I can help here. Calendly - Ben Simon Let's set up a time for us to troubleshoot this together. You should be able to create new posts without issue. So let's just review together on a quick call.

      • ben_simon's avatar
        ben_simon
        Community Manager

        Hey Geoff, I made an adjustment on your setup. Can you see if you can start a new post now? 

  • 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
    ------------------------------