Calendar from date field is not displayed completely on phone screen
Hi Everyone, I made the Visitor Sign-In form as described in the "Creating an Application" video from the Zoholics videos and ran the form on my Samsung Galaxy S7. The form displays correctly but if I tap the date field, only half of the calendar is displayed on the phone screen. What do I need to do to centre it on the phone screen? Thanks. Truly, Emad
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"
Changing Messages from ZOHO
How can I modify the "Data Updated Successfully" and "Please Wait". I have a slow DSL connection, and when I change the information in the database, the messages cover a large amount of the data and I am forced to wait until they disappear before continuing. I know I must wait until the change is actually made, but if I could see the data while it is being changed, I can be planning what to do next. I looked on the Internet with this question and your site says to open DASHBOARD and then FORM PROPERTIES.
How to add print button in creator
Hi, I am new to the creator. I am working on a form to print a copy of the same when I use the Print Button and also create a copy of the form in my system in some assigned storage place. I changed the name of Submit button to Print. Now when I am trying to add a rule or edit this button to perform print action, I am not finding any options here. Please help.
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 do i export my Zoho calendar to my Google calendar
How do i export my Zoho calendar to my Google calendar? I found sync but that only brings in my google calendar to zoho. I need it to go the other way.
Field for hours and minutes
Hi. How to best create a field for Hours and Minutes? I want to have a field where I can input how many hours and minutes was used, then create a report that summarize the total time spent. Format for the field should be HH:MM Best would also be if I could write it in format HHMM and then the app auto insert the : between. Any one that can help?
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
Can I not add multiple formula fields to another block
Hi, I have used formula field and calculated a percentage. I have used the output of this field to calculate one more percentage. Now I want to add all these into another field - obviously a formula field. However, in the refer fields block these fields are not visible. Ex: formula field 1 = ((9/100)*CTC) Formula field 2 = ((5/100)*formula field1) Formula field 3 = sum of (formula field 1 + formula field 2) - however I am not able to view these options under refer field in the formula field pop
Master Zoho Creator @ Zoholics Developers '17
This August, Zoho is hosting its annual app development conference, Zoholics Developers. This event is a three-day workshop designed specifically for anyone who wants to learn about, build, and improve their skills with Zoho Creator. We'll lead interactive workshop sessions where you can refine your skills, one-on-one sessions where you can chat with an expert, and showcase Creator's new features. You should come if: you want to learn more about building custom applications with Zoho Creator. Whether
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
Creating Custom Action Button
Hi Zoho Community, I'm trying to create a custom action button called "View Record" that does nothing more complicated than open a view of the particular record - exactly what you see when you click "edit" to that record. I am trying to follow this tutorial but I'm having a hard time understanding what needs to be done different to "view attendance" instead of "add attendance." Any help on either count would be greatly appreciate. Thanks!
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
Enable and disable the “Enable Payment” checkbox in the “Payment” form settings from within Deluge
Hi, Can I enable and disable the “Enable Payment” checkbox in the “Payment” form settings from within Deluge? I need to do this so I don’t need to create duplicate forms with the only difference being to accept PayPal payments vs payments by cheques. Thanks. Truly, Emad
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
Show Link Name instead of Title when viewing a lists of Forms, Reports, and Pages
Is there a way to show the Link Name instead of the Title when viewing a list of Forms, Reports and Pages in development mode? As my application grows, I am naming forms with a similar prefix to keep modules together. For example, forms that have to do with user management are named usrUser and usrCompany. I want to be able to look them up by these names when doing development, but I want my customers to see User and Company. What approach are you using to keep track of related Forms, Reports, and
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
I need the deluge help document offline pdf version.
I need the deluge help document offline pdf version. I have a download link but it doesn't work ( http://static.zoho.com/creator/explore/delugescript_helpdoc.pdf ).
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?
"Set Filter" for lookup fields inconsistent implementation on web v's mobile app
Hi, When using the "Set Filter" option on a lookup field in the mobile app it will update the lookup when I update a dependent field via deluge. In the web browser this is not the case, filters will only get invoked when a dependent field is updated manually. Effectively I now cannot use the "Set Filter" option. Damien Cregan Hire an Expert
Can the new (2016) UI be implemented for old accounts?
Hi everyone, I have the old (pre-2016) interface on my account. Is there a way to enable the new UI for old (pre-2016) accounts or am I stuck with the current interface? I can't seem to find any button or link that enables it.
criteria report last record
hi I would like to give as criteria in my report the following : [last_record_added = STOCK [(CLIENT== input.CLIENT && SUPERMARKET == input.SUPERMARKET)] sort by Added_Time desc; (last_record_added.TOTALBILL> 0.0)] is it possible to have this level of criteria in the report? How could I filter my report that way thank you
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.
Help me create line chart
Hi. This is my database I want to make a chart like this to print out the process for each customer I have set the columns like this but nothing happened ! Pls help me. Thanks
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,
SMS Twilio
How to use form field as part of text message, I am able send text message successfully, but I need the License_Expire_Date field as part of text. when use this script below the message does not go through, but replace the License_Expire_Date with sample text message it does work. Thankful for any help. This works var = input.Phone_Number.toString(); var1 = "+1" + var; //info var1; resp = twilio.sms.send("Driverlync",var1,"DL EXPIRED"); info resp
How can I set up auto refreshing time for other users in their views ?
I check forums but did not find browser auto refreshing time for added or changed data by forms. If a user submitted a form when other user can see this data in his view ?
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!
Next Page