How to auto populate one reference field value based on other reference field on catalog item?

[hemachandra2]

Hi All,

Actually we have two reference fields(State , City),these two are refering to location table only, so my requirement was whenever we select city based on that state will auto populate ?

Please help me on this

Thanks

Hemachandra

[Community Alums]

Hi @hemachandra ,

Refer to these links and design your solution :

How to populate one field value based on other field value in Service Catalog ?

Auto populate reference field based on other reference field

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Hi @hemachandra ,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Ankur Bawiskar]

Hi,

if both are referring to location table then filtering won't happen.

You can make City as string field and based on change of State we can fetch the city from that record and populate in city string field.

Regards
Ankur

[Deepika61]

Hi Ankur,

Thanks for the response

Can you please provide the sample script for this approach which your saying after making city field as string?

Thanks

Hemachandra