Forum Discussion

fc's avatar
fc
Contributor
2 days ago

Update make dashboard table formatting dynamic from BR

Hi everyone, 

I currently have a dashboard that shows the following table:

the format of each field has been set in the SQL Table Editor settings, to allow the users to understand what fields can be updated.

Nevertheless, I would need to make sure that the format of certain columns changes depending on how the users populate the table. For example, if the user inputs "MANUAL" under the col TAG, I would like the field "New Target Account" to become yellow automatically upon saving. 

So far, I only managed to make the content of the other cells dynamic using this construct in the Dashboard Extender BR linked to the SQL Table Editor:

xfrow.ModifiedDataRow.Item("T_ACCOUNT_NEW")= "-----------------"

Is there something similar that allows to also change the formatting of the cells?

Thank you!

Dashboards

1 Reply

  • BenEppel's avatar
    BenEppel
    Contributor
    2 days ago

    I believe the formatting can only apply to all rows, so you wouldn't be able to have differing formatting between rows with different tags.

    I would recommend creating a button that pulls open a dialog box, and within the dialog dashboard, create a combo box/list box/radio group with Manual/Non Manual as the param values.

    Then have two embedded dashboards, one for manual, and one for Non Manual. Within each embedded dashboard, create components that allow the user to select values that you want in the table. Use the Manual/Non Manual param to determine which embedded dashboard to use. You could also create one dashboard and use an xfbr to control the visibility of the components.

    Then have a button that a user would select to insert all those selections into the table (Dashboard Extender BR) using SQL. If you want this to work with editing an existing row, you would need a primary key field in the table, and that column would need to be the bound parameter. Then you can use that row parameter to update the specific row within the SQL statement.