I am trying to automate my JotForm submissions so that every time a new form submission is made a new project is created in BaseCamp and a PDF of the completed form is uploaded to BaseCamp. I currently have a Zap that creates a new BaseCamp project upon submission of form and that's all I could get. I have JotForm automatically sending a PDF of the completed form to Google Drive. So once the project has been made from the submission trigger, how do I get that specific form PDF from Google Drive uploaded into the BaseCamp project?
Best answer by JDCView original
Try adding a GDrive Find File step to the Zap.
That was able to get the Google Drive option into my Zap. I am still having issues with how the everything links to each other. Like when I ran the Zap, it created the project fine, but stopped at finding the PDF on Google Drive. I think the problem was because I didn't have it looking in the right place. When JotForm creates a PDF, it makes a folder with the same name as the PDF…. So I need to tell the Zap to first look for the PDF in that folder.
Hopefully I will have better luck troubleshooting it tomorrow.
@JDC You can search for a file across GDrive, so you shouldn’t have to specify the folder, just perhaps the parent folder.
This may be a limitation of the endpoints available as part of the Basecamp3 Zap app integration.
Is there a default folder created for a new project that can be selected?
Is there the ability to setup internal Basecamp3 automation to have a folder created for a new project?
Here are all of my steps so far. I added the “find project” step so that I could reference it when uploading the file to the project. Anyways, when I reference the found project in step 6, it still can't see that there is a folder.
As you can see, the newly created project does have a folder. Why do you think it isn't seeing it? Also, I did try “refresh fields” multiple time and the folder still never came up as an option.
When you do the Find Project step in Step 5, does it return the ID of the Folder to map thru to Step 6 as a ‘Custom’ option for the Folder field?
This field is likely expecting the Project ID, not the Project Name, from Step 5.
Also, you may need to add a Delay step to the Zap to let the Folder be created on the Basecamp3 side.
I think I got the folder working. You were right, it was looking for a project ID#. My new issue is with how Jotform saves their PDF’s to Google Drive. It seems that the files names that I was using are off by one second. So now I have to figure out how to change the PDF’s naming. But thats more of a Jotform question. I will let you know if I ever get it working as by now, you must be fully invested in my journey lol.
Options to try…
So far, everything is working up until the final step of actually getting the PDF from Google drive uploaded to the BaseCamp3 project. In the “Find the File” step, it successfully found the file in Google Drive. However, in the “upload file to basecamp” step, it is not finding the file. I think I am not using the right name for the file. Same way I wasn’t using the right name for the project so many posts ago. So Here are all of the options that I have, Which should I select?
Also, this is what I have for the above step to find the file in Google Drive.
Check out this help article: https://zapier.com/help/create/basics/send-files-in-zaps#place-a-file-in-the-action
I took all of the URL’s listed in the “file” drop down from the “find Google Drive file” step and I put them all into an incognito page to test them and none of them worked. So I am still not sure how to link to the Google Drive file and get it uploaded to BaseCamp3.
I used the “File (Exists but not shown)” but it returned this error.
Perhaps it’s best to now submit a ticket to Zapier Support:
done. Thank you. Really appreciate all your help.
Just wanted to let you know that support got everything working. Thank you again for all of your help.
For sake of the community, should someone come across this post, would you mind sharing what the issue was and what the fix was?
This is directly from support:
What I believe needs to happen is that 2 fields in step 6 of your Zap need to be dynamically updated. You see, every project receives its own "Docs & Files" ID.
The Zap needs to dynamically point to the ID of that folder for the project that was created. This is where things get a little messy.
Step 5 does return the ID that's needed, but it's concatenated amongst a whole heap of other IDs. Thankfully, we can parse it out.
This will break apart a variety of IDs from Basecamp so they can be accessed as individual values.
Then, in step 7 of your Zap in the "Folder" field select "6. Output Item 3":
What this will do is give Basecamp the folder ID specific to the project that was created. After some more digging, you should be okay to leave the "Project" field with "5. Project".
That’s amazing that you came back and presented the solution that our Support team provided :) That’s super helpful, and much appreciated!
And thanks for the callout
@Troy Tessalone! We definitely want to recognize when someone finds a solution and brings it back to the Zapier Community.