cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Custom Properties in Contracts (FNM On-Prem)

dbeckner
By Level 10 Champion
Level 10 Champion

I have added many custom properties to objects in FNM. I have never successfully added them to the contract object. Currently I am able to add a new tab to the contract object but adding a section or field to that tab or any existing tab for that matter never shows up. Everything looks good in the database tables where this is stored and if i change the object ID from contract to another type like purchases and update the section name it will show up there. Can anyone confirm that it is possible to add to the contracts object and also share their code for adding that if willing?

Here is the code I am using:

-- This works and adds a tab
EXEC dbo.AddTabToWebUIPropertiesPage
        @TargetTypeID = 10,
        @Name = 'Custom_TabNSDDataCall',
        @CultureType = 'en-US',
        @DisplayNameInPage = 'NSD Data Call',
        @UIInsertTypeID = 2,
        @RelativeTabName = 'Tab_General'

-- Attempt to add a custom section to the new custom tab doesnt display anything in the WebUI
EXEC dbo.AddSectionToWebUIPropertiesPage
@TargetTypeID = 10,
@Name = 'Section_NSDSchedule',
@CultureType = 'en-US',
@DisplayNameInPage = 'NSD Schedule',
@TabName = 'Custom_TabNSDDataCall',
@UIInsertTypeID = 3,
@RelativePositionTo = 'Custom_TabNSDDataCall'


-- Attempt to add a custom section to the General tab doesnt display anything in the WebUI
EXEC dbo.AddSectionToWebUIPropertiesPage
@TargetTypeID = 10,
@Name = 'Section_ABCD',
@CultureType = 'en-US',
@DisplayNameInPage = 'ABCD',
@TabName = 'Tab_General',
@UIInsertTypeID = 1,
@RelativePositionTo = 'Section_Payments'
(1) Solution

In the snippet that adds the Section, try adding:

@ExcludeTargetSubTypeIDs='',

 I know the SP defaults this parameter to NULL, but that looks a bit buggy to me and the following works for me:

-- Attempt to add a custom section to the new custom tab doesnt display anything in the WebUI
EXEC dbo.AddSectionToWebUIPropertiesPage
@ExcludeTargetSubTypeIDs='',
@TargetTypeID = 10,
@Name = 'Section_NSDSchedule',
@CultureType = 'en-US',
@DisplayNameInPage = 'NSD Schedule',
@TabName = 'Custom_TabNSDDataCall',
@UIInsertTypeID = 2,
@RelativePositionTo = 'Custom_TabNSDDataCall'

 

View solution in original post

(2) Replies

In the snippet that adds the Section, try adding:

@ExcludeTargetSubTypeIDs='',

 I know the SP defaults this parameter to NULL, but that looks a bit buggy to me and the following works for me:

-- Attempt to add a custom section to the new custom tab doesnt display anything in the WebUI
EXEC dbo.AddSectionToWebUIPropertiesPage
@ExcludeTargetSubTypeIDs='',
@TargetTypeID = 10,
@Name = 'Section_NSDSchedule',
@CultureType = 'en-US',
@DisplayNameInPage = 'NSD Schedule',
@TabName = 'Custom_TabNSDDataCall',
@UIInsertTypeID = 2,
@RelativePositionTo = 'Custom_TabNSDDataCall'

 

You nailed it. I can't believe it was that simple. Thanks @MurrayPeters !