Importing Data From Excel
Hi, Can someone please advise if I import data from excel how do i avoid duplicate entries being imported. I can't find that feature but I might not be looking in the right place Regards Jodie
filter for a lookup field in a view
I have a form with a lookup field "Employee" that references to the internal ID field. In Advanced display option, I selected Display As: "Name" When I create view for that form and select Employee, column, it properly displays "Name field, however when I try to use this field in filters, the displayed values are internal IDs. Displayed values in the filter should match to whatever is selected for display. Another option would be to allow filtering on referenced fields, It would be even better,
error Sharing Creator Application
I am trying to share my new creator app and I get an error message: "[My_Shared_Pages] null, message from server: "Duplicate entry '660708000000021617-660708000000021531' for key 1" I shared it at one point and then unshared it. What is the problem?
Tool tip to be list items?
Hi, Right now, the tool tip shows the "help" description you put in the field configuration. But can the tool tip be configured to show each list item when it is hovered over? In other words, I have a drop down list. But some of the items are longer than the field length which makes it harder to read them. Can the tooltip be used to extend each list item's text? I've seen this done before elsewhere, but can it be done in Creator? I'd rather do this than expand the length of the field, which
What happens when an email fails?
How does Creator handle an email that is sent to a person in which their inbox is full? How does Creator handle a mis-typed email address? Etc...
Date validation
Hi all ! I have date fields and date-time fields with the formats [dd/MM/yyyy HH:mm:ss] or [dd/MM/yyyy] Some of users hit the date as dd/MM/yy (Hiting the year as yy or yyyy is frequent). Then the date : 30/09/11 is submitted in Creator as 30/09/0011. Is it possible for creator to detect it and submit the data correctly (2011), or what kind of script can I write for this please ? Thanks Cyril
NView not defined in the Workflow
For the second time in two days (two different applications), I got this error message when attempting to save a section code ... NView not defined in the Workflow ... this last time, I restarted ZOHO Creator, navigated back to this section code and (without making any changes) attempted to Save it ... and still got this message. Please explain ... a) what this undocumented/undecipherable message means b) how does one get around this ? Gaev
List Support in Reports
Reports currently do not support lists as a filter criteria. In order to view a report that meets some limited criteria, you have to edit the view criteria first and then regenerate the report. John M. Whitney
Browser Testing
Adobe offers a service for free that allows you to test your ZOHO Creator pages in different browser/OS combinations. For example in my testing, Firefox on OS X required a page load time of 10 seconds, while Chrome allowed 0 seconds load-time. Also, every now and then I'd get the dreaded "Error: Contact Application Owner" page while other browser/OS combinations were fine. Here's the link: https://browserlab.adobe.com Enjoy! John M. Whitney
My Functionality based URLs is not stable
Hi, My client have a html view which passing parameters in the html view url, and fetch records by using the parmeters. However, after keep on testing, there are 30% chance that we can't fetch record in category and subcategory. I guess I make some mistake in construct the url parameters. I already enable support access. Could you please help me to take a look? Thank you. My client also intensive enter a lot of symbol in the database which cost a lot of problems. For example, " (This is for size,
Dynamically adding items to a drop down box present in a subform.
Hello just looking to get an update for when functionality to dynamically add items to a drop down box present in a subform will be available in Zoho Creator. This would be very useful for the application I am building to manage product configuration selection for customer orders. Cheers
Deluge script in for Schedules
i have a problem with my schedule, that falls for deluge scripting limits.. But i don't understand why: i have made many attenction to the scripting to not update all record but only the necessary records.. Thanks for urgent reply..
Dynamic Picklists Within Subforms
I've started trying to integrate the new subforms into my application, but have found that my dynamically crated picklists, don't dynamically change, when they are used as a subform. Is there a way to keep the dynamic nature of my fields, while having them as a subform?
intermittent issue with notification bar failing to update
The service is very slow at the moment. For example, saving a short script is taking 30-60 seconds. (EDIT: To clarify - as mentioned below, it later turned out the script is in fact saving ok but the green notification bar is sometimes failing to update.)
Urgent - Comments disappear when Saved from Free-Flow scripting
I was doing a test of a script section code and needed to temporarily disable a set of Deluge commands ... so I wrapped the command lines within ... /*abcd and xyz*/ ... but when I returned to the section later (after Running the Form), the block of lines were gone !!!! I did another experiment with just the //for a single line of comments ... that line disappeared too !!! I hope this is just a case of ZOHO Creator keeping its perfect record of "Make a platform change ... break unrelated functionality"
Reports are generating correctly in report builder, but display as "No Data Available" when I access the actual report
Report builder is showing my data correctly, but when I pull up my report, the report states that there is "No Data Available". See the attached screenshots. I also have another report that is still reflecting some "test data" that has since been deleted (4 days ago). This data should not be included in the report since it no longer exists in my database.
My Grid view is showing up as List view
Hi, I created a Grid View, but it only shows up as list view. So, my list view and grid view look identical. What can cause a "grid" view to show as a "list" view? Thanks.
Open URL pop up in a custom action x 2
Hi, I have shared my application with your support Config2709 Basically I have three layers of detail to capture. 1 . Quote 2. Room 3. Room product selection. Now I have used your Meeting Attendance planner method to relate the concepts. The quote view has a custom action for each row to open a "room view" (pop_up). I can then add details about each room. The room view then has a custom action for each row to open a "room product selection view" (pop_up). However I am having a problem with getting
How can I get an access to my app (at zoho.com) when IT departament banned "zoho.com"
Hi, My IT departament banned access to every URL that contains "zoho.com", because "it's dangeorus to our company". Is it possible to get an access to an application at zoho.com using other URL (for example zohocreator.com)? Regards, Leszek Mizyn
ABS or Absolute maths function for Creator?
Hello, Can anyone advise if an Abs function, or equivalent is available within Creator. I can't seem to find one...it is available in CRM and Sheet...so I am curious why one hasn't made it into Creator. Hope you can help. Regards, Liam.
Regex Matching Modes?
Does Zoho support these modes in the replaceAll() and replaceFirst() regex engines? /i makes the regex match case insensitive. /s enables "single-line mode". In this mode, the dot matches newlines. /m enables "multi-line mode". In this mode, the caret and dollar match before and after newlines in the subject string. /x enables "free-spacing mode". In this mode, whitespace between regex tokens is ignored, and an unescaped # starts a comment. /g - Allow global matching (all occurrences of a pattern
Tip on checking existance of records..
So I don't know about you, but I get really tired of having to use the count function to check for the existence of records first before making a collection. (From my knowledge this is how most do it) Example... cnt = count(myForm[field == value]); if(cnt != 0) { myRecords = myForm[field == value]; } One must use the count function because if you try to do this, ZC throws an error myRecords = myForm[field == value]; info myRecords.ID; However, I've found what I think is a very convenient way of
Lookup advanced display option
How can I display one field of a pickllist, and save another field like the ID on a lookup field that is dinamically changed in the on load form.
How do I create a Record ID link to sync/pull multiple data fields from one or multiple forms in a different view?
I am new to Creator and have a fairly basic database application question but can't figure out how to do it on Creator. Typically in a program like Access, you can tie records together by a certain data field and then pull certain other data fields into a form or view without having to re-enter the same data every time you input a record. For example... In my database "Contact Info", I have two fields, one - "contact" and field two - "phone number". Let's say I've created a view (not a report)
How to best link records within the same form
To make my database truly effective I need to show the relationships between records within the same form. In Form1, I'd like to indicate that Record1 is comprised of Record2 and Record3. I would also need to indicate if Record1 helps to comprise another record in the same way Record2 and 3 do for it. If I were to view Record2 I would want to see that it comprises Record1 and whatever else it comprises. The ultimate goal is to clearly see all of these mapped relationships. I've tried a few attempts
how can i send multiple email notifications with Form Data on success?
how can i send multiple email notifications with Form Data on success?
on my website I need to put some written info on top of the chatbox. Is that possible?
on my website I need to put some written info on top of the chatbox. Is that possible?
Help on Deluge please.
Hi. Below is my problem please help someone. Form 1 Acc No Name Address Telephone Form 2 I want to select acc no from a lookup, no probs I can do this But I want Name, address and telephone to auto fill on form 2 from form 1 based on acc no. No real help online for this script Please help Thanks
Custom Schedule on every 15 minutes
Hi, Is it possible to create a schedule after every 15 minutes? If yes, then please help me how to do this.
Update Button in View
I'd like to do something that I'm sure is simple, but I just can't seem to figure out the syntax. Here's the setup: 1. Form A has 20 fields. 2. Form B is a stateless form that lets users edit 10 fields in Form A. 3. I need an Update Button in Form A View that invokes Form B (the stateless form) and populates it with the 10 editable Form A fields from the matching record/row. My specific challenge: I can add a button (custom action) to Form A View and get it to invoke Form B, but I can't do it in
One Question Per Page? Smartphone App
Hi, I am creating a form using Creator. I want it to be accessible via smart phones. Is there a way to have one question per page/screen? Then the results compiled for the user? Thanks.
Render Image Problem in Different Views
Hello, I put an "Upload Image" and a formula "Display Image" in the form A. And I write the code below into the formula: ((("<img width='64' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Upload_Image + "&sharedBy=" + zoho.adminuser) + "&appLinkName=") + zoho.appname) + "&viewlinkname=Image_Upload_View'/>" When I go to the view A, I can see the image. There is no problem. But when I go to different VIEWS which I had duplicated from view A, I can not see the image. Could you please
Cannot modify a function
When I try to modify an existing function, I get the following error: Cannot modify.Already a workflow with the same namespace and function name exists. I can modify and save other functions in my app, but not the one in the default namespace. If I move the function to a different namespace, it saves correctly
Is there a limit on the amount of content that can be entered into a rich text field?
I'm pasting documentation into my RTE field and when I go to view them again they are clipped at roughly the same point in the document (the 304th - 318th line). I need there to be able to paste content into these fields without a limitation. Brent
How do I format a date-time value in a view ?
I've been trying to figure out the script code to include in a view to show a Date-time field in a particular way ("EEE, d MMM yyyy, HH:mm aaa"). I assume I'd use toString to do this, but I know so little about scripting that I can't figure out the exact code to put in the view's script, or where to put it. Any help would be appreciated. BTW, my application is a schedule of events for a 5-day railroad festival: http://ccrrf.com/schedule.html TIA! Jamie Foster
More map variable love with insert into, mail to, etc
Maps are REALLY useful data holders. They can be passed and returned in functions, you can dump all form field values into a map really quickly, etc. Deluge already supports using maps in setting postURL, getURL headers, and post body data, why not expand this to allow a developer to pass a map to insert into or mail to? Example myMap = {"first_name" : "Stephen", "last_name" : "Rhyne", "Added_User" : zoho.adminuser}; insert into contacts(myMap) //or insert into contacts [ myMap ] Why add
Limit number of records per user?
Is there a way to limit the number of records a user could enter into a given table? Let's say as a customer of mine who paid me an annual fee of x-dollars, I allow them to enter x-number of records during that timeframe.
Android mobile problem
I use forms in creator because people have the ability to use them on their phones. However, this past week, I've had people using Android phones (version 2.3.5) inform me that the forms will no longer work. The forms will load, but i use the OnUpdate/OnClick events for some of the fields and that is not working properly. Is there any explanation for this? Thanks.
Adding from Google Apps Marketplace
I have two accounts in my organisation admin.mtcpl representing the administrator anandmtcpl representing a user. Now I have installed Zoho creator for my organisation using my administrator account mentioned in point number 1 above. However, I do not wish to use my administrator account as an admin for Zoho creator also. I intend to use my Google Apps User account mentioned in point number 2 above as an admin of Zoho creator application. Accordingly, I logged in to google apps by using my second
Grid View
I have a Form with lookup field. Field selected on that lookup is ID ( Zoho ID of the referenced record). I have a grid view from that form. Making any changes to the data in grid view, removes values from lookup fields even though I edit not a lookup fields.
Next Page