Send email based on selection in multi select lookup field
I want an email to be send to based on the selection of a multi select field. I only want the email to be sent to the vendors that are selected in the multi select field that looks up from a vendor table. The code im using is below but i cant get it to quite work. It seems to be sending an email to everyone in the vendor table rather than just to the people selected in the Vendors_in_RFQ multi select field. for each E in Vendor [ID = input.Vendors_in_RFQ] { sendmail (
Able to export out all data with attachements
Hi, We are using creator, but really want a viable method of exporting all our data including attachments for archive purposes, and wondered what was available to do this. Any advice please?? Thanks Dave
Field validation in ZOHO Creator
I would like to add a number field to my form which shall only accept three digit numbers between 10 and 350. Any idea how to do that?
How to grab the display information from an lookup filed
Hi, I was wondering how to grab the display information from a lookup field. Kind regards, Ray
how to update a field on add
Hi Everyone, newbie question: How do I update a field on add? I would like to concatenate a field on save/submit. I have looked around and can't seem to find the answer.
Notes fields and line breaks
I have an application which is designed to show a Rich Text Field in a stateless form "On Load", however the line breaks are removed, for example, the following value is entered into a multi-line text field This is a sentence with sub items. The sub items are as follows: i) sub item 1; ii) sub item 2; iii) sub item 3. When I edit the record "On Load", the Multi-line Text Field is hidden and the a Notes Field is set to display the value of the Multi-line Text Field. eg. hide myfield note1 = input.myfield
script written in form don't seem to work when form is used as a sub form
a script that works in a form, doesn't seem to work when i use that form as a subform. any help?
New to ZOHO Creator
I am trying to make an application for my business and would like to create an app with basic info on the business including photos, info, Facebook, twitter, youtube videos, etc. How do I create this, I am not too familiar with creating my own app from code yet. Is there a way to do this with simple drag and drop GUI or does anyone have any templates that they can share with me?
Application wont duplicate
Hi My application will not duplicate Can you help? App is https://creator.zoho.com/mrcomputer/mrcomputer# and I have enabled access for you Thanks
Field Required via Script
Hello Guys, i have two fields for Text and this Code. if (((input.Acount_Code_1A != "") && (input.Acount_Code_1A != null)) { if (!(input.Acount_Code_1A).toString().matches("[a-zA-Z0-9]{2,15}")) { alert ("Account_Code_1A should be between 2 and 15!"); cancel submit; } } how can i write the code so the user always has to fill one of the two fields without which there are pre-mandatory. Thanks Carsten
Sorting on a Linked Field in an HTML View
Hello everyone, I was hoping that someone could help me out with an issue I am having with an HTML script that I wrote for a page. In this script, I use two forms (AVLBeerManager & Beer_Locator) to create an html view that displays a list of beers with relevant information (ABV, Description, etc.). Beer_Locator is where location information resides (i.e. @ which bar has which beer) AVLBeerManager is where beer information resides (i.e. abv, desc, etc) I iterated records on both tables, linking on
Get CRM Leads direct to Creator report List
How can I get all CRM lead records to import/sync directly to Zoho Creator report in list view??
Mass editing using zoho creator
I want to build an app to edit my existing records in Leads/Accounts/Contacts/Potentials module of zoho crm massively. Can you please guide how can I do that?
Current date and time in the Date-Time field? If exact data exists how to generate an error?
Auto add the current date and time in the Date-Time field? Also, if exact data exists how do I generate an error?
can i create api in trial version?
i want to use crator API in trail version . is it possible in trial version?
Profile Locale Details not respected in Creator
In My account --> Personal Details --> Profile --> Locale Details I set my language as English and country as United States. When I use my PC at home, with the English version of Windows 7, I don't have any problems. When I use a computer at work, with Japanese Windows, in some areas of zoho.com the interface does indeed display in English, as specified in locale details. In other parts, such as Zoho Creator, the interface is still mostly shown in Japanese. What the hell is up with this? Makes
Custom Schedule
Hi ! i look around but dind't find my answer ! If i set a schedule to run every Last day of month wich in the list i have 31 days !! is it gonna run if there is only 28 days in the month ???
Using Form definition to create forms
Hi, I would like to know, if there is a facility to create forms using the API. If not can I understand form definition rules and write my own Form Definition programatically and post it after authentication to an URL to create a new form ? Thanks Praveen.M
ALLOWI USERS TO SWITCH BETWEEN GRAPH AND CHART VIEWS IN A REPORT LIKE ADMIN CAN
As ADMIN I can choose to look at the data in a report in various ways, such as charts and tables. This does not change the underlying data records. When I save the view, that becomes the default view for USERS of the app, and the USERS cannot change the view of the data. Is there a way to let users choose to see both graphs and chart views like the ADMIN can switch between? Thanks! Loyd
Sort button in pivot chart not working
Sort button is not highlighted and can't sort the pivot chart axys Any ideas why not working? Thanks
NO REPORTS IN MOBILE APP?
I have the Android mobile Zoho Creator app. I can see the data entry form, and can view the records, but I do not see how to view any of the several reports I have in the app. I looked for a checkbox to share the reports on the mobile app but could not find one. My assumption is that the Android mobile app is just for entering data and viewing records, and not using reports. Loyd
Barcode Recognition
Is there anyway to include a web based barcode recognition tool to import inventory. Or barcode generator. This would be similar to something like the new google phone has. Scannerfly has something like this for amazon books.
lookup function 3 levels
Hi, I need your assistance with 3 level of Lookup function. Example of My data: products short-name full-name code Mobiles Samsung 3 3.5" Android Phones Samsung 3 9983 Mobiles Samsung 3 3.6" Android Phones Samsung 3 9984 Mobiles Samsung 3 3.7"-3.9" Android Phones Samsung 3 9985 Mobiles Samsung 4 4.7" Android Phones Samsung 4 9986 Mobiles Samsung 4 5.0" Android Phones Samsung 4 9987 Mobiles Samsung 4 5.3"-5.5"
Add the data of a subform with deluge script
Hello Zoho developers, Finding the answer of this question will help me in many projects. I have 3 forms: MainForm1, MainForm2 and Subform. MainForm1 and MainForm2 both contain a subform of Subform. When creating MainForm1 (in its On Validate or on success), I want to automatically create a record of MainForm2: Form2_ID = insert into MainForm2 [ Added_User = zoho.loginuser ... ];and then to have the same data of the subform Subform in MainForm1 attached to the newly created record of MainForm2. Thank
Showing all records in Table Report
Hello all When using Zoho reports to create Pivot Table, the default setting is to hide all those records that are have duplicates. Is there a workaround around this? I would like to have a Pivot Table and have all the records appear in the Pivot Table. Looking forward to your ideas and help.
Sort button in pivot chart not highlighted
For some reason the sort button doesn't work in pivot charts. I can't sort the x or y axys. Is this a bug or missing something Thanks
Export pivotchart report into .JPEG - trunckated image
Hi, I'm trying to export a chart into JPEG. The export work fine but the final result is a picture with the last few inches of the right side truncated. something like that : Any idea on how ti fix it? Riccardo
<Field Name>:ui.add() function does not work in On Add/On Load event?
Folks, I have another questions for this group. First off, I have found the link below on adding data to Dropdown Lookup List type field. https://www.zoho.com/creator/newhelp/fields/add-to-picklist-dynamically.html In my case, I have my first Lookup Field to be Tournament, then the second Lookup Field is Event. Each Tournament can have multiple Events. Currently, without any initial default value to my Tournament field, if the user chooses a Tournament, the Event Lookup Dropdown field will be
Problems with "lookup fields" and variable criteria
I have an application that uses a subform where I need to query a lookup from another database, the previous builder used a criteria with a variable, but I had to capture the "filter" in each row again, It worked very well. Now with the new builder I have the problem that I can not capture variables in the "criteria" field or at least not work well. Has anyone solved a problem like this? Thanks ....
Criteria to display a report with no value entered in a field
I have a form with categories, more than one can be checked at a time but I need a report showing those that have no category selected. I have tried a few things but none seem to give me the response I am looking for. I need to be able to go back and add categories to the ones I was not sure of when adding them initially.
Creating a report with fileds from Sub-From
Hi there I am wanting to create a report, based on the parent form, but bringing in various fields from 3 sub-forms of this parent form. I have created this type of report using the view link method, but the format of this is not satisfactory, and I want each field to show as a separate column in the report. (This is fine for one field alone, but not numerous) The Subform is logically a one-to many relationship, so I am not sure why the subform columns do not show as options in the report creator,
Subform handling that worked on the old platform is no longer producing the same results!
I have a form that was created on the previous Creator platform. This form contains a subform and is working fine. I created a new form using the old form as a template. I had to use a different subform in the new form. The new subform is an exact copy of the old subform. The code is identical in both forms. The new form does not produce the same results as the old form. In the old form the code listed below returns the string with the contents of the subform field Activity. This is exactly what
Lookup CRM and return address
Hi, I am trying to lookup my CRM account and then based on customer selected return the address? Thanks
Numbers not displaying properly in HTML
I have an HTML page where I am trying to display a currency field from a particular record. When the number is small I get the number to display 800.0 but if the number is in the millions I get 8.0E+8? I have found that when the currency is less then 8 digits I get something like 8000000.0 but when an additional digit is added it goes to 8.0E+8 How can I fix this to display like $8,000,000? Thanks, Sean The top part of my HTML page htmlpage Opportunity_Details(opportunity_idstr, opportunityID)
Can I call the delete web service using JSON in the request body?
Hiya The API samples show using x-www-form-urlencoded data when calling the webservice to delete records. Can I use json instead? If so, can you give me an example? thanks Paul
how to clear Zoho crm lookup field
How can I clear the value of a Creator Zoho CRM field with out using an API call? I want to be able to clear a value that has been entered. I have used the following but it seems to use an API call and i dont think it actually is clearing the value. input.ZohoCRM_Lookup_Field = null;
Calculation based on lookup
Hi, I have the following I am trying to achieve FormA.Product_ID FormA.Weight_Per_Item FormB.Product_ID is dropdown/lookup from FormA data FormB.Quantity FormB.Total_Weight trying to get this to populate based on FormA.Weight_Per_Item * FormB.Quantity Any help would be appreciated
Adding a field from another form database on success
A visitor fills out the form Landing_Page and enters a Promo Code. On success I need to look up the entered Promo Code and match it to the promo code library form called Promo_Code. After a match I need the associated consultant from that promo code record (in the Promo_Code database) to be added to the record that the visitor just created when they completed the form. Please advise how to do this
how are subform entries related to the parent record?
I want to be able to use a custom action to add a sub form record but don't understand how the sub form record is related to the parent record. My custom action adds a subform record but it doesnt seem to be related properlly. I have a custom action that opens the sub form but seem to be missing the part that will relate the new sub form entry to the parent record that the custom action was executed on. The custom action code im using is: void Payment(int ID) { openUrl("#Form:Payment?Request_ID="
adding unique rows
i want to know how to avoid duplication of records while inserting data?i want to know validation for same. when i will upload file only new rows can be added..
Next Page