Save with fields remaining the same

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
We create records that have the same data but only a few fields change.  I want to create a way to save and add new record with the data remaining.  
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb

Posted 9 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
The low tech solution is to be sitting on a record  in View mode and then use the More button to Copy this record.  

Note that you can set in each respective's field's Properties whether it copies forward (or is blank)  when you do that.

If you want to make a formula URL button to do that to make that more obvious to your users, you can make a formula URL button with this formula

URLRoot() & "db/" & dbid() & "?a=GenCopyRecord&rid=" & [Record ID#]
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,352 Points 20k badge 2x thumb
Write a formula URL using API_AddRecordForm and fill in the fields you want to copy:

https://help.quickbase.com/api-guide/index.html#gen_add_record_form.html

If you don't want to edit the record but rather just create the record use API_AddRecord
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb
Okay this works.  Is there a way to be in edit mode, so during creation of a record.  This is going on the floor and will probably be too complicated.  If not, maybe an alternative would be instead of save and close or save in new option to save and stay in the current record then copy.  
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
I'm not sure I understand.  You can only copy a record that has been already saved.  So the Operator would navigate to a record and then copy it to make a new record. 
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb
The two options are save and close / save and new.  Is there a way to save and stay on the record.  
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
If you want the allow the users to Save and Keep working (ie stay in edit mode), then that is an additional option you can set in form properties on the tab called "Properties"
Photo of Sarah Bunten

Sarah Bunten

  • 664 Points 500 badge 2x thumb
Ahh nevermind.  I figured it out.  Thank you!