Making lookups clickable for faster movement between notes

[Harry_Roper]

Hello all.

I am trying to build a connected note taking system at the moment but I can’t seem to figure out how to do it formulaically.

I want to use lookups to tag notes together but by using lookup you cannot click it to traverse to each note like when you use @. Is there a way to format it so that it is clickable?

Does anybody have any ideas on how I can accomplish this without having to type manually each time?

[Catalin_Marin1]

add a column , column type: button
in the button option under the label field write a formula (eg "=Link to previous.totext))
under the action field write an Activate() formula (eg "Activate(Link to previous))

[Scott_Collier-Weir]

Hey there!

@Catalin_Marin1 had the right idea! Utilize the activate() formula in your button to open any lookup.

Heres a few more tips:

• You should only use it on columns with a single lookup value in it (no multi-selects). The button would still work, but only opens the first entry
• No need to write .toText(). In your case just simply write the formulas as: Activate(Literature Referenced) - You could also write it as Activate(Literature Referenced).first() as the literature referenced will probably pull a list of rows as a value - but same outcome on the surface.

Heres a screenshot as an example!

[Harry_Roper]

Hero thank you for your reply.

[Harry_Roper]

Thanks @Scott_Collier-Weir and @Catalin_Marin1 for your help. Really appreciated!