Forum Discussion

Qrew Assistant Captain

24 days ago

URL formula -API_RunImport

I would like to create a URL formula button -- that when clicked it will run a table to table import --- this is what I have created (did not work) var text URLONE = URLRoot() & "db/" & [Table ID] ...

formulas

MarkShnier__You
24 days ago
The advanced settings for your application there is a place to indicate whether or not you want to use application tokens. The extra level of security is up to you but for most of my clients I do not enable them unless there is some private healthcare data that they are concerned about. But if you do want to use application tokens then you need to create one and then use the syntax
var text URLONE = URLRoot() & "db/" & [Table ID]
& "?act=API_RunImport&ID=" & [TableImportID]
& "&apptoken=xxxxxxxxxxxxx";

MarkShnier__You

Qrew Legend

Yes, it would have to be a Fomula Ruch textfield.

here ina low tech example.

var text Words = "Click here to Toggle";

var text Checkbox = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_12=" & not [checkbox];

var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

var text URL =
$Checkbox
& "&rdr=" & URLEncode($RefreshPage);

If([checkbox]=false,
"<a class=\"Vibrant Primary\"a href=" & $URL & ">" & $Words & "</a>", // blue
"<a class=\"Vibrant \"a href=" & $URL & ">" & $Words & "</a>") // gray

// "<a class='Vibrant'>Vibrant</a>", // regular grey button
// "<a class='Vibrant Alert'>Vibrant Alert</a>", // yellowish
// "<a class='Vibrant Danger'>Vibrant Danger</a>", // red
// "<a class='Vibrant Primary'>Vibrant Primary</a>", // blue
// "<a class='Vibrant Snowy'>Vibrant Snowy</a>", // white
// "<a class='Vibrant Success'>Vibrant Success</a>" // Blue again

BradElmore

Qrew Assistant Captain

15 days ago

Mark, I'm using the Rich Text formula field below -- works great -- But I would like to Add a step -- that after running the "run-Import" -- I would like to change a check box field [field d] - to True --- and then go to the "Refresh Page" --- is this possible?

var text Words = "Consolidate";

var text Checkbox = URLRoot() & "db/[tableId]?act=API_RunImport&ID=" & [TableImportID];

var text RefreshPage = URLRoot() & "db/[tableid]?a=q&qid=22" & Rurl();

var text URL =
$Checkbox
& "&rdr=" & URLEncode($RefreshPage);

var text button =
$RefreshPage;

Gesco_QBAdminis
Qrew Trainee
15 days ago
np,
The generic syntax for running multiple steps in a URL is this, and keep in mind the last step needs to be to either refresh the page you are on, or land the user on a record or a report or some page.
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSEVEN))))))

In you case we need three steps so we take 3 slices off the salami.
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))

so it would like this
var text Import = URLRoot() & "db/" & [Table ID]
& "?act=API_RunImport&ID=" & [TableImportID]
& "&apptoken=xxxxxxxxxxxxx";
var text CheckTheBox = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxxxxxxx";
& "&_fid_99=1"; // 1 means true or checked
var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

$Import
& "&rdr=" & URLEncode($CheckTheBox)
& URLEncode("&rdr=" & URLEncode($RefreshPage))