JimmyEdmondson

Hi Tobias,

That’s amazing, worked perfectly. Thank you for the support once again!

Best Regards,
Jimmy

I am terribly sorry, it’s set to private. Is there a way for me to send you login credentials without them being publicly visible on this forum?

Thanks Tobias! That worked perfectly. I think I’m finally finished with this project now.

Hi Tobias,

Thank you once again for the amazing support!

I’ve had to set the page to private now (here’s a screenshot https://www.dropbox.com/s/r39eehy68gsmfqc/Screenshot%202021-05-13%20at%2016.57.49.png?dl=0) and send it to my client for review but I was able to use a Tooltip plugin called ‘Responsive Mobile-Friendly Tooltip’ that works with shortcodes. So I was able to add the shortcodes to my Google Sheet heading cells.

The tooltip generated by this plugin appear above rather than below the cursor so I can retain the horizontal scroll where the search box and buttons stay fixed in position. So this is amazing!

And I brought in some AwesomeFont icons that are placed after the word ‘Company’ to be the basis for the tooltip. These icons show in my heading cells but don’t appear in the colvis list as text. Win win!!

I think everything is exactly as I wanted it to be now. Thanks again. I’ll be making a donation for the support shortly.

Have a great day!
Jimmy

Hi Tobias,

Thank you once again for such great support. I really appreciate it. I am going to make a donation to thank you for the support now.

The CSS you provided has helped me fix that issue with the header, I can’t believe I missed that.

—

Apologies for not providing enough information on the tooltip issue.

My spreadsheet is imported from here – https://docs.google.com/spreadsheets/d/1o4nQ5XKNkjENOdi8Rvd3qmFPxWSGpMyMUkSGK8mGPVs/edit?usp=sharing

The code…

<div class="info-box">
Your content and data.
</div>

…is added to the top two cells ‘Company’ and ‘Index’.

As this table is set to automatically update I thought adding the code directly to the Google Sheet would be the best place for it. Is that correct?

You can see that nothing is appearing in the table heading next to ‘Company’ but when you click ‘Show/hide columns’ the title for that column is ‘Company Your content and data’ so it is pulling in the text somehow.

What do you recommend to add the tooltip in the table cell but now have any tooltip text appear in the ‘Show/hide columns’ column title?

—

Many Thanks,
Jimmy

And I am terribly sorry to have to ask but I am pulling my hair out trying to figure this out. Since I selected the option to make the table scrollable horizontally it introduces the light green tint from the Header row into another row below.

I’ve tried to get rid of it by targeting thead but this removes the main header row too. And I’ve tried removing row-1 but that doesn’t work either. I’m not sure what is causing this row to appear. Do you have any idea?

P.S. I have also already added this to the Custom CSS box…

.tablepress-id-1 td {
	position: relative;
}

.tablepress-id-1 .info-box {
	display: none;
	position: absolute;
	z-index: 2;
	top: 50%;
	left: 50%;
	border: 2px solid #ff0000;
	width: 200px;
	height: 100px;
	padding: 5px;
	background-color: #ffffff;
}

.tablepress-id-1 td:hover .info-box {
	display: block;
}

Thank you very much! That is a massive help.

Hi,

Thank you for your quick reply and direction. I’ll be sure to review the plugin now. ?? I actually have two other small questions if that’s ok?

1. Is it possible to change the words ‘Column visibility’ to ‘Show/Hide Columns’?

2. Is it possible to group the ‘CSV’, ‘PDF’ and ‘Print’ buttons under a single ‘Share’ dropdown?

Many Thanks,
Jimmy

Apologies, after a bit of experimenting I managed to get it working with this code…

“columnDefs”: [
{“visible”: true, “targets”: [0,1,3,4,5]},
{“visible”: false, “targets”: ‘_all’},
]

Apologies for my delay in getting back to you. I’ve been out of the studio for a few weeks. Thank you very much for getting back to me and for looking into the issue.

My client had been messing around and managed to get it to work but I’m not sure what he did as I couldn’t fix it originally. I’m glad to hear that you managed to recreate the issue and can find a fix for it. Great news! I’ll be sure to download the update.

Many thanks!