4D Blog

Home Product 4D Write Pro: Assign Names to Formulas

4D Write Pro: Assign Names to Formulas

October 20, 2023

Product

In 4D Write Pro documents, formulas are crucial and contribute significantly to their functionality. Previously, these formulas could be represented as values, expressions, or symbols.

However, to further enhance the user experience and improve readability, an exciting new feature with 4D v20 R3 has been introduced: the ability to assign names to formulas. This latest enhancement allows users to quickly identify and comprehend the purpose of each formula within the document.

Download HDI: Assign Names To Formulas 

FOR WHAT PURPOSE?

Thanks to this new feature, you can display this:

…instead of this:

blank

 

How?

Two commands have been revised and improved.

WP Insert formula

The first one, the WP Insert formula, now admits two distinct syntaxes.

The first syntax is, of course, retained for the purpose of compatibility:

$formula:=This.data.customer.lastname+" "+This.data.customer.firstname
WP INSERT FORMULA($range; $formula; wk replace)

The new one allows you to use an object containing the formula and its name.

$o:=New object
$o.formula:=Formula(This.data.customer.lastname+" "+This.data.customer.firstname)
$o.name:="Customer name"
WP INSERT FORMULA($range; $o; wk replace)

WP get formulas

The WP Get formula command has not changed its syntax. It still returns a collection of objects, each corresponding to a formula. These objects have been enriched and now contain the formula name (if defined), the formula itself, and the other existing attributes (range and owner).

Form.formulas:=WP Get formulas(WParea1)

blank

ANOTHER ADVANTAGE

If formulas have been named, this will make documents more readable and hide the potential complexity of these formulas from end-users. In this case, formulas will no longer be displayed as tips in this display mode. And in the case of a display by values or symbols, the ends will no longer display the formulas themselves, but only their names!

But developers haven’t been forgotten: if you still need to display formulas as tips, simply hold down the “Ctrl” (Windows) or “Cmd” (macOS) key when hovering over them.

Conclusion

Introducing this new formula display mode in 4D Write Pro documents significantly enhances their intuitiveness and overall user experience. These documents’ readability and comprehension are greatly improved by allowing developers to assign names to formulas. This update not only makes working with document templates more accessible but also ensures a more pleasant and seamless user experience.

 

Discuss

Tags 21, 4D Write Pro, Formula, v20 R3, Word processor

Latest related posts

  • June 16, 2025

    Generate, share and use web sessions One-Time Passcodes (OTP)

  • May 20, 2025

    Automatic Refresh of OEM Build Licenses

  • May 16, 2025

    New class to handle incoming TCP connections

Roland Lannuzel
Roland Lannuzel
• Product Owner & 4D Expert •After studying electronics, Roland went into industrial IT as a developer and consultant, building solutions for customers with a variety of databases and technologies. In the late 80’s he fell in love with 4D and has used it in writing business applications that include accounting, billing and email systems.Eventually joining the company in 1997, Roland’s valuable contributions include designing specifications, testing tools, demos as well as training and speaking to the 4D community at many conferences. He continues to actively shape the future of 4D by defining new features and database development tools.
  • Deutsch
  • Français
  • English
  • Português
  • Čeština
  • Español
  • Italiano
  • 日本語

Categories

Browse categories

  • 4D View Pro
  • 4D Write Pro
  • 4D for Mobile
  • Email
  • Development Mode
  • 4D Language
  • ORDA
  • User Interface / GUI
  • Qodly Studio
  • Server
  • Maintenance
  • Deployment
  • 4D Tutorials
  • Generic
  • 4D Summit sessions and other online videos

Tags

4D-Analyzer 4D for Android 4D for iOS 4D NetKit 4D Qodly Pro 4D View Pro 4D Write Pro 20 R8 20 R9 Administration Authentication Build application CI/CD Class Client/Server Code editor Collections Compatibility settings Formula Listbox Logs Mail Microsoft 365 Network Objects ORDA PDF Pictures Preemptive Programming Qodly Studio REST Scalability Security Session Source control Speed Spreadsheet Tutorial UI User Experience v20 vscode Web Word processor

Tags

4D-Analyzer 4D for Android 4D for iOS 4D NetKit 4D Qodly Pro 4D View Pro 4D Write Pro 20 R8 20 R9 Administration Authentication Build application CI/CD Class Client/Server Code editor Collections Compatibility settings Formula Listbox Logs Mail Microsoft 365 Network Objects ORDA PDF Pictures Preemptive Programming Qodly Studio REST Scalability Security Session Source control Speed Spreadsheet Tutorial UI User Experience v20 vscode Web Word processor
Subscribe to 4D Newsletter

© 2025 4D SAS - All rights reserved
Terms & Conditions | Legal Notices | Data Policy | Cookie Policy | Contact us | Write for us


Subscribe to 4D Newsletter

* Your privacy is very important to us. Please click here to view our Policy

Contact us

Got a question, suggestion or just want to get in touch with the 4D bloggers? Drop us a line!

* Your privacy is very important to us. Please click here to view our Policy