We have relate fields within a custom module which link to documents, if the fields have been linked, a checkbox is to be checked which will prevent the sales person from finalising the job until all items are checked. I am unable to make the fields required as the fields are dependent on dropdowns variables and therefore will not always be present on all records.
Is there a way to use whether a relate field is null or not to populate the checkbox? Calculated fields logic, Workflows and Process Author don't show the field as a usable variable due to it being a relate field, so I cant see a way to do it without code.
Sugar Version is 7.6 enterprise on demand.
Any help or work around would be greatly appreciated
Thanks in advance