'<a href=\"' || Concat("https://4146758.app.netsuite.com/app/common/search/searchresults.nl?searchtype=Employee&amp;AHI_CUSTRECORD_MUTS_TSS_DATErange=CUSTOM&amp;AHI_CUSTRECORD_MUTS_TSS_DATEfromrel_formattedValue=&amp;AHI_CUSTRECORD_MUTS_TSS_DATEfromrel=&amp;AHI_CUSTRECORD_MUTS_TSS_DATEfromreltype=DAGO&amp;AHI_CUSTRECORD_MUTS_TSS_DATEtorel_formattedValue=&amp;AHI_CUSTRECORD_MUTS_TSS_DATEtorel=&amp;AHI_CUSTRECORD_MUTS_TSS_DATEtoreltype=DAGO&amp;style=NORMAL&amp;AHI_CUSTRECORD_MUTS_TSS_DATEmodi=WITHIN&amp;AHI_CUSTRECORD_MUTS_TSS_DATE=CUSTOM&amp;Entity_ENTITYIDtype=STARTSWITH&amp;report=&amp;grid=&amp;searchid=4369&amp;sortcol=AHI_cfRECORD_810_raw&amp;sortdir=ASC&amp;csv=HTML&amp;OfficeXML=F&amp;pdf=&amp;size=500&amp;_csrf=G-71JITLSOWLeIbqXh_p1n80l7AjpNgMcazpmnUDF3nLGZ9VNPoPdrbzRMIykW9Id-8GAs6tHx8R2cwRquqDesCU47rOonuj-F0g_uNWt327ctn5xkhdNQ7PCEnqBNuE1-mdtE5Ms1JlL9Gzlv_cT6X68uEROP54DQzZoV-aQRY%3D&amp;twbx=F&amp;TM_CUSTCOL_EG_PROJECT_MANAGER=",{time.custcol_eg_project_manager},"&Employee_SUPERVISOR=",{supervisor},"&Entity_ENTITYID=",{entityid},"&AHI_CUSTRECORD_MUTS_TSS_DATE=",{custrecord_muts_tss_employee.custrecord_muts_tss_date}) || '\" target=_blank>View Detail</a>' gives error

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like the issue is related to the concatenation of strings in a formula. In NetSuite, you can concatenate strings using the

||

operator. For example, in the first conversation, the user is trying to create a hyperlink in a saved search. The correct formula would be

'<a href=<https://system.netsuite.com/app/common/entity/custjob.nl?id=>' || {internalid} || ' target=_blank>Link</a>'

. This formula concatenates the URL, the internal ID of the record, and the HTML tags to create a clickable link. In the second conversation, the user wants to display the

{appliedtotransaction.number}

document number instead of the words "Sales Order". The correct formula would be

'<a href=\"https://########.<http://app.netsuite.com/app/accounting/transactions/salesord.nl?id=|app.netsuite.com/app/accounting/transactions/salesord.nl?id=>' || {appliedtotransaction.internalid} || '&whence=\">' || {appliedtotransaction.number} || '</a>'

. In the third conversation, the user is trying to concatenate a URL with two fields

{custitem_awa_custom_parent.custitem_awa_brand}

and

{custitem_awa_custom_parent.custitem_awa_type}

. The correct formula would be

'<a href=\"url=' || SUBSTR({entityid},1,3) || '%23' || SUBSTR({entityid},5,5) || '&custrecord_nn_nps_contact='||{contact.custentity_nn_con_nps_id}||'\">Text</a>'

. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******