Conditional Filters at Field Level

[javierlaborde]

I want the records within a Grid Block to display different fields from my database depending on the content of those fields, for example, if “did they answer?” is “no” then show the A field and hide the B field, if “did they answer?” is “yes”, then hide the A field and show me the B field.

I realised a couple of days ago this exact thing is possible with buttons within a grid item so I think it should be possible with other fields too.

Attached, photos of what I’m trying to achieve, I currently have this with two blocks, they go and look thru the same table in my db but they show different records based in a conditional filter, I feel is not clean enough, I don’t like having two search bars in the same page and it would be much better to sort the records with a simple filter within the block instead of having two block differentiated by a conditional filter.

block 1

block 2

[Marine.Hovhannisyan]

Hey @javierlaborde, what if you use a conditional form block to ask the user whether they want to see the options with “Yes” and show the “yes” Grid block data once it was chosen or “no” if it was not chosen?

[javierlaborde]

Interesting, I’ll give it a try and come back here. Thanks for the idea. @Marine.Hovhannisyan