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
multiple if conditions
Hi, I´m new user and I would like to know how to combine multiple if conditions. For example: I have two fields: -Survey- and -Projeto-. I have another field named -Percentual-. If Survey is checked as "Done" - The Field Percentual have to show "50", so I did the following formula: if(Survey="Done", 50,0) I did another formula: if((Survey="Done") && (Projeto="Done"), 100,0)) Each formula works good whithout the other, but I want both formulas work together. I tried this (didn´t work): if(Survey="Done",
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) &&
embedd HTML in webstite
I am trying to embed HTML into my webstite and this works properly with one page/view. I am using the referral network from which has mulitple pages to it. how am I able to place this in my website and have users access multple pages/view. Not just the single form. It reading through the help topics, I think it adding the "Get Java Script" Snippet is the way to go, however I do not see this selection on the form I am using. Please assist.
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
Is sharing having some Problem
Hi, I am unable to execute share script . Even though i have only one user active and 4 are remaining but then too there is a problem. I even visited the Manage Users link and there it shows 4 users remaining but share script shows error that No. of users exceeded. Help me as soon as possible. I am stuck. Regards, Pratik.
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
Repeat until...
Hi, I'm sorry, my English is very little. This is the problem: if((input.subdep == "mag_01")) { a001.mag01=(a001.mag01 + a000.m001); a002.mag01=(a002.mag01 + a000.m002); a003.mag01=(a003.mag01 + a000.m003); a001.Quantit_IN=(a001.Quantit_IN - a000.m001); a002.Quantit_IN=(a002.Quantit_IN - a000.m002); a003.Quantit_IN=(a003.Quantit_IN - a000.m003); } Now... is possible to use a function to increase the value of form and field name? a00x with x = x+1 until x = y
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 do i make an employee number auto assign to new records/form submissions
I would like to use creator to manage employee records. the last employee we hired was number 77, so I would like the next to be 78 and so on, with out having to look up the last used number every time. Please provide the script if you can.
Rich text fields are useless in stateless forms
ZC Team, I tried to access a rich text field in a stateless form with Deluge, but regardless of the field content, it appears as empty in scripts, so there is not possible to use it in records inserts and in fields updating... Thus, in stateless forms Rich Text Fields are now useless. A fast fix of this problem would be appreciated. Regards, George
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
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
Next Page