SQL like queries.
Dear All, I have 2 forms with 2 views created on my Zoho creator. I am not using the ids generated by zoho, because the forms will use ID entered by the user (just because this a requirement from the place I work). So, I am trying to write a script that will do the following: while the user is entering data into form B, he will enter the ID from one item from form/view A. After the ID is entered, it will show the information from that item into the form B, and some fields from form B will be automatically
Sharing a linked COPY of an application (without using the Marketplace)
I've developed an application which I'd like to share with another company. Note that I DON'T mean simply inviting other individuals to contribute data to my application -- I mean creating a separate copy of the application's forms, views, scripting, data so that another company can use the app themselves. And if I make a change to the source code, I'd like the change to propagate to the other company. Is this type of arrangement possible? Can I do this using the Marketplace? Can I do it without
Problem with Record(s) that cannot be edited and submitted! Please assist.
I have a record in a particular form that when edited cannot be submitted successfully. Here is an example: The view link is: https://creator.zoho.com/w21admin/w21data/#View:Contacts_All The record ID is: 340313000007715263 When you 'Edit' the record, the form pops up. But whether or not you change any data, when you do a Submit you get the following error: (it is impossible to resubmit this record) Please advise. If you find issues with this record, please scan all records in that form
Lookup field not retaining format
I have a form for products that includes a price field in currency format. I also have a transaction form that includes a lookup field for the product price field. How do I make the lookup field appear in currency format?
PickList
I have a question regarding the picklist, I want to set a value from one particular picklist by url on a form, if I set the picklist from the wizard when I am creating the component, when I pass the parameter by url, the set is made correctly however if I populate that picklist from deluge script and I pass the parameter by url, the set is not done correctly, Why?????
Saving changed records in Grid View is *still* hanging and not saving changed records (intermittent, but frequent)
This problem was reported and acknowledged many months ago and still remains an ongoing problem: When in Grid view, if you change some records and click the "Save" link, the application hangs while displaying "Saving Records". The problem seems intermittent, but FREQUENT. After waiting a long time for the saving to complete and finally refreshing the browser, you see that NO CHANGED RECORDS WERE SAVED during the "saving" process. Could this be looked into please? Months ago you said it would
How do I delimit a lookup multi-select field with line breaks instead of commas?
Hi I understand there is no direct way to make each entry of a multi-select field appear on a new line when viewed, i.e. one two three rather than one, two, three However, there is a workaround using the replaceAll function and the <br> HTML tag, which I don't fully understand. Could someone please explain this option? The multi-select field I have uses a lookup from another form to populate the list. Many thanks Martin
Help with script
Could someone please help me? I try to make a scrip but I dont know how. I tried this: if (input.survey == "Completo") { (input.Percentual_Completo==10) } else if ((input.survey == "Completo") && (input.projeto == "Completo")) { ( input.Percentual_Completo==15) } else if (((input.survey == "Completo") && (input.projeto == "Completo")) && (input.infra == "Completa")) { (input.Percentual_Completo==45) } I did this based in the follow syntax: ( https://help.creator.zoho.com/Control-Statements.html
script editor incorrectly changing parentheses
I have a validation script which is being saved without any syntax error but when the same script is subsequently reopened for editing, not changed, and then saved again, the editor throws an error due to the automatic changing of parentheses. The following line saves correctly: if (count(Client_Contacts[((Client == input.Client) && (Is_Billing == true) && (ID != input.ID))]) = 0) However, the script editor changes it to this: if (count(Client_Contacts[((Client == input.Client && Is_Billing) &&
Question About Linking Forms & Records
As I am trying to learn more about how to use this, I was wondering if people could point me in the right direction for something. Say I have a product that has 1000 units available for sale. Someone orders 5 units, and I now want it to display it as 995 units available. How do I do this? Do I enter it manually, or can it be done automatically? What I do everything manually, and so I enter a record for that customer ordering 5 units. Can it automatically decrease the units available from 1000 to
need help with simple application
is there anyone out there I can hire to get me started with a simple preferred vendor list? I have the info in Excel, but want to add it to our Google Apps
Cannot Duplicate application...
Hello, I cannot duplicate my Art Inventory Management 3.0 When i click duplocate or copy application it just never duplicates. I have Enabled Edit Access to Support. When i save the application and create a new application from it I get the following error: Error at lineNumber:1 Function:thisapp.general.ArtSerial() does not exist The function is there and it does exist. Please help me correct this issue. I need to be able to duplicate this application. Thanks
How find matched record and alert?
I want users to fill out a form but if there is a match between the data they enter and exisitng data in the database I want the user alerted (by email). The email needs to contain the matched data as well as the Case_Code value from the matched database record. How would I do this? I tried my luck at this but it doesn't work, if Case_Management_form(Case_Name == input.Case_Name && input.Case_Name != "") || (Adverse_Party == input.Adverse_Party && input.Adverse_Party != "" email_body = "Possible
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!
Next Page