Editable canvas formula result

[Sarah_Arminta]

So I love love love inline (canvas) formulas. I’m creating a daily journal page and I just thought of a feature I would use a lot.

I have a text column in my daily tracking page for sleep comments. In order to enter those in my journal page I am creating a view and filtering down to today’s row and only showing the sleep comment column.

If I could have an inline formula =[Today's Daily Tracking].[Sleep comments], where I could also edit the result area, it would be so much cleaner to enter my data. Instead of having a whole bunch of super filtered views on my page, I can just put editable inline formulas wherever I need them.

Maybe there are some situations where being able to edit that info so easily isn’t desirable, so make it an option you can select while entering the formula.

Just a thought.

[Connor_McCormick]

I am begging for this feature.

[Johg_Ananda]

@Sarah_Arminta Canvas formulas are awesome AND you can do so much more with a table. By using the @ row mention + hiding the column headers & gridlines you can get nearly the same effect as a canvas formula with the added benefit that you could create it such that you can edit the values as you described.

[Connor_McCormick]

Not if you want to use the content from your table in a formula and edit it at the same time.

[Johg_Ananda]

I don’t understand, can you give an example? The question was how to edit the data and see it presented at the same time.

[Connor_McCormick]

This is a good example of where it would be useful:

Content Formatting / Text nesting / Dynamic text generation / Infinite Section Nesting

This to me would solve a whole host of issues and I stand firmly behind the feature request. From my perspective, we tend to prefer to use a single table for as a Glossary which then has either has competing definitions in the table and in the section - or an uneditable part in the section with no easy way to click through to the underlying row. (if the definition is displayed through a formula) Vote for it as a feature request here as well: https://coda.io/d/Year-of-the-Maker-Webinar_d_-VZP3…

Essentially, any time you are generating a document it would be nice to be able to edit the content that is generated without having to go back to the source table.