How to create a machine usage report based on date interval records
We have records of usage of a tractor like: Tractor Initial Date Final Date Farm A jan-1 -2019 jan-15-2019 Sun Valley A jan-16-2019 jan-31-2019 Green Lake B jan -10-2019 Jan-20-2019 Green Lake B Jan-21-2019 Jan-31-2019 Sun Valley C Jan-30-2019 Feb-10-2019 Sun Valley And would like to create a report like: Date Tractor in Use Jan/1 1 Jan/2 1 Jan/3
How to disable some values of radiobutton ?
I have 2 radio buttons (RB). 1 contains : HN and SG. Other contains : 1, 2, 3, 4, 5. If RB1's value is SG. Then in RB2, u can choose only 3,4,5. U can't choose value 1,2 unless RB1's values is HN. Can anyone help me solve this problem ?
Customer Mobile Portal
Hi, I'm testing Zoho Creator to build apps for my business with a trial account. I'm trying to give access to a test customer to the mobile version of the app we are developing but I can't find how. Zoho Mobile Creator is for company users (and it works fine), not for customers, right? If I open from a mobile browser xxxxxxxx.zohocreatorportal.eu the pages are from the desktop version of the site, not the mobile one. Mobile version of the site xxxxxxxx.zohocreatorportal.eu has another url? Thanks
Customer portal, one user enters data for another user, possible?
Hello, I created a customer portal with 2 user permissions, player and host. The player has a username and plays a game. The host will enter the username of the player and add a score. The host should be able to see all records of all players. I would like the player to be able to see only the data that the host entered that matches this player's username. Is that possible? Thank you
Zoho Creator IOS 5.12 app broke our app
FYI. Any iPhone that we upgraded to Zoho Creator 5.12 over the last few days has stopped working with our app. We can see records in a report list as normal, but when we try to edit or create an new record - none of the fields are showing in the form. Is there a way to rollback to an earlier version? Googling that next.
Display Nested Subform values in Record Template
Hi, having a really hard time with this. In Parent form is a subform with most fields hidden, and a decision box. Clicking the decision box invokes OpenURL to display the full subform and allow the user to create/edit each row of the subform and interact with a nested subform within the subform. The issue I'm having, is displaying values from the nested subform in a record template. Any ideas for displaying subforms within subforms on a record template? Thanks! Levi
JSON from exported views starts with parenthesis but does not close
Hi all, I have a problem consuming my exported views because JSON data starts with a parenthesis but does not close and causes "SyntaxError: missing ) in parenthetical". My following URL: https://creatorexport.zoho.com/showJson.do?fileType=json&sharedBy=f1ps3online&appLinkName=campeonato&viewLinkName=ANUNCIOS_Json&privatelink=vfWCWZSbg48jYC4495dkZWjKqN2Pp3zyyuenyZ56KdFA6QPfExM5aJB9h1HF52vedz4ZmC70bxr1WRqGpwGG7WWNMW7m8nKCS7AD&callback=? Returns: ({ "ANUNCIOS": [{ "ANCHO": "", "SECCION":
Is it possible to search the custom filter list or use a dropdown box to select an item from the list?
We are going to add at least 30-40 items into our custom filter list and it would be really very helpful to the end user to be able to search inside the list and also be able to select an item based on the partially entered search string results. As a second solution the user could also select their list from a dropdown list of the filter items. Are these type of custom filter options possible to perform on Creator?
Creating Panel dynamically on a Page
Hello, i am fairly new to Zoho and as a POC i was wondering if there is a way to add a panel dynamically on a Page. For example like in "Cliq", message types at the bottom creates an entry right above it without a page refresh. I can imagine this being a function that has the custom ZML snippet formatted. Function can get input parameters as the data that has to go in the panel. when called, function could add the panel on page. Not sure if it is possible ? if not, any other way (hack) to acheive
Set default font size for rich text
Is there a way to set the default font size for the rich text field? I would like to set it to 14 instead of 10, but still allow people to change it if they choose. The real reason I want to change this is because the text is being used in a record template to save a PDF of the record. When saving the PDF, I've noticed that the rich text fields are coming up with small font. Hopefully changing the font size for the rich text field to 14 will keep it 14 when it gets plugged into the PDF. If there
User permissions and "Invalid entries found"
Dear friends, there's a message coming when editing a form "Invalid entries found. Please correct and submit again." This happens only when I change one field permission not to be visible (only one specific field), under user permissions-> more-> field permissions. It's a field which I don't want this user to be able to see. Any ideas how to solve this matter?
How to update a filed in form A based on a dropdown field in form B??
I have 2 forms. Form Schedule has some a drop down field called Status. The choices in the dropdown are Maintenance, Restoration and Survey. Form Airstrip Profile has a field called Ops Status. I would like this Ops Status to be updated from Form Schedule. Data in Airstrip Profile is usually entered first. I have a lookup field in Form Schedule that looks up Airstrip Name. The rest of the data is entered. Ops Status is one of those fields. I would like Ops Status field in Airstrip Profile to be
Can we send some data to our Application
Hello everyone We want to send some data with additional information from our server to application form. In future we want simply allow our customers to install our application from marketplace and receive some data from our project (server). Initiation request for adding extra data always come from our server Logic schema: 1. First request after install our app (e.g. from form): Client's App --> Our server with extra data 2. Requests with inserting additional information: Our Server with extra
Workflow Deluge Script not working in subforms
Hello, I've set up filters for my database for lookup fields so that users logged into the customer portal can only see records that are associated with them. I've also had to add some Deluge Script to allow for administrators logged in to be able to see all of the records. This has worked fine when directly accessing forms - all of the records populate the lookup fields appropriately. However, when looking at these as sub-forms, I (as an administrator) can no longer see all of the records populating
Deluge. Count number of instances in list (or map)
Example: Have put the following in a list: Name Department John A Dave C Mary A Jane C Pete B Oscar A Want to list the count for each Department (and put it into a list or map) like: Department Count A 3 B 1 C 2 Have tried with combinations of Count() and Size() and distinct(), but not find a way around this. Great if someone have examples. Thanks, Larry
Report Filtering using a Lookup ID
Hi team, I'm trying to create a link to a report (filtering by the an lookup). The field in question is Estimate which is contained within the Estimate Inventory form. I have gone through and followed the steps outlined in the tips and tricks but to no avail :( https://help.zoho.com/portal/community/topic/tip-02-how-to-dynamically-filter-reports-using-url-parameters-22-3-2018 Panel - Action The page passes through the identifier without a problem, however the report will not filter. https://app.zohocreator.com/<company>/estimator/#Report:Estimate_Inventory?Estimate.ID=3724905000000045059
This function only returns one value to all records
Hi, I built this function to update a field in form with the text name of the lookup field in that same form. This works... except that for every record, it is updating the same lookup field name to all fields, instead of the correct lookup field for that record. So instead of getting the correct Single Workout Name for each record, I get the same one for ALL records. I am missing a part of the code that pulls from the same record and update that same record. I am not sure what I am missing.
File Downloader Tool for Mac
Hi everyone, I'm having trouble figuring out how to download files to desktop from 'file upload' or 'image' fields in forms. I assumed this would be an automatic option? Are there settings I must adjust first? I'm using a custom app in Creator. I found this page with a link to install a 'file downloader tool' but it is only compatible with Windows and I'm using a Mac, and can't seem to find a mac version anywhere... Filedownloader tool https://www.zoho.com/creator/help/fields/uploading-files-and-images.html#download_file
System wide app failure
Has anybody else's app stopped working? I've had an app running fine for the last year. Now all of a sudden I get errors popup all over the place since yesterday. Still waiting on Zoho creator support team to respond. From experience it is something on their end rather than code that decided to re-write itself overnight.
Record Template editing is glitchy
I've created several PDF templates for records in Zoho Creator, and every time I do I find that the editor is always glitchy, mostly when it comes to text and background colour changes. Sometimes if I save, close and re-open what I'm working on, I can get the editor to start working so I can change font properties. This happens a lot. But, one thing that never works for me is changing a heading colour to white (I wanted to have some headings with a dark background colour and then white text).
Populate a subform field with data from a different app
Hi, I have two apps, App A and App B. In App A I have a lookup field in a subform that looks up records in App B, I want to be able to populate another field in the subform based on what the user selects in the lookup field. I understand that this is possible using a custom function that collects the data and places it in a map, I can then call the function and using the ID of the lookup field use the map to return the variables. I've got so far and have managed to create the function in App B....
Sheety Subform Values
We are currently integrating our form with "sheet" to collect the data. The Sheet is collecting all of the form values but the values from the "subform" are not showing up in the "sheet" ...Nor is the section Is this possible? I found an article where it was suggested that I create a form for the elements of the subform. Then when I use the custom subform add....it will ask me to choose - "blank"-new subform - or existing... I do not get this existing option. The structure is: Number of Attendees
Pulling records from another app with notifications
Hello, Can someone please give me some direction on this. I have an app called Receipts that user's submit vehicle receipts to. It includes maintenance, fuel, etc. with the current mileage. I want to set it up so that the last person to submit a fuel or oil receipt for a vehicle, becomes the "owner" for that vehicle. Also the current mileage should be stored on the first oil change, called initial_oil. When the current mileage for that vehicle = initial_oil + 4500 I would like to send a notification
How can I set a Date and Time Field to blank using Deluge Script?
I am creating an application where I calculate and fill a Date and Time field. However, if the user takes some action I want to be able to set the Date and Time field to blank or null using Deluge Script. Is this possible? Thanks.
Store PDF(Binary file) in Form File Field.
Hi guys, I need to store API response in the Form File field and I'm getting API response in PDF(Binary file) format. How to achieve this in Deluge script? For Example: API response will be in JSON format like below: { "ConversionCost": 4, "Files": [{ "FileName": "www_google_com.pdf", "FileSize": 68342, "FileData": "JVBERi0xLjQKJdPr6eEKMSAwIG9iago8PC9DcmVhdG9yIChDaHJvbWl1bSkKL1Byb2R1Y2VyIChDb252ZXJ0QXBpICApCi9DcmVhdGlvbkRhdGUgKEQ6MjAxODA4MTMxMDUyMTMrMDAnMDAnKQovTW9kRGF0ZSAoRDoyMDE4MDgxMzEwNTIxMyswMCcwMCcpPj4KZW5kb2JqCjIgMCBvYmoKPDwvVHlwZSAvWE9iamVjdAovU3VidHlwZSAvSW1hZ2UKL1dpZHRoIDI3MgovSGVpZ2h0IDkyCi9Db2xvclNwYWNlIC9EZXZpY2VSR0IKL1NNYXNrIDMgMCBSCi9CaXRzUGVyQ29tcG9uZW50IDgKL0ZpbHRlciAvRmxhdGVEZWNvZGUKL0xlbmd0aCA3NDYxPj4gc3RyZWFtCnic7V1bbxvJlSYsWZPJ78jTDDAZmxdfxpPu6m4xNmA/LfR7KKibpDyDLJC87T9Y+GmRXSSxLjMLDJCn/ILdhwE2MxYvcizxIlkXoPd8p5pSSyarqi+ULKUPCgQtk93Fqv7q3M8plfIhq30ommPRHPEYPlt9awdjtzV0m0OnNXboNRjx+xH9022N7ebQXg1FMKT/wmswtBqDnOZSUEEfKVnrY4KAHYxEMLLbh06AfxJkHINh+wPAp0mYGtmrA+EPcZ3mePnb8Lp/VkEF5UxOc0B8wW4O7JcHxC8s3wgjM4c/kGCpfxvaPtD3dTC67p9Y0BVR5d"
Sub-form items in detail view - ability to edit
Hello, I'm trying to limit the number of menu items by having (mostly) only forms on the database menu. My main profile form has a number of sub-forms (hidden in the main profile because I don't like the horizontal fields and lack of control). I've set it up so that when a user is looking at the report for all of the main profile records, clicking on one brings up the "detailed view" which includes the sub-fields with related records listed. Clicking on one of these related records brings up
Scheduled emails from creator
I know that I can schedule emails from creator based on date but how can I check other fields first. Example before I send an auto email based on a field date I also want to check a field to see if the customer opted out etc. I know I could do the in crm but creator offers me the facility to have life formula updates.
Single Column / Double Column? I need complete control where I place fields please.
I'm trying to convince a company to invest in Zoho Creator but their main complaint is that form layouts are too primitive. I'm learning how to use the form builder and can only see 2 choices. Single and double column layouts. I can't place the fields freely on the form. I'm sure they will invest in Zoho if I can show them a nice looking data entry form. I don't know HTML but I do know it can do nice looking field placements. The builder is supposed to let me place fields freely. I need to do something
Any way to integrate zoho form to wordpress form
Hi, Right now what I am doing is getting a form submission through my wordpress site and importing it here to my zoho form. And once it gets populated we do our other actions. I wanted to check if there is any way where i can directly populate this zoho form with data through my wordpress ninja form data every time a user submits this form?? how to link my zoho form ro this wordpress ninja form? This will reduce our import task daily. Thanks, Pooja
Pivot Table to Count Tasks in Related Form
Hi- We have Form 1 to collect the names of employees. Form 2 uses a lookup to Employee Name in Form 1 to assign a task to employees, with the ability to mark the task closed when completed Is there any way to create a pivot table that would provide a count of the number of open tasks per employee. I don't think I can build the table off of Form 2 only because there are some employees from Form 1 who do not have any tasks....they have no data in Form 2 so they would not show up. Basically, want
Add an icon field
Hi ZC team! It would be really great to see a icon field make its way to ZC with the ability to assign each icons to functions when clicking the icon. Currently, you can add custom action buttons to rows, but they take a lot of vertical spacing, can't be customized and in general, icons are preferable in terms of good UI design. I'm attaching an image of what I was able to do with a rich text field and some <i> tags pointing to urls. This allows for opening a comment module, an audit trail module
Displaying Length Of A String Field
I am displaying the length of a string field by creating a Notes field like this: <div style="text-align: right"><span style="color: rgb(153, 153, 153)"><font size="2">0/30</font></span></div> and using an On User Input script like this which truncates the field to a particular length or displays the updated length in the Notes field: if(input.Headline_1.length() > 30) { input.Headline_1 = input.Headline_1.mid(0,30); } else { input.Headline_1_Char_Count = "<div style=\"text-align: right;\"><span
Can I build Accounting & ERP system by Creator ?
Does Creator has the capability to build ERP system if task done by experienced developer ?
Conditional filter based on user role
I have a look-up field which connects to our main family profile records. We have instructors that teach families, and each instructor has their own login via a customer portal. I've set up a filter on the look-up field so that the only family names that come up are the ones that are taught by the instructor that is logged in (so that they have access to only the names of the families that they teach). The issue is that if one of our administrators wants to add a record, the filter does not allow
Login limit
Hello. I have developed an app that -among other things- allows the user to upload images. This app is the front-end to a report generator hosted in a remote server. Since Zoho Creator doesn't allow to automatically download images (via API or the like), I developed a script that automatically logs in, retrieves the images URLs, downloads the images one by one, and then logs out. Last friday, after I ran this script many times, it stopped working. When I tried to manually log-in, a "Login limit reached"
Inserting Sub-Form Rows
Hi everyone, I've done some reading around and whilst the problems seems to be solvable I'm going around in circles Scenario Once new inventory component is created, we need to pre-populate a list of tasks for (percentage) allocation. (via Custom Function) Problem I can't seem to be able to loop through the tasks and incrementally add them into the sub-form. I have tried Directly adding (via insert record) to Sub-Form. However, I get the error "Form 'Task_Distribution' does not exist in the application"
Mobile menu not updating
Hello, I've set up a customer portal for our users, and in my testing I've noticed that the menu isn't updating on the mobile side. I've hidden items and renamed some things, but those changes aren't taking effect on mobile. I do see the changes when I login on my desktop, so I know the changes are being made. I just can't figure out why they wouldn't be updating on mobile. Is there some delay in updating the mobile that I'm not aware of? Or, or is this a glitch? Any help is appreciated.
Retrieving Customers from subscriptions.
Hello, I have a function that I created today that pulls customers from subscriptions. And no matter what page number I put in I get the same records. The page number is set to 4 below. But no matter what I use I get the same customers. Below is code: Custs = zoho.subscriptions.getList("Customers","649130175",200,4); I could change the 4 to 1 and I would still get the same customers. Could someone look into this for me. Bob Lozinak Twelve/Three Marketing, Inc.
Help page information about creating subform-mainform relation is out of date
https://www.zoho.com/creator/help/forms/creating-subforms.html#Creating_relationship_between_mainform_and_subform The second bullet under this section does mention some actions which don't seem to be related to C5 but to C4. Select the SubForm report from the Reports tab, click on "Column Properties" and select the lookup field created above and click on "Link " button, to create a link to the MainForm data. I've did use the "Configure Fields for Web" window belonging to the related report and have
Remove obsolete fields
I have a Creator app in production. I am using Sandbox to make modifications. There are a number of fields which I have identified as obsolete (which do not contain data in production). I would like to remove them from a form but I get a message saying that the fields cannot be deleted while in Sandbox. How do I go about deleting fields which are no longer necessary? I can hide them so that only Admins see them but that is very messy. There must be a better way. Thanks.
Next Page