Update related record in Zoho Creator
Sorry if this is an obvious question, I'm starting to work with Creator and there are things I don't understand in the docs. I have two related forms. Each record in form B has a field to connect it to a record in form A. The relationship is one-to-many:
Zapier integration Name Field
Hi, I've done plenty of integrations from Webflow to Zoho Creator in the past but i'm struggling with this one. I have a form in my Webflow site which captures First Name in one field, and Last Name in another field. I'm using Zapier to push the data
Showing sub-form records in a approval process
Form A is a purchase order with a sub form containing product items related to Form B. I create a approval process for this Form A. But when I tried to approve the form A others have submitted. I couldn't see the sub form content. It only showed the ID related to the Form B.
How to Start Page or Default Page for Customer Portal
Hello, How can I set the Start Landing Page a Zoho Creator App client portal accessed via mobile? I am currently seeing sections. Thank you!@
Create Multiple Filters for Report Based on Customer Profiles
Hi folks, I am currently building a creator app for order delivery. I have two profiles for the customer portal, Admin and Driver. We have a delivery report to keep track of the delivery. Here is the question: Without duplicating the reports, how can
Fetch data
Hi, I am trying to do the following. I have developed a plant database where I want to create an observation record from a plant record. So when in the plant record I click 'Observe' (Havainnot) which opens the Observe record. I want it to automatically
Set expression for formula field on Zoho Creator
Hi guys, I am stocked with an apparently simple formula that should calculate the time between a “start time” and “end time” fields. Can some one please share some ideas to solve this? The formula field should calculate and show the time in hours and
Zoho Creator Upcoming Updates — May 2023
Hello everyone! We're back with more monthly updates after a short hiatus. During that time, we've been hard at work improving the user experience and adding new features to our platform. Today, we're pleased to announce a wide range of fascinating new
Creator: Calculating and Recalculating Sum of Two Subforms
We have a form with two subforms within it. I’m trying to run a loop through both subforms to calculate the sum total in a field that is separate from both subforms. How can I calculate the sum total of all “Rate” fields within both subforms? Also, I
pop form in a report action buttin to update a filed
Hello i know i am missing a simple thing but can someone help i have this (Update price action button ) in a report named Hold_item with this code inside the workflow openUrl("#Form:Update_Hold_Price?Cartlow_FBS=" + input.ID ,"popup window"); its suppose
Access subform fields from a lookup field in template records
greetings I'm working on a record template for a form where i have a look up field which allows access to a subform in another form, now i want to list that subform fields in a table, but i'm not able to find anyway to access any of the subform fields,
Creator Pages : URL actions in panel using parameters
Is there anyway to set the URL action of a panel to include a page parameter ? I have a parameter of "Sector" so how could I get the following URL to work : https://MYSITE.zohocreatorportal.eu/#Report:all_carbon?sector=Sector I've tried sector=input.sector
Get URL of image uploaded in image field
After several hours I decided to write this topic... I have tried several methods to make it work, but none of them solved the problem... I need to get the URL of an image uploaded in an image field called: "tempImage". I need to retrieve this data in
Zoho Creator Upcoming Updates — June 2023
Hello All! We continuously strive to enhance and improve Zoho Creator with new capabilities. Continuing with this journey, we're excited to share the latest developments and progress with you. Let's dive into the highlights of the month! Portal page customization
Formula Field In Subform
Hi Everyone, Kindly let me know how we can use Formula Field in Sub Form ?
Some Old Fields Appearance
Hi Everyone, It is observed that some fields which are already deleted earlier, but such fields are coming in the list for selection. For better understanding, I am attaching the screenshot for the same where two fields are highlighted with red color
Retrieving Data From Sub Form Of Other Form
Hi All, I would appreciate your help/guidance for the following scenario. 1. There is a "Purchase Order" form where there is a sub form called "PO Detail". 2. "Purchase Order" form have date, party etc. fields whereas "PO Detail" sub form have Item, Quantity,
Updating Feild by itself and code not working on new line on subform
Hello, I created a subform for recording time then I wrote a code like below but this code is working only for 1. row. When I tried to add new record the code doesn't work. Also the field isn't updating by itself. I have to insert random time first the
Adding subform columns while creating a new report component
I have created a form for adding inventory purchases. To add multiple entries, I have created a subform. The form is working fine. However, while creating a new report component it is not allowing me to create a dashboard using subform columns. PL h
Anchor tag in ZOHO Creator HTML Page
Hi, I was trying to add Anchor tag in ZOHO Creator page but it seems it is not working correctly . When I click on anchor link it jumps to the location but instantly the entire page is reloading . That is not something anchor tag should be . It should only jump to specific location not reloading the page. I tried below <a href="#FlightTool">Flight Tool</a> <a name="FlightTool"></a> Did anyone try the same ? Thanks Arfater
[Live Knowledge Sharing Session] Ask the Experts: All you need to know about Building Relationships in Creator
Hello Everyone, We are immensely happy to be letting you know that we are back with our Live Community Discussion series: 'Ask the Experts'. The topic we will be addressing in this series is 'Building Relationships in Zoho Creator'. We have formulated
comment avoir une version française de l'application hotel management
les différentes rubriques de l'application sont en anglais, pour mon hotel j'ai besoin d'une version traduite en français, comment l'avoir? merci d'avance.
Date field on iPhone
Hi guys, I'm getting reports from my users that they can't type a date into a date field - they are forced to select from the calendar. This seems only to happen on IOS. This is a problem when trying to quickly input dates of birth. Some of them are scrolling
Creator: Record Templates
When creating Record Templates within Zoho Creator, it asks the user to select the form it's based on ("Based on the form" see #7 here: https://www.zoho.com/creator/newhelp/app-settings/create-new-record-template.html) My question is, what if I just want
Zoho Creator - [Free Webinar] Creator Tech Connect - Deluge Built-In functions with Use-case and Cloud Function
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
how to calculate a Year, Month and Days from DOB
Hi, How to calculate a Year, Month and Days from DOB For example: DOB = 30-May-1995 Date = 22-Jun-2019 output like: Year - 24 Month - 0 Days - 23
Pivot table reports stuck on regeneration
Hi, All my pivot tables have been stuck showing "regenerating" for 24hrs. All tables are now only showing partial data. There are only 4000 records in the entire database so not a lot of data at all. Problem is we need to report on that data TODAY! I
Mobile Popup Form: How to close upon submit?
I made a short video showing where we're stuck. On mobile, how can I make a popup form closeout of the browser upon submitting? Not sure if that's even possible. In a perfect world, we'd like the popup to close out and/or be sent back to the Detail View
Creator Subforms Question
Should every subform I create be it's own form? I can either add a subform directly within the main form OR make it it's own form and then add it as a subform in the main form. Are there any major pros/cons to these options? I keep getting the feeling
Zoho Writer Merage Template and send for the sign by the API
Tips & Trick - Zoho Writer API Hello All, How to Create a Merage Template inside Zoho Writer. Enter Field.... //...........Get Mearge Field Data <response> = zoho.writer.getMergeFields(<document_id>, <connection>); //...........Create Map........... writermap
Customer Portal and Field-level Permissions
Under Settings, Users & Permissions, 1 of the 4 menu options is "Field Permissions" Under Customer Portal, I see no such option. My question is "Can I control Field Permissions for Portal users the same way that I set Field Permissions for Users? Thank-you, Kevin
"Add New" Items in stateless forms cause issues when touched on a click "On Submit" workflow
This is a new error. If I select a existing drop down record in my stateless form and try to use it on a onclick workflow, it works, but if I select "Add New" on that drop down and use a new item it wont work. If I exit the form and begin again I can
How to get a image url
Hi, This is Surya, 1. I want to get the URL of an image that was uploaded to the Zoho creator using image field (uploaded through local storage). I referred [https://www.zoho.com/creator/newhelp/forms/fields/image/understand.html#File_download_URL] to this link but i didn't get the solution. I followed the instructions in the above link.and when i click the button I get an error. Refer to attachment for error. 2.I am trying to integrate with Facebook and i want to post an image to Facebook from the
Input fields in HTML or ZML snippets
I'm trying to design a html search-result list report page. I used the search option to add one field on the page but i need to add more fields. Is there an option to add input fields on the pages?
Emailed links vanishing
Does anyone else get complaints from some of their portal users that emails are losing links? This is happening on really core emails like password resets. Most users will receive a perfectly good link, but some just see plain text instead. And when
Using dropdown append and add functions on a dropdown field inside a dynamically generated subform row
Greetings i'm working on a subform where i will create rows dynamically and assign them values on form load. i also want to assign choices dynamically to the dropdown menus of each generated row. the issue is when i try to access the :ui of the dynamically
Zoho Creator Upcoming Updates — March 2023
Hello all! Zoho Creator continues to rapidly develop new features and functionalities to help you solve your business challenges. We'll never cease working to amaze you with incredible new updates. And today, we're announcing a neat range of features
ZOHO Upgrade - What a mess
Since you Upgraded us automatically nothing has worked correctly. Our developer has contacted you several times but to no avail. Therefore, we have developed our own system and are cancelling our subscription. It was a great product but, as far as we are concerned, your auto upgrade is a real mess. Maybe you should, like all other software suppliers, offered the upgrade but not made it automatic. Anthony Gemmill - CEO Imagic (UK) Ltd.
Filtering for Date Field
I am wanting to create a filter so I can filter by day of the month, rather than filtering for the whole month. For example, if I have data input on 22-Jun-2007, I want to be able to filter on just this specific day. Any suggestions?
Convert Date field DD-MMM-YYYY to DD-MM-YYYY
I cant seem to figure out how to change a date field in the format DD-MMM-YYYY to the format YYYY-MM-DD I understand i need to use string and date functions but still cannot quite get it right. Any help? Thanks
Next Page