Calculation field vs JavaScript fields

71 views
Skip to first unread message

Walt

unread,
Nov 16, 2019, 6:08:26 PM11/16/19
to mementodatabase


Hi all,
Trying to figure out if  I want to use JS fields or calculations.
1. Does a calc field fire when the entry is updated/viewed/created and is there anyway to specify when it fires similar to JS fields
2. For a similar calculation should I expect JS or calc to be faster
Not sure how to make this decision, would appreciate some insight!

Bill Crews

unread,
Nov 16, 2019, 9:54:24 PM11/16/19
to Walt, mementodatabase
I think Calculation fields execute a bit faster, but I'm not sure. Also, you can pick fields & functions from lists, which makes things easier when you don't already know how to do something.

Otherwise, everything argues in favor of JavaScript fields...
1. It might very well be just as fast.
2. Using Calculation field functions can be very complex & difficult, once you start doing things beyond the most basic.
3. More people know some JavaScript; VERY few people know Memento's proprietary Calculation field script language.
4. Once you learn a little JavaScript, you can use that knowledge elsewhere, within & outside Memento.
5. If you share libraries & scripts with others, more of them are likely to already know the language.
6. Once you learn a few JavaScript functions, the pick lists no longer add much advantage.
7. Once you start learning JavaScript, you tend to continue learning more, extending far beyond the capabilities of Calculation field scripting.
8. You don't need to know much JavaScript at all -- just a tiny fraction of it -- none of all that stuff that's required to code a Web page, which is the main thing it's used for.
9. Once you've exhausted what you want to do with JavaScript fields, you've just barely begun to do what you can do with Memento Trigger & Action scripting, not to mention Data Source  scripting.

Scroll down to "Scripting, Calculation, & App Integration" at http://wiki.mementodatabase.com/index.php/Main_Page.

Also, look at the table of links at the bottom of any of the Scripting pages there, especially the links to Mozilla Developer Network (MDN) JavaScript pages, keeping in mind (again) that you don't need to learn any of that Web page, or Document Object Model (DOM), stuff and not all that much of the other stuff, either.

(I don't recommend you try using an app to learn JavaScript, cuz 95% of what they'll start to lead you through will be the Web page stuff you don't need to learn.)

If you need help on all this, don't hesitate to contact this forum in general or me in particular for customized assistance.


--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/b996a93e-9037-4319-aa77-ccd0c0fa8db3%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages