Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 10, 2018 05:37 PM
Let’s say i have a field named “company name” and a field named “logo”.
I want to create a field that automatically display the corporate logo of the company.
i don’t want to do this manually having to search for the URL of each corporate logo.
example: if i put “airtable” in a new entry, this will automatically display the corporate logo of airtable in the “logo” field
possible hints: http://logo.clearbit.com? zapier?
need something simple & elegant if possible :winking_face:
Thanks.
Sep 10, 2018 09:32 PM
You could use Airtable’s new SWITCH function.
You would need to create a new field called “Logo URL” and make it a formula field.
The formula would be something like.
SWITCH({company name},“Company A”,“URL Of Company A’s Logo”,“Company B”,"URL Of Company B’s Logo ",“No Match”)
After that create a simple Zap to fetch the URL from the “Logo URL” field and populate the corresponding “Logo” field with the correct company logo image
Jun 20, 2020 10:18 PM
Where you able to get this to work?
Sep 30, 2020 11:14 AM
This post is a bit dated, but since the automations have been released, it’s now possible to fetch logos automatically (via the Clearbit API for example).
In my specific case, I wanted Airtable to add a company’s logo as soon as I added their website in a URL type field.
So here’s how I did it:
Trigger
Actions
let table = base.getTable('TableName');
let query = await table.selectRecordsAsync();
for (let record of query.records) {
// if the attachment field is empty
if(record.getCellValue('Logo') == null && record.getCellValue('Website') != null) {
let recordId = await table.updateRecordAsync(record, {
'Logo': [
{ url: 'https://logo.clearbit.com/'+record.getCellValue('Website')}
]
})
}
}
And that’s it, as soon as you add a URL, Airtable will automatically download the company logo.
Oct 09, 2020 08:51 AM
Hello !
Thanks a lot for your script. However, it doesn’t seem to filter the files Clearbit can’t found. It looks like it just adds the URL instead.
Would you know a way to fix that, and add the logo only if it is a png/jpg file ?
Anyway, thank you for your work, and for sharing ! It really helps.
Jul 23, 2021 08:25 AM
It works for me!! Thanks
Mar 07, 2022 09:14 AM
Hi !
Had the same issue.
When the logo is not recognized, the automation keeps running and running et runs out all the automations :frowning:
why could be the solution ?