can i set delete option for uploaded data within mail
hi, can i configure mail filed in such way that when i upload data mail sent to given id with delete option for uploaded data. please help
Creating custom PDF
Hello guys, I've got a question about creating custom PDF file. I need an application that will print me a PDF file using standard scheme (created by me) and data from my database, created in Zoho Creator. The tricky part of this app is that I need an interface that will allow me to choose the particular records to be printed. How can I do this? Does anybody have any script of such an app? Thank a lot. I'm looking forward for your answers.
Print records with one record per page
Hi - I have a list of projects and I would like to print the "in progress" ones with ONE record per page. I would like to have a sort of a form per page, with all information related to each single project organized in one page. For example Project basic information at the top (name, id, manager), in the middle project description and notes field and at the bottom my status information. In this way, we can review each project by page at our weekly status meeting. I can't find a way to do that.
iFrame vs JavaScript embed of Report to show All records?
Hi, I am trying to embed reports in my website via "IFrame" so that the user has the "search" & "sort" options. But no matter what I try, it will only show the first 10 records of the report and is using "paging". I want the entire report (all records) to show, just as it does automatically if I use a "JavaScript" embed method instead. Unfortunately, when I use the JavaScript embed the user has no access to "search" or "sort" options. I would actually prefer the JavaScript embed, if I could get
how to auto populate rows into subform from another form?
I have the following forms: Main Files (subform) Upload Both forms Main and Upload have a Subform linking to the form Files. The form Files has a bidirectional relationship to form Main. A custom action in the records of the form Main opens the form Uploads which contains the subform Files Both Main and Uploads are none stateless forms. Currently when you click the custom action and submit the form with subform Files the records will appear in the Main form when you edit / view the records. I want
Printing groups in a list separately
I grouped some records in the list view and I need for them to print out individually for a payroll application I developed. Is this possible without exporting the list to Excel?
Help with building our Zoho Database
We are using Zoho to manage our contacts currently, but as our database is growing we need to be able to develop the fields and segment more easily. Is there someone who can do this for us ASAP? Please do get in touch. Hannah Robb
Updating Records using a custom Field as identifier
Hey, is there a way to update a record by a custom field? I don't want to use the id or the email-address for that. Regards, Jan
Help to create
Hi I am looking for an expert who can create for me. I am not very great with technology but starting a small business and zoho have advised my requirements can be met but cannot create for me. Anyone who can help, would be great ;) Please do get back. Thanks Adib
Inner Join in Creator
I have not found definitive answers in review of previous topics... I have a set of forms in Creator. They are like the classic teacher / student / class relationships. One form is the teacher and class pair. The other is the student / class pair that I need to write a new report using an inner join. I want to read each teacher record and join to the student record using the common class field. Are inner joins possible in Creator?. Must they be sub-forms? If so what is the script look like
Can't create lookup relation to a dropdown box?
I can't seem to create a lookup field to a dropdown field on another form. Here's a very simple example of what I'm trying to do: I've created a test application with two forms. Form 1 has a single dropdown box with three choices in it. On Form 2, I'm trying to create a lookup field where the lookup relation should be the dropdown on Form 1. I can't however choose the dropdown field from Form 1 -- it simply isn't an option. Am I doing something wrong, or is this not supported? Is there another way
want to know how to use webservices
hi i want to transfer data from zoho creator database to our company personal database with the help of web services,can u please help me for the same..
Multiple Paypal Accounts in Same Application
Can I tie to multiple Paypal accounts in the same application? Note: not the same form, just the same application. I'm building an app for member registration for different entities within the same organization. Each entity has its own bank account and thus each wants its own Paypal account. It would be easy for me to build the application so that each entity has its own specific member registration form. I could then put the correct Paypal Email ID in each form. Based on the fact that each
update creator's entry via email/webhook?
hi via workflow customers receive entry data in manner "if this than that" and via email they can reply "accepted" or "rejected" in email subject / message body there is for identification unique zoho creator's entry id how can i via customer's reply update currect entry status? first variant - work with reply email and via entry id update entry second variant - i can make email-to-webhook and via webhook update entry question - is there any possibilities in updating zoho entries via email / webhook?
hi i want to crate XML api ,Please help
i am new to Zoho, please tell me how can i create XML Api to add records in zoho creator i refere links "https://www.zoho.com/creator/help/api/xml-rpc-api/zoho-creator-xml-rpc-api.html" but using above code it gives error 8293 -form name invalid please help
Custom Image / Icon and Header Text for HTML Views Without Having to Custom Code the Entire HTML View
I worked out a way to add custom icons/images in the header of your custom app/html view. So when you create a webtab in the CRM your custom app looks just as professional as the standard zoho apps I.e. Potentials, Contacts etc Here is how to do it. Create a HTML View and embed the associated Form View. Add 2 div tags before the div tag with the main zc-component, and you have your own custom header. Note you have to set zc_Header param (shown in example below) to false so there are not 2 lots
Issue with gmail and sending form data by email
I have a form that can accept data by email. So I decided to test the Form Alias Email ID. In gmail I set-up the form's email for forwarding. Gmail requires verifcation of this by sending an email with a code. I had assumed it would arrive in the form where I could find the code. It never arrives. Just to make sure, I set-up forwarding to another email account I hold and the verification code arrived instantly. I'm suspecting that ZOHO email servers are misdirecting or blocking this email. The email
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"
Next Page