Undestanding execution limit
Hi, i'm trying to understand the execution limit on creator's function. So, take a look to this screen: This snippet work. But if i add: i reach execution limits. Also if a wrote ONLY if (condition) {} this if gives to me an execution limit error. But
HELP! Re-Order Blocks on Report Detail View
Is there any way to simply re-arrange the order of the blocks on a record's detail view? I'm showing that you can re-arrange the FIELDS however you'd like, but the blocks can not be re-arranged. This is a VERY BIG MISSING piece. Any possible update coming on this?
Issue with Embedded Report Not Retaining Filters/Sorting/Grouping on Refresh
Hi, I’m encountering a significant issue with embedded reports. While filters, sorting, and grouping are saved in browser cookies and correctly applied when reloading the page, this functionality doesn't work for embedded reports. It seems that embedded
Detail View Layout - Reorder Block Option
Dear Creator Support, Would love to have an option to drag/drop the Blocks to reorder or add new blocks. It's a big hassle having to delete all the existing blocks to add new fields/sections to the Detail View, then re-add the previous information.
Why am I getting this error?
Can someone explain why I would be getting this error?
Zoho Creator Widgets - Do we have any option to test the widgets in Local Server?
Our current process We make changes in the widget code We pack and upload to Zoho creator then we do the testing after adding to the page. Is there any option to test this from local server? Thanks
URL for downloading uploaded file - THE SOLUTION
Hi, I would like to share the solution for downloading uploaded files using url. There is no documentation for it and there are multiple forum threads with old solutions that didn't work for me. Here is the updated url - tested and works! fet = form_name[ID
Here's how to set a numeric field to null or to blank
I'm not sure this tip is discussed anywhere, so I thought I'd share it. When a form has a numeric field, it initially is blank (assuming you have not given it a default value). However at runtime, once you give it a value, you are not able to clear the field again.with a script unless you click the reset button or reload the form. Unfortunately, that will clear all the fields in the form, not just the one field. Although you can compare the value of a numeric field to null, you cannot assign a
Fetch Records
Hi, I'm trying to autofill a form based on another form using fetch records. When the user inputs a name, I want it to auto-fill an address. I've put this under "on user input" for the account name variable. When I use the code below, it gives no errors. However it doesn't seem to do anything. It doesn't populate the address field in the form, and does not add the data to the table on form submit. What am I doing wrong? TableLink = Account_Information_Form [ Account_Name == (input.Account_Name_from_Order).toString()];
Auto remove corresponding record from subform report
I have a main form with a subform in it. So lets say I make an entry in the main form, and make two entries/rows in the subform and hit submit. Now, the subform report should have two entries in it. But now, if I go back and edit the main entry and remove
What does this error mean?
Can someone explain what this error means when I try to update my deluge script?
Collapse/expand groups en report view
Hi! We suggest adding the indicated functionality through a report configuration option when defining grouping criteria. Thanks, Eduardo Santander
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
Next Page