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


            Get started with Zoho Sign

            in a few quick steps!

            Download Help Guide





                        Still can't find what you're looking for?

                        Write to us:  support@zohoforms.com


                              




                            

                          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 SalesIQ Resources



                                                    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 ...
                                                                                      • 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, ...
                                                                                      • Understand preview of file in list report

                                                                                        The File Preview feature enables you to view files in a report before downloading them. You will be able view the file in a preview window. Previewing will be applicable to fields that capture files: this includes file upload, image, audio, and video ...
                                                                                      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