Make.com Integration>Submissions showing as blank in Airtable

airtable

i used this scenerio in make:

but when i run the scenerio i get empty fields...

i got the info in the Get Form Submisions module:

and i mapped it

so why the table is blank please?

Hi Ron,

Thanks for reaching out to Jotform Support. I'll need a bit of time to look into this and I'll be back as soon as I can.

Thanks for your patience and understanding, we appreciate it.

thank you

Hi Ron,

I can easily replicate the issue. For some reason it comes up empty when passed over to the next module. I've tried setting up multiple variable as well, but the the variable set shows blank as well. You can try switching over to Watch Form Submission module, it appears to work perfectly using that. I'm referring to this:

It requires your account's API key, so you will have to get it first from your account's API page. We have a guide about that here.

Give it a try and let us know how it goes.

thank you for your answer. as i understand watch submitions is for future submitiont that will be submitted... what can i do if i have about 100 past submitted forms that i need to export with their link to pdf or pdf file of the submition to airtable please?

Hi Ron,

To send the old submissions to the Airtable, you can create a button in your submission table and enter your Webhook link there. Let me show you how:

1. In Jotform Tables, click on the Add button at the end of the rows, and click on the Buttons tab.

2. Select Send Data to Other Apps, click on Next, and enter a column name, then click on Next again.

3. Now, search and click on Webhooks integration and enter your Webhook URL.

4. Then, click on Complete Integration Button below.

5. Finally, click on the Create Column button, and you're done.

Now, when you click the Send Data button, the data will be sent to the Airtable. Take a look at the screenshot below to see my results:

You can also check out this guide about How to Send Data to Other Apps in Jotform Tables for more information.

Also, you can try to edit your old submissions from your Jotform Tables and submit them again. Let me show you how:

1. In Jotform Tables, click on View icon beside the submission date by hovering over it.

2. Click on Three Dot icon in the menu on the right, beside the Print icon at the top.

3. Now, click on Edit Entry from the list to edit the submission.

4. Finally, click on Submit button below.

You can check out this guide about How to Edit Submissions in Jotform Tables for more information. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Give it a try and let us know if you need any other help.

thank you very much can you please tell me where can i get the link to the PDF submission from the watch submitions module?

i want to send this url to my CRM to attach it to aclient file on my CRM

thank you

Hi Ron,

I understand what you’d like to do, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

Thanks for your patience, we appreciate it.

thank you very much

Hi Ron,

If you mean you want to get the URL to download the submission PDF, you can use the link below:

https://www.jotform.com/server.php?action=getSubmissionPDF&sid={submission_id}&formID={form_id}. 

Make sure to replace {submission_id} and {form_id} with your actual submission and form IDs in Make. Here's how to do it:

1. In Make Scenario Editor, click on the Airtable field where you want the link to be added. For this demo, I used the Notes field.

2. Paste the link you just copied above, then replace the {submission_id} and {form_id} placeholders with the actual submission and form IDs you get from your test data.

3. Click on Save, and you're done.

And that's it. After every new submission, you'll get the link added to the Notes field that'll allow you to download the submission PDF. Check out the screencast below to see how it works:

Give it a try and let us know if you need any more help.

i got submission pdf url but it is closed to view without me logged in

how can i get submissuin url that will be open to view to all users also not logged in please?

Hi Ron,

To view the submission attachments or PDF without logging in to your account, you just need to disable the requirement to Login to View Uploaded Files. Let me show you how:

1. In My Workspace, click on your Avatar on the upper right corner of the page.
2. Click on Settings.
3. Go to Security Tab and click Send Verification code to access your Security Settings. Enter the Verification Code that will be sent to your email.
4. Uncheck the box next to Require Login to View Uploaded Files.

This will allow anyone with the link to view the PDF submission.

Give it a try and let us know how it goes.