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
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
Longer answer is yes but that involves hacking the actions
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
Welcome to the Community, @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
system
Closed
November 8, 2022, 12:33pm
5
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.