Have created comma separated tags about a person in a Clay field and want to insert that back into the Airtable tags field which is a multi-select, but getting an error. Any suggestions?
To properly handle comma-separated tags when sending them to an Airtable multi-select field, follow these steps: 1. First, use the "Extract Data From Values" feature to process your comma-separated data:
• Apply the regex pattern: [^,"]+"?[^,"]+
• This will split your comma-separated values into a proper list
2. Then use either the "Update Record" or "Upsert Record" action (depending on whether you're updating an existing record or creating/updating) to send the processed data to AirtableThe key is to ensure your data is properly formatted as a list before sending it to Airtable's multi-select field, rather than sending it as a raw comma-separated string.
Sources:Airtable integration overview | Documentation | Clay UniversityWrite to table integration overview | Documentation | Clay University