Issue with Save and Next Record Button

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
I would like a button that once a grader reviews a form and submits a grade, QB directs to the next empty grades form. 

I currently summarized all the forms (yay power of 1) and have access to a minimum record ID field. However, when i click on the button to direct to the next record, it brings me back to the same graded record.

For the button to work properly, users need to click it twice after grading. Is there a way to get the button to save, let QB update the tables, then get to the next record, rather than click the save button twice?

Code for reference:
URLRoot() & "db/" & Dbid() & "?a=er&rid=" & ToText([2 - Minimum Record ID#])
Photo of Giuseppe macri

Giuseppe macri

  • 514 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Typically you would make a report of records missing a Grade. 

Then the user would just start at the top of the report and use the native "Save and Next' to edit their way down each record on the report.  No need to make a special button for this.
Photo of Giuseppe macri

Giuseppe macri

  • 514 Points 500 badge 2x thumb
Lets assume my users have no self control and would randomly select records from that list. How can i build a button to address this issue?
(Edited)
Photo of Giuseppe macri

Giuseppe macri

  • 514 Points 500 badge 2x thumb
Hmm i don't see a save and next option for the green save buttons.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
When ever you run a report, the Green Save and Next button is available - there is sort of a split on the right side of the button.  Select that it it will then stick as a Save and Next instead of a save button and the user can just walk down the whole report in edit mode.
Photo of Giuseppe macri

Giuseppe macri

  • 514 Points 500 badge 2x thumb
I understand what youre saying. Thanks! I never knew that existed!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
Hooray for no code native solutions.
Photo of Giuseppe macri

Giuseppe macri

  • 514 Points 500 badge 2x thumb
Now i need to figure out how to IoL to default the Save and Next Button
Photo of Ursula Ll

Ursula Ll

  • 1,446 Points 1k badge 2x thumb
Does the record already exists prior to saving? or is this the first time the record is being saved? If so, that may be why your formula is not working. When they click the button, the next form doesnt have a record id yet, because it doesn't technically exist yet. You would need to pre-create empty records for it to go from one to the next. However, this is not a good solution, as you would always have to go back in and create new records. Hope that helps!