Skip to main content

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?

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


  ),


  ", $",


  ""


)

Reply


Terms & Conditions