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: Adding an additional field to Add Edit Product

Marc Johnson
Posts: 252

Adding an additional field to Add Edit Product Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Jun 08 1:32 PM

I've added a new text field and modified the insert/update scripts in the form code (Add Edit Product). I can enter data and it'll store in the database but I cannot see where in the code the data is pushed into the fields to display. I'm probably missing something simple but I'm currently stumped. How are the fields filled in?

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Adding an additional field to Add Edit Product Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jun 08 3:05 AM

Yes, change these areas:

==========================================
"Simply" adding a new field to OppProduct:
==========================================

Form: Opportunity:Products
--------------------------
Sub PopulateDataGrid : modify to include col in sql, and the grdProducts
Sub CommitChanges : Modify to include col in sql, and the update rs

Form: System:Insert Opportunity
------------------------------
Sub SaveOpportunityProductInfo( )

Script: System:Insert Opportunity Common
----------------------------------------
Sub DefineProductsGrid(oppID) : modify to include new section detailing new column
Function CreateProductsRSStructure : modify to include new column
Function DoGridCalculations(Sender, FieldName, Value, OppID)
: Modify to include within loop/case the new field
If strCrntRecord = .Fields("KEYFIELDID").Value Then
.Fields("yourfieldhere").Value = Value
End If
Sub SaveOpportunityProductInfo( )
Sub RemoveProducts( )

Form: System:Add Opportunity Product
------------------------------------
Sub AddProductToGrid(objRS, intQty) : Modify to include any defaults
Sub UpdateCurrentProduct( )
Sub AddDeleteProductToDB( )

[Reply][Quote]

John Foster
Posts: 18

Re: Adding an additional field to Add Edit Product Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jun 08 6:48 AM

The Add Edit Product form is populated by the Manage Products form.

[Reply][Quote]

Marc Johnson
Posts: 252

Re: Adding an additional field to Add Edit Product Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jun 08 9:34 AM

Thanks John, that worked for me. I should have looked at that before.

[Reply][Quote]

Marc Johnson
Posts: 252

Re: Adding an additional field to Add Edit Product Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jun 08 9:35 AM

Thanks Mike. You missed the mark, but great info any way.

[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/24/2025 7:09:38 AM