Valorx
Fusion
Fusion
  • 👋Introduction
  • Getting Started
    • 🧩What is a Valorx App?
    • 🚀Getting Started with Valorx Fusion
      • Salesforce Setup
      • Connections List
      • Apps List
      • Favorite Apps
      • App Promotion and Provisioning
      • App Administration
      • Valorx Administration
    • 🏫Building your first App
      • Express Mode
      • Express Actions
  • SIDEBAR ADD-IN: EXPRESS
    • 🔍Getting Started
    • ⚡Unlock the Full Potential of Express
  • Design Studio
    • 💡The power of Design Studio
      • 👨‍💼Manage Your Valorx Account
        • Sign Up to Valorx Account
        • Reset Password
        • General Information
        • Active Subscription
        • Environments
        • Users
        • Billing Address
        • Get a Demo
    • 🖥️Open an App in Design Studio
    • 📊Data Modeling
    • 🏳️‍🌈Maps
      • Grid Map
      • Form Map
    • 🎨Tasks
      • Query
      • API
      • Macro
      • Dataset
      • Add/Delete
      • Document
      • Data Import
      • Refresh Ribbon
      • Clear
      • Launch CRM
      • Refresh Map
      • Add Field
    • 🖌️Workflow and UX
      • Workflow Settings - Button Click
      • Workflow Designer
      • Toolbox
      • Common Tasks
      • Utility Tasks
      • Salesforce APIs
      • Query
      • API
      • Launch CRM
      • Macro
      • Dataset
      • Add/Delete
      • Document
      • Refresh Ribbon
      • Clear
      • Refresh Map
      • Add Field
  • Runtime
    • ⏱️Runtime UX
      • Run at App Launch
      • Launch from Salesforce (LFS)
      • App Permissions
    • 🧰Toolbox
    • 🌐Supported Platforms
      • Microsoft Excel for Windows
      • Microsoft Excel for Mac
      • Google Sheet
        • Introduction
        • Getting Started
        • Pop-up Blockers
        • Expected Behaviors
        • Runtime
          • Hot Upgrade
          • Google Sheets Collaboration
          • Insert Row Using Right-Click Options
  • Settings
    • ⚙️Valorx Fusion Settings
    • 🛠️App Settings
    • 📜Logs
  • App Store
    • 📱App Store Submission
    • 💫Installing App
    • 🎮Customizing App
  • Miscellaneous
    • 🛩️Mass Rollout of Valorx
    • 🍭Open Source Licenses
  • Valorx Home
    • 🏠Valorx Home
  • Versions and Release Notes
    • 🪟Windows
      • April 25 Release (V17)
      • Jan 25 Release (V16)
      • Feb 24 Release (V15)
      • Jul 23 Release (V14)
      • Nov 22 Release (V13)
      • Aug 21 Release (V12)
      • Apr 21 Release (V11)
      • Dec 20 Release (V10)
      • Nov 20 Release (V9)
      • Managed Packages
        • Version 2.0
        • Version 1.7
      • Older Versions
        • Aug 20 Release (V8)
        • Jul 20 Release (V7)
        • May 20 Release (v6)
        • Feb 20 Release (V4)
    • 📗Google Sheets
      • February 25 Release (v64)
      • October 24 Release (v63)
      • September 24 Release (v62)
      • August 24 Release (v61)
      • July 24 Release (v59)
      • June 24 Release (v58)
      • Older Versions
        • Jul 23 Release (v57)
        • Apr 23 Release (v56)-Hotfix
        • Apr 23 Release (v55)-Hotfix
        • Mar 23 Release (v54)
        • Mar 23 Release (v53)
        • Feb 23 Release (v52)
        • Jan 23 Release (v51)
        • Oct 22 Release (v50)
        • Jul 22 Release (v49)
        • Mar 22 Release (v47)
        • Feb 22 Release (v46)
        • Dec 21 Release (v45)
    • 🍎Mac
      • March 25 Release (v45.1 - Hotfix)
      • March 25 Release (v45)
      • February 25 Release (v44)
      • January 25 Release (v43)
      • October 24 Release (v42)
      • September 24 Release (v41)
      • August 24 Release (v40)
      • July 24 Release (v38)
      • June 24 Release (v37)
      • Older Versions
        • Feb 24 Release (v32)
        • Dec 23 Release (v31)
        • Oct 23 Release (v30)
        • Aug 23 Release (v27)
        • Jul 23 Release (v26)
        • Apr 23 Release (v25)
        • Mar 23 Release (v24)
        • Jan 23 Release (v23)
        • Nov 22 Release (v22)
        • Oct 22 Release (v21)
        • Sep 22 Release (v20)
        • Jul 22 Release (v19)
        • Apr 22 Release (v18)
        • Dec 21 Release (v17)
        • Nov 21 Release (v16)
        • Sept 23 Release (v28)
Powered by GitBook
On this page
  1. Runtime

Toolbox

Last updated 6 months ago

Toolbox is another section of our Runtime UX. Toolbox will have six elements like Inset Row(s), Clear Row(s), Delete Rows, Lookup, Customize Grids, Multiselect Picklist and Mass Modifier. Designers will find this under Workflow Ribbon UX.

Below is the image of the Design Studio as the Toolbox will not be visible on the Valorx Ribbon.

Open the app in Design Studio, and click on Workflow and UX. Designers will find Runtime UX where we will find the Toolbox.

Below is the image of the Runtime Ribbon and Designer has an option to select which button to show up on the Runtime Ribbon.

Insert Row(s) : Users will be able to insert rows from 1-10,000. Users need to place the cursor on the designated cell where they need rows to be inserted and click on Insert Row(s). Then, rows will be added to the Excel. We can find a drop-down which will have 1-10 range of numbers which users can select and insert rows.

If users need more rows, then click on Custom Rows, and an Insert Row(s) window will pop up. Enter the number of rows required under ADD NUMBER and click OK.

Clear Row(s) : As the name tag says users will use this to clear the rows. This will only clear the data from the rows but not clear any data from our database. Select the rows which needs to be cleared and click on Clear Row(s).

Delete Row(s) : User will use this to delete the rows. Delete rows will delete the data from the Excel as well as from the database. Select the rows which needs to be deleted and click on Delete Row(s).

Customize Grid : Designer can customize the grid of the Excel sheet. Select a Map and click on Edit. Click on Display Options and check in the option "Allow adding dynamic columns (runtime mode).

Now, Users can find the option of Customize Grid on the Runtime Valorx Ribbon.

Multiselect Picklist: This option needs to be configured from Design Studio to display on our Runtime. Configure the details those needs picklist from Data Modelling and Maps.

Mass Modifier

Mass Modifier is a new feature introduced in our V13. Mass Modifier helps Designers or users when they have huge or bulk data to modify or when they want to apply changes to the data. Users need to enable this feature under Workflow and UX to find this on the Valorx Fusion Runtime Ribbon tab.

Users need to follow the below steps once Mass Modifier is enabled:

  • Open an App in Runtime and click on Mass Modifier.

  • A Mass Modifier window will open which will have the below fields.

  • Select the name of the field from Field Name drop-down menu. It will show the selected field by default.

  • Select Apply On from the drop-down menu.

  1. All Records – It will apply the changes to all the records

  2. Selection – It will apply the changes to the records selected

  3. Visible Records - Changes are applied to those records which are currently visible on the excel sheet

  • Select Action from the drop-down menu.

Note: Always provide the Input Value when you select Change to, Suffix, or Prefix as your Action.

  • Click Change to select the Grid of your Apps on that worksheet. It will display all the Maps available for that App.

  • Click Apply to find the changes made.

Rich Text Editor

Rich Text Editor is a powerful feature of our Workflow and UX Toolbox. With this feature, users now have the ability to edit the "Text Area" using the dedicated Valorx editor. The Rich Text Editor can be accessed conveniently through the Toolbox buttons located under the Valorx Runtime ribbon.

To take advantage of this exciting feature, users will need to enable the Rich Text Editor button under Workflow and UX settings. Once enabled, users can leverage the full functionality of the Rich Text Editor to enhance their text editing experience.

  • Open an App in Design Studio and click Workflow and UX from the Valorx Fusion ribbon button.

  • Enable “Rich Text Editor” under Toolbox.

  • Click Data Modelling and select the fields with text under Data Modelling. (Long text or Rich text).

Create a Custom object and add a Field in Salesforce in case you do not find fields with Rich Text in Data Modelling.

  • Save and run the app.

  • Select a field and click on Rich Text Editor from the Runtime ribbon button under Toolbox.

  • Make the desired changes to the content using the available formatting options provided by the Rich Text Editor.

  • Once done with the changes click on Continue.

Note: Editing will overwrite the text and direct changes to the columns is not allowed.

The Long text field will show up in the dropdown of the Rich Text Editor if the content of the Long text field exceeds the excel cell limit (32,767 characters).

Expected behavior of the Rich Text Editor

Scenario 1: If the data is not displayed, clicking on the Rich Text Editor button should not open the editor interface, allowing you to enter or edit text.

Scenario 2: If data is present and your cell focus is outside the map-range, clicking on the Rich Text Editor button would typically have no direct impact on the displayed data. The Rich Text Editor button is usually used to format or edit text within a specific range or field. If the cell focus is outside the map-range, the button's functionality may not be directly applicable to the displayed data in that scenario.

Scenario 3: When there is no Rich Text area on the map, the message displayed would typically inform the user that the Rich Text Editor functionality is not available for the current context. This message is intended to communicate that the Rich Text Editor feature cannot be utilized because there are no applicable areas or fields where text editing or formatting is supported using the Rich Text functionality.

To create a field in Salesforce, follow these steps:

  1. Log in to Salesforce and go to Setup.

  2. From the Setup menu, navigate to Object Manager.

  1. Open the desired Object and select Fields & Relationships.

  2. On the right-hand side, click on New.

  1. Choose Text Area (Long, Rich) and click Next.

  1. Enter the desired name for the field in the Field Label field.

  2. Modify the Length if necessary and click Next.

  3. Proceed to the next steps by clicking Next and then Save.

To add records to an object in Salesforce, adhere to the following guidelines:

  1. Go to Sales and access the Object you want to modify.

  2. Select New and specify the Account Name by providing the field name.

  1. Enter the desired input in the any of Rich text or Text Area field.

  2. Click on Save to save the changes.

🧰