Calculations inside format() function

[Quentin_Morel]

Hello, I’d like to create a little math oriented page & graphs.

I created a textbox with my formula “format-oriented”, such as “Power(10,{1})”
Then, I would like in a formula column of a table use something like this. Is there any to make coda understand that i’d like to re-calculate the “text” as a formula ?
Thanks

[Piet_Strydom]

HI Quentin,

Short answer is no.

But you could put the parameters for the formula in columns, and then write a column formula that refers to those columns.

If needed, you could also write a formulaMap() button that will create the rows with 5.1, 5.2 etc.

Regards
Rambling Pete

[Paul_Danyliuk]

Longer answer is yes but that involves hacking the actions

Solve math formula that is currently text in a cell using a button? (trying to make a calculator)

With some black magic, everything’s possible It’s not obvious though, and not a recommended solution. This takes a button, extracts its code and replaces a piece of that code with the expression. Then creates an Action object out of that new adjusted code and sets it on another button. Please mind that the code uses slightly different notation than Coda formulas, e.g. you cannot reference rows and columns like you’d do in Coda formula language. For literal numbers it works thoug…

To understand what I did here take this guide

Black magic

Welcome to the Community, @Quentin_Morel !

[Quentin_Morel]

Hi !
Thanks for these answer (and sorry for my own delay)…
I think I will have to study in depth your video Paul, but seems very interesing.

I’ll let you know about this little challenge.

Have a nice day