Random Hyperlinks Not Working in Nested Columns with Lists

I am new here and have beginner level experience with WordPress so please bear with me if I am leaving out any pertinent information.

Towards the lower portion of this https://www.logicmanager.com/ca-solutions-menu/ landing page, I have a series of containers with columns and nested columns. Within these nested columns I have included hyperlinked text to list items. Ideally, all of the hyperlinked list items would click out to their respective landing pages.

However, for some reason unbeknownst to me, most of the hyperlinks are not working properly and the text items are un-clickable.

Does anyone know why this might be and how I can fix it? Are there any additional details I can provide to help resolve this issue? Is this forum even meant for questions like this?? Many thanks in advance!

Cusor won’t react to hyperlinks when using Safari

Descriptions:

Normally when hovering the mouse on the hyperlink, the cursor turns into a little hand, and the link will show the CSS hover effect. But a wired Safari bug kept this from happening.

It’s been almost 4 months since I first encounter this issue. Finally I found the potential cause:

  1. In full screen mode;
  2. Click any website from Bookmarks (including Favorites) ;
  3. In the opened website, turn on and off the Bookmark Sidebar once;
  4. From now on, any website that opened from Bookmarks won’t trigger hover effect.

Here’s the screen recording (Imgure).


What I’ve tried to solve this:

  1. Empty cache, clear history, remove all plugins, delete relevant plist file, quit all the other apps, nothing;
  2. Installed latest Safari Technology Preview, repeat step 1, nothing;
  3. Created another admin account, problem still happens there;
  4. Repaired disk permission in Recovery Mode, nothing.

MacBook Pro 15, 2018. Mojave 10.14.5 (18F203). Safari 12.1.1

Help, please.

Find all hyperlinks to a SharePoint site collection

I have a site collection say A with URL https://company.sharepoint.com/sites/SiteA

Will it be possible for me to find where all this URL is hyperlinked?

Means,will it be possible for me to find all the places(like other site collections and subsites) where https://company.sharepoint.com/sites/SiteA and its inner pages are hyperlinked?

T

Find all hyperlinks to a SharePoint site collection

I have a site collection say A with URL https://company.sharepoint.com/sites/SiteA

Will it be possible for me to find where all this URL is hyperlinked?

Means,will it be possible for me to find all the places(like other site collections and subsites) where https://company.sharepoint.com/sites/SiteA and its inner pages are hyperlinked?

T

What would I have to change in my code to add images & hyperlinks to my email template on Google Sheets?

function getRowsData(sheet, range, columnHeadersRowIndex) {   columnHeadersRowIndex = columnHeadersRowIndex || range.getRowIndex() - 1;   var numColumns = range.getEndColumn() - range.getColumn() + 1;   var headersRange = sheet.getRange(columnHeadersRowIndex, range.getColumn(), 1, numColumns);   var headers = headersRange.getValues()[0];   return getObjects(range.getValues(), normalizeHeaders(headers)); }   function getObjects(data, keys) {   var objects = [];   for (var i = 0; i < data.length; ++i) {     var object = {};     var hasData = false;     for (var j = 0; j < data[i].length; ++j) {       var cellData = data[i][j];       if (isCellEmpty(cellData)) {         continue;       }       object[keys[j]] = cellData;       hasData = true;     }     if (hasData) {       objects.push(object);     }   }   return objects; }   function normalizeHeaders(headers) {   var keys = [];   for (var i = 0; i < headers.length; ++i) {     var key = normalizeHeader(headers[i]);     if (key.length > 0) {       keys.push(key);     }   }   return keys; }  function normalizeHeader(header) {   var key = '';   var upperCase = false;   for (var i = 0; i < header.length; ++i) {     var letter = header[i];     if (letter == ' ' && key.length > 0) {       upperCase = true;       continue;     }     if (!isAlnum(letter)) {       continue;     }     if (key.length == 0 && isDigit(letter)) {       continue; // first character must be a letter     }     if (upperCase) {       upperCase = false;       key += letter.toUpperCase();     } else {       key += letter.toLowerCase();     }   }   return key; }   function isCellEmpty(cellData) {   return typeof(cellData) == 'string' && cellData == ''; }   function isAlnum(char) {   return char >= 'A' && char <= 'Z' ||     char >= 'a' && char <= 'z' ||     isDigit(char); }   function isDigit(char) {   return char >= '0' && char <= '9'; }   function sendEmails() {   var ss = SpreadsheetApp.getActiveSpreadsheet();   var dataSheet = ss.getSheets()[0];   var dataRange = dataSheet.getRange(2, 1, dataSheet.getMaxRows() - 1, 4);    var templateSheet = ss.getSheets()[1];   var emailTemplate = templateSheet.getRange("A1").getValue();   var emailTemplate2 = templateSheet.getRange("A2").getValue();     var objects = getRowsData(dataSheet, dataRange);    // For every row object, create a personalized email from a template and send   // it to the appropriate person.   for (var i = 0; i < objects.length; ++i) {     // Get a row object     var rowData = objects[i];     var file = DriveApp.getFilesByName('2019_MA_BenefitsGuide.pdf')     var file1 = DriveApp.getFilesByName('List of Acceptable Documents.pdf')      var emailText = fillInTemplateFromObject(emailTemplate, rowData);     var emailText2 = fillInTemplateFromObject(emailTemplate2, rowData);     var emailSubject = 'Mail Merge Test';      MailApp.sendEmail(rowData.emailAddress,                       emailSubject,                        emailText ,                        {attachments: [file.next(), file1.next()]} );    } }  function fillInTemplateFromObject(template, data) {   var email = template;   // Search for all the variables to be replaced, for instance $  {"Column name"}   var templateVars = template.match(/$  \{\"[^\"]+\"\}/g);    // Replace variables from the template with the actual values from the data object.    for (var i = 0; i < templateVars.length; ++i) {      var variableData = data[normalizeHeader(templateVars[i])];     email = email.replace(templateVars[i], variableData || '');   }    return email; } 

What would I have to change in my code to add images & hyperlinks to my email template on Google Sheets? Or would I have to change my code? The template is here – https://developers.google.com/apps-script/articles/mail_merge

How do I add hyperlinks and images to the template(A1), to use the below could and use mail merge to send out my mails?

function getRowsData(sheet, range, columnHeadersRowIndex) {   columnHeadersRowIndex = columnHeadersRowIndex || range.getRowIndex() - 1;   var numColumns = range.getEndColumn() - range.getColumn() + 1;   var headersRange = sheet.getRange(columnHeadersRowIndex, range.getColumn(), 1, numColumns);   var headers = headersRange.getValues()[0];   return getObjects(range.getValues(), normalizeHeaders(headers)); }   function getObjects(data, keys) {   var objects = [];   for (var i = 0; i < data.length; ++i) {     var object = {};     var hasData = false;     for (var j = 0; j < data[i].length; ++j) {       var cellData = data[i][j];       if (isCellEmpty(cellData)) {         continue;       }       object[keys[j]] = cellData;       hasData = true;     }     if (hasData) {       objects.push(object);     }   }   return objects; }   function normalizeHeaders(headers) {   var keys = [];   for (var i = 0; i < headers.length; ++i) {     var key = normalizeHeader(headers[i]);     if (key.length > 0) {       keys.push(key);     }   }   return keys; }  function normalizeHeader(header) {   var key = '';   var upperCase = false;   for (var i = 0; i < header.length; ++i) {     var letter = header[i];     if (letter == ' ' && key.length > 0) {       upperCase = true;       continue;     }     if (!isAlnum(letter)) {       continue;     }     if (key.length == 0 && isDigit(letter)) {       continue; // first character must be a letter     }     if (upperCase) {       upperCase = false;       key += letter.toUpperCase();     } else {       key += letter.toLowerCase();     }   }   return key; }   function isCellEmpty(cellData) {   return typeof(cellData) == 'string' && cellData == ''; }   function isAlnum(char) {   return char >= 'A' && char <= 'Z' ||     char >= 'a' && char <= 'z' ||     isDigit(char); }   function isDigit(char) {   return char >= '0' && char <= '9'; }   function sendEmails() {   var ss = SpreadsheetApp.getActiveSpreadsheet();   var dataSheet = ss.getSheets()[0];   var dataRange = dataSheet.getRange(2, 1, dataSheet.getMaxRows() - 1, 4);    var templateSheet = ss.getSheets()[1];   var emailTemplate = templateSheet.getRange("A1").getValue();   var emailTemplate2 = templateSheet.getRange("A2").getValue();     var objects = getRowsData(dataSheet, dataRange);    // For every row object, create a personalized email from a template and send   // it to the appropriate person.   for (var i = 0; i < objects.length; ++i) {     // Get a row object     var rowData = objects[i];     var file = DriveApp.getFilesByName('2019_MA_BenefitsGuide.pdf')     var file1 = DriveApp.getFilesByName('List of Acceptable Documents.pdf')      var emailText = fillInTemplateFromObject(emailTemplate, rowData);     var emailText2 = fillInTemplateFromObject(emailTemplate2, rowData);     var emailSubject = 'Mail Merge Test';      MailApp.sendEmail(rowData.emailAddress,                       emailSubject,                        emailText,                        {attachments: [file.next(), file1.next()]} );    } }  function fillInTemplateFromObject(template, data) {   var email = template;   // Search for all the variables to be replaced, for instance $  {"Column name"}   var templateVars = template.match(/$  \{\"[^\"]+\"\}/g);    // Replace variables from the template with the actual values from the data object.    for (var i = 0; i < templateVars.length; ++i) {      var variableData = data[normalizeHeader(templateVars[i])];     email = email.replace(templateVars[i], variableData || '');   }    return email; } 

How do I add hyperlinks and images to the template(A1), to use the below could and use mail merge to send out my emails?

Hyperlinks in Excel are changing when uploading to SharePoint document library

I uploaded Excel files from an external drive to SharePoint document library. The hyperlinks in the Excel spreadsheet works fine in my local, I can open the links. However, when I uploaded it in SharePoint and click on the link it gave me this error:

Unable to open. The internet site reports could not be found (http/1.0 404) 

I checked the hyperlink and it is changed from “file://\Apps\share1\file.docx ” to “http://servername/share/file.docs” Any ideas please to resolve the issue?

Issue with hyperlinks with Office Web App Previews in Chrome and Firefox

I have a powerpoint file in my SharePoint 2013 site which has hyperlinks in it. I am able to see the powerpoint preview in OWA (Office Web Apps).

However when I click the hyperlink in the OWA preview pane, the tab is opening and closing immediately, this is happening in both Chrome & Firefox browsers (latest versions). Surprisingly Internet Explorer 11 (IE 11) is working fine without any issue.

The hyperlinks are not relative links, they are full hyperlinks to other files within the same sharepoint site. When I type-in (or copy) the same link manually, it is working fine even in chrome & firefox browsers.

For me it seems, there seems to be some issue with the OWA and hyperlinks in document previews. But I am not able to fully understand the exact cause and resolution. Anyone please help me.

Regards, Kishore

Google Sheet – Convert hyperlinks to buttons

In Google Sheets, I have a column of active hyperlinks. When you hover over one of them, a tool tip appears that contains an “open link” icon that you can click on to open a new tab that loads the url.

In each cell, instead of showing the entire URL, I’d like to replace that text with a “view” button that can be clicked immediately, without having to wait for the hover-delayed tool-tip with the “open link” icon.

Keep in mind, that each URL is different (in this column) and I’m looking for a solution where I can highlight all of them and convert each to a button that opens its respective url in a new browser-tab.

Is this feature available?