How to make a formula that incorporates other formula fields?
Hi, im creating a complex quoting tool in Zoho Creator. Im using formula fields to calculate the price of certain add ons. I need another formula field to add all of these other formula results together. How can I do that?
How to use a conditional formula based on a lookup?
Hi, I need a formula that is something like this : if(Test = TRUE, if(Installer.toString() == "Patriot", 1000, 0), 1). However, Installer is a lookup field and zoho doesnt seem to be catching that. How can i make that work?
Zoho creator Integration with Biometric
Hello, Is there anyway to store biometric details for each employee inside my custom made Zoho creator application as a field and then use it to track attendance of the employees, if there is any what device do you recommend to be used for tap-in\out and what api should i use. Thanks,
Adding Subform Row Values together
I am having a hard time figuring out how to add values from a subform together. I have a subform called - Payment_Information When people pay us, I record the payment in that sub form called - Amount_Received. If they pay in full, it's just one line and
Auto fill in fields after selected lookup dropdown menu
Hi everyone~ good evenning/morning I am a very new and beginner of Zoho creator. i have test almost a week, and created some databases and forms for users. i am started to love zoho products and i am considering to have paid version instead of trial version.
Page Parameters broken with Page Variable Release
My page parameters are coming through as empty now that page variables have been released. I am unable to use the name of the page parameter to create a new page variable and I am unable to delete the old parameter to free up the name. I have tested a
Track date variable across a page
Hi I'm creating a page that has a few charts that pull data from another table. At the top of the page i have 2 buttons that allow the user to go back a month or forward a month in data that they're looking at and a text field that displays the current
Activate python application
Is it possible for a deluge code to activate a python application ? Say i create a deluge program, in that deluge program, i need it to activate a python application stored on my drive Would that be possible, and if so, what would the code look like
Sending Emails - Creator/ZeptoMail/Campaigns
Hi There, I'm looking for some advice on the topic of sending emails triggered by content in a creator application. We have a customer & order system application in creator and would like to start sending out emails to customers for order confirmations,
Field Service Management Application
Hello all...I am currently trying to use Zoho Creator to create a field service management ticketing application. I am new to Zoho, and coding in general, and know that I am in over my head at the moment, but this effort is borne out of necessity. Right now I am working on a relational database style diagram on how everything will tie together. I initially thought that everything that needed to be visually present when working a ticket (not necessarily creating a ticket) would be included on a
Deluge Script: Option to copy Rows from another Subform
Hi Zoho Team, Do we have an option to copy existing Field Rows(excluding the value) from a subform to another subform(stateless) on the same form. I hope I make sense :d
Please can we have an edit link when viewing a related form from a list view report?
Its great that a list view can display URLS for lookup field values which give you a preview of the related form. However, without being able to edit the displayed record you tend to have to bring up and other browser window and locate the other record from its dedicated list view report. Ive seen complicated work arounds to bury the edit URL into a field which is the included in the linked record view but thats just nasty IMO. Please could zoho add an edit link into the view record popup.
"Oops, something went wrong." on Google Drive import to Creator
This is peculiar, because I've been uploading records to my Creator app via Google Drive for over a year now, and it's always done just fine. However, over the last month or so, anytime I try, I get as far as attaching the file and then get a mysterious
Custom Sign-in and Sign-out
I've had a number of users ask me "how do I sign-out" when the sign-out link is clearly on the upper right of the page. To make it more obvious, you can use this bit of code to make a sign-out button on the top of any HTML view. You can customize the serviceurl as needed. <a class="zc-formbutton" style="padding: 5px;font-size:12px;" href="https://accounts.zoho.com/logout?serviceurl=https://creator.zoho.com/<%=zoho.adminuser%>/<%=zoho.appname%>/">Sign-Out</a> And since we're on this topic, you can
Click on Table Row to Edit
Hello, I am very new to Creator. Thank you for your help. I created a Report and added several Tables from Related Blocks. I want to be able to click on a row in the Related Block Table to edit the data. I am creating a Sales Pipeline App. The Contact
Accepting Callbacks in a Zoho Creator application
Hello - I have a Zoho Creator application that needs to query data from views (asyncronously) in Zoho Analytics. Using the Zoho Analytics API, I can submit an Export Job that includes a CallbackURL, whereby Analytics will POST to the URL when the export
Do we have an update for Subform Hide/Show function
This gives an error invalid task in subform action - under >User Input of Field
Add Days to Calendar
I am creating an Invoice system. I have a field called - Terms, which is a drop-down with four options since I have customers that pay on different lead times. Due on Receipt Net 30 Net 45 Net 60 I have another field that is a date field called - Due_Date.
Zoho Creator - [Free Webinar] Creator Tech Connect - Canvas Builder in Zoho Creator
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
Drawing
Trying to build my first app, I need to be able to make small drawings/sketches. Is there any way to embed a drawing tool into creator?
C6 - URL Filter for Pivot Tables and Pivot Charts
With the changes in C6 ... is there now available a way to filter Pivot Tables or Pivot Charts using URL criteria in Creator? This would be extremely helpful if we can filter like in Zoho Analytics. Creator is using Analytics for the Pivot Charts and
How do you remove name or account name from Permalink url?
I created a private form I want the public to fill out. So I did a permalink iframe without login. However when I load the iframe and right-click, View Source...my personal name or account name is in the url. How do I remove or change this? Thanks! Robert
Hyperlink to local network pdf?
I appreciate that this may seem a strange request but..... Is there a way I can allow users insert a hyperlink in a form field, to a pdf file stored on our local network rather than upload the file? Appreciate that this will mean that users will not be able to see the file when not on the company network, but this is the desired functionality. tried to use the URL field type but this appears not to support the file:/// preface, it almost works but the browser opens without the ":" Hope this is not
Creating country drop down menu
Hi there, Apologies for the incredibly basic question, I'm just starting out building my first form on zoho. I would like to have a simple drop down menu field where the answer options are the standard list of countries. Is there a quick and easy way to do this or do I need to type in each country? Any help much appreciated. Thanks!
Work flow not triggering-- in creator 6
I have an application. It has a Payment received form with the 'Inv/Ret' field, 'Amount', and 'Amount accounts' fields. My requirement:- When 'Inv/Ret' is null AND 'Amount' is not null and 'Amount accounts' is not null. It should send a mail to the login
Zoho Creator - [Free Webinar]Learning Table Series for Trading and Distribution Management + Canvas builder
Hello everyone! Mark your calendar for the next Learning Table Series on Trading and Distribution management + Canvas Builder. What Trading and Distribution management is the process of overseeing the movement of goods from supplier to manufacturer to
"code":2930," when I use creator.getRecords()
id = input.batch_transverse.ID; info id; A = "ID == " + id; response = zoho.creator.getRecords("xxxx","xxxxx","xxxxx",A,1,200,"oauth"); info response;
Chart comparing different filtered records
Is it possible to have a line chart that compares different filtered records. So for example I have a form where a customer can be marked active or inactive. In this form, I have another field which has the month and year that the customer started. I
How to make text larger in an Export to PDF?
I am exporting monthly reports to a PDF (from Creator) and can't make the text large enough for my manager to read. It is fine when looking at it on the screen but she wants to have a printed version. Is there a workaround for this issue? I attached an example report so you can see the size.
Inventory SKU barcode printing
Hi I am a developer and am wondering if zoho creator or even zoho inventory have the capability to print barcodes upon submitting a form. I have been researching the forums and have not been able to find any way to do this natively in Zoho. Can someone
Portal and Main environment blueprint stages not aligning
Hi, We have a customer and order system using a portal account for our sales rep's to be submitting orders and customers. We've recently implemented the blueprint feature on the orders as order status management, we're finding that there is a delay in
import file upload and image
Hi, Good Morning. While importing records by "Import data" in reports, Am I able to import file upload and image ? Thank you
Can you make an email update a record in Zoho creator table?
On my application I set up a stateless form "Issue Request" that when the user clicks a button to open issue request it displays the stateless form. The users will then select the email address or multiple address' to send to. Enter the issue type and
Rich Text Editor: Insert Image
Having an "insert image" button in the RTE field would be beneficial. Currently, images can be inserted using the html button and the <img src="some url"> tag, but novice users don't realize this. I understand there would be complications to upload an image from your desktop in terms of how this image is stored at ZC, so I'm merely suggesting the insert image button only be for images with urls. As a best practice, mimic this forum's insert image button:
Fetch Zoho Learn data (Article ID + Article Title + Article Link) from Zoho Creator
Hello, I'm bulding an app to keep track of who's responsible for each task in the company + keep track of the procedures needed to perform the task. Here's the structure: Each procedure can contain on or more "procedure step". Each procedure step can
What is "Link to view"?
I'm having an hard time finding what the "Link to view" feature does of Zoho Creator: Thank you
Manage records order
Hello, I'm using Zoho Creator to create an application to keep track of who's responsible for each task in the company + keep track of the procedures needed to perform the task. Each task contains the following fields (there are more, but let's simplify
Automatically export
Hello, is there a way to automatically export all entries once a day as a csv file and store it in a folder? Alternatively, how can I access the entries of a form in Creator and retrieve them from Creator via Power BI? Best regards Jörg
Zoho Forms at Analytics/Creator or MS Power BI
Hello together, I wanted to include the data from Zoho Forms into Zoho Creator/Analytics to access it with Microsoft Power BI Connector. Unfortunately, I keep getting the message that my tariff does not support this feature. I have already upgraded everything
Parsing GS1 Barcode
Hello, I am building a simple application to capture inventory and location. The user would scan the item barcode and location barcode and would sumbit the form. I need help parsing the data. Here is a sample of an entry: 90I-3110-991010222179550 90 identifies
Next Page