The Windward Studio

Windward Blog Home

Windward Features in Progress: Version 14.1

by
Posted on 06/25/2015

Please Share This

 

We’re on the cusp of releasing Windward version 14, so you know what that means — it’s time to talk about version 14.1!

Here are the items we’re working on:

Advanced Data Source Interface for OData, REST and URL Connections

REST LogoMany have asked us to add all types of customizations to our current data source connection window, and we have responded to the call by adding additional security implementations for each. We’re also creating a custom advanced data source interface that will allow you to pass your own parameters and authorization tokens that can be executed on the initial connection or each time a transaction or query is made.

Expanded OData Functionality

OData LogoWe are adding some highly requested features such as grouping, multi-tenancy secured authentication and an HTTP injection security token for each individual session, as well as variable selection for use with an OData data source. This will make OData’s usage more universal with custom security protocols.

Many Macro Additions

autotag macrosYou requested more macro formulas and we have responded. We are implementing macros for the following genres.

  • Date and Time
  • Conditional Logic
  • Math and Trigonometry
  • Text and String Functions

(Feel free to browse the full list at the end of this post.)

Side-by-Side forEach Loops in the Same Excel Spreadsheet

Microsoft_ExcelPreviously forEach loops in Excel spreadsheets could only be placed vertically before or after an already existing loop.   We will add support so that you can place forEach loops in block mode horizontally next to each other in neighboring columns. This means greater output flexibility when generating tables in Excel spreadsheets and better looking reports.

Future Features

We’re already hard at work on features that will be presented in upcoming versions. You can read all about these enhancements in our blog post The Windward Features Roadmap.

**********

The Macros List

Date/Time

  • DATE
  • DATEVALUE
  • DAY
  • DAYS
  • FROMNOW
  • HOUR
  • MINUTE
  • MONTH
  • NOW
  • SECOND
  • TIME
  • TIMEVALUE
  • TODAY
  • WEEKDAY
  • WEEKNUM
  • WORKDAY
  • WORKDAYINTL
  • YEAR
  • YEARFRAC

Conditional

  • ISNUMBER
  • AND
  • FALSE
  • SWITCH
  • IF
  • IFERROR
  • IFNA
  • NOT
  • OR
  • TRUE
  • XOR

Math/Trig

  • PRICE
  • ABS
  • BASE
  • CEILING
  • DECIMAL
  • DEGREES
  • FACT
  • FLOOR
  • ISEVEN
  • ISODD
  • ODD
  • PI
  • POWER
  • PRODUCT
  • QUOTIENT
  • RAND
  • RANDBETWEEN
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SEC
  • SQRT
  • SUBTOTAL
  • SUM
  • SUMIF
  • SUMPRODUCT
  • AVEDEV
  • AVERAGE
  • AVERAGEIF
  • COUNT
  • COUNTIF
  • FREQUENCY
  • MAX
  • MEDIAN
  • MIN
  • PERCENTILEEXC
  • PERCENTILEINC
  • PERCENTRANKEXC
  • PERCENTRANKINC
  • STANDARDIZE
  • STDEVA
  • STDEVP
  • STDEVPA
  • STDEVS

String Functions

  • CHAR
  • CONCATENATE
  • JOIN
  • LEFT
  • LEN
  • LOWER
  • MID
  • NUMBERVALUE
  • PROPER
  • REGEXEXTRACT
  • REGEXMATCH
  • REGEXREPLACE
  • REPLACE
  • RIGHT
  • SEARCH
  • SPLIT
  • SUBSTITUTE
  • TEXT
  • TRIM
  • UPPER

 

Please Share This



Author: Ryan Fligg

Ryan, Windward's Sales Engineer, has been with Windward since 2006 in many roles as a sales engineer, IT specialist and account executive. Ryan's background fuels his desire to guide Windward's product development. He now works on the future vision of Windward offerings through creating the product roadmap, responding to customer requests, and communicating what Windward is doing and where it’s headed.

Other posts by