Limit max characters in multi line box
Hi! I would like to limit the max number of character that a user can write in a multi-line box. Is this possible in any way? Cannot find the option when I edit a multi line box.
Web page for many reports, same search parameter ?
Hello I create clinic application, To enable doctor to see all patient's reports like blood lab, radiology, need to add all reports in one web page. I know how to create button in in report to go to another page with search word in this form openUrl("https://creator.zoho.com/" + zoho.adminuser + "/" + zoho.appname + "/" + "#View:Search?searchname=" + input.Name, "Same window"); and add it to web page parameter where parameter will add to search string as a filter. The problem search string in report
Link To File On My Computer
Newbie Here. I want to link to a file on my computer - not on a website. For instance: File Location would be the field. I see where I can link outside but I don't see how to make it link to a file on my computer. Am I missing something. Or is it because it is cloud based?
Formula: Sum amounts entered in lookup field
Hello! I would like a formula to add the sum of all the amounts entered in a lookup field. (The lookup field is within the same form) I have attached pictures that I think would help. Below are all the payment amounts I would like to add. (this is a lookup field to a form) When I click "+ Add New" , this is the form that pops up.
File_Upload using Advanced Rest Client (Google apps)
Hello, I have a File_Upload field on my app in the Creator. When I am tying to upload a file using the Advanced Rest Client (Google App), I can see the status code '200 OK' , but the response is empty. Also, the file does not get uploaded in the database/table. Below are the Name-Value fields that I am passing in the Data Form section of the Advanced Rest Client: authtoken : ************** scope : creatorapi applinkname : rest formname : FormA fieldname : File_upload
How to: Show field if lookup is populated
Hello! I would like a hidden field to show when a lookup field is populated. Another way of thinking about it: I would like a hidden field to show when a lookup field is not null. How do I do this?
Ideas for my form
Hi everybody. I'm trying to make a form to distribute all the biopsies through the pathologist (residents and assistants), and I need to add two fields which I'm not able to find out how. The first field I need is one in which I see the sum of cases of each pathologist for the day, updated every new biopsy is added. The second field is one in each I can see the pathologist who received prostate biopsies in the previous day. Can anyone help me?
Initializing/updating/displaying counter variable
I have a feeling this is simple, but I'm new to Deluge and can't figure it out. I'm taking reservations for an event and want to show the remaining spaces in a disabled field called Spaces_Remaining. How/where do I initialize Spaces_Remaining so that it isn't reset to it's initial value each time On Add>>On Load? Any help would be appreciated. Bryan
Compress attachments?
Hello community, So, I'm creating my first zoho application for a friend who needs to replace an app they currently use. One of the biggest features they need to keep around is their ability to add photographs to records. In some cases they may have 20-30 photographs attached to a client record. These photo's only need to be accessible while the form is in certain status's but once the workflow has been completed and the record is being archived and used for reporting purposes only, those photo's
auto data saving
Hi guys. i have someone building a dance club databas for me with creator and i'm being told that data cannot be saved automatically within a form... when we create an event and open the booking form to add customers/members that dat is not stored unless we click the save button at the bottom every time ... whats happening in live tests are mistakes happen on a busy entrance door and while moving around the database sometimes all the data entered on the night can be lost and its even possible to
email notifications no longer being delivered
We have just moved our site from a Joomla to a Wordpress platform. Staff are no longer consistently receiving email notifications, although we have made no changes to our form, simply copied the same embed codes to the new site . Could there be some kind of conflict or is there some other explanation?
Getting Events associated with an Account record
Hi there, I'm currently getting my feet wet with Zoho Creator and I had a question about its integration with Zoho CRM. I was wondering if it was possible to get the events associated with a Account/Potential/Contact record. I've tried using this function call to no avail: relatedEvents = zoho.crm.getRelatedRecords("Events", "Accounts", accountID); I was wondering what other things I could try, and if this is even possible. Thanks!
Use barcode reader to define the list of fields and options
Hi everyone, I'm Rob, a total newcomer in Zoho, but i'm willing to learn about this plataform to use it form my company. Right now i'm building a demo app to show the capabilities of creator. My question is: Is it posible to read a barcode, fetch the data and then (with the informatión the barcode provides) fill the rest of the form (two selects and a checkbox). I'll be waiting for your comments, thx to all.
How to have a Creator App use information from the Contacts in CRM?
The idea is to have the App be able to take the contact information directly. As it is, the data that my App is using was manually imported from a spreadsheet.
Set the value of a checkbox field from a function
Scouring the help forums and documentation...it does not appear that I can set the value of a checkbox field from a function. Is this true or is there a way to set a checkbox value from anywhere other than the On Load event?
Boolean fields in a map?
Is there a way to have a boolean field in a map? if you use this code mymap = map(); mymap.put("aaa",true); mymap.put("bbb",false); then alert mymap.get("aaa"); shows 'null' is there a way to make the value for aaa behave like a boolean instead?
Any news on "Deluge NG" ?
This post from the man behind ZohoCreator mentionned about a new version of the Deluge language called "Deluge NG". Now what is ahead over the next few years? I am personally working on what I call Deluge NG - the next generation of Deluge that I hope would offer much more expressive power, while at the same time being as accessible as Deluge today. My goal is to empower the "casual programmer" or even power user to get a lot more done, without having to get a Computer Science degree. It is still
how do i sum values in fields?
Hi, how can i do to sum 8 fields in a form? This is how i actually do with 3 fields: if(input.field1 > 0) && (input.field2 > 0) && (input.field3 > 0){ input.total = input.field1 + input.field2 + input.field3; } how can i do to simplify the code, cause the example code is for 3 fields, and i need to sum like 8 and And can also add to clutter. and i think it will takes more than 20 if conditions.
On validate if statement with two conditionals.
In my form validation script I would like to have an if statement with two conditionals. I feel like the following script is formatted correctly but it is returning an error at the first if statement. Any insight as to why this is happening? wordsList = input.MyField.toList(" "); wordsCount = wordsList.size(); if(input.MyField2.contains("Some string about this long") && wordsCount > 150) { alert "Sorry. Only 150 words allowed for MyField2"; cancel submit; } else if { ... continue
How do I add many fields in a form?
Hello everyone, I have a form, and in the form i have some sections, In each section I have the sum of the fields that section has, i was addend that fields, it was only 3, so add 3 fields is easy using conditions, like: if(input.field1 > 0) && (input.field2 > 0) && (input.field3 > 0){ input.total = input.field1 + input.field2 + input.field3; } As you can see, i can do it, but i have to put every condition in every "On user input" so, in case that field2 == null, do this.. in case that field1
HTML PAGE IN CREATOR
Hi, I have a html page with input tag and submit button tag, In live mode, whatever I type in the input tag,I want to pass it as parameter to any one of the fields in the form of my application. Is it possible? Kindly,help me.
Jumping to a different input form
While entering data on FormA the user can elect to enter data in a different FormB. Actually, we anticipate 5 or 6 choices which require jumping to another input form. I cannot find any documentation on how to do this, but I expect it is quite easy. Barry Sammons Sammleton Distilling LLC
2 Forms, 1 Calendar Report
Hello! I have two forms. "Add New Event" "Add New Appointment" I would like to see all of my appointments and events in one single calendar report. I do not want to combine or link the forms because they have their own, separate, information. How do I do this?
Web Services in Zoho creator
Hello how are you. i have one question....., i have created a web service in Java that's connect to Data Base Oracle, this service throw me a WSDL file. I would like to know.¿ how i can include this WSDL file in zoho creator? Regards Jonathan
Bug? Zoho import create app from xls makes 'too long a decimal' from number
I did the following. Made a new blank excel spreadsheet with the following data: TestDec Name 20.4 Bob Saved the sheet. When to create an application from file. Chose the spreadsheet in question. The import fields are as follows: "Single Line" "Single Line" "TestDec" "Name" "20.39999999999 "Bob" No idea why zoho creates that decimal. If I change the fact it says "Single Line" to "Decimal", it still lists 20.399999999. If I try to finish the import, it gives an error
Data Access lookup fields
Hello I need some experts help asap to make the below function workable. Very simple...yet... FORM CATALOG: Product_name will list only Products on the selected Category. Price will show selected product price Have created 3 forms: Form Product_Group containing Category (field) Form Products containing Category (lookup), Product_Name and Price fields Form Catalog containing Category, Product_Name lookup fields and Price currency field Tried already filters, fetch record, for each record, an several
Is it possible to get GeoLocation for mobile form?
I am trying to create a custom app where we record the geolocation on submit. I have been able to get user IP, latitude, longitude and submit with form. However, IP is not very accurate. Here's what I"m using: IPAddress=zoho.ipaddress; User=zoho.loginuser; location = getUrl("http://freegeoip.net/xml/"); Latitude = location.executeXPath("/Response/Latitude/text()"); Longitude = location.executeXPath("/Response/Longitude/text()"); I would like to use something like this from client-side: if (navigator.geolocation)
Domain mapping
Does anyone know how to create domain mapping in ZOHO CREATOR ? I have tried to follow the documentation but on my setup screen there is nowhere I can enter the domain name to be mapped. The documentation leaves a lot to be desired. Mike
How can I integrate my zoho creator app inside zoho people?
Hi! is it possible to integrate my zoho creator app inside zoho people? if so, how can I manage that? I would really appreciate your help! Thanks.
Using bookmarks in the HTML page
Hi there, how is it possible to use bookmarks inside the HTML page ? I set up a bookmark with <a href="#link">Part 1</a> and mark the HTML block with <h2 id="link">Part one</h2>. When I run the app, open the page and click on this hyperlink, app opens another view/form which is placed first in my app. I checked the URL behind the link in the running page, it looks like https://customerportalname.zohocreator.eu/portal/appname#link which is clearly wrong as it misses the page name. Any ideas how to
add a subform item opening its form as a dialog
I wish I could add a subform row by filling its form as a dialog. That way, subform would act like a view. That could be an option when a subform is created based on an existing form.
Date-Time Field valication
Hello,I am developing an Room Booking apps for my company. I am using the date-time fields to create Start & End points. How can I block certain hours from the fields or maybe display a warning on form validation? Many Thanks
Iterate multi picklist errors
Hello, I'm trying to set up a script wich iterates values in a Lookup field with multiple entries. I have 2 forms: Werkopdracht wich contains the lookup field medewerkers_select Medewerkers wich holds the field Voornaam (text single line) wich is related to the lookup field in the Werkopdracht form and has a field wich contains and email field; email_medewerker I want to send any individual selected person in medewerkers_select and email when the Werkopdracht form in succesfully submitted. I
Load all [input] Fields in Form with specific 'Fetched Record' Values
Hi, Till now, we are able to only set individual field values using the 'set variable', in a Form. Could we have a statement, or variable name, for the current unsubmitted records, i.e all the form input fields, so that all their values can be set to a fetched record value, in a single statement. This can only work for, forms fetching data from the same form, or in an identical stateless form. lastrecord = (Songs[ID == input.ID]); //fetch record e.g formdata = lastrecord ;
Customizing the embedded report from Zoho Creator
Hi there -I have a report from my Zoho creator App that I am embedding on an external html page in an iframe. I am trying to customize it a bit further and was wondering if anyone had an idea on how to accomplish these 2 things? 1) Would like to customize the drop down column menu when clicking on the header/title row - right now it shows the eye to search and i can click 'Start' below and have it show me the 5 options of Sort by Asc, Desc, Group by Asc, Desc, and hide column. I want to get rid of
Zoho Creator PDF Export
Hi, I would like to export a page with a record view in Zoho Creator automatically with the URL structure http://app.zohocreator.com/name/application name/pdf/page name. But unfortunately when I open the URL and open the downloaded PDF it shows me instead of the records just Loading... Is there a way to make a delay that Zoho Creator can load the reports before the page is downloaded as PDF? LG Niklas
Hide Submit Button
Hello, I am using a form that calculates user data and displays the result; http://www.beergrains.com/priming-sugar-calculator. I have no need for the SUBMIT button and it is causing confusion with the users; when they click Submit the results appear then quickly disappear. They just need to view the result without submitting data. Is there a way to hide the submit button?
Issues with Customer Portal feature.
Hello ZC Team, I have a couple of problems in using customer portal: When the settings is such that users need the approval of the admin, the entire workflow doesn't tell that to the signing up user. The user gets the invitation email, gets the add-password link too. All this gives a false impression to her/ him that there is no approval involved. We really need the message to read something like - "you will receive an email with further instructions *after* the administrator approves your request."
Dealing with a poorly formatted query string
Hi! A third party is opening a form that I've made, and is including the query string "?first-name=Rob". Is there any way to get the value of "first-name" into a field in my form? Right now it doesn't work because Deluge names can't have "-" in them. Thanks!
Custom domain for zoho creator app
I am creating an app for the workplace of a large company. Unfortunately, it is like working for the government and I cannot convince the enterprise security folks that zoho does not pose a threat to their security and they have banned the zoho.com URL via their firewall. So I am considering whether or not I can use a private domain access to zoho in order to access a creator.zoho app. I believe that if the app were accessed through my_domain.com in some way that things would work. Am I understanding
Next Page