Connections in Creator
A while ago, the way connections can be created changed so that ONLY the application OWNER can create connections. It makes it really difficult as a developer, because 1. the OWNER of the application rarely knows how to create a connection. 2. It is nearly
api criteria Question.
https://creator.zoho.com/api/v2/customer.service_americaship/zoho-test-bed/report/Package_to_Shipment_Report?from=200&limit=200&criteria=Package_ID==“184063” && Shipment_ID==“83676” 在上面的链接中,&&条件不起作用,如果使用AND则不起作用。
Reorder blocks in Detail View
It's been a long time in coming, but I'd like to thank the Creator team for finally allowing us to drag and drop blocks within the detail view. It's not a great new shiny feature, but it's these little improvements that make working with Creator a more
Button in Subform
Hi, How is it possible to get a Button from a Form Report in a connected Subform (see Screen Shot)? Thanks Marcus
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
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.
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
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
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 >
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?
Hide Field or Section when the form load | Zoho Creator
In Zoho Creator an I hide Fields or Section when the form load and show it if I select a option from a drop down I tried to code it with deluge but I can't make it work.
How to Distinct the Drop Down field values in form?
Hello Team, We need to distinct the values which from lookup field in form on user input event in Zoho Creator. Thanks in Advance, Thisai Moorthy.
Accessing the values in a dropdown or lookup field in a page script
Hi How can I access, in an html page script, the values (not the records) that exist in either a dropdown or a lookup field? I want to store these values as a variable in the page script. Thanks Dave
Correct Parameter
Hi Zoho Team, It comes to my attention that I am missing something to display a report. What I want to achieve here to be able to display results base on certain criteria Here's the result of the query to display records But here's my query parameter:
Next Page