Reply to comment

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:

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

Reply

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.

© 1997-2014 Intuit Inc. All Rights Reserved.

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