I have a document which manages projects. Every project has a bunch of tasks. Those tasks are visible on my project table. Because of the complexity of the document and for UX purposes, I want to: Open the individual tasks from the project table, preferably on a modal.
FormulaMap( All Tasks.Filter(Related Project=thisRow).Name, All Tasks.FilterName=CurrentValue.Open Task) )
What I have tried so far:
- The closes action that I found it was Activate but is not available or I have not been able to implement. The other option that I found was to call a button field with Activate(thisRow) but it’s translated on my Project table to simple an Action text but it does nothing.
- I have tried with Link but I don’t think it can be used inside rows.
The reason I’m not using a regular Lookup is that I have an Action that creates predefined tasks based on templates in another table, so Lookup row breaks everything that I use the Add Template button/action.
Thank you in advance