Periodically upload files in Zoho Creator to Zoho Workdrive

Periodically upload files in Zoho Creator to Zoho Workdrive

Requirement

Perform integration between Zoho Creator and Zoho Workdrive, and use Schedules to upload files from Creator to Workdrive on a monthly basis .

Use Case  

A project tracker app maintains report files of finished projects in a form - Projects. At the beginning of each month, report files of the projects completed in the previous month will be submitted for audit. To achieve this, a schedule will be run at the end of each month to create a new folder for the current month and push all the relevant project reports to the newly created folder automatically.

Steps to follow  

1. Create a form with the following details.
Form
Form Link Name
Field Type
Field Name
Field Link Name
Projects
Projects
Single Line
Company
Company
Single Line
Project title
Project_title
Single Line
Report
Report

This use case can be demonstrated using just the above-mentioned fields. You can include as many fields as required.
 
2. Create a connection with the following details.
This connection is used to authenticate the Zoho Workdrive account in which the files will be uploaded.

3. Create a schedule with the following details.
 
4. Click Add New Action > Deluge Script and add the following snippet:
  1. // Create a folder for the current month in Workdrive
  2. folder_name = "Audit_month-"+zoho.currenttime.getMonth();
  3. new_folder = zoho.workdrive.createFolder(folder_name, "oyw2o9aaeafa4c3e9421ca2ae4a8205d3c8c1", "workdrive_connection");

  4. // Fetch the ID of the new folder
  5. folder_id = new_folder.get("data").get("id");

  6. // Fetch the list of projects completed in current month
  7. projects_variable = Projects[End_date in this month];

  8. // Upload reports of the fetched projects to Zoho Workdrive
  9. for each rec in projects_variable
  10. {
  11.  response = zoho.workdrive.uploadFile(rec.Report, folder_id, rec.Project_title, false, "workdrive_connection");
  12. }

See how it works         

 
 


    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION









                                        You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                            Manage your brands on social media

                                              Zoho Desk Resources

                                              • Desk Community Learning Series


                                              • Digest


                                              • Functions


                                              • Meetups


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner


                                              • Word of the Day


                                                Zoho Marketing Automation

                                                  Zoho Sheet Resources

                                                   

                                                      Zoho Forms Resources


                                                        Secure your business
                                                        communication with Zoho Mail


                                                        Mail on the move with
                                                        Zoho Mail mobile application

                                                          Stay on top of your schedule
                                                          at all times


                                                          Carry your calendar with you
                                                          Anytime, anywhere




                                                                Zoho Sign Resources

                                                                  Sign, Paperless!

                                                                  Sign and send business documents on the go!

                                                                  Get Started Now




                                                                          Zoho TeamInbox Resources



                                                                                  Zoho DataPrep Resources



                                                                                    Zoho DataPrep Demo

                                                                                    Get a personalized demo or POC

                                                                                    REGISTER NOW


                                                                                      Design. Discuss. Deliver.

                                                                                      Create visually engaging stories with Zoho Show.

                                                                                      Get Started Now









                                                                                                          • Related Articles

                                                                                                          • Understand file upload field

                                                                                                            The File Upload field enables your users to upload a file while submitting their data through your form. Your users can select the file either from their device (in the device's local storage) or from any of cloud storage services we support. The ...
                                                                                                          • Zoho Creator - Starter Guide

                                                                                                            This page covers essential insights into Zoho Creator, a low-code platform offering support for multiple languages, shared responsibility models, and the unique Deluge coding language, providing comprehensive assistance for your business needs. What ...
                                                                                                          • Extract contents of a ZIP file and email the extracted files

                                                                                                            Requirement   Use Deluge to extract a ZIP file and email the extracted files with the click of a button. Use Case   An HR management application contains three forms: Add Employee, Employee Payslips, and Download My Payslips. The Add Employee form ...
                                                                                                          • Check for the type of the file uploaded

                                                                                                            Requirement Only allow the file upload field to accept file types PDF, XLS, or XLXS. Display an alert message when any other file type is detected. Use case A restaurant app contains a form to store supplier receipts as files. When an admin uploads a ...
                                                                                                          • Upload media

                                                                                                            FormUtil This util lets you manage the different functionalities in a form. Note: Zoho Creator's Mobile SDK is currently a Beta feature. We do not recommend using it for apps in the production stage. Upload Media in Java uploadFile(ZCForm zcForm, ...
                                                                                                            Wherever you are is as good as
                                                                                                            your workplace

                                                                                                              Resources

                                                                                                              Videos

                                                                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                              eBooks

                                                                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                              Webinars

                                                                                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                              CRM Tips

                                                                                                              Make the most of Zoho CRM with these useful tips.



                                                                                                                Zoho Show Resources