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

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?

Regards
Bilal

You can use custom script for that.

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

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

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

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

https://github.com/frappe/erpnext/wiki/Community-Developed-Custom-Scripts
https://github.com/frappe/frappe/wiki/Client-Side-Scripting-Index

But these may be what you seek

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

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

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

Good information thanks for clarifying!

1 Like