How to fit an old database form into a double layout format?
Have an old database form in triple layout, which I would like to recreate using Zoho Creator, but since Zoho only has a double layout, I'm trying to find ways to make it fit. I've enclosed an image of my old form and under the word 'TEST' under each column, there are construction codes with boxes next to it to insert the amount (numbers). Can you guys help suggest a way to fit all that into a double layout form?
Managing an embeded from width in an html page
Hi Zoho! I have a list in my html page, and I'm using a form embeded in the page so the user can filter it. how can I set the form's width? I've adjusted the field's name width and the drop-down width in the form's properties, but it looks like there is a lot of space to the right of every form and on the buttom also (I've used float:left" to set them one by one). I've tried to use "Width="20%" etc. but it did not help.... (I've attached a screenshot to make it clear) Thanks! Ravid
How to create a Page
Can anyone provide a simple explanation as to how to insert individual field from a Report into a Page? I just want to create a Page similar to a Word document's merge function.
Passwords
I have a few ZOHO Creator databases. I need to change my password on all of them, but not sure where to find that option.
Data Analyzation Capabilities
Hello, Is possible to build an app that will allow me to upload all of the parents at my school and track which parents have and have not completed the form on a dashboard? I am not a developer but I will attempt to build the app if this is possible. Thank you for your help.
Moving App components into another App
Hello all! Very ofthen I need to move forms (with data, views etc), functions and schedules into another app. Now it's really hard to do - you need to make so much operations by hands. I'm the only one? Or someone else also wants feture: right-click and select "Move to another app"?
Fetching Contact IDs from CRM to Creator
I want to create and make updates to Contacts in Zoho CRM through Creator forms. So that if the form is filled out and submitted they are added to our Contacts in Zoho CRM or updates a Contact already present. For updates, I need the Contact ID from CRM. How can I fetch the Contact ID from Zoho CRM to Creator and provide it in the update Deluge? Or can another identifier be used to verify if it is a new contact, i.e. email address? The fetch record instructions seem to only give me help with fetching
How to give update Email Notification in Zoho Creator Application.
Hi dear friends, I need to know, how to give update Email Notification in Zoho Creator Application. Exact Scenario: I have Agenda Live Form and Agenda Live Report form In my Agenda Live Form, I have "Enable E-mail Notify". And I am getting Email Notification perfectly. But, when I am "Updating" the records via Agenda Report Live form on "Edit" mode. Update is successfully happend in Agenda Report Live form. But I am not getting update Email Notification . I have already given command "Enable
Insufficient permissions when exporting on Windows 10
In Chrome (as well as other browsers) I am unable to export data. I get an error message. It works fine in Mac/Windows7 with same user account. I am able to download other formats like pdf. I am an admin on my local machine. I can also download from other services like dropbox. Here's the header information for both Request and Response: POST /downloadExportData.do?filterVal=FY%3A2016%3B HTTP/1.1 Host: creatorexport.zoho.com Connection: keep-alive Content-Length: 164 Cache-Control: max-age=0 Origin:
Update CRM Qty in Stock based on ZCreator subform
Hi, I went through the CRM update record tutorial, but wasn't successful in creating what I need. I created a form "Store_Records", and a subform "Store_Items", in the subform there is a CRM field related to products to select a product from CRM and a number field "Issued_Qty". I need to update the "Qty in Stock" under CRM module "Products" based on the issued qty for each selected product. Example: If I select 3 items type A, I need to subtract 3 from the current Qty in Stock in CRM. Need to do
Can't get into any Creator databases for two days now
Suddenly, I cannot modify any of my 9 databases. I can see the data but can only SEARCH. If I click on SIGN IN, and I successfully sign-in, nothing changes. I still only can search. Without being able to get into the databases, I cannot get into ACCESS THIS APPLICATION (?) so I can't make any changes to the format or fields or try to see what the problems are. PLEASE help ASAP.
simulate submit
I have a decision box in a form that generate in a new window the pdf file of the record summary. If the user modify a single line field in the form the pdf will not take that modification into account without the user submitting the form (thus closing it) and then re open it. I also put a pdf field in the view so the user can genéerate the pdf as a custom action also but the goal here is to have as few clics as possible. How can i generate the pdf inside the form and take into account any user input
Search Box in Reports replaced?
As recently as a couple of days ago, all of my Reports in Zoho Creator had the search box pictured in the screenshots attached to this message. This search box made it extremely easy to rapidly search all of the fields in the Report for relevant information. This text box also had a little dropdown built into it in case the user knew exactly what column they wanted to search and in what way. Inexplicably, this extremely simple interface (which has the word 'search' on it) has been replaced by a wordless
Translate ZC using Google Translate
Hello ZC Team Here is something that may help in translate interface problem. Is it possible to use in a html view this script code made available by Google Transpator?: <div id="google_translate_element"></div><script> function googleTranslateElementInit() { new google.translate.TranslateElement({ pageLanguage: 'en', includedLanguages: 'pt' }, 'google_translate_element'); } </script><script src="http://translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
Need to add rule to user, but i cant
Hello everyone, I need to add a task to a user so he can make changes only on two rows on any report published, the user cant add new reports, just edit and change two options on the report. the user is added and configured as user... Ive created a rule that could block almost all the report and let edit only the two rows i wish. But its works for admin also. Ijust want the rule to the user and there is no option as appear in this tutorial: https://www.zoho.com/forms/help/adding-rules.html#Form Im
XPath Builder throws error on valid JSON data
I'm importing a valid JSON feed (checked at jsonlint.com) into XPath Builder, and it loads the XML Node Tree fine. But when I select a node on the tree to execute it gives me this error: Invalid XML/JSON format javax.xml.xpath.XPathExpressionException What might be going wrong? How can we fix it? Thanks.
Can a deluge script run on user input in a form?
I have an application which creates a form Temp_Inv that is used to input monthly inventory & orders. at the end of the month, the following fields are exported to a form Month Summary be added to the Inventory form: Item ID Yesr Month Inventory Amount Order Amount All records in the Temp_Inv form are then deleted and new records are exported from the Products form. I want the Temp_Inv form to have fields Last Inventory and On Order which would be the values in Month Summary
What is wrong with this code?
I have a form Month_Status, with fields (among others) MD_Serial, Inv_Amt, Order_Amt. I want to update form Temp_Inv for correspomding MD_Serial. I have tried: for each y in Temp_Inv { if(Month_Status[ID == y.MD_Serial].count() > 0 { x = Month_Status[ID == y.MD_Serial] y.Last_Inv = x.Inv_Amt y.On_Order_Qty = x.Order_Amt } } and for each y in Temp_Inv { if([Month_Status.MD_Serial == y.MD_Serial].count() > 0 { x = [Month_Status.MD_Serial == y.MD_Serial];
Can I pass parameters to a checkbox field in embedded Form in HTML pages?
I want to pass parameters to a embedded form inside a HTML page. I know it is possible using the params attribute like this: <div elName='zc-component' formLinkName='MyForm' params='Number_Field=<%=var_number_value%>'> I want to do the same with a checkbox field, but I'm not being successfull. I works like a charm If I access the form directly passing parameters to a checkbox field through the URL: openUrl("#Form:MyForm?Checkbox_Field=value1%2Cvalue2%2Cspaced%20value", "same window"); But it doesn't
3rd Level Relationshiip
Hi there I have a "Course Instance" form. I have a "Booking Header" form. I have a "Booking Details" subform on the "Booking Header" form. On the Booking Details subform, there is a lookup to the "Course Instance Form". My question is, can I display the "Booking Details" records on the Course Instance form, linked by the Course Instance ID? Thanks Aaron
Filter report by non year specific month
Hi I have an application which includes a dropdown field to select which month the service is due on that record, what I would like is a report to only show the records that the service is due this month and next but the only way I can do it seems to be with a hidden date picker which is updated by the dropdown and then updated regularly via schedules to update the year but this is a very long winded way of doing it and it's susceptible to all sorts of issues... There must be a better, simpler way?
Pulldown, how to populate with string from another pulldown
I have 3 forms. 1 - Products (just a product name) 2 - Batch Record (year, month, day and pulldown of product name) - creates a LOT # 3 - Batch Ingredient (Lot #, ingredient name, and weight) My problem is on form 3 (batch ingredient) I want the pulldown to show LOT number and the product name. I can only get it to populate the pulldown with the LOT number and product ID (BatchProduct). How do I convert that BatchProduct ID to it's string name, to populate my pulldown? I was trying this must
Page with Form and Report with data entry refresh
Hello, I'm trying to make a simple page with a form for data entry and a report. I would like that, after pressing the "submit" button, the underlying report updated, showing the new newly inserted record. Someone can give me a hand? Thank you!
ADD NOTES FIELD IN ZOHO CREATOR
Good morning,In add notes field of zoho creator,I am unable align the text centre even I click the align centre icon.Kindly help me.
Change of email address
How do I change my email address michael.macmullen
CTI click to dial through hosted IP
Hi, i really like the like and feel of Zoho but it's important to me to be able to do click to dial from the crm. Is it possible to have CTI with a hosted IP telecom setup? I understand you can use PhoneBridge but only with a physical PBX system which is old news now considering more and more businesses are using Hosted IP any information would be really helpful Thanks Antony
How do I add a help text to a field?
I've created a new form that requires more explanation per field than I can squeeze into the Tooltip Message. Any idea / examples?
Moving Company App
I am making an app for a moving company I need help I have list with customers that i can add different ones now for the 2nd part i have shipments and i want to create something like an order you would add to a customer into that order i add Crates with specific barcodes and i add a location so kinda like How can i make it so when i click the customer in my report and it would list like all the orders i created for that customer in the report?
Importing Zoho Spreadsheet to Zoho Creator
I'm trying to create an app from data in a Zoho Doc spreadsheet. When I go to import it I get this message: But my Zoho Spreadsheet is not more than 70 columns, it is only 35 columns wide. Any idea why this won't work?
Record Fetching question
Hello, I have tried looking at examples \ videos etc... I am just still not getting on how to accomplish what i am trying to do I tried looking at: https://www.zoho.com/creator/help/script/fetch-a-value.html#Example_1 Maybe someone can be kind enough to set me in the right direction. My Example: I have a form with products and price, I have another form which fetches my products - this part I got working now my problem is that i want to also pull price onto the same form based on what product was
Use criteria in "for each" task when using a subform.
Hi Zoho community, I have a "for each" task for sending an email to every row in a subform. On Add it sends an email to all the rows, which is ok, but, On Edit, I need to add criteria in order to send mails only to the rows that where recently added or modified. I have been trying with the code bellow but no success so far. It seems its not possible to use criteria like this when using the task for a subform. for each R in input.Chequeo [R.AddMod = zoho.currentdate] { sendmail (
Zoho creator crashes
While reporting in Inspections, I have the following concerns: Most important, the app randomly crashes during use @ any given time, I could be waiting for a score to calculate, or go out of app to look at some notes I want to add to the report & come back to the app resetting itself. I can only add 2 emails under client at a time, when I may have to send it to 4 at a time, so I have to forward it as a PDF & cc the 2 clients listed in the app so they know I forwarded it to everyone else. I can not
Multi Dimensional list
Hi I am seeking a small help i have three forms where one field is named as Date. I need to display the data in a html page, combining all data from all three forms sorted by date field Kindly help me with a solution on how to do it Thanks
Limit number of entries per radio button option
Hello - Is there a way for me to limit the number of entries for each specific radio button answer? For example, we have a registration form where people register for a specific 1 hr time slot. We want to allow a maximum of 10 people to register in each time slot and then disable that option. Thoughts?
using Zoho fields in Rich Text possible?
Hi there, I want to use a rich text in a form, where the user can also place zoho fields. The value of the field should then be rendered in the rich text or in an output. Is this possible? For example, if the user could add something like "Dear {!Customer.Firstname}" within the rich text, then I want to be able to render this in an email stating "Dear John" in the email body. Anyone experience with this? Thanks in advance, boudewijn
Zoho AppCreator
Just learned about this new Zoho Product and already have a ton of questions for which there are no answers available in the community. I thought it would be appropriate to create a new AppCreator topic. 1. Can I whitelabel apps i create for iphone and android with my company names/logos instead of Zoho branding graphics? 2. How is AppCreator different from building an app in Creator and sharing it on the Creator Mobile app? That should be a good start for now.
Zoho Creator Sending Additional Emails to Select Database Member. Why!?
We use a script that sends an email out to each member in our client database IF 1) it is a new member OR 2) if we physically select a checkbox that instructs the script to email an update status to a member. (Be aware that the update select button mentioned is reset after every use, thus, it must be physically reset with each update.) However, as of yesterday, indeed, each member updated receives the email, but in addition, and most incorrectly, one particular member, newly added as of yesterday,
Design Question
I have an Service App with several forms. As a service company, I need a way in insure dispatching is done properly.I was thinking of "Zones" based on Zipcodes.(EX 29653 = SC01). My Zipcodes and Zones are both in a dropdowns on the Equipment Form. As new equipment gets added to the database, when a Zipcode is added, the Zone also gets added automatically. I have tried using the If statement; if (input.zipcode == 29653) { Zone = "SC01" } But that would mean I would have a great deal of "If Statements"
Update a Lead record by specifying it's id
Hello, I tried to create the same App given in Example 1 But using the given code return the following Error: Error at line number : 4 Mismatch data type for function zoho.crm.updateRecord at argument index 2 expected data type STRING found dataType BIGINT
how do i create a soap/xml envelope
how can i create a soap envelope of the following form, to send to an external api? <?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<CreateNewProduct xmlns="http://example.com/">
<Login>string</Login>
<Password>string</Password>
<SKU>string</SKU>
<ProductDescription>string</ProductDescription>
Next Page