The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

jwagner's avatar
jwagner
New Contributor III
2 years ago
Solved

Updating a OneStream Application Table through Dashboard Extender/SQL Table Editor

Looking for some sample code to help me get started with adding in a new row through the SQL Table Editor, where a few of the columns are prepopulated on row addition through Dashboard Extender BR Co...
  • jwagner's avatar
    2 years ago

    I was able to find a bit of a workaround for this.  I created a Dashboard String Function which returns the current row count + 1 as a literal parameter, and I am using that as the default value for the column format aka a new row default for the row column.  (Which is a XFBR String named |!DivisionMapping_RowCount!|)

    DashboardStringFunction Code 

    Workspace Parameter Configuration 

    SQL Table Editor Column Format Configuration