Modify a button to save before adding a record in a separate table

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have the following button working to go to a different table and add a record for the related project.  What I would like to do is add in a save part to happen before going to the new table and adding a record.
URLRoot() & "db/" & [_DBID_REGULATOR_INFORMATION] & "?a=API_GenAddRecordForm&_fid_95=" & URLEncode ([ProjectID#])& "&z=" & Rurl()
I saw Dan's Pastie about Save and Edit but it uses HTML and I don't know if I can use HTML with the above.
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
  • happy

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 59,576 Points 50k badge 2x thumb
Try looking for a setting in the table where the button is under advanced properties, and check the box to Automatically Save when adding a child Record. That might work.
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
I set that after reading a post you did earlier about the benefit of that.  For some reason, using the above formula will not link back to the parent record unless it is saved first.