Copy and Paste to a new table matches fields


#1

For better or for worse, I often have information in one table that I need to transfer to another table. Usually, the two tables have some fields in common, but some unique fields; which means Ctrl-C, Ctrl-V does a column-wise copy of the date, when, in fact, the columns usually don’t match. What does match, however, are the field names. “First Name” = “First Name”, “Last Name” = “Last Name”, etc.

I’d love to have an optional copy that ignores columns and matches field names when copying the data. Any fields that don’t match don’t get copied.


#2

yup this would be really useful. I’ve found if the columns are in a different order in another database that messes around with the copy/paste as well - so being able to select a field to match on e.g. first name, would be really useful.


#3

If the fields are the same between different tables, the “proper” thing to do would be to use a single table and have views that are filtered to different sets of records. That said, our view switching UI currently leaves something to be desired, so we understand why you sometimes want to put similar data in different tables.

Interesting idea about providing a way to match columns up when pasting into a different table though. This could actually be really useful for importing data as well, as well as pasting from an external source.