Enhancement request: "this" or "input" allowable in Lookup Field Criteria - a better Dependent Dropdown
It looks impossible, but I'd like to create a dependent dropdown by setting a criteria in a Lookup such as a) field_fky == input.field_fky rather than the only supported method that requires an on input action on the field b) https://kbase.creator.zoho.com/application/dynamic-picklist a) would be faster to create and the resulting field would appear in views, unlike b) What happens when I try a) is an error message that "this." is not in the form. When I look at the API for dropdowns, it's seems
Calculate a field from two different tables
Hi, I have 2 forms (tables). The first one is with product and prices for it. In the second you can select a product from dropdown list (connection from the first form) and set amount of product. So, is it possible to calculate automatically in one field in the second form a price for selected quantity? If I change then price in the first form, the price for selected quantity in the second form will be also changed. It must be not a result of procedure that start on form filling ivent like https://help.zoho.com/portal/en/community/topic/camp-booking-form-calculate-price but
Is there a way to do joins in a report
I currently have my form tables linked by ID. When I create a report I would like to use the display value rather than the generated ID. Is there a way to join the forms by ID to get the column value I want?
PickList
Hi, I have a question regarding the picklist component, I have two picklist dependent each other, one for country and another for state. In country I chose that the value gonna be the ID (System Field) of the Country form and the Display field is the name of the country Like this: My question is how can I set on deluge script that the value of the state dropdown is going to be one ID and the display name is going to be another dynamically. I reviewed the syntaxis of DropDown:ui.add(value) but
Zoho Creator is down
The entire service appears to be down right now and it has been 10 minutes or so. Please advise urgently. Anton
Plaque Builder Application
I'm trying to build an application where my customers can enter their information into a form and see a preview of the information, ideally in real time. Is that something that can be done in Zoho Creator? The snapshot attached is from an application that has to be installed and won't work in this situation.
Inconsistent information in Help page ...
This Help page contains inconsistent information regarding the URLs to be used for specific functions. http://help.creator.zoho.com/Functionality-based-URLs.html#To_print_a_view http://help.creator.zoho.com/Functionality-based-URLs.html#To_print_a_view_with_criteria http://help.creator.zoho.com/Functionality-based-URLs.html#To_print_a_HTML_view_with_parameter The format references creatorexport ... but the example references creator http://help.creator.zoho.com/Functionality-based-URLs.html#To_convert_HTML_view_to_PDF
Line breaks in Advanced Display layouts
When creating a Lookup field with a Multiple Selected List display type, is there a way to set the advanced display options to have each new selection begin on a new line (i.e., line break?) The form seems to take a standard html <BR>, but generates an error message ("the value of attribute 'separator' associated with an element type 'field' must not contain the '<' character" when I try to close it.
Default Numerical Field To A Negative?
We created an inventory system using ZOHO Creator and made a web form for our warehouse staff. Is there anyway to default a numerical field to a negative? The only thing our warehouse staff will be doing is removing inventory which we have setup them a page to remove inventory but as we have it now we must put a "-" in front of the number. This is prone to mistakes, warehouse never "ADDS" inventory and we only need it removed. Can we default this numerical field to starting with a - sign.
Having the following error when migrating from Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Dear all, I'm using Windows 7 (64-bit) and Microsoft Office (32-bit) and when I tried to use Zoho tool for importing access database i have the following error "The 'Microsoft .ACE.OLEDB.12.0' provider is not registered on the local machine". Can anyone help me to find a solution to this problem? Thank you very much for your attention Regards. AC
Passing sort order in Functionality based URLs
Dear zc_Creator team, Is it possible to pass a sort order to an view with a functionality based URL? I want my users to be able to set the sort order for a view which can than be called, each time the user enters that view. Is that possible? Kind regards, Silvester
Form script will not load
I am trying to edit the script of one of my forms (specifics below), it will not load no matter what I do, and I have been trying to do it for the last 24 hours. I think it may be because I am trying to link to a cell in another table but may have spelt it wrong, but not really sure. Please help asap. Form link: https://creator.zoho.com/youthalivedatavictoria/form/30/edit/ Script: on edit > on submit is the one that will not load and Form definition with action also.
Calculation in Views
Hi! How can I make calculations in views (query), like (Form1.Column1 * Form2.Column1) where Form1.Form2ID=Form2.ID ? Thanks, Alexander
Embedding forms
One thing that I would like to see is the ability to edit the blue frame around forms. I would love to embed Zoho forms into my website, but can't because the frames don't fit the look and feel of my site. andre.malan
Lookup Sort
I have a problem. I have a table with value (text) and value (order) Like that : text - order aaa – 02 bbb – 04 rrr –01 ggg –03 Now, it matter to me to have that order sort, because it is imported in another table as checkbox (lookup). So in the table #2 there is some field, and one field should look like (multiple value check box) [ ] - rrr [ ] - aaa [ ] - ggg [ ] - bbb I have SORT the first table value based on the order. THE PROBLEM, and the question are: The already enter product in table #2
Problem with setting permission to users
I disabled user permission to edit, bulk edit, delete and add. Its not working in live view. Kindly check. Regards, Edith
Zoho Creator API - We will support only HTTPS
Dear Users, At present, we are supporting both HTTP and HTTPS in our API implementations. However, starting 4th week of May 2011, we are planning to support all API transactions only via HTTPS and permanently discontinue the HTTP protocol. This additional SSL, 256-bit security system will make our third party integrations more robust especially with the data transfer processes. After 3rd week of May 2011, if you still use HTTP in your code, API requests will be redirected to HTTPS. If your client
How to return "0" or "null" values on a report?
We have a report that shows sales by store locations. I would like to also list the locations that had "0" in sales. Is this possible? Thanks for any help.
Edit/delete/add in the form is disabled.
I could not edit/delete/add/remove field to the form: Work Accomplishment. Kindly address asap. Thanks, Edith
How to create User Accounts withought requiring a Zoho Account
Hello. I'm working on a Zoho application that I hope to share with "public" users whom I would like for them to purchase goods from my site. After they make a transaction,I'd like for them to be able to "login" to my application without requiring them to obtain a Zoho account (sort of like an e-commerce application) so that they can securely view their own orders, payments, submit customer services questions, etc. I'd like to personalize their experience as they register in my site and do business
updating records using import
Is there a way to update records using the import method? My application includes stats on professional athletes and i want to update different stat columns daily without adding duplicate entries. I edited the "Name" column so that it was set to "no duplicate entries" but when i do the new import i get new records with blank columns instead of updated records. What's my solution for updating records using the import method? Thanks
Form without section
Hi I have several forms created as a stateless form and they are included on HTML view but my problem is that the stateless form is appearing on my menus thing that I do not want, I wonder if there is a way to set a form without section and do not appear on my menu but appears on my HTML view. Thank you..
Submit the form by pressing Enter
Hi,Previously I could submit the form by pressing the Enter button when I was in a text field. Now the only way to submit the form is to scroll all the way to the bottom and press the button - it was faster when I could press Enter. I don't know why that doesn't submit it anymore. Any suggestions? Thanks, Wisnu http://www.zohology.com/
Report DateTime Wrong
Hi I have been seen that my reports are generated with a wrong date, I already double checked TimeZone on the settings and it is correct. Please let me know the reason of this issue. Thank you ...
Some views won't take grid + then grid gets disabled
Hi -- On several views, if I select "Grid" in Display properties, not only does it revert back to List, but "Grid" disappears altogether from the "View as" submenu in "More actions"... I just tried to create a new view, based on a test form, and that's what it did. Any idea? TIA.
Zoho Creator Reports
Hi, Is there a way to filter a report based on one parameter that I might pass by one stateless form.... Please advise
Printing Without logging in.
It would be nice of we have the option to let the user print without logging in.... Regards, Edith
"contact card view" with editable info and a call/email log
So i have a form that users can input their leads with. Similar to a CRM except WAY more basic. I already created the form and fields for the initial input of the basic information. here is what i would like to do: 1. Have a place where they can view the information that they have already inputted. on this form will be more detailed information that they can fill out. 2. Would like, on this form, a way for them to be able to track phone calls, or really ANY communications sent. a. just needs
Create a form with password recovery
Hi, I have this situation, In my DB I have a table with users and password, I would like to create a form where, when a user loses his pass he would be able to recover it without sending an e-mai to me, how can I do that? welcome all suggests, thanks a lot :)
Javascript in a form/view?
Does anyone know if you can add javascript in a form or view? I'd like to put a "back" button or link on a row/record using the following script: <SCRIPT TYPE="text/javascript"> <!-- var gb = new backlink(); gb.type = "button"; gb.write(); //--> </SCRIPT> Is there a way to accomplish this? I was thinking that I'd add a URL field to the form and then display that on the view, but that doesn't seem to work.
Issue Relationship forms
Hi, I have an issue in relationship two forms, for example I have the follow scenario: I have a table who holds some users and it is called "USERS" I have another that holds locations and it is called "LOCATIONS" I have another table who relation both tables and it is called "LOCATIONS_USERS" And When I try to make a Lookup for "LOCATIONS_USERS" in another form, the user defined fields doesn't appears, Why????? Please advise...
How to pass multiple values for the same field to a view?
I would like to dynamically pass multiple ID values to a view and have that view only display the records with IDs in that list. I can't work out how to do this from reading the functionality based URLs help page.
change file description to download here or icon
How do you tell creator to not show the complete file name under download document (see this link http://litcosys.ca/testing/brochure_finder.html) I want it to simply describe the file name as "download" which would be linked to the document.
How to develop a function that can be called from the 'custom actions' menu to update a specific field in all selected records with a specific value that the user must enter
Dear all, I'm looking for a function to update a specific field in all selected records in a view, with a value that the user must enter in some way. The implementation is to make a function that is called form the 'custom action' menu. But I'm too low level programmer to see how to do this. PS, I do not want the default function 'bulk edit' because then, the users see all fields in the form to update which is unwanted. Kind regards, Silvester Draaijer
For each record - scriptbuilder errors, Scriptbuilder inserts space-characters
Dear zc-Team 1 If I try to insert a 'for each record' function via scriptbuilder to an HTML-view, the expression is not submitted to the code. The other inert functions seem to operate as normal. Please fix. Handcoding is so much more difficult. 2 When switching between scriptbuilder and free-flow scripting, zc inserts space-characters in the code. This is very annoying. Please fix. Kind regards, Silvester Draaijer
Using Creator for many filtered views
I've used Creator extensively. It has many excellent features but there is one glaring weakness - the inability to display many different filtered views. For example, I have a database with a state field. There are 50 states. On my web page I need to give the user the option to select a state (either through link or picklist) and display the database filtered by that state. How can I do that with Zoho Creator today? There does not seem to be a reasonable solution. I can create a duplicate view filtered
Can I create a parent-child relationship within the same form via a Lookup field?
Can I create a parent-child relationship within the same form via a Lookup field? For example: Widgets A and B have no parent. The Parent lookup field is therefore empty. Widget C is the child of Widget A. The Parent lookup field contains Widget A. Widget D is the child of Widget C. The Parent lookup field contains Widget C. How do I create a Widget form that allows this relationship to be contained in a "Parent" lookup field? When I try, I am not offered the "Widget" form as a source of the lookup
Report Scheduler broken?
I have setup two different schedules and neither report ever emailed... is anyone else having problems with report schedules?
Please Update the Feature-updates-and-bug-fixes Page
https://help.creator.zoho.com/Feature-updates-and-bug-fixes.html needs attention. I believe the new account home page layout is now universal, for example. There may be other updates... John M. Whitney
Where should I to look for error when I receive the error message "null" in html views or functions?
ZC Team, I'll not insist complaining of the cryptic error messages, it is a well known issue of Creator and there is nothing new to be added, I need only a hint to understand an often meet error message. Where should I to look for error when I receive the error message null in html views or functions? Regards, George
Next Page