Allow to select value in table column depending on another column value

Frappe Framework Customization
1

Hello;

In the below picture example for the child table, how I can allow to select Order field only if Status was Available (of course for each row)?
For example: if the status is Taken for the row, then it is not possible to click on the checkbox of the Order, but if the status was Available for the row then it is possible to select the checkbox in the Order. How?

Any work around for this?

Grid_ColumnAppearDependingOnOther
Grid_ColumnAppearDependingOnOther891×183 18.9 KB

Regards
Bilal

2

You can use custom script for that.

https://erpnext.org/docs/user/manual/en/customize-erpnext/custom-scripts/custom-script-examples

3

Hello @bhavikpatel7023
I know that I can use custom script. But how? What is the method to achieve this.
If you know what method, please advise.
Regards
Bilal

4

go in custom script list, select document and write your logic. For more info how to write it, you can refer above link.

5

Just these two lists that I know of, but neither has seem to have what you seek

Community Developed Custom Scripts · frappe/erpnext Wiki · GitHub
Client Side Scripting Index · frappe/frappe Wiki · GitHub

But these may be what you seek

Filtered dropdown in Link Field Type
Display field based on selection in another field

6

ok there’s this that @umair referenced just now "Depends On" in a new field

Thanks so much umair I learn lots from your patient responses!

A request @bghayad to spend more time reading to answer you own questions - please return and write a followup response to what you find :wink:

1 Like
7

Hello;

“Depends on” does not work with child table.

This is possible for field of type Link and not for these of type Select.
I am still looking for a way to filter the Select values based on the selection for other field.

Regards
Bilal

8

Good information thanks for clarifying!

1 Like