Conditional column visibility in detailed view

Suggestion Box
1

Hi,

I would like to request a feature that allows creating a detailed view that displays only non-empty values.

For example, I have a table with the columns ‘question’, ‘ambition’, and ‘rationale’. Some rows may have empty values in the ‘ambition’ and ‘rationale’ columns. In such cases, I need the detailed view to automatically hide these empty columns.

Thank you!

image
image801×695 20.4 KB

2 Likes
2

Hey @ailuropoda ,

If the coda detail view would not show the blank fields, how would you enter data in these empty fields? Perhaps you fill them with a formula and if that is the case, the situation is a bit different.

If your table is not to complicated, you could use a work around: create one extra column and fill the column with a formula, to show or not show these specific fields,. Something like:

concatonate(
 if(column 1.isnotblank(),concatonate("column 1 name",linebreak(),column 1,linebreak()),""),
 if(column 2.isnotblank(),concatonate("column 2 name",linebreak(),column 2,linebreak()),""),
 etc. etc.,
)

Then, edit your layout to only show the columns you want to be always visible (like Question) and this new calculated column.

I you can’t get it to work you can share a dummy doc which resembles your document and we can shot how this is done in your doc.

Greetings,
Joost

3 Likes
3

Thanks for the response! It’s not exactly what I was looking for, but the solution and the formula you shared was helpful.

4

+1
Workarounds are many but none of them is really solid alternative

1 Like