Best formula field AI prompt

[OfficeOurs]

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

[Saravanan_009]

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.

[Saravanan_009]

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",
   ""
)

[OfficeOurs · Accepted solution]

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.