Filter of Checkbox Field Not Working in Reports
I have a Form called Fuel Order. On this form I have a checkbox field called "Invoiced" with two options, "Fuel" and "Freight". When I try to generate a Calendar Report showing only selected records, using this logic: "Invoiced" does not contain "Freight" This does NOT work. It shows all records. I think it is a bug. https://monosnap.com/file/Mq5z8WYfxPbqfLPQhrlc9u6g2XiCiG Any help would be greatly appreciated.
What better way for a veterinary consultation record ?
Hello , I need to create a query form for animals. 1- How do I create queries in the customer file so that the history be stored and has good usability mobile? And may I add the service values at each visit ... 2- How to make two date a form fields appear on a calendar ? I need to schedule more than one procedure but could only configure each on a different schedule. Thank you!
Edit record issue
Hi In one of my form I have a single line field ,that is referenced to some other reports.Now when I go to report settings and I tried to hide,it shows one warning message like "lose the data of that column".I have shared the mockup below,can you please let me know why its happening? Thanks
Zoho creator Not saving changes
Hi Im having issues whit my document in zoho creator when i try ti save something new a message saying saving records shows and stay for a long time not saving my changes. There is anything i need to do to fix it ?? what is going on ??? i already try to log out and log in a couple of times, and also do it into google chrome and safari and still not being able to work.
In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid
I am having a problem with the following code. QBD_Line_6 this is result from a user selecting from a Lookup field QBD_Type is the field that the Lookup field draws from QBD_Cost is the form that all the data is drawn from Cost_per_Pc is a cost associated with each QBD_Type QBD_Value_Line_6 is the field that the cost should display to the user. if (input.QBD_Line_6 != null) { temp1 = QBD_Cost [QBD_Type == input.QBD_Line_6.toString()]; input.QBD_Value_Line_6 = temp1.Cost_per_Pc; } This code gives
Seperator for passing variables via url string
here is my nonworking example (between forms) openUrl("#Form:Client_Form_GC_CL" + "?TZ2CF_Address_1=" + input.TZ2PF_Address_1 & "?TZ2CF_Address_2=" + input.TZ2PF_Address_2, "Popup window", "height=400,width=400"); NOTE the single ampersand does not work as a separator between fields...what does?. Help Please Thanks Larry
There is no such view in Zoho Creator
I am trying to use the REST API to download data. It keeps giving me the above error. Below is the data that is being sent. URL: https://creator.zoho.com/api/zoho_bob191/json/t3/view/GoldMine_Web_Import_Report And this is the data that I am sending to the above URL: <form method="GET" action="https://creator.zoho.com/api/zoho_bob191/json/t3/view/GoldMine_Web_Import_Report"> <input type="hidden" name ="authtoken" value="xxxxxxxxx"> <input type="hidden" name ="zc_ownername" value="zoho_bob191"> <input
Bug in Creating URL's
Hi! I am getting a REALLY weird problem. I have the exact same email being sent to two different people. On one of them the a URL in a link (generated by Zoho Creator) is different that the other. Just a tiny difference. Why? See here: The Correct Link: https://creator.zohopublic.com/jjmancini/fuelorders-v2/view-perma/Stateless_Carrier_Acceptance_HTML/12345YFYyjw1PECxegqWkRMeGHhMCS0u6dYZ61OtJuUR7axhbawj3qPkyW87JpeEP3pCWrH5M4RW7ubQ84658XPFS06jKt6Qj/Order_ID=555539000012469123&Carrier_Reply=Yes&CarrierSCAC=XPER&Carrier_Contact=555539000004748233
Auto email report on form success
I can't see how to email a simple report of a form as soon as it is saved.
Send a report when a form is saved
How do I set it up so that the report associated with a form is automatically sent when the form is saved.
I need some help!
I need some help! I'm new to zoho creator and my manager wants me to create a database system for our business, which our staff can all access via the cloud and edit whilst still being secure. What he also wants is a file for each of our clients which logs all contact with them, their basic information and attached files that have been sent to them. Can this be done with zoho creator? If so how? If it cannot be done can anyone recommend some other software that I could use which would suit my needs?
Email to item feature like Salesforce & Podio etc
it would be nice to specify email to a specific case/item... Mr smith may be 1 person, but we handle multiple cases on his behalf... he emails pictures of an accident to us but also emails in his car registration number for another case... the two emails show together even though they have no relevance to one another in other products they handle this with an email to item address.... have zoho made a decision on this kind of thing just so i know? a final reason for this being important is data protection...
Easy inventor order
Hi, i would like to know how to make an ordering form. I dont want to look for each item from a drop down menu. I want all the items displayed like a report that you can just add a quantity and save it. it would look like this: Date Product - Quantity Product2 - Quantity etc Thanks!
Impossible to Delete
Hi, I'm creating a form in Zoho Creator but i got a lot of troubles with Rules and Task. I've created some rules but i can't delete them anymore and I can't Delete even the Fields. I tried to delete every Rule but the field cannot be deleted. This is the error message. "This field is referred in the following places. Please remove them and then delete this field. Form Rules and its Tasks I would like to upgrade but i really cannot end any form because Every Time I Find this kind of problem! Please
Create a List of Checkbox Choices
I have a form which includes a checkbox field with about a dozen different choices. In a script, I am trying to create a list of what those choices are. I am not trying to get a list of which boxes are checked, but instead just a list of all the choices available. Is there an easy way to grab those values and stick them in a list?
Make columns in an email with a subform
I have a code that allows me to send an email with a subform and add a horizontal columa to all data: Example: Entry.1 = " Precio" "Link" Entry.2 = " Precio" "Link", Entry.3 = " Precio " Link" I would like to make the data in the subform were vertical but when I add the data does not work that are not organized properly. What happens: E1. Precio E2. Precio E1. Link E2. Link I need: E1. Precio E1. Link E2. Precio E2. Link Anyone know how to change my code: Precio = "$"; Enviousd = "<br>"
Email Notification problem
Hi, I'm using zoho creator in my company to manage my data. I try to get an auto email when a user fill a specific form. When I choose to send the notification email on my personal gmail, i can receive it, but when i choose my professional email, i can't receive the email. Do you know how i can solve this problem ?
Is there any problem with the display type in reports?
Dear All, Can you please check if you change the display type of a report from List to Speadsheet or Grid for example (from the Summary Settings), does it change for you?? Because in my reports it does not do anything!!! It still shows me as List!! Example: It shows a LIST
add break page inrecord summary
hello, all in the subject.
How to Create Tel HTML Link in Zoho Creator Report
Hi i'm trying to create a html link so when user see this link is report he/she able to call that number .here is the Code input.Phone_Link = "<a href=\"tel:+" + input.Phone + "\">" + input.Phone + "</a>\n"; The Only Problem is When this Number Display in Report its add the Http Prefix <a href="http://tel:+5566988878" rel="noreferrer">5566988878</a> so its Doesn't work with this Http Prefix its Should be <a href="tel:+5566988878" rel="noreferrer">5566988878</a> Please help solve this issue.
Login
Hello Guys. I am new to creator. I created two applications and i want to create a login page in one of the application that will allow login according to the record in another application. plz suggest me any idea and if possible give me sample code. Regards, Raj
Zoho Creator - Local Backup & Scriptng
Hi, I want to know if I can take local backup of data and app available on my zoho creator. Also to do the scripting in zoho what I need to learn HTML or something else. Also I am trying to build two way communication program in this,let me know how can you help. Please let me know.
How to generate HMTL Code?
Hi all, I am would like to generate HTML Code in Creator. I created a products table in Creator, and I have an html template, which require to put some product information in the html template, just like a mail merge. However, after html code generated in the form, the HTML tags was trimmed. Is there any way which don't trim the HTML tags? Thank you in advance.
bug in Dropdown ?
Hello, i create a form with Dropdown. In dropdown i have as possibility just CHOICE 1. in Script i have for each line in MySubform { ml = List:String(); ml.add(line.SingleLine); } input.MyDropDown:ui.add(ml); I can see in my dropdown all line of my subform. I submit. When i reopen my form the dropdown is already equal to CHOICE 1, all line have disappear !!!! a bug or it's not possible to add new value in dropdown with script deluge ? thanks you
Custom URL for creator app
Hi, I followed the instructions on the page https://help.creator.zoho.com/Zoho-Creator-for-Your-Domain.html in order to verify my domain. I have completed this successfully. I now want to have a custom URL for my app. For example http://example.com/app should redirect to https://creator.zoho.com/username/app. Is this possible? Shaheed
Customer Portal
Would it be possible to to have a system variable that returns a user's Profile Name from the Customer Portal that then can be used to determine the user type in scripting? Is there a plan for Profiles to be included when duplicating an Application? The ability to export a Profile and reload it into another version of the same Application would be equally good. Many thanks!
Edit Record Passing Parameters
Good day this is the following way to edit a record passing parameters could you please confirm how to perform this in form-perma. http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> Best Regards,
Duplicate Record with different information subforms
I have a form with a subform. I want to know if I can make a function that allows me to register, for example: I have: 1 record, with 4 different entries in the subform. I want: 4 records, each with 1 entries subform Delete the original entry. Result: Record 1 With entry 1. Record 1 With entry 2 Record 1 With entry 3 Record 1 with Entry 4 What I want is to separate the original record, to have one record per entry that was in the subform.
Copying values between forms & lookup/editing with barcodes
Hello all, I am build an application that I can use to keep track of my company's hardware. I have a New Hardware form for adding new entries, an All Hardware form/report, and a Check Out/In form to perform the check-out/in action. I have a couple of basic questions I need help with: When a "New Hardware" form is submitted, is there a script I can implement to create a new entry in "All Hardware" and copy values over? Is there a way that in the "Check Out/In Form" I can use a Single Line field
Bug: Stateless form buttons don't work on mobile.
Hi, Both button types (Standard and Submit) don't appear to execute their deluge script on Stateless Forms via the Zoho Creator mobile app. I have shared the application with support: https://creator.zoho.com/johndobble/bugs/#Page:Stateless_Form Please advise. Regards
Android Phone photo - unfortunately Zoho creator has stopped
Hi, I have a new app (and have a developer helping me with it) My android phone is giving the error "Unfortunately Zoho has stopped working". The cause is when I take a photo and submit it. This works fine on an iPhone. Questions: 1. Is this a common error? 2. How fix it? 3. I have logged with Zoho support. Will they be able to resolve? 4. Are photos generally a problem area? All help appreciated.
How to update formula field dynamically?
How to update formula field during the process of adding form? I want to display results of formula calculation dynamically, on user input.
website
I just wanted to say that this website is fantastic. I have been searching google for 2 days trying to find a good one. You have my praise. Thank You. kiel
Progress update
I created an app in Zoho to manage a real estate project. It has 1 form "Budgets", the fields are: - Project - Supplier - Date and it has a subform with: * Task * Quantity * Amount The idea is enter the "progress certified" each month for each supplier, so I want to create another form when I will select Project / Supplier and them each task with progress, for each selected task I will enter Progress Advance and calculate automatic amount. I was reading all forum and reference guide, but I did not
Embed sign-in form
Hello. Could you please help me with embedding sign-in form to my site. I use iframe with https://accounts.zoho.com/login?servicename=ZohoCreator&serviceurl=http%3A%2F%2Fwww.mysite.com&hide_signup=true But when i'm loggin i will redirect to https://www.mysite.com I'm not seeing https links. I have browser warning about different SSL in this link. And what's mean "dcc" and load_ifr tag's in Zoho url Thanks!
Sidebar that the information is not displaced,
I am sending an automatic email with the content of a subform for each entry. I would like the photography and content from becoming a single entry that would shift at the same time because if I add a variable to "PHOTO" and a variable to "Text" page breaks give me different positions. How to change my code to make the photo and text are in one sidebar regardless of anything? CODE output=""; Foto=""; for each entry in input.R { Foto=Foto + entry.Imagen.replaceAll("/sharedBy/appLinkName/","https://creator.zohopublic.com"
Problem with subform and adding fields to picklist and txt.
I have a form Items, and form Recipe with a subform. In my subform I need to populate a dropdown box based on the item selection. row.PurchaseTxt=Items [ID == row.items].Purchase_Txt; row.InventoryTxt=Items [ID == row.items].Inventory_Txt; row.UsageTxt=Items [ID == row.items].Usage_Txt; clear row.Usage; row.Usage:ui.add(Row.PurchaseTxt); row.Usage:ui.add(Row.InventoryTxt); row.Usage:ui.add(Row.UsageTxt); Any help would be appreciated.
Inventory counting problem
I work in a restaurant and i have to make ordering forms for diferent vendors. I would like to have an easy way to display the records with a dropdown menu with the quantity i want to order. And save each orders with the quantities in a separate form without afecting the main inventory form. Thanks
Sharing records
I have a situation where we want to share some records between apps. Specifically the apps are for keeping track of leads for different websites. In some cases, the leads are common to both sites or apps. We want to have the common record available to queries from both apps. Is this possible with zoho creator. Note, the apps are identical in structure.
Select or Deselect a Field Weh the Field is Updated
I have a checkbox field called "Invoiced1". I have the following code in the Field Action, On Load section for a field called "Carrier": Invoiced1.deselect("Freight"); It works great! When I try to copy and use the same simple code into the Field Action, On Update, it fails. Saying error on line 0. Any ideas? Help is much appreciated. Thanks!
Next Page