not abe to activate print option in creator
Hi, I followed the instruction as shown in the zoho help to execute the print option. However when i go to the live mode, I not able to view the same. This is a very important step in my app. Please help. Below the steps I followed I opened the page - > settings -> Header Option -> Clicked on PDF option - > Done button - > Save Script - > Live Mode - page downloads but not the print button. How to address this.
Dynamic url in pages
Hi, Good day to you! Based on the loginuserid, I want to open the dashboard page I have tried the below code which is not working. <% if(zoho.loginuserid == "vedavalli@itkeduserv.com"){ var="https://app.zohocreator.com/itkes/masaa#Manager_Dashboard"; } else{ var="https://app.zohocreator.com/itkes/masaa#Telecaller_Dashboard"; } %> <a href="%{var}">Click here to go to the dashboard</a> this var receiving value but it is not getting assigned in href.. Is the format right? Thanks ITKES
Trying add records via API and a PHP cURL function...getting permission denied error
Trying to add records via the API and PHP cURL, getting this error - {"errorlist":{"error":[{"message":"Permission Denied To Add Record(s).","code":2899}]}}. Please advise Here is my example code: Here is an html page with a form - <html> <head> <meta http-equiv="Content-Type" content="application/json"> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content="">
last 30 days search
When filtering for "last 30 days" or "last 7 days" anything with today's date is not included. Is there a way to create a filter that essentially says "today or last xx days"
Deluge script for maximum(added_time) functionality changed (timezone??)
Hello, In my form I have a script which until yesterday worked fine. But now it returns wrong data. It reads last record by added time. It returns time 9 hours back, it is really strange, because the seconds and minutes are OK, just the hours are 9 hours back, as if the code would work in different timezone? In below case, - l_last_day variable returns the wrong time. Please help!!! Code: l_akt = Visits[ID != 0 && Added_User = zoho.loginuser] sort by Added_Time desc; if(l_akt.maximum(Added_Time)
Problem trying to download using curl
Hello. I am trying to download a report result in CSV format using Zoho Creator's API using curl, but I keep getting "curl: (35) Unknown SSL protocol error in connection to creator.zoho.com:443" errors. The URL begins with "https://creator.zoho.com/api/csv/..." and works flawlessly if I try it from a browser. I have even tried adding " --cipher rsa_rc4_128_sha" as proposed here, with no success either. I am behind a Windows proxy. Could you please tell me the right way to do this? Thanks in advance.
How to Upload to Application from PHP
Hi everyone, i have been using Zoho Creator for a while now and it has been amazing, however i tried uploading to my application using Guzzle PHP library but i always get an error. Please any help would be very much appreciated. $zoho_url = "https://creator.zoho.eu/api/xml/fileupload/scope=creatorapi&authtoken=********************"; $client = new \GuzzleHttp\Client(['verify' => false ]); $client->request('POST', $zoho_url, array('Content-Type'=>'multipart/form-data'), array(), array(), [ 'form_params'
How can I add all records from a previous form into a multi-select field on a new form?
I'm building a simple app to manage a tutoring company (eventually all but payroll). I have Form A, where the user can add a new Content Area (such as Mathematics, Natural Sciences, etc.). I also have Form B, where the user can add a new Tutor. There is a "Qualifications" section on Form B where I want to have a Multi-Select (or a Checkbox) field where the user may select multiple Content Areas that the tutor is qualified to tutor. For this reason, I need all records from Form A to populate the choices
Bringing ZOHO Creator Apps to a Single "Dashboard"
Hello, New to the ZOHO community and appreciate any help. What I am trying to figure out is if it is possible to bring the individual apps that I create in Creator into a single interface in ZOHO? I hesitate to call it a dashboard because that term carries with it the connotation of KPI's. I'm not referring to KPI's here. So far, I have created a CONTACTS, TASKS and NOTES app in Creator. What I want to do is to embed those apps into a page where I can quickly go to those apps. It would even be nice
How do we publish an entire application and generate the URL for usage without Login
How do we publish an entire application and generate the URL for usage without Login the same way we are able to Publish and Generate the URL for Individual Forms.
How Can i Add a Desk Task via Creator?
Hello, i am working on a System that pushes Zoho Creator Data in Zoho Desk as Tickets and Tasks. The Tickets are genereated perfectly with zoho.support.create("Requests"...); -> This Works BUT i must add Tasks in the Tickets, too. For this i found: https://help.zoho.com/portal/kb/articles/addrecords-api-method https://desk.zoho.com/api/xml/MODULE/addrecords?authtoken=AUTHTOKEN&portal=PORTALNAME&department=DEPARTMENTNAME&xml=XMLDATA (the Bold text is filled with my values) My XML Data: <tasks><row
Zoho creator is very slow to load form and data entry
Halo Zoho Creator From yesterday 28 July 2017 12pm Jakarta time, until now 29 July 2017 2pm, we have been experiencing slow response time. It is very slow, very very slow to load form and to submit data entry. As a result, we cant do data entry for transactions and our customers are complaining as we cant deliver invoices 1. Are you able to confirm that this is a zoho worldwide issue and not just for us in Indonesia ? 2. If this is indeed a worldwide problem, what is the problem, and when are you
Decision field: summary
I'd like to see the summary of a decision field. For 100 rows for example, I wanted to see in a report: 59 FALSE 41 TRUE. Thanks. Can you add this feature to Reports of Zoho Creator?
How do I access individual elements of a multiline control?
I'd like to use a multiline (or a note) control to display an onscreen log of actions taken by a maintenance routine. Basically, I want the ability to programmatically push new values into the list, either at the top or the bottom with automatic scrolling. In other languages I'm used to accessing the content of such a control as a list or array, at which point I can use list functions like .add or .insert. How do I do this in Zoho? I can't find any relevant documentation as yet.
Receiving and storing email attachments in Creator
I am receiving email (GMail) by way of a Zapier Zap. These emails come with attachments. Is it possible to store these attachments in a standard form when the record is created? I don't see a form control type that will allow for this. Thanks Derek
Unable to attach photos on mobile embedded form
I have a mobile form embedded on a mobile website and in a mobile app and I am unable to attach photos. On Android when you click the "Choose File" button it does nothing. On iOS when you click the "Choose File" button it opens up the Camera/Gallery option but when you select one it just closes out of the form
Vacation Request on Youtube
I have been following this Vacation Request video carefully, but it does not show how the employee information form/Report gets its vacation Days data updated. All it does is check to see if you have time. If approved, how does it update the Number of Days Taken field, so that if I check, it was updated?
Zoho Creator new Version
Hi I am in need to send Zoho Pages as E-Mail .As far as i know i belive we need to re-code for that to happen which is time consuming. It looks like more new features are expected in Zoho Creator very soon.It would be good when we can get the details of that and in what way it ll reduce the coding work.. Please update.
Use CSS on embedded Forms/Views?
Hello, how can I override the Zoho CSS stylesheets on embedded forms and views? I need to update my UI and unfortunately the Zoho styling is a little outdated. I am tried to simply assign new CSS to specific Zoho classes in my html <head> but they aren't taking effect. I then did a "View Source" and copied the HTML/JS code into my own html page and was able to augment the CSS, but crucial Zoho functions stopped working. Please let me know what I can do here, really considering using a different tool
How to make each record that i am referencing a clickable link ?
How can I make each record that I am referencing a clickable link in report setting?
Update a record's field in Zoho CRM by using creator.
Hai Team, I have a issue in Zoho creator. if i update a record's field in Zoho creator automatically it should update in Zoho CRM. How to do that? Ex : In product module,if i change the unit price field in zoho creator.Automatically the same field in Zoho CRM have to get change for the same product. Hope will get a response back ASAP. Please send me the code. its very useful for us. Thanks in advance Abishek.
Possible to use same script for two subforms (that are identical)?
Hi, My current script is super long, I hope there's a way to make it shorter: I have a main form, with two subforms in it. The subforms are completely identical, it's just that I had to display them twice on the same form and Zoho would not let me add the same subform twice. I have a pretty long script that needs to be run for each subform on On Edit -> On Validate. is there a way I can use the same lines for both subforms? To make thing easy I'll elaborate a bit: The subforms have 3 fields: Date,
Quickbooks Online issue
Has anyone successfully connect to Quickbooks Online? I've setup a Connection but when I try to execute: searchResponse = intuit.quickbooks.searchRecords("Zoho", "{company ID}", "SELECT * FROM Customer where DisplayName='Insert Name Here'"); I receive a "401 unauthorized" error. I've checked the Company ID in Quickbooks online several times and it appears to be correct. Could this be due to using a Canadian Quickbooks database? Thanks!
Allow user to insert new single line text in a form?
I'm creating a simple application (contacts) but one requirement has me stumped. Seems like it should be easy but I'm not able to come up with the right search terms to find the answer. The requirement is to update an existing record with a brief note of when the contact was last met with and why. The note is simple freeform text (ex. "Spoke by phone.") and the date can be a timestamp or a date field. The date does need to be a distinct field because the user wants to be able to search by date
Printing Zoho Page with embedded Zoho Report - is this possible?
I have a Zoho Page with an embedded report. I turned on the header option to print the page. When I print the page, the report gets really tall and spans multiple pages. When you go back to the page the report also stays tall and starts scrolling within the element window. Is this proper behavior or is there some configuration that I'm missing. I see there is an embed as image in Zoho Reports. Do you need to use Zoho Reports to do this or is there a way to get an embedded report to print properly
Please specify a valid date value in application date format
Any time I try to save a workflow action got this message. Check on application date format and it was choosen from standard dropdown formats. No clue, please help
How to create statistics for each employee who add records through form?
Dear developers and colleagues! I am just one month zoho user. Even I have not yet discovered all the abilities of Creator I believe I can develop exactly what I want: simple and effective application. By now I am almost done, but there is one thing left which I never thought I could stuck at...a super primitive statistic report showing performance of each employee who added records in certain date range, e.g. Today, Current month, Last Month, Total. Showing the count of both, total records added
Go back to dashboard in mobile app
Is there any script or way to close a form after successfully submit a record and go back to the dashboard (screen showing all forms/reports etc in my app) in the mobile app? My employees use the mobile app with QRcode capture in our main form. This form displays the camera screen (before displaying the form) and never closes after capturing the QRcode. I need my users to go back to the dashboard after every QR is captured &recorded so they are able to open other forms (which is not always the
Problem with search form code
Hi I'm new in programming and really need help with my code that I modified from tutorial link here: https://www.zoho.eu/creator/help/application/search-interface.html What I need to have in my application is search interface where I can find records by user input and show them on page. I modify code form tutorial to my app where all data are stored in Item_register and I want to looking for records that have same value as input in fields Model_Name, EAN_CODE_Value and Item_category. Problem:
Access Image from API
Hi, is it possible to access a image with an authtoken It is not a good solution to save the complete HTML tag into a database. Why was this done? I am currently getting the picture url with regex but unfortunately, i can not access the picture because I have to log in. Is there a way to get the picture with an auth token? Thanks Daniel
Fetch XML response from Zoho Creator rest api
Hi, I'm having trouble figuring out how to use their rest api. I read their document but the explanation was not clear enough for a beginner like me. Can someone give me a simple example of how to use it? I really appreciate any help you can provide.
Import data problem
I'm having problems importing data. The import file was exported from a Zoho Creator App and now I'm trying to import it into a copy of the same Application. I'm going to use the copy of the App for development. I'm trying to populate the forms in the copied application with the same data in the original application to get a realistic development environment. The import works fine on most of the forms/tables, however I'm getting strange non-descriptive errors on a few of the forms. It seems the
Summing fields in a subform
Hello. I'm relatively new to Creator and Deluge and I'm hoping someone might be able to help me solve an issue I'm having with a Creator app I'm building. In this app, I have a mainform and a subform. Each row of the subform has a "Total" field which I have managed to automatically calculate. What I am trying to do, however, is sum up the amounts in every row's "Total" field, and display that in a field on the main form. My early attempts at scripting this resulted in various form execution errors,
Finding and editing records of a form using another stateless form
Hello, I have two forms in my application. One has data (Form A) while another is a stateless form (Form B). Form A (the form with data) has various fields and one of those fields is a unique ID field (Ticket ID - put in by me). Here's what I want to accomplish via the stateless form: The stateless form records data entry in a single single-line field I want to use this data just entered to search the Ticket ID field of Form A If there is a match in the Ticket ID field of Form A then I want to modify
Open an specific form when mobile app is launched
Is there any way to automatically open an specific form when the mobile app is launched?
Accessing and editing records from another form
Hello, I have two forms in my application. One has data (Form A) while another is a stateless form (Form A Check In). Form A (the form with data) has various fields and one of those fields is a unique ID field (Ticket ID - put in by me). Here's what I want to accomplish via the stateless form: The stateless form records data entry via barcode or manual entry I want to use this data just entered to search the Ticket ID field of Form A If there is a match in the Ticket ID field of Form A then I want
URL criteria syntax
Hi, I'm trying to open a report based on a set of criteria. The criteria are: The BkCourse_ID field is the same as the one entered on my stateless form that I'm invoking the report from. The Booking_Status field is not like "Cancelled" The Booking_Status field is not like "Exchanged out" I can successfully open the report with the first two criteria as the filter, but I'm struggling to come up with how to add the 3rd to the URL coding. Here's what I have so far: rec = Courses_Setup [ID = input.Course];
I wanna create an application that can search and view the CRM i have.
I wanna create an application that can search and view the CRM i have. I need a professional guide how to do it. to where i can fetch the record i want to be viewed with, fast searching for the information inside the CRM, and possibly published to either Google Play and/or iStore
logging in using userid instead of email/phone
Hi, I understand that when the zoho account is created - a userid is created eg bkmaithili I am able to login using email or user id But today i have created a new zoho account - but am not able to login using the user id.. It throws an error asking for email/phone number My query is that 1.how to login using the user id? 2. can we create our own user id... the application will be used by few people - are we dont want to have a login based on email id - just a generic userid - eg Appuser1
Auto fill form field with the same value as the last submitted record
How do I fetch a value from the last submitted record so I can set that value as the default value on loading the form?
Next Page