4D View Pro automatically recalculates the formulas in your worksheet when you change data they depend on (e.g., entries, formulas, names, etc.).
But what if you want to make your UI more interactive and trigger the calculation of formulas whenever you want? 4D v18 R4 makes it possible thanks to three new commands: VP SUSPEND COMPUTING, VP RESUME COMPUTING, and VP RECOMPUTE FORMULAS. These commands let you suspend and resume the calculation of all formulas in your document, or force their recalculation.
Have you ever created an HTTP data request only to get hit by a red “access to HTML request has been blocked by cors policy” error?
When your site is on the same domain as the web service server, there’s no problem. However, this isn’t the case when performing a cross-origin request. Access is denied due to browser security preventing HTTP requests to another domain. The result? A CORS policy error.
To help you explicitly allow certain cross-origin requests on your server, 4D now supports the CORS protocol. Accessing data with cross-origin requests just became easier!
Often when you create a table, you might need to combine two or more cells to create a centered title on a particular section of your table. As of 4D v18 R4, a new set of commands is at your disposal to help you merge and unmerge a group of cells by programming. Let’s take a look at some examples.
In 4D v18, we introduced a new way to send emails. Then in 4D v18 R2, we added a new way to retrieve emails using POP3. Now in 4D v18 R4, we’re taking the first steps for a new way to handle the IMAP protocol. As we did for SMTP and POP3, there’s a new IMAP New transporter command to handle the IMAP protocol.
The Internet Message Access Protocol (IMAP) is an Internet standard protocol used by email clients to retrieve email messages from a mail server. This protocol makes it possible to manage multiple mailboxes, download emails, perform searches on the server, manage message state, and a lot more!
And with this first IMAP feature, you can add methods to the transporter to: have the list of the available mailboxes, select a mailbox, and receive email from the selected mailbox. Let’s see how.
An increasing number of developers are using the Form command to link their form objects and many of you require easy programming access to the values of those objects. So, to help you access the value of a form object, regardless of its variable or expression, we’ve added two new commands: OBJECT Get value and OBJECT SET VALUE.
Let’s see how to use them!
Want to dynamically generate 4D View Pro documents on a server and, for example, send them by email or calculate values? 4D v18 R4 introduces a new command to manipulate 4D View Pro commands in an offscreen area: VP Run offscreen area.
Do you need to load web pages, extract metadata, or generate pictures from the contents of pages on a headless server? If you answered “yes”, then you’re in luck because 4D v18 R3 makes it possible! Now you can create an offscreen web area with the WA Run offscreen area command.
Do you need to store all business emails, for example, for legal or fiscal purposes? These documents must be stored as they are. That is, how they were received … in their original, unconverted formats. 4D v18 R3 answers this need by providing you with a new method allowing you to get emails in their original MIME format.
To create user-friendly documents, you often need to hide a gridline or header, protect certain cells, or simply change the line color to respect the corporate identity. With 4D v18 R3, you can do all this and more with the new VP SET SHEET OPTIONS command.
XPath is a language allowing you to easily work with your XML documents. It’s already usable via the DOM Find XML element command and with 4D v18 R3, the support of the XPath syntax has been drastically enhanced. If you’re among those who requested features such as using a wildcard in a path, then keep reading!
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