"Failed to Add Data" when submitting form
No other information and no other clues are given. The project has open access to support. And I have asked support to help on this with no success, yet they pretend they solve it, or ignore my problem. Support staff lately is very unhelpful. I wonder if others experience this error and know what to do.
Alert Box size
Hi, I have set up a alert on user input but it seems the alert size is really too big. How do I can size it to smaller ? Below is the script that I am using ************************************************* if (input.UNM_MVPD_01 != null ) { input.UNM_alertNote = ((((((((((("The " + "<b>" + "<i>" + MVPD[ID == input.UNM_MVPD_01].mvpd_MVPDName + "</i>" + "</b>" + " in " + "<b>" + "<i>" + Market[ID == dat.Add_Market].Market_Name + "</i>" + "</b>" + " TV Market Sold to " + "<b>" + "<i>" + MVPD[ID
live chat to a creator page?
Is it possible to add live chat to a creator page?
Writing to Creator database from Zoho CRM
Is it possible to insert values into a Zoho Creator database from the CRM, using a custom function or something similar? If I write the code in a custom function, I get an error that the Form does not exist in the application. Any ideas?
Wufoo to ZOHO
I am willing to pay for the job I require somebody to please set up my Wufoo toZoho api ? Any body that has done this or can assist please contact me.
Script for lookup of data across different applications
I would like to do a lookup from a separate application. Here is an example: config-module: "Form1" has fields: Global Category, Prefix hr-module: "Form2" has fields: Category and Name --> Category is my lookup field. --> When I lookup a category, I would like to populate from config-module's field Global Category. The issue is, I want to create a function to get the details from the form programatically, it keeps suggesting that there is an error...the problem is that my lookup field (which
Update records from other form
Hello, I have a form (form A) with information about vehicles. These vehicles have to periodically inspected.The date when the vehicle is inspected is filled in. In an other form (form B) I can plan this periodically inspection wich will be shown in a calender. In this form B I would like to add an input field where the new inspection date can be filled in. So when a new inspection date is filled in form B it has to update the inspection date in the record generated by form A. There is a report based
Subform subtotal automatic
Hello, I have made a subform with the following fields: Field 1: Aantal Field 2: Prijs Field 3: Subtotaal I have made the following script for Subtotal: row.Subtotaal = 0.0; row.Subtotaal = (row.Aantal * row.prijs); // calculate grandtotale input.Totaal = 0.0; for each rec in Werkzaamheden_2 { input.Totaal = (input.Totaal + rec.Subtotaal); } input.Totaal = input.Totaal; The script works but subtotaal will not automaticly be filled in when I put a value in: Aantal en Prijs. See attachment
Hyperlink function not working
I just tried to access the hyperlinks in my database and it's not working. Is there an estimated timeframe for a fix. These links are critical to my business. Thanks.
data typing; script error
I have an app with a subform. The whole form looks something like: Client - a lookup Project - a lookup Employee Hrs Rate Bill_Amt (a line of the subform) After entering Employee, I want to lookup the associated Rate and insert in the Rate field above. I am trying some scripting : theRate = Employees[ID == row.Employee].Rate; alert(isNumber(theRate)); //used for debugging returns true. row.Rate =theRate; When I go to save the script, I receive : Error at line number : 3 Expecting
Problem in form
Hello, I'm stuck in a form. In the attachments I have uploaded a print screen of the issue. When I select "Selecteer opdrachtnummer" the value in "Kenteken" has to be filled in. When "Kenteken" is filled in the field under it has to set a variable. The field "Kenteken" in the sub-form "Kosten" is based on the field "Kenteken." The problem is: Why does "Kenteken" right in the top doesn't fill in his value. Probarly there is a value because the field "Kenteken" in the sub-form is based on it.
Passing parameters to embedded form (2)
Hi, I would like to create HTML pages to customize the look and feel of the forms. However, I use navigational URLs to pass information between forms. How can I pass data to the embedded form?
formula field issues
Is there a way to make a formula field calculate properly if one of more of the items it's supposed to sum are blank? For example, say I have three number fields: Group A invitations, Group B invitations, and Group C invitations. If the formula field expression is (Group_A_invitations + Group_B_invitations + Group_C_invitations). but there's no value for Group C because no one from that group was invited, then the formula won't work. I still want the sum of groups A and B though. How can I make this
Picklist not accepting a list
Hi, I have a picklist not accepting a list of string items. The script can be saved fine but at the time of execution it generates an error. To, me nothing seems wrong with the logic here. The list is generated in another application from a database of categories filtered by another field. There seems to be an issue with this way of generating the list because if the list is generated manually with random items like "a", "b", everything works fine. I appreciate your support. here the code: Tecnicas_Lista
HTML script sections in a page
Hi, when creating a page, I added several HTML sections one after another. each section containing a table with pictures and text. At some point I wanted to add one section at the top but the insert HTLM function did not seem to find a spot to add this new HTML section right at the top. My reaction to this was to switch to free flow scripting, add a few lines at the top (to create a space), save and go back to script builder mode. The result is that the builder lost track of the different html
zoho.userid actual BIGINT ID?
I don't need the email address, or the user name, I need the BIGINT number. Can this be accessed?
Other currency field vs chart
Hello, I have a problem. In a field I have selected the currency "EUR" --> €. When I make a Pivot Chart based on the database with the value of the field with lay-out "EUR" -->€, it will show in the Pivot Chart a dollar --> $. How do I change this? See attachment for a printscreen.
Change current index of autonumber field
Hi, We developed and are using an application for orders management since last year. We're using an autonumber field for setting the unique ID for each order. The start index was 20140001, so we could easily identify the year an order was generated. We intended to change this index, this year, for 20150001, but I figure out that this is not possible in Zoho Creator. Can you made this change for us, please? The form is at https://creator.zoho.com/appbuilder/gbpenha/pedidos, and the field name is Codigo.
Get Quickbooks Customer Details
I've been able to get quickbooks customer details using the quickbooks integration functions; however, I'm having trouble accessing the individual child attributes. For example, I can pull the Customer ID, First Name, etc. with no problem. When I request the BillAddr, it provides all the child attributes in one large string. I'm trying to get the individual child attribute values Like BillAddr Line1, Lat, Long, etc. The code I've used to successfully get the info is: searchResponse = intuit.quickbooks.searchRecords("st_Rate_QBO",
Customer Survey
I have made a customer survey form. I would like to have it go out with an email form I already have being sent. Do I need to publish this form first, then add it to my existing email, or do I need to have it sent separately? If Seperately, what is the best method for scripting? if(input.Billable == "Yes") { if(input.Customer_Name == "Savings Bank") { sendmail [ from:zoho.loginuserid to:"@jbank.com" bcc subject:(" Savings Bank " + input.Terminal_ID) + " Service Call Response" message:(((((((((((((("<em><strong>This
Is there a limit to the size of an HTML upload?
Hello, I'm trying to create a page. I have a HTML document that is 22,000 lines long. It doesn't seem to upload on save. Is there a limit?
Using Image field to take picture
My target device for my Zoho Creator app is the Chromebook. I'm looking to allow users to take a picture in addition to uploading a file in the image field. I know this is feature is available in iOS and android devices, is there a way to implement it through a browser (because there is no chromebook web app for zoho creator)
Newbie questions
Hello, I am new to Zoho, and I don't have any experience in creating applications. I have 2 or 3 projects that I believe Zoho could provide solutions for. Is there phone support, or an option where I can consult on how to create the tools I'm looking for? Thanks
Android app of creator
We are having trouble with the Zoho Creator app (Android Version). When enter information and click submit, it works fine. But once all the fields are cleared and we go to enter the next bit of information, it automatically submits and duplicates the previous record. What is funny is that once this duplicate is created, it works fine again. But then when you submit the next set of information and all fields clear, the same thing happens and makes another duplicate. Is this a bug issue in the Android
Cambiar "Single_Line" a "Multi_Line" /Change " Single_Line " to " Multi_Line "
Español Buenas noches, tengo un cambio el cual inicialmente fue creado como "Single_Line" el cual ahora es necesario que sea "MULTI_LINE".. Campure los valores de este campo junto a su ID en otra tabla para luego realizar el cambio volverlo con su informacion original. Pero al querer eliminarlo me dice que este esta relacionado a varios objetos, la lista parece ser tan larga que realmente no se cuantos podrian ser. existe alguna posibilidad de realizar este cambio de alguna forma mas practica? Aguardo
Creating Navigational URLs for mobile
How do I create navigational URLs for mobile browsers or the app as hashtags do not work outside of the web browser. Is there a way to check for the browser or OS?
Lookup based on a lookup
I want to create a form called Billable_Items that is related to a form Projects which is related to a form Clients . Form Clients has a field Client. Projects has a field Project and a field Client which is looked up from Clients. On Billable_Items, I want a field Client looked up from Projects. The system won't let me do this. It will let me do a lookup on the ID; i.e., system record number. Then I want a field Project looked up from Projects and filtered based on the Client selected in the
Fetch Records Case Sensitive?
I'm looking for the scripting syntax to fetch records using criteria that is not case sensitive. For example, I'd like to find all people with a particular first and last name: recordCollection = People [firstName == <criteria1> && lastName == <criteria2>]; However, the criteria appears to be case sensistive (i.e. <criteria1> as "John" yields a different result than "john". Do I have to code for all possible combinations of letters?)
Record Summary page 2 is not showing
I have a 2 column record summary with fields that extend beyond one page. For some reason the Labels and Fields are showing clearly in Page 1 however I cannot see a way to scroll to the second page of the summary. Any ideas? Is the record summary limited to one page. Tell me isn't so!
Error 500: Create Form from Template
I have been unable to create a New Form choosing "From Template" in my application, and then the first form I originally created. I have tried multiple ways to create the Form from the existing Template and each attempt results in Error 500.
Image Field, URL value assigned using script
Hi, I have a form, where I have an Image field. I want to run a script to assign each record a URL value to the image field. The issue is that the script seems to do nothing, i.e. the URL string is not written into the field. below the type of script I am talking about, which produces no change in the Image field... thanks for your support... for each F in Fotos { F.Image="URL"; }
Customer Portal, open url passing logginguser
hi, Using the portal, I want to have a stateless form where depending on a picklist selection, the user will be redirected to another form in the same customer portal application. The issue I am having is that by using the openurl function, when the user is redirected to the new form, the loginuser is no longer recognized and is being asked to log in again... how can I direct the user from one form to another in the application without loosing identity? Regards Luis
Rotation on larger mobile devices
Is there no rotation feature on mobile devices? If I use a docked ASUS Transformer, the screen doesn't rotate. I can no longer use a full keyboard for data entry. Is there a way to enable rotation through the Zoho Creator mobile app?
Column Width for Rich Text Field
In a report it seems that setting a custom column width for a rich text field has no effect. My users type a lot of text and the reports are getting cumbersome to navigate.
Help With the Right Path in Zoho
Problem: My wife runs a charity, and I'm thinking about using Zoho to capture requests for her product. The product is free, but there is a shipping fee. The charity only helps people that meet certain requirements (income level, number of children, etc.) and the user must submit attached documents proving they meet these requirements. These are then reviewed by staff and, if approved, they are invoiced for shipping and then sent to another group for fulfillment. My Struggle: My issue is that Zoho
zoho ed platform
Hi as an educator who uses a variety of blended options to reach and interact with my students and tutors, it would be great to have an integrated Zoho platform something like Wiggio (perhaps). Anyone else interested in this? (Isn't it counter productive to need to choose a forum for such ideas? By definition, they don't fit anywhere!!)
Custom function
Hi, I am trying to create a custom function or something like a button that when user execute this function it will input a specific text (URL) into a specific field. please see below screenshot where in the "Update link" field I want to input below url link when user execute the custom action. input.Update_link = "https://creator.zoho.com/mikekokernak/across-platforms-web-proxy/#Form:Update_TV_Station?Update_TVStation=" + 798107000000666628 where 798107000000666628 is the corresponding ID number
Access value of a lookup field
A simplified version of a problem I have: I have two forms Projects and Clients. Projects has a lookup field Client which looks up field Client on form Clients. I want to access the value of Client. In a Field Action on Client on User Input I have the Deluge command 'alert "Entered: "+input.Client' . The message box shows "Entered: 2440810000000112935". How do I get the value of Client. Thanks!
attach a pdf document to a form
hello, I have a service app that I'm working on. It has come to my attention that the end user needs to be able to attach a PDF document. Is there a field type that will allow a PDF document to be uploaded as part of a new entry? Happy New Year, Alan
URL parameter using Equal OR
I would like to know how to pass a parameter in a URL for a view in the form of " variable=A or B or C" in other words, take this URL: https://creator.zohopublic.com/yaxche/catalogo/view-perma/Fotos_2/aYh5B2kTxt3NX2AF4GnaMbPqfeb3qGUy7en5YYeZa1O0DzyRkhkbwq0B2kmfrSQ3juTUf2TDK3mrezZuv7zvBj5p5ksuK3TPheYF?Numero=2 here I am passing the parameter Numero=2, which works fine. The view shows the record where the value of "Numero" equals 2, the issue is that I want to display more than one record, for instance,
Next Page