Show/Hide in Subform
Hi, I want to hide/show the fields inside the subform. Hide works perfectly on load but show action doesnt work it says "Invalid task in Subform action". Code: if(Job_Work_Challan.Accessories = "Cartons") { show Job_Work_Challan.Quantity ; show Job_Work_Challan.Dimensions_Cartons ; } wherein Job_Work_Challan = subform Accessories = checkbox Job_Work_Challan.Quantity & Job_Work_Challan.Dimensions_Cartons = Both single line fields which i want to show.
Invoke.Function
Examples of how to use Invoke.Function
ID's become incorrect when exporting via csv
I have an application where I am exporting a view that has multiple ID's from several forms. When exporting the data via csv, the ID's are changed and are no longer unique. Yet when I export via "speadsheet" (xls) the ID's are correct. This is a similar issue that we had with the api a while back. I'll paste a link to that thread below. https://help.zoho.com/portal/en/community/topic/api-calls-on-a-combined-view
What happens to my current site SEO if i opt for zoho creator?
I have an existing website and I need to use Zoho creators for the rapid creation of my webpage creation. Currently, my IT team is creating the web pages, but I am concerned about the SEO of my current website if I shift to zoho will i loose it all?
Month/Year Data Format
I want to create a date field that only displays Month-Year. I believe the format would look like this: MMMM- yyyy. For example: November- 2017 The date formats in the general settings always has month, date and year. Suggestions? Thanks, David
Decimal places in Formula Fields
I want to multipy a numeric field with two decimal places (Shares) times a currency field (Per_Share) with two decimal places. The result, a formula field (Total) should be of the currency type with two decimal places. When I do this (GUI), I do not get trailing zeroes. For example, if I multiply 2 * $4.55, I get $9.1 but want to get $9.10. I tried scripting, decimalplaces = 2, but the system just ignores that. Thanks. Frank Driscoll
How to disable sub-form fields?
For each line in my sub-form, I have various fields that I don't want the user to be able to edit. There are also a few fields that I want to be kept hidden but I can't seem to figure out how to do that either. I've created a new workflow for adding a
Minutes / Hours DELAY IN ALL OUTGOING MAIL
All my outgoing mail has been lagging by minutes / hours (randomly) or sometime 12-14 hours delay. and i can receive some email as normal (receive 1-2 minute after the script sent email) It's not very certain. When will there be a problem. Some days there
Multi file upload
Hi, I just wonder if one could upload multiple files in one shot, say between one and three files, without adding multiple File Upload fields? Thanks, Alalbany
Open multiple views
Hi, I need to open multiple views. More precisely, I have a button which should generate multiple views, one for each value stored in a list: for each supplier in suppliers { sURL = ((((("https://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/#View:Order?progID=") + input.progN + "&supplier=" + supplier); openUrl(sURL, "same window"); } With "same window" it opens only the view corresponding to the last value. Instead I need a view for each "supplier". Could you help
Prevent deletion record if there is connected records
I want to prevent deletion records, if there is connected records in any other Forms or Apps in my solutions
Subform scrolling problem on iPhone
Hi! I created an app with creator. Everything works fine except for subforms on iPhone (they work OK on android). A chunk of the subform stays in place, and the scrolling seems to happen behind it. I attached an image to show what I experience on my iPhone
Resizing the last column in the report is terrible
Resizing the last column in the report is terrible. Has anyone faced this issue or am I doing wrong here? Please see the video attached.
Jalali Date Calendar
Hi, Is it possible to change default calendar custom apps to Jalali Persian or Hejri Calendar date picker in App Creator? Thanks
Attaching deal emails to a deal record in Creator
I'm developing a customer portal using Zoho Creator. In the portal, my customers can see all their deals. One of the things I love about Zoho CRM is how it collects all the emails related to a deal on the deal record. I want to add that same functionality
Issues Fetching Emial ID in a sub form using a fuction in delgue
Hi All, I have two forms: Form A and Form B. Form B is a subform in Form A. In Form B, I have a lookup field (Action For) from another creator application. I am looking to populate a field (Email ID) in Form B based on user selection in the Lookup field.
Serious problem with backup /restore
Creator is mangling ID's for entries in applications that are restored from backup. This problem is preventing us from doing our work. Could someone get back to me on this problem? Here's what I've figured out... If you take a perfectly good Creator application you can add the "ID" field to any of its views and you will see that every entry in the table will have a unique ID field. If you backup the application then restore it and look at the ID fields in the restored application you will see that
Is possible to populate the values for many fields in openurl?
Hello Team, Hope you are well...! We need to pass the values to the particular form fields via open url as popup window is this possible to populate the values from the functionality. Thanks in Advance, Thisai Moorthy.
Change to copy/paste functionality in Deluge code editor
Recently there was a change to the Deluge code etidor where it now inserts backslashes into strings automatically when copying/pasting strings with double quotes, it's a nightmare to have to go delete all these. Is it possible to toggle this on or off?
Proposing a new function for lists: Remove Duplicates
Currently I use a cumbersome way to create a list and then feed unique values to another list all for the purpose of removing duplicates. The USER_IDS is an integer list of record IDs. Because of the way my database is constructed, if the criteria is met, this list can have duplicates. To remove them, I have to feed the list of IDs to another list (UNIQUE_IDS) as long as the ID is not already there. USER_IDS = (DATABASE[(USER_DATA.contains(r.SUBLIST) && STATUS == "CONF")].ID).getall(); for each
What is the purpose of CANCEL SUBMIT?
I have been researching the Alert command for use in a script. The documentation says the syntax is alert "type your message here!"; cancel submit; But you can only use Alerts on "Validate, on Load, on User Input" and you can't use cancel submit on "On Load or On User Input" BUT you HAVE to use cancel submit on "On Validate" or else "On Validate" will ignore it. AND when you use it with "On Validate" you don't get a pop-up box with your alert message and the option to "cancel" the submission or
How to get Monday as 1st day of the week?
Hi, The first day of the week is Sunday in Zoho Creator calendar.So it is hardly usable as in Europe the 1st of the week is always Monday. How can I get Monday as 1st day of the week? Best regards, Chris
postURL - Error due to - 'Internal Exception'
Good day, I created a function that makes a simple postURL call to our API without authentication. It works using Postman but I get Error due to - 'Internal Exception' in Zoho Here's my code : HeaderMap = Map(); HeaderMap.put("content-type","application/x-www-form-urlencoded"); param = Map(); param.put("param","test"); url = "https://zoho-teleopti.tpcc-trim.com/api/Zoho/post"; result = postUrl(url,param,HeaderMap,false); info result;
Zoho Creator | Auto Number
Hi this is working but is it possible don't update the one autonumber field if it's not selected. latestDP = Client_Submit_Card[ID != 0].maximum(DP_Auto_Number); latestJSP = Client_Submit_Card[ID != 0].maximum(JSP_Auto_Number); vendorsValue = input.Vendors;
Publishing in a specific language
Is it possible to have a "?lang=XX" paramters in the URL to force a published form/page/report in a specific language? (Zoho Analytics can do this)
Add to picklist dynamically in a subform
I have a form with a subform The subform has a dropdown field wich is dinamically populated accordingly to a value inputed at a form fieldI have this code triggered on add row event: ListProd = F_Produtos [Fabrica_Produtos = input.Fabrica_Encomenda]; row.Produto_ItEncomenda:ui.add(ListProd.ID.getall()); It works great when i add a row, but if i want to update a row, the script obviously won't run and the picklist shows all the values, not only the ones needed. I guess an "on focus" event would
How do I connect Zoho creator Product Catalogue app to my Zoho Books ?
Hi I have around 200 products (items) in my Zoho books. How do I sync these to Zoho creator Product Catalogue app? I don't want to use export and import using .csv, .xls file as its won't sync the images and also I don't want to keep manually do it each
Prevent Entire Record
I want to prevent entire record data from being repeated in case it is repeated as it is. for example if we have form has 3 fields and one user enter a record as below: field_1 = 15 field_2 = 14 field_3 = 13 and he try to add a new record with same fields
Number Plate Recognition Using ZC inbuilt OCR
Hi Guys, I want to build a system to record number plates of vehicles that enter and leave our company depot. I'm thinking of using ZC's OCR feature however I'm not sure how I can get images from a camera to my ZC app automatically. Any thoughts on the matter would be greatly appreciated! Cheers, Justin
Image size issues in Zoho creator, can we compress and resize somehow before upload or even after upload
Is there anyway we can resize the images being stored in Zoho creator.? We have a number of reports that utilise the photos and images we store and that report produces PDF reports. These pdf reports are getting to larger with the huge images being stored
[Free Webinar] Creator Tech Connect series - Product Release Updates in Zoho Creator
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
Loops in Deluge
Hi, Can someone tell me how I do a simple loop in deluge? For example, if i have a variable "X" containing a number of loops to perform, i would like to perform an action X amount of times. X = 10; do while (Y < X){ // ... do something } to further explain, the equivalent in PHP of what i am trying to acheive would be: $X = 20; for($Y = 1; $Y < $X; $Y++ ){ // ... do something } Thanks
Expression Help
Hello, I'm trying to work within the expression editor in ZOHO Creator. I have a field that currently is populated to say Valid or Expired depending on whether or not the date is after the current date. That looks like this, IF(NCIC_Expiration_Date >
How to get fields centered in a form?
Is it possible to center fields in a form? Some of my forms do some don't and it is really not aestheticly pleasing? Any help would be greatly appricated. Thanks, Michael McNeill
Prevent form submit if the record has changed while the form was open
We have a common situation that causes unexpected behaviors in our creator apps. Does Zoho have a fix for this, since it must be common for lots of folks? 1. User A edits a record which opens the record to a form 2. The record is changed elsewhere (e.g.
Address Auto-Complete - API Help
Hi There, I'm trying to create an address autocomplete using an address API, I've gotten so far from pulling from other online sources but have come across an issue I'm not sure how to tackle. I'm not a dev firstly so just trying to piece things together
How to generate a random number in a main form field through a deluge, so that every time the form is finished it is generated?
How to generate a random number in a main form field through a deluge, so that every time the form is finished it is generated?
Zoho Creator | Can I filter Report between two dates?
Can I filter Report between two dates? I mean like can I have two calendar field to generate a report?
[Free Webinar] Learning Table Series - Creator for the Agriculture Industry
Hello Everyone! The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience by demonstrating how Creator can be used as a solution for various
Integrate with Power BI
Hi, How to connect Zoho CRM dashboards & reports with POWER BI ?
Next Page