Bidirectional lookups with 3 or more forms
Per the attached, I have 3 forms. My "main" form is PU, which has a unique field in it called PU_ID My two other forms contain PU-related data: PU PGIP and PU Data. I have bidirectional relationships established between PU and both PU PGIP and PU Data
Calculate between days of Leave
I calculate in between days but the problem is it also get the weekends. numberOfLeave = input.Beginning_On.daysBetween(input.Ending_On); daysofLeave = numberOfLeave + 1; input.Number_of_Days = daysofLeave;
Populating a field in the subform dynamically in the main form
Hi I have a main form and a subform. In both the subform and main form, I have the same dropdown field called Status. I would like Status in the subformto dynamically populate the status in the main form. I will have several records in the subform but
Upcoming Updates - June 2021
Hi all, We hope that you are all safe and in good health. It has been one of the most challenging times of our age and we, as a global community, are trying to deal with it to the best of our abilities. Zoho Creator team has always tried to stick to its
Update ALL records that fit criteria
In my form I will have multiple records that fit my fetch criteria of: Name.first_name == input.Participant_s_Name.first_name && Name.last_name == input.Participant_s_Name.last_name && DOB == input.Participant_s_DOB On successful submission of another
How to pass value of HTML textbox to page ?
I have created report using HTML & Deluge (Page HTML Snippet) .Now I want to provide some filter option to the end users. Someone please help me to pass value of html textbox ( <input type="text" id="dt" name="dt" >) to page parameter.
Filter stopped working, users can't view data
I haven't made any changes to my app and this morning none of my users can view their data. My form has an 'access' field so each record contains the emails of the zoho users that will be able to see it. Then on the report I use a simple filter that says access contains zoho.loginuserid. It has worked without problems but this morning for some unknown reason users cannot see any records and I can't figure out what happened since we didn't do any modifications to the app. 1. I am the admin and I
Split record into multiple records
I am not sure if this is possible, but hoping for any ideas to make it work. I have a form that my customers will complete to book their children in for a class. They can select to book in multiple children (up to 9) which makes the required number of
When the Lookup Field "Add New" is selected
How can do I intercept when this option is selected? and am I able to redirect to a stateless form instead of the pop-up?
Access Video using Deluge
I have a form where I can upload a video/audio. I would like to see if I can show the video as a iFrame over Zoho Sites using scripts
Invoke URL Function is showing execution error
I am using the trial service of Zoho creator. I have tried the code in the screenshot. but i am getting the WebhookCallWarn error in execution. Please anyone help me to exceute the script correctly.
Tip 27: How to upload files to Dropbox using the Dropbox API in Zoho Creator
Hi folks, It's been a while since our last tip. Hope you're all safe and doing well! This tip will talk about the Dropbox API that helps you upload files to Dropbox. It's one of the most common actions that you can perform by integrating Zoho Creator and Dropbox. To understand how this works, let's create a sample application called File Management App and learn how to upload files to DropBox by adding the Dropbox API to a workflow. Application flow The end user will upload a file to the file upload
Is there any way to access via Deluge the Developer API usage?
I'm working on a project where it is essential to know when the Developer API calls reach a certain point, and I would like to send some notification when they reach 50%, 80%, etc. Is there any way to check the number of calls uses in a given day using
Error when saving ZML code in Creator pages - "Cannot resolve the name 'panelType' to a(n) 'type definition' component."
Recently when trying to edit the ZML coding of page panels, we are receiving the error message: "Error found in line number 5 : src-resolve: Cannot resolve the name 'panelType' to a(n) 'type definition' component." This error occurs regardless of which
Use Page parameter to filter report embedded as a button
I have a Page for viewing information about a specific Project, it is filtered using a parameter proj_id In the Page, I have used Report > Embed as button to add a button to open another report in a new window, I want to filter this report on a field
Need User & Customer see only their own record?
Look like can not set disable sharing record to each user. We need Users and Customer from portal to see only their own record? Thank you
Many clients, same Zoho Creator App - How can we proceed?
Greetings. I hope find all good and safe! I have the following situation, and I would like to listen your thoughts. We are in charge of the management of some operations to our clients. Our clients use Zoho One as the operation solution. Our office is
Query parameter in Page report filter strips "input." after saving is causing problem.
Hi, I have a Search and a report in a Page. I have created a Query parameter for the Page to be used in the Search on the Report. I created a Report filter using the query parameter to be use as a Search for "Name" containing. In the past (June 2021)
Is there documentation for the Signup Helper
I can find the documentation for the "plan change" Helper here: https://www.zoho.com/developer/help/creator/configure-solution/helper-params.html But I can't seem to find the documentation for the "Signup" Helper. For example, what is in the customerInfo
Please change "more options" in reports or pages as a property that can be turned "off" just like "Export", "Print" can be unticked to disable them.
Hi, Please change "more options" in reports or pages as a property that can be turned "off" just like "Export", "Print" can be unticked to disable them. Sometimes enabling anyone of these options like "Spreadsheet" can be quite devastating if unintended
Set allowed dates on condition
Is it possible to write my calendar allowed dates into script? I have a dropdown field where people will pick a class. The day of the week that class is held on is listed in the name Eg: Monday 10am class, Tuesday 4pm class etc. They are then required
if we delete values in multiselect lookup field then automatilly it should delete in subform
Hi Guys, if we delete values in multiselect lookup field then automatilly it should delete in sub-form. Below i have attached pdf . Now in Item List field i have added multi select lookup of Fruits_Name and if we select Fruits_Name in item list those
"Unsafe attempt to initiate navigation for frame with URL" when trying to use stateless form filters on embedded report views
I have various stateless form filters and report views embedded in my PHP website. Until recently the workflow of using a form to openURL with an inframe target to an embedded report and pass in filter options worked fine, however now I get a "Unsafe
Search in the new CREATOR
Is anyone having trouble with the search feature in the upgraded version of Creator? This has become a real problem. I type in the box my search parameter (for instance "Moore") and press enter, then click on search. Nothing appears... and I have hundreds
Building a page that runs a script on multiple records
Hi there, I'm building a system on Creator for a loan company. I'm trying to build a page where they can go and search a name and then received a list of loans as well as the total payoff between them. Ideally a search form at the top, a record list/report
special caracters
Hi how i can validate on a input if an user use special characters like ´ $ % etc ?? i want that i use an special character dont have the option or throw an alert before submit thanks
WeChat Compatibility
I was wondering if ZOHO Creator has WeChat MiniPrograms integration? If not, when would this be available as it is key to reaching the China Market.
Subform limitations
Subform is generally a great functionality, I do believe it is limited so far in Zoho. 1. It displays all fields from the form. What if I only want to display some fields? 2. Can it be sorted? 3. It would be nice to have more of view like capabilities ( sum calculations), Ui 4. If I have File Upload in subform, how do I see it? I think it should behave more like view in that case 5. This is a different discussion, but I think File upload field, should allow some kind
Validating duplicate studio booking b/w same time interval
Hi, We have form with dropdown field "Studio" with options {Studio 1, Studio 2, Studio3} and date-time field "From" & "To", so suppose if I book ( ID 46 ) a studio from "15-Aug-2021 10:45" to "15-Aug-2021 12:45" with studio selected as "Studio 2" then
Calculating Time Difference between two Date-Time Stamps on Zoho Creator
Hello, I am trying to find the time difference between two time-stamps. We cannot use the timeBetween function on Zoho Creator so I am using the following script to find the number of days and then round off to the nearest higher integer. Number_of_Days
Speed of success message
Hi there, I added a success message to my application so that people would know their information had been successfully added. The only problem is that the message flashes on and off the screen so quickly that most people don't manage to read what it says and think it might have been an error message. Is there any way of slowing down the speed of the success message? suziea
Upgrade your account to download as mobile app
Greetings. I hope find you well and safe. I have downloaded an app from Marketplace. I am configuring that, but there is a part that says "Upgrade your account to download as mobile app", I don't understand update to what, once I already have Zoho One
Barcode Scanning - Auto Submit
Hello, When i scan barcode using a scanner the form automatically submits. How do i stop form from getting automatically submit?
"This report is not accessible" message in published page
I have created an application with some reports. The application includes a page with buttons, each of them with an "Open report" Action type. I have published the page to share it with final users, and when any of them clicks on a button, a page with
Override report name when embedding on page
Sometimes i need to duplicate reports just for changing the report name. It would be great if it will be possible to change the name of the report when embedding. Report header color also will be great improvement for the interface. Thanks
Can i share file from "Upload File" field with public link?
Thanks
Push Data from Excel into Zoho Creator using API?
Hello, How can I create an automated process through API where I input data into excel and it automatically pushes them to creator? I used to have a migration tool that helps me with that but now Zoho removed support for it and this can ruin all my business
Receive User response in Alert?
Does anyone know if one can receive User Input in Alert? For an example, I have a stateless form that will have a button say "Generate Data". If certain conditions exist, I want the Alert to say "Duplicate condition exists, do you want to proceed?" and have a Yes and No type button in the Alert box. Then based on the user response, the On Click event will behave differently. Is this possible to do in Creator? The Alert box seems to be just displaying a message with Ok. Is there any enhancement
Adding checkbox, radio buttons and dropdown into Report columns just like the buttons.
This will make Reports even more powerful/useful for users to update records directly in a Report and avoid the extra steps to open a form and save a form just to change the value in a column.
How to Use Zoho apps to built a system to run a offline Supermarket
How to Use Zoho apps to built a system to run a Supermarket offline (Physical), where the system will be in cloud .
Next Page