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.
Displaying All Row Fields
How can I populate or display the other fields once I pick a value in a dropdown? The dropdown was made using a lookup. Ex. If I select a contact then his email, phone number, address etc... are displayed on the other form fields.
stringlist conditioning
Hi guys, I'm not into coding too much but i have an idea of the basics. I have a stringlist in my app, and when a certain value is selected (in combination with others or just that value) I want to enable another simple string field. Could you help me with the code? Thanx Cosmin
How to get Zoho Challege records in Zoho Creator ?
Hi, In zoho creator - leadslist = zoho.crm.getRecords("Leads") ;Using this function we get records from zoho crm. But is there any function like testlist = zoho.challenge.getRecords("Tests") ; - so that I get all the test from challenge?Right now i found above code is wrong. Any help will be highly appreciated. Sorfuddin
Button next to dropdown and layout
Question 1: How can I add a button next to every dropdown? I want that button to show a hidden field when I click it. Question 2: Is there a way I can create a model window for a multiline text. If my question 1 is possible then I want it to open the model window or pop up with the multiline textbox. Question 3: Can I create a three column layout? Thanks.
XML feed
I need to develop a Zoho Creator script to import data from an XML feed into forms -- could be multiple forms with relationship set up between them. I need to let the script automatically import at intervals, say every 12 hours. Is this possible?
Zoho Creator Help Desk cannot delete: you are not allowed to view / edit the script
I had installed the application for trial. Finally, I found no interest and want to delete, but I cannot..... "you are not allowed to view / edit the script" HELP!!!
Formula field help
I have a task form to assign specific tasks to individuals to work on them. I have "Estimated Hours", "Actual Hours" and "Remaining Hours" which is a formula (Estimated_Hours-Actual_Hours). I also have a Project Length lookup field that's a in which you choose how many weeks/months you have to complete the project and it will then formulate the Weekly Hours =(Estimated_Hours / Project_Length).round(2) which will break down how many hours a week you need to devote to the project to finish it.
Help Creator Login Problem
Unable to Login to Zoho Creator, Please help beacuse I am using it daily.
I can not enter my Zoho Creator Account. So does my friend
The form is accessible in the public view but i can not enter to edit it. i need it ASAP. so you gave any idea why?
Reply to multiple email addresses
Within Zoho Creator, I want to reply via e-mail to multiple recipients using the "Reply" form. If I try to send an email to "user1@domain.com, user2@domain.com" (without the quotes) I am getting the following error message: Enter a valid email address for cc When I try to use a semi-colon ; in order to specify multiple recipients It allows submitting the reply form, but it never sends the actual email as it is most likely recognizing the input value as a single email address. Do you have a procedure
How to display data in a form field?
Hello I want to display some data in a single field when i choose some option in a dropdown o multiselect field, or when i put some numeric values in a number field i want to display the sum total of that values in another numeric or currency field without going to the view from that form. Thanks for your time and patience Greetings from Colombia
If statement not working
For a Task form I've built, I want to be able to put in the Estimated_Hours of the project, the Actual_Hours of the project and how many hours a week I want to work on a project, Weekly_Hours. If the (Estimated_Hours-Actual_Hours) is less than the Weekly_Hours originally submitted, I want the Weekly_Hours to show the (Estimated_Hours-Actual_Hours) to have a better idea of how many hours per week you have committed to a project. For example, I'm working on project X and at the beginning of the project
Format number of decimals displayed in sum totals in a view
I have some decimal number columns in a view. When I use the sum function, the sum totals are carried to a large number of decimals. Can I control the format to display two decimal places?
Next Page