Lookup field filter
Can anyone see what I am doing wrong here? When I first load the page the filter works, but if I change the date it puts the word "null" in front. https://www.loom.com/share/dbb4bd9d004244ff97737bba01b9dffa
Zoho Creator Api V2 - How to phrase muliple "does not equal" criteria in the request
I have a data source where I want to return everything except records containing two specific codes. The field "customer_tlr" is a single line box - not a dropdown or multiple select. I have tried the following : These only exclude the first value app.zohocreator.eu/api/v2/MYCOMPANY/MYAPP/report/api_customers?criteria=customer_tlr!="ABC"&customer_tlr!="DEF"
Conditional formatting with function call
Should it be possible to have function call like this, here copied from Application IDE: conditional formatting ( "New Formatting" { condition = (Formula == thisapp.Sjekk_sub(input.ID)) fields = [Navn] format = "color:#ffffff;background-color:#e84c3d;"
Message Box?
Hi, Basically, I have a form with a lookup field. If the user selects an item from that lookup field that has a "*" or if the user selects an item that is not "online" I want Zoho to display a message box saying "You have selected an item that is not currently available, please go back and select one that is 'Online'". Is there anyway to do this? I was able to do something along these lines via Visual Basic using MessageBox codes, but I am not sure how to do this with Zoho Creator. I do not see any
How to Control Browser List View Column Width in Creator 5?
Since I migrated to Creator 5 some, but not all, of my old reports no longer auto-adjust their column width (originally in Auto mode) properly in List View, jamming 3-4 columns to the left of the browser window and keeping exceedingly wide columns to the right of the screen (see attached screenshot). Any manual adjustments to fix it do not stay and are lost on the next screen refresh. In the Creator knowledge base there is an article on how to change column properties from Auto to fixed width, but
Fill Field From Multi-select Lookup
Hi, I want to fill a field called "Artists" (string) based on every-time I update a lookup field called "Artist_Name". So far I've tried several things similar to this: For every artist in Artist_Name{ Fetchartistname = Artist_Name [ID == input.Artist_Name_Lookup] input.Artists = Fetchartistname.Name; } All I've been getting is my Artists (string) field being populated with the same name no matter what name is chosen in the multi-select lookup field. For instance: The lookup field has "Judas Priest"
Search with report below
See attached image. I'm sure I've built this wrong, but it gives the idea of what I'm looking for. I built a page and put a search widget at the top - where it says "PO#" is a search box, with a report widget below. When I search, it takes me to the report
Deletion of individual prices
I have , a sub form in main form with the general services, and medical services and their costs. their addition reflect in to total. sub form all rows addition shown in the grand total of main form. i am getting deletion of row. and i am not getting
Date Field Calculation / Today Function in Creator
Hi, I am trying to calculate number of days items are in stock. so in excel formula would be: today() - Stock.indate. I have two questions: 1) Is it possible to use creator to reflect Current date field in a column of a view. So it will always show the current date 2) In Creator's report, can i do a date calculation similar to excel = today() - Datefield Can you please provide some guidance. Thanks, DC Zhong
Printable Manual for Deluge Script and ZOHO creator?
I know his hs been asked before, but was wondering if there has been any progress on a downloadable (PDF or other) user and reference guide for ZOHO Creator and Deluge Scripting? It is cumbersome to have to keep refering to a wiki or other online source to learn the scripting language versus studying an actual hard copy manual. Guess I'm old school and prefer the printed word.
Get Data Type from Variable
I have looked through the documentation, but have found nothing on checking the data type for a variable. How can I determine if a variable is a map, or if it is a list, (or neither)?
Auto fill a multiselect field (that is also filtered) based on another fields selection
In my form (Add a Students Financial Information), I have a lookup field called "Students Name". I would like another field called "All Teams" that is on the same form to auto-fill based on the selection from "Students Name". I want it to auto fill with
Hiding HTML Snippets on Zoho Creator Pages
I want to add some more HTML snippets onto a Zoho creator Page so that I can show the state of progress within the customer journey depending on the services we are providing for them. My question is, I have the snippet object working fine but when there
Filter for a lookup field: Value in field cleared on Edit
When I edit a record with av lookup field with filter based on an other field in the form, the field value of that field is cleared when form is loaded. Is there any work around to secure that the vaule is kept in the field?
Menu Bar Search Element
Would be fantastic to have a Search Element on the Menu Bar.
Search Records by Criteria
Is it possible to use url params to hide/show fields on the Report Search Records? For example, Form has three fields (Name, Phone, Address). Report has three columns (Name, Phone, Address). User is viewing Report and clicks the Search magnifying glass
Parse Full Name Field to First and Last Name Fields
I have data coming from another system as Full Name (e.g John Smith) that I need to parse to 2 fields, First Name and Last Name (e.g John, Smith). Is there any "easy" way to do this with a formula? I thought I could just look for the first occurrence of a " ", but 1) I cannot figure out the formula or function to do this and 2) this does not handle situations where the are multiple spaces in the name (e.g Mary Anne Van Der Beek - Maria Anne (first name) , Van Der Beek (Last Name)
Zoho Creator Community Webinars | October - November 2020 [Completed]
Hello everyone, I’m happy to announce that Zoho Creator is hosting a new Community Webinar Series starting this October. This series is a learning initiative aimed at our developer community, where every session will take spotlight use cases focused on
Custom redirect on logout from customer portal
When a customer signs out of the customer portal, they are redirected to the customer portal sign in page. I would like to redirect them to a different page. This thread shows how it can be done with a separate button - at least from the main service (rather than the customer portal) https://help.zoho.com/portal/en/community/topic/customize-sign-out-button - thanks John ...but I would like to redirect from the standard sign out link in the top right of the customer portal. Thanks.
Can I get the top search bar back?
Our Zoho was force upgraded to Zoho 5 which removed the search bar from the top of the screen and it's now a pop-out from the right of the screen. Not only that, when searching multiple fields we now have to "x" each parameter to start a clean search
User nickname?
Hello, When I'm using Zoho Creator apps, is seems I have a username "Zoho_lien", while my username should be Joshi Boomputte as it is in the CRM. How can I modify this please ? Thanks
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");
Next Page