Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoLet's start with low tech.
Can you just make this URL formula button which will land the user on the native import menu?
URLRoot() & "db/" & [_DBID_ of the table name from advanced properties]
& "?a=ImportExport&preselect=optImportFromFile"
The user will then navigate to where the file is stored on their computer or network drive.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Can you just make this URL formula button which will land the user on the native import menu?
URLRoot() & "db/" & [_DBID_ of the table name from advanced properties]
& "?a=ImportExport&preselect=optImportFromFile"
The user will then navigate to where the file is stored on their computer or network drive.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- MichaelMahon3 years agoQrew TraineeThat's going to be my last resort. The less navigation I can have I can have the user do is the ultimate goal.
Is it possible using that formula to have the fields pre filled and read only when they land on the import screen? That at least keeps them from choosing other than the intended file?
------------------------------
Michael Mahon
------------------------------- MarkShnier__You3 years ago
Qrew Legend
It is hard to say that something is absolutely impossible but I've never heard of anybody being able to pre-populate the file path.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- MikeTamoush3 years agoQrew CommanderMark,
I was unaware of the import from file. Does this actually map fields from the import?
------------------------------
Mike Tamoush
------------------------------- MarkShnier__You3 years ago
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
------------------------------- MikeTamoush3 years agoQrew CommanderI 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
------------------------------