Skip to main content

Update airtable record with integromat

  • October 23, 2020
  • 14 replies
  • 60 views

Hi,
I would like to update a record in airtable,
The record is a PDF file I created in my Google drive and now I want it to be a record in airtable.

I don’t know how to fill these fields: File URL
Can you please help and send example what to fill in?

14 replies

Forum|alt.badge.img+20
  • Inspiring
  • October 23, 2020

Hi @Ariel_Sigler

I did some testing with a scenario setup and it seems the only way I could get this to work, is by using a URL field in Airtable.

I will attach screenshots to show my setup below.

Hope it helps.


  • Author
  • Known Participant
  • October 24, 2020

Thanks again so much.
Your help is so important and crucial.

I did exactly as you suggested, but I want at the end to update a record which contains a file.
SO see below that I was asked to add a File URL address . I am not sure from where and how to get this information.


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • October 24, 2020

@M_k I wouldn’t recommend using the “Download A File” module. Just use the Google Drive “Get A Share Link” module instead:


  • Author
  • Known Participant
  • October 24, 2020

@M_k I wouldn’t recommend using the “Download A File” module. Just use the Google Drive “Get A Share Link” module instead:


Thank you very much!
You are absolutely correct.
No need to upload a file. Better upload the link.
Let me know If I can return you back a favor.
Ariel


Forum|alt.badge.img+20
  • Inspiring
  • October 24, 2020

@M_k I wouldn’t recommend using the “Download A File” module. Just use the Google Drive “Get A Share Link” module instead:


Hi @ScottWorld

Thank you for the suggestion!

Mary


Forum|alt.badge.img+20
  • Inspiring
  • October 26, 2020

@M_k I wouldn’t recommend using the “Download A File” module. Just use the Google Drive “Get A Share Link” module instead:


Hi @ScottWorld

I wondered if you could take a quick look at this scenario that I did, following you example. I am not getting any PDF attached to a record. The field is an Attachment with an array.

Screenshot 4 has no data coming through, in the GDrive, together with the yellow tags. It’s the Attachment field.

Thank you,
Mary


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • October 26, 2020

@M_k In your 2nd screenshot, you need to change it from “User” to “Anyone”, which is also what it says right on the screen there. In your screenshot, it says: “If you need to generate a download link for any kind of service, set Type to ‘Anyone’ and Role to ‘Reader’”


Forum|alt.badge.img+20
  • Inspiring
  • October 26, 2020

@M_k In your 2nd screenshot, you need to change it from “User” to “Anyone”, which is also what it says right on the screen there. In your screenshot, it says: “If you need to generate a download link for any kind of service, set Type to ‘Anyone’ and Role to ‘Reader’”


Hi @ScottWorld

Well, it shows you how much I read these things, eh. :grinning:

I’ll give it another go!

Mary


Forum|alt.badge.img+1
  • New Participant
  • October 27, 2020

You can use the Web Content Link to access file directly, rather than add the second GDrive module. But it still has to be public.


Forum|alt.badge.img+20
  • Inspiring
  • October 28, 2020

You can use the Web Content Link to access file directly, rather than add the second GDrive module. But it still has to be public.


Hi @Joe_Hand, @ScottWorld

I did it!!!

I created another attachment field and it worked!

Yay! :grinning:

Mary


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • October 28, 2020

Hi @Joe_Hand, @ScottWorld

I did it!!!

I created another attachment field and it worked!

Yay! :grinning:

Mary


@M_k Fantastic to hear! :slightly_smiling_face:

This has actually been deprecated by Integromat. This will only work for older scenarios that are grandfathered in. For any new scenarios, we are now required to add the new “Get A Share Link” module to grab the “web content link”.


Forum|alt.badge.img+20
  • Inspiring
  • October 28, 2020

@M_k Fantastic to hear! :slightly_smiling_face:

This has actually been deprecated by Integromat. This will only work for older scenarios that are grandfathered in. For any new scenarios, we are now required to add the new “Get A Share Link” module to grab the “web content link”.


Hi @ ScottWorld

Interesting you should mention that, I was only able to map it from the second module, as it turned out.

Mary


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • October 28, 2020

Hi @ ScottWorld

Interesting you should mention that, I was only able to map it from the second module, as it turned out.

Mary


Right, that’s the new process.


Forum|alt.badge.img+20
  • Inspiring
  • October 28, 2020

Right, that’s the new process.


@ScottWorld

Thank you for your help with this, I realize you are busy.

Mary