Button to add rows with multiple columns from another table

1

Hi Coda Community!

I am trying to have a button where when clicked, it will add rows to a table with the data from 2 columns on another table. The Task Column is currently being added with the button using the formula pictured. However, I’m also trying to get it to populate the Stage column that matches the task from that same table as well. I cannot figure out how to add multiple columns from another table. Help Please!!!

Button Formula

This is the DB Template Tasks where I want the Task and Stage to pull from

This is where I want the Task and Stage to populate
This is where I want the Task and Stage to populate708×158 13.4 KB

2

Question: have you considered creating a view with the information, rather than copying it to a separate table?

3

Hi there! Thanks for responding.

I have a table with the tasks and stages as a template.

I have another table with the tasks from the template table (which is where I’m wanting to pull the stage in from) but it has more information as well (that I have a different view set up for) such as which employee is assigned to it and adding due dates etc. I’m tracking each line item per employee for onboarding purposes but I don’t see another way to accomplish it.