full database backup
hi how can i make full backup of all databases of my app? in admin console there is backup only of application
Import Bank Statement
To enable me to reconcile my bank account(s), I wish to import bank statements into my Creator accounting package. I know Zoho provide a number of accounting/invoicing etc. solutions and specifically, Books enables automatic bank feeds. Can I access this functionality from Creator?
repopulate dedleted field.
Hi, I need some help figuring out how to repopulate a deleted field. I have two forms, Assignments Form and units form. The units form holds information about the unit "Unit_number, Unit_size" Th data entry, Assignment form holds information about Task assignment" Assignment_number, Unit_number , Unit_size. I accidentally deleted the "unit_size" filed. from the assignment form and now I don't know the Bedrrom Size of the unit assigned/booked. What method could I use to repopulate this filed?
Custom Filter
I can search within a list and get the expected results, however I am unable to save as a custom filter or view, the saving pop up stays permanently on screen. Is this a bug is there a fix
Developer Acess
Hi, I don't seem to have the ability to define a developer in my application. According to the documentation I can do this through the manage user section. When I click to invite the developer it says in the documentation to click "Developer". Problem is there is no developer option. Nor is the Choose developer option under the General tab as in another account I have. I have an enterprise account so not sure why I can't do this. How can I add a developer to my application? Thanks
Call a custom schedule to run immediately from a form?
I am looking to to be able to submit a function to run numerous calculations that result in a report. I would like this to be initiated by the user, from a 'submit' button in a form. i.e. 1. User signs on and enters client financial data 2. Once entered, the user submits the information to run the calculations - I would like this to run immediately, but without tying up the user's session. Like initiating a custom schedule, but to run immediately. Is there a way to achieve this? Thank you!
How to list entries associated to an item?
Hi, I have 2 tables: COMPANIES Company Category Ranking Notes JOBS Title Company Category Ranking Notes . In the companies form, I want to list all the jobs associated to this company and be able to click on these jobs to view/edit them To get this, I have tried to use: a Lookup field: You can see it, it is named 'Jobs'. It does list all the jobs from this company, but is not a list of jobs with the possibility to click on it to edit/view a subform: I could not manage it work, I am a newbie. Any
Zoho Creator SLA?
Is there an SLA for Zoho Creator? A published uptime service level? Required for certain customers. Thanks,
Capitlizing a name...
Just thought this might come in handy for someone . You can use this function to captilize any text. It says name but it could be anything you want it to be string translate.capitalize(string name) { Uppercase_first_in_name = (input.name.toUpperCase()).subString(0,1); get_rest_of_name = (input.name).subString(1); capped_name = Uppercase_first_in_name + get_rest_of_name; return capped_name; }
map tutorial (Beginners)
Hello Zoho Creator fans, I thought I would make a post about some info, tips, ideas, I have around the the Zoho Creator "map" feature.... The map feature can be extremely poweful if you know how to use it. Unfortunately, there isn't a ton of documentation in the Wiki about it's cababilities.. First talk about what a Zoho Creator map is.... A map holds data! You put data in it by first creating a key and then adding a value. This is called a key, value pair. This key,value concept is used in well
Insert field data to email issue
Hi! I want to get email notification whenever a new record added to the DB, and I insert a "lookup"field into the mail template, but when I get email, the value of that field seems not correct, it shows something like: "1929807000000018033" , what should I check to make sure it insert the correct value into that email template ? Regards, James
Add Number / Decimal Field without using a formula Field? Possible?
Add Number / Decimal Field without using a formula Field? Possible? Let me know if it is possible? thank you
How to create a login form to my zoho creater signup form on my website!!!
Hello any body please help me!!!! I created a registration form using zoho creator,and now i need a login form for my website connecting to my registration form data and allow my users to access my site . So please help me regarding the above problem and please explain me in detail about it!!! Its urgent !!!
In reports, what does the "Like" search function actually do?
The only time "Like" seems to work is when an exact match is found. Therefore it seems indistinguishable from "Is" I would have assumed "Like" should function as a fuzzy string match, like php's levenshtein function. Cheers, John Whitney
is below stuff possible with Zoho Creator--imp
hi, our Organization basic requirements needs enlisted below 1) Authorization:- Admin assign roles to user then same roles will be approve or reject by Manager , according to that user can access forms. In case if Manager reject role same will be informed to Admin. 2) Sending Mail:- In case there are errors while importing data ,send respected errors as attachment to Manager and user. Then Manager will check data and approve or reject data. 3)Data Import:- When user import data ,same
Confirmation email sending ID instead of contents of Lookup field
I have talked to ZOHO many times but can not get an answer on a very serous problem for me. So serious that I might have to drop my account with them. My confirmation emails do not show the actual data in a lookup field. Instead they show the ID number which is of no use to me. Zoho simply says that is the way their new editor works which is simply insane. I am not sure if maybe Zoho support does not have a good command of English and they are misunderstanding me or they really have designed
fetch email from zoho crm to zoho creator
having a hard time doing this because i'm a nood :( Hope you can help me guys. Here is the code i use but it did not work :( if (input.Contact_Name != "") { vSearch = "(Contact_Name|=|" + input.Contact_Name + ")"; crmRes = zoho.crm.searchRecords("Contacts", vSearch, 1, 1); if (crmRes.size() > 0) { fa = crmRes.get(0); input.Email = fa.get("Email"); } } Here is the pictures
How to upgrade my zoho account to have new features?
We have been waiting for user permissions and some other features that i just found out are already integrated but only in new zoho accounts! How can I upgrade my zoho account to have these features? Do i need to cancel my entire account and attempt a migration? How can I get these needed features? I wanted to use customer portal but its mostly useless to us if we do not have access to user permissions. Please help me here. Thanks
How do I make a result report for just the last entry added?
Basically I have a report that displays deals that users have submitted. I would like to have a second report that will display the last deal entered. How do I do this? In the creator it seems to have minimum of 10 results. And what option/filter would I use to select last entry for display? 2nd I would like to know if there is a way to have the users select an entry and report it as expired. It is a public report so I don't allow user edits to avoid accidental or intentional deletion of the whole
Find and set null values to 0 in curancy field.
I have a currency field in which I did not set an initial value so it shows up as blank in my view. I now would like to find all null or blank values in my view/report and set them to 0.00 with out impacting the existing values. Please would be very much appreciated. Thank you very much
Export report to email?? Possible or not?
Can i ask if this is possible??
How I get the content of lookup field rather than record ID in NEM?
Hi, I need to make tips according to the lookup field contents, such as : if ( lookup = "male" ) { alert "You're a man"; } else if ( lookup= "female" ) { alert "You're a woman"; } But now I get ID from lookup field, should I need to search data using ID from another form like this ? var = form[ID=lookup]; if ( var.sex = "male" ) { alert "You're a man"; } else if ( var.sex = "female" ) { alert "You're a woman"; } Is there any way to get it convenient? Looking forward to your reply.
Zoho Creator Mobile Version
Hi guys, Still quite new to Zoho and how it all works. We have previously used Zoho Creator as an entry form - as it's a great way to get a database of people that Opt in. This is the old site we did and integrated Zoho Creator: http://www.adlab.com.au/promo/ The only report back we had it the site didn't work well on Mobile Devices. We now have a new promo starting and they want it mobile savvy. Just wondering can you use Zoho creator generated code to work properly within a mobile site? Please
please help for this
hi, our Organization basic requirements needs enlisted below 1) Authorization:- Admin assign roles to user then same roles will be approve or reject by Manager , according to that user can access forms. In case if Manager reject role same will be informed to Admin. 2) Sending Mail:- In case there are errors while importing data ,send respected errors as attachment to Manager and user. Then Manager will check data and approve or reject data. 3)Data Import:- When user import data ,same
Can we upload images from zoho creator to zoho Crm
we have a feature to add image in Creator and can we get the same image into the zoho CRM invoice ,like i want to create a customer Catalog and when a purchase is happened i need that image to be on the invoice.invoice contains ,Cus name,phone,collection name (image),model no and price.....
Making report based on existing report instead of table/form??
Hi All, I have two forms. Form 1 contains Product related details and form 2 contains stock related details. I linked both the forms to get product-wise stock related details. Now, if I want to link another new form to this report. How can I link it in Zoho creator? Please help!! Thanks! in Advance.
Adjust column widths in record view
Hello All, I am attempting to create a record view containing a table where the column widths vary. I inserted a table into the view with 5 columns, which creates equally spaced columns spread across the width of the view. I then edited the code for the column %'s. The column widths adjust as expected in edit mode. However, when you go to the record view in the application, the columns are still equally spaced. I am experiencing the same issue width the border weights for the same table. Any
You have reached maximum number of rows. You can not add further.
Using an funcion, and adding a attachment in subform, Zoho is telling me that I have exceeded my maximum number of rows (110,000). Does anyone have any idea why that might be the case? Thanks Mike
Publish app to client and relinquish ownership
I want to publish source and data to a client and then allow that client to publish the app as if he were the creator. [What I am really trying to do is "give" the app to this person to develop and use as they see fit.] I can publish the app and the client can use, edit, and share the app with his users, but when he goes to Developer Zone, it shows he has 0 apps developed and there are no apps that can be published. The only things there are the apps I shared with him, which are under "My Installed
Problems in sharing my applications
I have tried to share my application as public. It didn't get shared, neither did it show any messages to me about why it did not get shared. But making a form as private from public is happening successfully.
How to restrict users from exporting
Hello, I need to be able to restring the people who have access to my database from being able to export. Right now when users access my database they are able to export to PDF and CSV as well as other options. Is there any way I can stop this? Thanks.
Application Domain Mapping
Is it still possible to map a domain to an application without using the customer portal feature? Cheers, John Whitney
Expiration policy... specific number of days
I see in the Terms of Service a mention of account expiration due to inactivity, but it doesn't say how many days. Can you tell me how many days of inactivity will trigger account (or application) expiration? http://www.officeswap.com
Trouble with function to update field with current date via custom action
The custom action button in my report runs and displays the success message. However when I check the Quote Sent Date field it is empty. Here is my function code void SentRFQ() { rec = RFQ [ID == ID]; rec.Quote_Sent_Date = zoho.currentdate; } Any ideas
Access database from iphone app
Hi, I'm creating an iPhone app and wish to populate my remote database with zoho creator. I wonder if it is possible to access my zoho creator app's database from this iphone app like one can access a random remote mysql database. If so, how ? I didn't find any documentation on zoho's api's... Thanks.
Zoho Creator Accessibility
I'm interested in raising the awareness of web accessibility concerns within the Zoho Creator community. Some people cannot use a mouse, including many older users with limited fine motor control and users with impaired vision. According to the World Health Organization 285 million people are estimated to be visually impaired worldwide; 8.3 million in the US alone. All U.S.government and most educational institutions are required to have their IT systems meet minimum accessibility guidelines. Zoho
System Fields Missing from Report GUI
I wanted to create chart displaying a running total of sign-ups but "Added Time" and "Last Modified Time" are missing from the report builder GUI. Where did they go? Cheers, John Whitney
hi with sendmail functionality is below stuff is possible
hi, using send mail is it possible that 1)After successful upload of data it send mails to respected user and manager 2)In case there are errors while importing data ,send respected errors as attachment to Manager and user. 3)Then Manager will check and approve data. hi if above stuff is possible tell me how?
Zoho Creator pages are not accessibble to some users
We have found that some content in Zoho Creator is not accessible to our visually disabled users or users with limited dexterity. For many users the only way to access web content is through a screen reader or other assistive technology. There are a few simple things that can be done to make Zoho Creator accessible to everyone: Images should include alt tags Form labels don't reference the form fields, The Labels the "for" attribute like so: <label for="FirstName">First name:</label> <input
Addition of values not working as expected
Hi, I have a form1 with fields say Id,Name and Type and Quantity, Quantity available then form2 with fields say ID,Name,Type,Quantity,Quantity Sold and Quantity in stock. Based on the type given in form quantity available will be listed. What i want to do here is , On success of form 1 i have written a code to fetch the form 2 field with current form1 fields, If their type and name is equal then add Form2.Quantity =Form1.Quantity+form2.Quantity. rec = Form2[Event_ID == input.Event_ID.toString()
Next Page