@kimstev
If you want to filter out records that have a completed discharge date, you can add a Filter function to your existing formula. Here is how you can modify your existing formula:
Filter(
Search(
[@'New tables'],
SearchInput1.Text,
"cr034_midwife",
"cr034_analgesiagivenother",
"cr034_assessmentothercomment",
"cr034_babyoutcomeother"
),
IsBlank(DischargeDate) // replace 'DischargeDate' with your actual column name
)
In this updated formula, the Filter function is used to further refine the results returned by the Search function.
The IsBlank function is used to check whether the DischargeDate is blank or not.
If the DischargeDate is blank, that means the record is not yet completed, so it will be included in the result.
Please replace 'DischargeDate' with the actual name of your column that stores the discharge date.
This formula assumes that a non-completed record is identified by a blank discharge date. If your completion criteria is different, you should adjust this formula accordingly.
