10 More Reasons to Like Arbutus (91-100)

  1. Applications Menu loads shared procedures
  2. Copy and paste fields
  3. Match function supports arrays
  4. Average function
  5. Total function
  6. Maximum & Minimum functions support unlimited parameters
  7. Save Field
  8. NTOD function
  9. NTOT function
  10. 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.

See: All 100 Reasons – sorted by topic

91. Applications Menu loads shared procedures

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.

5-5-apps

 

92. Copy and paste fields

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.

5-5-copypaste

 

93. Match function supports arrays

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.

 

94. Average function

The Average function will take any number of values or array values and will return the average.

95. Total function

The Total function will take any number of values or array values and will return the total.

 

96. Maximum & Minimum functions support unlimited parameters

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.

97. Save Field

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.

 

98. NTOD 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.

 

99. NTOT function

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.

 

100. Re-arrange command field order, after selection

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.

5-5-updn

 

Want even more reasons to choose Arbutus?