Blog – Wiki

Looking for coding examples, ideas, ‘how do I’ or introduction to commands? Hundreds of blob posts are published, this list of contents will help you to find information.

Index of chapters:

4D View Pro 4D Write Pro 4D for Mobile EMail Development Mode 4D Language ORDA User Interface / GUI Qodly Studio Server Maintenance Deployment Tutorials Generic Summit/Videos

4D VIEW Pro

Data context

Populate your sheets with a data context

Create a Pivot Table From a Data Table

Data table

Create a Pivot Table From a Data Table

Customize the Style of Your Tables

Commands to Manage Rows & Columns

Display Your Collections as Tables

print

Print Interface

Manually Adjust the Print Area Using Page Breaks

Manage Printing and Pdf Export

workbook

Workbook Options

More Workbook Options

Sheet Management

Enable, Disable, or Force Calculations

Freeze Panes to Lock Rows or Columns

Manage Rows and Columns

Customize the Style

Powerful & Feature-Rich Ribbon

document creation

Speed Up Your Development Process With Templates

Populate your sheets with a data context

Use Collections to Write and Read

Get and Set Cell Content

SJS Import/Export (Large and complex documents

Import/Export documents in Blob

CSV Import/Export

Excel/XLSX Import/Export

4D View document convert to 4D View Pro

End of Document Loading

Offscreen Areas

Programming

Find and Replace With Code

Speed Up Your Development Process With Templates

End of Document Loading

Use 4D Formulas in Your Spreadsheet

Get Control Over Your 4D Method Settings

Use Methods and Database Fields

Merge and Unmerge Cells

Offscreen Areas

Create a 4D View Pro Document Offscreen

Enable, Disable, or Force Calculations

Freeze Panes to Lock Rows or Columns

Manage Rows and Columns

Customize the Style

Use Collections to Write and Read

Manage Selections and the Active Cell

Name Your Ranges and Formulas

Get and Set Cell Content

4D WRITE Pro

TABLES

Wizard to Create Tables with Data

Carry Over Rows

Dynamically Fill Tables With Entity Selections & Collections

Automatic Page Breaks

Standard Actions for Tables, Rows and Cells

Manipulating Tables

Insertion and Deletion of Rows and Columns

Easily Resize Columns

Elements

Floating Text Boxes

User-friendly Display of Formulas

Where are my Formulas?

Assign Names to Formulas?

Disable Visibility of Empty Images

Linked Paragraphs

Image Settings Dialog

Image Formating

Tab Alignment (comma, point, right)

documents

Export PDF/A with Enclosures

Electronic Invoice Generation

Import docx (Microsoft Word)

Export docx (Microsoft Word)

Export HTML (Web)

Export MIME (eMail)

Continuous Section Breaks

Page Break Inside and Widows/Orphans

Autofit Parameter

Substitute Missing Fonts

Links in 4D Write Pro Documents

Programming

Document Modification Detection

Easily Locate All The Breaks

Control when using Formulas

Deleting Pictures

Save the View Settings

Set the View Settings

Leading Characters for Tabs

Tab Alignment (comma, point, right)

Links in 4D Write Pro Documents

Getting Coordinates

How to Create an Offscreen Area?

Define Page Layout

Create Headers and Footers

Manage Headers and Footers

Manage Sections

Create Multi Columns

Interface

new with 19 R5: Widow/orphan control, page break, keep with next, line height, breaks, author

new with 18 R6: +- text size, copy&paste ruler, change background color, style of a word

Select which Interface to Display

Import & Export

Manipulating Tables

Create Your Own Contextual Menu

Formulas

User-friendly Display of Formulas

Where are my Formulas?

Control when using Formulas

Formulas and Virtual Structures

Images

Deleting Pictures

Image Settings Dialog

Image Formatting

Disable Visibility of Empty Images

Anchored Images

Images in Absolute Position

Full Size Background Images

Image attributes

Tips

Use 4D Write Pro to Create & Print a Batch of Documents

ORDA and 4D Write Pro: The Power Couple!

Full Text Indexation

Webinar: Create a Lightweight Email Composer

Easily Send a 4D Write Pro Document containing images as Email

Use 4D Write Pro Documents as Input Forms

Tips for ranges and targets programming

Migrate 4D Write (old) Documents Stored in Picture Fields

Get the Position of Any Part of a 4D Write Pro Document

Four Different Ways to Use Objects With 4D Write Pro

4D for mobile

generic

Generate Android and iOS Apps From a Single Project

Open Source Library

Share Sessions with 4D and Display Web Pages

Questions about Licenses

Go Fully Offline

Push Notification With Data Syncronisation

Ready-To-Use Templates

User Interface

Choose an Input Control

Custom Input Controls

Sections (4D for Android)

Material Design 3 (4D for Android)

Display Web Pages in Your Mobile Apps

Interact With Other Apps (Android)

Interact With Other Apps (iOS)

Many To Many Relations

Use Signature and Read Barcodes from Your App

Turn Your iPhone Into a Barcode Scanner

Upload Pictures From Your Camera

Improve UX With Deep Linking

Data Formatters

Custom Data Formatter

Multi Criteria Queries

back end

Get Mobile User’s Cookies

Embedd Data in the App

Using ORDA Aliases

Using ORDA Computed Attributes

Using Object Attributes

Sort Criteria and Action Parameters

Push Notifications

Email Authentication

Actions – Add, Edit or Delete Data

Actions – On Mobile App Action Method

Restricted Queries

An Easy-To-Use Component for Mobile User Management

Manage Mobile User Sessions

tutorial

Create your Native Mobile Application

Your First Application

Include Relations

Sort Your List View

Using Formatters

Define Filter Queries

Share Sessions with 4D and Display Web Pages

Debug Your Mobile App on Android Devices

Build Mobile Apps in Less Than 2 Minutes

How To Create Form Templates

How To Test iOS Apps Using Testflight

Banking App Tutorial

Email

SMTP

Connect Using an OAUTH2 Token

Send a 4D Write Pro Document Containing Images as Body of an Email

Legacy Charset Support (ISO-8859-1 or ISO-2022-JP)

Customize Email Headers

POP3

Download Only Mail Header

Download EMail in MIME Format

IMAP

Mailbox ID and Mailbox Keywords

Create, Delete and Rename Mailboxes

Save Emails in a Specific Mailbox

Copy, Move And Delete Emails

Microsoft 365

Create, Delete and Rename Mail Folders

Copy, Move, Replay and Delete Emails

Update Mail Properties

Get User Informations from Azure

OAUTH2 authentication from Azure

Gmail – Google mail api

Get Labels and Emails

Assign Labels and Get Multiple Emails

Create, Delete and Update Labels

Development mode

Developing Concurrently on 4D Server in Project Mode

Server Code Development in Project Applications

Navigation between Development Windows

More Enhancements to the 4D Debugger

Customize Your Debugger Shortcuts

Remote Debugger: Debug Server Code on the Client

Enable Debugger for PROCESS 4D TAGS in Compiled Mode

Build Your Own Documentation For Classes, Methods and Forms

Build Your Own Documentation For Components

Using 4D Libraries and build your own

Project Mode: File/Folder Architecture

Code Live Checker

Handling Errors: Try and Throw

GIT and Version control

Basics to use Git

4D and Git: From Beginner to Expert

An Introduction Guide to 4D and Version Control Systems

How to Take Advantage of Github Actions With 4D

.gitignore (Default Settings)

4D Widgets Source on Github: Report, Label, WritePro, Progress, SVG, Widgets

Git. Commit. Pull. Push & More

Data structure

NULL Value Not Automatically Mapped to Blank Value Anymore

Track Data Changes in Data File (Global Stamp)

Structure Definition Export In HTML

Compatibility settings

BOM/EOL for XML and Text Files

Invisible Characters – EOL and BOM

XML: Enhanced XPATH Support

Compatibility Settings- Part 1

Compatibility Settings- Part 2 – use Period And Comma As Placeholders

Compatibility Settings- Part 3 – Nested Transactions

Compatibility Settings- Part 4

Deprecation of PHP Commands, Removal on Build-in PHP Interpreter

Non Blocking Printing

4D Language

Classes

Declaring Class Properties

Computed Class Properties

Manage Class Inheritance

An Intro to Object-Oriented Programming with Classes

Access Component Classes from Host (even in Binary Mode)

How to Create a Simple Timestamp Class in 4D

internal classes

HTTP Client – Asynchronous HTTP Requests

HTTP Client – more options

WebSocket Client

WebSocket Client: Custom Headers

WebSocket Server

Zip/Unzip Files and Folders

Files and Folders – Power of Objects

Object Notation to Handle Files and Folders

Zip: LZMA Compression

System Workers – Launch external processes asynchronously

System Workers vs LAUNCH EXTERNAL PROCESS

Cryptokey – Encrypt, Decrypt, Sign and Verify

objects and Collections

Comparison With an Undefined Value

Handling Undefined

More Collection Functions

Sync Several Collections

Comparison With an Undefined Value

The Use of Formulas in Collection & Callback Commands

Object Sharing,Copy and using as Hash Map

Formula – Think Outside the Box

Formula – Write Your Own Methods For Objects

Read Object Fields with SQL

Time in Objects

Date in Objects

Pictures in Objects

Blobs in Objects

Different Ways to Find Items in a Collection

Query Collection

Calculations in Collections

Combine and Sort Collections

A Wide Range of Possibilities to Manage Collections

Working with JSON Pointers

commands

Catch Errors Everywhere

THROW – Enhanced Error management

Form and Subform Communication Made Easy

OBJECT SET ENTERABLE

Copy Parameters

OBJECT Get Value and OBJECT SET VALUE

Encrypt Your Own Data With the 4D Algorithm

Use an Offscreen Web Area

XML: Enhanced XPATH Support

LISTBOX SELECT ROWS

SET USER ALIAS in Journal

SCREEN COORDINATES

Form Event attributes

Form Events and Meta Info for List Boxes

Form Events for 4D View Pro

Get call chain – Error Handling – Retrieve the Current Execution Call Chain

Formula – Usage Examples

Formula from String

New Signal – Synchronize Your Processes

CALL WORKER – CALL FORM – Exchange Messages

Server Administration Commands

Get Application Info

Get System Info – Retrieve Hardware Informations

WEB Get server info

Get License info

Get License Usage

Get Process Activity

Generate password hash – Hash and Verify your own passwords

FORM GET/SET ENTRY ORDER

GET PICTURE FORMATS

Save and Restore Print Settings

Suspend and Resume Transactions

Detail Control for GRAPH

Preemptive Processes

Coexistence of Thread-Safe and Non-Thread-Safe Commands

New Signal – Synchronize Your Processes

Preemptive on the Client/4D Remote

Make Your Solution Scaleable With Preemptive Multi-Threading

Preemptive Web Services Server and Client

Share Information in Preemptive Processes

In Depth Session: Workers and UI in Preemptive Mode

In Depth Session: Difference between Preemptive and Cooperative Processes

CALL WORKER – CALL FORM – Exchange Messages

syntax

Object and Collection Literal Initializer

Larger Integers than Integer32

Accessing/Initializing not Passed Parameters

Return, Continue, Break, Short-Circuit Evaluation, Compound Assignment, Ternary Operator

String Comparison Improvements

Declaration Syntax for an Intuitive Autocompletion

Variable Declaration and Assignments

Variant – Storing different Types

Name Your Parameter

Variadic Functions (unspecified number of parameters)

Method Parameter Declarations

Customize Date and Time format

CODE Editor

Find and Replace

Visualise Your Classes Component in Explorer

Customize the Code Editor

Using Tags – MARK/TODO/FIXME

Quickly Jump To Different Functions Of a Class

Show Online Documentation Directly From the Code Editor

Prototype of Functions and Short Description

Multiple Themes

visual Code Editor – 4D Analyzer extension

Discover CS Code Extension

Setting up Code Syntax Highlighting

Syntax Checking, Code Folding, Indention, tool4d

Format your Code

Code Completion

Show 4D Documentation

Go To Definition and Signature Help

Saving Project Source Code without Tokens

ORDA

language

Distinct Function

Compare Two Entity Selections

Computed Attributes

Easy Looping With New 4D Tag

Extract Function

Queries with Formulas

Queries with Placeholders for Values or Attributes

Queries with an Object Oriented Approach

ORDA Member Methods to Get Structure Informations

Control Data Encryption

Logical Operations on Entity Selections

ORDA – convert to objects/collections

4D keeps your selections of records consistent regarding deletion of records

Generic

Logging ORDA calls on the Server

REST/Web Filter Access/Permissions

Optimize Performance with Full Control Over REST/ORDA Requests

Optimize Your ORDA Code with Requests Logging

Share an Entity Selection Between Processes

Share Entity Selections to Increase Performance

Move To Shareable Entity Selections Smoothly

Welcome to the World of ORDA Classes

ORDA Classes to Handle Your Data Model

ORDA Data Model Classes and REST

A Better Understanding of 4D REST Sessions

Better List Box Row Selecting

Remote Datastores – Access Multiple 4D Data Sources

Use ORDA to Boost Performance in Client/Server

Working with ORDA Optimistic Locking

ORDA Optimistic-Pessimistic Locking

Convert Classic <-> ORDA Selections

tutorial

ORDA – From Beginner to Expert

ORDA/REST Request Optimization Step by Step

Welcome to the World of ORDA Classes

TIPS: Data Model Classes

Remote Datastores – A Practical Use Case

ORDA Cheat Sheet

ORDA Genealogy – Part 1

ORDA Genealogy – Part 2

ORDA Genealogy – Part 3

ORDA Genealogy – Part 4

user interface / gui

form elements

Radio buttons/checkbox states for icons – positioning of text and icon

Rounded Corners

Form and Subform Communication Made Easy

New Windows System Rendering Engine for Web Areas

WebCam Support in Web Areas

Using CSS to Control Dark/Light UI

Using Collections and Lists Within Form Objects

Access Form Object Values by Programming

Define the Font Size for Automatic Font

Form Wizard: Build Entity Selection List Box

Dynamic Forms, JSON and JSON Pointers

List box

Automatic Row Heights in Collection Based List Boxes

Drag&Drop without Alt-Key

Horizontal and Vertical Padding

Time Columns and Footer Calculation

Manage Clicks in Edited Cells

Type Ahead Made Easy

Setup Movable Rows by Code

Select List Box Row with ORDA

Display a Collection in a List Box

Special Form Events and Meta Info for List Boxes

Display Multilevel Collection in Different List Boxes Without Code

Help Tips on a List Box

Customize Highlight Color in a List Box

Column Auto Resizing

Live List Box Column Resizing

Add an Icon to List Box Header

printing

Use Form Object with Print Form and FORM LOAD

PDF Format for Print Preview on Windows

menu

Create Your Own Help Menu

generic

Test Your Windows SDI Application

High DPI On Windows – High Resolution Screens#

Text Rendering in Forms on Windows with DirectWrite

Automate Repetitive Tasks And More With Form Macros

6 Practical Examples On How To Use Form Macros

Open a Form per Programming with FORM EDIT

Form Event attributes

Use an Offscreen Web Area

Style Sheets – CSS – Beautify your Forms

4D Widgets Source on Github: Report, Label, WritePro, Progress, SVG, Widgets

Views in the Form Editor

Project Databases: New Possibilities With The Form Editor

Easiliy Customize the Entry Order of Your Dynamic Forms

Use DIALOG instead of MODIFY SELECTION

Control your Help Tips

Define Tab Order by Programming

Use Standard Actions

On Mouse Up Event for Picture Objects

QODLY Studio

Tutorials

Introduction to Qodly Studio

Get Started With Qodly Studio

All about Datatable (& CRUD Operations)

Switch from Datatable to Matrix to add Actions

Get Started With Qodly Studio 3 Demos: Matrix, Navigation and Weather API

server

generic

Integrate Your Own Administration Window for 4D Server

Customize the Administration Dialog With 4D Code

Build a Web Based Administration Dialog

Data Collection Insights

Developing Concurrently on 4D Server in Project Mode

Disabling Data/Runtime Explorer on Merged Server

A Deeper Look Into 4D Data Encryption

Control Data Encryption by Code

Setup Web Admin Access

Monitor 4D Server Activity

Server Administration per Programming

Control the Cache Manager

Client

Share Local Resources Between Users with RDS

Use Duplicated Merged Client Applications

Multiple Servers, One Shared Local Resources

Build Your Own Custom Remote Connection Dialog

Multiple Instances of Merged Server Applications on the Same Machine

Concurrent Merged Clients From the Same Machine

Define Sleep Timeout for Remote 4D

network

WebSocket Client

WebSocket Server

QUIC Layer introduction

Active/Deactive QUIC Layer in Production

Define Sleep Timeout for Remote 4D

Auto-Generated TLS Certificates for Client/Server

QUIC network layer: Automatic update and sleep mode

web server

TLS 1.3 – OpenSSL 3.1

Debug with scalable/preemptive sessions

Scaleable Sessions for Advanced Web Applications

Cookies: Samesite and Secure Attribute

WebSocket Server

REST/Web Filter Access/Permissions

Easy Looping With New 4D Tag and ORDA

Support of Cross-Origin Resource Sharing (CORS)

Multiple Web Servers in a Single 4D Instance

HSTS – HTTP Strict Transport Security

REST server

4D REST API and React

REST/Web Filter Access/Permissions

ORDA Data Model Classes and REST

A Better Understanding of 4D REST Sessions

authentication

Microsoft 365: Get user information from Azure

OAUTH2 authentication from Azure

OAUTH2 with Google or other OAuth2 Servers

Bcrypt Encryption for Passwords

Directory File (User/Passwords) in Merged Server Projects

Dynamically Grant User Permissions

Single Sign On – Active Directory

Maintenance

Logging

Logging ORDA calls on the Server

ORDA – REST Request Optimization Step by Step

Optimize Your ORDA Code with Requests Logging

Data Collection Insights

Evolution of the Diagnostic Log

Evolution of the Log Formats

Pausing Logging and Log Configuration File

Who Did That? Store User Aliases in Journals

Debug Log Analyzer

Debug Log Detailed Settings

data explorer

Data Explorer embedded in 4D

Create, Update and Delete with Data Explorer

Relations in Data Explorer

Disabling Data/Runtime Explorer on Merged Servers

Data Explorer in Action

Data Explorer Introduction

Setup Web Admin Access

monitoring

Integrate Your Own Administration Window for 4D Server

Command Get License Usage

Opening the Runtime Explorer

Monitor 4D Server Activity

Server Administration per Programming

Get Application Info – Get Information About the Running Application

Get System Info – Retrieve Hardware Informations per Programming

backup

Automatic Integration of Multiple Journals

4D Backup, VSS Snapshots and Commands to Lock the Datastore

VSS – Volume Shadow Copy Service / Snapshots

Database Mirroring

Backup Journal Export to JSON

Journal Management

deployment

build

Define Icon – Set License

Tool4D – CLI tool for CI/CD Pipeline or Code Execution in CLI

Build your Compiled Structure or Component With Build4D

Build Standalone Application With Build4D

Create a Client/Server Application with Build4D tool

Reduce Your 4D Application Size

Disabling Data/Runtime Explorer on Merged Servers

How to Notarize for macOS

Evolution of Client/Server Application Building

Simplified Cross-Plattform Client/Server Application Building

Secure Your Applications Resources and Forms

How to Automate the Compilation

Launch A Compilation By Programming

Manage Your Applications’s Information

Silicon Compiler

settings

Headless Applications

CLI – Command Line Interface – Launch Control

Journal Management

Authentication (security)

4D Write Pro: Control when using Formulas

4D View Pro: Get Control Over Your 4D Method Settings

4D for Mobile: Share Sessions with 4D and Display Web Pages

4D for Mobile: Define Filter Queries

Login: Get User Informations from Azure

OAUTH2 authentication from Azure

OAUTH2 with Google or other OAuth2 Servers

REST/Web Filter Access/Permissions

Bcrypt Encryption for Passwords

Directory File (User/Passwords) in Merged Server Projects

Project Database: Managing Users and Groups

Project Database: Users and Groups in Action

Dynamically Grant User Permissions

Single Sign On – Active Directory

security

Auto-Generated TLS Certificates for Client/Server

TLS Support for ECDSA Certificates

TLS 1.3 – OpenSSL 3.1

Encrypt Your Own Data With the 4D Algorithm

Control Data Encryption by Code

Get Started With Encryption

Integrate Your Own Administration Window for 4D Server

Disabling Data/Runtime Explorer on Merged Servers

A Deeper Look Into 4D Data Encryption

4D Backup, VSS Snapshots and Commands to Lock the Datastore

How to Notarize for macOS

4D Tutorials

System Workers vs LAUNCH EXTERNAL PROCESS

File Transfer Class – CURL for FTP, FTPS, SFTP, HTTP

File Transfer Class – Dropbox or GDrive

ORDA – From Beginner to Expert

ORDA Classes to Handle Your Data Model

ORDA – REST Request Optimization Step by Step

An Intro to Object-Oriented Programming with Classes

How to Create a Simple Timestamp Class in 4D

An Introduction Guide to 4D and Version Control Systems

4D REST API and React

Apply Naming Conventions With Form Macros

6 Practical Examples On How To Use Form Macros

Tableau and 4D: Deploy Your WDC to Github Pages

Bootstrap and 4D Transformation Tags

How to Connect Tableau With 4D

Free: 50+ Hours of Training Sessions online: 4D Summit 2020

Remote Datastores – A Practical Use Case

A Better Understanding of 4D REST Sessions

Test the Powerful 4D REST Server With Postman

Web Scraping Using Object Notation

An Enhanced UX With AJUI_PROGRESSBAR

AJUI_TIP: A Tooltip Engine for 4D

Get Started With Encryption

Formula – Usage Examples

What are Transactions and How Do I Use Them?

Qodly Tutorials

generic

4D Versioning – LTS – Feature Releases Explained

A Class for Easy Handling of your Sub-Forms

Deprecated and Removed Features: Why and How?

3 Reasons Why We Release Early and Often

4D Awesome List (GitHub projects)

Extensive Library of 4D Applications

How To Browse GitHub To Find All 4D Projects

A Deeper Look Into 4D Data Encryption

How to Toggle Dark/Light Mode on Mac With One Click for Testing

The Story Behind 4D’s New Markdown-Based Documentation Site

SVG “Non-Scaling-Stroke” Attribute Support

How to Use Google Charts with 4D

Mac: Define Which Language to Use (English, French, German, Spanish, etc)

Deprecation of PHP Commands, Removal on Build-in PHP Interpreter

Track Data Changes in Data File (Global Stamp)

4D Summit sessions and other online videos

Free: 50+ Hours of Training Sessions online: 4D Summit 2020

In Depth Session: Workers and UI in Preemptive Mode

In Depth Session: Difference between Preemptive and Cooperative Processes

In Depth Session: 4D Cache Manager explained

In Depth Session: Objects are not JSON

Appropriately Use the Flexibility of Dynamically Structured Databases