Send files to airtable by apps script + HTML

I’m not sure I understand your question, but Airtable’s forms allow you to upload files to Airtable.

So you can just use Airtable’s native, built-in forms.

However, for more advanced forms, I would recommend using Fillout’s advanced forms for Airtable.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to connect a single form to dozens of external apps simultaneously, update Airtable records with a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Could you provide additional details like the script, a link to the form, how everything links together, etc?  I take it there are business reasons why you can’t just use Airtable forms instead?

Hey ​@Eduardo!

In addition to questions/comments above, if everything worked for your for a long time and all of a sudden it is not working anymore (assuming that no change was done to your data base architecture/fields), I would highly suggest you reach out to Airtable’s support team by emailing the following address: support@airtable.com

If it worked and now it doesn’t something might have changed, or it might be a bug of some sort.

Please keep us posted!

Mike, Consultant @ Automatic Nation 

Thank you all for commenting, my problem is that I made a form in google scrip apps and with html which are connected to airtable and the data part arrives perfect the problem is the attached files those are not reaching airtable. And if I have Fillout, but it doesn't have the flexibility that I have with my own html

If you have a base 64 encoded file that is less than 5 MB in size, you can upload that file directly to an Airtable record by using this endpoint.

Otherwise, you would need to use the normal REST API calls for creating & updating records in Airtable.

Those API calls require that your file is stored at a publicly-accessible URL.

So, you would need to upload your file onto a cloud drive somewhere — many people use Google Drive to store their files — and then you can reference your file that way.

Note that if it’s not working for you, then you may be using the Google Drive “webpage wrapper URL” for your file. In other words, you may be referencing a Google Drive webpage instead of the file itself.

Here’s one way to designate the direct path to a Google Drive file:
https://drive.google.com/uc?id=[YourFileIDHere]

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hey ​@Eduardo,

Out of curiosity. What is the flexibility you are looking for with your own HTML?
If design, what aspects of the design? Trying to understand where Fillout is short on this one. 

Mike, Consultant @ Automatic Nation 

​@Mike_AutomaticN 

If I tell you, for example, Fillout does not allow sending data to multiline Airtable, I attach an image, having a horizontal design data entry form, the other thing if you do not assign the users in Fillout you do not know who is entering the data, on the other hand with my own design in HTML I know who the user is by their email, therefore I block them or give them access as I decide, well and several other things, I am not saying that Fillout is bad at all but it lacks the flaccidity that you have with HTML

​@ScottWorld 

correct I am invoking the base 64 method, until last week I was uploading data and attachments from my html to airtable without any problem, this week I saw that google made changes with the issue of persimmons to force in different ways until sending the url of the document to airtable and with that url in airtable a scripting that downloads the url and saves it in an airtable attach column, the automation tries to do it, it shows me how it does it and deletes the attachment, what I am looking for if you have some test example where I can validate a routine of an html that delivers a pdf to airtable. and ideally the file as such is not url

​@Eduardo 

Actually, that is incorrect. You can do everything that you listed above — and much more — with Fillout’s login pages.

Regarding your URL, if your URL is not loading in Airtable, then your URL is incorrect in one of the ways that I listed above:

Either your URL is not publicly accessible, or the URL doesn’t lead to the file itself.

What URL are you trying to upload into Airtable?

- ScottWorld, Expert Airtable Consultant