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
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%>
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.
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
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?
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
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
LookUp Dynamic Filter
Good day for you, I have a Subform with 2 Lookups, I set a filter for the second Lookup based on the first lookup selection, I script that when the user add a row the first lookup take a value for the parent form, the problem is that in this scenario the second lookup filter doesn't work. This filter only works if the user select manually the value in the first lookup. Is there a way to set filters for this second lookup thru deluge? Best Regards,
passing parameter to HTML View in Search Field
Hi, I have a HTML View and I am using a OpenUrl task to reload the parent window after on Success action of another Popup window . What I am having trouble I would like to retain the search keyword in the search field which is applied before reloading the page. See below screenshot for your convenience ... Screenshot 01 : Here you can see there are Two search result before on Success action of another form. Screenshot 02 : After adding new entry of another form the above search result will contain
Problem with adding Number field
Hi, I cant add to the form i created (by Zoho creator) "number fields". The message i got is "adding..." and nothing really happen, its stuck without doing anything. Can you please check the issue ? Thanks, Cory R
action for printing
Hi, I am working on a simple app that manages warehouse. The user should input some data about a pallet and getting a printed label with these data on it. Printing will be done on a common local laser printer. I suppose I shoul use record summary to generate the label. I would like the printing process starts automatically after data insertion, any idea about this? Thank you
Problems Duplicating applications
Hi I have seen a few threads regarding this, but no solution. I am trying to duplicate applications in my Zoho Creator account. Zoho Creator indicates that an application is being duplicated, and when the process ends, no copy of the applicaion is found. Please assist. Tal
forcing a UI refresh (Form and Field events) from a function triggered in a view
We've got Zapier integration nicely adding new records into our app. However, when the records are added, the UI functions are not evaluated, and as such some of the values we compute during a normal On Add event are not completed. We could always duplicate the calculations into a Function. Instead, is there a method to trigger the UI events against a collection of records using a Function triggered from a view? Thanks in advance
No split function in string methods?
Hello, i would like to have a confirm that there is no split function in string methods in Deluge. I have written a custom function that use getUrl function to get data from an external service, the response can be very long (each value on a different row) and it would be really useful to have the capability to split the response string in an arryay for each single row.
Lookup fields that can lookup each other.
I have two lookup fields on FORM1 pulling information from FORM2. I would like it if these fields could lookup each other. Example1: If a customer service representative knows the customer number and selects the number from the Customer_Number field on FORM1 then On User Input would pre populate with the information from FORM2 into the Customer_Name field on FORM1. Example2: If a customer service representative knows the customer name and selects the name from the Customer_Name field on FORM1 then
Emailing a record from within Zoho CRM
Hello, So I have created my app in Zoho Creator and connected it to Zoho CRM. I was wondering if there is the ability to email a record to a contact from within Zoho CRM. Thanks!
DB Structure / Multiple Lookups Question
Hey there, I'm trying to build an order management system and I'm a little new at this. Here's what I'm trying to figure out: Each item we can order comes in multiple sizes Each size for a given item has its own pricing Pricing is based on the quantity in an order, with different combinations of item + size having different quantity breaks As an example, say we could order Flour in a 20lb bag or a 50lb bag. The 20lb bags are $10 each if you order 1, $9 each if you order 3, $8 each if you order
String
I need to accept a string of 8 characters and in the On User Input field action I want to add code to simply put a dash between the 4th and 5th characters. In other words, if the string is entered or imported as ABCDEFGH then I want to convert the string in field to ABCD-EFGH. Here's the code I added to the On User Input field action for a field named Course. s1 = input.Course.subString(0,3); s2 = input.Course.subString(4,7); input.Course = s1 + "-" + s2; This code does not work at all. The code
Zoho Date Discrepancy
Hi, On a lookup field referring to the Added-Time of a record, I noticed that when I set the filter to only show records from Today (Zoho creator: Added Time) it will show up correctly on my computer but on my mobile app on Android it will filter dates from yesterday instead. Both are logged in using the same zoho account and the system times are both correct and same. Any ideas as to what is going on? Thanks.
Access Denied!!all My data has disappeared
i am unable to login into my account. It says access denied. I had stored 1000s of records in my application. It is all gone. When i contacted the support team through email. They they are working on it. It has been over a week and they are still working on it. I had shared the application with colleague. He is also unable to access the application. This is a very serious matter for my organization. This has been a big disappointment.
Checking for unwanted characters in text input
I'm surprised I can't find an answer to this one. It MUST be possible! I have a text input field called IDname1 I want people to create a username in this field. However, for various reasons I need to make sure that certain characters aren't used in this username, including # and & and @. I've tried all sorts of variations of if statements using .contains and .getOccurenceCount but I just can't get anything to work. Can anybody help??
Zoho CRM Lookup field not working in Chrome, works in Firefox
Steps to reproduce: Add a Zoho CRM field to a form in Creator (for Account or Contact) Access the Creator App in Chrome Attempt to lookup an Account or Contact using a Zoho CRM Lookup field Pop-up window of Accounts or Contacts appears Click on Account Name or Contact Name to select Expected result: Account Name or Contact Name populates Lookup field Actual result: Nothing happens and Pop-up window does not dismiss This does not work in Chrome on my Chromebook, Chromebox and Windows 8 Chrome. Current
printing from iOs or Android
Hi, any idea about printing directly from iOS or Android App?
Android app - Force Close
I've installed the native android app on two Motorola phones (Droid X - 2.3.4 and Droid X2 - 2.3.5). Both apps force close on startup. I get the login screen, after entering my gapps name and password, the app crashes. I've reinstalled several times with the same result. Any help appreciated. Thanks, Joe
How to expand / collapse fields in forms
I am creating a form where if I click on check box, certain fields on the form get visible. I have seen on certain apps on marketplace. Not sure how can this be done? Any help would be appreciated
Inserted record formulas not calculated initially after insert.
Hello, We have several functions that insert records into a form. The form that the record is inserted into has many formulas fields in it. After inserting a record none of these formulas initially have calculated as expected. When viewing the record in an html view the formula fields are null. When I edit the record and change one of the values that the formula in calculating based on, the formula recalculates to display the proper value. How can i get these formula fields to calculate properly
Purpose of PreSubmit?
Just wondering: What is the purpose of the PreSubmit code added to the form definition for some forms? Thanks! :-)
Next Page