# Data Interaction

Efficient data management is key to a seamless workflow, and **Valorx Wave** offers multiple ways to interact with your data. Whether you need to update entity relationships, customize layouts, or perform bulk actions, these features help streamline your experience.

## Row Operations

Valorx Wave allows various types of row operations, including:

> * [x] Expand Row Details&#x20;
> * [x] Right Click Operations
> * [x] Other Operations&#x20;
> * [x] Excel-like operations&#x20;

### Expand Record Details

**Hovering** on the **Sr. No. Column** will show the Expand icon. Use it to **expand** and **edit** the record details.&#x20;

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FKjC3y9qBEwnXPlF1H3kW%2FWR%2016.png?alt=media&#x26;token=f5e73c36-24ea-4990-8d2a-697e1829307c" alt="" width="405"><figcaption><p>Expand Record Details</p></figcaption></figure></div>

When you click on the Expand icon, the **Record Details** screen will open as shown in the image below.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FSKdupxC4zXgDKird3WPh%2FWS%203.png?alt=media&#x26;token=54ace7cf-2b41-4e02-98eb-f5368833f623" alt=""><figcaption><p>Expand Record Details: Record Details Screen</p></figcaption></figure>

> 1. The Details tab will open by default.&#x20;
> 2. The Object Information title shows the record's Object name, i.e., Account Information, Opportunity Information, etc.  &#x20;
> 3. The other tabs show more details about the record. For example, the image shows orders, contacts, contracts, opportunities, cases, and partners related to the account Aaron Bergman. If there are no associated records in Salesforce for the account, those tabs are shown deactivated. For example, the image shows Open Activities, Activity History, and Notes.
> 4. Use the Field Layout icons to change the visual layouts of the fields. &#x20;

If you make any changes in the Record Details screen, the Changes button will appear. Click it to preview the Changes. You can revert any changes if required. &#x20;

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FScBdHuQJEdK8HwrkNurS%2FWS%204.png?alt=media&#x26;token=1584fbc6-4c48-401d-8023-af9e93c0aa28" alt="" width="306"><figcaption><p>Expand Record Details: Preview Changes</p></figcaption></figure></div>

### Edit Record Details Layout&#x20;

Editing a layout allows user to customize the appearance and arrangement of fields to better suit user's workflow. By selecting and organizing fields, user can create a layout that meets specific needs and enhances overall user experience.

1. Use the "**Edit layout**" button to edit the layout properties or make a custom layout.
2. In the "**Layout Properties**" tab, rename the layout as needed and save your changes.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2Fu1KXIYGrkH0cUK56Sk23%2FLayout.gif?alt=media&#x26;token=a7943d07-732d-433f-978f-65c61ddbf0cf" alt=""><figcaption></figcaption></figure>

3. Users can customize the layout by adding **Object Fields**, **Design Elements**, and **Related Lists**. Click the '**+ Add Element**' button at the bottom left, then drag and drop the selected elements into the desired positions within the layout.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FMVGTGd5xbRYVvQaXeG4B%2FLayout%202%20Add%20Element.gif?alt=media&#x26;token=d92159c1-9767-4718-818b-ced6068e7e73" alt=""><figcaption></figcaption></figure>

4. Users can **rearrange** any element by clicking the a "**drag handle**" (six dots) and dragging it to the desired position. To **delete** an element from the layout, simply click the **dustbin icon**.
5. Once you've finished editing and customizing the layout, click "**OK**" to save your changes.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2F25qnO8nutQLWWj0LcGgB%2FLayout%203%20Delete%20and%20Drag.gif?alt=media&#x26;token=d995aa25-5546-416a-8493-629c1e0f136c" alt=""><figcaption></figcaption></figure>

### **Right-Click Actions in Grids**

Easily manage records using the **right-click contextual menu**. The menu now includes improved action labels and a clearer layout for a smoother experience.

**Available actions:**

* **Copy** – Copies the selected cell or data.
* **Copy with Headers** – Copies data along with the column headers for easier pasting into grid.
* **Paste** – Inserts copied data into the selected cells.
* **Expand Record** – Opens a detailed view of the selected record.
* **Open Record in Salesforce** – Navigates directly to the record in Salesforce.
* **Insert Row Below** – Adds a new row beneath the selected one.
* **Duplicate** – Creates a copy of the selected record.
* **Delete** – Removes the selected record after confirmation.
* **Last Modified By** – Displays the user last modification.

This feature helps you perform common actions faster and with better visibility, reducing the need for extra clicks or navigation.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FluYED7tbNOAiBcP3SBUw%2FRight%20Click.gif?alt=media&#x26;token=ba81e93f-8cf4-4af8-9841-86e0dcb5925e" alt=""><figcaption><p>Right-click action</p></figcaption></figure>

### **Left-Click Actions for Lookup Fields**

You can now **left-click** on any lookup field value to preview or open the related record directly in Salesforce.

This simple interaction makes it easier to explore related data without interrupting your workflow or leaving the grid view.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FcQOiaDYKMfN6cG7wnZEY%2FLeft%20Click%20Lookup.gif?alt=media&#x26;token=a8177085-6d6c-4ebe-953f-96608e8ead1e" alt=""><figcaption></figcaption></figure>

### Other Operations&#x20;

1. Click on any cell of the column having a Picklist drop-down icon on the column header. Click on it again to open the picklist and edit the record by selecting another value if required.

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2F8aulpyHxfItMbawW8FBG%2FWR%2017.png?alt=media&#x26;token=c06cf29e-8571-4a8e-bf10-262fd1dbd769" alt="" width="339"><figcaption><p>Picklist drop-down</p></figcaption></figure></div>

> 1. Picklist drop-down
> 2. The icon on the column header indicates that the Picklist drop-down is available for this column

2. Click any cell of the column with the Calendar icon on the column header. Click the Calendar icon to make changes to the date record.

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FV9MHqeNUfRDvBFcP0BNS%2FRelease%20Notes%20V27%20-%2026.png?alt=media&#x26;token=eb0e608b-d842-4e09-a76e-129b13d70e9b" alt="" width="237"><figcaption><p>Calendar</p></figcaption></figure></div>

3. Hovering on the Object Name cell will show the Activity icon. Click on it to see, edit, and create activities related to the record. &#x20;

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FpBuQWwmJa36YKjJzobFi%2FWR%2019.png?alt=media&#x26;token=3d3c4ae0-98b6-4284-ade9-a267c4245180" alt="" width="275"><figcaption><p>Open Activities</p></figcaption></figure></div>

4. The record will be visible in the **Attachment** column if it already has an attachment. Hovering over any field in the Attachment column shows the message **Drop files here**. You can upload or drop the file to attach it to the record.&#x20;

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FpeIOpyyHqu3ShVLIwoTG%2FWs%208.png?alt=media&#x26;token=1b32133b-f740-4ff2-8b41-91e17664f8d9" alt="" width="204"><figcaption><p>Adding Attachment</p></figcaption></figure></div>

> Use the Expand icon to expand the attachment details.&#x20;

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FpgG82IPEOCkILYviG4yS%2FWs%206.png?alt=media&#x26;token=8efdcd2f-82ad-4c7b-81f8-a6521369f7ec" alt="" width="254"><figcaption><p>Expanding Attachment</p></figcaption></figure></div>

> The Attachment Details screen shows information about all attachments of the record segregated as All, Documents, and Media. Use the screen to download or delete the attachments.

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FkWrpBhgQ0cK73AcO1sMp%2FWS%207.png?alt=media&#x26;token=f0543fda-6c50-48d6-989c-66ddba4e80c4" alt="" width="563"><figcaption><p>The Attachment Details Screen</p></figcaption></figure></div>

### Excel-like Operations

You can perform the following Excel-like operations in Wave Spreadsheet:

> * [x] Resize columns&#x20;
> * [x] Copy and paste records from one cell to another cell&#x20;
> * [x] Drag and fill

* **Drag and Fill**

**Double-click the Drag Icon to copy records** in the column cells. This feature makes copying record values in Valorx Wave as swift as Excel and Google spreadsheets.&#x20;

> The Drag icon appears when you click on any cell.&#x20;

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FvsHzYOAItZRnFJfFqC0U%2Fimage.png?alt=media&#x26;token=41d1342e-7fc6-44fe-94d5-db82673b1014" alt="" width="444"><figcaption><p>The Drag Icon in the Grid Screen</p></figcaption></figure></div>

> You can double click the Drag icon to copy the record values in the column cells.&#x20;
>
> * If all column cells are empty, the record value of the selected cell will be copied to them.
> * If values exist in a few cells, the **Fill Option** message will appear, as shown in the image below. The user can choose the fill options as per requirements.

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FgK5ERCEbdFFUvkxAv0Qd%2Fimage.png?alt=media&#x26;token=3da86433-5d4b-4a15-8058-85221bd2b34d" alt="" width="445"><figcaption><p>The Fill Options Message</p></figcaption></figure></div>

Note: This feature will not be available to the Boolean fields (The fields with the checkbox or tick mark).

***

## Add Button

Add button helps you to perform multiple functions such as:

1. Entering a **single record** (new row) in the Grid.
2. Entering **Multiple records** at a time.
3. Adding **Related List(s)**.
4. Adding new **Fields** related to the Object in the grid.&#x20;

<div align="left"><figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FrrnttUIAwYY1MPcNoZkz%2FRelease%20Notes%20V27%20-%2028.png?alt=media&#x26;token=5ac2083e-33f7-47ae-9943-786b09beb0b1" alt=""><figcaption><p>Add button</p></figcaption></figure></div>

### Related List Display Options

* Choose **Related List Display Options**:
  * **Hierarchical Grid** – Displays related records in a structured, expandable format.
  * **Right Panel** – Shows related records in a side panel for easy reference.
* **Default Hierarchical View:**

  * For Global, Custom, and Standard grids that include a related grid (master-detail), the related list will automatically open in Hierarchical view, providing a clear, nested display of your data.

  <figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FbDwZEEfjTQZaHqN3vTmb%2FHierarchical%20View.gif?alt=media&#x26;token=63d1c52f-1e4d-4ea6-9a8f-c85d81e68850" alt=""><figcaption><p>Hierarchal View</p></figcaption></figure>
* **Alternate Right Panel View:**

  * Users have the option to switch to the Right Panel view if that layout better suits their workflow. \
    \&#xNAN;*Note: This is not applicable for Salesforce and Shared grid.*

  <figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2Fit3dRDgiyqPSmAsnjXg4%2FRight%20Panel%20View.gif?alt=media&#x26;token=1a2d7b89-b7a9-470e-92ac-411a6f809c7b" alt=""><figcaption><p>Right Panel View</p></figcaption></figure>
