Skip to main content
Question

Create a button with a default file name/path

Forum|alt.badge.img+4
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 import daily work tasks into QB from an external file which is stored on an internal network share.

I am looking for a way to achieve the following options

A) View a sample or demo of an API button that will import data from a file (csv or xlsx) into a table.  I'd like to actually see it in action rather than a script. I have not been able to locate any resources that actually show this function

Or

B) Create a button that will allow the intended user to attach a file as a record then get the data from that attached file into a table. (Not sure if that's even possible. )
The button would have to be a hardcoded url/file name that never changes. 


Happy to provide additional details if needed.

Thank You




------------------------------
Michael Mahon
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    Let'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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement