I have a grid that lists contact information. A custom field has been added to mark if the current address is known to be invalid on the table level. The customer wants a checkbox that will remove invalid addresses from the grid. I cannot filter on the query because that will remove the entire records where the address is invalid. The requirement is for the record to still be there but just the address fields be blank. I tried modifying the datasource but that removed the data from the table which I don't want, I want the data to remain but simply not be visible in the grid in this circumstance.
Example:
Here we would want to see rows for Contacts1, 2, and 3 but for Contact2 want the Street and City fields to be blank or hidden. The data should remain in the table but not be visible in this grid.
| Name |
Street |
City |
isValid |
| Contact1 |
123 1st St |
City1 |
yes |
| Contact2 |
234 2nd St |
City2 |
no |
| Contact3 |
456 3rd t |
City3 |
yes |
Ideally this would be quickly toggleable with the checkbox. I believe I could hide the entire field by setting the column to hidden visibility, but that is too much, I want similar functionality on the cell record, so it can be implemented on a row by row basis.
Is there any simple way to do this?
