Forum Discussion
IvanWeiss
5 years agoQrew Captain
Flip around the display record. You do not display it first, the API can edit the record and you can display it after
rewrite the formula completing your api edit record first. After that put an & next line should be
"&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [Maximum Related Job]);
You complete the action and use the rdr to navigate after that.
------------------------------
Ivan Weiss
------------------------------
rewrite the formula completing your api edit record first. After that put an & next line should be
"&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [Maximum Related Job]);
You complete the action and use the rdr to navigate after that.
------------------------------
Ivan Weiss
------------------------------
- WallaceYeboah5 years agoQrew MemberThanks for the response Ivan. The formula still seems to not be working
Here is the updated formula:
URLRoot() & "db/" & "db/" & Dbid() & "?a=API_EditRecord" & "&_fid_1146=1" & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [Maximum Related Job])
I get this error when I test
<qdbapi><action>API_EditRecord</action><errcode>102</errcode><errtext>Invalid request - we cannot understand the URL you specified.</errtext></qdbapi>
------------------------------
Wallace Yeboah
------------------------------- MarkShnier__You5 years ago
Qrew Legend
The first line of the formula is missing telling the AP:I which record to edit. Perhaps you want this
URLRoot() & "db/" & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#]
& "&_fid_1146=1"
& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [Maximum Related Job])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- WallaceYeboah5 years agoQrew MemberThanks Mark. I just tried that formula, still no luck. I keep receiving the same error message when I test
------------------------------
Wallace Yeboah
------------------------------