How can I create a button in Coda that duplicates only the visible rows in a table and overwrites some of the field values, especially when the table is filtered to show specific data in Coda?

To hide columns in a Coda table, follow the steps given below:

• Open your Coda account
• Right-click on the column header that you wish to hide
• Hit ‘Hide’

You can combine and calculate summaries based on the looked-up information by first creating a relation between your main data table and the lookup table, then utilizing the 'filter' function in a formula to select relevant data from the lookup table based on the matching value in your main table.

To add a toggle switch to an automation in Coda, follow the steps given below:

• Open your Coda account
• Press on the toggle switch in the upper right corner
• Click on Add Rule to create an automation
• Press on the toggle switch in the upper right part of the page to activate the automation

To hide the table title in Coda, follow the steps given below:

• Open your Coda account
• Hover over the table that you wish to hide
• Press in the ‘Options’ button in the top right corner
• Click on ‘Table display’
• Turn off the item that displays the table title.

To build a basic team hub in Coda, follow the steps given below:

• Open your Coda account
• Create a new document
• Use Coda’s text blocks, buttons and tables to add dedicated areas for important team data, such as a resource repository, project tracker, team roster table, meeting notes section, and an ‘About Us’ part describing the team's goal and values.