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
Attach a Template from a Creator Form in CRM?
How can I attach a PDF Template to my CRM? I found this line of code: "<variable> = zoho.crm.attachFile (<module>, <record_id>, <file_object>, <connection>);" But I don't know how I can get the requested variables through DELUGE.
Batch edit doesn't run workflow
I have a workflow that looks for a status change on a form (when form is created or edited) This works fine, but if I edit several rows by selecting them in the report and then editing a single field for all selected entries, the workflow doesn't fire (or perhaps fires for only the first record in the list). Is there a way around this?
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:
Display Record Summary Inside of the Form
How can I easily display a record summary, record detail inside of a form. Example: I have an order form. If the order form is a split order, then I want it to show a previous order (un-editable). I have the logic of finding the previous order, I just need to display it. Possible Solutions: I could create a stateless form and then have the form populated. Thats a lot of work to just show a record. Use the notes field and fetch the data and populate with HTML. This also is a lot of work since Zoho
Upcoming updates - February, 2020
Hello App Creators, Welcome back our series of upcoming updates! Here's what we'll be rolling out in the next 2-3 weeks: Custom inline error messages for fields Look up data from the same form Spreadsheet report enhancements Improvements for the Layout Designer for Print & PDF PDF enhancements for records Deluge script versioning Form workflows revamp - - - - - - - - - - Custom inline error messages for fields Many of you may have used the alert task to implement dynamic data validations. For example,
Bug: iOS app consistently crashing on image load
I’ve created an application that calls (multiple) images to be displayed in a Notes field. Works fine on pc, but the iOS app consistently crashes upon the first load of the form once a new image has been added. Subsequent loads (when the images have been saved in cache??) of the same form load ok. Please support.....
How to get data from this API response
Hello, I'm having trouble figuring out how to read this response. The result posted below is saved on a variable called response. <?xml version="1.0" encoding="utf-8"?> <string xmlns="http://www.ventamovil.com.mx/ws/">{"Confirmation":"24","Description":"RECARGA EN ESPERA","Folio":"000000","Folio_Carrier":"000000","Notice":"Feliz navidad 2019","Balance":"0","transaction_date":"23/06/2020 17:44:33","productVersion":"21"}</string> I want to get the data between {} I tried this but got null: info response.get("Confirmation");
Javascript Variable Scope
Hello Guys, I am trying to get the value of the variable "mthitems" out the function defined to retrieve the record data and run the for loop as shown below. But somehow it does not return me any value for the variable in the console if I print the values outside of the function, but inside the function when i try to it does return the proper values. Can someone help? mtconfig = { reportName: 'Match_Stats_View', criteria: 'Parent_Season==' + ssitem.ID, } var mthtitems = ''; let mtdet = ZOHO.CREATOR.API.getAllRecords(mtconfig).then(function(mtrecords)
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.
Zapier Integration to Creator
Hi, now after few months creator V1 API will be decrypted. & New API needs auth token and it will valid 1 hr. every request we need to validate that token so on. But now, for automation tools, such as Zapier or Zoho flow Used old base authentication Token now they are automated tool then How We can do for As per New API V2 base?
Does Zoho Creator support Arabic Language on the User Interface?
Does Zoho Creator have inbuilt support for the Arabic - where the form labels would display on the right, the text box cursor would move from right to left as Arabic Data is entered? See sample Gmail login page with my Browser language set to Arabic (Saudi Arabia) [ar-SA]:
It is possible to call Zoho creator custom function by using Rest API or by URL
Hi Guys, I need to call a zoho creator function for every 20 minutes in a day. In zoho, it is not possible to schedule task for 20 minutes. So i thought of calling function by Rest API or by URL. Guy please help me to achieve this task. Thank you in advance.
How to make pop up form dependent on subform row user entry
I currently have a product selection on my user form which has two options (box of 12 and box of 6). When one of these is selected I have a pop up form appear which relates to the option selected by the user, triggered when they select the product. However, when a new row is added to the subform and another product selected, the subform only looks at the first row to determine which pop up form to load, not the current row that the product is being selected for. How do I make the subform check for
Can I show multiple Subform entries into a Kanban quickview report?
I was wondering if it is possible to show multiple Subform entries into a Kanban quick view report? Or any quick view for that matter. I have a report that shows fields from a subform. Let's call it an order with rows of products. In the quick view, I can select the Products subform to show, but it only shows the first product. How can I get it to show ALL the products? Thanks!
Using Zoho as a developer
Hello, I've set up a small system under my Premium license for Internal use. Since there are only 4 of us, this works fine with me using the 'user' license and then my colleagues as contributors. I think that there are several customers for whom we could develop applications but our customers are mostly small or micro business. They would typically have 5-10 people accessing the application. I'm trying to get my head around the pricing model for this sort of situation. Using a 5 user site as an
Zoho Creator App
Opinion on Creator APP Design and Customization So I have created a Sites Form: site_name, site_address etc... Next I Created a Site Stops Form: (Lookup Field: site_name) and SubForm to allow adding tour stops I created a Check-in Form to allow the tour guide to check in. They specify the (Lookup: site_name) and date/time is automatically filled in with current date/time. I created a form called Tour: where I have some fields that they must fill in like how_many_ppl and notes and few others.... Once
Update records that meet criteria
I'm trying to create a schedule to update records daily that meet criteria. My deluge code looks like this: for each oldTruck in Enter_Tank_Inventory[Latest_Record = true && Warehouse = "T13"] { oldTruck.Latest_Record=false; } But I keep getting this error: left expression is of type BIGINT and right expression is of type STRING and the operator = is not valid How do I get the warehouse value of T13 in the criteria?
Open Form with Parameters from a page
I have got a page, Added a button Action is to open a form. I want the Email field to be populated with zoho.loginuserid Wondering if I can pass that on with the "Query Parameters" under the action tab. If so just wondering what to type in there. See attached screenshot
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.
Upload file API
I am having a really hard time with the Zoho Creator Upload API. I am trying to upload a pdf file from google drive using the following google app script. I keep getting the following error message {"code":2945,"message":"LESS_THAN_MIN_OCCURANCE"}. Any insight would be very much appreciated. Code: var theFile = { 'file' : DriveApp.getFileById(fld.fileID).getBlob().getAs('application/pdf') }; var formData = { 'authtoken' : 'xxxxxxxxxxxxxxxxxxxxxxxxxxx', 'recordID' : 'xxxxxxxxxxxxxxxxxxxxxx',
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 :)
App for recording delivery of consignment of blood products
Hi everyone I've recently taken on the role providing technical support to a charity here in the UK. We provide emergency out of hours transportation of blood, platelets, human milk etc. for the health service here in the UK. We have a Zoho Creator app that our controllers use to log a call from a hospital, assign it to a blood biker, and record collection and delivery details etc. Currently our blood biker has to fill out a paper receipt and request a signature from the person receiving the
How to post data from a web page to Zoho database with no network!?
Firstly, an apology - after much reading I'm not even sure I have the right forum. I was looking for the forum relating to the Zoho database our charity uses - I think it's Creator? But all the docs talk about Creator being an app platform, not a DB, so I'm not sure. Apologies if I'm in the wrong place. Secondly, we're looking at how to allow our mobile end users to submit data to the database when they have no network. Yes, I know, bear with me... We're considering a few options but one of them
Bulk Edit a Log
Hi I saw this post and want to know if this feature can be done using bulk edit? I have a courier company and want to update the status of multiple packages at the same time? It started as a simple long text field "Notes Log", and then we added a feature that: User enters new text in a separate field "Add Note". Upon submit, scripting prepends what they just entered at the top of the "Notes Log" field, AND it automatically adds the current date (we decided against date/time), and a visual divider
Comparing string values
Hi Does anybody know how to compare string values such as if string1 begins "s" { list = list + String1 }
'Application' vs. 'Solution' in Zoho Creator Developer Zone?
1. What is the difference between building an 'Application' and a 'Solution' in Zoho Creator Developer Zone? 2. I want to build an app and have customers subscribe to my app rather than sell the app to them. What is best for me? 3. Is there a way for a client to subscribe to my software and for them to add their own users like you would using any other software out there? I really like the Zoho Creator platform but I have no idea how to get my app to market in an effective way..
Triggering an 'On input' script for existing records
Hi, I have a form with some simple automation whereby editing one field dictates the input of another. This was achieved using an 'On input' deluge workflow. However, I only built this flow after having created many records. How can I trigger this script for the ALL of the existing records. I believe it can be achieved with a function but I'm not sure where to start. Any help would be much appreciated.
PDF Record summary
Hello, When exporting a record summary into a PDF (I have made quote and invoice templates) I cannot seem to have neither the header nor the footer repeat on every page and I can't seem to add page numbers to the footer. is there something I am missing here or is this not part of Zoho Creator yet?
one to one relation in a function
I have got a new issue to work out. Form Profile is linked to Form Person through lookup field Lookup_Profile. I want to allow only one entry of Profile for each record in Person. And create a function (with a button in Person records) that opens a new Profile record OR the existing one if it already exists. I didn't get much further than fetching all records of Profile in a variable. Like recProfile = Profile ( ID != 0 ); After that I would need to check if the Lookup_Profile already is in recProfile.
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?
Ability to Create/Set Custom Form Templates in Creator 5
Hi! I have been developing a course/operations management application for a client. We tested concept in version 4, then switched to version 5 to develop the application. I noticed that while there are many form templates to choose from in version 5 (which is nice), there isn't a way to set a custom form that I develop as a template. In my client's situation, we are handling course registrations through the application along with other operational functions. I tried creating one 'master' registration
Customer Portals Stop Working
This is the response when trying to access any of our Customer Portals
Show records in the last x weeks
I know this should be simple but I seem to be tying myself in knots trying to get this done. Form1 has a list of week no's. ie 1,2,3,4,5 etc as type string (so they sort). Form2 has a lookup to the week no's in Form1 as well as an errorName. I want to count all the errors that have occurred in the last x number of weeks. ie count of Form2 where week no is todays week no - 12. This would give me the total number of errors in the past 3 months. Any help is much appreciated, thanks!
Reset and Submit button not working
I am having an issue with the form Reset button and Submit button. Both work in the application however, on on the published link neither button works correctly. The Reset button will not reset the form. The Submit button sends the data in the form to the report but it does not reset the form and give the "Successful Submission" message. This is happening for all forms in my account. Thanks, Matt
how to pass the record id from one form to another?
I have the following "views" in zoho: CLIENTS - (automatic ID ? does not appear anywhere) - Name - Email - Birth date then I have another table: QUESTIONS - Client ID (this is a lookup from the 'Clients' table) - What is your favorite color? (radio: black, white, blue) - What is your car's brand? (picklist: Toyota, Ferrari, Volvo) then I have the form for "Clients". when I click on SUBMIT, I want to pass the client's id to the second form. How do I do that? Does it matter if the form
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!
Next Page