"Attempting to add a non-unique value to a field marked "unique" error on a QB Connected Table
My connected table has been erroring out on the hourly table refreshes due to the following error: The error was: Trying to add a non-unique value to a field marked unique - Your import data has duplicate values for the following unique fields Field name: " I was able to verify that the field in question does not have any duplicate values in both the source and destination table. In addition, the destination table already has the records in question within the table, so if anything, the records should be updated but there shouldn't be an error on the refresh. Has anyone else dealt with a similar issue? Not certain of what next steps to try aside from reaching out to QB Support. ------------------------------ Niraj Shah ------------------------------
How to convert a connected table to Quick Base Table
I have a table that is a combination of a Connected CSV file and Quick Base created editable fields. Because of this mix I am having problems keep data synchronized when one of my "Key Fields" changes. Was wonder if there is quick trick to convert the data into a Quick Base Table and remove the connection? ------------------------------ Bradford Fullerton ------------------------------
Sync Vs Relationships
There is a great blog here about the pros and cons of Cross App relationships, vs sync, vs table imports. Sharing Data Across Quick Base Apps: Part 1 Cross App Relationships, Table to Table Imports, and Sync I am aware that you want to avoid having 15 apps, somehow all intertwined with cross app relationships. I am trying to better understand the why. It seems that cross app relationships will create dependencies, so that all apps basically travel together and are forced to be run by a single QB server. Is that basically the explanation? For example, if I have 4 apps intertwined with cross app relationships, and then a 5th app has a single cross app relationship with one of those 4 apps, did I just lock that 5th app in with the rest of those? Not sure if someone is able to give a brief explanations in mildly technical and mildly layman's terms? ------------------------------ Michael Tamoush ------------------------------
Sync Table Question
I have a table that holds session tokens for a third party app. This third party app will now be used with another app I administer. Would it be a good idea to move the current table to the app I use for data transfers and create a sync table in the two apps that will need access to the session token rather than creating cross app relationships? I look forward to hearing your thoughts ------------------------------ Paul Peterson ------------------------------
Can't import fields
I've looked through many posts and can't find anything similar. I have a table that has eleven fields connected through Google Drive, one of which is the key field. I want to import three fields that are not connected but will update the related "unit number" but I keep getting the error in the snippet. I tried it on another table that is also connected and it worked fine. I am the app admin as also shown. Any suggestions? ------------------------------ Steve Pearson ------------------------------Automate Table CSV Export To SFTP Location
I am looking for a solution where I can export a table in a CSV format in some type of frequency (e.g. every 24 hours, or after x action takes place). What I'm trying to achieve is basically the same as Quickbase Sync, but exporting a file to a specified location rather than importing a file from a location. I can write an API to download the file locally, but it would be preferred if there's an option of doing the above without any manual intervention.
How to change connected file name in Dropbox folder
Please find the following screen snapshot of connection history. After I built a connected table connecting to a file "Boppy2.csv". It was successful. Then when I was trying to add another connection, the connected file name was suddenly changed to "BHLicensing Input2.csv", and to have "Refresh failure" all the time. How to change the connected file back to "Boppy2.csv"?
Creating multiple records in Table X from a QB Sync Table
My QB Sync table has a patient primary key and a multi-select field (although QB imports it as a text field) with hundreds of possible symptom values. I would like to make this into a join table between patients and symptoms with each record being one instance of a patient with that specific symptom. Is there any way to do this natively with QB? I can script it, but the organization I work with is not very technical, so it would be difficult to maintain. Much easier to maintain in a low code platform like QB. ------------------------------ Solace Sonder ------------------------------
