Cannot get column to automtically match on Import from Clipboard

Question

Typically, when you copy and paste from an excel sheet and perform an import, as long as your column heading matches exactly, QuickBase can guess correctly and match which field to import to.

This has worked flawlessly for me, until now. I have one column, that no matter what will not match itself up (not an impossible situation, I simply select the correct column when importing, but sometimes if I am going to fast I miss it, and it would be nice to not worry about it).

The Column name in excel (and indeed the field name in QB) is 'Project ID and MonthYear'. I know the names match because I copy/pasted my field name to my excel sheet header.

However, when I import it always auto selects a field named 'Summary Key Month Manual'. Even if I change the name of this field to 'testing new name', it will always select this particular field in its attempt to match.

One other note: 'Project ID and MonthYear' is a text field and also the key field and merge field in this particular table. Not sure if that has anything to do with it?

Thoughts of what it could be, or how to troubleshoot? Why does it auto select this field to match?

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

MarkShnierYou · Answer

Does that field name get "used up" for a different column. By that I mean the problem may not be with that field, but rather a different field cannot find a match and it randomly grabs your problem field.
ie is he feld for Summary Key Month Manual a perfect match?

Maybe the system is in fact dealing with that column first and cannot find a perfect match and it grabs that [Project ID and MonthYear] field instead. That field is used up it is not available to be used on any other columns.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community