OK here goes,
We need to make a URL formula field to edit the record and land the user in edit mode on the record.
When using API's which update records, we either need to have what is called an
application token.
You may or may not want to keep the need for those enabled those enabled. many of my clients choose to disable the need for them. That is a setting on Application Properties for the App settings.
Here is the code for a button. Post back with your code and any error messages as I'm free form typing this without the benefit of he formula syntax editor!
You can get the field ID# by right clicking a field name on the form or looking at the field properties under Usage or in the URL.
// this is a comment
//this is a formula variable below
var text ClearFields = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=cxcxcxcxcxcxccxcxcxxcxc" // insert your app token here is you have them enabled
& "&_fid_90=" // clear field ID 90 change the 90 to the field ID# of your own fields.
& "&_fid_91=" // clear field ID 91
& "&_fid_92=" // clear field ID 92
& "&_fid_93="
; // clear field ID 93 and end the formula variable with a semi colon
// new formula variable to display the record in edit mode.
var text DisplayInEditMode = URLRoot() & "db/" & dbid() & "?a=er&rid=" & [Record ID#];
$ClearFields
& "&rdr=" & URLEncode($DisplayInEditMode)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
