What to be done??? Normalize the values with TO_NUMBER and TO_NCHAR, then concatenate them using the following formula: CONCAT(CONCAT(‘Days: ‘,TO_NCHAR(FLOOR(TO_NUMBER(TO_NCHAR({timeelapsed}/24))))), CONCAT(‘ Hours: ‘,TO_NCHAR(MOD(TO_NUMBER(TO_NCHAR({timeelapsed})),24)))) What would be the output??? String
Category:
The Role of the Personalization Worksheet in NetSuite SuiteSuccess
Implementing an ERP system can feel overwhelming, especially when every business has its own way of working. NetSuite addresses this challenge through its Personalization Worksheet, a structured discovery tool used during the Engage phase of SuiteSuccess delivery. The worksheet is more than just an Excel file — it’s a guide for consultants and customers to… Continue reading The Role of the Personalization Worksheet in NetSuite SuiteSuccess
Creating New Records for Projects
Depending on the features you have enabled, you can create new records for projects. Read Customers for information about entering a new customer record. Read Creating a Basic Project Record for information if you have enabled the Projects feature but not enabled the Project Management feature. Read Creating a Project Record for information if you have enabled the Project Management feature.… Continue reading Creating New Records for Projects
Using NetSuite AI Connector (MCP) with Postman: Step by Step Guide
Prerequisites NetSuite (NS) Account. Relevant features enabled and permissions provided to the role. NetSuite MCP SuiteApp or at least one Custom Tool deployed in the NS instance. Postman Enable Features In NetSuite, navigate to: Setup → Company → Enable Features → SuiteCloud (last tab), and enable the following features. You may see additional options listed,… Continue reading Using NetSuite AI Connector (MCP) with Postman: Step by Step Guide
Manual execution in Boomi
Manual Execution Manual execution allows users to trigger a deployed Boomi process directly from the platform interface, bypassing automated schedules or external triggers. This is especially useful during development, debugging, or when immediate data processing is required. Steps to Manually Execute a Process 1. From the Manage menu, From the dashboard, select either: Process Reporting:… Continue reading Manual execution in Boomi
Creating a simple flow in Boomi
🧭 What Is Boomi Flow? Boomi Flow is a cloud-native workflow automation tool that allows users to: Design interactive applications using a drag-and-drop interface Connect to external systems via Boomi Integration Build workflows that span multiple steps, users, and system 1. Create a New Process Log in to Boomi AtomSphere. Go to Build → Click… Continue reading Creating a simple flow in Boomi
Exploring the Test Function in Boomi
In Boomi AtomSphere, building an integration process is only half the journey. The other half is making sure it works as expected. That’s where the Test function comes in—a powerful feature that lets you simulate and validate your process before deploying it into production. Whether you’re syncing data between systems, transforming records, or handling complex… Continue reading Exploring the Test Function in Boomi
To Change the sales order form based on the Domain.
We can create an extension to check the domain. For this, we have created a configuration record and a transaction body field. If the domain matches as expected, we will add the corresponding form to the sales order during creation. Using a workflow, we can then set a condition: if the transaction body field contains… Continue reading To Change the sales order form based on the Domain.
How to Use Subcollections in Firebase Firestore and Create Multiple Child Items
When working with Firebase Firestore, you’ll often need to store related data in a structured way. For example, an Order document might contain multiple Items, or a Post might have many Comments. Firestore provides a powerful way to handle this scenario using subcollections. In this article, we’ll cover: 🔹 What subcollections are in Firestore 🔹… Continue reading How to Use Subcollections in Firebase Firestore and Create Multiple Child Items
Converting Subtask to Task in Jira
To Convert a Subtask to a Task in Jira, follow these steps: Open the Subtask: Navigate to the subtask you want to convert. Access More Options: Click on the three dots (…) in the top-right corner of the subtask window. Convert to Issue: Select the “Convert to Issue” option from the dropdown menu. Select New… Continue reading Converting Subtask to Task in Jira