Form stuck at "please wait"
Ive traced my issue to the fact that when multiple checkboxes are selected that the form is getting stuck in "please wait" message when a user tries to submit. I have figured out that if you just check one box in each section, the form will submit fine. Can you please advise on how to resolve this? Ive shared the app for development in case you need access. Thanks! https://creator.zoho.com/jacqueline.oddo/project-brief/#Form:Job_request_form1
Platform Update: It Broke JSON
Here is one element of my JSON ouput today { "ID":"212085000007745003", "LISTS":[ "[NISHIOL", " NISVARP", " NISGRE8", " NISGRE9]" ], "EMAIL":"someone@gmail.com" } Yesterday, it looked more like this: { "ID":"212085000007745003", "LISTS":[ "NISHIOL", "NISVARP", "NISGRE8", "NISGRE9" ], "EMAIL":"someone@gmail.com" } What happened? Note the extra brackets and odd spaces. I'm using a PHP script to process this and now it's broken
Subform Data From Master Form Not Getting Deleting
I have two forms. Work Order as the master form, and a General Journal form as a sub-form of Work Order. When I delete a sub-form row(General Journal) from the Work Order master form it will not delete the data from the General Journal. It doesn't show up in the the Work Order form. But will show up in the General Journal form views. As it is a General Journal form used to track profit /loss on a work order when data doesn't get deleted it throws all my number off. How do I make it so when I click
How to show list to a particular Group on Look Up field?
Hi, I have different GROUP Name with different MEMBERS. Now I'm trying to make a database reporting on each GROUP, I want each group to input their reports and identify who among their MEMBERS attended their meeting. What I want to achieve is, when a user input a GROUP name, on the "look up" field under ATTENDEES only show those MEMBERS included in the GROUP name selected. Right now, all MEMBERS in the look up field (regardless if what GROUP) are all showing, which I don't like because the list is
Problems with Subforms
Until now I have not had a need to investigate subforms. But a need arose to create a time-input manager at work and since many people work on multiple projects, a subform seemed to be the base scenario. But subforms are really buggy! First off, it took a while to find how to update a running total of hours as people used the subform to enter projects. Yoge has a demo in the marketplace showing this. To calculate a running total, you treat the subform as a collection (for each row in SUB_FORM)
Preview function popup not working in IE
Hi, I am having an issue where the popup window from my custom action preview function is not appearing correctly in Internet Explorer. I have version 9 and others have reported it in versions before 9. The address is https://creator.zoho.com/slaafws/registration/#View:SLAA_Intergroup_Listings on click of the blue "More Information" buttons. One time you click the button the window might appear, then the next, it doesn't appear, and shows only a transparent gray band at the very top of the page.
"Powered by Zoho Creator" logo hides part of a stateless form
Hi! I've got a public embeded stateless form tant contains several buttons. The problem is some of these buttons are hidden under the image of "Powered by ZOHO Creator". It is a built-in css issue. Any possibiliy of fix this? Any workaround? Thank you!
Issue with a null lookup field that is of type Number
In a Normal form (Year Records), I have a lookup field whose type on the parent form (Year) is "Number". In another stateless form's onLoad event, I am testing the value of the Year field on the Year Records form and it seems there is no way to determine whether the value is null or not null as both the statements below return false: Year_Records[Name == "Two"].Year == null Year_Records[Name == "Two"].Year != null I am referring to this sheet - https://sheet.zoho.com/publishrange.do?id=0d9c0b681f5501ffcf6f935a335ab5e6 but
How can I list all <"Product Name", "Quantity","Unit Price"> rows for a CRM sale order in my Creator application?
Through https://zohocrm.wiki.zoho.com/Managing-Standard-Fields.html, I know CRM "Sales Orders" module has defined following fields. Product Name * Select the product name.This field is mandatory Lookup - Quantity in Stock Displays the stock quantity. Numeric Integers Quantity* Specify the quantity for which the sales order has to be generated. This field is mandatory Numeric Integers Unit Price* Displays the unit price of the product. Currency However, since one sale order contains several <"Product
Import to Subform
I have a forrm with subform. I managed to prepare import that creates new record (in main form) and also creates 2 records in subform. it works just fine. Here is my problem, I need to import subform records to already existing main records ( none of them currently have any records in subform). It does not work. The way I tryed it: I used "ID" field of the main record, this record is updated, however it does not create records in subform
Huge Error on Views see attached image
I happens some times, is there something you can do. See attached image. I looks nothing at all like a zoho view.
Auto Filter Limits
Is there a limit to the number of items that will appear in an auto filter drop down box. I have an auto filter set up on one of my views but it is missing the most recent items that I would expect to see at the bottom of the list. If there is a limit to the number of items that will appear, and if so how to I restrict the list to show say the most recent x number of items. Thanks.
Sorting Lists or Maps
I've been pulling my hair out trying to solve this one! A client's database in ZC contains contractors, projects, and project costs. Many of these contractors have multiple projects. My client wants to generate a "report" showing three columns: contractors, total number of projects for the contractor, and total cost for those projects.The report should be sorted by total number of projects. In addition, this report is a filtered view based on other criteria. I approached this problem by generating
May 2012 Calendar Update: How to lock past events.
How would one lock past events now? In the old system one could simple disable the date field in Edit mode. In the new system the Drag & Drop feature only calls the date field On Update script, so what On Update script would one use to cancel such an attempt to change a past event using the Drag & Drop feature? UPDATE: To prevent the Drag & Drop from changing dates I put a script at On Update for the Date field which basically changes it back right away to what it was and then refreshes the page...BUT
new update broke radiobuttons layout
It seems that the new update in Zoho Creator, with multiple columns layout for ckeckboxes and radiobuttons, just broke something important. Just an example. I have in a form some radiobuttons: Nothing special here. I add the following code at on form load, in order to make "Andet" the last record. The fields is named. Copy code instType = Institutionstype [Institutionstype != "Andet"] sort by Institutionstype ; InstTypeField = instType.Institutionstype.getall(); InstTypeField.add("Andet"); Institutionstype:ui.add(InstTypeField);
Creator form not working properly this morning
Since this morning, our company daily report form is not working correctly. The radio field "Crew Leader" is displaying horizontally where they used to be vertical, and the Actions on User Input on "Crew Leader" field are not working. Not sure what would be causing this. Here is the link to the form: copy-of-krystal-klean-co-payroll-manager1/#Form:daily_report
Another platform change ... another broken function !!!
About an hour ago, my client emailed me to report a problem ... something that used to work as late as a few hours ago has now stopped working. I checked it out and found that it is broken in both his Test and Production Applications. Upon further investigation, I have deduced that the on User Input for a Radio Button Field is no longer being triggered (I placed an alert command and a command to populate another field in the same form ... right at the start of this section ... and it does not do
Something goes wrong in Zoho Creator
Since Morning I have been unable to put New entry .. Below is the error An error occurred while on Success script. Unable to update variable An error occurred. https://creator.zoho.com/piju2111/penta-crm-11#Form:To_Do_Form Note: edit access has been given to Support.
Adding a Record
How come when a record is added to another table neither the validation nor the success scripts of the receiving table are observed by Zoho Creator ?
How to auto-generate URLs for each record in a list?
Hello, I'm using an HTML view to generate a bullet list of upcoming events. Here's what I have so far: <%displayevents = (Event[Date_is_final_confirmed].Event_Title sort by Event_Date).getall();%> <p><%if (!displayevents.isEmpty()) { for each index var_index in displayevents {%> <li style="padding-left:30px;"> <%=(displayevents.get(var_index)).getPrefix(",")%> <%} }%> So right now it displays all events whose dates are final,
quotation using zoho creator
Hi.. currently i'm using Zoho Creator to create quotation.. i'm using Subform to add few of my products to one quotation as below.. After generating HTML & PDF, instead of showing all products, it only show my last product as image below.. any ideas to solve this problem? thanks..
Need help for execute a url in Deluge
Hi Sankar I have a url it's can insert a record to SQL Server like bellow: http://cs.868982.com/getdata?sql=INSERT INTO cl_hpkc (field1,field2,field3) Values(value1,value2,value3)&root=root put the url in address of browser it's can be executed ,but I want to execute the url in Deluge I try used openURL() but failed,so hope you can help me. Thanks Stanley
How to process Toaddress field when is a multiselect list
Hello ZC Team, I have a problem and I need some help, I have a Form with a field called Toaddress, this field was defined as a multiple select list. In the other hand I have a view with a customs action ("Send Open Position") which is a sendmail function based on that Toaddress field. My problem is that only works for the first email id however the field has several emails selected; How can I manage in order to process all the selected emails on that multiple select list?. Please Help :PD
Custom background for embedding views
Has anyone been able to figure out a way to customize the background color (javascript, css) when embedding a view? I'm aware that a form has the background color set as transparent, but the iframe for a view only renders a white background. Note: I'm using the professional theme which has a "taupe?" background, but this does not show when using an iframe window. Any thoughts?
Scheduler attachment limits
I can use the following code on the criteria section of a view but if instead I include the code in the crieria section of an attachment it will not save. What I want in the attachment is only records added in the last week. (Added_Time >= (zoho.currentdate - '1W:0D:0H:0M:0S') && Added_Time < zoho.currentdate) Herb Wexler
Images not showing up
I have an application created (zoho creator) called “PS2 Games I Have”. One of my fields is an image field called “Pic”. The location of the images are in “my picture” folder in Zoho Docs. Recently, the images stop displaying in my application. It only affected certain images. And for those images that were effected, image would not display in the Zoho Docs either although the file is physically there. It seems to be intermittent issue since each time I load the application different images are
why cant i get my numeric fields to line up under my column headings?
please help!
Help! Delete all records limited to 200 at a time
Hi Wizohoes, I'd like to delete all records in a particular table. Currently when i click the select all checkbox .. only the entries in the view are selected, and these are limited to 200 per page. Is there a way to select all and 'safely delete' the records.. my table has 18000 records. Thanks :)
How to get openURL in Function called in Custom Action to "wait" until all selected records have updated
My goal is to set the invoice number of selected billing records in a view and then open an Invoice form that loads its field values based upon the values of that selected group of billing records. In the code below the Function SetPayCode sets the InvoiceNumber field for each billing record selected from the Session Form which has a current InvoiceNumber value of "0 (Not Yet Billed)... to the value of the field named Code that exists in a InvoiceNumberList Form record with the field named FilterAid
Invite users email
Just now starting to get into the 'Invite users' cycle. I'm finding it really annoying that that the Invite email on the Invite/Sharing page is not stored. Surely this makes sense as I do not want to cut and paste the email each time I invite a new user? Am I missing something. Chris
Daily Calendar View
Zoho has a Monthly Calendar View format. Does it (or will it) have a Daily Calendar View format?
Disappointment with and suggestions for Creator's "Calendar View"
Why is the html Calendar View in Creator so poorly designed and lacking basic customization and display features? Please see the attached image which illustrates my point. Why is the data that's displayed cut-off after only a few characters, instead of showing all or most of the text? This is a very useless view, and it needs to be able to be modified by the user to fit one's own needs. Do Zoho developers not understand or care about the calendar view? It seems greatly under-designed, yet it
Can openUrl in a Function open a Stateless form?
If yes, what is wrong with this function code? (The code sets the Invoice Number (as string) field for records whose current string is "0 (un-paid)". After that I want the Form named Add_Invoice to open as a popup. It is not opening. Please help me figure out why not. Thank you. void SetPayCode() { NewInvNum = InvoiceNumberList [FilterAid == "Next"]; rec = Session [InvoiceNumber == "0 (un-paid)"]; rec.InvoiceNumber = NewInvNum.Code; openUrl("#Form:Add_Invoice", "Popup window",
Assigning multiple technicians to a request
Hello, I have been searching for a way to add multiple technicians on a request ticket. Often we have more than one technician working on the same problem, and this feature is necessary to accurately track progress made on the same issue. Also, is it possible to assign a request to a "Queue" - or "Group" of people, and then have that group of people pick up the ticket? For example: - A user submits a request regarding a broke phone - The request is assigned to the Telecom queue - A Telecom technician
Gdata access
I have developed an application in creator and I need to be able to access data from Google docs. I get an error saying I need to grant access to Gdata. I am an administrator on the domain and ZOHO. i can't seem to find where I need to grant the access. Thanks
Lookup in a formula
In a formula, can I do a lookup on another form? For example, given the ID of a record in FormX, can I do something like lookup(FormX,theID,lastName) The value would be the lastName from FormX for the record id of theID.
For in deluge
Hi, anyone how traduce FOR java condition in deluge script? Thanks Mic digitos_iguais = 1; if (C_digo_Fisca_CPF.length < 11) { return false; FOR (i = 0; i < C_digo_Fisca_CPF.length - 1; i++) } if (C_digo_Fisca_CPF.charAt(i) != C_digo_Fisca_CPF.charAt(i + 1)) { digitos_iguais = 0; break; } if (!digitos_iguais) { numeros = C_digo_Fisca_CPF.substring(0,9); digitos = C_digo_Fisca_CPF.substring(9); soma = 0; FOR (i = 10;
Edit for lookup unique entry
Hye, I'm having a problem in filtering unique entry.. My data is blank for lookup field if i want to edit my entry.. for example, if i have select "USA" in my Country lookup field and save it, when i want to edit the form entry, the country field is "Select" instead of "USA".. thanks..
Uploading data to link to Zoho CRM account in a Zoho Creator application
I have created a very simple form in Creator which will be the basis of an application to manage subscriptions. I am using a CRM field in my Creator form to link the subscription form to Account Name in Zoho CRM. In my form this takes the form of a lookup field into Zoho CRM to retrieve the account name. Each account may have multiple subscriptions (essentially multiple rows per Account). When I use the form to lookup an account in Zoho CRM it works great. When I create a view grouped by account
The web tabs that you create will not be linked to the other modules in Zoho CRM.
Team, Can the creator forms be linked back as a related list on the module identified in the form?
Next Page