How to Reload/Update other fields automatically after Editing one field in row using Excel cells

QuestionsHow to Reload/Update other fields automatically after Editing one field in row using Excel cells
Tony Wolsey asked 4 years ago

Hello

I am using grid displayed as Excel-like cells. When I edit one field of a record, how can I get other fields of the same record to also update after the change?

Reloadedit not working in Excel-like grid

thanks

Tony

5 Answers
Abu Ghufran Staff answered 4 years ago

To update single row only is custom work. You can reload whole grid on save. If it does not work for your case, let me know.

Here list1 is grid id.

$opt[“afterSaveCell”] = “function(){ setTimeout(()=>{ jQuery(‘#list1‘).trigger(‘reloadGrid’, [{current:true}]);},500) }”;

$g->set_options($opt);

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Tony Wolsey answered 4 years ago

thank you Abu

I updated the $opt with $grid and it worked perfectly.

$grid[“afterSaveCell”] = “function(){ setTimeout(()=>{ jQuery(‘#list1’).trigger(‘reloadGrid’, [{current:true}]);},500) }”;

 

thank you

Tony

Tony Wolsey answered 4 years ago

Hi Abu

There is some strange behavior that after editing a field and hitting enter to accept the update. When I hit enter to accept the update/refresh and move to the next field below, the previous record remains selected with the checkbox on the left side.

thanks

Tony

Tony Wolsey answered 4 years ago

Hi Abu

When I select a cell in Excel format to edit, the entire row gets selected with the checkbox. When I hit enter to move to the next record, the previous record remains selected and the next record is also selected.

thanks

Tony

Abu Ghufran Staff answered 4 years ago

Sorry for the delay, you can email me (at [email protected]) grid code for review. In basic excel view demo, after enabling multiselect:true … i’m unable to re-generate this issue.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Your Answer

20 + 11 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?