Custom edit field special properties

MoneyWorks Gold 8 allows you to create new windows that can be used with scripts. The UI form editor allows you to set the type (text/number/date) and numeric format of an edit field, but there are some other useful modes … Continue reading

Posted in MWScript | Comments Off on Custom edit field special properties

Sorting Filters

In MoneyWorks Gold 7.1.4, it is now possible to use CreateSelection() with the "*Found" and "*Highlight" metasearches to access more tables and list windows than were previously possible (e.g. department, offledger, filter). Access to the transaction selection in the Creditor … Continue reading

Posted in Sample Code | Comments Off on Sorting Filters

Make the Bank Transfer dialog remember the From and To accounts

If you are doing a lot of bank transfers, you might want to have one or both of the bank account popups remember their settings, at least for the session. Here's a script that does that. constant meta = "Cognito … Continue reading

Posted in MWScript, Tip du Jour | Comments Off on Make the Bank Transfer dialog remember the From and To accounts

Script Editor automatic backups

When you activate a script in the script editor (which compiles and loads the script), the script editor first saves a backup of the script's text into the standard plugins† Scripts folder. In the event that your script goes into … Continue reading

Posted in MWScript, Tip du Jour | Comments Off on Script Editor automatic backups

Base64 encoding

Connecting to the REST service on a Datacentre requires Authorization headers that need to be base64 encoded. As of v7.1.3 there is no built-in intrinsic function to do base64 encoding, so here's a utility routine to do it in MWScript … Continue reading

Posted in MWScript, Sample Code | Comments Off on Base64 encoding

MWScript

MoneyWorks native scripting language Rationale Since v4.1, MoneyWorks has supported customisation via platform-specific attached helper scripts. On Mac, this was via a Helper.scpt Applescript in the Scripts folder, and on Windows via a slightly more convoluted mechanism to invoke a … Continue reading

Posted in MWScript | Comments Off on MWScript

Persistent Data and DevKeys

In MoneyWorks 7 we introduced a new internal data table called "User2", specifically so that mwScripts and external plug-ins can store their own persistent data in a MoneyWorks database. However with diverse scripts each storing their own data, there is … Continue reading

Posted in Database, MWScript | Comments Off on Persistent Data and DevKeys

PostedTransactions

PostedTransactions (selection) The user has just posted the transactions. This will be called for both electively and non-electively posted transactions.

Posted in Handlers | Comments Off on PostedTransactions

AllowPostTransactions

AllowPostTransactions (selection) The user is about to (electively) post transactions. Return 0 to abort posting. If you return 0, none of the transactions in the selection will be posted. If you do this, you should display some feedback to the … Continue reading

Posted in Handlers | Comments Off on AllowPostTransactions

UserLoggingOut

UserLoggingOut The user is logging out. You can use this opportunity to save user-specific state.

Posted in Handlers | Comments Off on UserLoggingOut