Deselect (empty) a lookup field
in On Edit / On Success of Form A I can manipulate a field (lookup/single-select) in Form B like this: rec = formB [ID == 12345]; rec.lookupfield = "option 1" ... as long as 'option 1' is a valid selection in this field. But how do I empty the field (it is not a required field)? These 3 do not work: rec.lookupfield = null; rec.lookupfield = ""; rec.lookupfield = "-Select-"; Any suggestions?
creating Variants for a product
I am trying to create teh same functionality as zoho inventory has to create item groups. As and when the options are added to a attribute and seperated by a comma a new list of products is added to the table below. How to achieve this functionality in
Emojis in HTML Snippet
I am not able to add emojis in the HTML Snippet. Everytime I add one, all the code disappears. Is there a special way to add them?
Publish form as a public calendar?
Hi All! We have a creator app that's basically built to manage various events we're working on with associated tasks. Whilst the 'Calendar View/Report' in Creator is handy it'd be much more useful if it can be published as a calendar that our team can
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?
Can I get file data from the file upload field upon submission?
From inside my Creator app, my users need to send images (.jpg files), documents (.pdf files) and spreadsheet tables (.csv files) to one or more external APIs. Is there any way to grab the file data (I need to include it in my API calls) from the file upload field upon clicking the submit button?
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);
Rename Record Summary PDF in SendMail task
So I've been tasked with renaming a record summary PDF to be sent as part of a sendmail task. Normally I would offer the manual solution, a user exports the PDF and uploads it to a file upload field, however this is not acceptable to the client in this
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
TrackmyTime- Zoho Creator Time Tracking & Employee Monitoring App
Hello all, After months, weeks, and days of planning, preparation, and a heap of hard work we've published a custom app-TrackmyTime in the Zoho Marketplace. ⏰Time is something we can’t get back! That’s why it’s important to track your time and see if
Calling the new 'Custom API' feature from within a Custom Widget
From what I've learned it is not possible to call an endpoint from the new "Custom API" feature within a Creator Widget. The SDK's doesn't support it yet, when calling it natively you end up with CORS issues or at least I couldn't get it working even
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
Highlight question
Hi, How would i set up the below question using Zoho? My ideal analysis report is delivered <daily / weekly>. It is <factual / opinionated > in nature with <text only / text and charts / mostly charts> and is <1-minute / 3-minutes / 5-minutes / 10 or
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,
Dynamically populate drop down based on selection of previous record
Hi, I would like to populate a drop down based on the selection in the previous data. For example there are three drop down Country, State, City. Based on the selection made in the "Drop down Country" "Drop down State" should display only states for the country selected "Drop down City" should display only cities for the state selected How can this be achieved?
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?
error occured please contact application owner
Hi Zoho, I am facing an error on my application on Zoho creator. The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. However, the data has been trapped in the database. The user doesn't know this and tries to re-enter the data, causing multiple entries. Can you please help? I can give you access to the application if required. Naveen
Is Zoho Creator Currently Experiencing Issues?
I have received suddenly reports from my employees indicating intermittent service disruptions in Zoho Creator.
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.
Custom Buttons in Stateless forms - how to bypass form validation criteria
Hi I have a number of stateless forms that have mandatory fields which are required to perform an action (e.g. insert records into another form or send an email) I want to create a custom cancel button with the only action: openUrl("#Script:dialog.close", "same window"); However, when I click this button, I'm prompted to fill in all of the required fields on the form. Of course I want to be prompted to fill in the required fields if I'm clicking my 'Submit' or 'send mail' button, but - how can I
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.
problem with dollar sign replacement
Hi, I am trying to avoid users from entering the dollar sign in a string field So I want to check if the dollar sign is in the string and if so replace it with nothing if (input.invoer.indexOf("%") >= 0){ input.invoer = (input.invoer).replaceAll("%","");} This works other characters. If I do this for # or & it works. But only not for the dollar sign Please let me know how to solve this? Rob
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
Next Page