Creative way for users to import data?

So depends how much work you want to do. When I have clients who are routinely Importing data from another system where the data needs to be transformed in some way either with filters or simply to control the mapping, I have done it using a table in QuickBase where they can enter their data.  Case they would paste the raw data in from their spreadsheet external system and I am assuming that all the spreadsheets are of the same format. They would have to choose a parent record from a drop-down list. And then they would push a button and it would run an API_RunImport  to copy these over to the child table attached to the correct parent.

If the traffic for those imports was going to be quite infrequent then Import table could be on a single record because the users wouldn't be bumping into each other. But if there's too much chance that the users are going to trip over each other than it could be a table of users so that each user has their own record to paste into.

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