form.submit
Hi, I'm using the Zoho Creator for an inventory management application and have found most things really awesome. I require to do an auto submit of the forms once all the fields are filled up correctly, something like a form.submit in Javascript. Is there a way to do this ? Is there a "force submit" counterpart of "cancel submit" ? Is there a way we can embed our own Javascript to do this ? Thanks, Zainul.
Conditional switching of mandatory field status
Hi I have a form that requires a number of fields to be hidden depending on the selection of a yes/No radio button field, ie if the radio button selection is "no", then about 6 other fields are not necessary and must be hidden. Obviously, if the fields which must be conditionally hidden are defined as mandatory, then on submit, errors are thrown for each of those hidden fields. Conversely, if the radio button selection is "yes", then all fields must be shown and they must be required fields. Is
Intigration with facebook
Hi, This is Surya, I am trying to integrate with Facebook and i want to post an image to Facebook from the creator using deluge [The image was already uploaded to creator using image field from local storage]. It is working when I use an image URL from external sites. But I can't post the images that are already uploaded to zoho creator.Please give me a solution for this. Regards, Surya.
how to create a button in View and a timer
Hi! I am new to Zoho and I need a bit of help with something. I want to add a button in a View so that users can click and go to the next Form. How can I do that? Also, is there any way of inserting or creating a timer for my application? Thank you!
Coupon Generator with end of date use
Hello World, I needed a coupon generator to generate about 200 unique coupon per day for my ecommerce and couldn't find one. I never coded before the last 48h and didn't know what a variable,function or index was. I watched a video about JavaScript for Beginner and went true the Zoho Deluge website to find functions. I then created this one. It gives about one and a half billion combination per day. Should i worry about having a double coupon value happening? Is there a way of avoiding it? Should
About Record Add Permissions
Hi there everyone, This might be a simple question, and I might just be overlooking something minor. I am trying to figure out how to allow the permission to add records for the Zoho Support team. As I am working with them on an issue and they asked me the follow: "If the script is triggered while adding records to the form, please provide your permission to add records from our end. " I know right now they are busy, so I may not get my answer for a bit. I was hoping someone could help me here in
Help regarding hide Reset button from form.
Hello I need some help. I have a form in which I am getting a value into single line field. I have two button Submit and Reset. I am doing functionality on Submit button. Reset button is no use for me. I want to hide reset button from Form. Please tell me how can I hide reset button from the Form. Otherwise suggest me alternative.
Developer / Creator EU licensing per user cost please
I am looking at Developer Creator Application, and wondering what the licensing model is? Is it the aligned to the Developer Creator Solutions starting at $2 per user, or Creator Apps starting at €10 if in the EU? Thank you.
Creator Calendar - On Validate
In my app, I've added some On_Validate logic to prevent users from changing a date field to a day that is "off", i.e. Sunday or Holiday. However, in the Calendar report, users can drag any appointment to those days. In other words, the On Validate script seems to only fire when the record is opened for editing. In the Calendar view, the date field gets updated. I could write the code for the "OnUpdate" event but by then, the data has already changed. Also, I don't not have access to the old date
Workflow schedule to send email
Hi there I'm setting up a workflow schedule based on my add employee form to email reminders annually on the employee's anniversary date/hire date. I want to remind the employee's manager to book the employee's annual performance review. However, the fields I have on the form are the employee's email address and the employee's reporting manager, which means that I would need to fetch the reporting manager's email. How can I use the reporting manager's email address in the To: line of the notification
How to use fetch and update to calculate current wage
I am new to deluge and I'm really struggling to figure out how to set up my creator app, particularly when it comes to referring to fields in other forms. One example: I have a form called Add_Employee which lists all basic employee info including Starting_Wage. I have a second form called Enter_Wage_Increase which uses a lookup field for Employee Name. I want to have a field called Current_Wage that calculates the employee's new wage based on Starting_Wage + Amount_of_Increase. For starters, I am
MAJOR Security hole in ZC5 reports(kanban)
@Support: With the introduction of the kanban report I have discovered a major security flaw. If a user creates a kanban report from a filtered lookup field, the filter will not apply to the values in the kanban. See: http://prntscr.com/lhr2k4 There is no mention of this in your help documentation. So if someone was creating all list reports and not using kanban they would not be aware of this. The only option is to remove the column from your report, in which case you lose the ability to see the
Creator - Schema Builder - Can you save the view?
I find the schema builder really helpful at times for visualizing my apps and their architecture as they evolve. That is, is helpful after I reposition the form icons to make some visual sense. The thing is, the schema builder always defaults to a random system generated view/arrangement, which is generally chaotic to look at. This happens upon refresh, it happens if you leave the view and come back to it, and it even happens on print - the print view itself reverts to the chaotic system view. I
Exporting report data to Excel?
Is it possible to export data from reports into Excel?
Approval Process of a Subform
I have a request form, Form A, which includes a sub-form, Form B, for any purchases that need to made for the request in Form A. When Form B has an entry within Form A, is there a way to trigger the Approval Process? I can only seem to have the Approval Process triggered when Form B is filled out independently of Form A.
Double "For Each" loop to update grand-child record
Hello all, I have three forms: countries > cities > airports. Each child is related to its parent with one to many bi-directional lookup fields. Saying it differently, each city is related to one country and each country is related to multiple cities. The same is true for the cities-airports relationship. When an update happen on a field on "countries" (the parent), I am trying to update fields on cities (the child) and on airports (the grand-child). I succeed to update the child using "For Each"
ZOHO Creator and ZOHO Sheet
Hi Can ZOHO SHEET be intergrated with CREATOR ?? Can I use the front end cut and paste functionality of SHEET with the backend validation of CREATOR?? TIA Allan
import xls file with european date format dd.mm.yyyy
I am trying to import data from an .xls file containing date fields with european date format like dd.mm.yyyy Importing the xls file the date column appears as a dropdown field. When I want to change it to a date field, I get the error message: "One or more rows contain a value that´s not a date. These won´t be importet. Proceed with changing the field type?" All the fields in the row have the correct format dd.mm.yyyy What to do to import the european date field correct?
Inquiry regarding how to customize CRM with CREATOR
We are using zoho CRM and CREATOR. However for accommodating our business more, we want to create an interface with CREATOR to link CRM database, and it needs customize tab made from CREATOR inside to operate database of another tab. In order to put it into practice, how should we do? best regards, Ueda
XML RPC API - Failure, Invalid or null criteria specified
I'm using the XML RPC API's for editing data, following the example that they gave (modified). This is the XML that I am trying to parse with the API: <textarea name="XMLString" > <ZohoCreator> <applicationlist> <application name='supportv15'> <formlist> <form name='Main_Database'> <update> <criteria> <![CDATA[(Return_ID=="HORP53376")]]> </criteria>
zoho creator
How to create a workflow of auto number generating without using a auto number field?
Source IP address of Zoho servers for postUrl() commands
Hi, Is it possible to get the current IP address range of Zoho servers making postUrl() requests? We'd like to whitelist these addresses from our firewall. It would be useful if these addresses were published on the docs (or maybe they are, couldn't find though ;) Best regards, Ville
Zoho Integration with ActiveCampaign
When Adding a contact in Zoho creator it should add automatically on ActiveCampaign. For that I am using workflow but it always returns:- {"errors":[{"title":"Email address is required.","detail":"","code":"field_missing","error":"contact_email_was_not_provided","source":{"pointer":"/data/attributes/email"}}]} I am using this code :- m = Map(); m.put("email","abc@gmail.com"); h = Map(); h.put("content-type","application/x-www-form-urlencoded"); response = postUrl("https://shobhitagnihotri123.api-us1.com/api/3/contacts?api_action=contact_add&api_key=d13fe84cffb52d11060b3daadc75172982e4e16d21b3f57b5b1c09363a041fe2aa779aee",m,h,true);
Continue display of the next form field on the same line.
I want to be able to design my forms to logically use the space on the page with some lines containing one field, some two, and even some three, horizontally. My forms are so enormously long because a whole line is wasted for one small field. I am aware of the two column option, but I can't place my fields where I want them, they just start at the top and cluster together. One column only and two columns only is not friendly at all to the way forms look in reality. Please add the option to continue
Barcode
Hello, In a barcode scanner, initially i have set up the scanner like when you scan the barcode it should straight go to the next field below the previous field so it means for the browser we have used enter button and for zoho it means i have submitted the form. So basically unless, Zoho doesnt update their function on enter button this is not possible on zoho. But i think there is a workaround for this like when i scan the barcode On User Input it should straight go the field i point out at using
Find "closest" previous record that "matches" the current record
Has anyone (Damien Cregan?) found the best way to find the "closest"/"nearest" previous record that matches the current record without getting the "x is an empty set and values cannot be retrieved" error? For example: RecordSet = FormA [Criteria 1 == x && Criteria2 == y && Added_Time >= "some date"]; for each record in RecordSet { if record.Field == SomeCriteria { PreviousRecord = FormA [Field1 = record.Field1 && Added_Time < record.Added_Time && ??????]; } } This works in some situations,
Custom Solution limitations: Is my work down the drain?
I have been working on and off over the past couple of years building a solution for a specyfic industry. I was about ready to release my first version at the start of this year, but then Zoho implemented their Developer program, which basically said that I couldn't use Creator to make a SaaS app. That hurt, but I (painfully) converted my Creator app to a Developer app. Six months later, I'm ready to start getting clients on-board. But I JUST came across the limitations Zoho has implemented for
File Stream
Hello Zoho Support, I'm creating an apps which will upload file to zoho creator and will also upload the file to zoho docs using it's API. But the problem is how can I pass the File Input Stream of the File_upload field of creator form? Because File_upload is a string, I need the actual File to be pass on zoho docs. this is my sample codes: data = Map(); data.put("filename","SampleName"); data.put("content",input.File_upload); Multi_Line1 = postUrl("https://apidocs.zoho.com/files/v1/upload?authtoken="authtokenCodeHere"=docsapi",data);
Displaying report in public website - can't get it to work
What apparently seemed to be a fairly easy task, it's becoming a nightmare for me. I have created report with the price list of all our services. This report includes 7 fields like Service name, price, category etc... show in the image below and the list goes on... Now, what I need is to filter out things displayed on my website where I will publicly be showing our price list, but I don't want all columns to be seen. For example I need only Service and Price columns to be shown. What I've tried is:
Better Search Filters - Community Forums
The ZC Community forums are an invaluable source of information for users seeking help. However, one of its limitations is the search feature. More often than not, I have to turn to Google to search the forums for relevant information, rather than using the community forums built in search feature. When I search the community forums, I'm often presented with outdated information that was published many years ago. It can be hard to "drill down" to find exactly what I need. Here are suggested search
Rich Text Field Editor and Tag support
Why is there no HTML editor for RTF fields? You can insert HTML code, but you can't edit the entire field. The Notes filed has is, but not the RTF filed. The tools available don't allow it to do much. I worked around this by creating a multi-line text field. On the click of a decision box the HTML code is copied to the multi-line field, ediited there, on the click of another box it is copied back. Works pretty well, but I find not all tags are supported. I want to do a nested outlined list.
Problem with adding single line field
Hi, I cant add to the form i created (by Zoho creator) "single line fields". The message i got is "adding..." and nothing really happen, its stuck without doing anything. The name of the form i used is" פרטי מקור חינוך - 2014" Can you please check the issue ? I allowed you to access this form for checking. Thanks, Itai B.
Validation On submit work flow action script is not working
For some reason, validation on submit work flow action is not triggered from any of my creator applications. It stopped working from 9th June 12 am IST. Without validation records are inserted into the report on form submit. I checked this even with simple alert box but still the alert box is not even popped while submit. Can someone help please.
Custom Colors/CSS for individual series in a page dashboard
Hi, I have a gauge chart that shows me a count of ticket status ie. in progress/late/done/not started. At the moment they chart can be styled with set colors or on a color scale. Is there anyway to specify a color based upon the series/field - late is red, not started is grey etc... ? The fields are based on a fixed drop down so there is no chance of mis-spellings or accidental additions. Thought this would be an abvious feature given how customizable Zoho is. Maybe I've just not found it yet :)
Can I integrate file uploads from creator form to Dropbox and then access from creator form with a link click?
Hi, I am using wufoo form builder and in that I can integrate file uploads to Dropbox. But the problem is that I can't access those files from wufoo. I have to login into dropbox and then access which is very hard. Can I achieve this functionality in Zoho Creator? Add files to Dropbox and then access from zoho whenever required?
Customer Portals Stop Working
This is the response when trying to access any of our Customer Portals
Merging Records
Has anyone (Damien Cregan) written a script that will do a suitable job of merging Zoho Creator records? Zoho CRM has this functionality on the front-end, but I haven't seen anything on the Googles or the interwebs to indicate that anyone has tackled this for Creator. Thanks!
Send multiple files in Email
Hi I have to send multiple files - all attached - in one single email given a certain criteria -- not the URLs. Can I do it? Any other ideas to share a specific set of files with one email address that is not a Zoho user? Basically my company produces documents, which are attached to the customer order, and at the end, I need to send them. How can I do it? Any ideas? Raul
Control visible fields in Spreadsheet View
Apologies if this is a silly question. But how do you show/hide fields (columns) in Spreadsheet View in Zoho Creator 5? This was easy in the old version, but cannot see how to do it in Creator 5? Any guidance much appreciated!
Accessing the last record?
Hi, I've been searching on how to access the last record of a View in a form. I've seen the code below. We are not expected to manually set a flag on the last record to search/filter on are we? Is there not a first, last, next, previous method of running through a list of records? Cheers, 4. How can I create a view in Zoho Creator which shows only the current record? To create a view which shows only the current record, Create a hidden field in your form to identify the current record
Next Page