Quick Base Discussions

Changing linking behaviors on New Calendars

By Sam Jones posted 03-30-2018 16:30


[The Quick Base Knowledge Base is your library of frequently-asked questions that help you better customize your apps to solve your business problems.]

While the response to our new calendar reports has by and large been very positive, we've had a few people asking about changing the linking behaviors. Some want to be able to right click on the records to open them in a new window, while others miss the drill-down report to show the day. 

While at this moment we aren't implementing either of these features in the product natively, there's an easy, supported way using a Formula Rich Text field to insert them.

Here's the formula:
var Text URL = URLRoot() & "db/" & Dbid() & "?a=";
var text DisplayText = [Project Name];
"" & $displaytext & ""
There's two variables here, one to set the URL you want link to. That can be constructed as you would any link in Quick Base. If you want to link to a great blog about Apple, you can set it like so:

var Text URL = "https://daringfireball.net";
If instead, you want to link to a table report filtered to only that day, you'd do something along the lines of:

var Text URL = URLRoot() & "db/" & Dbid() & "?a=q&query=" & URLEncode("({'134'.IR.'" & ToFormattedText([Start Date Time], "DDMMYYYY") &"'})");

where 134 is the Field ID of my Start Date Time Field.

Finally, if you'd like to link to the record itself, you can use:

var Text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#];
The second variable sets the display text. If you only want to display one field, you can use:

var text DisplayText = [Project Name];

but if you'd like to preserve the display we used on the new calendars, you can use:

var text DisplayText = List(" | ", [Project Name], [Status]); 

and add several fields inside that List function.

Hope this helps!

Sam Jones

QuickBase Product Manager