Discussions

Expand all | Collapse all

Issue with Save and Next Record Button

  • 1.  Issue with Save and Next Record Button

    Posted 06-11-2018 13:24
    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#])


  • 2.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 13:47
    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.


  • 3.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 13:53
    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?


  • 4.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 13:58
    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.


  • 5.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 14:06
    Hmm ok, but just for reference, the native way to handle this would be a URL String with rid=[Record ID#]+1 right?


  • 6.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 14:09
    I don't understand what you mean.  The "native way" is to use "Save and Next.


  • 7.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 14:13
    Hmm i don't see a save and next option for the green save buttons.


  • 8.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 14:34
    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.


  • 9.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 14:47
    I understand what youre saying. Thanks! I never knew that existed!


  • 10.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 14:50
    Hooray for no code native solutions.


  • 11.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 14:58
    Now i need to figure out how to IoL to default the Save and Next Button


  • 12.  RE: Issue with Save and Next Record Button

    Posted 06-11-2018 14:49
    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!