302 Found

Found

The document has moved here.

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

Comments

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

Found

The document has moved here.