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?
Error Code 2945 , PATTERN_NOT_MATCHED
Hi, I am trying out Zoho Creator API. However, I always get the following <response> <code>2945</code> <message>PATTERN_NOT_MATCHED</message> </response> However, error code list error as Invalid Ticket. I do not know what is wrong.
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!
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
How to switch to 12 hour format?
Hello. I'm trying to create a form within creator that allows my employees to clock-in/out but the date-time field in the forms only allows for 24 hour format? We need 12 hour format. How can I get this going? Also, I need two forms, one for clocking in upon coming to work, and another for clocking out at the end of the day. How can I get these two forms to work together on one report? Thanks
Creator 5 - Edit Record based on Record-ID
What URL pattern can I use in Creator 5 to open a form and edit a specific record using the record ID? I have a list report with an onClick function. OnClick executes a deluge script to open a stateless form using the selected record's ID. Example code is below. All of the variables correctly populate. However, I cannot figure out the correct URL pattern for 'Editing Records via Record-ID.' The form will open, but it is always blank and it does not reference the record. openurl("https://app.zohocreator.com/"
n months ago custom filter in reports, filtering wrong data
i have 3 data in 01-May-2020 08:00, 31-May-2020 08:20 and 20-May-2020 18:10. now, so in June, with filtering that with 1 month ago filter, i get only 01-May-2020 08:00 and 20-May-2020 18:10. if the filter 1 month ago means 30 days ago, 20May should not be in the results too. And if the filter means the month just before this month like i want, all 3 records must be shown. What is the problem here?
Restoring Relation of 2 Forms Using Zoho Backup Data
Hi all, So basically one of my co-workers deleted all the data in one of the forms. I have a backup of the app from a month back and able to restore that database using the basic#Form_1_Name. Unfortunately, there are some other forms that have Field_LookUp based on Form 1. I see there is a rel#Form_1_Name#Form_2_Name and inside, it contains the IDs of the related data from the forms. Q: is there a way I can import this relation and connect the two of them together and thus eliminating manually restoring
Retrieve and merge 2 fields
I have 2 forms: Members and Claims. The line below works to retrieve the status from Members, when the membership number is inputted into Claims input.Membership_Status = rec.member_membership_status; I also have First Name and Last Name fields in the Members form. Is there a similar line of code for me to retrieve and combine the First Name and Last Name fields to input into a single Name field in Claims
Conditional Rule for field in a sub form
Hi All, I am trying to create a rule for a sub form field to send notifcation or add task when selected. But when i go to the rule i dont see the field of subform to assign the rule. Pls help if there is any other way to do this??
Updating from records using function in workflow with deluge
Hi I am trying to update a field in an already created form record using deluge after an 'on success'. The updated value is not static and is defined in a variable. How do I update a field value using deluge script in another forms records? Thanks
Deselecting multi-select lookup via other multi-select lookup
Hi, I would like to use a multi-select lookup to populate another multi-select lookup: select a Unit, and automatically a Name is selected. I've created below on user input of field. Problem: everything works as planned, both when I add or remove items from the Unit field the Name field gets populated (or removed). However, if I add items and subsequently remove them from the Unit field, once I get to removing the last remaining item in the Unit Field, the Name field does not get fully cleared. There
Problem updating new row in SubForm
I have created a form that contains a SubForm. I have actions through a workflow that automatically set field values, for example: Form > Created or Edited > User input of SubForm.Frequency > Calculate Next Date if (SubForm.Frequency == "Annually") { input.SubForm.Next_Date = input.SubForm.Date.addMonth(12); } This works as intended and updates the field value for the first row entered; however, if any additional rows are added, the first row values are updated based on actions in the second row
Next Page