How do I create a delete record link that can be clicked on from a report?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

Just create a Formula URL field and use the following as its formula:

"javascript:if(confirm ('Are you sure you want to delete this record?')){location.assign('/db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]& "&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=q&qid=7")) & "')}"

You'll have to change the seven character "7" in the above formula to the qid of the report that you want to return to. To learn about qids please read the following:

http://quickbase.intuit.com/developer/node/2087

NOTE: QuickBase recommends that you use application tokens when working with API calls (read more about tokens at https://www.quickbase.com/help/app_tokens.html).

Tags:

66497 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base