Printable report with subform record on each page
Hello there. Is it possible to produce a printable subform report that has each single subform record on it's own page? Many thanks, Matt.
Multi - Select Lookup Field
Hello, I am trying to add values of Multi-Select Lookup field and store them in another field Value should be updated On User Input Following is the code i used to add values var = 0.0; for each rec in Quantity { if(Quantity.size()>0) { var = var + Quantity.todecimal(); } } input.Total = var; Values inside the Multi-Select lookup field are all decimal values Following is the error i received :
List elements separator / List values separator in record summary
I have a field that contains schedules. A record can contain many schedules. A typical record is used to illustrate my problem: When this field's content is displayed in a REPORT, it looks like this : 06h00, 07h00, 08h00, 09h00, 10h30, 11h30, 13h00, 14h00, 15h00, 16h00, 17h30, 03h15, 05h00 All fine. The values are separated by comma+space. When this field's content is displayed in a CUSTOMIZED RECORD SUMMARY IN A TABLE, it looks like this : 06h00,07h00,08h00,09h00,10h30,11h30,13h00,14h00,15h00,16h00,17h30,03h15,05h00
Copy image from a an image field to another.
Hi there! I need to fetch an image from an image field to another field in another form. So i have: Form A: Risk Levels Image Form B: Other non related fields, Subform B: Risk description Risk Level (lookup from form A) Image. I whant that whenever a user selects a risk level from the subform B, the image is copied from the form A image field to the subform B image field. I tried this code (wich works great for other type of fields) but had no luck... IMG = Lista_Niveles_Riesgo[ID
Automating Customer Email reminders
Hi all, I am trying to work out (not successfully) how to send a customer a "Service" reminder email. I need to send an email to a customer based on a few different fields and conditions. So a customer would get a reminder email if they have a service due next month, once the email has been sent the system then changes the next service due date, this new date is based on what level of service they have purchased (bronze 6 months, silver 4 months, gold 3 months). But i only want it to send the email
How to add a record to a filtered report
I have a single form - LISTS which includes merged lists of organisation departments, categories of objects, etc., all in the same list in order to minimise multiple Forms. I was advised by Zoho Developers this is best practice. So I have a single Form with filter Query in a Panel object on a Page (filtered by department, object category, etc.). So there are 2 Items in each Record, Name of Item and List Type (Radio). I have tested by creating a Report with Filter and same problem. All I want to do
Feature Request: Button Field Type
Oh how easy that would make so many features I want to add to my Zoho Creator apps. I would like to be able to add a Button as a field type. This Button would be able to be referenced in deluge "On input of a form". That way I can add slick features like: Calculate Taxes: This would do the complex call of calculating taxes and then writing the taxes to the subforms. Show/Hide Sections & Pagination: Right now to make it feel like multiple pages on a form, I have to do this wonky stateless forms stuff.
Basic Creator Form -> CRM Case
I've built a basic form in Creator that has 2 CRM Integration fields to find 2 different account profiles that will be linked to a case. We're using cases in this manner for requests between 2 different account types. Account A has requested something from Account B, for example, so both should be linked to the case. I've got the form set up no problem, but when I go to create the workflow to create a record in the CRM, the two CRM integration fields are not available for mapping. Any ideas here?
Fetch Application Users List
Hi, Is there a way to fetch a complete list of all users in the application? I'm trying to develop my own approval process rather than using the in-built one and I need to send an email to all users who have the "Approver" role. Therefore I need to grab the list of users and loop through them using the thisapp.permissions.roleForUser function to retrieve their role. However, I can't find a function to list all users in the app. Any help anyone can provide would be greatly appreciated. Thanks, Harry
Looking for a ready custom app
For Traffic just daily mileage using GPS and features around this
New Workflow one issue, two suggestions
I like the new workflow, it has proved helpful in finding issues. With 250 workflows in my app, search is important. The new workflow search is case sensitive, where the previous version wasn't. Is this a change or a hiccup? Can we make it none case sensitive? The second point is that the form list on the left really needs to be collapsible, as it leaves too little room for the script name. Finally, I have asked before, and I will keep asking the creation date is not that important, but the date
Creator 5 - Page Break in an HTML Page
HTML page/ snippet/whatever. I have a client with a specific 3-page filled-out printed form that they need generated from the Zoho app. In the past it was simple (but tedious) to just create a Page to mimic the printed form and then either send it to a printer or send it to PDF. To get pagebreak I had <head> <style type="text/css"> P.breakhere {page-break-before: always} </style> </head> and then in the body of the HTML where I wanted the page break I would put <P CLASS="breakhere"> and
Multiple Date fields into one report
Hi, I have a form that records 5 date fields. Is there any way I can have all of the fields appear in 1 report? Ideally I would like ti in a calendar (either in Zoho or get the iCal feed). Thanks for anyhelp.
Restoring report data
I am trying to restore a report. Several fields were look-ups, so when a related form was removed all those fields went blank. I thought I could just use the automatic back up, but the data isn't in there either. The csv files show relational ID numbers, weirdly the numbers aren't unique- not sure what's going on there- so there's no way for me to manually match up records to fill in the blank fields. Is my only option to create a dummy app, do a full restore, and download this one report to then
Adding to a lookup when criteria met. WARNING... COMPLICATED
So... Trying to add a "product" (aka ID of a house) to a customer within the approval process. The "PotentialRevedyHomes" is the field I want to add the "Revedy_ID" to, but only when listing price is within the limits the customer sets and the home is within the zip code of where the customer is looking. I also want to make sure it is not a house they have declined or already liked. The problem is these are all lists and I can't get the match to happen. There is not an error, but it does not add
How to extract data from soap api response?
1. After successful request using getUrl() method got the response from URL but it is shown correctly in text enrich field only? 2. From the soap API response how to extract the values? 3. Is there any libraries like zeep (soap API clients) in python for zoho?
Input Multiple Parameters for Page
I have a page that is acting as a report across several forms in my app. I want the end user to be able to filter the report for Employee (User) and a date range. I've figured out how to use the Search to pass a parameter to the URL (open Page in same window), and I can see how to filter Panels, Reports, etc. using the parameters. It's just not clear to me how to get several user-entered parameters into the page URL. How would I go about getting the date parameters into the page URL in a similarly
LISTA SUBFORMULÁRIO
Olá, estou tentando fazer com que um subformulário exiba os campos sem e-mail, se eles não forem repetidos, pois não quero duplicidade de informação. segue em anexo print do meu código.
Add a marker on an image.
Is there a way to add a marker on an image the same way you add a marker on a map? Something like this:
Zoho creator deluge code to add petty cash transaction in zoho books
Hi, We are developing an app to track petty cash transactions received from our customers. Is there a way to add petty cash transaction in ZOHO BOOKS from our custom app using deluge code?
Updating Records on import
Hello, I am trying to update records on import (not create a new record). I have seen several community forums for this but they are all incredibly out of date. My problem: When trying to do a mass import, any records with matching ID & project ID, I want those records to be updated and not have a new line created. How can I do this?
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!
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
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
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?
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
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
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
Next Page