Feature idea: Test field in formula editor

When trying to find out where exactly the issue is with a formula that does not give me the output it should, I like to test sub-parts of it to see what their output is. to do that I would love to copy-paste a sub-part into a test field. (without having to first paste the whole formula somewhere else to still have it and then delete the parts i dont want to test)

Hi there :waving_hand:

Thank you for your feedback!
Would you mind creating a feedback ticket so our dev team can review it?

For formulas like these, where the complexity is high, I tend to use the JavaScript option, it lets you do the same, but more cleaner and you can test and run even per partes.

1 Like

Or just being able to format the formula with spaces/tabspace like usual code would be nice, so we can visually break up the one-line-code

I agree with Boberto that javascript is generally better once it gets complex. But I do have a few formulas like this what I do to test is you can chuck a // in front of your current formula this essentially comments out that part and you add any little snippet you want in front of the // to test

Example:

4 Likes

this is brilliant, thank you!!!

1 Like