Connected Table Error--Unknown Column

  • 0
  • 2
  • Question
  • Updated 6 months ago
  • Answered
Is there a known fix for this error? The error was: Unknown columns: [[[11]]]
How do you determine which column(s) are unknown?
Photo of John Romno

John Romno

  • 120 Points 100 badge 2x thumb

Posted 6 months ago

  • 0
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
This is usually because something was deleted.

Check for field ID 11 in the table.  And then check your source data to find what used to be there. 
Photo of Quinten

Quinten

  • 732 Points 500 badge 2x thumb
I am receiving the same error however it is [[[1085]]]. The source data does not contain this field ID nor does the connected table. What should I do in this case?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Is there s field ID if that number 1085 in the target table? Is it giving you s clue as to which field is missing from the source.

If you can figure out which field it is upset about, you need to go into the target table and delete that field as there is no source for it.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
This also can happen if the column header in your csv file has changed or doesn't exist.  The sync is VERY particular on naming of column headers.
Photo of Quinten

Quinten

  • 732 Points 500 badge 2x thumb
There is no field ID in either the source or target table, that is why I am very confused. Since the connected table only has 70 fields, I cross checked them with the source table and found that one field could be the issue. When I go into the properties of the field, it is unable to gather the information from the source table. Meaning that, it continuously spins to retrieve the field name from the source table and can't find it. Do you think this is the field that is causing the issue?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
... probably.  Try disconnecting it and see if that solves the problem.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
I've seen this error when there is an extra comma or tab in the csv file.  Try re-uploading a file from the "done folder" that previously worked properly.  Then you might be able to identify the missing field.