Skip to main content
Solved

Exporting a Block to Wix

B

Hi All,

I’ve got a client that wants to be able to view airtable data in wix.

This has been easy enough when using a grid - eg customer comments for the last month.

But,… what I’d like to do is have a chart eg “customer satisfaction by month” grid data is “date” and “rating” (values of 1, 2 or 3).

The awful solution i can think of is manually export to csv, generate the chart, save as image, the save to webpage - but that is awful. Is there something I could do with API? That is way beyond my capabilities though (but I’d happily accept help or pay someone via a freelancer app)

I’m not committed to wix so if there is another way I’m open to that.

Thanks heaps in Advance :slightly_smiling_face:

Best answer by kuovonne

While the API can do amazing things, it sounds like overkill for your situation, and it would also depend on whether or not Wix has a compatible API.

Do you need a fully automated process, or would a less intensive manual process still work?

It sounds like you have two issues:

  1. creating the chart
  2. getting the chart to the website

You can easily create charts in Airtable with the Chart Block. Note that the Chart Block requires a Pro subscription.

However, these charts cannot be directly embedded in a web page, so you still need to figure out step 2.

One way of getting an image from an Attachment field in Airtable to a website is to use a WordPress website (instead of Wix) with the Airpress plugin.

While this process still requires taking a screen capture of the chart, saving it to a file, then uploading it to Airtable, it is much less work than the process you were describing.

View original
    Did this topic help you find an answer to your question?

    4 replies

    kuovonne
    Forum|alt.badge.img+27
    • kuovonne
    • Brainy
    • 6001 replies
    • Answer
    • March 1, 2020

    While the API can do amazing things, it sounds like overkill for your situation, and it would also depend on whether or not Wix has a compatible API.

    Do you need a fully automated process, or would a less intensive manual process still work?

    It sounds like you have two issues:

    1. creating the chart
    2. getting the chart to the website

    You can easily create charts in Airtable with the Chart Block. Note that the Chart Block requires a Pro subscription.

    However, these charts cannot be directly embedded in a web page, so you still need to figure out step 2.

    One way of getting an image from an Attachment field in Airtable to a website is to use a WordPress website (instead of Wix) with the Airpress plugin.

    While this process still requires taking a screen capture of the chart, saving it to a file, then uploading it to Airtable, it is much less work than the process you were describing.

    B
    P
    2 people like this
    • B
      Ben_Engel
    • P
      Pete11
    B
    • Ben_Engel
    • Author
    • New Participant
    • 3 replies
    • March 1, 2020
    kuovonne wrote:

    While the API can do amazing things, it sounds like overkill for your situation, and it would also depend on whether or not Wix has a compatible API.

    Do you need a fully automated process, or would a less intensive manual process still work?

    It sounds like you have two issues:

    1. creating the chart
    2. getting the chart to the website

    You can easily create charts in Airtable with the Chart Block. Note that the Chart Block requires a Pro subscription.

    However, these charts cannot be directly embedded in a web page, so you still need to figure out step 2.

    One way of getting an image from an Attachment field in Airtable to a website is to use a WordPress website (instead of Wix) with the Airpress plugin.

    While this process still requires taking a screen capture of the chart, saving it to a file, then uploading it to Airtable, it is much less work than the process you were describing.


    Hi Kuovonne,. thanks heaps for your reply.

    Thinking about it now,… I think I’ll propose creating a summary view and then dragging that across.

    Really appreciate your help :slightly_smiling_face: :slightly_smiling_face:

    kuovonne
    Forum|alt.badge.img+27
    • kuovonne
    • Brainy
    • 6001 replies
    • March 1, 2020
    Ben_Engel wrote:

    Hi Kuovonne,. thanks heaps for your reply.

    Thinking about it now,… I think I’ll propose creating a summary view and then dragging that across.

    Really appreciate your help :slightly_smiling_face: :slightly_smiling_face:


    Here’s another idea. It really depends on how the data is structured, and the exact info you want. But you can fake a horizontal bar chart in a grid view.

    1. Create a table with one row for each row in the horizontal bar chart. (Or used an existing table.)

    2. Have formulas or linked-records/rollups to calculate the number value for the bar chart.

    3. Have another formula field turn that value into a series of emoji, depending on the value.

    4. Share the fully automated grid view!

    B
    1 person likes this
    • B
      Ben_Engel
    B
    • Ben_Engel
    • Author
    • New Participant
    • 3 replies
    • March 2, 2020
    kuovonne wrote:

    Here’s another idea. It really depends on how the data is structured, and the exact info you want. But you can fake a horizontal bar chart in a grid view.

    1. Create a table with one row for each row in the horizontal bar chart. (Or used an existing table.)

    2. Have formulas or linked-records/rollups to calculate the number value for the bar chart.

    3. Have another formula field turn that value into a series of emoji, depending on the value.

    4. Share the fully automated grid view!


    Hey I like that !! :slightly_smiling_face: and I think the client will find it quirky and fun too. Thanks heaps again for your help.

    Reply


    Most helpful members this week

    Terms & Conditions