Forum Discussion

100Rub's avatar
100Rub
New Contributor III
5 months ago

Save validation for data cell in table

Hi,

How can we ensure that a record is only saved in the SQL table editor or grid view after all cells are filled? A message should be displayed to the user if any data cell is left blank when attempting to save. Is this functionality available in version 7.4?

Thanks

Dashboards
  • TheJonG's avatar
    TheJonG
    5 months ago

    Yes, this functionality is available by attaching a Dashboard Extender Rule to the SQL Editor Dashboard Component's 'Save Data Server Task' property. Below is an example from People Planning which is using this functionality when saving data on the register table.

    You can use the DashboardExtenderFunctionType.SqlTableEditorSaveData function type and check each field value and cancel the default save and also show a message to the user.

     

  • TheJonG's avatar
    TheJonG
    Contributor III
    5 months ago

    Yes, this functionality is available by attaching a Dashboard Extender Rule to the SQL Editor Dashboard Component's 'Save Data Server Task' property. Below is an example from People Planning which is using this functionality when saving data on the register table.

    You can use the DashboardExtenderFunctionType.SqlTableEditorSaveData function type and check each field value and cancel the default save and also show a message to the user.