Adding AutoComplete to my Custom Table Column

[kailashthiyagar]

Hi Team,

I m new to Service now. I have created a lookup table(Table A) for my Application in Service now. I m referenced it in one other table(Table B) as reference field. While entering values in Table B, its not showing the reference suggestions automatically. After surfing through service now wiki, in TableB , for the reference column, i added the autoComplete dictionary attribute and after that, it worked fine..

Questions

• Is this the rit way to do it? Because when i referenced service now Sys_user table, autoComplete suggestions are displayed by default....
• Also, my requirement is more like, it allows the user either to choose from the autoComplete value or to type values of their own choice. Which "Field Type" should match this criteria? How to achieve this?

P.S : Please treat both questions independently

[Pradeep Sharma]

Hi Kailash,

Please refer section 2 and 3 for more info.

http://wiki.servicenow.com/index.php?title=Auto-Complete_for_Reference_Fields#Defining_Auto-Complete...

[Pradeep Sharma]

So basically you will go to the field->personalize the dictionary->Click advanced view and search for field "Attribute" and define

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_version //Replace u_version with the column name you want to show

[kailashthiyagar]

Hi Pradeep,

Thanks for the immediate response but still i m unclear on the facts

• If i add field of "Reference" type to my form and If i add "sys_user" as reference, without doing any personalization to the field, i m getting the auto populate values. But in my custom table, i do need to the personalization as you have explained.. Why it is so???
  • Should i be any attributes to my lookup table column during the table creation? (I assume it would have been done as part of sys_user and so, its showing the auto complete value by default when being referenced)
• As i posted in my original query, my requirement is, the user should have the flexibility of choosing the existing value or to type something on their own?
  • If i use reference field and i type something other listed out , it shows invalid reference.

[Pradeep Sharma]

Hi Kailash,

The reason because for the "sys_user" it is pre defined in the attribute section of the dictionary type collection.

Does this answers your question?

To answer your section question, there is no way expect manually defining the attribute for the columns you need to pull.