Say I want to be able to update a certain groups of rows with a button. Let’s say I have a list of subtasks, and when the main task is “Complete”, I want to change the status of all related subtasks to “Complete” as well. MainTask-Table fields: MainTask-Name, MainTask-Status SubTask-Table fields: …

Can you do this with RunActions? It looks like you might be able to select all related fields, have a button in each one that says “MarkCompleted”, then execute all those buttons at once with RunActions. Is that right?

Never mind. Looks like the ModifyRows function will update all selected rows at once. [image] Coda | Formula library A.k.a. the official book of Coda spells. Our formula library is a comprehensive list of everything cool that comes after (But I’m still intereste…

You may want to look at FormulaMap as well. FormulaMap (list, expression) Copy link Provided a list and a formula, returns a list where each item is passed through the formula. INPUTS list A table, column, or list of values. expression The formula to transform every value in list. Use current…

Dear @shishir , Thanks for this example, especially the "detail view of task with sub-table"creates many use cases. Just my personal logic: If total sub-tasks belonging to a main task is 'true" , the main task should be true, isn’t it :question: Amicable, //JP

Sure, depends on your business logic, but that’s easy to implement. You would just need to decide if having no subtasks also means that your task is complete.

Does Coda have a way to create loops?

shishir February 22, 2019, 8:21am 5

Here’s an example:

Formula Training

Topic		Replies	Views
Struggling to Loop Through a Task Table and Add Rows to a 3rd Table Using FormulaMap	2	119	February 18, 2025
How to Rename Multiple Fields at Once in Coda?	4	94	February 26, 2026
A Button to copy multiple Rows from one Table into Another	11	7921	May 8, 2025
Easier ways to work with Subtasks that are within the same table, Grouping Product Feedback	9	6584	May 1, 2020
Feature request: use `thisRow` in formula of action that apply to all rows Product Feedback	8	1284	February 11, 2019

Does Coda have a way to create loops?

Related topics