In the inspector palette we'd like to have a checkbox per field to allow math.
So if user types in "3+5" and presses return, we want to evaluate that value automatically (and safe) and store 8 as result.
Define "safe". Do you mean the field should guarantee that there will be no side effects (e.g. setting variables, setting data or making network connections via plugin)?
Why dont you just use a regular Text field to store your calculations in different records and then use Evaluate function?
we do that like this: if user has put in
as his first key, we try to calculate the result of the rest of his input. If the first key is something else than = we don´t do anything. All happens with field triggers.
Nice solution, intex!
we do this without "=" by checking if the entry is an algebraic equation - parsing happens on entering via keystroke triggers.
as soon as the entry can't be parsed as an algebraic equation it won't refuse the keystroke - for example 2+*3 would refuse to take the * ..
I liked the "begins-with =" because that was more in the UI/UX for Excel. The "=" means, watch out, I have a formula for you...
Retrieving data ...