I’m trying to list the field names for which non-zero values appear in each record. I would have used a combination of Match and Index in excel… What would be the solution in Airtable?
List field names for non-zero values in record
+29Welcome to the Airtable community!
Here is a starting place …
REGEX_REPLACE(
CONCATENATE(
IF( NOT( {Field1}, "Field1, "),
IF( NOT( {Field2}, "Field2, "),
IF( NOT( {Field3}, "Field3, "),
IF( NOT( {Field4}, "Field4, ")
),
", $",
""
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.