How can I set a custom filter for a multi-select checkbox field?
Hi Zoho Experts! I'm trying to create a custom filter/view in a report that relies on information from a field that is a mandatory, multi-select checkbox in the original form. The field is "Season" and the values in the field are "Winter" - "Spring" - "Summer" - "Fall" I need to create a custom filter/view that allows me to see all items that have both a "Fall" and a "Summer" value attributed to them (regardless of Winter and Spring). I am able to create a custom filter for one season, but I am
Programmatically Add (Insert) Child Records Upon Parent Add Event?
Is it possible to programmatically add child records [to subform] on the "add record" trigger of the parent form? For example in a basic order-entry application. There are Orders and OrderDetails. OrderDetails accepts entries of Inventory Items. For example, an order may be of a specific "type". This "type" typically includes 10 of the same Inventory items that meet a certain criteria according to "Class" or other field value. So when this "type" of order is added (initiated), I want to programmatically
Report using zoho creator
Hi, I have created one property application in zoho creator, so i want to take report by monthly wise. For Ex : Jan Feb ......... upto Dec AAA 12,00,000 3,00,000 5,00,000 BBB 23,00,000 12,00,000 9,00,000 Issue is Date Format is nt accepted this type of month value, i have one date formatted column.(Added_Date) Can you please ans for this one .........
Automatically update Zipcode
Hi , I want to update automatically zip-code in fields For ex : Location ------ OMR Zipcode ------ 600003 It's is possible in zoho creator,i think it will take from Google Map or other sources
Add Record, Only Want Some Fields Available Before Submit Button
I'm looking for a clean way that when a user wants to add a new record, a "form" ("report"?) opens up with only the key required fields available for data entry, before the Submit button is displayed. In this application, when a new record is added, the remaining 60% of fields are not required as the data for them is not yet known. I don't want the user to have to scroll through many times to get to the Save button far off-screen at the bottom. Also, along the same lines, if I have a report that
How can I allow another user ability to edit my application (add new forms etc)?
I would like to grant another user permission to edit my application, please tell me how I can do this? Thank you, Bianca.
Convert HTML to PDF with filename
Hi, When using the header option pdf = true in an HTML view is there a way to generate the PDF with a file name other than the name of the view? Any help would be appreciated.
Auto Duplication of Form Entries based on Criteria
Hello, I am currently building an Invoice Program in Zoho Creator due to Zoho invoicing not having everything that we need. I need to include the ability to allow re-occurring invoices which are duplicated every month based on the original invoice. I currently have a tick box which if ticked I would like the system to create additional entries once every month until it is stopped. Is this something that can be done? Is anyone able to give me some advice.
List in sendmail
Hello everyone: I have been using a string variable to "build" the list of email addresses that is used in the To: line of the sendmail task. See portions of code below: if ((peemail != "") && (peemail != null)) { toEmails = toEmails + "," + peemail; } and the To: line: sendmail ( To : toEmails, input.Email1 I can't take credit for this genius bit of coding as Zoho did it for me to resolve a sendmail issue I was having. This has been working for a long time and recently
Fetch, Update, and Schedules
Hello! I have a form that has a drop down called "Status" which I use to filter for reports. I'm using the Schedules feature to send a report of records once daily based on the status field. I'd like to create a second schedule to update the status field shortly after the first report is sent. Is this possible? Thanks Arlan
creator.zoho and mobilecreator.zoho
Hello. How to synchronize application from creator.zoho.com to mobilecreator.zoho.com. When user enter data at form on mobilecreator(for example in Zoho app box application), these data automatically update in Report on creator.zoho.com. And another question, I want creat my own application for Andoroid\iOs (.apk .ipa) and then upload to Apple store with own logo etc. but with application on Zoho creator. Is it available, or any ideas how to do that ?? Thanks !!
Formula update
hello, By example i would a number field witch is the subtotal and a formula with TAX and formula with Grand total I would that when my script deluge calculate the SubTotal the TAX and the GrandTotal will be update automaticlly. Is it possible ? thanks you
Display next record +1 on next Add row in SubForn
Hi I'm trying to have the next field to be = Previous record value + 1 so I can start working adding Lines every time the user hits Add new in the Item_Sub Form. Try this but only pass as result = 2 to all new records. x=(row.Number + 1); row.Number=x; I'm completely new on this code trying to learn. Your help will be greatly appreciated.
sharing
hi : i am new to zoho and so using a free version to devlop a small app by it . i have shared my app with a friend ,which appears on his account page as a shared app,but it denys access, is it because of limitation in free version ?, or i miss a setting to let him use it..? please help
Multiple notification rules, yet more than one rule is applied
Hi, I have a drop down box with the aim that when an item is selected, it will produce a custom notification via email. I set up the rule with in criteria section: Dropdown - Equals - "specific dropdown item". I have 12 rules set up - it all works apart from Rule number 1 will always send a notification out as well as what ever is selected in the form. Can you help?
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
Next Page