OliverKenfield
3 years agoQrew Member
Edit Record button doesn't work (a=er)
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?
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?