Issue with Save and Next Record Button

  • 0
  • 1
  • Question
  • Updated 1 year 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 G.Macri

G.Macri

  • 878 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
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 G.Macri

G.Macri

  • 878 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 G.Macri

G.Macri

  • 878 Points 500 badge 2x thumb
Hmm i don't see a save and next option for the green save buttons.
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 G.Macri

G.Macri

  • 878 Points 500 badge 2x thumb
I understand what youre saying. Thanks! I never knew that existed!
Hooray for no code native solutions.
Photo of G.Macri

G.Macri

  • 878 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,678 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!