I have a condition that Inputs Boolean and outputs Boolean, and i wish to make it appear (format it) as a checkbox and not as a string “true” or “false”
Even though this solves the issue, I also second the request for checkmarks as a formula format. Why, because emojis look different o every device, aren’t center aligned, and are harder to use as filters.
This creates a big functionality hole in the product: there is, at the moment, no way of using a formula output a bool value to be used in blocks. Or am I missing something here?
You most certainly can use formulas for boolean values. I see this request as a purely visual preference one (matching the appearance of the Checkbox-type field over relying on emojis).
I’m upvoting this too. Critically for us, it also integrates better with third party systems eg Stacker that rely on the boolean format - try using emojis and they treat the field as a string. And looks aren’t trivial - formatting a boolean formula as a checkbox makes it look better, which improves the client experience, adds value to the service, and creates a good impression!
This is a bit of an oldie now and still a good product suggestion. A better workaround than emojis (which was all we had back then) is to use the scripting block to update the second boolean field based on the true/false value of the first boolean field. Something like this would do the trick:
let table = base.getTable('Bool');
let query = await table.selectRecordsAsync();
for (let record of query.records) {
table.updateRecordAsync(record, {
'Scripted Checkbox': record.getCellValue('Checkbox')
})
}
Like others, I would appreciate the addition of this feature. Using an emoji in a Formula makes the data less semantic for use elsewhere, and having to write a bespoke script or automation is tedious. It seems much more intuitive to edit the formatting of a Formula or Rollup.
Surfacing some other posts that requested this functionality for the Airtable product team (over 13k views in aggregate, including this post):
I would also like to echo this feature. This example has only a boolean as outcome, it would be great if we can format the outcome as such:
IF(Field=0, TRUE(), FALSE())
The interface to configure the outcome already exists for other formattable formulas. Here’s the current formatting options for a numeric outcome from a formula field:
I suggest a similar setting for a boolean outcome:
