Forum Discussion

GiuseppeMacri's avatar
GiuseppeMacri
Qrew Captain
7 years ago

Issue with Save and Next Record Button

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#])
Ask about Quickbase functionality
Data import and export
Forms
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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's avatar
    GiuseppeMacri
    Qrew Captain
    7 years ago
    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?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      I have no idea how you would do that so my suggestion is to give them a button which directs them to a Dashboard consisting of an Instructions on how to use Save and Next.  

      I feel that where there is a perfectly good native solution,  you should use and and then move on to the next Quick Base project on your,  no doubt, long todo list.
    • GiuseppeMacri's avatar
      GiuseppeMacri
      Qrew Captain
      7 years ago
      Hmm ok, but just for reference, the native way to handle this would be a URL String with rid=[Record ID#]+1 right?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      I don't understand what you mean.  The "native way" is to use "Save and Next.
  • UrsulaLl's avatar
    UrsulaLl
    Qrew Assistant Captain
    7 years ago
    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!