Forum Discussion
MarkShnier__You
Qrew Legend
This would edit the record you are on and then land you in edit mode on the same record.
var text SetValues =
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
var text EditMode = URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid="
& URLEncode([Record ID#]);
$SetValues
& &rdr=" & URLEncode($EditMode)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text SetValues =
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
var text EditMode = URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid="
& URLEncode([Record ID#]);
$SetValues
& &rdr=" & URLEncode($EditMode)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
OliverKenfield
2 years agoQrew Member
Hi Mark, thank you much! That works mostly. Is there a way where it doesn't actually save it until the person hit's Save? Right now it updates the fields, and then uses Edit mode. Which is great, it just doesn't allow a person to make a mistake and back out without saving.
- MarkShnier__You2 years agoQrew LegendIf you don't want it to save - which is the whole point of this button, then you need to do this with simple form rules instead. You make a checkbox to trigger a form rule to do those changes, and then the last step of the form rule actions is to uncheck the checkbox.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- 110138 months agoQrew Trainee
Regarding your last suggestion about accomplishing this via a DFR: I have a similar challenge, but one of the edits I want to make is to increment a numeric field by 1. I don't think a form rule can help me to do this. Am I overlooking something?
- MarkShnier__You8 months agoQrew Legend
Yrs, a dynamic form rule can do this. You might need to create a helper feel that's equal to your numeric field plus one and then, when the form rule fires, it would change your numeric field to the value in the helper field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------