Forum Discussion

Qrew Cadet

4 years ago

"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 d...

Quickbase Sync

MichaelTamoush

Qrew Captain

Is the same field unique in both the origin table and the synced table? Or is the unique field only in the synced table?

If only in the synced table, check to see if there are multiple blank entries that are trying to sync. A duplicate blank will register as non-unique.

------------------------------
Mike Tamoush
------------------------------

NirajShah4

Qrew Cadet

4 years ago

Hi Mike,

Yes. The same field is unique and required in both the origin and synced table.

I submitted a support ticket to QB and they couldn't figure out the issue either and are escalating the ticket.

ᐧ