Mar 10, 2017 07:34 AM
I have a base for many social accounts. I created a column in the base for emails. Records will have multiple email addresses (that I want to put inside the field for a record thats being created) for the main email providers - Google, Yahoo, Outlook, Webmail. Is there a way have many fields inside the cell labeled with the email providers (label1: Google label2: Yahoo, etc.) that I can input the email address for the record?
The only way I see how to do this is to use the long text field type and just type everything in it. Please see snaapshot.
Apr 01, 2018 02:12 AM
Did you find a solution for this? I’ve a similar challenge.
Mar 02, 2024 10:35 AM
The cleanest way to do this is to have a separate column for each and if you want to see them concatenated, use a formula field to do so. You can then hide the source columns. From a form input perspective, I would recommend using fillout.com integration. It is truly an astoundingly good tool and works wonders for Airtable's missing features such as signatures and updates. You could have a a checklist of social sites and then selectively show only the questions that correspond to selected sites. Alternatively, you could use a regular expression to constrain entry to a comma separated list of emails. Chat gpt says this will work: /^(\s*[\w.-]+@[a-zA-Z\d.-]+\.[a-zA-Z]{2,}\s*(?:,\s*\s*[\w.-]+@[a-zA-Z\d.-]+\.[a-zA-Z]{2,}\s*)*)$/ I have not tried it.