Hide a value for field in a multi box

[#1]

Hi,

I have a multi box with field [Record Type] with values as below. I would like to hide the value 'Replace and RT' , so that it doesn't appear in the drop down for the users to select. Also, If I select type 'Replace', its should trigger the selection of 'Route' and 'Replace and RT'or selecting route triggers selection of 'Replace' and ' Replace and RT'.

Record type
New
Replace and RT
Replace
Route
Cancel
Order

Thanks in Advance.

[Simon_J]

Hi Mohan,

Can you not edit this in your load script so you have :

If([Record Type] = 'Replace and RT', 'Replace', [Record Type] ) as [Amended Record Type]

This way you have an amended field ready to use from your dataload. You could then do an OR clause to include the Route fields as well so that Replace, Replace and RT and Route are classified as the same thing

Is that what you are after?

Simon

[sunny_talwar]

Try like this:

Aggr(Only({1<[Record type] -= {'Replace and RT'}>} [Record type]), [Record type])

or

If([Record type] <> 'Replace and RT', [Record type])

Ignore my response, and use the above response.

[#4]

Hi Simon,

thanks for your response. I can not modify it on the load script because I have a few other tables which will be affected..So I want to restrict it on the front end, if at all possible..

[vishsaggi]

Did not quite understand your second requirement, but to hide values in Multibox, just use this expression:

= IF(RecordType = 'Replace and RT', NULL(), RecordType)

[#6]

Hi Vish,

It is not working...my record type 'Replace and RT' still shows up in the drop down. Thanks for ur time

[vishsaggi]

Strange it works for me.

Add recordtype into Multibox -> Click edit and type the expression and label the expression.

[#8]

Vish,

Thanks its working now.. I messed up something.

[#9]

The second part is that, If I select record type either " Replace" or "Route" in the filter, I should get all the information related to Route and Replace and RT (So all the records with Record type: Replace + Route + Replace and RT). Example as below:

Record Type	ID
Replace	abc1
Route	abc1
Route	xyz 1
Replace and RT	abc123

Thanks in Advance.

[vishsaggi]

Is this the table you want to display when you select the filter ? Are there only two fields or you have any additional information or data. ?