Integrating weather info into a record automatical...

[Sylvain_Dubois]

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.

[Andrew_Johnson1]

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

[Nicho_Worth]

Where you able to get this to work?

[Valentin_Chreti]

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

• “When a record matches conditions”
• “When Website is not empty and Logo is empty”

Actions

Run a script

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.

[Industry]

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.

[Mario_Granero]

It works for me!! Thanks

[Agathe_Dagorn]

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 ?