Thursday, 14 January 2016

Dependent Dropdown List in Netsuite

Dependent (or) Cascading Dropdown List in Netsuite:

First we need to create two Record Types.

For creating record types, we have to navigate to the menu Customization -->List,Records&Fields --> RecordTypes --> New.

Navigation for creating new Record Type.

1.Record type Games:

  • Enter the name of the record. In our example we create an record called Games.
  • Give the id for that record.
  • And go to the tab links and choose the Center,Section,Category,Label,InsertBefore. Links are used to display the records types created easily as of user convention.
  •  Example :Choose Center as Classic Center,Section as List,Category as Custom and Label as Games.
  • click save.
  • Enter the values in Games Record by navigating the menu Lists --> Custom -->Games --> New
  •    examples:
  •      1.Indoor Games
  •      2.Outdoor Games. 

           Step 1&2:

Games Record Type

      Step 3:

Custom Link for the Games Record

    Step 4:

Navigation for Games Record Type
  






    Step 5:

Adding values on Games Record


2. Record Type Sports:

  • Enter the name of the record. In our example we create an record called Sports.
  • Give the id for that record.
  • And go to the tab links and choose the Center,Section,Category,Label,Insertbefore. Links are used to display the records types created easily as of user convention.
  • Example :Choose Center as Classic Center,Section as List,Category as Custom and Label as Sports.
  • Click save.
  • Click Fields tab and enter the Name,Id for the field and choose the Type as List/Record and choose the List/Record as Games
  • Click Save
  • Enter the values in Sports Record by navigating the menu Lists --> Custom -->Sports --> New
  •    examples:
  •      1.Badminton
  •      2.Table Tennis.
  •      3.Squash.
  •      4.Cricket.
  •      5.Football.
  •      6.Hockey.

     Step 1:

Sports Record Type Creation

Step 2:

Custom link for sports record

Step 3:

Adding New Field on Sports Record.


Step 4:

Navigation for the Custom Record Sports





Step 5:

Adding new values for Sports Record

 and then we need to create the two Entity fields and we have to map the two record types we have created to the entity field.

 For Creating the Entity types, go to the menu Customization -->List,Records&Entity -->Entity -->New
Navigation for creating new Entity Field

  1.Entity Games.

  • Enter the name of the Entity. In our example we create an Entity called Games.
  • Give the id for that Entity.
  • Choose the Type as List/Record and choose the List/Record as Games
  • In Applies to tab,Click Customer,that means this entity will appear on customer record.
  • In Display tab click subtab as play sports,subatabs shows our content in separate area,it is easy to view.
  • Click save.   

Step 1 & 2:

Games Entity Field

Step 3:

Display tab for games entity field

         Custom Subtab Creation:

    Step 4:

Navigation for creation new subtab

Step 5:

Creating the new subtab Play Sports

  2.Entity Sports

  • Enter the name of the Entity. In our example we create an Entity called Games.
  • Give the id for that Entity.
  • Choose the Type as List/Record and choose the List/Record as Games
  • In Applies to tab,Click Customer,that means this entity will appear on customer record.
  • In Display tab click Subtab as play sports,Subtabs shows our content in separate area,it is easy to view.
  • In Source and Filtering tab Choose the Source list as games and source filter by as games
  • Click save.

Step 1:

Sports Entity Field

Step 2:


Applies To Tab for Sports Entity Field

Step 3:

Display Tab for Sports Entity Field

Step 4:

Source_and_Filtering Tab for Sports Entity Field

Step 5:

Navigation for creating new Customer Record.

Step 6:

Dependent DropDownlist


3 comments:

  1. May I know how can achieve the same in suitelet sublist fields.

    ReplyDelete
  2. This works great!!! How to I restrict my users from adding new entries to the lists? I set the permissions on the custom record, but it doesn't seem to have any affect. they can still add new entries to both fields. These users have full access to custom lists which is required for other functions within our system.

    ReplyDelete
  3. Great work i want appreciate your patience to create this article..


    It will helpful for
    Cloud ERP solutions & netsuite implementation support companies employees.

    Thanks for sharing the article with us.
    people will learn and get Knowledge.

    Reach us
    netsuite implementation partners

    Few of my articles i fell helpful more :

    Top 5 Benefits of Using NetSuite

    NetSuite Industry Solutions

    NetSuite for small business

    NetSuite for retail industry

    ReplyDelete