Smart Software For Maverick Entrepreneurs

By: CreatorScripts | August 15, 2018


Zoho Creator does have an automatic weekly and monthly backups of all database details, but there is no way to create a daily backup. A solution is to leverage Dropbox API to send a copy of all records in a view to dropbox on a daily basis.

The Solution...

The solution is quite elegant. First, you need to send an email to a Form that will store the attachment you want to backup. You would then need a clever iteration setup to consider large number of records in a view. 

Below you can get the script for the file creation.


void Dropbox.fileCreation()
getMaximumAuto = YOUR_FORM_NAME[ID != null].maximum(Auto_Number);
maxLoopN = getMaximumAuto / 3000;
i = 0;
for each  rec in YOUR_FORM_NAME
if(i >= maxLoopN)
start = i * 3000;
end = (i + 1) * 3000;
from :zoho.adminuserid
to :""
subject :"Records from zoho " + zoho.currenttime + " " + i
message :"Dropbox"
Attachments :view:YOUR_VIEW_NAME[Auto_Number >= start && Auto_Number <= end] as XLS
i = i + 1;

Second we need to send the file to Dropbox by executing the SendfiletoDropbox function on Add on Success of YOUR_VIEW_NAME 

getData = Dropbox[ID == input.recID];

Get the full script to integrate the Dropbox API to your Zoho Creator databases from our Deluge Scripts Library. If you need a Dropbox Account open one for free here. Dropbox Sign Up

Category: Zoho Creator 

Tags: API, Data Backup, Dropbox 


Be the first to comment ...

Post a Comment