How to hide unnecessary rows in a data source?
I have a screen form that connects to a data source with information regarding estimates.
Once an estimate changes to an invoice, we would like that info to become invisible to the person that uses the form.
Instead of deleting rows, there is a safe method where I could add a status field in the Data Source where it changes to an "Invoice" = 'Yes.' Then I could use filters not to show invoices.
However, I don't know how to implement this solution.
Would anyone know anything about this? Thank you for your help.