Count the number of responses in an Invoke URL call
I have a qc function that is comparing data between a report I have in my Zoho Creator app, and that of an API dataset. I am using for each to iterate through a day's records by a unique ID (Appeal_ID) and calling the api by each f these ID's . So far
Zoho Creator and Automation platforms
Hi, I have a requirement to move information form Zoho into Monday.com. I have it working great, but any field that contains files (.PDF,JPEG etc) don't show in any of the automation tools I have tried (Zapier,MAKE, ZOHO FLOW). Am i missing something
Connection between Zoho Creator and CRM impossible
Hello everyone, I am trying to pull contact entries from ZOHO CRM to an application I am trying to build in Creator. Unfortunately, I do not get my entries showing up, I always get "null". Please have a look at my configuration and tell me if I am missing
Display single Record from Zoho CRM in a form based on URL parameter
Hello everyone I need to do the following. I created a form with 3 field . Based on the URL parameter which has the contactIid I need to fetch the specific record and display it in a page. https://creatorapp.zoho.jp/julien_dunes/fetch-it/#Form:OkOK?contactID=987238392832989382
Push notification message limit
Do the <message> has a limit of letters or combination of variables and text limit?
Best method for Logging Time
I'm developing a pretty extensive app and I want to include logging time to specific jobs. I know the method for time tracking in the gallery app is to basically use text. However it is a bit clunky when it comes to summarizing time in reporting and in
Images in export spreadsheet
Hi, anyone have idea as I can export images displayed in a view? I can import all data with MSAccess or MSExcel, but images is not displayed (only as a link). I need link my zoho db with a xls or dbaccess to use the data with CardStudio software and print identity cards. Someone have operated with this? Thanks Mic
Problem with the pipes
Hey there, I am trying to fetch data from an API populate it into a drop down. The problem I am having is the data being fetched is separated by pipes. And anything I have tried just puts the whole pipe separated list into the drop down. Exterior_Color:
Is there any way to send message on whatsapp through zoho creator
I have created an app in Zoho Creator as well as I have created required workflow,## Heading ## when to send message. It is working fine if I need to send sms or email. I want to send message directly to my users Whatsapp, How can I do that?
Using for each to iterate through a collection of records and invoke url for each record
I am trying to set up a scheduled function to compare and quality control check between 2 sets of data. One of these is within a creator app that I built, and the other I am calling from a 3rd party API. My planned workflow involves selecting all of the
Can I add a file download section to a client login portal?
Hi. We need to create a client login portal which has a file download section for participants on our training courses. Is it possible to do this in a Zoho Creator App? Can anyone point me in the direction of a tutorial or even better, a prebuilt app that can already do this? (Preferably a free one.) Thanks a lot. Damien.
Increase Image Upload File Size
Currently the limit is only 10mb, it would be great if this could be increased to at least 20mb. It is often requested.
No word wrap in multiline fields in report view
I am sure this worked fine earlier, but now there is no word wrap in multiline fields when displayed in summary and detailed view. I am in the EU server.
How to prevent or adjust Access Token expiration OAuth 2.0
I have built a form in Creator that pulls data from a 3rd party API when a user inputs a unique case number. Upon user input of that field, I have scripted an API call that pulls in corresponding data and auto-populates several other fields in the form.
Delete subform rows in creator
Hi, I am using a subform for adding rows dynamically. The insertion will be done only based on the decision field's value. If it is true, I will show the subform fields for entering. After enabling, if i make the field as false, the entries in the subform has to be deleted. So, can anyone please help me to delete the subform data through deluge script.
report merging several tables
Hello There I am trying to build an application to manage payrolls. I built several tables such as: Companies Company name (field) Company ref (field) Departments Company name (lookup) Department name (field) Employees Employee Name (lookup) Employee number (field) Contracts Employee (lookup) Company (lookup) Contract # (field) Salaries Contract (lookup) Salary (field) Bonus type Contract (lookup) Bonus (field)
Get the current URL
After spending hours on the last simple thing, thought to ask this community instead of playing for hours and hours when someone probably already knows how to do this. I want to have a form field that gets the current URL dynamically of wherever the form is embedded store the url and show the link in the view - possibly with fixed text (or a button) on the view rather than lengthy URLs. Allowing the user to click and it will return to the page where the form was originally filled in. i.e. it is a
[API] Uploading file via API to existing record by ID
Hello, I'm trying to uploasd a PDF to an existing record using its ID via API as written in the instructions (https://www.zoho.com/creator/help/api/v2/upload-file.html ). I succefuly created records on the form in my app. Then I took the record ID from
Zoho Creator - [Free Webinar] Creator Tech Connect - Creator's Latest Release Updates
Hello Everyone! Gear up for our next session in Creator Tech Connect Series! About Creator Tech Connect Series Creator's tech connect series would comprise of pure technical sessions in which we delve deep into key essentials and technical nuances while
Zoho Developer Community learning Initiatives
Developer Zoho User Group (ZUG) is a platform to encourage developers from the Zoho ecosystem to connect, learn, and share their expertise to find solutions for common business challenges. There are a couple of ongoing initiatives to help you get onboarded
Dynamic Filter on a look up field on a form based on the input of another look up field
Hello, I am trying to set up a dynamic filter where a look up field "Sending_Entity" in a form can then filter the drop down list of another look up field "Sending_Account". I tried setting the filter for "Sending_Account" as "Input.Sending_Entity", but
Title and Link Color Changed?
yesterday I could have sworn that the title color and link color were blue. now they are red. can this be reversed?
Zoho C6 Customer Portal Audit Logs
Is it possible for App Admin to audit customer portal user activity in Zoho Creator 6?
Data transfer Creator to CRM
Hello, We are currently using an application in Creator to create visit reports to Accounts. These visit reports are linked and visible on a related list in the ZOHO CRM. Anyway, we are thinking to stop using Creator and create a custome module in ZOHO
Did anything change recently with Zoho Creator?
I have been using a few contact forms on my personal websites. I have been away for a while and Zoho Creator account went dormant. I logged on and reactivated the same. However when I quickly tested my contact form got this notification. The actual content
Zoho Creator Embed Code is being Blocked
I am able to test the embed code as a direct link on the webpage. However when I try to embed the same into the Iframe I am getting the belowsaid error message Should I enable any settings for embed within the iframe?
How to compare records collected in creator to outside data
I have built an app in creator that gathers user input data that I need to check and see if it matches an outside data source for quality control purposes. It seems like doing this within Creator is not a great option, so I am looking for a way to do
OAuth 2.0 authentication compatibility with Creator as the client
I have been stuck for awhile now on this. I am using data from the Tyler Data & Insights API to autofill fields in one of my forms, when a unique ID is passed to one of the fields. Since some of this data is private, I am using their workflow for OAuth
Random String Generator
Suggestion: Random String Generator Purpose: A built-in function that can generate a random string. Tastes great with password input field! Motivation: Zoho Creator is missing a random-number generator. Examples: Create a strong password for a user. Alternative to Zoho ID#. Implementation: The function would have the parameters: character length, number range, and option to include alphabet charters (lowercase) Issues: Limited audience I bet. References: none I could find
Fetching records with multiple sort criteria
Wondering if anyone has had success running through a for each collection with multiple sorting instructions.... Example In a view's script you have.... sort by ( rep_name_grid ascending Talked_to_this_rep descending ) In a collection it looks like this..... for each r in Form_Name [group == group_var] sort by rep_name_grid range from startval to (endval - 1) However, in collecting records you set asc and desc in the scriptbuilder :) I tried to make the syntax work
How can I set a message to show when an upload file is loading?
We have an upload and parse script that goes through almost 2,000 records and takes a littler over 2 minutes to process. I would like the user to see a message that instructs them to be patient and allow the file to finish processing before trying to
Change of multiline fields behavior in templates
Until a few days ago, the multiline text fields of the templates made the corresponding line breaks to adapt the text to the width of the container. Recently, without me making any changes to the templates, the behavior has changed and now the text doesn't
Auto Add Subform in Zoho Creator
Hello, Could you please help me with how to auto create subform in Zoho Creator? Here is an example: Mainform Start Date is 14.11.2017 End Date is 17.11.2017 No.of Overnights is 3 nights. Is that possible to auto create 3 subform (based No.of Overnights). First one "Date (Overnight)" is 14.11.2017 (the same as "Start Date") Second one "Date (Overnight)" is 15.11.2017 Third one "Date (Overnight)" is 16.11.2017 Please check the below photo. Thank you in advance for your help!
Deluge code error in crm function
function getProductsByCategory() { products = zoho.crm.getRecords("Products"); categories = {}; for each product in products { category = product.get("Product Category"); if (categories.containsKey(category)) { categories.get(category).add(product); }
Automate and schedule data export CSV to a fisical folder
Greetings, I need to plan to export a table to a folder to synchronize with another software. At the moment I manually export from the settings screen of my "companies" table and save the csv in a specific folder on the physical server accessed by the
fields should be enable in a particular time
Hi, i have a form with 3 time fields,start time end time and shift time.and i added some data into it.Another form with shift time as lookup and some other fields.if start time<shift time<end time the forms fileds should be enable.otherwise fileds should
can't create report with connected datasource Form
Am I correct that in creator can't create report with connected datasource Form (or even add record from another form) I connected my form with zoho sheet and can't do anything more than send data to the sheet Is there any other option?
Zoho Creator - [Free Webinar] Learning Table Series for Logistics
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
How do I filter a subform lookup based on a main form lookup?
We represent multiple vendors as commissioned sales reps. We track our sales by entering them on a Purchase Orders tracking form. One of the fields on the main form is Vendor, a lookup from the Vendors table. The form has a subform to select the Product sold, and enter the cost and order quantity. The subform field Product is a lookup from the Products table. I would like to limit the list of Products in the dropdown to only those sold by the Vendor that was selected on the main form. I can't figure
Show Hide Zoho Creator subform Fields
It seems like ZOHO has recently launched a new feature that allows users to hide/show Subform row fields, which was highly anticipated. Previously, users were using the disable/enable feature for this purpose. Reference Code:- if(row.College_Name.isEmpty()
Next Page