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
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
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.
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.
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
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.
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..
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 ...
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
"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 :)
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.
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
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
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
VERY URGENT!! More images disappearing from HTML Views --- company Home Page is disasterous!
THIS IS EXTREMELY URGENT. More and more images are disappearing from HTML Views... now it's critical imagery on our company's Home Page. (www.warehouse21.org) There is definitely something seriously wrong on Zoho's side.... PLEASE ADVISE AND FIX IMMEDIATELY!!!! Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
Company logo disappeared-- broken link to image -- in ZC headers
Suddenly this morning our company logo has vanished from our Zoho Creator application, replaced by one of those 'missing image' icons. I re-uploaded the logo and it is back. But the real issue is WHY? And, not just "why did the logo disappear", but why are there always little and big things like this happening that keep us afraid of what Zoho Creator will break next? I just don't understand why ZC is so fragile and an endless stream of things getting broken and corrupted. There simply must
Formula in a chart
Hi all is this possible? i have a chart (please see attached pic)! and i would like the user to pick ALMOST CERTAIN from a likelihood dropdown box that i have created & then pick MODERATE from a Consequence dropdown box i have created. and it totaling to the reliant amount ? you will see from the chart that if i choose likely and choose minor it will come to a 3. i hope this makes sence. Help would be very much appreciated as im very new to Zoho
Single record view
How do I generate a view of a single record? In particular, how do I implement this in an embedded view on an HTML view page?
Picklist dropdown returns unwanted data from another field
Hello, I am having a problem with my picklist dropdown. It is returning the data from the correct field, but also it is giving me data from another field that I am not asking it to. I have two forms, one for Groups and another for Intergroups. Each Group is a member of a larger Intergroup. When someone fills out the Group_Registration form, I want them to be able to simply indicate on a dropdown who their Intergroup is by a reference to the IntergroupName field on the Intergroup_Registration form.
Easiest way to create a dynamic updatable list
I have a form that uses a list / dropdown box. the list is static for the most part but i would like to maybe have a user be able to click a button (or some other action) and be able to ADD an item to this list. the user will only ever need to select just one option.
Output requested Data based on a cross reference to a table
I have a table that i want to have users be able to put in the X and Y axsis and have creator output the intersect data. Basically i have inputed a chart that usually you can lookup the years your have been there and current level with the company and the intersect point would be their pay. EXAMPLE BELOW TIME Level 1 2 3 1 20 70 120 2 30 80 130 3 40 90
Labels on a form?
Hi, From what I can see on the forums, there's no way to make certain fields "read only" on a form. Is there a way to have "labels"? In other words, rather than fill editable fields with data, maybe some of those fields can just be text on the form that is taken from data. I want a form that gets data based on a drop down selection, but I only want some of the fields to be editable. The other fields can just be labels/text. Thx.
Creator Set date AND time on load
Let me preface this by saying i am VERY NEW to scripting and using zoho creator. I have a date-time field in a form that i want to auto populate with the date and time that the user will be inputting the data. I have already set the field to hidden and can script it to auto fill in one or the other, but i am not able to get it to auto fill the date AND time. Any help would be appreciated! thanks so much! THANKS!
User registration
I am a newbie and have the following question. How do I setup the application such that the user can register themselves via a form without the admin manually adding them? I'll also need to have it automatically generate the key and ticket for API because I am planning to have an iphone interface to the database via the API.
Decision Box
Hey Guys, i'm undergoing a university project and have encountered a problem creating my application. Basically i have to keep a log of tasks completed by a student for a certain event and if a task has not been completed by a certain date they will be withdrawn from the event However it is ultimately at the discretion of the event organisor so i also need an override function. I was thinking about using a checklist features to log the tasks and a decision box to perform the withdrawel function but
How to make a calendar view out of multiple fields
So I have a form with jobs that have recurring dates that are based on there frequency. My form has a next date, second next date, third next date, ect field. I want to have a calendar view that shows all of the future dates but calendar view can only be based on one fields. Any ideas?
Auto Generate Email
Hi I am a very new user having been forced to transfer from Dabble. We have an instruction booking system for appointments which are completed online. once we receive them we validate then confirm appointment time. To explain fields that appear on the web form are something like this Instruction Date (Auto completed at time of input) Client Name (Input by Client) Detail (input by client) Appointment (Completed by us on validation) Within the form we have additional fields that we comlete
Column widths suddenly way too wide
Suddenly most of my views are super wide as the columns to not display correctly. One view now streches over 3 screens on my notebook. I've checked Firefox and Chrome... same problem. Zoho has edit access to my app (bmpm). Please advise. Regards, Filip
Print & PDF of ZC Views do not wrap text in fields
While preparing for a meeting and needing to print out a ZC view, I discovered that both the Print and PDF functions do not wrap text in the fields, resulting in extremely wide documents -- i.e. the field stretches to fit one line of all the text put into the field. See below. I should note that the offending field is a "rich text" field, and that the text in it has no line breaks. Still, it should wrap. Could this oversight be corrected, please. Printouts and PDFs are essential when sharing
Compare Drop List Item to Supplier Checkbox List
Hi, I am using a Dropdown Field to capture the Country of a Customer registering. Is there a way to compare this value to a Supplier Checkbox List where the Checkbox List of the Supplier may have several Countries Selected EG USA = Country of Customer Registering USA UK China = Countries in the Suppliers Checkbox List Many Thanks
problem adding records to 2 related forms via 1 stateless form
I submitted this to support yesterday but have not heard back yet so thought I would give it a try here. I have a "Contacts" form and a "Clients" form. The Clients form has a "Billing Contact" lookup field which references the "ID" field of the Contacts form. I am trying to use the OnClick event of a single stateless form to firstly add a Contact record and then add a related Client record using the ID returned by the first insert statement, but I am getting an error. When I click on the "View Error
Unknown table or alias 't_612827000000016301' used in select query.
I have been alerted when accessing report page: Unknown table or alias 't_612827000000016301' used in select query. What's that meant?
Is there a user guide for the inventory app I downloaded?
I recently installed the Multi-Location Inventory app to my account and it looks promising for my organization, but will need to be customized. However, before I can take shot at this myself, I really need to understand the guts of this application, which is tough to do just by inference. I am not a developer, more of a fairly knowledgeable end user of similar software (like MS Access).
form problem
Hi, I'm currently working on a University project and I'm having a problem with my form. I would be grateful if any one could help with my problem below. when the data is submitted, I want it to check to see if the date it was submitted is past the date I have specified. and if it is I want it sent to another view. I'm not sure how to do this. any help would be appreciated.
Generate Reports
I would like to generate a report based on check boxes, can this be done if so how?
If scripts to copy within one Application
Hi, I use Creator to list customers and clients. I am not familiar with Deluge and have been trying to write a script to use a "yes/no" radio button field to copy address components. I particularly need help with the Spielman Case Database form. In this one, there is a series of fields for address and an updated address (new address) for each record. Some do not have an updated address in which case I click "no" on the "Address_Change" radio button. I would like it to be so that if Address_Change
Next Page