Method:Classic General Q&A

Re: Updating multiple grid fields as one is edited.

Method_Jason — Thu, 11 Apr 2013 13:39:36 GMT

Yes, this would make sense. You could even put a Save Grid action and a Refresh Grid action in the same action set before you retrieve the values. This might be more efficient because you wouldn't have to remember to click Update or Save.

- Jason

Re: Updating multiple grid fields as one is edited.

JohnnyW — Thu, 11 Apr 2013 02:18:29 GMT

Jason,

This is very helpful. I noticed some weird behavior while retrieving values from a grid row. I would manually change a field, such as quantity, tab out and later call an action to retrieve the value from quantity, which retrieved the previous value. I suppose the solution is to always save and refresh the grid before making a call to retrieve values. Am I making sense?

Re: Updating multiple grid fields as one is edited.

Method_Jason — Wed, 10 Apr 2013 20:48:27 GMT

I tested this a little further and found there is a difference between Actions Before Edit and Actions After Edit. Both actions are in fact triggered by saving or updating the grid, but there is a difference between which values the actions will pull.

For example, I used a Retrieve Value from Table action on both Actions Before Edit and Actions After Edit. I retrieved the Quantity from the EstimateLine table of the active recordID on the Estimate screen. If you edit the quantity on the grid and then press Update, the Actions Before Edit will pull the original quantity before the edit and the Actions After Edit will pull the new quantity after the edit.

Hope this makes sense.

- Jason

Re: Updating multiple grid fields as one is edited.

Method_Jason — Wed, 10 Apr 2013 16:25:32 GMT

Hi Johnny,

You are right in that the Edit... caption no longer exists and should be removed from the Grid Wizard. When Editing takes place directly in the grid is selected you can directly edit the grid without having to click the caption. In my testing, it seems that the Actions Before Edit and Actions After Edit are both triggered when you click Update on the grid or when you save the screen. This seems like it is not the correct behaviour so I will submit a ticket to the team to address the issue and update you when I hear back.

- Jason

Re: Updating multiple grid fields as one is edited.

JohnnyW — Tue, 09 Apr 2013 19:42:13 GMT

While working with grids, I've noticed that Step 5 of the grid configuration wizard asks about Editing abilities. If you choose "Allow editing directly in the table" it gives you the option to type in an edit caption. However, I don't see where this caption would show up, as was mentioned in a previous post. Is this just something that hasn't been removed yet?

Also, there are two action events available for editing: After edit and before edit. I'm guessing that because there is no longer a link caption to initiate these events that they are also deprecated. If so, removing them from the wizard may avoid confusion. I did spend a little bit of time programming actions to be performed "after edit" thinking that perhaps a tab out of any cell on the grid following an edit would initiate this actionl. I now realize that it's function may have been tied to this missing edit link. Please let me know if I'm mistaken.

Re: Updating multiple grid fields as one is edited.

Method_Michael — Fri, 27 Jan 2012 16:18:59 GMT

viret56-

viret56:
Editing is allowed in the grid ('Editing takes place directly in the grid' is selected). The caption for the edit link is 'Edit...'. However, I see not 'Edit...' on the grid. I can edit directly in the fields. Apparently, javascript is capturing clicks and keypresses while editing the fields.Where is the 'Edit...' link? Why is it not showing on the Grid?Is the javascript associated with the field preventing the actions I defined from executing?

I am pretty sure that the Edit... on a grid is an old feature that no longer exists, previosuly you had to click Edit before you were able to edit a grid.

viret56:
The Gain Focus and Lose Focus actions work. I will do my work there. I am still curious that the Text Changed actions are not executing. If you have insight, I would appreciated understanding more of how these grids were programmed.

The Text Changed event only executes when the text is changed to be something different but it seems to not be working on grids. I will put in a ticket for this and update this forum post once I have more information or when the issue is resolved.

The Text Changed event still works on no grid fields from the looks of it.

-Michael

Re: Updating multiple grid fields as one is edited.

viret56 — Thu, 26 Jan 2012 16:24:28 GMT

The Gain Focus and Lose Focus actions work. I will do my work there. I am still curious that the Text Changed actions are not executing. If you have insight, I would appreciated understanding more of how these grids were programmed.

Re: Updating multiple grid fields as one is edited.

viret56 — Thu, 26 Jan 2012 16:11:34 GMT

Editing is allowed in the grid ('Editing takes place directly in the grid' is selected). The caption for the edit link is 'Edit...'. However, I see not 'Edit...' on the grid. I can edit directly in the fields. Apparently, javascript is capturing clicks and keypresses while editing the fields.

Where is the 'Edit...' link? Why is it not showing on the Grid?

Is the javascript associated with the field preventing the actions I defined from executing?

Updating multiple grid fields as one is edited.

viret56 — Thu, 26 Jan 2012 15:42:46 GMT

I am customizing the New / Edit Estimate screen. I have added a Subtotal field to the EstimateLine grid. Among other actions, I want the Subtotal field to update when I change the Quatity or the Rate. I have added actions to the Quantity field but no actions are executed. I see actions for the Item field. They are executed whenever a different item is selected.

Why are the Quantity field actions not executing?