2 "lookup" forms sharing the same lookup field - how to?
Hi, I have one main form asking for someone's age and I want to access 2 other 'lookup' forms based on the age entered. Each of these other 2 forms (one to do with nutrition and the other to do with exercise) are designed to be looked up based on age. I don't want to combine these 2 forms (for a bunch of reasons) but how can I access both of them in the main form without the user having to enter their age twice on the main form? I was thinking I would have the 2 age lookup fields in the main form
Multiple Part Numbers
In our industry some parts are identified by multiple unique part numbers. Items are referenced by part numbers only and the part number will be the primary key. For example a part has the following unique part numbers all referencing the same product: Part Number 1: 571889-001 Part Number 2: 484275-001 Part Number 3: 484274-001 I am creating a form “Add Part” and I would like to add all these 3 part numbers referencing the same product with a common
Error handling
Hi, I have built an error handler function for my google api call. However I’m struggling to find an elegant way to restart the original workflow or function upon refreshing the access token. workflow: run function “api call” (for example read a file on google drive) function api call: calls google api and upon response = error, calls errorhandler. function errorhandler: deal with the error. If the error is ‘token expired’, call function “refreshtoken”. Function refreshtoken: refreshes google access
Sum time field
Is it possible to script for cumulative total of a time field? I am using the following script to fetch time from one form to another: for each PeopleRecord in People[ID in input.People_lookup] { //fetch participation record ParticipationRecord = Participation[ID in PeopleRecord.Participation_dates]; //update record PeopleRecord.No_hours_participated=Time_spent; } This only gives me the most recent 'time' from the record. Is there a way of doing a cumulative total time? Thanks!
scan dymo barcodes
Our supplier uses the dymo labelWriter 450 to create their barcodes, however scanning them using zoho isn't working. Are the two compatible? Thanks
Subform filtering || sorting (mainly for printing out)
Let's assume that we have two form, orders and parts. Orders form includes parts as the subform. Parts form has a lookup field, called manufacturer, which informs where the parts have been made in. Here, I want to sort parts according to their manufacturers' names in orders form, or want to filter parts by, mainly for printing out to a PDF or a paper then I will order the order actually. Can I do those?
How to remove an item (voucher code) from inventory in Creator App
I need to create an app for my campground to allow my office people to issue WiFi voucher codes to our customers. My gateway can generate a list of codes which I would upload into the Creator app. When my staff sells a voucher code, I would like to have the code they select no longer available for re-issue. Can someone point me in the right direction to how I would accomplish this? I've been searching the community and have not been able to find anything pertinent. Conceptually I wonder whether I
IntegrationID not zCRM Contacts ID
Hi, I have a field of type integration which is linked to contacts in my zoho crm account. I can add new entries using the contacts ID from Zoho CRM, however getRecord API provides afterwords a different ID for the field integration Add a record: { "data": [ { "Integration": "296786000000255011" } ] } getRecord: { "code": 3000, "data": { "Integration": { "display_value": "XXXXXXXXX", "ID": "88718000000006007" },
Duplicate Check against Address field
What is the best away to throw an alert when a customer types in an address that is already in the database? Prefer to do it before form submission, i.e. post entering the address into the field.
Create a 7 digit number from an autonumber
Hello all. I am wanting to create a serial number that is required to meet a set format. That is: XXX (preset prefix number) YYYYYYY (serial number) Z (check digit) End result looks like: XXXYYYYYYYZ I need to use a formula to return the autonumber of the record as a 7 digit number: ie: 1 -> 0000001 Can anyone help with the format for this? Regards, Matt.
Passing a perameter to a report to be used as criteria in the report.
Is it possible to pass a parameter in the openUrl function to a report to be used as part of the criteria to base the report on. openUrl("https://creator.zoho.com/zoho_alan18/atelier/#Form:On_Hand_Count?Tech_ID =" + User.Employee_ID , "same window"); // 1) Tech_ID is a field value that the report is based on. 2) User.Employee_ID is the Tech_ID assigned in the [Employee] form. OR: can I create a user defined variable to pass and use that as part of the criteria? Thank you for the help, Alan
Display Calculated Result in Page Panels Using Data from Multiple Forms
I'm building a report page that uses data from multiple Forms in my database, and I want to display calculated values using data from multiple Forms. For example, the Attendance Form tracks the employee hours worked, but the New Build Form tracks employee productive time. I don't see an easy way to have a panel that displays the result of dividing the latter by the former. It looks like it might be possible to do this via directly editing the underlying ZML in a panel, but it's not obvious what the
Passing info from stateless form into htmlview with no clicking
Hey, Assuming a stateless from with no buttons and a lookup field. I want to access or pass the value that was selected within the form into the htmlview holding this form. Any idea how this can be done? Many thanks.
What is wrong ?
Hello Zoho Team; I tried to enter a piece of code on the When Edited of a form in the On Sucess The below code is working ok, i can save and test and if working. //Mail de Aprobacion if(input.Status1 == "Aprobado" && input.Status2 == "Aprobado") { input.Status_del_Pedido = "Aprobado"; } Now, the problem is when add a Send Mail function. //info input.Status1; if(input.Status1 == "Aprobado" && input.Status2 == "Aprobado") { input.Status_del_Pedido = "Aprobado"; sendmail [ from : zoho.adminuserid
Upcoming updates - April, 2020
Dear App Creators, This is an unprecedented time we're living through, and we at Zoho wish you all safety and good health. Let's all continue to do our personal best to help curb the spread of COVID-19. Remember, it's in our hands—so let's wash 'em extra carefully! :) That said, our work-from-home efforts are keeping the updates coming. By the end of April, 2020, we'll be rolling out the following features and updates: Hide/show seconds in reports Freezing the subform header Layout designer for quick
Creator - Schema Builder - Can you save the view?
I find the schema builder really helpful at times for visualizing my apps and their architecture as they evolve. That is, is helpful after I reposition the form icons to make some visual sense. The thing is, the schema builder always defaults to a random system generated view/arrangement, which is generally chaotic to look at. This happens upon refresh, it happens if you leave the view and come back to it, and it even happens on print - the print view itself reverts to the chaotic system view. I
Unable to get Records of Creator App from Desk
I am trying to get fetch Creator App report records from a Desk script but I always receive the same Error message: {"message":"Please verify whether you gave a valid ownerName,appLinkName and viewLinkName or not","status":"Failure"} I am parametrizing the function like is explained in zoho documentation: <variable> = zoho.creator.getRecords(<ownerName>, <appLinkName>, <viewLinkName>);
Changed behavior of zc_LoadIn=dialog
Hi - did anyone notice a change in behavior on the url parameter "zc_LoadIn=dialog" during the past couple of weeks? Seems use cases where this used to open a nice popup window now load in the same window. Were any changes made to the backend?
Exporting report data to Excel?
Is it possible to export data from reports into Excel?
Display format Numeric Data type / Formato de visualización Tipo de Dato numerico
Hola a todos, Me gustaría saber una forma alternativa de configurar el formato de visualización del tipo de datos numéricos, diferente del formato predeterminado. Necesito un formato de visualización similar al tipo de datos de moneda(currency), como se muestra a continuación. Formato de visualización default: 100000 Formato de visualización deseado: 100,000 ¡Gracias por su apoyo! ---------------------------------------------------- Hi everyone, Id like to know an alternative way to configure the
Schrems II decision on Privacy Shield and the use of Standard Contractual Clauses (SCCs)
Hi, I am using developer.creator to which I understand the servers are based in the U.S., although originally there were attempts to host in the E.U.? The recent decision -Schrems II- impacts every EU business which has personal data stored in the U.S. I was just wondering the status with Zoho as regards to developer.creator, will the EU customers be transfered back to EU? Maybe they are in the E.U. now, but I am unaware? Although not panicking yet, the product is low-cost cloud-based GDPR compliance
Live Page
Hi I am working on a hospitality app which requires the kitchen staff to see all food orders on a screen and update the order with the press of a button from the report itself. The latter is easy but I just can’t find a way to keep the orders report up to date. Manual refresh of page is not ideal as the customer wants their big kitchen screen to show all the orders with their live status. Wondering if there was a way to make a ‘live’ report? I mean I could make an HTML page to visualise the orders
Importing CSV data only to inline subforms
I have two forms, parent_form and child_form. The parent_form has inline subform which is child_form. My question is about importing CSV data which has many null values(so when imported, some rows are not imported correctly, but it's OK for me) to child_form_report. Import actions are done frequently. The results of imports are that the child_form_report has data from CSV, but the parent_form's inline child_form does not have. I think if could, when imports are completed, inline child_form will have
Approval Process of a Subform
I have a request form, Form A, which includes a sub-form, Form B, for any purchases that need to made for the request in Form A. When Form B has an entry within Form A, is there a way to trigger the Approval Process? I can only seem to have the Approval Process triggered when Form B is filled out independently of Form A.
Double "For Each" loop to update grand-child record
Hello all, I have three forms: countries > cities > airports. Each child is related to its parent with one to many bi-directional lookup fields. Saying it differently, each city is related to one country and each country is related to multiple cities. The same is true for the cities-airports relationship. When an update happen on a field on "countries" (the parent), I am trying to update fields on cities (the child) and on airports (the grand-child). I succeed to update the child using "For Each"
Embed a google map in a ZOHO page in creator
I tried to add the share link of my google map in Pages. Nothing shows up. How do i add a map . Any help is appreciated. Thank You, Chris Edit: I should mention, that it is just a static map from GoogleMyMaps. They provide a share link ,which is what im trying to use.
Changing behavior of lookup suggestion/autocomplete
Hi, 1-I'd like my lookup fields not to display records in a dropdown fashion. The info in these lookups are private and I'd like the user to type in his value (for example, email), and after 3-5 letters the field would start searching for autocomplete. 2-Or another solution would be to not give any autocomplete/suggestions: to just match the value with the existing record, and if there's no match, then prompt the "Add new record". 3-The last solution would be to filter the lookup in a way that no
Trigger "Created/Edited --- On success" workflow. of related records
Hi, In form A, I use a "Created/Edited --- On success" workflow. In this workflow, using deluge script, I'd like to trigger the workflow of other related records that are linked by lookup field. Is there a way to do that? Thank you!
URL parameters to pre populate a form
Hi Have tried to pre poulate a form from this... to this.. Product_Used is a Lookup field to another table, with values 1,2,3...etc Have tried the form url with "/Product_Used=2" or "?Product_Used=2" appended to the url, but that does not seem to work. Have also tried ui.add restrictions, but that dis not work. Cannot find anything on the forums. Can anyone help, going slightly mad as I am probably making a basic mistake?
User Input Pop-up - Does this exist?
Is there any way to have a user input prompt that pop's up asking the user for input? For example, exactly what is seen on the back end when you are executing and testing functions, there is a window that pop-ups prompting the user for input. Does this exist outside of the old stateless form idea?
Zoho Creator page in CRM web tab - dynamic filter does not work
Hi, My page has a report "Loan applications". The button "See related documents" triggers a custom function which passes the application ID as page parameter. The documents report is filtered in a HTML snippet which has the following code: <%{ %> <div elName='zc-component' reportLinkName='All_Documents' params='zc_Header=true&zc_SuccMsg=Data Added Sucessfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&Application.ID=<%=application_identification%>'>Loading Form...</div> <% }%> It works perfectly in
How to clear field values?
I see how I can CLEAR by using 'Delete all items from the given picklist/radio/checkboxes/multiselect'. How can I clear the value from other fields like Date, single line and others? I am finding it difficult to use the show and hide command without being able to clear values on HIDE. In my other example, I have a 3 fields Allergy, Severity and Allergen. Severity and Allergen are hidden on form load and shown when Allergy == 'Yes'. If you add info to the 2 fields and then go back and change the
ZOHO Creator and ZOHO Sheet
Hi Can ZOHO SHEET be intergrated with CREATOR ?? Can I use the front end cut and paste functionality of SHEET with the backend validation of CREATOR?? TIA Allan
Dropbox PostUrl Save_Url
Good day Im trying to figure out a PostUrl to save a url file into a dropbox account, but I got a 400 sintax error, I try to do the same curl dropbox example with a postUrl, I try always encoding the url param. What I should doing wrong? curl https://api.dropbox.com/1/save_url/auto/images/downloaded.png \ -d url="https://dl.dropboxusercontent.com/s/deroi5nwm6u7gdf/advice.png" \ -H "Authorization: Bearer <ACCESS TOKEN>" headerMap = {"Authorization": "Bearer <MY TOKEN>", "url": "https://dl.dropboxusercontent.com/s/deroi5nwm6u7gdf/advice.png"};
Color of the custom action buttons that are shown
Can you change the color of the action buttons that are shown on reports/views for each record?
Calendar Report only showing 6AM - 6PM
We have a calendar report in our application. Until recently, it showed the full 24 hours of the day. At some point in the past few days, however, it started restricting the hours shown to 6AM - 6PM. As a result, some of our records are being cut off and we are unable to access them through this report. This is happening across applications, so it is not related to just one report or change we have made. There doesn't seem to be a way to set what the working hours should be restricted to in any
interacting with mysql db hosted on azure
How can we make a Zoho creator app to get/post data to a MySQL db which is hosted on Azure.
Security Update Applied to Public Applications
Dear App Creators, We have rolled out a security update on July 2nd, 2020, for "public applications" and "public components" — Zoho Creator applications or their forms, reports, and pages that are made public to all visitors over the Web: Note: Unless you receive an email from us regarding this, this update does not concern you. Emails have been sent About the update When a user (logged into their Zoho account) accessed a public component, the Deluge system variables zoho.loginuserid and zoho.loginuser
import xls file with european date format dd.mm.yyyy
I am trying to import data from an .xls file containing date fields with european date format like dd.mm.yyyy Importing the xls file the date column appears as a dropdown field. When I want to change it to a date field, I get the error message: "One or more rows contain a value that´s not a date. These won´t be importet. Proceed with changing the field type?" All the fields in the row have the correct format dd.mm.yyyy What to do to import the european date field correct?
Pass File_upload field as function parameter
Hi, I can't pass a File_upload field as function parameter. I need it to do the proposed workaround to preview a file: https://help.zoho.com/portal/en/community/topic/how-to-open-a-pdf-file-of-a-view-in-preview-mode Why is it not working? I activate the function through a custom function button found in a report. The File_upload field is shown in the report, but I can't select it as a function parameter. Thank you for your help!
Next Page