Welcome to the ninth article as an update to the series of articles that explains in detail the steps to add a user defined custom field to a window using Modifier, Report Writer and GP Power Tools to add the business logic.
The series should be read in order starting with the introduction article:
In this article we will provide updates to the project adding the modified window and report to the project. In the following articles we will show how to use manual SQL tables and then GPPT Custom Tables (even better than manual SQL tables).
To understand the original version of the project which adds an Item URL field to the Item Maintenance window and stores the additional field in the DUOS (Dynamic User Object Store – SY90000 table), please review the earlier articles in this series starting with the Introduction.
An updated version of the original project is included here with the Modified IV_Item_Maintenance window and Detailed Item List report included as part of the project. Including the Customization Maintenance package with the project was not available when the original article series was published.
Here is the ITEM URL Project
Trigger ITEM URL BUTTON
This trigger is used with the hidden zoom button used to drill down and open a web browser to the address stored in the Item URL field. It uses a different method depending on if it is running on the Web Client or not.
Trigger ITEM URL DEL
This trigger runs after the IV_Item_MSTR table delete event and delete the DUOS records.
Trigger ITEM URL FIELD
This trigger runs when the Item URL field is entered and ensures that the https:// prefix has been added.
Trigger ITEM URL READ
This trigger runs after Display Existing Record Field Change event and reads the DUOS records and populates the Item URL field
Trigger ITEM URL SAVE
This trigger runs after the Save Record Field Change event and saves the DUOS records from the data read from the Item URL field.
Runtime Execute Script ITEM URL GET
This script works with the rw_TableHeaderString Report Writer function to return the Item URL field to a report. It has been used with the Detailed Item List modified report. It will read the data from the DUOS records.
Downloading and Installing
Download the example code, import using the Project Setup window (without any project showing, select the path to the xml file and click Import):
The code will be active on next login or after switching companies, or you can start the triggers manually from the Project Setup window.
More Information
For more information see:
- #GPPT Beginner’s Guide to Adding Custom Fields – Introduction
- #GPPT Beginner’s Guide to Adding Custom Fields – Update: Including the Modified Resources (this article)
- #GPPT Beginner’s Guide to Adding Custom Fields – Update: Using manual SQL tables
- #GPPT Beginner’s Guide to Adding Custom Fields – Update: Using Custom Tables
- GP Power Tools Portal: https://winthropdc.com/GPPT
- GP Power Tools Samples: https://winthropdc.com/GPPT/Samples
- GP Power Tools Videos: https://winthropdc.com/GPPT/Videos
Hope you find these examples useful.
David
This article was originally posted on https://www.winthropdc.com/blog.
2 thoughts on “#GPPT Beginner’s Guide to Adding Custom Fields – Update: Including the Modified Resources”