Some formulas in Coda can become complex. As they become more complex they become less readable. I would like to see the ability to format formulas using line breaks, comments and tabs to increase readability. This is particularly important when trying to maintain someone formulas written by others. …

I think the formula’s have a ‘name’ - it’s the column name itself. So the formula name is Table.[Column]. You can further target a specific row by typing @ and then the value in the ‘Display’ column. This is separate from when you write =formula() on the canvas where that can be a discrete formula …

You’re right in saying that formulas in column technically have a ‘name’ but it’s more the name of the column used when displaying the data and not the formula specifically, and I can’t see a list of formulas I have in columns. I’ve noticed I tend to make quite a lot of logic inside the column form…

OK so one idea I have used is to have a ‘database’ folder in your doc where you keep the tables with all of the ‘hard coded’ (non-formula) columns, then have another table in a folder called ‘Formulas’ (I use ‘fx’) and in that one I reveal everything. You are right it would be nice if it was baked i…

+1 to this please :smile: Would make a big difference to productivity

I was playing around with this more and actually got pretty good results overriding some CSS to expand the formula editor: /* Allow a wider view */ .formula_builder--root--MsCMk97F { width: 800px; } /* Allow a bigger height - would be better to calc() this in relation to current y position, but…

Thanks for the discovery, Jami! Just one thing. I wouldn’t rely on those --MsCMk97F etc to stay forever as class name pieces. Those look like autogenerated (versioning?) suffixes that may change at any time. Rather use *[class^=formula_builder--root] selector that means “class attribute starts wit…

Thanks for the tip Paul, I didn’t think of using that kind of a selector. You are right, the hashy names of classes as such are very likely to change.

[image] Paul_Danyliuk: [class^=formula_builder--root] I thought this would be a great hack, however the CSS didn’t work. I did some research and it turns out you need to wrap the class in “double quotes”: [class^="formula_builder--root"] That’s the CSS. However I have not been able to get a…

For me the “starts with”-trick that @Paul_Danyliuk introduced works. At least for me it works with or without the double quotes. After a while trying to understand why your code I copy-pasted was not working I noticed few small problems and I managed to make it work. The form plugin used here cha…

@Jami_Haavisto you nailed it I was missing that double quote " and when added it fixed it 🤦 However that gave me width and pink but no height which is what I really desire. I was able to get that working with: div[class^=“editable–root”] {max-height: 420px;} Thanks this will make using Coda.io mu…

Better formula editor

Product Feedback

Paul_Danyliuk April 14, 2021, 7:25pm 31

To everyone on this thread — this is now live:

Topic		Replies	Views
Launched: Formula building, now bigger and better News from Coda	43	4483	October 12, 2021
Ability to make comments in formulas Product Feedback	22	1676	February 28, 2023
Expand Formula Editor Product Feedback	13	2509	November 3, 2022
Option to put the formula builder in full screen Product Feedback	25	645	May 4, 2026
[Request] Complex Coda Docs — Mapping them out for sustainability and continuous development Requests and Gigs	23	6653	June 7, 2022

Better formula editor

Related topics