Dear support,

I have 2 questions:

Due to the different view modal with gravityform (new vs edit entry), I decided to manage it by SQL request and the tab editing. However, my fields need some validation rules. For example:

I have 2 date fields (date1 and date2) that have to follow this rule before saving in database:

• Both date must be in the current month
• date1 must be <= than date 2 

If the rule is not valid then an error must be displayed to the user.

The other question is for the show/hide columns. By using SQL request and editing functionality I have to get my ID column. However I don't want to this this column in the front-end. Even if I hide it in the tab, the user still have the choice to add it through the column visibility dropdown. (cf.attachment).

Thanks in advanced. 

I found in other tickets and documentation about the hook: 

wpdatatables_after_frontent_edit_row($formdata, $rowId, $tableId)

But it's seem to be called after the data has been updated in database :( 

I also found in some tickets the filter:

wpdatatables_filter_formdata_before_save($formdata, $tableId)

That seem to match to my needs but I'm not able to stop the update and display an error message.

Do you have have another hook/filter or solution that could match my needs?

Best,

Hello Aleksandar,

Thanks for the answer.

The hook allows me to get the data and to do my logic in order to valid or not the data. However, the hook must return the $formData otherwise the tab is frozen. 

EDIT:

I added into the wdtSaveTableFrontend function (which handles the edit ajax request) a new filter just before the db connection and save, in order to return $returnResult with error message. Then if the $returnResult has something in 'error' I skip all the database (connection and update) part. I got the error message  and the value is not updated as expect.

However I'm stuck because now in your ajax request, if the ajax is a success but the $returnResult var has in its error value something the script block the tab with an infinity loader... which is removed only is the value of this error is empty.

My question is now: Could you add a filter to make back-end validation of our fields (I did it with 3 lines of code)? And could you also handle the front-end error message without blocking all the tab?

Thanks

Hi,

If needed I can push the feature on your code versioning solution. Adding validation rules to datatables edditing is mandatory to me and this is the last part of my website.

Best,

Hello Aleksandar,

I test the data seized by the user regarding some logic. For example, I have 2 date field (date1 and date2) following those rules:

- date1 and date2 must be in current months

- date2 must be earlier or equal then date1.

If both condition are not validated, I want to display a custom error message to the user and not update ma db.

Take note that what I did can be do in better way :

In your wdt_ajax_actions.php I added into the "wdtSaveTableFrontend" function a new filter "wpdatatables_filter_formdata_validation_before_save" that must return the $returnResult var. Then I test if this var has no error message to follow the db connection and update. Here the code:

$formData = apply_filters('wpdatatables_filter_formdata_before_save', $formData, $tableId);
$returnResult=apply_filters('wpdatatables_filter_formdata_validation_before_save', $formData, $tableId, $returnResult,$idVal);
if(is_empty($returnResult['error'])) {    
// If the plugin is using WP DB
if (!(Connection::isSeparate($tableData->connection))){...}else{...}
}

Then in the wdt.frontend.js I added into the function doing the ajax request the following code to disable the infinite loader in case of success request with something in the error message: 

success: function(returnData) {
        $(tableDescription.selector + "_edit_dialog")
        .closest(".modal-dialog")
        .find(".wdt-preload-layer")
        .animateFadeOut();
        if (returnData.error == ""){...}
        else{
            wpDataTables[tableDescription.tableId].fnDraw(!1);
            $(  '.edit_table[aria-controls="' +    tableDescription.tableId +    '"]'
            ).addClass("disabled");
            wdtNotify(
                wpdatatables_edit_strings.error,
                returnData.error,
                "danger"
            );
        }

It's works for me but code skills are needed. 

I think it will be better to manage it on the column setting with a proper validation panel like you did with the conditional appearance column tab.

Best,