Skip to main content

Automatic integration of company logo

  • September 11, 2018
  • 6 replies
  • 98 views
S

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.

    6 replies

    A
    Forum|alt.badge.img+3
    • Andrew_Johnson1
    • Participating Frequently
    • 586 replies
    • September 11, 2018

    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

    N
    Forum|alt.badge.img+1
    • Nicho_Worth
    • Participating Frequently
    • 8 replies
    • June 21, 2020

    Where you able to get this to work?

    V
    • Valentin_Chreti
    • New Participant
    • 1 reply
    • September 30, 2020

    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.

    I
    • Industry
    • New Participant
    • 1 reply
    • October 9, 2020

    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.


    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
    Forum|alt.badge.img+5
    • Mario_Granero
    • Participating Frequently
    • 7 replies
    • July 23, 2021

    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.


    It works for me!! Thanks

    A
    • Agathe_Dagorn
    • New Participant
    • 3 replies
    • March 7, 2022

    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.


    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 ?


    Terms & ConditionsAccessibility statement