Forum Discussion

Qrew Trainee

3 years ago

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...

APIs and custom code

Button

RaziD_

Qrew Cadet

3 years ago

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
------------------------------

MarkShnier__You
Qrew Legend
3 years ago
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
------------------------------