Button to update cell value with lookup

1

Hi Everyone!

I have a page with all tasks including

  • a table with projects A B C D
  • a table with tasks + lookup to associated project

image
image377×605 5.63 KB

I have a page per project with

  • a table with tasks linked to project B
  • a button to add a task

image
image753×558 27.6 KB

I am trying to have the button automatically assign the task to a give project.
Any clue on how to do it?

I have “=project” but don’t know how to redirect to the specific project I had in mind.

Thanks in advance for the support!

Best,

1 Like
2

image
image388×683 15.3 KB

image
image416×553 8.42 KB

In order to get the correct item in the Column 2 button, type “=@Project B” (without the tick marks).
On every project page you make a button with the right project for column 2.

Open for editing makes sure that you actually start entering some task text, but you don’t have to do that if you want to follow a different approach.

2 Likes