Adding a choice value to the reference type field

[Shir Sharvit]

Hey,

Creating a record producer form to create a new incident.

I have a caller field in the form that once I select a caller, the position field will display the appropriate values of the caller.

I did this by script include :

And in the Reference qual field I called script include:

I need to add to the values in the Position field a value - other which will be a constant value that will always appear, as soon as the caller selects "other" a new field called "other position" of reference type must be displayed that shows all the positions that exist in the system.

[Community Alums]

Dear @Shir Sharvit,

To be frank, i read your query few times i did not understand whats expected ? can you explain bit more on your last point...

[Shir Sharvit]

I added a new record called other to the table to which there is a reference, how do you associate this record from the table to all users

[Community Alums]

@Shir Sharvit,

creating a new record called other will not be a probable and effective solution in your case. This will lead to poor data management on table. Instead, try my alternative solution which is smooth and clean for your requirement. 

[Community Alums]

okie my understanding was right !

there is no way you can add a custom choice to reference field, because reference field list all the values that exisits in its table. You can consider adding a new record called 'other' if it helps your requirement.

(Alternative solution) : 

Alternatively, instead of leting the user select 'other' in caller field, try to introduce a check box field called 'other ' & when the user checks it make the caller field read only and displays a new field called 'other position' from which the user can select any choices.

i hope this helps.