please help me with a following problem: I have 2 forms: "EmpsAll" (all employees) and EmpsDocs (employees which, for example, signed a document in company). And I need to build a view to show the employee name in first column and boolean info (0 or 1) depend on is the employee in the EmpsDocs base (if employee is in EmpsDocs then returns 1, if not returns 0). The question is: is it possible to enter a formula @BDLookup to second column to calculate value (0 or 1) idividually for every employ in the view?
You can't use @DBLookup in a view column formula. A good alternative is to write a scheduled agent that iterates over all documents in one view, does the @DBLookup, and changes a value in the document.
The good news is your view is fast since there are no lookups, but the bad is your view is showing a snapshot in time of the state of all documents.