Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Best formula field AI prompt

Solved
Jump to Solution
414 0
cancel
Showing results for 
Search instead for 
Did you mean: 
OfficeOurs
7 - App Architect
7 - App Architect

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

1 Solution

Accepted Solutions

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.

See Solution in Thread

3 Replies 3
Saravanan_009
8 - Airtable Astronomer
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.

Saravanan_009
8 - Airtable Astronomer
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",
   ""
)

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.