Tips

4D View Pro: End of document loading

Automatically translated from English

When you use 4D View Pro (especially in offscreen mode) with complex documents, calculating all formulas could take a while and it can be difficult to know when it’s finally finished (and it’s important to wait before you call commands such as export or print).

As a solution, we’ve introduced two new events. One of which is called for every single calculation/formula, which could be used to trigger a timer. If the time expires without another formula being finished, we can assume that the whole document is finished.

Tips

4D Write Pro – Full text indexation

Automatically translated from English

“I want to find all of the documents that talk about tango! I need them quickly! Can I do that?”

Ok, but first breathe!

Keyword searches within 4D Write Pro documents simply require adding a new indexing attribute within each document. This isn’t done by default because this type of search is not often necessary so it wouldn’t make sense to systematically increase the size of the documents. However, when it’s needed, this type of index is very easy to build.

Tips

6 practical examples on how to use macros

Automatically translated from English

4D 18 R5 introduced form macros. They can be incredibly useful, for example, by providing an ideal way to save time on repetitive tasks. In this blog post, we’ll show you some basic examples to learn more about how macros work and the possibilities they offer. All of the following examples are available on GitHub.

Tips

Tableau and 4D: Deploy your WDC to Github Pages

Automatically translated from English

In the  How to connect Tableau with 4D blog post, you learned how to create a web data connector (WDC) to request data from 4D and visualize it in Tableau Public.

Now it’s time to host our WDC! Since it only uses HTML and JavaScript files, Github Pages is the best option to store them. This allows others to test your connector directly in their Tableau software. In this blog post, I’ll show you how to proceed.

Bonus: I’ll also show you how to debug your WDC in Tableau Public using Chrome. Let’s get started!

Tips

How to connect Tableau with 4D

Automatically translated from English

In 4D Webinar – How to Connect Tableau with 4D, William Taylor (Technical Account Manager, 4D US) gave an overview of the Tableau tool and how it could be used to visualize your 4D data. In this blog post, we’ll dig into the technical details to give you a deeper understanding of how it works. This will allow you to build, for example, a visual showing the highest invoice total with nothing more than 4D REST and Tableau!

Tips

A better understanding of 4D REST sessions

Automatically translated from English

In a previous blog post, we showed you how to get started with the 4D REST server. We walked you through different CRUD operations using Postman and pointed you to the full REST documentation. In this blog post, We’ll explain how sessions work in 4D. This understanding will ensure that you’ll be able to build a session-based authentication system using the 4D REST server.

Tips

Web Scraping using object notation

Automatically translated from English

Want to retrieve data that isn’t available via REST or Web Services? What if it’s only available on a website? The data is easy enough for a human to read, but reading HTML data with a programming language isn’t so simple. Some developers try to use Position and Substring, others try Regex, but it’s unpleasant and time-consuming. A very different approach is to convert the HTML into an object and get the data via object notation. Table rows are handled as collections and are easy to loop through!

This blog post describes how to use this approach and provides some handy tips.