Show Hidden fields after click

Let me see if I can re-stated the problem:

• You want to display submitted form data in a table, like you would using short code [cfdb-table]
• In a table row, you only want to so some of the field (those you consider “open”)
• When a user clicks on a row, you want to see additional fields (though you don’t say how you want this displayed…maybe a box under the row or a popup

Is that the idea?

Correct. popup or box, anything is fine with me.

Also I want to give table editing rights to contributors. The table has a column with header availability with 2 options yes/no. That should be hidden and only visible to contributors. If the contributor sets the option to yes, that particular row should be visible to general public and if it selected to no, then that row should be hidden. Is that possible?

The approach I suggest is to use [cfdb-html] where:
– You manually add the table, thead tbody tags before the short code
– Add the corresponding closing tags after the short code
– Inside the cfdb-html out put each row (td tag)
– for each row put a javascript onclick function to popup the hidden info

Editing is not possible outside the admin page.

I’m ok to give the admin rights to them. Please tell me how to do that?

Editing you have to pay for. See CFDB Editor.