Blogs

How To Use SOQL Parent to Child In DataRaptor

How To Use SOQL Parent to Child In DataRaptor Here we see How To SOQL Parent to Child In DataRaptor. — :  “In this post, we will create an Extract DataRaptor to retrieve account and related contact data”. Step :–  1  “We are creating a new Extract DataRaptor.” /*! elementor – v3.18.0 – 20-12-2023 */.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=”.svg”]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block} Create a new DataRaptor Step :– 2 On Extract create mapping as show on below image. Select Object Step :– 3  “Map the output fields as shown in the image below.” In OUTPUT Step :– 4   “In the Preview Tab, click on ‘Execute’.” on preview tabSalesforce Guide =https://help.salesforce.com/s/articleView?id=sf.os_dataraptor_extract_overview.htm&type=5

How To Use SOQL Parent to Child In DataRaptor Read More »

How to Make KeyValue To Array in Transform DR.

First let’s create a DataRaptor Transform. /*! elementor – v3.17.0 – 01-11-2023 */ .elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=”.svg”]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block} Now we go to the Transform Tab and click on the Plus(+) icon. then go to the Output JSON Path and type type Fields|1 . And type Contact:first_name in the Input JSON Path.(to fetch the fields of an object, use : ). Similarly we add more fields of the User(Fields|2) Click on Preview Tab and write down in input json. {  “Contact”: {    “firstName”: “Sumo”,    “lastName”: “Jensen”  }}then CLICK Execute Buttom. So Output results SHOW.(according my input json)

How to Make KeyValue To Array in Transform DR. Read More »

How to AutoPopulate fields in Omniscript

In this blog we create set value and populate the value in the field of omniscript when ever we select an option. Create a Omniscript and drag SetValues.  Click on the setvalues.  Create two values in setvalues, see below image . Drag Select Properties on the canvas. Click Add New Option in select input to make a picklist type value. Fill Value and Label field like below Image. Select two text block poperties to show the result when we click on button / option. Click Text and fill values in %% sign  like below image so we can get the action . Click Preview and Select an Option we will see the value what we pass in setvalues .

How to AutoPopulate fields in Omniscript Read More »

How To Use Messaging Input In OmniScript

Create an Omniscript. Messaging elements can be used to display success, warnings, comments, or requirements based on the validation expression. /*! elementor – v3.18.0 – 20-12-2023 */ .elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=”.svg”]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block} Create A Omniscripts First I am Drag & Drop Text Field in Canvas and Messaging Function. Expression=If Name<> NULL than Show the message “Thanks” . And expression == NULL So display Show “Please Fill The Tab”. Messaging Add to Omniscript Same thing on message display Whichever Condition is given in validate expressions. When the validate  expression is true then it follow true expression and if it is false then it follow false. This validate expression is displayed only when the active checkbox is checked. Note- If requirement is selected in validate expression then navigation is not possible without validating. Lets Preview it See the JSON See The JSON Expression Is True & False To display the message, select the type of message to be displayed when the validation expression returns true or false and add the message to be displayed. I hope you understand the use of messaging function.

How To Use Messaging Input In OmniScript Read More »

How to use Transform DataRaptor in Array to KeyValue.

First let’s create a DataRaptor Transform. /*! elementor – v3.17.0 – 01-11-2023 */ .elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=”.svg”]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block} Now we go to the Transform Tab and click on the Plus (+) icon. then go to the Output JSON Path and type Contact:firstName . (To fetch the fields of an object, use:). And type first_name in the Input JSON Path. Similarly, we add more fields of the User(last_name) Now we can the formula by going to the Formula Tab. type Fields|1 in the formula and type first_name in the output result path. In this way we create another formula. Click on Preview Tab and write down in input json. {“Fields”: [    “Sumo”, “Jensen”]} then CLICK Execute Bottom. So, Output results show according to my input Json)

How to use Transform DataRaptor in Array to KeyValue. Read More »

How To Make Formula in OmniScript

  — :  “In this post, we create a Date Formatter to showcase the date format. In the Formula field, establish a logic for the date format.” Step :– 1  “We are creating an Omniscript with three text fields (for DD/MM/YYYY) and one formula field (to calculate the format).” /*! elementor – v3.18.0 – 20-12-2023 */ .elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=”.svg”]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block} text field for input and formula field for calculate // in formula field IF(%Text1%>10,%Text1%,0+%Text1%),IF(%Text2%>10,%Text2%,0+%Text2%),IF(%Text3%>10,20+%Text3%,200+%Text3%)  Step :– 2   On preview tab we pass date  We find date format  Salesforce Guide- https://help.salesforce.com/s/articleView?id=sf.os_create_a_formula_or_aggregate_in_an_omniscript.htm&type=5

How To Make Formula in OmniScript Read More »

How to use TypeAhead With Json Data In Omniscript.

In this post we will learn how to use TypeAhead With Json Data in the omniscript. Example:- Here we create an omniscript and when user type any Account name it starts giving suggestion. Step:-1  Create an omniscript and Drag a TypeAhead ,text field ,Extract dataRaptor in it.and Name every component. Create a dataraptor to extract data from the database.

How to use TypeAhead With Json Data In Omniscript. Read More »

How to use Tansform DataRaptor

How to use Tansform DataRaptor in One Object to Multiple SObject Information. /*! elementor – v3.18.0 – 20-12-2023 */.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=”.svg”]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block} Now we go to the Transform Tab and click on the Plus(+) icon. then go to the Output JSON Path and type User:FirstName .(to fetch the fields of an object, use : ). And type FirstName in the Input JSON Path. Similarly we add more fields of the User (LastName,Email,Username). Salesforce guide == https://help.salesforce.com/s/articleView?id=sf.os_dataraptor_transform_action.htm&type=5 Now we Transform Parent to Child record.so now we type Account:Contact:FirstName in the Output JSON Path and type FirstName in the Input JSON Path. Similarly, we add more fields of the Contact records (LastName, Email, State, Street). Now we take the Account records so type the Account:Name in the Output JSON Path and type Name in the Input JSON Path. Similarly we add more fields of the Account(website, state, street). Click on Preview Tab and write down in input json  {  “FirstName”: “My”,  “LastName”: “Maurya0”,  “Email”: “Maurya0@gmail.com”,  “Street”: “Mau”,  “State”: “UP”,  “Name”: “ABC”,  “Website”: “www.abc.com”,  “Username”: “maurya@.com”}then CLICK Execute Buttom.So Output results SHOW.(according my input json) I hope you understand how to transform dataraptor in Omniscript for Salesforce.

How to use Tansform DataRaptor Read More »

How to use Look up Field in DataRaptor Load.

In this blog we use to Lookup field in DataRaptor Load. First let’s create a DataRaptor Load. /*! element or – v3.17.0 – 01-11-2023 */ .elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}. element or-widget-image a img[src$=”.svg”] {width:48px}. element or-widget-image img{vertical-align:middle;display:inline-block} You can select any one of these objects. We have selected the Account Object. Now we select two fields. 1. Name- First we go to the Domain Object Fields and select the Name Fields, then go to  the Input JSON Path and type the name. 2. Website- Now we go to the Domain Object fields and select the Website, then go to the Input JSON Path and type the username. Now here we locate the email of our user id in the website. Now we tick isLookup option of the website field and then select the user from the Lookup object and select the username from the Lookup field and then select the Email from the Lookup Requested Field. (You can select your fields as per your requirement) Now we type the inputs json the name of my account and the username of the user whose email we want to capture. { “name”: “Lookup Account 1″,”username”: “abc@maurya.com”} Then click on execute. Output Result.(my account) “Account: 0015j00001VTSy7AAH” NEXT

How to use Look up Field in DataRaptor Load. Read More »

Scroll to Top