Forum Discussion
I appreciate all of the help! It is almost working perfect. The pipeline runs and the ultimate goal is achieved but I am getting an error with this code:
var text Approve = If([Import Note Check Box] = false, URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#])
& "&_fid_39=1",URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#])
& "&_fid_39=0");
var text DisplayParent= URLRoot() & "db/" & [_DBID_EPISODES_OF_CARE] & "?a=dr& rid=" & [Related Episode];
$Approve
& "&rdr=" & URLEncode($DisplayParent)
I think it has to do with [Related Episode]
Here is the function:
Our staff dictates notes into the child table while on the road. When they come home and go into the Parent Table and click the URL button we are creating here. This checks a box on the child record and then triggers a pipeline. The pipeline maps the fields from the child table to the parent table. There are about 12-15 fields.
------------------------------
Joseph Mahon
------------------------------
Take away the extra space in this line before rid.
"?a=dr& rid=" & [Related Episode];
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- JosephMahon2 years agoQrew Member
That did it! Jeez, thanks for catching that. I appreciate all of the help.
This works perfect and looks nice and clean now!
------------------------------
Joseph Mahon
------------------------------