Zoho Creator with no app gallery
Hello, The App gallery its gone? When i create a new app it used to send me to a app gallery like this: This menu doesn't appear anymore, and i need to use one of the apps on the gallery, what can i do? The pre-maded app i need its "Sales Management". Thanks
Fetch data in different Applications
Hello, Working in Zoho connect I make applications in different groups according to the data access users are being given. In Group1 their is AppName1 and AppName2 and have both different Forms from which MembersForm in AppName1 In Group2 their is AppName3 with an Form UserinfoForm that, as in AppName1, contains a LookupField 'Name' that links to AppName1.'Name' and gives a dropdown form names introduced in AppName1 - MembersForm. My Problem is to fetch the data of other fields present in MembersForm
Can the Lookup Field pull in data from a Photo Field
I want to enable the lookup field to show Students Photos that where selected through the Lookup Field from the same form or create an association from another form. For example, I want to show a group of students who are boys in 7th grade math. I can pull in all the corresponding data from Boys, Grade and Class. But I'm unable to get the photo's appear as an association for the Look Up Field.
Sections in forms
Hi... let me start by saying that this is a great application... Here is a thought... Whenever we make a form, the form can have multiple sub areas. For example, when we make a form for say a contact, the different areas could be office address, home address, personal details... stuff like that... It will be nice of you could allow me to add such form dividers... Thanks... Aseem Saxena India a.saxena
Summarize Subform in a Single Line
I have a subform that contains two column describing a pesticide. The first column is a lookup (compound), the second is a decimal (concentration). However, in one of my reports, I have to summarize all this information in one line. For example: Product A (Single_line) Subform: Compound 1 Concentration 1 Compound 2 Concentration 2 To be displayed like that in a Single_line: Product A - Substance 1 (Concentration 1) + Substance 2 (Concentration 2) Is it possible?
Ask the Experts 1: Using Customer Portal in Zoho Creator: All you need to know.
Hello people, We're happy to tell you that we'll be launching a new community learning activity this month: 'Ask the Experts'. This is a live knowledge-sharing session where our technical experts will answer all your questions in real time. We'll be doing a session every month and each session will focus on a new topic based on popular features and questions frequently asked to our support and community teams. Our first 'Ask the Experts' session will be held on 8th March 2018 between 6:30 and 11:30
Zoho creator calendar report & page
Hi All, i need some help. Please find the attached image. i have done some customization on the event management page. instead of showing the calendar field, when clicked. can it link to another page? like i clicked eventA in calendar report, it will show the search eventA in the page for me to book.
zoho.encryption.base64Encode(); did not work
Hello there, 2 weeks ago, i write a Zoho Creator Function, that encodes a String. Today, i want update this Function, but i cant Save them, becouse the Script compiler send me an Error is this a Compiler Bug? Or did the syntax changed? Thanks! Kind Regards Klaus Brandt
Zoho creator api
Hi I'm traying Zoho creator api to export an app report whit a php form and I'm getting this error {"code":2945,"message":"PATTERN_NOT_MATCHED"} I found the code is "Invalid Ticket" and I don't know what it means my url is: https://creator.zoho.com/api/json/pruebasql/view/sqlprueba1 hope you can help tnx
Cancel (and Other Buttons)
Forms only have Submit and Reset Buttons. I'd like to be able to add other custom buttons, particularly a Cancel button. I want this so I can attach an OnCancel script. In my case I want to direct to a particular form. I've worked around this by creating Stateless Forms, but it seems like I'm doing twice the work and creating additional confusions.
Stateless form + URL parameter + Web Page + Embed Report
I have Stateless Form to enter userID and password, the workflow of the button onclick is OPENURL with URLparameter of userID and password to a Page. In the page I'm using an embed Report. Is it possible to add the URLparameter to the search string of the embedReport? I tried different approaches most of the time it crashes and I have to delete the page and start over... Thanks, Martin
Auto formating field
Hi, I want to enter GPS coordinates into a field and format it automatically OnValidate. The user will enter "46 51 10" and the field would automatically reformat itself to 46°51'10"N How can I acheive this? Thank you!
Fetch records
Hi, I'm new to this and it's my first post in this forum. I'm struggling to get data from a related form into a field. It's something to do with the lookup value being in a lookup dropdown I think. Form A (Room_Cat_Form) has fields called Room_Usage and CtFm_Net. Form B has a lookup field for Room_Usage and I need the corresponding value of CtFm_Net in another field (Usually_Net). I tried this but it just returns the Record ID. input.Usually_Net = Room_Cat_Form[CtFm_Net == input.Room_Usage]; It's
Lookup field that aggregates two reports
I've a lookup field "Purchase Order" but the orders can reside in either of two Reports "Purchase Order Product A" or "Purchase Order Product B" Any idea how I can make appear entries from both forms in this single lookup field?
Zoho Integration
Hi, Is it possible to integrate a Zoho Creator App with a local database? I want Zoho Creator to INSERT/UPDATE/DELETE records into a local database and viceversa. Thank you
How to show the top 5 results in a Report
I've created a database and I want to see the top 5 sales people at the end of the week. I've looked at the User Guides and I haven't found a definitive answer. Any insight would be appreciated! SC
Zoho Creator performance problem and thinking about switching to salesforce.com
I have some complicated Zoho Creator apps written. With around 30 forms connected to each other. One main form is approaching half a million rows soon, and probably expanding to 10 million rows in the next 3 to 5 years. Clears some Zoho Views (called "reports" now to add to the confusion), are not loading fast enough for any of my applications. If you change the criteria for the views, and try to reload the view, it just gets stuck. Sometimes I have to mass-process say 500 rows in a single form for
Inventory Items w/ Unique ID's Viewed Together
Just going to go ahead and apologize now if this is a DUH issue. I am super new and know enough to be dangerous. I am building an app for my home staging business. I have to track items that I purchase to use in my rental inventory, which gets moved between properties. I also occasionally sell these items to clients. So the app includes recording inventory additions (have a searchable list of inventory), cost tracking for resale/tax purposes, and assigning "locations" so that I can keep track of
how to count field that is a dropdown iteam
hello my form have field name, batch, exam status I have a field in a form exam status with dropdown choice pass, fail, not sit how can i count under reports based each group of student and display total number of exam pass using count option. how to build the script hope you can help thanks
horizontal multiple checkboxes on one line
What would be the best way to recreate a single row with multiple checkbox options?
Zoho Creator Calendar Report & Pages
Hi all, i have make some customization on zoho creator event management. i want to show the calendar report of the event in the page to let customer have a look of the entire event. instead of showing the calendar field when clicking, can it link to another page? please find the attached image. red & green arrow is the normal, i want is the black arrow. Victor
Docusign integration with Zoho Creator - Update envelope status - PUT method
I have managed to set an integration with Docusign to create envelopes. However I have a problem to update the envelope status to void, using Docusing REST API method. Since Zoho offers the posturl method (POST), I have tried including "X-HTTP-Method-Override": "PUT" in my header (instead of POST) without success. I keep getting the the following error: " INVALID_REQUEST_PARAMETER\" - "The request contained at least one invalid parameter. Invalid value for 'status' in envelope definition. Only 'sent'
formula field expression
I need to use the TODAY date in a expression for a formula (calculated field) but nothing seems to work. How do I get the TODAY date ? Thanks.
delete Customer portal User via Creator
Hello, my problem ist, that i have a Customer Portal with many customer accounts. Now, due to security, i must guarantee, that any User can Delete his account by Click. Aktually i have a "Delete Account" Page. This page ask for the Password. On send with the right Password, the User where Logged out and in Zoho CRM where marked, that this account ist disabled, so the Customer Portal didn't show any Data. BUT i need, that these account where deleted from the Creator Customer Portal. Is there a Solution
Multiple Conditional Formatting Rules
When I use multiple conditional formatting rules how do I control the execution order? e.g. If Rule1 says to color fields with less than 700 as Red and Rule2 Says to color less than 800 as Red will the order of execution matter and how can I control it to achieve the desired outcome i,e, 800+ No formatting 700 to 800 Yellow <700 Red
Any way to conditionally change CSS styles in a custom record summary template?
Hello, I have a record summary that includes fields that come from a related form. Each record in the first form may or may not have a related record from the second form. Now our client wants us to hide the fields from the related form if the first record doesn't have a related record. I tried using a formula field that returns "display: none;" or "display: block;" to insert CSS styles into the record summary, but when I view the record summary, the CSS is removed. Is there any way to use field
Using Functions in Record Summary?
I'm trying to get the record summary of Record Type A ("Players") to e.g. show the sum or count of all entries in a field in a connected Record Type B ("Games"), so that I can show the total wins that player has made, or total games they have played. I can access the field (e.g. ${Record_a_Match_Date_of_Match.They_Won_the_Match}), and it returns a comma-seperated list, but I can seem to perform any functions on it (e.g. sum(${Record_a_Match_Date_of_Match.They_Won_the_Match})). Is this possible?
Sport Stat Tracker (How to do create equations and display results)
I'm looking to create a Sports Stat Tracker. I've created the forms and the database to have my players register. I've already created a form and started testing. However I'm running in to issues on how to create the additional equations and how to create reports or display that players individual stats. Thanks! SC
Fetch all values from a single record
Hi, I would like to fetch all values from a single record but can't figure out the exact way. At the moment I have: det = Addresses[ID = input.Delivery_Address]; input.Address_Details= det.Account_Name + " " + det.Address_Line_1 + det.Address_Line_2 + det.City + det.City + det.County + det.Country; What I would like is something like: input.Address_Details = det.getall(); Where "getall()" returns every field values for that specific record in my Addresses form. I'm guessing it's something simple
Tips & Tricks
Hello everyone, We hope everything is going smoothly with Zoho Creator. We are always thinking about ways to make our community more engaging, vibrant, and informative for our users. That’s why we’re happy to let you know that we'll be sharing Tips and Tricks every fortnight, starting this Thursday. It’ll include some quick how-to's and best practices to help you get the most out of your Zoho Creator applications. We have handpicked these topics from the most frequently asked support questions and
href to popup using "zc_LoadIn=dialog" - and getting back to main page!
Hi Zoho, I use "zc_LoadIn=dialog" to open a form in a popup windows from an html page. this works great, BUT- after submitting the form is popping up again, blank, for another use. I need that after submitting (or canceling) the form, the user will be redirected to back to the html page (after a refresh). Reading this forum, I figured this could be done using "zc_NextUrl" -adding zc_NextUrl=#Page:parent_page_name gets me to the form I need, but empty (I have an ID specified for edit mode in the
Using the Multi Select Field results in a Lookup Feild
I'm trying to user create a registration form to allow users to select their city, then from which city they select to display which services that city offers. In the City Form, the services have been selected via checkbox. In the user form, I've created the Lookup Field however it can't sort or exclude data based on what services where selected. I've read several articles however all the design solutions seem to be for Zoho CRM. Is there away to do this through the creator? Thanks
Variable formdata for a row from a form
I need to write deluge script to send emails. the input.formdata variable won't work because this is not the "on add" / "on edit" actions... So the email body is to contain all data from a certain row in FORMA for example: FORMA[ID == 251445568000066556].formdata The email body is to contain all field names and values from that certain row where [ID == 251445568000066556]. How can this be realized in a deluge script? Is there a way to simulate form submission? Thanks.
MS Word crashes when trying to mail merge with Creator Plugin
Hi, I've installed Zoho Creator MS Word Plug-in, defined a simple form (just one text field) and I've been trying to do a mail merge. I can sign-in with the plugin, define the template but once I click 'Start Merge' the MS Word crashes. Any idea what can be wrong? Thanks, Jakub
User Management
Hi, I would like to request for a better user management system. I have 50+ users in the system and using Enterprise. It is very difficult for me to scale further because management the user is a big headache. Please allow some tagging or grouping and filter of user list. Regards Andrew
Changing Application Owner
Hi folks, I'm developing an application for an organization where I'm an intern. I created the application on my own Zoho account and have successfully shared it with the other staff. Since my internship will be over soon, I need to transfer ownership of the application to another staff member's account -- and I also don't want everyone typing my name in the URL long after I'm gone, heh. Any guidance? Do I need to get a Zoho staff person to help? Thanks!
GDPR Compliance
Am looking into GDPR compliance regarding data we maintain using Zoho Creator. Although Zoho has published some info on: https://www.zoho.com/gdpr.html I've been looking into implications about certain types of data we maintain on Zoho Creator and my understanding is that we need to keep a log of any changes to data. ie If a record is changed a log should be kept of the old value of the field and date and time it was changed and user that changed it. My question is is there is system-wide setting
subform writing to another form
I am creating an inventory system for a lending library of recording equipment. It starts with a parent form for selecting the user borrowing equipment, and in a subform a lookup field pulls the item number from the equipment inventory form. I'm trying to update the availability of each item loaned in the inventory on_success of the parent form. I can get the first item selected in the subform to update to the inventory form, but not the second, third, etc. Below is my workflow that is not working.
Custome creator app developing
How can I share my app with a developer if he'll be granted all access and data? is there a way to share the app without the data?
Genrated Image in Record Summary
I have a field with an URL to an image. Would like to display this image in a Record Summary, is that possible? The URL is dynamically generated so i cannot add it as a normal image field. Tried to wrap the field value in some html img tags, such as: <img src="${Value element}"> but that is not accepted.
Next Page