slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Opportunity Product Grid: Make columns read only case by case

Marc Johnson
Posts: 252

Opportunity Product Grid: Make columns read only case by case Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 May 08 3:13 PM

Ok so we have some custom columns in the Opp Product grid. I can see where I could make an entire column read only, however I just want to make a cell read only, depending on a specific product. Basically we have a few products that need to collect additional sales data but none of the other products do, so I'd like to lock them down.

Thoughts on how to do this, without dramatically rewriting the 'out of the box' logic?

[Reply][Quote]

RJ Samp
Posts: 973

Re: Opportunity Product Grid: Make columns read only case by case Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 May 08 9:28 AM

Unfortunately the GUI OOTB goes against this.....when the user types in a grid cell and then leaves the cell, SLX fires off a SQL statement for (or against in this case) you IMMEDIATELY.

Try this..... events
OnSelectNode
OnRowSelect
onSingleClick

DIM PID, ITS_LOCKED
PID = Grid.GetCurrentFIELD("PRODUCTID")
IF Grid.GetCurrentField("I KNOW I WANT THIS LOCKED") = "Locked Down" THEN
''' obviously this can go after the Product Table with a SQL statement if need be.....

grid.ROWSELECT = TRUE

ELSE
grid.ROWSELECT = FALSE
END IF
END SUB

Basically you are trying to lock down inline grid editing on these special case Products.....
IF they want to edit them, then allow a Double Click to pop the edit view......

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/23/2025 2:19:30 PM