4D View Pro: Create a Pivot Table from a data table
Pivot tables are among the most valuable features that allow users to swiftly summarize and analyze large quantities of data to see comparisons, patterns, and trends in their data. From the 4D v19, pivot tables are included in 4D View Pro. This blog post reviews how to use a pivot table through the ribbon interface.
IMAP: Mailbox Id and mail keywords
4D v20 brings two very useful features to IMAP Transporters!
Interacting with some IMAP mail servers and clients requires to manage custom keywords in mails, and benefit from some of their specific features.
We also added the mailbox ID support in our IMAP Transporter so that you can identify a given mailbox even after it is renamed.
Comparison with an Undefined Value
Since the appearance of ORDA, classes, and other objects, you must work increasingly with undefined values.
Since some of you are asking for an easier way to use them, starting with v20, you can compare any type of value to an undefined value without throwing an error.
New Built-in Websocket Server
In an increasingly connected world, websites or IoT applications must be updated in real-time.
A way to deliver information instantly to your sites is to use the Websocket protocol that provides a full-duplex communication channel between a server and a client. From the v20, 4D provides commands to create a Websocket server.
POP3: Download the Mail Header Only
When retrieving email messages using POP3, it’s possible to retrieve just the message headers (which include information such as the sender, subject, and date) without downloading the entire message body.
Retrieving just the message headers can be helpful when you want to quickly scan the list of messages in your mailbox to decide which ones to download and read in full.
Starting with 4D v20, a new parameter is added to the .getMail() function of the POP3 transporter to receive your emails without the body. This function can be even more helpful if you use Gmail because it does not trigger the deletion of read emails.
Microsoft 365: Create, delete, and rename mail folders with the Microsoft Graph API
To access the data in Microsoft 365, like emails, Microsoft is deprecating Basic authentication for IMAP and POP3 and is increasingly promoting the Graph API.
With this last set of functions that includes all the features to manage folders from the 4D v20, you have in 4D NetKit a set of functions to manage your mailboxes by programming with the Microsoft Graph API.
Object and Collection Literal Initializer
In your code, objects and collections can be instantiated using New object and New collection commands.
However, starting from 4D v20, a more convenient and readable approach is available using object literals and collection literals. These new features provide a simpler and clearer way to initialize objects and collections.
4D View Pro: What’s New in 4D v20
With every release, the 4D View Pro features list is growing. And this feature release is no exception: 4D v20 comes with a new version of SpreadJS, the v16, and a Ribbon update that is compatible with it.
Let’s discover the new features offered by this new version.
Microsoft 365: Copy, Move, Reply and Delete emails with the Microsoft Graph API
To access the data in Microsoft 365 like emails, Microsoft is deprecating Basic authentication for IMAP and POP3 and is increasingly promoting the Graph API.
From v19 R8, you now have new built-in commands in 4D NetKit to natively automate Microsoft 365 emails operations, such as copy, move, reply and delete emails.
4D View Pro: Customize the Style of your Tables
Tables are an integral part of 4D View Pro documents, so we have provided many table-related features over the releases of 4D. 4D v19 R8 adds a new one related to styles so that the table fits perfectly with the rest of your document.
From now on, the VP Set table theme provides a way to apply by programming one of the predefined table styles. If none of these styles meet your need, you can define your own theme and apply it to your table.
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