Inserting Notes Under Reports within a Page
I'm having trouble finding a way to add a note under embedded reports within a page. I'm familiar with adding notes within a form, but there is no form builder that I can see for pages. Any tips would helpful. Thank you
date flied multiple selection of days
hi i cannot figure out how to set the date field in order to allow multiple days selection and then sum the days selected into another number field any help or guide
Group Creation is Still Broken
I have reported this a couple times and it's still not working. Maybe because we have the old enterprise account? So I want to make a new security group Next I click "Choose from contacts" Note that there are no contacts. However I do have many users This makes it very difficult to manage security. As we have paid you $1000's over the years I think this bug should be fixed right away. Thanks, John M Whitney aka buzzap
Enable Email Notification missing?
I was able to tick this option for my previous forms. However, I do not see this option anymore. Please help Zoho / Zoho experts :) Many thanks.
Changing drop down lists
I changed a drop down list item, added a word and now it does not display on any of my views. When I edit a record the old text appears. What did I do? I thought I was globally changing the field display.
ZOHO CRITERIA in Zoho Creator
Hi, Is there any ZOHO CRITERIA function in zoho creator like zoho reports? I want to filter the records dynamically in pivot chart based on some conditions. Kindly assist me. Thanks Satya NHM
add date as a criteria in pulling records
Hi, How do you include a field in a form that is part of a "for each x in AssignedSites.sort()" - AssignedSites is a result of a list created by another "for each statement". I want to add a date reference in the for each statement to pull put dates within a range. Here is the code for each x in AssignedSites.sort() { xx=AssignedSites.size(); ThisSite = Customer_Info[ID == x]; ThisInspection = Inspections[(ID == AssignedSites && (Next_Inspection_Due <= Next_Inspection_Due.addDay(input.Fire_Inspection_Range)))
Combining single line text fields and autonumber field
I'm in need of combining 2 single line text fields and 1 autonumber field into a new field. The single line text fields just need to combine the first letter from each field together with the full auto number field. Example: Text field 1: Ext Text field 2: New Autonumber: 1234 Combined output into new field: EN1234 I found this example on How Combine 2 fields into One. But is is only part of the solution, I'm stuck on pulling the first letter only from the single line text fields. https://help.zoho.com/portal/en/community/topic/combine-2-fields-into-1
Report using 2 times the same form
Hi, I would like to build a report which uses 2 times the same form with different criteria. I have Form A with a one to many relationship with Form B. I need a report which extracts rows from Form B with certain conditions, that are linked to Form B (via Form A) with other conditions. Not sure if I am clear enough. Basically, in the report builder, I would like to see 2 times the same Form. I can't find a way to do that. Any idea ? Many thanks !
How to change admin ID
We want to create a specific new ID for managing all software stuff including zoho apps. I have made a Typo error in the email id while creating Zoho creator account. Now i want to get my receipts and change the ID too. Fortunately i have created other users so usage may not be the problem. However I need to change the admin ID for communication needs. Even if i choose forget pwd option, a mail will be triggered to non-existing email which is of no use. How to do it? regards Mukunth
Summary of courses per individual
Hello I have multiple entries for individuals showing courses they have completed. I want to show a summary of this using the learners detail and then a list of the multiple entries on the same summary page. I would like the details of the learner and then a list of all the course entries to show on the same page in the summary.I can only get a summary with one entry per page. thanks P
wmsbar.js script stopped
I get the following message when trying to work in Workflow>forms>deluge tasks. Tried the obvious restart etc. Using Firefox.
Is there a way to get rid of box-shadow on embedded form
I'm using the professional theme and the embedded forms come with box-shadow around them. Is there any way to remove this ? Been playing around with css but no luck.
how - move old entries from creator to zoho reports database?
hi need to move entries older than 30 days to zoho reports database there is synchronization in place i need exactly move functionality as scheduler in zoho creator oк zoho reports
Dynamic Lookup
Hello All, I am attempting to build an estimating application. Within this application I need to have a 4 level lookup filter. For example, the user selects the material dropdown which filters the type lookup which in turn filters the description lookup which in turn filters the size lookup. How I am attempting to achieve this: The Material field is a dropdown list. I have a form (L2 Descriptions) which stores both the Material information and the Type information. I have a lookup field called
Creating a lookup field
My organization is comprised of divisions, corporate branches and an entity called TELF. Divisions contain portfolios, which in turn contain programs. Branches contain business units which contain groups: Divisions Name of division Name of portfolio Name of portfolio Name of division Name of portfolio Name of portfolio Name of program Name of program Name of portfolio Name of program Name of division Name of portfolio Name of portfolio Corporate branches Name of branch Name of branch Name of business
Fetch Record using Auto Number Field
Hi there I am new to Zoho and have successfully used the 'fetch record' to get fields from one form into another using Set Variable BUT, I am trying to populate a form using the AUTO Number field in the Fetch Record script., but it won't work,. I have made it work by using the ZohoID, but this is a big number, and would rather use the auto number which starts at 2014 here is the script that doesn't work (where incident ID is the auto number field ) IncID = Report_Incident_or_Serious_Harm[Incident_ID
Showing image in a form
Hello I have image field. I want to see my image in form. i did what you written before for this issue in the form but link is broken I am really bored help me out. My Code is "Resim" is image field in "Product" table Plain is Addnote field in my Form Urun is lookup field from Product I fetch data Image = Product[ID == input.Urun]; Picted=Image.Resim; imageUrl=((("http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Picted + "&sharedBy=" + zoho.adminuser) + "&appLinkName=") + zoho.appname)
API Criteria &&
I am trying to view & update through the API. It states that I may use criteria. I can get it working fine provided there is only a single criteria required, however I am trying to do this with 2 & 3 crtieria that must be met prior to the activity being undertaken. Specifically the API documentation states for multiple criteria - Example : (Name == "Jean" && DOB == "20-Jul-1981") So I have built this into the JSON array I send. It appears to be reading it and trying to act upon it but is returning
Join Creator and CRM
Join Zoho Creator with CRM Hi, I made a webform using Zoho Creator which I inserted on my webpage. Is it possible to save/duplicate the records from Creator in Zoho CRM?
urgent - old entries left report
hi everyday use reports today in one of report - old entries do not appear, but new added entries - appear well what was wrong? may be fault in internal programs?
Como hacer un reporte con muchos formularios? / How to make a report with many forms?
Quiero hacer la consulta a un cliente pero a la vez me tiene que mostrar los registros de los formularios que esten vinculados a este. I want to query a customer but hang time has to show me records of forms that are linked to this.
creating a summary field from another form in a report
not sure how to explain this, but here goes: I have a form called Items. Items contains two fields: item_name and item_price. I have another form called Master List. Master List contains a number of fields, one of them is a lookup to a third form called Room. Master List also contains a lookup field to the Item form, retrieving the item_name. I wish to create a report on Master List, grouped by Room, that shows the individual rows and gives me a total of item_price. However,when creating the report,
Conditional form feeding web-to-lead
I have a web form that walks users through a series of questions and essentially records the answers in their web session. Once they have finished, if they pass all the criteria, they are presented with a form that allows them to input name, email, phone and submit. The submitted form comes with the answers to the questions in the form of an email. Is there a way of doing this with zoho creator, or other means of doing a more conditional web-to-lead form?
Error Message when changing expression in formula Field
7I am receiving this message when I change the expression in a formula field. What is intended for it to say?
Added_User not returning a name but a "numeric string"
I have several portal users who are inserting records into a table. I need, for an email, to list the users along with the records they have entered. I am trying to find the users with the following statement (or nearly). UserList = Table[TableReference ==SearchReference].distinct(Added_User); I have also tried UserList =( Table[TableReference == SearchReference].Added_User).getall(); with the same result. What I get in UserList is a 'numeric string' - looks a lot like a row reference ID to a table
How to remove item from picklist which have been selected in previous entries in a subform context?
Hi! I have a subform with two fields: Item and Qty. Item is a dynamic picklist. I need to remove item from the picklist every time I add a new row. I'm stuck as I cannot get the picklist to work. Here is my code: \\This part is where I count the number of entries in my subform\\ On Add Row for each recA in Collection_Tracking { recCount = 0; for each recB in Collection_Items { recCount = (recCount + 1); } } \\ \\ \\UsedList is a List variable updated with a Multi-Line field
Create relationships between two existing forms
I have two forms with existing data in them. They are not linked; one is master and the other child. How can I link them together with a key to foreign-key relationship? Thanks!
How do i change for new pricing plan?
Hi, I am on the "old" pricing plan. How do i change for the "new" pricing plans: https://www.zoho.com/creator/pricing-comparison.html Kind regards Bo Thygesen
Decision Boxes Aligning Right
In one of my Applications, as of three weeks ago, all of the decision boxes starting aligning to the right of the form. All other applications have remained to the left. Is it something to do with a new setting I have missed? Can anyone shed any light? Thanks
Can not delete field / form.
The function getUsersTeam did once exists, but was deleted long ago. I continue to receive this error.
Publish URL?
All, I have a free Zoho account and have created a one-form application and would like to make it available publicly. According to this help page, https://www.zoho.com/creator/help/forms/publish.html, the Publish URL button should be available for me app. However, it is not - neither it nor the Embed URL buttons are available. Would you please help me figure out how to publish this app? Thx.
href help
Hi, I am trying to hyperlink a text "Website" with the URL . But something is wrong with my script so I am getting below result. Script : input.UPM_links = "<a href=" + TV_Station [ID == input.TV_Station].TV_Website + ">" + "website" + "</a>" ; could any please help me Thanks Arfater
Mandatory Field
Hi, I generated ID field is in Single Line so set as a Mandatory field.Its working no pblm but i want change that error line For Ex: Duplicate value found for "ID" how can i change this text .Its possible or not Please reply me immediately. Thank You.
Question share from list / consulta compartir desde lista
Español: Buenas me gustaría saber si existe la Posibilidad de compartir por medio de una lista armada . Espero se comprenda la inquietud y disculpen la traducción. Ingles: Good I wonder if there is a possibility of sharing through an armed list. I hope the concern is understood and excuse the translation recordUsers { email={user1@tes.com, user2@test.com........} (String) } recordItemShare { type = {"section, form, view, page"} (String) nameObject = {"form1, form2, section3, list1......"}
Export a Form to be used as a template
Good day, Could you please tell me how do I export a Form to import as a template in other application? If I create a New Form with the template option only the current app forms will be displayed, but I have my form in other app. Best Regards,
Cannot customize mail notification
In form builder, I cannot customize the mail notification. When I click the link to do so, I get a blank page. Please help!
subform suddenly broken, need help please!
Hello! I’m having a problem with a subform in my application that suddenly started behaving strangely. There are four fields in the subform that are not working now. 1. 1. Event Name is a text field that pulls from the master form in which the subform is embedded. 2. Event Date is a date field that pulls from the master form in which the subform is embedded. 3. Event Type is a dropdown that pulls from the master form in which the subform is embedded. 4. Site ID
Url Image Field Deluge Update
Good day, I have a product catalogue, each item have a Url Image, I want to update the Url Value with Deluge when every new product is created, I use the same syntax to feed a url on a plain field but in the Url Image field nothing happens. iniciolink = "<a href="; mediolink = (" target=_blank>"); finallink = "</a>"; thumblink1 = "http://www.zhingenieros.com/zoho/productthumbnails/"; thumblink2 = ".jpg"; thumblink = thumblink1 + "1" + thumblink2; input.Image = iniciolink + thumblink + mediolink +
How to create a report that shows items with zero dependencies?
I am trying to create a report that has two tables (forms as they're called in Zoho), one table is Stores, the other is Accounts. The Accounts form has a field has a foreign key from the Stores table. How do I create a report that shows me how many Stores do not have a foreign key associated with data in the Accounts table? The MS-SQL equivalent of the results I would like to see in the report would be: SELECT s.Store_Name FROM Stores s WHERE s.Store_Name NOT IN ( SELECT
Next Page