Levi Pruss
12/12/2025, 5:18 AMCeligo AI
12/12/2025, 5:18 AMAI generated answer (using internal Slack threads):Based on the conversations, it seems like you want to create a custom field that displays the transaction ID (tranid) and links back to the corresponding sales order. Here's a way to do it: 1. Create two custom fields on your task record. The first one is a list/record field that you use to select the sales order. The second one is a free form text field that you can use to source the tranid. 2. For the hyperlink field, you can use a formula to construct the URL. However, you need to use the internal ID of the sales order, not the tranid, to construct the URL. The internal ID is unique and can be used to directly link to a record. Here's a sample formula you can use for the hyperlink field:
javascript
'<https://system.netsuite.com/app/accounting/transactions/salesord.nl?id=>' || {internalid}
Replace 'system.netsuite.com' with your account's domain. This formula will create a link that goes directly to the edit page of the sales order.
Please note that the tranid is not unique and cannot be used to directly link to a record. Also, the user must have the necessary permissions to view the sales order.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
12/12/2025, 5:18 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.800567627
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.780578613
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.780212402
Celigo AI
12/12/2025, 5:18 AM