How do I update a contacts task?
I am trying to update a task for a particular contact, but cannot find a way to find the ID for the task. I used get related record to find the task; (zoho.crm.getRelatedRecords("Tasks","Leads",thisLeadID); The map shows "ACTIVITYID", but it doesn't seem like I am able to use that that to update the task. Anyone have any id how to the ID of this task? Thanks
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
How do I round to 2 decimal places? Using Script
I have a couple of variables I wish to express as a % <%=Failed/Total*100%> This works, but I get an answer for example - 4.5454545454545500 How do I round this to two decimal places? Thanks in advance for any help
Zoho Creator Local/Hosted
Interesting post on Facebook today by ZCreator. My thoughts here: http://crediblesystems.blogspot.com/2011/07/zoho-creator-in-house.html https://www.facebook.com/zohocreator Really hope this is a precursor to a launch.
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
Adding Multiple Records from a Single eMail
I needed to post a number of records into my form, ideally from a single email (and not having to have extra coding on the source system to implement the API). However, Zoho only supports single record submission from a single email. I therefore devised a work-around, which maybe useful to other people needing a similar system. I would also appreciate any comments on code improvement. My Form (IMPORT) has 10 fields, as below. Date Hour Channel Site Break_Type Month-Year Guest_Weeks Promocode
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
MultiSelect Iteration
Good day, I have a form with a Checkbox Multiselect field "workerchoose1", I want to iterate the selected values, and create new records, I save the script correctly but when I send the form I got this error. (If you need access app is share Form DailyTimeReport On Success). I have this code if (input.scheduleselect == "Entrada 1") { for each selectedValue in input.workerchoose1 { workerID = Employees [wkname = "input.workerchoose1"]; fetchwk = TimeFixture [ID = workerID.ID];
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
Dynamically Update Subform via Deluge
Currently I have a main form for Orders, a subform for the Model information and a Product form for each individual asset. The order form has the Model Form as a subform and the Model form has a serial number field which is multiline. I have a script, that works properly, to create an entry into the Product form for each serial entry. On the model form I have a sub form linked to the Product Form. After the script runs the subform in model form never updates. In my script I have assigned a lookup
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
Custom Filter - Display only records with a 'Blank' field
Hi I want to set up a simple Custom Filter that only shows the records which a certain field is blank. The field is called "REM number" and I want to create a custom filter so that only records which have no text (blank) in the "REM number" field is displayed. Is this possible? I've had a look and have tried: REM number > does not contain > "" However this doesn't seem to be working as it returns no records at all. Any help is greatly appreciated Many thanks Tom
How control View display of record retrieved from global search?
When you do a global search, there is a "View" option (#1 below). This view is different than a regular "View Record" --has fewer fields (#2 below). Compare with regular "View Record" display (#3 and #4 below). How can you control what appears in the "View" list display? #1 #2 #3 #4
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
Problem with latest Android mobile update for Creator
It would appear the search-a-field ability has gone bad with the latest Android Mobile update. Anyone else having a problem?
Create Rule Based Upon Unselected Dropdown Field
Is it possible to create a field rule that is based upon a dropdown field NOT being selected? More specifically, I want to hide the rest of the Zoho form below this dropdown field when the user hasn’t yet selected an item from it. Basically the rest of the form shows ONLY once you make a selection in this field. Before you do this, everything below this field is hidden. I don’t know what language to use when writing the rule to refer to the unselected dropdown field. It displays as -Select- when
creating a new input page
Hi I need some help with an input page please Lets say I have a form with the following fields Name Address Tel no Visit time Agent Instructions agent special instructions ETC Now I want to create a new form with the fields Name Address Tel No I want this form to have the ability of creating a new record in form 1 Hope this makes sense
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
Failure submitting to FORM through email
Hi, We cannot submit anything to Form by email. It's been working well but not these two days. No errors found in Log, nothing, email just could not be received by the system. Please help check and advise. Thanks!
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.
Can't update Creator form from Apple or Android device anymore
I have been successfully using Windows IE, Apple, Android browsers to post data to my Creator app for several weeks without issue. Now only Windows/IE works. When I use Apple or Android, I get a "Please Wait" message that never ends, and data does not post. I havent' changed the Creator app. How can I fix this? Thanks
add columns to form fields
Hi, I'm sure the answer is somewhere on here, but I can't find it. I've created Dynamic Content. It's a simple excel sheet. It has 4 columns. When I select it and edit it, there are only 3 columns. I need 4. In future I would suspect that I would need way more than that. What do I do to add columns to it? Thanks!
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"; }
Next Page