Awesome - thanks Mark! I was hopeful you would see this and provide assistance, and here you are.
I really appreciate all you do for this community.
Qrew LegendThe use of a temporary staging table is a great technique for importing from 3rd party systems where you have limited control over the source format, since you can just import the raw source file "as is" and then add any extra formula columns as needed and also you can add filters in the saved T2T import if not all records are valid to be imported. Also, of course, the source field names may not be what you want them to be in the Quickbase app, so the saved T2T settings let you do the field mapping. The scratchpad table will have field names identical to the raw CSV/Excel source so that they import perfectly aligned into the Scratchpad table. In fact the easiest way to create all the fields in the scratchpad table is to import a source CSV/ Excel file into an empty table with no fields created and let Quickbase create all those fields for you.
