Disable Field not working from a Report
I am trying to disable certain fields from being edited, but when I access the record via the Edit button on a List Report, the disable function is not applied ? Any thoughts for each REC in Access [User_ID == zoho.loginuser] { alert("Level : " + REC.Access_Level); if (REC.Access_Level.toLong() < 5) { disable Site_Name; disable Seaware_Code; disable Seaware_Detail; disable Floor; disable Location; } }
mCreator and geolocation (geofence) feature
Hello, I am wondering what the geofence restriction feature in mCreator uses to capture a potential submitter's location when determining if they are within a geofence or outside of the geofence. I would like to use a query to the mobile device's GPS software stack instead of using the IP address of the submitter when determining what their location is. This is a feature found in a few other mobile form building software platforms that I find lacking in ZoHo Creator. Having this feature would allow
How to separate output data
Hi, I need help to provide me simple script to get the input data from a source "single line" data and output separate into two different "single line" Example : input data = '"2015-04-29 18:00:00" Target A = "2015-04-29" Target B = "18:00" Please refer to the photo attached.
Error inserting a record-Reference Field field_name not having the value 0.
I'm inserting a record with a function. I'm getting the error Reference Field Field_name not having the value 0. Field_Name is a lookup field but it is not required. The funny thing is I still get the error if the field is not referenced in the insert section. I also get the error if the field is in the insert section with a valid value.
Custom Actions: Work OK in stand alone report - Fail when embedded in HTML page
I have never had this problem (see details below) before and have been running the apps in question for years. Has something changed on the Zoho end? Do I need to add new parameters? Within an HTML view I have a report named "SessionsNotYetBilledADMIN". The code for that part of the page is below. <td><div elname="zc-component" viewlinkname="SessionsNotYetBilledADMIN" params="zc_Header=true"><br /> </div></td> If I load the report outside of the HTML page, the Custom Actions work fine. Within
Recurring Tasks OR Events
Request your help. In one of the applications: we are trying to create a recurring Task feature. So the user can specify the Start Date, End Date and Frequency (i.e. Daily, Weekly, Monthly, Quarterly, Yearly). And the system will automatically create those many tasks with different Due Dates. (Quite similar to the way Zoho CRM functions). Is there any Sample Application that I can refer? Thanks: Arnab
Zoho Creator connection to an Azure SQL Database
I have a Microsoft Azure hosted SQL Database. How do I connect to it from Zoho Creator by mapping Creator forms with tables in the SQL Database? Thanks.
Integrate Asterisk
Is it any way to integrate Asterisk with Zoho Creator?
Pivot Table refresh/re-generate
Hello, My pivot tables in Zoho Creator are not automatically refreshed with new data unless I go in and Regenerate. It used to be about 10 minutes at most to refresh for new data. Has anyone experienced the same issue? Thanks AA
Display form records into a Page
Hello, I need to create a page that displays the data from three forms based on an option selected from a list, for example: Let's say I have 3 forms: - One named "employee" that has 4 fields: ID, name, phone, extension. - A second form named "department" that has 3 fields: lookupID1 (is a lookup field from the employee form), role, officeNumber. - And a third form named "payment" with 3 fields: lookupID2 (is a lookup field from the employee form), salary, payDay. I need to create a page with this
Add column to list with a calculated value
Hi, Is it possible to add a column to a list, which contains a calculated value ? For example > the value is the amount of records that occur in another table with a given value. Thanks! Peter
Add header rows to report
Hi, I'm evaluating Zoho Creator. I need to create a tabular report with about 300 columns that is exported using a TSV format. This is then input into another system. I have been able to create a report with the necessary columns, and can export that as a TSV file. So far so good. However, I also need to add two header rows at the top of the report. These would be immediately above the row with the column names. In these header rows I need to put some required data for the system that will process
Send mail function not working
I have my form sending emails to the Purchasers when the Employee submits further comments/questions. I would like it to also send another email to the people CC-ed on this request if possible. The Purchasers are receiving their emails without any issues, however the CC-ed people are not. Not sure what is wrong with my coding here: //If staff member sends comments/questions about an existing Request to Create new SKU, there is a CC but no CC1 if ((((input.Comments_Questions_to_Purchaser_Assistant
keep getting "Improper Statement" errors
I've spent hours trying to do a simple IF statement and I keep getting errors. I'm on the trial version and attempting to setup a quick demo for a customer so that they can decide if Zoho works for them. It's a simple Commission tracking application. There are Sales Reps, Expense Categories, Customers and Invoices. On the Invoice, there are multiple Expenses (subform). Based on the Expense Category of the Expense, I need to pull in the Rate_Type and calculate the amount of the expense. It seems
Insert Crm "Contacts" into Zoho Creator Form
Hi, I am using below script to insert Contacts from CRM into Zoho Creator form, it is working correctly except not inserting Zoho CRM Contact Name link . Please see below screenshot contactlist = zoho.crm.getRecords("Contacts"); for each contDet in contactlist { insert into ContactForm [ Zoho_CRM_Contact_Name_ID = contDet.get("Zoho_CRM_Contact_Name_ID") Email = contDet.get("Email") company = contDet.get("Company") ] } Form : Output of Script: What I am expecting from insert Task is like below Could
Print HTML Page in Portal
I have an HTML page that I want portal users to be able to print. What is the functional URL for printing an HTML page in the portal? I tried "https://soundcyclists.zohocreator.com/portal/<appname>/print/Sign_In_Sheet_HTML/ride_ID=" + ID_string where ride_ID is a paramter, but that's not recognizing that I'm in the portal Thanks
Building a dashboard
Hello, Can anyone help me. I'm building a dashboard with 3 reports. Now I would like one search field which works on all the 3 reports. How can I do this? I'm thinking about a blank form with a look-up field. Hope to hear from someone soon. Greatings, Erwin
In Record Summary view - Sub form data problem
Please see below image .It is record summary view. In this view three column - City , Hotel , Check IN. all are sub form data. I want output like this City Hotel Check IN Bangkok Bangkok Palace 2015-02-11 Pattaya Bella Express 2015-02-16 But i m getting output like this Code Package Details City Hotel Check In ${HOTEL_Rates.City} ${HOTEL_Rates.HOTEL} ${HOTEL_Rates.Check_IN}
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
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.
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
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
Next Page