OK thanks.
I am clicking in the column headed “Comments”. However this column actually displays the values from a field called ‘commentsClick’. This column will either be empty or contain the word “CLICK”. The reason for this is that the actual comments are too long to display in the table and are consequently in another field in the collection called ‘comments’ which is not displayed in the table. So the idea is that the user sees the word “CLICK”, clicks on that and the contents of the ‘comments’ field will be displayed in a lightbox.
Here’s my code:
export function table1_cellSelect(event) {
// This function was added from the Properties & Events panel. To learn more, visit Velo: Working with the Properties & Events Panel | Help Center | Wix.com
// Add your code for this event here:
let cellRowIndex = event.cellRowIndex;
let rows = $w( “#table1” ).rows;
let cellColumnId = event.cellColumnId;
let commentsText = rows[cellRowIndex].comments;
if (cellColumnId == “Comments” && commentsText !== undefined )
{wixWindow.openLightbox( ‘Results Comments’ , commentsText)}
}