Skip to main content

Convert a formula/link in image

  • May 17, 2023
  • 6 replies
  • 24 views
G
Forum|alt.badge.img+2

Hi, need some help! I make a chart on https://quickchart.io/chart-maker/ than i build a formula in airtable to pass the the variables 

[SUBSTITUTE("https://quickchart.io/chart/render/zm-2146d069-a493-4d97-90ad-3a4bc6766b7d?labels=" & ARRAYJOIN({items from graph 2 all},",") & "&data1=" & ARRAYJOIN({Rampa interna primaria},",")& "&data2=" & ARRAYJOIN({Rampa esterna primaria},",") & "&data3=" & ARRAYJOIN({Rampa interna non primaria},",") & "&data4=" & ARRAYJOIN({Rampa esterna non primaria},",")," ","%20")], the formula generates a link to the dynamic graph [https://quickchart.io/chart/render/zm-2146d069-a493-4d97-90ad-3a4bc6766b7d?labels=Tecnico%20Funzionale,Manageriale,Imprenditorialità,Creatività,Autonomia,Stabilità,Sicurezza%20geografica,Stile%20di%20vita,Servizio,Pura%20sfida&data1=0,0,0,4.5,4.5,0,0,0,0,0&data2=0,0,0,4,4,0,0,0,0,0&data3=3.5,3.25,2,0,0,4,3.75,3.5,4,3.25&data4=5,4,4,0,0,4,4,2,3,4] . How can i convert this formul field in a image field on airtable? Thanks

 

    6 replies

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 9808 replies
    • May 17, 2023

    You have to use Airtable’s API for that, which means that you would either need to use scripting or a low-code API tool like DataFetcher or Make. I use Make for so many different things, that that’s what I typically use. But DataFetcher is awesome, too!

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 9808 replies
    • May 17, 2023

    Never mind what I said earlier. I just discovered that if you use Airtable's native automations, and you type the URL within quotation marks for an attachment field, it will download the attachment and put it into the attachment field! I don't know when it started working this way, but it works this way now! 🙂 

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 9808 replies
    • May 17, 2023

    @openside @kuovonne @Hannah_Wiginton Did you guys know this? I just discovered this today! 🙂 

    G
    Forum|alt.badge.img+2
    • Giacomo_Corda
    • Author
    • New Participant
    • 3 replies
    • May 17, 2023

    Never mind what I said earlier. I just discovered that if you use Airtable's native automations, and you type the URL within quotation marks for an attachment field, it will download the attachment and put it into the attachment field! I don't know when it started working this way, but it works this way now! 🙂 


    Thanks for your answer @ScottWorld. My problem is that my starting point is a formula, not a url, so i guess the only way is a script.

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • 9808 replies
    • May 17, 2023

    You should be able to put quotes around the formula field in your automation and that should work. If that doesn't work, you probably don't need to write a script for this if you don't already know Javascript, because Make has built-in support for QuickChart. 

    G
    Forum|alt.badge.img+2
    • Giacomo_Corda
    • Author
    • New Participant
    • 3 replies
    • May 17, 2023

    You should be able to put quotes around the formula field in your automation and that should work. If that doesn't work, you probably don't need to write a script for this if you don't already know Javascript, because Make has built-in support for QuickChart. 


    Thanks @ScottWorld. It doesn't work, message is "Field "Chart image" cannot accept the provided value: Invalid string."  I try with Make or Zapier.


    Terms & ConditionsAccessibility statement