catalog item form design

[iwsservicen]

 Request for Help: Dynamic Dropdowns in ServiceNow Catalog Forms

Hi General 👋,
We need assistance with creating ServiceNow catalog forms that include dynamic dropdown functionality. Our requirements are:

• Dropdown values should come from a CSV file 📂.
• Dropdowns should be dependent on each other 🔄. For example:
  • If a user selects a Subscription in the first dropdown, only the Resource Groups under that subscription should appear in the second dropdown.
  • If a user selects a Resource Group, then only the VMs under that resource group should appear in the third dropdown.

Is this achievable in ServiceNow? If yes, could you guide us on the best approach or share any relevant documentation or examples?

Thanks for your support! 🙏

Requirement for ServiceNow Form Development

Overall Objective

We need to evaluate and finalize a standard, non‑hardcoded, scalable approach for passing input values into a ServiceNow form and dynamically filtering dependent fields (e.g., Country → State → District). Once the approach is finalized, we will proceed with form development after aligning with the backend team.

---

Detailed Requirements

1. Identify all feasible approaches for populating values in a ServiceNow form

We must explore different approaches to:

• Pass input values into the form
• Dynamically load values into dropdowns or reference fields
• Avoid hard-coding
• Maintain a clean, scalable, and maintainable configuration

2. Finalize the standard approach (commonly used in ServiceNow)

Our goal is to choose a method that:

• Follows ServiceNow best practices
• Works well for dependent selections (Country → State → District)
• Supports default or null values when the form loads
• Avoids any hardcoded scripts or static choice lists whenever possible
• Is widely adopted and proven to be maintainable

Example requirement:

• If Country = India, show only Indian States.
• If State = Delhi, show only Delhi districts.
• When the form loads for the first time, finalize how default or null values should be displayed.

[iwsservicen]

hiii one question i want to join 6 tables as one table how to do any idea ?

[poyntzj]

Database view is the easiest way.  there are join queries, but I normally use a DB view for simplicity and the fact you can query from any of the linked tables