Button to add rows with multiple columns from another table

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

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

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.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.