Create a button with a default file name/path
Our company has Pipelines locked down to be insanely restrictive so I'm having to be a little creative here. RIght now I am building an app for a non-technical audience where they need the ability to ...
Forum Discussion
Mark,
I was unaware of the import from file. Does this actually map fields from the import?
------------------------------
Mike Tamoush
------------------------------
I was unaware of the import from file. Does this actually map fields from the import?
------------------------------
Mike Tamoush
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legend@Mike Tamoush
Really? you have never imported an excel xlsx sheet or CSV file into Quickbase? You're just navigate to your file and you need to match up which columns in the the spreadsheet match up to your fields and QuickBase.
If they are going to be repetitive imports than either you need to contrive that the column headings in excel exactly match your field names or failing that if it's not possible for some reason there is another technique to import the Excel sheet as he is into a scratch file table so that the field names will match up perfectly and then press a button to import from the scratch file table over to your real table.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Really? you have never imported an excel xlsx sheet or CSV file into Quickbase? You're just navigate to your file and you need to match up which columns in the the spreadsheet match up to your fields and QuickBase.
If they are going to be repetitive imports than either you need to contrive that the column headings in excel exactly match your field names or failing that if it's not possible for some reason there is another technique to import the Excel sheet as he is into a scratch file table so that the field names will match up perfectly and then press a button to import from the scratch file table over to your real table.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- I realize I read your response wrong. I skipped over 'will land your user on the native import menu.'
I've of course used it 100's of times, but actually this could be helpful, as I didn't realize I could land a user on that menu. I thought you had to have admin rights to import.
------------------------------
Mike Tamoush
------------------------------