Article Details
Id:14752
Product:finPOWER Connect
Type:NEW
Version:3.00.07
Opened:26/07/2017
Closed:31/07/2017
Released:18/08/2017
Job: J019359

Scripts; finPOWER Connect Cloud Action; Grid columns and alternate views can now be defined

finPOWER Connect Cloud Action Scripts can now be used to define which columns appear in certain grids such as the Account Transactions grid.

The following code demonstrates how this is achieved:

If headerInfo.Pages.Exists("Transactions") Then
  With headerInfo.Pages.ItemByPageId("Transactions")
    With .Grid1Layout
      ' Add Columns with a Priority
      With .Columns
        .Add("Date", 0)
        .Add("ElementIcon", 1)
        .Add("ElementId", 0)
        .Add("Balance", 0)
        .Add("Reference", 1)
        .Add("Notes", 3)
      End With
    End With

    ' Alternate Grid Layouts
    With .Grid1AlternateLayouts.Add("Overdues", "Overdue Focused")
      .Columns.FromCsvString("Date,ElementId,Balance,Overdue,BalanceOverdue")
    End With

    With .Grid1AlternateLayouts.Add("Dates", "Date Focused")
      .Columns.FromCsvString("Date,Value,Balance")
    End With
  End With
End If

In finPOWER Connect Cloud, right-clicking a grid header will now do the following:

  • Display a list of available views (if applicable).
  • Display a "Grid Information" report that allows developers to see available Column Keys (only when signed in as an Administrator).