Filter link field encluding used docs

Frappe Framework Custom Script
1

Hello!
I have created a new DocType and inside it I created a link field of Sales Order

Screenshot%20from%202020-11-25%2007-56-04
Screenshot%20from%202020-11-25%2007-56-041440×900 129 KB

Its is working fine

Screenshot%20from%202020-11-25%2007-56-36
Screenshot%20from%202020-11-25%2007-56-361440×900 102 KB

But I need to filter this field to get only Sales Orders that were not used in other docs of the same DocType. How could I do that?

Thanks in advance.

2

With a Custom Script you can set your own conditions. Also, you could tick the “unique” checkbox in the field “Pedido de Venda”.