Storage of secrets/ token/ credentials
Hi, How can I store credentials and tokens in Creator so they aren't accessible to others? Or perhaps 'what's the best practise for this'? I created a form to store the values for a bunch of API calls, then encrypted those fields, but of course we can't
DataBase
Creating and working with DataBase.
How to filter page values?
Hi, I am new to Zoho creator. I created a page with panels based on form values. But I couldn't find a way to filter the page values with user selected filters. Please refer the attached screenshot. I am seeing Search component in Page. But it is not allowing me to add drop down or calendar which is required in this case. Could you please point to the right direction?
Adding a single item through Zoho Books API returns {"code":4,"message":"Invalid value passed for bulk_update"}
Hello, I need to update an invoice with hidden items (rate = 0) in order to have the inventory updated accordingly, as well as monitoring the full project's economical efficiency. To do so, I am passing the Zoho CRM customer ID, Project Name, Article
Filtering an embedded Analytics dashboard in Creator
I have an Analytics dashboard that shows key stats by organisation(s), based off two main tables synced from Creator (projects and project members). Within Analytics, it works beautifully. However, when embedding the report into Creator, I need to pre-filter
GetProjectDetails Integration Task returns only 100 last projects ?
Hi Everyone, I am new to Zoho and Deluge, so this may be an easy one for the experts :). On Form load, I am populating a dropdown field with the list of all active projects. I do this using a Zoho Projects Integration Task: projects_response = zoho.projects.getProjectDetails(portal_name);
Can i create a booking form that doesn't allow double booking?
Hi, I'm trying to create a room booking form with online payment. There is one room available between 9 and 11pm. Is there a way of creating the form so that more than one person can't book the room for the same time? Ideally, there would be a calendar that is greyed out on already booked days. I want to use a form because i need to push the record through to a calendar report. Thanks
Duplicating Reports with different values from API
Hi, I want to be able to duplicate a report (same fields and layout), but I want to have different data in the columns from API calls from the CRM. So, for example, my original report would have fields like 'Seller', 'Total Sold', '% Sold' with data pulled
Invoicing Software
Hi, Is it possible to create invoicing software with Zoho Creator? with the possibility of implementing SAF-T (Standard Audit File for Tax purposes)?
ANY HELP WITH WRITING BACK TO An EXISTING SUBFORM RECORD
Tried this so many ways... How can I write this back to this "subscriber list"-FORM with Field List "Demo" or ID "3412703000009959015" ? My Inventory List already is setup with a list of contacts and I want to write more records from another form with
Customer Portal - Restrict/Hide/Modify form fields to customers only
Hi, I am attempting to setup a customer portal for my existing database allowing customers to add new orders. I would like to restrict, hide & modify different fields for customers inside the portal, without changing the fields for existing user accounts that are not in the customer portal (our staff). Basically the same form will be viewed/interacted with differently depending on whether its a staff member or a customer. What is the best way to go about this? Is there a guide to follow that will
Renaming Record Template
Hi Zoho Team, I would like to confirm if this possible to rename the template once successful submission of form -> sent email notif I haven't tried yet but will Display Name accepts this? - declaration of variable
Notifying portal users with specific permission
Hi, I want to use deluge script to send push notifications to the portal users with specific permission. How can I do that in Zoho Creator?
Strange deluge error trying to access data from List
Hi all, Some background on my problem: I have a form that accepts some values from keyboard input pictured below. The form section values are named "Non_Discountable_1" and "Non_Discountable_1_Quantity" from 1-10. The left field is a multi option dropdown,
Duplicate record in form and related form
I'm looking to create a "duplicate" button. I have a form and a related form. By clicking on "Duplicate" the record of the first form and the linked records of the related form should duplicate themselves. Any idea ?
AI that checks text content quality and for plagiarism
Hello, A client has a requirement where the users will be typing in content consisting of multiple paragraphs in Creator. The text box will be checked for plagiarism and also for its quality. What would be the best approach for that?
Zoho Creator On-Premise
Hi, It would be great to have a On-Premise Zoho Creator version/solution for clients/organizations that require to store the data on their own servers. Is that something to come on the near future? Thanks.
JAVA RENAME FILES
Hil All, Its possible to change the name of the File that user upload in a file field (PDF format) with data that already exist in the record? Best Regards!
Hide form *section* with Deluge?
Hi folks, I have a form with questions arranged into sections. I want to hide/show a given section or sections on user input with a given field. I'm obviously aware that I can hide individual fields with Deluge - but I can't see a way to hide/show a section. Does anyone know a way to do this, or is it only possible at field level? Thanks in advance, James
Zoho Creator - [Free Webinar] Creator TechConnect Series - Custom widgets and extensions in Zoho Creator - Part 2
Hello Everyone! About the Creator TechConnect series The Creator TechConnect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into key essentials and technical nuances while building
Fetching data and updating data
I have a form called My_Info that has a field called Validation_Credits. Now I want that whenever I successfully submit another form called Customer_Details the field value Validation_Credits in the form My_Info deducts 1 and updates the value. So if
Where is the documentation for For, while loop implementation?
Folks, According to the roadmap http://help.creator.zoho.com/Roadmap.html, this feature is implemented already. However, I am not finding any documentation that talks about this. So is there any documentation about this? Any update will be appreciated. Thanks.
Attach Record PDF to Email
Hi, We send test reports to clients via email and attach the pdf report for that record. This is currently done in Access. We have nearly finished our App in Zoho, however, hit a snag. We have created a button to download the record as a pdf as below, which works well. https://app.zohocreator.eu/zohoapp/app/record-pdf/reported/15794000002731111/test-report-123 How can we attach the record as a pdf attachment to an email? We have the email all set up ready, just not sure how to attach. Many thanks
IF/THEN Statement
I am trying to write an IF/THEN statement in a formula field. when I use the conditional formula builder it returns the script below. if(Current_Odometer>=(Last_Oil_Change_Mileage+Oil_Change_Interval), “Due”, “Coming Due”) I then get the message below.
Sendmail function- customise Attachments ?
Hi, I have the following creator sendmail function working- sendmail [ from :zoho.adminuserid to :EmailTo subject :emailSubject message :"" Attachments :template:Staff_Setup_Template:Employee_Setup_Forms recordid as inline ] But I want this function to
Authorization for rest api
I dont see the india dc in client settings thats whya the code generated shows invalid client
How can I get only month and year in Date format
Hello, I want to show only month and year in Zoho Creator Form Builder for that I used Date Field as input . But in default it shows like this only 08-February-2024. I want like this February-2024 . Is there any way to resolve this .
Custom detail view is not visible on mobile devices.
I'm reaching out to address a concern regarding our Zoho application. It has come to our attention that the custom detail view we've created is not visible on mobile devices, whereas the default detail view is accessible. Could you please investigate
Best way to sell an app
Hi, I would like to sell an app to a customer, but I hope to have different customers for the same app in the future. My customers don't have technical skills, then I need to provide them an easy and whole solution. Which do you consider is the best way and cost-effective to sell them? The alternatives that I'm considering are: 1. To buy different Enterprise Users in order to establish Roles and Profiles to my customers. 2. To buy a customer portal and share my app from zoho developer to the zoho
Why is Creator so SLOW?!
When I first started working with Zoho Creator on a project a few months ago it seemed relatively quick. When I say quick I mean that the page load times happened right away and the processing of the deluge script occurred fast. Now I find that the application I built is painstakingly slow! Has anyone else seen this? It seems the more forms I have the slower the app but now that I just tested an app with 1 form, it also seems slow. I'm a consultant who has built a huge application for my client
Getting Subform Data from API
How do I get subform data from the api Get Record by ID 2.1 endpoint? I've tried all the different field config parameters, and I have the subform data in the detailed report I'm trying to pull from, but I never get subform data in my response.
Are the Integration tasks still using API V2.0?
Are there any plans to update the integration tasks to use the V2.1 API? I'm assuming it's still on 2.0 since I can't seem to stop the workflows from triggering when adding a record and I haven't needed to bother with the external API yet so I'd rather
Reset Auto Number field
I could be missing something really obvious but how after testing can an Auto Number field be reset?
Custom actions are not displaying on mobile
Hello, I have created a custom button on one of my reports for each record. The button is working correctly and displays fine when viewing in browser on my PC. However when viewing on my IPad, the custom buttons are not displaying. I configured the report for mobile to show the custom button, but it is still not displaying at all. any help is appreciated, thanks.
Problem with If statement in html page
Hi there! I'm trying to make a HTML page and I need to apply some conditions but I don't know where is my problem. This is my initial code: <%{ bill = Presupuestos[Code1 == input.code]; entorno = Entornos[ID == bill.Entorno]; %> PRESUPUESTO <%=bill.Code1%>
Map Report Pin Colour Customization
Hi, I would like to make this simple customization in Map Report. I've got a form like this: Name Address Type I would like to change map pin colour using the "Type" field, for example: Type=Hotel -> Red Type=Restaurant -> Green and so on. Is that possible? Thanks, Massimo
Addition of row based on Subform View type
Hi there, Straight to the point, if I use Subform View type List, I want the row is actually added when I click on the Done button, instead of added as soon as I click on the Add row button. My use case, I have: 1. A subform in the List view, has a field
can we edit certain things in zoho books using ZC
Greeting im new to zoho Creator we have been using books for months but we found that certain actions not available such as approval process for Journals or Payments Bill that they dont have option for super admin approve before sending can we do such
Can I host my own custom fonts on Zoho Creator and use them in pages?
Can I host .ttf, .woff, .woff2 files somewhere in my creator app or even other zoho product and use them as fonts in my pages viewable by portal users?
The Contains Function Fails for a List Due to BIGINT Error
Finding is a list of integers (ID values assigned by ZC). In attempting to run an aggregate counting, I requested to count how many times an ID number was in this list and it throws the error. I feel this is yet another example of how the new lookup requirement to only reference ID numbers is causing issues.
Next Page