Api calls fail on listing views and listing formsandviews
Hello, I am trying to create custom views outside zoho and api calls gives a 500 (Internal server error) code when I try to consume the following apis: https://creator.zoho.com/api/<format>/<applicationName>/view/<viewName> https://creator.zoho.com/api/<format>/<applicationName>/formsandviews/ Raw response gives the text: An error has occurred. It has been reported to Zoho Creator support. We will look into this issue . Add,update api calls gives expected results. Trying to list the views in this
How to rehide a field when a user deselects a checkbox
Hi everyone, I mastered the show field for checkbox selection earlier today (thanks to Herb) using the contains function. But need to ensure that when a user deselects a checkbox, the data is cleared from the field and the field hides again. I have tried notContains later in the script, so the system checks if the checkbox is clear, but it causes errors. I have also tried isnull, but cannot get this work. Any help would be appreciated. Thanks very much
Unable to fetch data from a specific view based on form
Dear Zoho Creator team, I request your help to regain normal functioning of STATS form and its associated views of application called GT. https://creator.zoho.com/f1ps3online/gt/#View:STATS_View Today I wanted to update the field called "Categoria" (picklist) and something did not work. All related views do not show any record since the code definition of the form STATS has been corrupted. I have given edit access to support. Thank you very much for your time and effort.
Checkbox 2-column/Single-column option lost on edit.
Steps to reproduce: 1. Create a form with a check box field. 2. Add several values (say 6). 3. Set the layout to 2-column display. 4. On user-input action, modify the list of values available (clear the list and then add new values). (Application: Imagine a Survey. A user has options "A", "B", "C", "None". If a user clicks on "None", I want the rest of the values to be removed from the list since ZC doesn't allow disabling of individual values). You'll notice that the 2-column layout option is lost
String to Number in Dropdown
I have a Dropdown R1, where the choices are 3, 3.5, 4, 5.5 I want to multiply the Price of an item by R1 as a percentage Have tried returning R1 as R1.toNumber() as toLong(input.R1) but receive error messages
How can I add a barcode number to each field, that will pull a specified feild when barcode is scanned?
I want to add a barcode to my records , so that when the barcode is scanned it will automatically pull up the corresponding record. Is this possible?
Editing Records from Reports don't link to base Form (since about 30 Minutes)
I've been working on a Creator application for the past couple of days and all of a sudden things don't work as they used to (since about 30 Minutes). Previously, when I clicked on the Edit button in the left-most column of a Report, the original base Form would appear with all the fields and all the validation logic, etc. Now what I'm getting is a dialog box with just the fields from the report. I have rexported the application and diff'ed it to an older copy, but I can't find any difference that
Set variable on a related Form B with data from Form A before Form A has been submitted/persisted. Possible?
Form A has a NameA field with data "John Doe" A related Form B has a field NameB that is to accessed half way through filling out Form A. How do I set the value for Name B as "John Doe" before Form A is submitted/persisted?
Creating report of subforms
Hello, I have been working in a purshase management where i have a form named "products" with products and categories of the items., I have a form named "order management", with the fields (Project, date, and the subform named "Products") . I need to create a report group by product, where appears the quantity per project of products, any ideas? Could i Do that with html view? Hope your answer, thanks.
help with zoho.loginuserid
Hi. I'm new to zoho. Had some experience with MS Access. I've created a form for service tickets. I plan to have users pull the tickets from the view for editing. I need to create a script Edit - On load to show, hide, or disable fields. I thought I would start with hide all and then based on the user login show the fields they can edit. I need a sample code to do this. Thanks
Quick Developer Job
I need a Zoho Creater developer to do a quick interface for me(1 day). We simply want a quick way to select and store many to many relationships between two tables that are entered manually with a benchmark note. 1. Select the table you want to use as base. 2. Select a second table as a comparison benchmark 3. Display first selected table in column mode with an action button next to each record. 4. Action button brings up iframe or popup that allows you to select a record from the second table and
Best Practices - Performance
We are developing an application that will have 25-50 concurrent users and are concerned with performance. Has anyone published or build a list of Best Practices around Coding for Performance? Any stories on what not to do? Thanks, Troy
Entering a field value from a variable dependant on checkboxes selected
Hi all, I have been working on this for hours now and am still struggling to find the right process to do this. I have a form with a few checkboxes: 1) All Students 2) All Staff 3) Members of the Public For the purpose of reporting, I have a hidden field which I would like to effectively enter values dependant on the selection above. I originally set this hidden field to contain values according to what was selected, so if all the checkboxes aren't selected, I would end up with null in place of
How to automatically set default value after submit
Hello. I would like when I submit something (e.g a lookup dropdown) then the form to keep as default value the last record. What I mean, If I have a lookup dropdown with: -select- food drink If I choose 'food' and click submit then I want to have food as default (for adding new record). The same if I choose 'drink'. In general I want when I choose something and click submit then this choice to be a default value. Is it possible to do that?
Cannot get image to display in HTML View
I cannot get the image to display in a html view... https://creator.zoho.com/crocked/receipt-application/view-perma/Print/thisID=740075000000264747 This is what I'm trying to use, but it just displays a box with "image" in it. <img src="https://creatorexport.zoho.com/DownloadFile.do?filepath=/ZFS1309176687906_Amato_Image.png&sharedBy=crocked&appLinkName=receipt-application&viewlinkname=Picture_View"/> Can someone help? Damien.
Access zoho.loginuserid field
Is there a way to access this field? I want to pull it into a form as a multi-select field.
Zero Response/Follow up from Zoho Support
Zoho Support, I sent an emergency request 7 days ago, and all I have gotten from you is en email saying you will look into it. I have sent repeated follow up emails, and left a voicemail. I don't like to air my dirty laundry but you leave me no choice but to come to the forums. As an "Enterprise" client, I can't imagine doing this to one of my own top payment-tier clients. When is someone going to help me?
calculating a midpoint date
Is there a way to calculate and store a date that is midway between two other dates? This is how I would expect it to be calculated, though I'm not sure how to code it: MidpointDate = StartDate + ( (EndDate - StartDate)/2 ) I want this field to be calculated when the StartDate and EndDate have been entered and then to have it stored within the same form. I also plan to create an email notification triggered by the calculated MidpointDate.
Changing field from currency to decimal
On trying to do this I receive a popup warning me that data will be lost when changing the field type. Is there any way to do this without losing Data?
Hide -Select- from dropdown
I would like to ask you if it is possible to hide the '-Select-' from a dropdown menu and also to set a default value on it. As an example: first choice second choice third choice Is it possible to set 'second choice' as a default value? I read this topic https://help.zoho.com/portal/en/community/topic/drop-down-list-hide-select-from-choices but I think that it is based in older version of Zoho Creator and I cannot find 'Initial Value' on it.
Pivot Chart report page not loading when make new report. ZC support not answer by mail.
Problem #1 I try to make Pivot Chart report for one of my app, when press button Create page start loading but after long time waiting still not load. Other type of reports can make without any problem for this app, just Pivot Chart not working. For other app Pivot Chart reports working well. Problem #2 In Report type List can make several criteria and all must have or logical "AND" or logical "OR", can't make complex criteria. Before have group for this, now can't find it. Is it possible to make
Auto Generated Number Field with prefix
Any help will be appreciated: Issue ------- The Auto Number starts from "1" - It is missing the following basic abilities: 1- No Prefix can be set For Example Starting with a letter 2- No starting Number - I want to start the first record from 2500+ 2501, 2502.. (Is this too much to ask??) 3- No Leading Zero possible - for example 000001, 000002... I need to create an auto numbered field for item lot number looking like this L0000001, L0000002, L0000003....L0000015... I used a formula field that
Embedding a Google Map into a Form
I'm creating a property database application and I'm trying to give the users the ability to find the location of the property on a google map. Is it possible to embed a google map on a form so that when users input a new property they can locate the address on a google map, which will then be displayed in the report so that when I run the report I can easily find where the property is located?
Create new section into a section
Hello to everyone, I would like to ask you if it is possible to create a new section into a section. Lets look an example: I have an application with the name Hotels. The first section is called Hilton Hotel. Then I want to have 2 subsections (under Hilton Hotel) with the names Setup and Room Comparison. And finally I want to have some forms (Room, Price etc) under Setup. Is it possible to do that? Like the webpages which has menus, submenus and sudsubmenus...
rebrand each app in account
hi there is three different apps in account how can i for each app assign different image in left upper corner? app1 - image1 app2 - image2 app3 - image3 and so on
Lock date in Calendar View
Hi All, I'm working on a application that revolves around a Calendar View. The drag and drop feature is just superb however I've come up against an issue that I can't think of a way to solve so any help will be greatly appreciated. The Calendar shows scheduled flights and as mentioned, it is great to be able to move them as we reschedule, but once the flight has taken place, the flight record has to be "locked" to the specific day that it took place (ie disable the drag and drop feature.) Is this
Full screen record editing
Hi All, When adding a record, the form loads full screen. Is there anyway of being able to edit records in full screen too rather than a window as shown below: The problem is that the edit window isn't wide enough to show the subform widths and the horizontal scroll bar is right at the bottom of the form. Many thanks for any help! Chris
Spreadsheet style data entry form: is it possible?
I want to create a six-row, four-column matrix for data entry. I can do this a little clumsily using a subform. Has anybody managed it any other way?
OnLoad Set variable "Name" to correspond to Loginuser.ID?
Form A has a list of users with details such as Name , Phone number etc and includes the unique Loginuser.ID for each user record. Form B is related and on load sets variables to show the current date, user id an so forth. How can I set the Name variable on Form B to correspond to the particular loginuser. ID. ? In other words retrieve the real name of the submitter for Form B. I guess that it is a "Fetch records" problem but I cannot get it to work properly.
Cannot add subform feild to my view
this bug I will refer to in a support request - cannot add subform field to my view
populating a field in a parent form based on a field in a subform
I have a parent form with a subform, and I know how to have fields on the subform populate based on the parent form. But is the reverse possible? That is, can a field on the subform be used to update a field on the parent form, upon either user entry or submission of the subform? If so, how would I script this?
Recognizing fields
I'm noticing that when I make a change, add or delete a field in a form, if I go to workflow, the fields are not available for use. If I switch to free-flow scripting I can type it in myself and it works fine. Also in the new app builder, the ability to select fields or user variables in the dropdown does not always work. Third is an issue with the image field. If i go into Column Properties and change the image size from Actual to a anything else, when my app is downloaded, it changes back
new user registration/login
I'd like to build a bulletin board type site where users can submit posts, but only after registering an account. How would I go about implementing user registration and login? Thanks.
Deleting subform data
Hi All, I'm looking for some advice please ... I have a master form with several subforms. Depending on choices made from dropdown lists, these subforms are hidden or shown. If a user enters some data into a subform, then changes their mind and selects another option from the master form; how can I clear any entries they've made in a subform from the master form so they don't get persisted? Many thanks indeed for your help! /Chris
More colors in customize
Dear Zoho Team, at the moment there are 5 colors available for applications under customized view: grey, black, orange, green, blue. is there a chance to add purple, red, maroon, yellow, light green, brown, etc.? thanks, Gil
Filter dropdown from another dropdown on a form in on Load
I have two drop downs on a form. The second is filtered by information from the first drop down. It works perfectly however if I prefill the first drop down in the On Add On Load section the second drop down is always blank. How do I trigger the second drop down that there is a value in the first drop down.
Problems with Script Builder and HTML Pages
I am having a LOT of problems trying to create an HTML Page. If I use Script Builder, it works fine to embed a Form, but if I try to use "Insert HTML" the whole screen goes grey and freezes as soon as I drag the "Insert HTML" icon onto the script area. In other words, I have no option but to use Free Flow Scripting. In Free Flow Scripting, I often make some changes or additions to the code, click 'Save Script', and it seems to save OK. (First I get an annoying Internet Explorer popup asking
!!! Recalculation without infinite loop !!!
Hi there, I have build a simple calculator which calculates some plastic specifications called MFI (each has got min and max, compare the screenshot). There are 3 different types of MFI (Melt flow index) MFI 2, MFI 5 and MFI 21 / HLMI. I have got all the functions to calculate each of these types, if you have got one of them given. The aim: If you type in a value in one of the fields, all the other fields should be calculated automatically. So far so good. The problem: If you change one of the values,
Need to populate first five digits from a number field to another number field
Hi, I have a Product Serial number field and a Product Batch number field in my form. Batch Number is the first five digits of the Product Serial No. User should either enter the Product Serial No. and Batch Number should automatically be populated in the Product Batch Number field or if the user does not have the Product Serial No., he should be able to enter the Batch No. directly in the Batch No. field. Can someone help? Thanks
Row Too Large Error
I have a created a stateless form with 100+ questions and am building the database form to accept the answers of the stateless form and store them in the table. I am using single line fields and understand the limit of 80 fields at 255 characters each. My single line fields are mostly 3 max characters but I'm getting errors at just over 80 fields. Am I missing something?
Next Page