How to open a row for editing (modal) from a different table using a formula

Hello @Jorge_Silva,

One way to accomplish this is to first run the button through a conversion to a referenced button inside of the source table, as then you can have it display anywhere.

In the shared example below, you will see that I have a separate column in my tasks table which uses the hidden formula Button() to rebuild my “Activate” button. I then use that new column in my Projects table to show it as you want to.

I use this along with some extra complications for my daily task list (the magnifying glass activates the row and the checkbox completes it):
image

However, one important note if you end up displaying something on a canvas (as opposed to a table like you requested) that has an embedded button using the method above - it won’t work as a single click ends up sending two actions, one to modify the formula on the canvas and the other to push the button to activate the row. Therefore, I use this formula for my “Activate” button: =list(activate(thisRow),_delay(activate(thisRow),100)) . The resulting “double-click” then causes the button to work in one click as you would expect. There is probably a better way to do this.

3 Likes