calculation on custom fields

I have a structures table with 3 custom fields (all integer values in this case).


Is it possible to do a calculation on these fields and store the value in another field ? I tried to add a new chemicals term field with a formula something like this


field('f1')*100+field('f2')+field('f3)


but this gives me a 'Chemical terms expression is invalid' message





field('f1') seems to be valid syntax but the value (property) does not appear in the new field





I've read http://www.chemaxon.com/chemterms.html and related documentation but am getting nowhere.





Any ideas?

Sorry, I just read this http://www.chemaxon.com/forum/ftopic3018.html


seems to be the same question.


I'll be patient

Yes, this is on our TODO list.





Tim