I haven't found a thread yet with a solution that is working with me so, I am trying to to make a button that saves and redirects. Currently I am trying <div class='Vibrant Success' onclick='RedirectURL.value=myurlhere;editform.rl.value="";DoSave();'>Save</div>I got my current setup from this thread https://community.quickbase.com/quickbase/topics/how-can-i-save-and-redirect-to-a-home-page This thread is the closest thing to what I am looking for. I would like to be able to save a form and then be redirected to a different table and its default report. Is there an easier solution?

Hey Mark,I'm trying to set this up to send me to a certain report (within the same table) once I click the save button in a form. Is this possible? I've set up the following in a Formula URL field and placed the button in the form:var Text URLONE ="[my data entry form URL]";var Text URLTWO ="[my report URL]";$URLONE & "&NextURL=" & URLEncode($URLTWO) But, it's only saving and keeping me in the same form, opened to the next new record.

Yes, I'm just on my iPhone now, but you can use this contract. var text URLONE =. Insert your first URL here ; var text URLTWO =. Insert your next URL here ; $URLONE & "&rdr=" & URLEncode(NextURL ) The first URL would be the one where you are using GenAddRecordForm

var Text URLONE =. https://example.quickbase.com/1 ;var Text URLTWO =. https://example.quickbase.com/2 ;$URLONE & "&rdr=" & URLEncode(NextURL )Is telling me variable declaration must end with a semi colon

If you post hour formula I can hep correct it. But you need to end each of the two formula variable lines with a semi colon.var Text URLONE ="https://example.quickbase.com/1";var Text URLTWO ="https://example.quickbase.com/2";$URLONE & "&rdr=" & URLEncode($NextURL )Also I had an error on the last line.

Ahhh yes, I forgot the quotation marks, silly mistake on my part. Currently the formula is:var Text URLONE ="https://clearpath.quickbase.com/db/bmr3y249a?a=nwr";var Text URLTWO ="https://clearpath.quickbase.com/db/bmr3y225t?a=td";$URLONE & "&rdr=" & URLEncode(NextURL)I too am getting an error on the last line

Save button with a redirect | Qrew Discussions

33 Replies

TylerParker
Qrew Assistant Captain
6 years ago
Hey Mark,

I'm trying to set this up to send me to a certain report (within the same table) once I click the save button in a form. Is this possible?

I've set up the following in a Formula URL field and placed the button in the form:

var Text URLONE ="[my data entry form URL]";
var Text URLTWO ="[my report URL]";
$URLONE
& "&NextURL=" & URLEncode($URLTWO)

But, it's only saving and keeping me in the same form, opened to the next new record.
QuickBaseCoachD
Qrew Captain
7 years ago
Yes,

I'm just on my iPhone now, but you can use this contract.

var text URLONE =. Insert your first URL here ;
var text URLTWO =. Insert your next URL here ;

$URLONE
& "&rdr=" & URLEncode(NextURL )

The first URL would be the one where you are using GenAddRecordForm
JordanBeatty1
Qrew Captain
7 years ago
var Text URLONE =. https://example.quickbase.com/1 ;

var Text URLTWO =. https://example.quickbase.com/2 ;

$URLONE
& "&rdr=" & URLEncode(NextURL )

Is telling me variable declaration must end with a semi colon
QuickBaseCoachD
Qrew Captain
7 years ago
If you post hour formula I can hep correct it. But you need to end each of the two formula variable lines with a semi colon.

var Text URLONE ="https://example.quickbase.com/1";

var Text URLTWO ="https://example.quickbase.com/2";

$URLONE
& "&rdr=" & URLEncode($NextURL )

Also I had an error on the last line.
JordanBeatty1
Qrew Captain
7 years ago
Ahhh yes, I forgot the quotation marks, silly mistake on my part.

Currently the formula is:

var Text URLONE ="https://clearpath.quickbase.com/db/bmr3y249a?a=nwr";

var Text URLTWO ="https://clearpath.quickbase.com/db/bmr3y225t?a=td";

$URLONE
& "&rdr=" & URLEncode(NextURL)

I too am getting an error on the last line
QuickBaseCoachD
Qrew Captain
7 years ago
Right, so I corrected that in my previous post. Needs to be $NextURL.

& "&rdr=" & URLEncode($NextURL)
- StephanieHarris
  Qrew Assistant Captain
  6 years ago
  I am using the save and redirect technique to allow everyone on the internet to submit fraud concerns through our Quick Base application. After saving the record they are directed to an internal html splash page thanking them for bringing the concern to our attention. I would like to be able to provide them with a reference number (record ID# of the record they saved) so when they are reached for follow-up it's easy to know which submittal we are referencing.
  
  Any suggestions for getting the record ID# on the splash page? _
- QuickBaseCoachD
  Qrew Captain
  6 years ago
  I suggest not redirecting to a splash page, , but rather displaying the saved record on an alternate form. The form would be used in View mode. For the EOTI Role.
  
  It can have all the HTML you like using formula Rich Text Fiekd. But it can thus provide the Record ID.
- StephanieHarris
  Qrew Assistant Captain
  6 years ago
  Currently the formula for my button is: "<a class='Vibrant Success' href='javascript:LinkAway(\"" & URLRoot() & "db/" & Dbid() & "?a=dbpage&pagename=Thank You for Submitting.html" & "\");' >Submit</a>"
  
  How would I change that to save and go to a specific form?_
JordanBeatty1
Qrew Captain
7 years ago
This did the trick, thank you!
QuickBaseCoachD
Qrew Captain
7 years ago
Great, thx for letting me know.
- MichaelGraham2
  Qrew Assistant Captain
  7 years ago
  Mark
  Can you tell me why you put $NextURL and not $URLTWO ?
- QuickBaseCoachD
  Qrew Captain
  7 years ago
  That was muddled, I was trying to answer questions on an iPhone while cleaning out my basement yesterday
  
  This would work if the first API was like API_GenAddRecordForm where you want to control where to land the user after the save.
  
  var Text URLONE ="https://clearpath.quickbase.com/db/bmr3y249a?a=nwr";
  
  var Text URLTWO ="https://clearpath.quickbase.com/db/bmr3y225t?a=td";
  
  $URLONE
  & "&NextURL=" & URLEncode($URLTWO)
  
  Sorry for that confusion.
- MichaelGraham2
  Qrew Assistant Captain
  7 years ago
  Now I understand. Cool :)
ArchiveUser
Qrew Captain
6 years ago
Is there a way to do this without getting the QB prompt:

"You've made changes to this Service Request. Do you want to save these changes before going to the next screen?"

I'd like it to just save the record and redirect, is there a way to skip the "are you sure" part?
QuickBaseCoachD
Qrew Captain
6 years ago
Try going to the Table
Advanced Settings
and check the box for : Save parent record automatically when a child record is created.