Bika
Template
Help
Pricing
Contact Sales
Login
Getting Started
Guide
Basic
Resource Permissions Management
Automation Guide
X(Twitter) - Create Tweet
Slack - Send Message to Channel
Telegram - Send Message
WeCom - Send Messages to Group
DingTalk - Send Message to Group
Feishu - Send Message to Group
Run Script
Integration Guide
Using Integrations in Automation
X(Twitter) Integration
Telegram Bot Integration
Open API
Quick Start
Template Guide
Template Quality Verification
Cookbook
Airtable vs. Bika.ai: The Ultimate Automation Database Showdown
Reference
Automation Triggers
HTTP If Change
Scheduler
Webhook Received
Record Created
Record Match
Manually Run
Datetime Field Reminder
Form Submitted
Inbound Email
Member Joined
Button Field Click
Automation Actions
Find Members
Find Records
Create Record
Update Record
Find Dashboard
Find Widget
Find Missions
Create Mission
Run Script
FormApp.ai
Send HTTP Request
Send Message to WeCom Group
Send Message to Feishu Group
Send Message to DingTalk Group
Send Message to Slack Channel
Send Message to Telegram
AI Text Summary
X(Twitter) - Create Tweet
X(Twitter) - Upload Media
Condition
Delay
Loop
Random
Round Robin
Filter
Send Report
Send Email
OpenAI - Generate Text
Create Document
Create Node Resource
Replace File
Integrations
IMAP Email Account
Airtable
APITable
AITable.ai
Zoom
SMTP Email Account
X(Twitter) OAuth2.0
X(Twitter) OAuth1.0a
WeCom Group Bot
DingTalk Custom Bot
Telegram Bot
Feishu Custom Bot
Slack App
Webhook
MySQL
PostgreSQL
Vika
Siri
WeChat Login
Google
GitHub
LinkedIn
AWS Textract
OpenAI
Make.com
Zapier
AliCloud Tongyi Qianwen (Qwen)
Claude.ai
Google AI
Tencent Hunyuan
ByteDance Doubao
Node Resources
Folder
Database
Canvas
Document
File
Automation
Dashboard
Report Template
Web Page
Code Page
Form
AI
Mirror
Database Views
Grid
Gallery
Kanban
Gantt
Form
Database Fields
Single Line Text
Multi-line Text
Checkbox
Currency
Date Time
Date Range
Number
Percentage
Phone
Email
Rating
Single Select
Multi Select
URL
Member
Created By
Modified By
Created Time
Modified Time
Link
Attachment
Formula
Auto Number
Lookup
Video
Voice
Photo
API
AI Text
AI Voice
AI Photo
AI Video
Video Editing
JSON
Cascader
One Way Link
Document
Button
Dashboard Widgets
Chart
List
Highlight Number
Text Block
Pivot Table
Icons
Embed Webpage
Progress Bar
Missions
Quest
Sequence
Approval
Submit Form
Submit Multiple Form
Enter View
Review Record
Create Record
Create Multiple Records
Create Task
Update Record
AI Create Records
Comment Record
Install Template
Zoom Meet
Google Meet
Voov Meet
Invite Member
Set Space Name
Read Markdown
Read Template Readme
Redirect Space Node
UI Launcher
Reminder
Ai Wizard
AI Apps Builder
Chat
AI Search
Create Record
Create Reminder
Create Node Resource
Formula
Sum
Average
Max
Min
Round
Round Up
Round Down
Ceiling
Floor
Even
Odd
Int
Abs
Sqrt
Mod
Power
Exp
Log
Value
Concatenate
Find
Search
Mid
Replace
Substitute
Len
Left
Right
Lower
Upper
Rept
T
Trim
Encode URL Component
If
Switch
True
False
And
Or
Xor
Blank
Error
Is Error
Not
Today
Now
To Now
From Now
Date Add
Datetime Diff
Workday
Workday Diff
Is After
Is Before
Is Same
Datetime Format
Datetime Parse
Datestr
Timestr
Year
Month
Weekday
Weeknum
Day
Hour
Minute
Second
Set Locale
Set Timezone
Created Time
Last Modified Time
Array Compact
Array Unique
Array Join
Array Flatten
Count
CountA
CountIf
CountAll
Record ID
Space
Space Station Sidebar
Workflow
Import Data
Request Record
Rich Document
Create Mission
Send Report
Report detail
Record Detail
AI Wizard
AI Launcher
Roles
Members
Setting Info
Notification
Permission Management
Release Notes
v0.9.7
v0.9.6
v0.9.5
v0.9.4
v0.9.3
v0.9.2
v0.9.1
v0.9.0
v0.8.23
v0.8.22
v0.8.21
v0.8.20
v0.8.19
v0.8.18
v0.8.17
v0.8.15
v0.8.13
v0.8.12
v0.8.11
Videos
Video: What is Bika.ai？ - Proactive AI Automation Database Starter Guide
Video: What is Bika.ai？ - Proactive AI Automation Database Starter Guide
Video: What is Bika.ai？ - Proactive AI Automation Database Starter Guide
bika cta

Recommend Reading

  • Rotating Duty Reminder(Wecom): Airtable Alternative to Project duty plan
  • Airtable Alternative for influencer: AI Create X Tweets Automatically
  • Vika OKR: Airtable Alternative to improve team consistency
  • Bika.ai vs Airtable: To Improve data accuracy
  • Airtable Pricing vs. Bika.ai Pricing: Which is More Advantageous for Administrative Assistant?
Bika.ai LogoBika.ai - Billion-row Airtable meets GenAI Zapier automation | Product Hunt
Product
Login & Register
Template Center
Integration
API Documentation
Support
Help Center
Tutorial
Roadmap
Brand Assets
Privacy Policy
Terms of Service
Contacts
Contact Customer Service
Contact Sales
support@bika.ai
Language
English
简体中文
繁體中文
日本語
AItool-PRO
© 2024 Copyright Bika.ai
twitterlinkedin
Removes empty strings and null values from an array. 【item】Represents array values, such as cell values of multi-select, attachment, magic link, and magic reference field types. This function will retain "false" values and strings with blank characters.

Array Compact

Removes empty strings and null values from an array. 【item】Represents array values, such as cell values of multi-select, attachment, magic link, and magic reference field types. This function will retain "false" values and strings with blank characters.

Input formula

Select a field or function

Number

/assets/icons/formula/number.svg

Sum

/assets/icons/formula/number.svg

Average

/assets/icons/formula/number.svg

Max

/assets/icons/formula/number.svg

Min

/assets/icons/formula/number.svg

Round

/assets/icons/formula/number.svg

Round Up

/assets/icons/formula/number.svg

Round Down

/assets/icons/formula/number.svg

Ceiling

/assets/icons/formula/number.svg

Floor

/assets/icons/formula/number.svg

Even

/assets/icons/formula/number.svg

Odd

/assets/icons/formula/number.svg

Int

/assets/icons/formula/number.svg

Abs

/assets/icons/formula/number.svg

Sqrt

/assets/icons/formula/number.svg

Mod

/assets/icons/formula/number.svg

Power

/assets/icons/formula/number.svg

Exp

/assets/icons/formula/number.svg

Log

/assets/icons/formula/number.svg

Value

Text

/assets/icons/formula/text.svg

Concatenate

/assets/icons/formula/text.svg

Find

/assets/icons/formula/text.svg

Search

/assets/icons/formula/text.svg

Mid

/assets/icons/formula/text.svg

Replace

/assets/icons/formula/text.svg

Substitute

/assets/icons/formula/text.svg

Len

/assets/icons/formula/text.svg

Left

/assets/icons/formula/text.svg

Right

/assets/icons/formula/text.svg

Lower

/assets/icons/formula/text.svg

Upper

/assets/icons/formula/text.svg

Rept

/assets/icons/formula/text.svg

T

/assets/icons/formula/text.svg

Trim

/assets/icons/formula/text.svg

Encode URL Component

Logic

/assets/icons/formula/logic.svg

If

/assets/icons/formula/logic.svg

Switch

/assets/icons/formula/logic.svg

True

/assets/icons/formula/logic.svg

False

/assets/icons/formula/logic.svg

And

/assets/icons/formula/boolean.svg

Or

/assets/icons/formula/boolean.svg

Xor

/assets/icons/formula/boolean.svg

Blank

/assets/icons/formula/boolean.svg

Error

/assets/icons/formula/boolean.svg

Is Error

/assets/icons/formula/boolean.svg

Not

Date

/assets/icons/formula/date.svg

Today

/assets/icons/formula/date.svg

Now

/assets/icons/formula/date.svg

To Now

/assets/icons/formula/date.svg

From Now

/assets/icons/formula/date.svg

Date Add

/assets/icons/formula/date.svg

Datetime Diff

/assets/icons/formula/date.svg

Workday

/assets/icons/formula/number.svg

Workday Diff

/assets/icons/formula/boolean.svg

Is After

/assets/icons/formula/boolean.svg

Is Before

/assets/icons/formula/boolean.svg

Is Same

/assets/icons/formula/text.svg

Datetime Format

/assets/icons/formula/date.svg

Datetime Parse

/assets/icons/formula/text.svg

Datestr

/assets/icons/formula/text.svg

Timestr

/assets/icons/formula/number.svg

Year

/assets/icons/formula/number.svg

Month

/assets/icons/formula/number.svg

Weekday

/assets/icons/formula/number.svg

Weeknum

/assets/icons/formula/number.svg

Day

/assets/icons/formula/number.svg

Hour

/assets/icons/formula/number.svg

Minute

/assets/icons/formula/number.svg

Second

/assets/icons/formula/date.svg

Set Locale

/assets/icons/formula/date.svg

Set Timezone

/assets/icons/formula/date.svg

Created Time

/assets/icons/formula/date.svg

Last Modified Time

Array

/assets/icons/formula/array.svg

Array Compact

/assets/icons/formula/array.svg

Array Unique

/assets/icons/formula/array.svg

Array Join

/assets/icons/formula/array.svg

Array Flatten

/assets/icons/formula/array.svg

Count

/assets/icons/formula/array.svg

CountA

/assets/icons/formula/array.svg

CountIf

/assets/icons/formula/array.svg

CountAll

Object

/assets/icons/formula/array.svg

Record ID

ARRAY COMPACT

Removes empty strings and null values from an array. 【item】Represents array values, such as cell values of multi-select, attachment, magic link, and magic reference field types. This function will retain "false" values and strings with blank characters.

Usage

ARRAYCOMPACT(array)

Example

ARRAYCOMPACT([1,2,"",3,false," ", null]) => [1,2,3,false," "]