Method Community

 I know how to set the default value on a screen field but can't figure out how to do the same for a grid field.  Any assistance would be much appreciated.

-Paulette

Hi Paulette,

A grid is just a visual representation of the data from the table and by default, the grids are read-only. I assume that you have customized the grid to allow for editing and new entries directly on the grid (steps 5 & 6 of grid properties) and that is why you are asking for a default value.

Unlike using fields on the screen, which can be customized to have a default value, this option does not currently exist for grid columns. Instead, we can trigger this with actions on another grid column. For example, put actions on the first grid column so that when a user makes a selection (or in some cases better to use loses focus) it will automatically enter values for other grid columns in that row.

As a side note, in most cases when you click on the link to add new lines it provides rows for several new lines to be added. Imagine you had set up a default value for the grid column (even though it is not a possible option right now) but you only wanted to add 1 new line. Clicking ‘update’ on the grid will try to insert all rows as new records since there is new data in all of them. This might not be such a good idea and it could conflict if you had required or unique fields set up.

Hope this helps,

 Thanks Val.  Makes perfect sense.