Skip to main content
Solved

URL Button to auto-complete form

  • October 9, 2019
  • 0 replies
  • 22 views
Forum|alt.badge.img+6
Is there a way to add a button that will edit a record with "pre-planned" data?  Looking for a quick approval system for an app I created for employee overtime requests.  This button would be only accessible to the app admin(s) and would generally set a Text multi select field to "yes", User List to the approver, and add a brief description of "Approved" to a multi-line text field.  

Any help is appreciated.

------------------------------
Joshua Case
------------------------------

Best answer by SergioSanchez1

Hello Joshua

Absolutely, please modify he following code as your best convenience:

-----
var text URL= URLRoot() & "db/" & [your table ID] & "?act=API_EditRecord"
& "&apptoken=your app token"
& "&_fid_field##=yes"
& "&_fid_field##=Approved";

"javascript:" &"$.get('" &$URL &"',function(){" &"location.reload(true);" &"});" 
​​-----

Remember to use URL type field, and have it : Display as a button on forms and reports". 

------------------------------
Sergio Sanchez
------------------------------
This topic has been closed for replies.

  • SergioSanchez1
  • Quickbase Alumni
  • Answer
  • October 9, 2019
Hello Joshua

Absolutely, please modify he following code as your best convenience:

-----
var text URL= URLRoot() & "db/" & [your table ID] & "?act=API_EditRecord"
& "&apptoken=your app token"
& "&_fid_field##=yes"
& "&_fid_field##=Approved";

"javascript:" &"$.get('" &$URL &"',function(){" &"location.reload(true);" &"});" 
​​-----

Remember to use URL type field, and have it : Display as a button on forms and reports". 

------------------------------
Sergio Sanchez
------------------------------
Terms & ConditionsAccessibility statement