Increase number by decimal
I thought I posted this but, can't find it so here we go again...
I have a version number field, which when I create a new record I need to automatically increase by 0.1. I've tried it with the
let field := whole max(field name) + 0.1
but it doesn't want to work :/
Try this (not tested...)
let m := max((select YourTable).YourField);
YourField:= m + 0.1
A mix of what you offered (adding in the extra brackets) and also changing the location of the formula worked. I had it in the 'on create' of my table which... didn't work because it had no way of identifying the current record haha.
So, I've so far added the formula to my 'add spec sheet' button and will also add it to the 'revise spec sheet button'. Its working a treat :)
- 3 yrs agoLast active