I am creating a content management base, and struggling with how to get a field to automatically update, and I hope someone can help.
I have different phases of publishing (eg brainstorm - > outline - > draft - > create visuals) that I want to manage using the kanban view.
At each phase I have different online tools I use.
What I would like to happen is when I change a record’s phase field I would like another field (“Tools”) to automatically update to reflect the tools appropriate for that phase, and even better if this list is clickable links that takes me straight to that tool. The idea is to get a quick visual idea of where all my articles are at
I have tried a couple of different other tables for tools and phases (one organising the tools by the phase, and one organising the phase by tools) and experimented with advanced field types (logic like IF, lookup) but I’m not at the point with bases where I can work it out.
Thanks in advance for any help