Save validation for data cell in table

[100Rub]

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

[TheJonG · Accepted solution]

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.