# Best formula field AI prompt

Solved
365 3
cancel
Showing results for
Did you mean:
7 - App Architect

List all fields in this table that are empty or contain errors.

1 Solution

Accepted Solutions
7 - App Architect

Precisely.

Making such a formula by hand, iterating through all feilds the table, would take more time than its worth.

Using AI, it took 30 seconds to write the prompt & less than 30 seconds to generate the formula.

3 Replies 3
8 - Airtable Astronomer

To create a formula field in Airtable that lists all fields in a table that are empty or contain errors, you can use a combination of conditional statements (IF, ISBLANK, ISERROR, etc.). However, Airtable does not directly support listing all empty/error fields in a single formula field. You would need to check each field individually within the formula.

This formula checks three fields (Field1, Field2, Field3). If a field is empty or contains an error, it lists that field in the output. The & operator is used to concatenate the results, and " | " is used as a separator between messages for each field.

If no fields are empty or contain errors, the formula returns a blank string. You can expand this by adding more fields as needed.

8 - Airtable Astronomer

Example formula:

IF(
OR(ISBLANK({Field1}), ISERROR({Field1})),
"Field1 is empty or has an error",
""
) &
IF(
OR(ISBLANK({Field2}), ISERROR({Field2})),
" | Field2 is empty or has an error",
""
) &
IF(
OR(ISBLANK({Field3}), ISERROR({Field3})),
" | Field3 is empty or has an error",
""
)

7 - App Architect

Precisely.

Making such a formula by hand, iterating through all feilds the table, would take more time than its worth.

Using AI, it took 30 seconds to write the prompt & less than 30 seconds to generate the formula.