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
MarkShnier__You
Qrew Legend
Qrew LegendLet'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
------------------------------
- That'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__YouIt 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
------------------------------
- Mark,
I was unaware of the import from file. Does this actually map fields from the import?
------------------------------
Mike Tamoush
------------------------------- MarkShnier__You@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
------------------------------- 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
------------------------------
