Button that references own row formula?

1

Does anyone know how to format a button that auto-fills in a section of a row based on a formula?

Basically, I have a todo list. Each row is a project and I reference another table for the individual todo items. I want to add a “add todo” button to each row that references the name of that specific project. I already have a “add todo” button for the page, but I have to find the project each time I add a new todo item and my list of projects is growing and it’s becoming difficult to find. Here’s a screenshot of what I’m looking to do:

Screen Shot 2020-05-11 at 9.25.37 AM
Screen Shot 2020-05-11 at 9.25.37 AM1660×770 45.5 KB

Right now the “Add a New Task” just creates a blank row and I have to fill in all the blanks myself. I was hoping to add a formula to make it reference the row that the button exists in.

2

Hey I would need an example doc - to be able to see the other tables - to be able to help you.

3

I’ll try and put something together soon. I can’t share this doc for confidentiality purposes unfortunately.

4

Hey @Benn_Bennett,

I imagine, in your Todos table there’s a lookup column back to the row in Projects? Then in your Add new task button you simply need to specify in your AddRow formula:

Tasks.AddRow(Tasks.Project, thisRow)

or use thisRow in your UI, if that’s how you set up the button.

thisRow is the reference you’re looking for; it’s the row of the button that’s clicked.