How do I write a formula that presents a link in a view so users can open individual records with an XSL stylesheet?

Knowledge Base

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

Use a field of type "Formula - URL (Link)". Set the cover text to "Click Here.." and then use a formula to point to a view that selects for only one record based on the Record ID# field which is unique for every record.

The URL for a view using the API is for example:

https://www.quickbase.com/db/6pfpsy9r?act=API_DoQuery&query={'3'.EX.'4'}&clist=6.9.3&fmt=structured&xsl=%3Fact%3Ddbpage%5Epagename%3Dgenericstructured.xsl

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). Alternatively, you can leave the application's token requirement set to disabled.

You can make this into a QuickBase formula like this:

"?act=API_DoQuery&query={'3'.EX.'"&ToText([Record ID#])&"'}&clist=6.9.3&fmt=structured&xsl=" & URLEncode(?act=dbpage^pagename=genericstructured.xsl)

Notice that this is a relative link because it only gets displayed from within a view page of an application.

You can add more columns by adding to the period delimited list of fields following the clist parameter.

Tags:

38310 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