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 University
Write to table integration overview | Documentation | Clay University
Hi Stephen J.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: