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