Can column formulas be managed/edited/updated from an external doc or table, or even programmatically?

1

Hi all!

I have some template documents that I use frequently. One of the tables in the template has an important column formula. On occasion, I want to update the formula. Of course, I can make this change for the template document, and all future dertivatives will have that new formula. But for docs already created from that template, I have to go to each document and update the column formula one-by-one. Is there a way to set up a master control formula, either from a master document, table, or even programmatically, that will easily propogate changes to columns across several other docs/tables?

Thanks in advance to anyone who can help! :grin:

1 Like
2

hi David, that is not yet possible.
the alternative is a source table synced to all your docs via cross doc (the new set up is really helpful) and relate your other data to this cross doc table.
cheers, christiaan

3

Hi David, an option for this might be to create a pack that has a custom formula that does the logic you want.

There are pros and cons to this approach, but the pro would be that when you want to make a change to the pack formula, any doc using the pack’s formula would use the new logic.

More info here: Add custom formulas - Coda Pack SDK

1 Like