Skip to Navigation

Knowledge Base

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

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

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

The URL for a report using the API is for example:{'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 (to learn more, please see our Application Tokens help topic). 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 report page of an application.

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


Post new comment

The content of this field is kept private and will not be shown publicly.
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.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit