Method:Classic General Q&A

Re: Update Grid Action

Method_Jason — Thu, 11 Apr 2013 21:30:35 GMT

JohnnyW:

Is it possible to dynamically change the ability to edit rows based on user or role? Or would this require a completely new grid?

Sorry Johnny I must have missed this post.

Unfortunately, this is not possible. Like you said, you would have to create two grids, one editable and one not. From here you may set actions that will hide/show the object/section depending on if the user is the admin or not. In my screenshot below, I put the Show/Hide Field/Object action inside the conditional statement. Hope this helps!

- Jason

Re: Update Grid Action

jnoneiliv1 — Thu, 11 Apr 2013 19:22:03 GMT

Cool. I'll give it a try.

James

Re: Update Grid Action

Method_Jason — Thu, 11 Apr 2013 18:54:06 GMT

James,

I have tested it and it works the way I described earlier. The Save Grid Row action no longer exists, it has been replaced by Save Grid. Let me know if you still experience unexpected behaviour with these actions but I think you'll find that the behaviour is different then from when you started this thread.

- Jason

Re: Update Grid Action

jnoneiliv1 — Thu, 11 Apr 2013 17:11:29 GMT

Jason,

Have you tested this to see if it works this way? This thread was started when I found those Actions did not work as documented or expected. I haven't gone back to try these again. I would really like to be able to use Save Grid Row in conjunction with Insert New Row.

James

Re: Update Grid Action

Method_Jason — Thu, 11 Apr 2013 16:00:14 GMT

Thanks for all of the insight! Here are my thoughts:

Refresh Grid action: This action refreshes the grid but does not save it. For example, if your grid is editable and you make a change in the grid without saving, the refresh grid action will refresh the grid to the previous state before the edit.

Save Grid action: The grid will not save unless this action is performed. If you make a change in an editable grid and then change the active record without saving, you will lose the change and it will revert back to the original state.

Update link: This is simply a Save and Refresh grid action combined.

I would suggest using a Save all Sections action before you leave the screen to make sure that the entire record is saved.

- Jason

Re: Update Grid Action

jnoneiliv1 — Thu, 11 Apr 2013 14:17:52 GMT

Oh, and yes, I never really sorted out the difference between refresh, update, and save and I ended up just using save as a heavy hammer to get the grid back to where I needed it for the next user or action sequence operation. The documentation has not tended to provide detailed technical information as to how to choose among those actions.

Also, my suspicion is that some of those Grid actions were originally coded expecting a performance improvement if Saves are avoided. Refresh or Update may have done something within the context of the browser cache of the grid contents without going to the server and back. But, the Save action is so fast that I see no performance problem using Saves recursively in a grid edit session with a user interaction.

The more experience I have with screen design for user interaction the more I like frequent saves. Getting users to understand their changes are not committed until a save is performed harder to do than to allow them to change something after the save occurs and I tend to see some odd results when a full save isn't performed at key points. There are some values like Totals on Orders and Invoices that only come from Quickbooks. When a user enters a Quantity and a Price, the Amount is always a calculated value and the save must synch back to QB to get the result. This is a nice feature as QB is holding onto some data integrity for certain financial calculations.

Anyway, for what it's worth, I think full saves are good and folks shouldn't be afraid to use them liberally.

Cheers,

James

Re: Update Grid Action

jnoneiliv1 — Thu, 11 Apr 2013 14:07:16 GMT

Thanks Jason. I'm sure I tried those actions but I'll try again, there's been a lot of grid enhancements in the last year or so. I was trying to update the grid, then insert a new row based on text change or other cell editing by the user. The results were not predictible. Somewhat understandably as the grid may be thinking the user is still in edit focus on a cell, etc. depending on cursor location when the text change event fires, etc.

Re: Update Grid Action

JohnnyW — Thu, 11 Apr 2013 04:42:47 GMT

James,

Thanks for your reply to the earlier post. After reading through the thread, I believe it's possible that some changes have been made within Method actions with regard to the Update button. It appears that the Update button is giving me the same results as a call to the Save Grid action.

I've also tried combining the Save Grid and Refresh Grid actions as well as using only the Refresh Grid action, but so far I can't discern a difference between the two. So far it appears as if Save Grid = Refresh Grid = Update button.

Maybe Jason could shed some light on this for us.

Thanks,

Johnny

Re: Update Grid Action

JohnnyW — Thu, 11 Apr 2013 02:13:06 GMT

Jason,

Thanks for the response. That brings up another question...

Is it possible to dynamically change the ability to edit rows based on user or role? Or would this require a completely new grid?

Re: Update Grid Action

Method_Jason — Wed, 10 Apr 2013 20:34:00 GMT

Johnny,

There hasn't been any documentation released on the Update button in an editable grid. This link is not customizable as it is hard coded into the grid. The only way to hide this link is if you choose Do not allow editing of rows on Step 5 of 9 of the Grid Wizard. Does this help?

James,

I believe the Update link is simply a Save Grid action and a Refresh Grid action.

- Jason

Re: Update Grid Action

jnoneiliv1 — Tue, 09 Apr 2013 20:10:50 GMT

Down the rabbit hole you go. I think I gave up on trying to use grid update in Actions. I couldn't get it to work. I either had to have the user do it by the button or have the action sequence save all sections.

Good luck. I'd be glad to know how this works out. I have a clickable link within a button that does some calculations for pricing but that link is not active until the grid is updated. I could not get this to work programatically reliably using anything less than save all sections, or maybe save section, but not the action button for grid update. Or, I might not remember correctly, but I know I couldn't get it to work and it's because that functionality did not work as documented.

Cheers,

James

Re: Update Grid Action

JohnnyW — Tue, 09 Apr 2013 19:48:43 GMT

Does anyone know if there has been any documentation released on how the Update button on the grid works. I'm working with grids now, and I've found that in most cases, I would rather control the updating of the grid myself, rather than let the user press the update button. So I guess I have two questions:

1) Is there any way to hide or disable the Update button?

2) Is there any documentation on exactly what the update button is doing?

Thanks!

Re: Update Grid Action

jnoneiliv1 — Wed, 14 Sep 2011 13:35:18 GMT

Thanks, that's great news.

Re: Update Grid Action

Method_Michael — Tue, 13 Sep 2011 21:56:18 GMT

James-

We have been made aware of some of the 'wonky' things happening on the grids and our next publish should address these.

-Michael

Re: Update Grid Action

jnoneiliv1 — Tue, 13 Sep 2011 21:39:25 GMT

Michael,

Thanks for the update. This should work also. I'm still curious as to how the functionality of the Update link automatically provided at the bottom of the Grid is simulated in an action sequence. Maybe this new version of Save Grid Row will do this?

I am also getting weird calculation results for some cells in the grid where a cell like Total Weight will sometimes not update with the calculated result until AFTER the grid is updated and the calculation sequence is re-initiated. Again, only sometimes. There is something wonky in the grid.

Cheers,

James