Create a custom field for store the words. In Transaction Body Field record has a subtab ‘validation & Defaulting’. Under this subtab, we have an option to give the formula. Click the checkbox of the FORMULA and give the below mentioned formula in DEFAULT VALUE text box. INITCAP(CASE WHEN {total}=0 THEN ‘ZERO’ ELSE replace(‘ ‘… Continue reading Convert Number to Words using equation in NetSuite
Author: Magi Thomas
Convert Base64 to PDF using a free decoding tool
We can decode base 64 code to pdf format using any free decoding link. https://base64.guru/converter/decode/pdf#:~:text=How%20to%20convert%20Base64%20to%20PDF%201%20Paste,on%20the%20filename%20link%20to%20download%20the%20PDF. Steps to convert base 64 to pdf Paste your string in the “Base64” field. Press the “Decode Base64 to PDF” button. Click on the filename link to download the PDF. After the conversion, we can store the pdf in to… Continue reading Convert Base64 to PDF using a free decoding tool
Clear the textbox in the make a copy scenario
if (scriptContext.type === scriptContext.UserEventType.COPY) { var currentRecord = scriptContext.newRecord; currentRecord.setValue({ fieldId: ‘custbody_pb_shipment_id’, value: ‘ ‘ }) }
How can we send the link of Suitelet script through the workflow
Using this syntax, we can get the link of the suitelet Page . <a href=”https://7404422-sb1.extforms.netsuite.com/app/site/hosting/scriptlet.nl?script=369&deploy=1&compid=7404422_SB1&h=fbf2566a1a5b5374ec85&po_id={id}&approver_id=1330&type_status=approve” target=”_blank” onclick=”window.open(this.href,”windowName”)”, style=”color:blue; text-decoration:underline”>Approve</a> This is the external URL link of the script .We get the External link from the script deployment page. https://7404422-sb1.extforms.netsuite.com/app/site/hosting/scriptlet.nl?script=369&deploy=1&compid=7404422_SB1&h=fbf2566a1a5b5374ec85
Error: Numeric instance is lower than the required minimum (minimum: 1, found: 0)
Code: “requestedQuantity”: {{#if this. Item_Qty}}{{{this.Item_Qty}}}{{else}}0{{/if}} Using the above code , Celigo tried to assign 0 to the ‘requestedQuantity’ in the Client system. But, ‘requestedQuantity’ field set as minimum required ‘1’ quantity. So, it shows an error. Error: { “errorCode”: “311”, “errorDescription”: [ “[Path ‘/lines/5/requestedQuantity’] Numeric instance is lower than the required minimum (minimum:… Continue reading Error: Numeric instance is lower than the required minimum (minimum: 1, found: 0)
Delete LastPass Credentials
Use the following steps to delete your LastPass credentials for a specific website: Open the LastPass folder Celigo shared with you (Company Name). Right-click on the site you want to remove from LastPass. Click Delete. This will move the site to the LastPass Deleted Items folder. Click Advanced Options in the left navigation menu, and click View deleted items. This opens… Continue reading Delete LastPass Credentials
How to share credentials with Celigo using LastPass
To access LastPass through the web portal, navigate to the LastPass home page at lastpass.com. When using the web portal in your first-time sharing credentials through LastPass, you may need to generate sharing keys in order to activate account sharing. The following steps explain how to generate access keys, which you will need to do only… Continue reading How to share credentials with Celigo using LastPass
Find active tickets in Celigo
We can find your recently submitted support tickets by logging into Celigo’s Help Center. Select your profile avatar. Select My Activities. Then we can get the details of the submit tickets
How can we submit ticket in Celigo
Celigo provided a feature to developers get assist to solve issues in the development of flows in Celigo with Celigo support team. To get this help, we need to submit ticket to Celigo. we can submit a support ticket while signed into integrator.io using the Help menu in the application sidebar. Select Submit ticket and continue on to create your ticket… Continue reading How can we submit ticket in Celigo
Convert the string data type to integer in integrator.io
Using the following handle bar, we can convert the string to integer using JSON : “width”: {{#if record. Width}}{{{record. Width}}}{{else}}0{{/if}}