CloudExtend Excel Analytics for NetSuite users may want to add hyperlinks to the original NetSuite transaction in their search results. Because Excel formulas don't carry over when drilling down from a pivot table we have implemented two different approaches outlined below when building our own data sets.

In both cases below you will add a Formula (Text) field to your search results and give it a custom label.

(1) If you don't need your hyperlink to work when drilling down from a pivot table

You can create a nicer looking result if you don't plan on your users drilling into your detail from pivot tables.

Use the formula below and replace 231585 with your NetSuite account number

'=HYPERLINK("HTTPS://231585.app.netsuite.com/app/accounting/transactions/transaction.nl?id='||{internalid}||'","Link to NetSuite")'

(2) If you need your hyperlink to work when drilling down from a pivot table

If you need your hyperlink to work even when drilling down from a pivot table use the formula below and replace 231585 with your NetSuite account number.

'HTTPS://231585.app.netsuite.com/app/accounting/transactions/transaction.nl?id=' ||{internalid}

Watch the short video below for a deeper dive.

Did this answer your question?