10 More Reasons to Like Arbutus (91-100)
- Applications Menu loads shared procedures
- Copy and paste fields
- Match function supports arrays
- Average function
- Total function
- Maximum & Minimum functions support unlimited parameters
- Save Field
- NTOD function
- NTOT function
- Re-arrange command field order, after selection
Note: The following 10 More Reasons to Like Arbutus are aimed at technical or advanced users. Questions or comments? Please contact us.
Any shared procedures are automatically added to the Applications menu. The folder structure of your share is maintained in the menu, which allows easy support for standard processes, with no more complex .MNU files to maintain.
Similar fields may be copied and pasted between tables with a simple right-click. Any type of field may be copied and pasted (including computed fields), as well as multiple fields at one time.
The Match function will take an array of values, rather than needing to specify them individually. If ‘list’ is an array of 100 items to be matched against, ‘value’, match(value, list) will perform this comparison.
The Average function will take any number of values or array values and will return the average.
The Total function will take any number of values or array values and will return the total.
The Maximum function will take any number of values or array values and will return the largest, whereas the Minimum function will return the smallest.
Save Field allows an entire column from a table to be loaded into a variable array. The elements of this array can be accessed individually or as a set. This is a great way to automatically load dropdowns in dialog commands. It also offers an almost instantaneous alternative to the relatively slow RECOFFSET function.
The NTOD function will take a year, month, and day and turn them into a date. NTOD(2013, 12, 31) is New Year’s Eve 2013. This is particularly useful when creating dates from calculated data.
The NTOT function will take an hour, minute, and second, and turn them into a time. The time can be added to a date to create a datetime.
When selecting fields in a command dialog, you can use the “Move Up” and “Move Dn” to rearrange the order of the fields in the command. For long field lists, this is much simpler than re-selecting all the fields.
Want even more reasons to choose Arbutus?
- Contact us today to set up a 20-minute web demo