cancel
Showing results for 
Search instead for 
Did you mean: 

Dropdown scripting

DanielVisblut
Explorer
0 Kudos

I have a click Button to insert a new member into diemnsion
I have 1 input field for the ID and Description (its the same)
and i want the user to choose a category (property) from a drop down
also i want to define the heirarchie to be equal to H2 always
i wrote a script but its not working

NEED YOUR HELP IN THE DESCRIPTION FROM DROP DOWN AND INSERT A VALUE TO THE HIER COLUMN 
var dim="Cause";
members = {
            id:InputField_1.getValue(),
            description:Dropdown_1.getValue()
            H2:getValue(H2)
};
var status = PlanningModel_1.createMembers(dim,members);
if (status===true){Application.showMessage(ApplicationMessageType.Success,"master data is created");}
else {Application.showMessage(ApplicationMessageType.Error,"something is  wrong,try again");}
Thank you very much

View Entire Topic
SimonKranig
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

maybe you can try this (assuming H2 is the name of your hierarchy)

var newMember = cast(Type.PlanningModelMember, {
id: InputField_1.getValue(),
description: InputField_1.getValue(),
hierarchies : {},
properties: {}
});

newMember.hierarchies['H2'] = { parentId: '<Member Id of the Parent>'};

newMember.properties['<nameofyourproperty>'] = Dropdown_1.getValue();

This example is very minimal, I would suggest to do some input validation for the values provided by the user beforehand.