Have table and form view showing only blank fields

[Morten]

I have a check list app where there are a lot of things we do over a few days. All fields have “Done” and “N/A” as alternatives. I have designed the form view to be editable, so it’s just to open the main issue and click one of the two buttons as we perform the tasks. But there’s quite a lot of them, and I would like the form view to just show the fields that have not yet been addressed, making the list smaller and smaller.

I also would like to be able to create a table view which only displays the column names for the fields that are blank according to the main issue.

Any ideas?

[Suvrutt_Gurjar]

Welcome to the Appsheet community.
I believe you can show only blank fields in the form view with an expression something like

AND( ISBLANK ([_THIS]) , CONTEXT(“View”)= “Form__View_Name” )

However, in table view, one will not he able to hide columns based on value of the column in one record. This is so because table view is a summary view of many records. Record 1 may have a column as blank and record 2 may have that column as “Done” . So table view does not respect these show_if constraints, per my understanding.

[Morten]

But do you mean that I should use this string in the “Show if” in the form or in each column?

[Suvrutt_Gurjar]

Yes, since you wish to hide at column level in each record, the show_if constraint is at each column level.

[Morten]

Ok, but then I have another problem. Because this is for an extra view, in the main view I want to see all columns. At the start of designing the app, the blank fields didn’t show in the form view, and after a bit of searching, I ended up inserting this string in Show: OR(ISBLANK([_THIS]),ISNOTBLANK([_THIS])).