Skip to main content
Question

Edit Record button doesn't work (a=er)

  • May 17, 2022
  • 0 replies
  • 219 views

Hello,
I have a button and when I use ?a=API_EditRecord&rid= it works, but of course saves the record. I would like the record to stay opened in Edit mode.  So when I use ?a=er&dfid=2&rid= it doesn't update any of the fields.  I need to be able to enter a quantity before I save.  I'm starting to feel crazy, but I had the button working the other day fine, and the next day it didn't work.  

This one updates fields correctly but saves:
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid="
& URLEncode([Record ID#])
&_fid_119=" & URLEncode("Change Qty Requested") //Change Order Status
& "&_fid_110=1" //Changed Item checkbox
& "&_fid_111=" & URLEncode("Waiting on Approval") //Approval Status
& "&_fid_109=" & URLEncode("Waiting on Approval") // Change Status
& "&_fid_114=" & URLEncode([Qty]) // Change Previous QTY
& "&z=" & Rurl()

This one opens the record in edit mode, but doesn't edit the values of any of the specified fields:
URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid="
& URLEncode([Record ID#])
& "&_fid_119=" & URLEncode("Change Qty Requested") //Change Order Status
& "&_fid_110=1" //Changed Item checkbox
& "&_fid_111=" & URLEncode("Waiting on Approval") //Approval Status
& "&_fid_109=" & URLEncode("Waiting on Approval") // Change Status
& "&_fid_114=" & URLEncode([Qty]) // Change Previous QTY
& "&z=" & Rurl()

What am I missing here?
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • May 17, 2022
When you push the button are you in edit mode?  And when pushed you want to save and continue in edit mode?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------