Auto Back Ups
I am looking for a way to auto backup my data in a timely way, so I don't loose my existing data. I would like it to be able to back up to a location, or send me an excel or google drive sheet for each form
How to export all Zoho Invoices into a Form in Zoho Creator?
I need to connect Zoho Invoice to Zoho Creator ( Not the otherway around) without using a 3rd party application. Has anyone accomplished this already? Function Get All Invoices saves the data on a MAP varaiable. How do I get it into a table from there?
Retrieving details from product details from Zoho CRM order
Hello everyone, In the application I am building on Zoho Creator, I need to retrieve product details from the Sales Orders which are in Zoho CRM. // Get the Sales Orders from Zoho CRM salesOrders = zoho.crm.searchRecords("SalesOrders", "(Status|=|Asignado)"); // Add the Sales Orders records in the Orders table for each saleOrderDet in salesOrders { // DEBUG info "Order: " + saleOrderDet.get("SO Number"); // DEBUG // Get the Products from every Sale Order record productOrders = saleOrderDet.get("product").toJSONList();
hi can i keep few columns invisible in report
suppose i have two columns name "First name" and "last name" which are visible but output of both having "Full Name" is only visible under report view view show only "Full Name" column which is calculated result of First name and last name columns can i do it?
Populate a field into a form with zoho.loginuser
All, I created a form to enter data for customer engagement. One of the field is "userid" and I would like to populate this with the value of zoho.loginuser so that the user is already presented with a correct value that could not be changed. I know there is "added user" but I have old record where the added user was a different one and that now belong to a new user and I don't know/want to change all the "added user" value for that record. For this old record the "userid" field has been already
can i update data with import
if i have 4 columns 1,b,c,d and on the basis of fist 2 unique columns a and b i want to update c and d can i update rows with import
Formula field popup warning message
I am getting a warning message before I add a new fx Formula field "All reports involving this field also will deleted Do you really want to change expression?" I am confused because this is a new field and I have not seen this message before. I don't want to lose any reports. Can anyone explain why I am seeing this? I have not seen before. formula ((field1/field2)*100).round(2) Thanks
REST API, POST jsonp and authentification token
Hello, It seems than when using the Jquery $.ajax(type='GET') authtoken is correctly checked and no data can be retrieved if authtoken is wrong. When authtoken is correct, request status is success and data is correctly retrieved. This is, I guess, normal behaviour. But, when using the Jquery $.ajax(type='POST') $('#signIn').on("click",function(){ var formData = $("#userForm").serializeArray(); $.ajax({ type: 'POST', data: formData, url: 'https://creator.zoho.com/api/******/json/*********/form/User/record
Form reading from MYOB
Hi, Has anyone successfully connected a zoho form to MYOB for reading data? I know this post is duplicated but last question on myob was over a year old and only refers to buying third party software? Cheers Scott
How to add a formula that adds 10 day on curent date
I am new on the creator I would like to create formula filed that adds 10 days current day and show on the formula field any help will be appreciated
Urgent Help for "invalid entries found please correct and submit again" error in zoho creator
I am getting this error message when we update data as "invalid entries found please correct and submit again" in zoho creator. We are adding data sucessfully but can not update it after that.
MultiSelect field doesnt give Item Names but only system ID. How can I get Item Names of selected items from a multi select items
Basically I want item names from lookup based multiselect field. I have a lookup in which I have selected a multiselect field, and when I select items in multiselect and submit the buttons , I only get System Id. I have written following code on submit buttton- <some variable> = input.<multiselectfield> I have even tried fetching Item names using for loop with following code but and I succeeded in getting name but it only returns 1 same name even if I select another item name : for each input
Creating Paydates
I am trying to create an Auto Pay date, based on Bi-Monthly dates, and have it auto fill. I want to use just Fridays and I loaded a start date, and added 14 dates to that date. It keeps coming back as a bad error on Load. Any Ideas? //Next Pay Date Automatic //Add auto increment number x = Paydates [ID != (1 / 7 / 2014)]; input.Next_Date = x.Next_Date + 14; x.Next_Date = x.Next_Date + 14;
How to integrate web form created in ZohoCreator into custom module of Zoho CRM ?
Hello Team Is it possible to create a web form in Zoho Creator and then integrate it into Zoho CRM custom module so that form values are populated into the custom module in Zoho CRM? Please explain me how to integrate the form into Zoho CRM custom module? BR Zorge
Join us for the first Zoho Creator Developer Conference.
With the objective of fostering a stronger relationship with our users and to effectively support them in achieving their business goals, we are organizing ZOHOLICS developers, our first Zoho Creator developer conference. The event is to be held on March 20th and 21st in California. The event will have more than 15 sessions spread over two days with the keynote being delivered by Sridhar Vembu, CEO Zoho Corporation. You can expect deep-dive sessions into Scripting, integrations and best practices
Sign In and Out for Embedded Pages
I have a page that I shared publicly. It has some code that forces people to sign in. http://buzzable.info/?page_id=9 How do I get the sign in process to refresh either the iframe or whole page? I played around with the service url and it failed to do anything. After you sign in, I have added a button to sign out. Once again, how can I make the sign out process refresh the iframe or whole page Application buzzap/formacademy has been shared with support. Cheers, John Whitney
"Not able to find 'count' function"
I am trying to edit some code that is currently working but am not getting an error that says: "Not able to find 'count' function" The code with the problem is: filecount = Purchase_Request_Form[ID == input.Request_ID].count(Build_Files.ID); As I said this code is currently working including the count function. Im trying to change a parameter in an if statement in this form and I cant save the updated code now because of this error. I am in free flow scripting mode. What is wrong?
Exporting creator files to word templates
Hi I was wondering if there was any way to export information from the database creator to a template or word doc that I have created. Like what you can do with mail merge in excel. I primarily use zoho creator but am willing to incorporate zoho docs if need be Thanks Chris.
How to reload a stateless form with updated data
I have a stateless form with 2 fields. One is a key of a form. The user enters that field and clicks a button on the stateless form. This button retrieves the form using the key, and copies a data-filed from the retrieved form into the second field on the stateless form. What do I need to do to show this second field to the user? The <reload> function basically refreshes everything. Any suggestions? thanks Henk
Duplicate record summary
Hello there! Is it possible to duplicate a record summary? We have already created a nice record summary ready to be printed or exported as PDF and we'd like to use it as a template, removing or addings specific fields and headings for each custom report. Thanks in advance.
Pull field from another relationship
In our database, there are many "contacts"...some contacts are "clients", while other are not. It is a one to one relationship, but I didn't want to combine the two forms as that would leave many empty fields. Instead, I created the CLIENT form that contains a lookup box that pulls the name from the CONTACT form. We also have a form called CASES, where a case can have one or an infinite number of clients. I added a lookup box to that, but I cannot show the name field from the CONTACT form, I can
REST API criteria in update request
Hello, I've tried to update my Zoho Creator View by using Email as criteria. $criteria = "Email=$user_info->user_email";The response is a failure, with the following response : update: {"formname":["User",{"operation":["update",{"newvalues":[{"WP_ID":"135","WP_login":"f","Origine":"wordpress"}],"criteria":"Email = f@mail.com","status":"Failure, No Records Found With Specified Criteria."}]}]} f@mail.com obviously exists in my zoho creator view, and a test based on another criteria ( WP_login ) works.
Removing the currency symbol in a formula result
HI, I am calculating ROI which means I am constructing a ratio between currency values and time. My results are showing as $5.10 months. Any simple suggestions for removing the "$", other than redoing it all as decimal? Thanks, PM
Customer portal and pictures
Dear team, For a project I am working on for a customer, I am having some questions related to the announcement on the blog about customer portal. My application will be used by operators in the field. They will therefore use Zoho Creator on their Android device. We would like to be able to add pictures as attachments to a form. This is because they want to have proof of delivery and install done with customer. Is that currently possible? My customer would like to show these pictures to his end customers.
Send Todays Tasks by Email
I have a built a tasks app, I would like to make it so that on the due date tasks are emailed to the relevant person. I am trying to add a schedule using "Workflow" and the "Schedules" and the "form schedule". I have done it all ok but if I click execute to test I get a message asking which task ID. In the "What to do" page I have it set to filter tasks that fit the criteria. Below is what I have in the "message" of the "When to do" page but when I click execute it asks for a task ID. That would
Attaching images and file size restriction
we are on the enterprise plan and have close to 44 users and run 90% of our organization on creator. most of the employees are on the field and they use customized forms that require them to attach several photos on certain forms but some users can not submit and its always hit and miss because the smartphones take these pictures at high quality and some phones do not have the capability to downsize. we have full time developers and coders in our company and we hit a wall here and its creating major
Month should adhere to standard Calendar months (full name ONLY)
hi, i want to give input month which should adhere to standard Calendar months (full name ONLY), please help
Users unable to view HTML page
I have spent some hours (and had a LOT of help from Herb Wexler) building an HTML page which displays a compiled view of information held on 15 tables within my database. The html page is run through an action button in one of the views. I have shared the page out to all domain users. Until now, myself and the developer have been running the html page and printing off the records, but we are ready to train users and hand this application over to business as usual. Unfortunately, when a user selects
IF statement -- Date == NULL Error.,
HI, I am facing null error on the below 1st line (IF statement). All 4 fields are of type Date. if((((input.From_date == null) || (input.To_Date == null)) || (input.From_mon == null)) || (input.Date_monto == null)) { Execute; } Else { Execute this; } Let me know the solution.,
Conditional if statement in scripting
What's wrong whit this script? Or what else can be wrong? I always get back the FALSE value, 200.0, regardless the input. input.Painting = if((input.BWS < 40.0),2.0,200.0); I have the sensation that the input.BWS < 40.0 has not be considered at all. Do you have some experience like this? (the input.BWS in the <boolean-expression> is Look-up field, with an applied filter, so it is dynamic) can it be a problem?
View Image without login
With Zoho Creator API, image fields are returned as HTML tags with src being the image URL. However, loading of images uploaded to Zoho database requires the user to have a valid session. I am building an application which requires public access of the uploaded images. Is there a solution to this problem without making public my view? Any help will be much appreciated.
Mail Suite Contact Data Entry through Web Form (NOT CRM Contacts)
Hi, I am trying to find out if I can make a web form that can be used to enter contacts into the zoho contacts that are part of the zoho mail suite (also accessible at contacts.zoho.com). VERY IMPORTANT - this is in reference to the contacts in zoho mail suite - NOT in CRM. I did see the webform for CRM contact entry, but we are planning on using zoho primarily for email and possibly campaign purposes, and while CRM's functionalities are impressive, they are not applicable for our purposes. While
Passing value through open URL not working for me.
Im using the following function on each record in a view. This function opens the edit mode for the record and I want it to set the field "edit_design" equal to "Yes". trouble is when i use the function the edit_design field is not set to Yes. What is wrong with this function? The field "edit_design" is in the form Purchase_Request_Form and is a drop down menu with values "Yes" and "No". Im sure this is something simple but i cant seem to find it. Please help! void editDesign_upload(int ID, string
Report for loop Syntax
I'm trying to construct a report that's to the value start date between the first and the last date of the current month. I know that I can do this through a filter but I'd like it to be coded so that I can ahve it be emailed list Report_Example { displayname = "Report Example" #show (for each TimeSheet in Time_Sheet [Start_Time > zoho.currentdate]) ( Employee_Details as "Employee" New_Company as "Client" New_Project as "Project" Start_Time as "Start
Open source fonts
Is it possible to use open source fonts (e.g. google fonts or icon fonts) on html pages? Thanks.
Customer Portal Limitations
Can you please tell me the limitations of the customer portal? For example, if I buy it as add on can I use it in all my zoho creator applications (I have 8) or I have to buy it separately for every application?
Attach multiple uploaded files from subform in email
I want to attach multiple files that have been uploaded in a subform to a particular record in my email. The code im using is below, I know this is close but it doesn't seem to work when i put the variable holding the files uploadfilecvar into the attachments :file: part of the email. If I use attachments :file: file.File_upload then only one of one file is attached. How can i get this to email all of the files attached to a single email? If i put sendmail inside the for loop then it will send
how to create a label on the form
Is it possible to create a label on a form, as we could do when creating a form in Access ? For example, I would like to have on the right side of a field the format the user should follow to type the data in. ex: 99.999.999/9999-99 Thanks
can you please help me to configure field actions to accept fiscal year between 2010 to 2020
hi, i have field which take fiscal year input between 2010 to 2020 how can i write code for same
i want to give uniqueness to combination of 4 columns
hi, i have 6 columns a,b,c,d,e,f ,but i want to add records with unique combination of only 4 columns a,b,c,d please help
Next Page