User Permission Log
Our external auditors are asking for a way to view changes made to user permissions (basically, a user permission change log). Is this feature built into Creator?
Lookup field script help: if, contains, count, &&
Can anyone see what I am doing wrong here? I am very new to this and can't work out why this won't work. I am trying to say if the field "All_Competition_Teams" (multi-select lookup field) has more than one team selected which has "Cheer Sport" as the
Buttons within Custom Printable Report Template Window Are Missing Functionality
Hello, I was testing the Printable Report Template as I was hoping to incorporate it into a project. The UI blocks appears not to be draggable, and the other buttons including the close modal button appear to do nothing. I am assuming it's a potential
Set value of Link Name of URL field
Hi all, We have 2 fields. One is title 'Video Link' and the other is titled 'Image Link'. Both are URL fields. We paste a unique dropbox link into the https:// section for both fields, however, we need to set the 'Link Name' that then appears to a number
Export as ZOHO and import as ZOHO?
When I first started with Zoho, I would make a new application for each form. I did not realize you could make multiple forms in 1 application. I have thousands of records in each form now - and formatting I've done over the years. Is it possible to export
ZC : Dynamically filter a report where a date field is empty
I'm sure this is easy, but I can't get it working. I have a date field and I need a report filtered to show when that field is empty. I've tried : ?action_daterequired=null ?action_daterequired==null When filtering in the menu it has the IsEmpty in the
Script help
I have a form for booking parties. The parties are available every Saturday and every Sunday. And each day has two slots available 11am-1pm or 2-4pm. I am trying to find the best way to script this so that once someone books a slot it is no longer available.
Adding images limit
Hi, Wonderful app How to increase the 15 images limit to a text note ?? Thanks
Edit single link in a subform?
Hi all, We are a test laboratory and have a subform where we enter the test dates. This subform looks at the parent form for the primary date and simply adds x number of days to create a future test date. For example:. Primary Date: 01.01.2021 (Main Form)
How do I make an embedded (iFrame) form mobile responsive?
Hi there, I have a zoho creator form embedded with an iframe (from the publish option) in my external website. It works fine on desktop, but unfortunately the content of the form does not scale correctly on mobile. I have tried placing the iframe within a container, but it still makes the form label text massive, and the form fill areas tiny. Any ideas how to resolve this ASAP please? Thanks
Pick up information from an Email back into a Form
HI, I don't even know if what i am asking is possible?! The app we are using records quotes our sales guys produce and sends a copy off to the customer in an email. I would like there be a link in that email that directs to a different form so the customer
Merging PDFs using Cloud Functions
Hello Creator Gurus! I understand that cloud functions are relatively new, not even available yet for domains other than .com but, I am wondering if anyone had given any thoughts to perhaps building a Java/Node.JS based function for merging PDFs? This
Reserved keywords
Reserved keywords If you name your form field to any of following reserved keywords you will risk runtime failure when communicating with your application: script – (this seems to have been resolved, please refer to the list in further reading) type count Background This post is here to address issues that randomly occur while using reserved keywords when communicating with Zoho Creator through the REST API and/or integrated Zoho services using Deluge. Since Zoho Creator does not use namespaces
Easy way to insert images into rich text fields
This is becoming more and more important as people get used to being able to do this in emails etc. In Zoho Creator, this this seems really difficult for the average user who does not know HTML.
Creator Report Issues
There are two reoccurring issues with Creator Reports that need to be addressed: Report Regeneration We should not have to do a report generation every time we access a report. It is confusing to clients when they need to conduct a regeneration and when they can rely on the data that populates. I have found that these reports have to be regenerated very regularly and the data that populates is often several days old or doesn't even make sense. For example, today I pulled up a report that only
HOW CAN I DO THE FOLLOWING CONSECUTIVE?
Hello, can someone please guide me how I can do a consecutive as follows TRL-A-001 TRL-A-002 TRL-A-003 ...... TRL-A-999 As I get 999, the same first letters appear and only change A to B and so on until it reaches Z TRL-B-001 TRL-B-001 TRL-B-002 TRL-B-003
Limit each multiselect option to a max number of entries
Is there a way to set a limit on the number of times a multi-select option can be selected? For example, if I have a field called "Dates Available" and the choices are: Mon 1 Jan Tue 2 Jan Wed 3 Jan Can I set a limit so that each choice can only be selected
Record lookup field is clearing on edit
Does anybody know how to fix this? When I click on a record to edit it, the lookup field clears to null. Please see scree recording - https://www.loom.com/share/aa11468352f444fca9ac0d86eb40726b
invokeurl variable mapping
Hi, I have set up a 'connection' to Mosyle MDM so I can pull usernames via API I have the following code which seems ok but doesn't work 'Error occurred while executing on load script.' header_data = Map(); header_data.put("Content-Type":"application/json","accesstoken":"MyAPIToken");
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
Next Page