Organize app menu by dragging menu items in live mode
Hello, Is't possible to allow to Administration users to change menuitems order by dragging them in Live mode (in same Section or move to another Section) - now it's very slow to do (in my App - I have 24 Sections and 476 Menu items - so it's a big job to reorganize it - and also you need always to switch to live mode or refresh page to take a best position of item)
Create a Report with Criteria calling a function
Is possible creat a View, in creator, with a criteria calling a function? Like: branch==thisapp.return_branch(zoho.loginuserid) See the attached image
Printing Mailing Labels (Mail Merge / Export Data / SQL Query??)
Hi friends, I'm trying to create a database to replace an existing excel worksheet. One of the requirements is that we can print labels that contain various pieces of information about each record. They are not simply name / address, but I suppose that's as good a place to start as any. We currently update the information in an Excel spreadsheet, do some concatenation and formatting in another sheet, and then do a mail merge in MS Word against that sheet using an SQL query through MS Query. When
consecultive date entry in subform
dear all, I created a sub-form for people to input their working/education experience. Since it is required to have a consecutive date record, so we have to make sure the "start date" in the next entry are one day after the "end date" in previous entry. for example. the "end date" in first record is 20/01/2001, then the "start date" in second record must be 21/01/2001. I am not sure if in zoho can do coding on it and realize it. If anyone can shed some lights that would be much appreciated thanks
Reports disappeared from Creator iPhone app
Very strange the other day when loading up the ZC app to discover that all but the form and one report had vanished from the app menu. They're all there when logging on to the web version and am wondering if anyone else has encountered this problem or has an answer to the problem?!
Move records from one form to another
Hi Is it possible to move entire records from one form to another? Or is it possible to archive entire records with the ability to look back over them? Many thanks Tom
eomonth function not working properly
Dear ZOHO , while using Date-Time functions in zoho creator I noticed that the eomonth() function is not working properly. It returns wrong values for dates in February. If February has 29 days eomonth(<date_in_february>,0).toString() returns “YEAR.03.02” / 2 nd of March and if February has 28 days eomonth(<date_in_february>,0).toString() returns “YEAR.03.03” / 3 rd of March. Best Regards Michael
Has anyone elses creator program stopped working?
As of today, Our creator pricing tool has stopped working correctly. In every instance it gives the error below, even though we have made no changes to it since it was working. Anyone else having an issue with this?
How to calculate difference date?
Hello İ have form A And i have form B İ want in form B a field to calculate Added time form B - Added Time A (or current time) İ tried to this with formula but there is a error whic says one field is string the other float Thanks for help
Filemaker migration crashing
Hello, I am testing a migration and come up with this error. I have deleted all calculation fields in the export file.
iframe transparency - white lines
I'm using an iframe for the first time since the parameters were changed to be saved in Zoho rather than specified in the iframe. Ive added the same '=transparent' code I had previously but I'm ending up with a thin white line below the text for each field (see URL). Also when a lookup field is used (dropdown) it appears as transparent rather than white making it unreadable. In my page after the code provided by Zoho I added "/zc_BgClr=transparent&zc_FtrClr=transparent&zc_HdrClr=transparent&zc_BdrClr=transparent'>"
Problem displaying embedding form in WordPress (only in IE)
Hello, I have a Zoho Creator form embedded in http://rateyourride.org/rate-your-ride/ . The form displays fine in Firefox or Chrome. However, it does not display in IE 10. I get a blank white iframe. Thanks.
Calculated date field
I am trying to add a calculated formula field to achieve the number of days between two dates. I can get the number of days but my answer has two decimal places and I dont want any. Can anyone help? I am finding the calculated formulas very difficult to understand and the "help" pages seem to require a certain amount of prior knowledge on the subject to begin with which i just don't have!
Is there a premium support option for Zoho Creator?
The long, multi-day delays to get a support response via email just won't cut it for my particular needs. Is there a premium support option available to purchase that will get faster results for support? I really want to go full-bore with Zoho, but the support time-frames make me very hesitant. I don't mind paying for better support and a higher SLA, I just have to have it.
Report
Hello, I have a "workshop" report that shows data from my "workshop" form. I also have customer field in my "workshop" form, that data populates from a "customer" form. I would like my workshop report to produce all my workshop data, and have two fields from the selected customer displayed i.e. Customer Name and Email Address. However I would like these to be listed as two separate columns on the report. I am sorry if I haven't explained this very clearly, please ask for more information, but
Anybody notice issues overnight?
Has anyone else noticed any changes overnight? I have a sendmail function that is no longer working correctly along with some calculated fields and reports.
How to enable registered visitors on membership site to automatically access embedded ZOHO Creator report
Hi, I have a Wordpress based membership site with restricted access to many pages. One of these pages accesses a ZOHO Creator report. When I set up a "published" report, the only options are to view and print a selected record. However, I wish to enable my registered users to access an "embedded" report where they also have the ability to edit and delete records. Is there a simple way to automate the process of logging in to the ZOHO Creator database so that my site visitors don't need to go through
Why does my app kick me out to my ipad when I try and access my form?
I downloaded the Zoho creator App to my ipad. I can sign in and my apps(Form) is present but when I try and access my form to fill out, it kicks me out of the App completely to my ipad home page. I am not sure that I published it correctly.
How to rename pdf?
Hi all, I have a formula to download an html view as a .pdf file. When it downloads, the filename is beo.pdf (my page is called BEO). Is there anyway I can name the file with some fields from the view (ie mmddyy_title_beo.pdf or similar?) I'm attaching the function for reference in case it might help somebody else at some point. void BEO.LoadBEOpdf(Events ThisEvent) { openUrl("https://creatorexport.zoho.com/jeffzearfoss/catering/pdf/BEO1?ID=" + ThisEvent.ID, "new window"); }
Can MS Access 2013 Custom Web Apps Use ZOHO Creator
The "Custom Web App" Template in MS Access 2013 is designed I believe to be "created" on SharePoint or on what MS call the Home365 versions that support (via shrepoint again as I understand it). It would be a good thing but I do not have access to SharePoint of the Home 365 equivalnet. So my question is can I create a MS Access 2013 "custom web app" on my ZOHO account? If so - what would be the general Web Locactin URL/Address ??
File Upload Tool
The Zoho FileUpload tool which allows for the bulk upload of files into a File Upload or Image field is not allowing me to login to any of my applications. Is anyone else who uses this tool seeing the same problem? Is there something wrong on my end or is the application broken?
Unable to Connect to Messaging Server
I am constantly getting this message in Zoho Creator. I have not set up any SMTP messaging server or mapped any custom domains.
Problem with edit button in a Report
Dear All, I have an HTML Page and I embedded a form and a report inside of it. As you can see when I am trying to delete a record the 'window' with the Delete, Duplicate, Print options is working like this. So, it is not possible to click the Duplicate button because when I move the mouse the window is lost. I tried it in Chrome and IE but I had the same problem. Any ideas?
Back up not working
I am trying to back up my application and I keep getting failed and null in the description. Is there something wrong? I only have one previous version.
Type Required "Int", Type Found "Long" error
I am calling a function from within a function. They function that I am calling needs to receive and Integer, however when I I try to send an Integer (specifically an ID from a related drop-down) I get the attached Error expression type does not match: type required:int type found:long
Popup Window v New Window on user input actions
I have an app whereas I created a function to add record that autofills a related form field and then script in that form (on user input) fetches the information and autofills additional fields. I set up the function to open as a popup window. This works to initiate the "on user input" actions when the lookup fields is autofilled via the function. I get an additional popup window that is blank when I submit the form. I then changed the function to open the new form in a new window, however,
What type of images file types are supported in ZOHO?
What type of images file types are supported in ZOHO?
Aggregate Records Average Function Issue
When I use the aggregate records average function the result looks to be inaccurate. Exporting the report to Excel or Google Sheets and averaging the column returns a different result than Zoho did using the aggregate records average function and displaying the results in a html page. I believe it might have to do with blank fields within Zoho's averaging range that might not be ignored. So what can be done to fix this or increase the accuracy of the returned results? Additionally is there anyway
Calculated date field causing error that disappears when field is hidden
I have a field "Art Due Date" that is calculating a date for 5 days before another date in the form. It's been workin for 2 years and then last week every time someone tried to edit a record using the form with this calculated field they would get this error "Invalid Field Found Field Name : Art Due Date" and would be unable to save the record. I changed the setting on the field properties by unchecking the "Make the field visible in the Form" and I was able to successfully save/revise records.
How to configure report to show empty fields as empty spaces?
When I create a report and I have an empty field, this field appears in the report as "-No Value-", as you can see in the picture below: How can I make to the report show nothing (just an empty space) in this field? Thanks
Count Records Issue
Have an issue using the Aggregate Records Count function and displaying the results in a HTML page. Zoho's example seems simple enough. Or I'm just missing the mechanism that displays aggregate record count? Zoho Example: //to count all records in a form input.Total = FormA.count(); I have tried: input.Quote_Number1 = RFQ.count(); Quote_Number1 = RFQ.count(); NOTE: Quote_Number1 is a Autonumber field Nothing is displayed in my html page. Any ideas?
no reply from support
I sent an issue by email 2 days ago and have had no reply. The subject line is "automation not working" I have logged this again via the support request form today. I am not receiving any auto-reply from support that even indicates that my email or form submission was even received at your end. Please advise.
Support Issues
What is the best way to get Zoho support? I submitted two different support requests (and left voice messages) last week that were critical to not only the usability of my application but the roll out of the application (which has now been delayed by a week with no solution or timeline in sight). All I get are "we're working on it" emails but no solutions? These issues are still not resolved. Is this typical of Zoho support? It doesn't seem like they place much of a priority on their customer
Seeking Help with autofill
Hello there, I'm new to zoho in general and I'm loving the service however, I am unsure how to go about something. I was wondering that if a user input their CRM name into a form that the creator would be able to fill out the rest of the form based off of that field alone. For instance, Joe Blogs has a quote, a purchase order and a sales order but doesn't want to have to type each out in the form. Would it be possible to just enter his name and grab that information from CRM. If this doesn't make
Integration Zoho mail app shortcut with Zoho Creator sections
Dear all, My question is simple and short. As you can see in the attached image, I would like to know if there is any way to create shortcuts in the Zoho mail apps shortcut (in the left of the panel) with some sections of my Zoho Creator application. In my example, I would like under the Links shortcut to have Admin Functionality and Inventory setup shortcuts. If there is no way for that, then is it possible to have a shortcut under the Links with the name of my whole application?
Creator Support No Answer
Is it just me or has anyone else had issues contacting Zoho Support via phone? it seems like every time i call it goes straight to a Voice Mail.
Dynamic view criteria with access to other forms
Hello everybody. I'm trying to implement a sort of function that allows every single user to choose on which data sets he can work on. I found no problem with the FORMs by creating a table on which I save a sort of cookie for the user. The problem is with the VIEWs: I cant' make the view access that table and select the proper criteria selector (ie: the company). Is there a way to make the dynamic view criteria work? Thanks, Matteo
Formula field Date Calculation shows time too
In a formula field, I am trying to subtract days from a date field. The formula field displays the correct date, but also includes the time. Is there a simple way to strip the Time and display only the date? I know it can be done in a tedious way, by creating more formula fields, convert to string, then getPrefix, then convert back into a date, etc, but i was hoping there was a way to accomplish this all within the one Formula field. (Registration_Expiry.subDay(150)) the Original date field contains
Free edition of Creator - can the public access fill in the creator forms embedded on my website
Hello, I am using Zoho CRM and recently created some registration forms using Zoho Creator. I have embedded these forms in my website. I have noticed, however that when I am not logged into Zoho - these forms are not accessible - asking for a username and password. I need people to subscribe via my website. They do not have usernames and passwords. How do I enable NON- Zoho users to fill in my Zoho Creator forms? thanks and regards, Michelle
Shared Users import via Migration Tool
I have shared an application with a user who I need to be able to import records using the Migration tool. The user is unable to select the Application from the list after selecting "Shared Apps". What applications should be included under "Shared Apps" for non Admin users?
Next Page