URL Button Doesn't Work in Edit Mode
I've got a URL button "Submit" that creates a child record then redirects to the parent table. It works great, but I can't do it while in edit mode, which is really the place I need it. I want staff t...
Forum Discussion
Hi Bettany;
You can create formula rich text field and use that instead. Formula below is saving master table record then adding child record and returns back to master table record. I hope this helps
Parameters: fid=48 is related project in task table and fid=6 is task name field in Task table.
var text url=URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_AddRecord&_fid_48="&[Record ID#]&"&_fid_6=test"&
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]);
"<a class='Vibrant Success SaveBeforeNavigating' style='background: #6BBD57; border: 1px solid #6BBD57' href='" &$url&"'>Add Task Record</a>"
Thank you
------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------
You can create formula rich text field and use that instead. Formula below is saving master table record then adding child record and returns back to master table record. I hope this helps
Parameters: fid=48 is related project in task table and fid=6 is task name field in Task table.
var text url=URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_AddRecord&_fid_48="&[Record ID#]&"&_fid_6=test"&
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]);
"<a class='Vibrant Success SaveBeforeNavigating' style='background: #6BBD57; border: 1px solid #6BBD57' href='" &$url&"'>Add Task Record</a>"
Thank you
------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------
- MarkShnier__You
Qrew Legend
Bettany,
Razi is correct. In your use case you will need to use a formula Rich text field type.
I believe that you are saying that your workflow is to be on an Add Record form for a Task. You want to save the record but AFTER the Record ID# is created, you want to also automatically create a record in a different table called Aggregate Tasks.
Try this as a Rich Text formula field.
but your code canny be copy pasted.
// define $add and $ ReDirect here
var text URL =
$Add
& "&rdr=" & URLEncode($ReDirect);
"<a class='Vibrant Success SaveBeforeNavigating' style='background: #6BBD57; border: 1px solid #6BBD57' href='" & $url & "'>Add Task Record</a>"
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
