Making lookups clickable for faster movement between notes

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?

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

1 Like

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!

1 Like

Hero thank you for your reply. :bowing_man:

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.