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))
@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!
Hero thank you for your reply.
Thanks @Scott_Collier-Weir and @Catalin_Marin1 for your help. Really appreciated!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.