Currently I have a Site Visit table with multiple forms that the users select when created a record. After they save the record Quickbase takes them back to the form select form. (I inherited this) How can I add a URL button on the form to save/update changes to the record and keep the user in the current form and record.

Try this format. This will edit using form ID #10 and then redisplay after Save on that same form. URLRoot() & "db/" & Dbid() & "?a=er&dfid=10&rid=" & ToText([Record ID#]) & "&nexturl=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&dfid=10&rid=" & ToText([Record ID#]))

OK that works but now when I press the button quickbase pops up a window asking if I want to save the record "You've made changes to the (table record name". Do you want to save these changes before going to the next screen?" I dont want to go to another screen.

Wait, something does not make sense. That Button should show in View mode only. The user clicks and edits the record and then saves the record normally and it should then redisplay on form ID #10.

ok that works but now its in view mode again so they have to press the button again after every save. Can I code the button to stay in edit mode and just update the record?

I am not understanding where you want to return the user to after saving. Do you want to leave them in Edit mode after saving? if so, then in that last line of code, change the "dr" (Display Record) to "er" (Edit Record).

How can I add a URL button that will allow users to save/update and stay in current record and form? Currently returns to form select form.

QuickBaseCoachD
Qrew Captain
7 years ago
See if this idea works

var text Edit = URLRoot() & "db/" & Dbid() & "?a=er&dfid=10";

var text ViewOnFormTen = URLRoot() & "db/" & Dbid() & "?a=dr&dfid=10&rid=" & [Record ID#];

var text URL =
$Edit
& "&NextURL=" & URLEncode($ViewOnFormTen);

var text Words = "click here";

"<a href=" & $URL & ">" & $Words & "</a>
KellyBianchi
Qrew Assistant Captain
7 years ago
That opened a fresh form. I don't need it to edit. The 'Update' button puts the form in edit mode. I just need it to save and display the correct form. Isn't there a way to amend the onclick='DoSaveAdd() so that it displays the current form upon save?
QuickBaseCoachD
Qrew Captain
7 years ago
Sorry the first line was supposed to read

var text Edit = URLRoot() & "db/" & Dbid() & "?a=er&dfid=10&rid=" & [Record ID#];
KellyBianchi
Qrew Assistant Captain
7 years ago
But that's still an 'edit record' command. I'm not looking for the button to edit the record. I just want it to save it. The form is already in edit mode and has been edited. I just want to click a button that saves like 'onclick='DoSaveAdd() ', but I need it to stay on the same form.
KellyBianchi
Qrew Assistant Captain
7 years ago
Or are you thinking I should edit the 'update' button?
QuickBaseCoachD
Qrew Captain
7 years ago
I'm suggesting that they use the edit button and then the regular save button will stay on the proper form. I don't know how to change the DoSaveAdd button to force a particular form, so I'm offering up an alternative solution.
QuickBaseCoachD
Qrew Captain
7 years ago
yes, this would replace your update button.
KellyBianchi
Qrew Assistant Captain
7 years ago
Good call as usual, Mark... that worked!
QuickBaseCoachD
Qrew Captain
7 years ago
Thx for letting me know it worked. I guess that you are still "stuck" with the native edit button at the top right, but that native Edit is pretty subtle compared to your row of matching buttons which look more inviting to click.
KellyBianchi
Qrew Assistant Captain
7 years ago
Not entirely... I have reinstated the DoSaveAdd and retained my save button, and it works just as the native button does :) Win, win!
- JanaBaker
  Qrew Cadet
  7 years ago
  Kelly...what was the final code that you implemented to make it work properly? I'm trying to accomplish the same thing. :)
- KellyBianchi
  Qrew Assistant Captain
  7 years ago
  Remember, this is a row of navigation, so the one you want is 'Update Info' (bolded).
  
  // Begin button style
  var text ViewOnFormThirtyOne = URLRoot() & "db/" & Dbid() & "?a=dr&dfid=31&rid=" & ;
  var text bgcolor = "#4b72b0";
  var text txtcolor = "white";
  var text URLONE = URLRoot() & "db/" & Dbid() & "?a=er&dfid=31&rid=" & ;
  var text URLTWO = URLRoot() & "db/" & Dbid() & "?a=dbpage&pagename=" & URLEncode("Service Request Form.html") & "&clist=a&rid=" & ;
  var text URLTHREE = "https://vcommerce.quickbase.com/db/bnhjmd73w?";
  var text URLFOUR = $URLONE & "&NextURL=" & URLEncode($ViewOnFormThirtyOne);
  var text style = "style=\"text-decoration: none; background:" & $bgcolor & "; border-radius: 5px; padding: 10px 24px; margin-bottom:5px; width: auto; font-weight: normal; font-size: 12px; text-align: center; display: inline-block; color: " & $txtcolor & "; font: normal 700 24px/1 \"Calibri\", sans-serif;";
  // End button style
  
  "<div>" &
  "<a " & $style & " href='" & $URLFOUR &"'>Update Info</a>" & "  " &
  "<a " & $style & " href='" & $URLTWO &"' target=\"new\">Print Record</a>" & "  " &
  "<a " & $style & " onclick='DoSaveAdd()'href='#'>Save Changes</a>" & "  
- JanaBaker
  Qrew Cadet
  7 years ago
  Kelly this is amazing! I wont lie, some/most is over my head but i can piece it together. I'd love to mimic this if possible, but think i need a little hand holding if you dont mind?
  
  To make sure i get it it, all of this code makes all four buttons your reference at the beginning of the post! My needs fairly close.
  
  Upon saving, i want the user to return to Report 27 when sitting for Form 16. Currently they are being forced back to the original form, and i dont want that. How can i that into your code? I have little bits working but not all. This redirects the user to report 27:
  
  URLRoot() & "db/" & [_DBID_LEADERS2] & "?a=q&qid=27&nv=1&v0=" & [Record ID#];
  
  Your URLTWO goes to Service Request, mine would go to the "A-Team Dashboard"...what would i put in place of what you have here: URLEncode("Service Request Form.html"?
  
  Then URLTHREE would just be my QB App i would assume? And for other changes i would need to make...where you have Form 31, i put what form # the buttons are sitting on? So Form 16 in this example and use [Record ID#] vs. ?
  
  Thank you in advance!!

Forum Discussion

How can I add a URL button that will allow users to save/update and stay in current record and form? Currently returns to form select form.