Skip to main content
Question

Issue with Save and Next Record Button

  • June 11, 2018
  • 0 replies
  • 112 views
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#])
GMacri

    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.
    • GiuseppeMacri
    • Author
    • Registered
    • June 11, 2018
    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?
    GMacri
    Forum|alt.badge.img
    • UrsulaLl
    • Registered
    • June 11, 2018
    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!
    Terms & ConditionsAccessibility statement