It would be really useful if there was some validation when saving a formula, it doesn’t need to give any specific error but just simply something to say “Hey, this formula won’t work!” would be great.
I’ve been migrating some of my formulas from AT to Noloco’s native tables and it’s been quite the headache because they work so differently and there have been quite a lot of complex formulas with nested if statements not working as intended, and the whole process is just made longer by having to save the formula, close the modal, scroll along to see if the field is showing correct info now… If it just told me when trying to save that something is broken it would save so much time.
Hey @EthosLuke we do have validation in place if you insert something completely invalid, but I suppose there could be holes in it…
One thing that I would love your opinion on, is whether a preview would help with this process? If you could either preview a few rows at once, or even just choose between one of the rows on screen and see the output
I had noticed it does validate for very simple and obviously wrong formulas but anything more complex (e.g. a function that doesn’t exist (such as MIN()) inside an if statement) doesn’t throw any errors.
Honestly having a preview would be amazing and probably negate the need for the enhanced validation as we’d immediately see if we’re getting the expected results without having to save, scroll back along to find the field again, etc.
