Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoCan I see your code?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
MikeTamoush
3 years agoQrew Elite
This was the code when I was just trying to get it to work in the same table (this said no record found, and doesnt even perform the add record):
var text RID = "%%rid%%";
var text AddRecord = URLRoot() & "db/" & Dbid() & "?a=nwr";
var text EditRecord = URLRoot() & "db/" & Dbid() & "?a=er&rid=" ;
var text URL =
$AddRecord
& "&rdr=" & URLEncode($EditRecord) & $RID;
"<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='"
& $URL
& "'>TestAdd</a>"
This was the code when trying to use Add Record API in the child table (this adds the record, but has a blank still for RID. I am not sure how I saw before it take the parent record ID):
var text RID = "%%rid%%";
var text AddRecord =
URLRoot() & "db/" & [_DBID_SAFETY_ATTENDEES] & "?act=API_AddRecord"
& "&apptoken=xxxxxxxxxxxxxxxxxxx"
& "&_fid_11=" & URLEncode([Record ID#]);
var text EditRecord = URLRoot() & "db/" & [_DBID_SAFETY_ATTENDEES] & "?a=er&rid=" ;
var text URL =
$AddRecord
& "&rdr=" & URLEncode($EditRecord) & $RID;
"<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='"
& $URL
& "'>TestAdd</a>"
------------------------------
Mike Tamoush
------------------------------
var text RID = "%%rid%%";
var text AddRecord = URLRoot() & "db/" & Dbid() & "?a=nwr";
var text EditRecord = URLRoot() & "db/" & Dbid() & "?a=er&rid=" ;
var text URL =
$AddRecord
& "&rdr=" & URLEncode($EditRecord) & $RID;
"<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='"
& $URL
& "'>TestAdd</a>"
This was the code when trying to use Add Record API in the child table (this adds the record, but has a blank still for RID. I am not sure how I saw before it take the parent record ID):
var text RID = "%%rid%%";
var text AddRecord =
URLRoot() & "db/" & [_DBID_SAFETY_ATTENDEES] & "?act=API_AddRecord"
& "&apptoken=xxxxxxxxxxxxxxxxxxx"
& "&_fid_11=" & URLEncode([Record ID#]);
var text EditRecord = URLRoot() & "db/" & [_DBID_SAFETY_ATTENDEES] & "?a=er&rid=" ;
var text URL =
$AddRecord
& "&rdr=" & URLEncode($EditRecord) & $RID;
"<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='"
& $URL
& "'>TestAdd</a>"
------------------------------
Mike Tamoush
------------------------------