Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 19.3 ('Black Hole')
Instant purchase and download via GumRoad!

FEATURE

Filemaker-Like Checkboxes

Using a checkbox set to simulate the Filemaker checkbox

Issue: 19.3 (May/June 2021)
Author: Vince Du Beau
Author Bio: Vince is an experienced Filemaker developer. He is exploring Xojo as an alternative development environment to better serve his clients.
Article Description: No description available.
Article Length (in bytes): 6,103
Starting Page Number: 47
Article Number: 19305
Resource File(s):

Download Icon project19305.zip Updated: 2021-05-02 22:26:27

Related Link(s): None

Excerpt of article text...

A little history. I first discovered REALbasic in 2003, a little after I switched from Linux to OS X. I wrote a few programs for myself and others, but was generally too busy with my regular consulting to write anything major. For the past fifteen years or so my main development platform has been Filemaker. It is great for database development, but there are always additional things one could wish for (just as there are for Xojo and other development platforms).

In recent years, the cost of licensing Filemaker server and connections has increased greatly. This makes it difficult for small businesses or individuals looking for a database solution to justify the cost. I, like some other Filemaker developers, am looking at Xojo as a way of servicing these clients.

One of the features of Filemaker is the ability to tie checkboxes to a database field. You do this by creating what is called a "Valuelist" which can be a series of terms separated by a carriage return or is actually tied to a field in another table and then tying this Valuelist to the field (see Figure 1). The items that are checked off are then stored in the field separated by carriage returns. This is an ability I greatly wanted to be able to have in Xojo. This project is my take on it.

Creating a ValueList

First we need to create a control array on the window where you want the checkboxes to appear (see Figure 2). There's information on how to do this on the Xojo forum (https://forum.xojo.com/t/making-a-control-array/8546).

Make sure that you turn on the transparent property of the checkbox so that it doesn't show on the main window. I decided to place mine just above the actual window.

...End of Excerpt. Please purchase the magazine to read the full article.