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?
create list of form names
Is it possible to generate a list of the names of the forms and views in an application? What I want to do is create a software request form for an application with about 50 forms and views. When the user wants a change to the software they go to the form and specify if the change is to a form or a view. Depending on the response they are then presented with a list of the Forms or Views in the application. I can manually create the list but it would be nicer if there was a way to do this in a script.
Can variables be declared in a conditional formula?
For example, how would I get something like this to work? InvoiceNumbers = (Payment[ID > 0].InvoiceNum).getall(); if( InvoiceNumbers .contains(ThisFormInvoiceNumber) == true, ThisFormInvoiceNumber , ThisFormInvoiceNumber + "<font color=#FF0000>An Invoice Needs to be Made for This Group of Records</font>")
Edit ''Added_User' fields
My Zoho database has been public to date but I'm adding a private view of data that was entered via public pages. The Added_User fields that I use to restrict users to seeing only their own data, is therefore set to 'Public'. I'd like to edit this field so that it shows the user e.g.firstlast, otherwise users will not be able to view or edit data they have already entered via the public page. Although I can see the Added_User field in the view, I am unable to edit it in the record view. As Administrator
Maximum Fields
Hi, Here, https://help.creator.zoho.com/Known-Issues-or-Limitations.html, it says that for single line fields "Form can have maximum of 80 text fields with max length of 255(SingleLine and Email). This can be increased by reducing the max length value. " I have already reduced most of the fields' (80% of it) max length of characters from 255 to 55 and some to 10 and 5. However, I am only able to use 81 fields. Is there a way to know how much should I reduce the max length of characters and how much
Problem HTML website form
I am trying Creator to decide to buy. I created a nice input form to be used on my website. tried to embed it, and all I get is a large black box that is empty. The email link works perfectly. I used the website link in the CRM web to lead form and that works perfctly. What do I need to do to get my survey form to show up properly on my site. Is there a setting or formatting thing in creator that needs to be changed? Many thanks
Failed to retrieve stored file
I am failing to retrieve the files stored at Zoho Creator. The effect is intermittent: sometimes I can retrieve them, while other times I can't. If you wanted to replicate my results, please look in my apps, whose access has been grated to Zoho Support. Thanks!
Using form fields in lookup criteria
Now it is possible to use form field in the criteria of lookup fields. This will help creating dynamic drop down fields whose values depends on the value given for the other fields in the same form. Refer this sample application implemented using this feature. It contains three forms Country, State and Registration. Registration form contains two lookup fields Country and State. The criteria "Country == input.Country" for the lookup State in the Registration form will update the States based on
Merge Fields from Sub form Data
Can't seem to work out the code for emailing sub-form data from a parent form I use the insert expression on the email tool,but as its variable data, its asking to define the variable (Cant seem to find a help documentation regarding this, is there way to create a email template based on all of the rows or just the latest added or as you add them Subform: Bill Status Parent form: https://creator.zoho.com/kingstonscardiff/kingstons-inspection-booking-system/#Form:Bond_Status Regards Omar
Navigation URL
Can someone please tell me how to use #Script:page.parent.close I want to close a window on the click of a button using this script but it is not working. Can someone give me the exact syntax. Thanks. Jayadev.
If statement and multiselect/Checkbox
Hi, Can you apply an if statement to multiselect/checkbox fields? It doesn't give the option to apply any scripting to the field? Is there a work around for this. I want to be able to apply a condition (e.g. hide field) on the basis of a multiselect selcetion? Any ideas please? John
Need help for Character conversion
Hi When through the deluge to the SQL server insert into the Chinese data(English is ok), add data garbled, so how to convert the utf-8 to GB2312 or GBO ? Thanks Stanley
Best way to Control (delay) selected Scripts On Load
UPDATE: I had posted the topic below the stars earlier and now found a better solution. It was simple, really: For the key fields that need to load "first", create a "partner" field that is filled upon load with the same value as the key fields. Then use key field On Update script conditional on key=partner to trigger the filling of the other lesser fields that needed to be filled "later" . Then add partner="" to the On Update scripts for the lesser fields. ********************************************************************
Zoho Creator Helpdesk: automatically create request via email
Hello, Can you please let me know how I can have a new request automatically created via email to specific accounts (e.g. info@agroenos.com, help@agroenos.com, support@agroenos.com) ? Also, is it possible to answer a request submitted via email from within Zoho Helpdesk and have the requester receive the answer via email? I have already provided edit access to support, via the following URL:https://creator.zoho.com/admin.agroenos/help-desk/settings/edit/ Finally, can you please let me know what
Add Aggregate Formula/Field in Creator
Hi Does anyone know how to use this function in Zoho Creator? It has recently appeared in the Reports module (Edit mode) and I cannot figure out how to use it.
Next Page