Hiding a value from a reference field

ramak · ‎03-14-2016

Is there a way of hiding a group name from "Assignment group" field on the Change form till the New Change reached "Scheduled" status ?

Reason for this is there is a group which only needs to be selected after all the approvals are done. This group in turn bridges with a 3rd party tool & selecting this group before the change is approved, would prematurely bridge the change request.

I know you can do this on a choice list but not sure on how to hide a value in a reference field.

Any input would help me here !!

Brian Dailey1 · ‎03-16-2016

Hi Suhas,

No, you don't have to use a script include. For an advanced refqual, you can specify "javascript:" with any valid javascript statments following it, including a call to a script include. But you can also just insert your statements right there in the advanced refqual. The advantage to calling a SI is that you could call a much more complex script... the refqual field does have a finite length which limits the amount of code you can enter there.
If you want to list the 9 groups (out of 10) all the time, and include the 10th group when state=scheduled, use the second refqual I gave you (replace the group name and the state value with whatever you need):

javascript:current.state==-15 ? "active=true":"active=true^name!=Infrastructure NSW";

One important thing to note, I see in your query you were using "nameNOTInfrastructure NSW", which I don't think is a valid query... which would explain why you are still seeing all of the groups. An invalid query condition is ignored and all records are returned.

Instead you should be using "name!=Infrastructure NSW".

Try that and see how it works for you.

Thanks,

-Brian

View solution in original post

ramak · ‎03-15-2016

Thanks Vivek, tried this but it ain't working...still seeing the group name when the state is not in 'scheduled'...any idea what we are missing here mate ?

vivekkumarr · ‎03-15-2016

Can you please share some screen shot. because it should work.

mpatil · ‎10-18-2016

Hi All,

I have a similar requirement, with few changes

1) The reference field is present in incident task form, called "type".

2) once a type is selected and a task record is submitted.

3) The user should not be able to select the same type and submit the task for the incident.

4) Only unused values should be shown in the reference filed "type" in the task form for the incident.

Tried multiple codes but no success, please help.

Regrads

Mahesh Patil

Brian Dailey1 · ‎10-18-2016

Hi Mahesh,

I will assume the name for your Type field is 'u_type' for the following code. You can set the 'u_type'field to use an advanced Reference Qualifier to be self referencing, and enter the following as the qualifier:

javascript:"u_type!=" + current.u_type;

Please give that a try.

Thanks,

-Brian