Dynamic population of options in a select field of a child table based on several conditions

ERPNext
, , ,
1

Hey all. I’m currently working on a customization in Frappe/ERPNext, and I’d love your input on a concept I’m exploring.

The idea is around dynamic dropdown options inside a child table**:

The dropdown should populate its options based on a condition** (for example, Story Points chosen in the row).
Once a value is selected, the remaining available options should shrink dynamically across other rows, so no overlapping or invalid selections occur.

In simpler terms:

First condition → generates options.
Second condition → progressively reduces available options, ensuring consistency.

I’m trying to identify the best approach to implement this in Frappe/ERPNext** (via server scripts, custom APIs, or client-side scripting).

Would love to hear your thoughts if you people encountered a similar requirement before.

2

HI @Frappe795:

Basically, you should “listen” to field changes and then populate df options on your next select field. But maybe it would more interesting using here Autocomplete field. It’s pretty undocumented, but look at this …

Hope this helps.

3

Yeah firstly thanks for making a response, Will try this method out and post the outcome