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"
Product Image Url
Hi; I did not find a way to add Image Url to crm with deluge script When I add new record to Products. Are there a way to add image url with script ?
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 Trick? Combine Single and Double Columns In a Form
Hello- Just started playing with creator and I've run into a design challenge within forms: Right now, a form can only be a single or double column. Does anyone know a trick to have both in 1 form? Its a bummer to take up tons of vertical space for small entries like a checkbox or date and I find my forms as strangely tall. Or, is there a way to have multiple fields side by side? Anyone have a suggestion? Thx!
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
Custom Snippet tool for Zoho creator pages
Often I am making pages / dashboards which has a certain number of elements same (for example I created 5 pages all of which had 5 buttons which interlinked them together same). Now the rest of the elements of the page are different, but these 5 are just the same, so if there was an option to either make a snippet or a mini page sort of a thing which I could call within my application anywhere, that would be amazing. The biggest pain point here was that originally these were 4, so when I had to add
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
Openurl/iframe opens the url in a new window instead in the frame
This functionality was working fine in my application for years, but after the security update, I experience this issue. I've 100% simplified my application but the issue remains: I've an HTML page with 2 named frames htmlpage miframe() <%{%> <iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/arturoacedo/test-zc56/form-embed/Untitled_Form/4A4x4zVJ9dkj5TaBEsvwgMPvJ6wM3PJKwM1Sk4Yz7yRNS8aAKOYjrQMFmHvBDgtOR1pFVBBf2UXMRhK28jSnrWNdOumdKva5jNvf'></iframe>
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"
Report for running total vs forecast
Hello, I'm currently trying to build a report that would show how much income has been received to date vs a set forecast. I envisioned some kind of doughnut chart that shows a percentage that gradually increases as additional income is received, but am unsure how to do this in Zoho, or if it is feasible. Any help would be greatly appreciated. Sam
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.
Zoho Creator File Upload API
Hello Zoho community! I'm having trouble with uploading a file into a zoho record. I've checked this post out https://help.zoho.com/portal/community/topic/upload-image-file-via-creator-api-from-ios-app but it seems like I'm doing everything correctly. He uses Apple's NSData of the image, but I'm using Base64. I'm getting back a success response too. <response> <result> <form name="Sign_Up"> <fileupdate> <values> <field name="Photo_ID">
Get nested drop down
Hi, I have a requirement where i have 2 dropdowns. One is Area Second(which will have 3 options say option1, option2 and option3) and second one is Sub Area(which will have options like option 11, option 12, option 21, option 31, option 32, option 33). When i select e.g, option 1 from Area.. it should display sub area options from Sub Area dropdown only related to it i.e, option 11 and option 12. Similarly if i choose option 2/3 same action should occur. I referred to some forums. But still stuck
Picklist sometimes not pulling records during edit
Hi there We have an issue where on editing a record, where we've already defined a picklist item during the create record process, the set picklist choice does not show. Is there a way I can ensure that the picklist field we have set shows in the edit record information.
Importing subform data results with success but no data is being imported
The import process results with success (or at least without any error messages about any of the related subform data) when I select the "Do you want to import subform data" option on the data import screen and select the related subform columns on the data relation table. When you return to the report after the import process and look up for those imported data then there isn't anything in the subforms. What am I doing wrong here? I can't also find any related help pages on the help guides about
open page in popup window without navigation
hi is it possible to open a PAGE in a popup without the Creator Navigation? i want to display record details kind regards Lambert
Exporting Page to PDF page size issue
So I created a Page in Creator 5 that we are using as a report page. We export it as a PDF and then print it out on our printers, but the PDF that is created is slightly larger then 8.5 x 11. When we print at full scale, it crops about .5" off the top and bottom. We been printing with the Shrink Oversized Pages turned on. Is there some way to control the paper size that the export to PDF uses?
Populate a field with criteria from other fields
Not sure whether this is the right way of doing this but i'm trying to populate a field by looking at results from other existing fields and then taking a value from one of 6 variables. The Script I created is below but its throwing up an error on line 8 "Improper Statement Error might be due to missing ";" at end of line or incomplete expression. I cant see where i'm going wrong though: KidsKick = if(Height <110,"Micro",if(Height <120,"Light",if(Height <130,"Welter",if(Height <140,"Middle",If(Height
For Each Value In A List Not Working, Help Links Are Wrong
I've been searching for a way to add each selection in a multi lookup field to a list. I came across an older help article here: https://www.zoho.com/creator/help/script/for-each-value-in-list.html Knowing it was for the older Zoho Creator, I still thought I'd try it out as it's currently my only lead. However when I did, the error told me that this type of iteration was no longer supported, and gave me a link to learn more. However the link itself doesn't work. So I'm now back to square one
Sending an email with several record templates
Hello, For each of my clients, I create a project. each project contains 3 subforms. for each subform i have create record templet when i finish a project, i want to have a way to send an email which contains these 3 subforms record templet to the client. How can do it? please advise..
getPrefix on a mixed field [SOLVED by Adhavan S]
This is my first post, as I'm new to Creator. Please give me some ideas on how I can solve the following problem: I have a lookup field witch takes data from two fields: a Number and a Single line text, separated with " - " (example: 125 - The Customer One) On another form I'm running an on-load deluge script, where I want to get the number and use it. I have played using the get.Prefix of get.Suffix, as well as conversions to Decimal or Numeric, etc.., without success. suffix = customer.getsuffix("
Pivot table filter won't update
I have created a number of pivot tables based on a drop down box in my form. I am creating individual reports and filtering each one by the corresponding criteria. Like so: Report #1 - Leads (Drop down option = "Lead", Pivot table filter = "Lead"). The pivot table displays all open leads in the system. Report #2 - Prospects (Drop down option = "Prospect", Pivot table filter = "Prospect"). The pivot table displays all open prospects in the system. And so on... All of the pivot tables worked great
sending email reminder based on field date plus
Hi, Been using creator and the rest o9f the Zoho products for some years. Very happy. For our new year project we would like to send reminders to customers (email) based on a couple of fields. 1. Next contact date which we already have in there ( we would like to send it 30 days before) 2. That it is a current record. 3. The customer has not opted out. As always when i start these changes I am always over whelmed by choices so a point in the correct direction would really help. Thanks
Get info on users who accessed the form
Hi, I have created a Form using Creator App. I have created 3 users to be able to access the form after accepting the invite. I would like to know how can i know which user accesses the form last or which is user is currently editing. Thanks
Edit mobile field order
I love that Zoho creator has an app for users to be able to fill out forms on their mobile devices. What I can't seem to find (if indeed it exists) is a way to edit forms for mobile. For my regular online forms, I have fields set up in columns - with related columns reading left to right... But on mobile it only allows for one column, and thus the logical order is thrown out of whack. Please tell me there is a way to change the field order for mobile! I am in the design space and mobile view...
Next Page