Retrieve Data from Zoho CRM to Creator Form
Hi, I am trying to auto populate of Email field of Creator Form based on the selected Zoho CRM Contact Name. I was trying with below script but it is not working crmResp = zoho.crm.searchRecords("Contacts", "(Zoho_CRM_ID |=| input.Zoho_CRM_ID)"); input.Email = crmResp.Email; Screenshot of Form: Thanks Arfater
Multiple customers with multiple users at each site
Hello, I am rewriting a program that I have been selling for 20 years and am wondering if I can use Zoho Creator to do it. What I have is multiple sites with each site having multiple users. I need the data from each site to be accessed by only that site but by multiple users at that site. Is it possible to do this using Creator and if needed the Customer Portal? Thank You, Paul
Update a date field when an e-mail is sent?
Hello, Is it possible to auto-update a date form when an e-mail is sent in g-mail? For example, I'd like to have a "Last Correspondence" date field that will auto-update when a certain gmail account sends an e-mail to the e-mail address in the person's profile. Is this possible?
Stripped Zoho Form?
Hello folks, I was wondering if there was any way to get the Zoho forms stripped to embed into the website like a normal php form input box. The current form includes too much padding with the iframe and I would like to simply include the input box which will take in email addresses and direct the user to a landing page / send email upon completion. The form is currently working to expectation, but I'd just like to have the form simplified to input box and submit button following it ONLY. I
Deleting Users
I want to do some clean up. Will deleting users have any effect or anything?
Date Function eomonth Problem
Good day the following date function eomonth(<start_date>,<nmonth>) is not working on February months that ends on day 28, it only works on February months that ends on day 29.
getting subforms to work
Hi I am having massive issues with Zoho creator subforms. unfortunaltly the how to guides are out of data and unusable. If I can't get the basic fuctiality to work I will cancel the system and go back to Excel!! Can anyone explian to me how I can get a total of values in a subform I.e if my users enter data and it will auto calculate the total. Cheers Dan
Submission Failure with forms Zoho Creator
Hello: We have a form that has been created for people to submit requests for equipment to be delivered to the department they work in. This form has worked well for the past several years but lately we are finding that once employees fill it out and hit submit they get an error message that the form is not correctly filled out. However, the form is submitted to us. In the end users are submitting multiple forms for the same thing because they continue to make fixes and resubmit, Any ideas? Thanks
Record Summary Report - hide empty fields
My record summary shows all fields from my form. Is there a way to hide or not show fields that have no results or are empty? To clarify, my report shows limited columns in order to show the most important info in my list view. Then I can "view record" to see all the info for that record. In this view which is the "record summary", I do not want to show fields that were left blank. Is this possible? Thanks for help!
Google drive
hello, do you hve an example to work with Gdrive in ZCREATOR. the idea will be : My user add an attachment in ZCREATOR, i take this attachment and i send it in a folder of GDrive. Is it possible ? thanks you
5,000 Deluge-statement limit - complete picture please?
I am trying to learn the complete picture about the 5,000 Deluge-statement limit. We realize that scripts should normally NOT come near this number of statements. And that good code optimization will reduce the number of statements. And that the limit can be increased by Zoho, on a case-by-case basis. Our reasons to better understand this is (1) good optimization for all scripts, (2) to be a good Zoho tenant, and (3) the potential occasional need to loop through more than 5,000 records. Could someone
File Storage - Pooled or individual?
I have a Zoho Creator account, Professional Edition, with 5 paid users, I should get 1GB / user for File storage = 5 GB total for our organization. If I do all of the file uploads for my account (no one else does file uploads), am I able to use all of the 5Gb myself, or is it tracked individually?
Request: Optional user-friendly limiter for length of content in multi-line fields?
Since the actual *size of content* of multi-line fields has an affect on the limits for the entire form, please consider offering, as an option, a user-friendly way to enforce a maximum via the UI. For most multi-line fields, we don't need 64K, and for form and DB management would like to limit to something much smaller, in a user-friendly way. For example: Admin defines a multi-line field, and accepts option to "Limit Size" and sets it as 2,000 characters. In the UI, while the user is entering their
How do I post a specific dance class selection to it's classroom roster sheet.
Hi All, I'm very new to Zoho. I have set a up a few applications that allow me to view customer registrations coming in on our website. We are a dance school offering many many different classes at different times of the day. I want to take the information coming in from our online reg form and place it in several records. I am chiefly concerned now with setting up roll sheets or roster sheets on a per class basis so we can monitor enrollment and attendance in each class. Ideally that same record
Get NUMBER (not string) from Zoho CRM
I am trying to get current numerical and currency values from Zoho CRM to be used in mathematical functions. Everything I try seems to return a string rather than a number. Specifics: When new record is created in Creator, match record by Email field and look up existing values in the CRM record. Then add the values from the new Creator record with values from the existing CRM record. Finally, update the CRM record with the total.
Big demand for working example of ZCreator <-> ZBooks API!
Is it possible for you to make available a working example of a API integration from ZCreator to ZBooks? - One .ds file with a working example of posting transactions from ZCreator to ZBooks, and - One .ds file with a working example of getting transactions from ZBooks to ZCreator. We are many, many users which will have great use and help in this!
Changing currency automatically
I have two fields - one is a radio button that shows US $, Japanese Yen, and Swiss Francs. Based on the user choice in that field, I would like the next field, which is a currency field, to use the currency that was chosen in the radio button field. Is this possible, and if so, how would I accomplish it? Thanks! David
Incorporate Multi-Select Option into Calendar
I'm trying to incorporate a time-off feature into an app, and I'd like to allow an employee's days off (selected via a multiselect menu on the employee record) to be reflected on a calendar view report alongside any vacation time they've entered. Is there any way to do this?
Select All and Add Values of Lookup Field in Subform
I'm working on creating a class registration application that has three main components: -A "Curriculum" component that allows us to define programs that can be used across groups (think a class) -A "Groups" component that allows us to create meetings that may or may not involve a particular curriculum (think a section of a class) -An "Add-Ons" component where we can define materials for a given curriculum (i.e., a workbook), and then when creating a group we can define whether the add-on(s) are
Creator Pubished Public Forms Time Out
All of our published public forms no longer work. They are timming out in Internet Explorer, Firefox and Chrome. We have 2 different published forms and neither of them can be accessed. Anyone else having this issue? What is going on? We have not enabled the new " Login changed for private embedded components in Pages" update . Here are two forms with the problem: https://creator.zohopublic.com/precisionsailloft/prod/form-perma/Website_Product_Quote_Form/5HDCVB7eJtSA8Ddj7qTbZSUKM7P80H5ydOhPUFANbsSby2ahOrsTYEef4KRXnQJRyPY2zyzyn5Rqrer0Qbfgf3wAsUM0TT98AwN6
String with angle brackets
I'm trying to set a string variable to "<Test", however I get an empty string back. Tried "\<Test" and results in "\". Tried "<<Test" which results in "<". Any help with this would be greatly appreciated. Oliver
Sub form data not sending in mail
if i add sub form data in mail but first row of the sub form only send in mail remain row are not displayed sub form Code - deluge mode "<br />\n<br />\nGiven Name - " + Passport_Details.Given_Name + "<br />\nSurname - " + Passport_Details.Surname + "<br />\nPassport No. - " + Passport_Details.Passport_No + "<br />"As Rich text mode Given Name - <%=Passport_Details.Given_Name%> Surname - <%=Passport_Details.Surname%> Passport No. - <%=Passport_Details.Passport_No%>
Question about the customer portal feature: individual user based content?
Can the new customer portal in Zoho creator allow each user to see data unique to him after logging in? For example, can I make a custom quoting application where the user will only see his own quote? (also this needs to be done automatically - if a quote is created for a specific user, he and only he should be able to see it after logging in. Manual permission adjustment for each user would be way too much work) Also can it allow him to update his contact information (Zoho CRM integration)? Thanks.
Lookup and Forumla Fields Not Working!
Hi, When I use some(not all) of the lookup fields in the form: https://creator.zoho.com/crocked/embryo-web-app/#Form:Recoveries whether or not they call "On user input" the processing icon shows constantly. Similarly when update any Number field whether or not it's calling "On user input" is showing processing icons and not updating formula field. I have logged a support request and enabled edit access. Damien Cregan
Bulk insert via the RESTful API
Is there anyway (or what are the best alternatives) to inserting multiple records at once through the Creator API? I need to insert 300+ records at once and I'm currently posting for each individual record which takes 1 - 2 minutes.
Help on linking data from two forms
Hi again I am trying to create an application but I have a problem. I have a form named Documents The Fields in this form are DocumentDescription, DocumentType, DocumentStatus, DocumentClass I have also another form named companies The fields in this form are CompanyName, CompanyType, CompanyStatus, CompanyClass What I would like to do is the following: In another form or view, when I select a company I want to have a list of the matching documents That means when I select the Company XXXX ( with
Error in executing Send Mail task: TO address is NULL
Hi all I have coded 'input.emailaddress' under the TO address using the Send Mail task in Form - On Success. The Send Mail task works perfectly fine from Creator Zoho itself. I have embedded the form in a website, but it returns 'Error in executing Send Mail task: TO address in NULL' when I submit the form from the website. Please assist asap. This is an emergency. Thank you.
Error: We are unable to fetch this data, sorry!
I am trying to log into Zoho creator and I keep on getting this error. How can i get this resolved? Thanks
Default image size in Email
I want to send an email with images from a URL box, and I want to define a size, example 141 x 141 What is the code that allows me to have a specific size? I have tried normal html codes but not funcionana or get error: http://mx.tuhistory.com/files/escapebacteria.jpg" width="141" alt="" />
A way to identify browser a user is currently using?
Hello, Is there a way to identify what kind of browser a user is currently using to access an apps via a deluge script or built in variable? Appreciate your help. Cheers!
Changing Account Owner
I have created an application with Zoho Creator at the company that I currently work for. I will be leaving the company and need to assign the application to a new owner/admin. Can someone please point me in the right direction as I have been unable to find any information online to help me out.
Basics of Deluge
Hi, I'm getting into the basics of using Deluge. I know php and mysql and could build it from scratch but I like the Zoho Creator framework a lot and want to make it in this. First of all I want something very simple: I have a table (form) which is called Enrollment. Enrollment contains a field called EnrollmentStudentID, which is added to the form by dragging the Look up field in it and relating it to Students>StudentsID. In my Deluge scripting I have this code: enrolledIn = Enrollment[EnrollmentStudentID
Different logo in applications under the same Zoho Creator Account
Dear All, In the same Zoho Creator Account I created two different applications. I would like to ask you if there is any way to change the logo so each of these applications to have its own Logo. Now, both of these applications have the same logo. In other words, is it possible (under the same Zoho Creator Account) each application to have its own logo?
Expense Tracker?
Hi We have a team of 5 people working internationally. Everyone makes expenses using personal cash. Which we then reimburse. I would like if you can tell me how I can create an expense tracker? The features would be: A user enters his expense claim (date of expense, description, Amount claimed, upload of a receipt image/pdf file) After this an administrator will receive info this via email and then approve or reject it Your help is much appreciated Kind regards
Create page with linked info from multiple tables
Hi, I want to built this but I would like to know if it is possible in Zoho Creator: Let's say there are 3 tables: - Students (id, name, etc) - Courses (id, name, etc) - Enrollments (id, courseid, studentid, etc) On a detailed student page (coded by myself in my own layout i guess, not a report?) next to all the student details that are in the Students table itself I want to list the enrollments of this student. In sql i would just simply query 'select * from enrollments where studentid = x' and
Can be used java in ZOHO creator?
I wonder if you can use java script in ZOHO creator. Using java to create a pair of graphics and insert them into Zoho creator to use ZOHO variables.
Bug: filter look-up field when adding record
Hello, The filter on look-up field is not working as expected when a new record is added in the table used for the filter' criteria. Here is the scenario. I have a form "Users" that contains two look-up fields: "Company" and "Office". The User-Office and Office-Company relationships are one-to-many. On the "Users" form, I filter the "Office" field in such a way it displays only offices belonging to the company that have been selected. The issue arise when, starting from the "Users" form, I create
how to immediately send email with uploaded file from form?
hi! user fills form and upload file in form. after submission - form sends email. how to send in email uploaded via form file as attached file?
Drop down menu in zoho creator
I have an application created in zoho creator and the professional layout for the menus. To simplify the use and feel, is there a way to create drop downs menus? Example: Mouse over the Menu "Fruit" to select one of 3 submenus "bananas", "apples", oranges. Thank you Edith
Group Sorting Problem on Android
Hello, I'm having a problem that just popped up, everything had been working perfectly until now. All search functions seem to work fine when I go online but when I try to group sort the data on my phone it groups the data correctly but when I tap a row to bring up the details it takes me to a different record. My phone is a Moto X 2nd Gen but as mentioned I don't think it is a compatibility problem because it's been working great up until now. I have been able to sort the data even on multiple fields
Next Page