Depend On other Field in same Form

[creamdory]

Hi @jellf,

You ma want to take a look at these use cases:

Custom Script Field Filtering

I added this as custom script to the stock entry doctype hoping the default warehouse will get filtered based on city. But there is no result. Any idea? cur_frm.set_query("from_warehouse", function () { return{ filters: { 'city': 'Dubai' } } });

Filter link field base on other field

I am a little bit loss with this use case. There is a “transaction type” field which is select with an option ( rent and vacant ) and there is a field “room” which is a link to a room doc type. If the transaction type is Rent the room field drop down will be filtered ( room_status = ‘Vacant’). if the transaction type “Vacate” the room field will only display with room_status=‘Rented’. How can I do this in frappe? [image]

Hope these help. Thanks!