"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 ------------------------------
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 ------------------------------
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 ------------------------------QuickBase Sync: You don't have permission to import data into a restricted field.
I am using Quick Base Sync on one of my tables (Contracts) and it recently started displaying this error:The error was: You don't have permission to import data into a restricted field. It's a Quick Base Sync SFTP. The SFTP credentials appear to be okay when testing it.I checked the permissions of each individual field and of the table and there aren't any restrictions that I'm aware of. I have one role "Everyone on the Internet", that I thought might be an issue, but even that has full access to this table. The Quick Base Sync history provides a link to their common errors, but this one is not listed. I wasn't sure if anyone encountered this particular error and where else to look in the settings. ------------------------------ Quincy Adam ------------------------------
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 ------------------------------Single Sign On in QuickBase
Has anyone implemented SSO with QuickBase? I want to know how it would work, when quickbase doesn't need you to enter a password anymore. What password would you use? How do you integrate with QuNect, which needs a password? How do you run the API_Authenticate API Call in custom scripts? If you opened a quickbase link from your email outside of your work environment, what would happen?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.
Dashboard Widget Page (manually refresh a connected table)
I have a URL field ("javascript:$.post('https://myrealm.quickbase.com/qb/sync/refreshTasks?replicationID=xxxxx')") to manually refresh a connected table, but I am trying to set a code page that allows me to do the same in dashboards, however, I don't know how to build the page code, is anybody has that syntaxis page code to share with me, or help me to set that much appreciate that. Edson ------------------------------ Data (Administrator) ------------------------------
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 ------------------------------
