Tip: How to work around issues of a Lookup field when it's definition includes appended child fields
When using the very nice feature, in a Lookup field's definition, of appending child attributes, such as Property_Name + ", " + City + ", " + State The result in the dropdown is a NICE combination display that really helps the user identify the correct choice. And, the appended fields are even included in the search-as-you-type. However, the result on Reports is not necessarily good, because that combination is always shown as the field's value. (Or if you use field.name it is not clickable to
Reports
How do I make the records in a report that I share with users not editable by them?
search open url new window and headers
I have created a search form using a stateless form with the following on click: openUrl("https://creator.zoho.com/<myapp>/customer-support/view-perma/Customer_Report/Customer_Name=" + input.Search_Customer, "new window"); Three questions please: This works ok if same window is used. Using new window gives no result - how do I overcome? When I use same window and I get the Customer Report results there are no headers (i.e. dashboard tabs) and I need to use the back button on the browser. How do I
How to reload a page with deluge
Dear all, I have an HTML page which consists of a form (embed form). This form has a lookup field. I would like when I choose something in the lookup field then to reload all the page. Is it possible to do that? If yes, what can I write in the on user input of the lookup? I found that I can use the Navigational URLs. But I do not know if I can use the #Script:page.refresh Furthermore with the usage of reload; in the on user input it reloads only the form
Send email from a fileld
Hello, I'd like to know how can I send a mail from a fileld in a different form. I have one form to customers register and another form to sales. My ideia is send a mail each new entry on sales form. Thanks a lot! Iedo Brazil
Adding text fields to choices in checkboxes
If I have a Field with check box choices, can I edit the choices so there is another field? For example, if the check box choice is "other" can I add a field for someone to write in what their other option is? Similarly, if someone checks the check box "Food" how would I create a text field that allows them to type in information about that food specifically and elaborate
My first application in zoho.creator
Hello. I downloaded mail-merge-contacts application but i can't edit this in my control panel. Why ? I need application like this ( https://creator.zoho.com/public/showAppInfo?ownername=fmriorum&callbackUrl=mail-merge ) to realize that idea: User fills out the form and then script produce specific letter with specific blank from form like this and this file we can download in .pdf or .doc. Thanks !
Current month in Report-Pivot-Chart - filter on the current month
HI, let assume I have a table with the following fields: Date (date); Quantity (integer); Should be possible to create a bar graph with: on axis x the date; on axis y the sum of quantity for that date; a filter on the current month? tks, pippo
RSVP Form with multiple conditioned pages and access code
I'd like to set up an RSVP form which initially lets users input a couple entries (their name and whether they're attending). At the bottom of this page I'd like them to enter a code so that I can verify only the people who have been invited are rsvping. If they enter the code wrong it shouldn't let them submit the form. If they enter the code correctly, I want them to be directed to a second form that is conditioned on their answer to whether they're attending. Is this possible? Thank you!!!
using Jquery
how can i Use jquery in my html web pages. actually i have developed an html page with jquery effects in zoho creator application. but the effects are not loading . is there any other way of including the script for jquery in zoho or zoho doesn't supports the jquery effects in application's html pages.
Select from lookup only entries associated with previous lookup
I have a two lookup fields in my Projects form. The first is Customer, the second Customer Contact (Customer Contact is a subform of Customer). In the form definition I have this code: Customer ( type = picklist values = Customer.ID displayformat = [ Customer_Name ] allow new entries = true [ displayname = "" ] sortorder = ascending searchable = true width =
New added currency NIO is misspelled only in help pages
For the sake of accuracy of the help pages , it's Nicaraguan Cordoba , NOT "Nicaraguan Cordobo..." Thanks Alfredo Hire an Expert Certified Solution Provider Zoho Creator Certified Developer Servicios Comerciales CASE SA / Certified Solution Provider casemx@sccase.com.mx
Cannot create new in Admin Panel
hi Zoho, Now, i created successfully 17 email accounts. But now, cannot, it show Sorry , we are unable to process your request, please contact support@zohomail.com when creating new email account
One payment for multi zoho services
Hello I don't know if there is way to pay one time for different services , I have to pay for Books in different area than Creator than Email ..etc. need one page to pay multi services ! Thanks
Cannot view images
Hello, We have lost our images- just get this: <img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/1434629830485_Screen_shot_2015-06-12_at_10.30.34_AM.png&sharedBy=rachelogg&fieldLinkName=My_Pic'/> Please let me know asap, thank you
How to edit this list ?
Hi How to edit Edit list , for image below I want to edit list to make it Print only instead of Edit, Delete ...etc. Thanks
Record Limit Reached - Innacurate Count
I have a custom plan that includes a million records, i received an email stating that i had reached my limit, i have added all the records in my applications and they do not add up to 1.4 million which is what my limit screen shows as being used. I tried calling support and sales and got a voicemail on both, can someone please explain to me what is happening here? Thank you.
Email Sender in Zoho Creator
Hello. I would like to change the email sender of an email that's sent from Zoho Creator. I added a user with the wanted email address, put him as administrator of my application, and as primary contact. It still sends with the first email. How to change that ? Thanks, Guillaume
Open Calendar Report as a custom action?
I have a Vacation Request report, which is in summary form and has two custom actions to allow for approval and rejection in the report. I have another report which is in Calendar View. Is it possible to create a custom action button in the Vacation Request report which will open the Calendar Report? Thanks in advance!!! Joy
Dropdown lists - how to filter if it is not a lookup
I have two dropdown fields: Location and Department. I would like the Department dropdown list to display options based on whatever is chosen as the Location. Is this possible? As always, thank you in advance!
Filters
I have created a delivery tracking application. In the view i just get option of selecting one filter where as i want to filter on 2 parameters. How can i do that? HS link2hs
Is it possible to access data in another application?
Dears, I want to build new application, which would work with data stored in existing application. Both applications will belong to same user. Is it possible? What is the format (deluge script) for fetch, insert and delete records stored in another application? Thanks in advance!
Dynamic picklists with dynamic filters
Setting a filter on a picklist is a really easy way to dynamically filter results, as other picklists are chosen. I have a number of criteria picklists which narrow the search results of a final picklist. I have the following Status = Active Activity_Type Location Site_Name Equipment (Which contains the list of equipment, which have the above 4 criteria) So my filter looks like: values = Equipment_Record[(((Status == "Active" && Sites.Site_Name == input.Site_Old) && Activity_Type == input.Activity_Type)
URGENT! View criteria not saving
Hello, my views have lost their criteria and I have tried to add criteria in both the edit this application and on the main view. I keep getting the error message: FAILURE:Error occurred while saving the view. Kindly refresh the page and try again later. Please help!! Thank you
'BIGINT' data type
Hello, 1. How can I fix the problem in the following code? if(input.Shipping_Value != null) { temp = Shipping_Value[ID == input.Shipping_Value]; input.Product_Cost_Shipping_Method=temp.Shipping_Method; } The message is: Error at line number : 5 Variable 'Product_Cost_Shipping_Method' is already defined of data type 'STRING' but trying to update 'BIGINT' data type. Thank you
If else code with Improper Statement
1. Hello, Please take a look at the simple If else code and tell me what is wrong: if(input.Product_Cost < 10.00) {input.Shipping_Value.toString() == "Under £10";} else if(input.Product_Cost < 20.00) {input.Shipping_Value == "£10 - £20";} else {input.Shipping_Value == "Over £20";} Shipping_Value is a vlookup field and Product_Cost is a currency field. The message is: Error at line number : 2 Improper Statement Error might be due to missing
June 8th Update Removed Formatting on Calendar Report?!
I have a Zoho Creator Application, which has been in use for a year and a half, that tracks Email Marketing Campaigns. My team uses a Calendar Report to help review the scheduling of past and future campaigns, which occur multiple times per day. The name of each campaign, that is displayed on the Calendar, is generated from a formula field called "Calendar Name", that combines a couple pieces of information along with a 10px by 10px jpg. or gif. of a solid color, which was uploaded to the application,
Wordpress - Zoho Creator Plugin - Loading
When I add a Page in Wordpress - Edit, press the Z button it stucks on loading... any hint? tks
Images showing in Firefox but not Internet Explorer
Any idea why images would show in Firefox and not IE? I had no idea this was an issue because I use Firefox but some of my employees use IE and can't view images. I logged into Zoho in IE and I can't see the images either...so it isn't a permissions / share issue because I can't view them either.
Authorization failed - Adding record by mail
Hi! When I am trying to add a record using mail, I get this reply back. How can I fix this? Authorization failed You are not authorized to add record. ............................................................................................................................. <XXXX@XXXX.no> wrote : Hele navnet ditt : XXX XXX XXX Adresse 1 : XXX Adresse 2 : Din e-post : XXXX@XXXX.no Post nummer : NNNN Sted : XXXX Ledsagers hele navn : YYY YYY YYY ------------------------------------------------- This
How to hide a Section with deluge
Dear All, As we know to write deluge code we use the Form Link Names in general (as inputs etc.). As I can see, when I create a section there is also a Section Link Name. Can I write deluge code for the Sections? As an example, is there any way to hide a section with deluge code in a form?
Zoho Creator Add Llead to CRM or update Date Created field if lead exists.
Our zoho creator application currently adds a new lead to zoho crm when a lead is added to zoho creator. We have a major problem where some leads already exist in zoho CRM and we are ending up with a lot of duplicate leads. The feature in zoho creator where it automatically detects duplicate leads and updates the records is good but our trouble is these leads do not move to the top of zoho crm lead list. Because of this we dont realize that a lead is requesting something from us again. It seems
Does anybody have experience of integrating TAPI phone systems with CRM?
Phonebridge does not do this. Thanks!
Calendar views are broken
Yesterday ZOHO rolled out a change to the platform that has BROKEN the calendar reports. The current week's events are showing as very small boxes that do not fill up the space between the start and end times. And it is not possible to click to the next week or show the monthly view. We need this fixed URGENTLY as our staff cannot book clients and manage their schedules. PLEASE roll back the changes that messed up the calendars! Anton
Relationships question again! Should be easy for you experts
I am working on a database to track links between people, places and organisations. Form 1 is object which has one field - name Form 2 is link which has two fields I want to relate to two objects. An object can have MANY links. So I'm trying to make a ONE to MANY to ONE relationship. I want to be able to create links from either an object form or a link form. I want to be able to show reports (lists) of links I want object reports to also show the list of links they have so: I have set up
Lead is not updating?
here is my code to update leadupdateinfo = zoho.crm.updateRecord("Leads",input.Company ,{ "Company" : input.Company, "Last Name" : input.Last_Name, "Email" : input.Email, "Phone" : input.mobile }); no error but not working. in Id=input.Company is not fetching the current record id?
how to update a record in zoho crm from zoho creator?
help? i am confused where to write the logic?
how to genarate a Account in zoho Crm if user entered details in form(zoho Creator) and vice versa?
i want to entered details(with automated process) whenever a user enter details in form (from zoho creator) that should be added to accounts in zoho crm.
how to retrieve zoho crm data?
i have one statelessform name "search" in which i have username a single line text and one search button. when i entered a valid username it search the data and display in page(html page). but i need to add related field data as well. from where i am searching i have one field account name(ZohoCRM) i wnat to fetch account details as well how?
Task Scheduler Sharing/Reminder
Hello, I was wondering if zoho creator can be built to send SMS reminders to recipients. I am aware that creator provides auto email reminders however not every trady uses a computer. Any help on this would be helpful. Thanks
Next Page