Permalink in new application builder
Hi, how can I get a permalink with no log in required? it seems that this feature has changed with the new application builder. When you follow the "publish" link you get to a new window where you have a check box for a no-login option however this seems to do nothing... Going back to the old builder does not help either as this option seems to be disappeared?... Thanks Luis
Need some information/assistance
I want to know whether there is a way to access Zoho CRM database through Zoho Creator ?
Is it legal to copy a form from another application?
Is it legal to copy a form from another application ? I am thinking that contact form it's a common form widespread across multiple websites and we can create a contact form in our website without to have copyright problems, this thing is applying on any form existing in any application ? I want to copy only the structure of the form and reproduce in my web application (which it's not a Zoho Creator Application) without to take code, style (look & feel) and to add/remove fields after needs. More
Restrict users
How do I restrict users from changing certain fields in a view, while allowing them to change other fields in that view. Any help much appreciated.
JSON API Ignoring filters
I have a view that presents some data to an external software client as json. On the url we filter the returned records using a named column in the view. As of this morning the column we provide is no longer filtering the records and returning EVERYTHING in the view. I've raised a support call but the customer who is using the software client has now had the remaining confidence in Zoho blown out of the water (we had BOTH of the creator outages during the pilot) this morning. The view hasn't been
disable subform
I have a CHANGE HISTORY subform on my TELCO ORDER FORM at https://creator.zoho.com/essistmgmt/form/1696/scriptbuilder/ I have disabled the subform disable CHANGE_HISTORY; I want users to see the CHANGE_HISTORY but not modify it However, when I tested it, users can Add New rows & delete rows. How can I prevent them from doing that but still see the change history?
Create windows folder
Hi, When I create a record, there is a field called job_code. lets use the job code "axg101" For each record I create a folder within windows and call the folder the job code which in this case is "axg101" Is there a script that will automatically create the folder for me and name it whatever is in the job code for that file? Thanks Nigel
view criteria help
I can't figure out the logic to create a view that would show me records that have an ArrivalDate and a DepartureDate that occur on the same date. I need to be able to show Units that where the Guest will depart and another guest will arrive on the same date to the same unit so I can mark them with priority. Example Fieldnames: | ArrivalDate | DepartureDate | UnitNumber| | GuestName Thank very much.
Requirement of Developer Edition (User Edition) in Zoho Accounts.
Dear Zoho Support Team & Developer Community As a Developer, I want to explore my idea in front of you; It is required that Zoho should be start a Developer (user)edition for the Developers, By that way it will be a good support and inspiration for the Developers and also Zoho will be more popular and affordable by the Developers/Enterprises. This same trick is also used by the SalesForce Corp, and today you will be seen that where they are, they have a large community of Developers, and also they
How do I set the value of a check box field
Hi Guys, I have a field Checkbox_1 which has one option call "Yes". How can I set the value of this in script?
USER CAN'T EDIT INVISIBLE FIELD IN A PUBLIC FORM
Hey, I have a public form. Inside this form there are some fields visible and some are invisible. The public only see the visible fields and submit, it's ok. But when my users edit any record, they can't see the invisible fields. I already set the permissions in the view and allowed everything to my users includingthe invisible fields. But it's not working. Help please.. Thanks Mustafa
Upgrade plan & Addon upgrade?
Hi, I have an question but i couldn't find answer. I need to upgrade to have 5000 record. I want to use Add On upgrade but i wonder could i have backup option? Is backup option included for Add on upgrade? KimSonCraft.Com Thanks you!
Set field value to field in a different form
FormA contains a string field (Line1). FormB contains a lookup to FormA (Choose FormA) and a string field (Line2). On success of FormB, I want to use FormB's Line2 as the value of FormA's Line1 For example: FormA's Line1 is null FormB's Line2 is "apple" When I hit FormB's submit, FormA's Line1 is now "apple" I have tried (On Success) FormA.Line1 = input.Line2 which gives me Only SubForm related fields can be updated and FormA[ID == input.Choose_FormA].Line1 = input.Line2 which gives me Improper Statement Error
Zoho Creator funtion Report
Good morning, I am generating a report in Zoho creator and need to create a visualization of certain records by status, status is a Dropdown, how do I make the sum of records by Status? EX: cont ("Status_Orcamento" == "Failed")? And another thing, how do I count the number of records in the view. Ex: Number of requests and requests that is a form. Thanks, sorry I do not speak English.
Automatically match fields in Zoho Creator with Zoho CRM
Hello, I have a table created in Zoho Creator and table in Zoho CRM called "Contacts". Both tables have a field called "company name". I want to import data to Creator from my .xls file and I want to match "company name" field so that it would be possible to click on the name of the company in Creator table and it will open information in Zoho CRM about this company. Now in Zoho Creator table I have the field, which is "Zoho CRM" type. And everything works perfectly as I want, but the problem
Any known issues running Zoho Creator apps on Windows 8 or IE 9?
We developed an application using Zoho Creator. We have over 80 users who regularly access the databases. We have not experienced any problems, but one user who recently purchased a new computer with Windows 8 says that the Zoho apps do not work. She says she is experiencing constant freezes while entering data and slow transition times between pages. Is anyone else experiencing issues running Zoho Creator apps on Windows 8?
Application Settings - Application Custom URL
Hi all, Would you know how the Application Settings - Application Custom URL field can be used? For example I set it to be: demo.mydomain.com? The Application Link field is set to: subdomain.mydomain.com/admin_user/app_name. My DNS provider yells that subdomain.mydomain.com/admin_user/app_name is not a valid domain name. Is there a help page for this settings? Many thanks,
Cannot modify application URL
By default, the application is accessible at a location identified by a URL like: http://creator.zoho.com/[USERNAME]/[APPNAME] Now, the application was created using the above [USERNAME] which is points to a person. We'd really like to share URL that contain our company's name. Here is what we were offered as an alternative: 1. Create a new user, recreate the application using DS EXPORT-IMPORT. 2. Transfer the application along with the data using instruction at: http://kbase.creator.zoho.com/general/publishing-applications-to-another-account
Next URL feature is not working.
When accessed using the URL http://creator.zoho.com/[USERNAME]/[APPNAME], the Next URL upon logging out works absolutely fine. But we've converted the primary account to a domain account, added a sub-domain to point to ZC. So when I use the URL http://[MYSUBDOMAIN].[MYDOMAIN].COM/[USERNAME]/[APPNAME], the Next URL upon logging out is NOT working. -Varun.
Date, Selection or Text from Main Form Fields to SubForm Fields
Hello. I have 1 main form which is unique by date, selection (drop down menu) and the name, in which there are about 5 subforms. How to make so that in Subform the report I saw date, selection and the name of the main form? Now I see only records created in subforms, but I don't know to what date^ group of people (selection) and to what client they concern.
Converting a STRING to a STRINGLIST
I have a STRING that was created from a STRINGLIST, but after the STRINGLIST was reset, I need to go back in and turn the STRING back to the STRINGLIST. Here is my code: input.Extra1 = Extra2.toList(); input.Perm1 = Perm2.toList(); Extra1 is a STRINGLIST Perm1 is a STRINGLIST Extra2 is a STRING Perm2 is a STRING I get the following error: The template variable Extra1 is of type STRINGLIST. But you are trying to update it with an expression of type LIST Any ideas?
Adding text on a form
I need to know how to add text on a form beside the fields. I need to add some text on the begining of a form, when I have to explain something about the form and also I need to add some text below on the form, when a new subcategory of questions will begin. To be more clear I added two pictures when you can see with blue and red the text I need to add. Thank you for your help. Cosmin
Subform Add Row any way to not Add Row based on a condition
Hi in the add row script area of a subform is their a way to "cancel" the add row, say for example the user has entered some data which is the same as the row above, i can see how to alert them using a for each loop but i still cant stop them from adding the row so something like if condition == (don't add row) or if condition delete last row added thanks
html script performance
I've seen several old posts about poor html view performance with complex code. My html view has 1550 lines of code - i suppose that qualifies. The first time the view loads, it takes around 30 seconds. After that, with any change in parameters (it's in an iframe to display data based on dropdown criteria), it's near instant with no performance issues. Any ideas what's going on that first time, and if there's anything I can do to pre-cache it or whatever it's doing? All the posts I found were
Deluge Console
Please, Very ofthen you need to make some queries to calculate, fix or check something in application, make some relinks and so on It will be very useful to have Deluge console - you enter some deluge code (only one line) and get result or make some changes in Application. It's not very comfortable to create every time a new function in script section, run it once and then delete it.
Adding cc to a sendmail
Hi I want to add more than 1 cc to an email. I understand I can use CC : "test@me.com","test1@me.com" but I wish to build up the possibility of having more than one email address from a multiselect of IDs (report_record.EmailCC). If I build up a string... if ( report_record.EmailCC != null ) { cc_contacts = ""; for each contact in report_record.EmailCC { contact_record = Contacts[ID == contact]; cc_contacts = contact_record.EmailAddress + ","; } cc_contacts = cc_contacts.removeLastOccurence(",");
Button: Rename "Update"
With non stateless forms, I know I can change the label for the "Submit" button. How can I rename the label for the "update" button that appears when I try to edit a record?
Doubt Subform
I have a form called Company, within it I have a subform called that has a field Machines Associate Company, if I add machine within the company it appears in the list of the form of machines, if I add more machines in the form of machines and put the Associate Company the machine does not appear in the Company. How to solve this? Thanks and sorry I used google translator, do not speak English.
Matching records which contain any words from the string
A user types the words "Zoho Forums" in as the Client_Name in my form, when they submit the form it looks for a matching record using the following snippet of code: records = Case_Management_Form [Client_Name.contains(input.Client_Name)] This will only find matches when it comes across records which are "zoho forums", how can I get it to find any matches which contain "zoho" OR "forums"?
Creating Relationships
I'm new to Zoho so please bear with me. Here's an example of what I'm trying to do. I have a "Employee Form" where you can add employees and general information about them. I have a "Vacation Form" where I can add vacations. This form is contains a lookup field connected to the name field on the employee form plus fields for start and end dates. I want to have a Report that pulls selected information from both forms. For example employee name, phone, email, and vacations(there could be multiple
Login and/or Sign up to access forms and views
Hi, Within our application users will be required to sign in / create an account. This is for privacy purposes, as well as creating view filters based on the logged in user. When I set a form or view to require a login there is no option to sign up. Also I want the user to be able to log in and end up exactly on the form or view I want them to land on. In other words, if User A is trying to access form A - after he creates his account I dont want him to have to find his way to the form on his own.
Integration of Form in Facebook
I want to integrate my Zoho form in Facebook, How Can I implement it?
fields no updating on bulk update
I don't know if this is a bug, or a feature request. :) I created a form with a date field that I want to update with todays date when the field is created or modified. I used: set Modified = zoho.currentdate; on the "On Add" ->On Load" and "On Edit"->"On Load" actions. When I add or modify, the field updates. When I do a bulk update, however, the date field doesn't update.
Found error in deluge script
HI I am evaluating a ZOHO creator application and stuck here in given code. There are two form: 1)job 2)Service partner once click on link which is at Job form it will go to Services partner form and those job id is appended to url as you can see in given link https://creator.zoho.com/fbriod/copy-of-copy-8-of-job-management/#View:Service_partners_View?Job_ID=1111408000001264149 Problem :Not able to fetch job_id from url please advice Custom Action function Code: void service_partner.JobOffering(Service_partners
global todo list
Hey, Is it possible to do the following..... So I have a record for every job, some records require me to do an additional task but later on. What I want to do is pass the information from some fields in a record into a global todo list. e.g. Fields to pass to Global todo list. Date: 25/7/2013 Task: Phone Mr. Jones and ask when he is free for the meeting. o Click here to add to global todo list ---------------------------------------------------------------------------------------------- Global
Error 12152
Dear Sir/Madam, I am creating a database on Zoho creator which involves scripting different variables to result in an action i.e. if someone selects yes/no, then an e-mail will be sent. However, everytime I try to script, the page says "please wait" for minutes, whereupon it gives an "unknown 12152 error". I am unable to access the script and continue developing the database. I have tried deleting my browsing history/cookies etc. and accessing the database via Firefox but to no avail. I am currently
Application Questions
How do I add new columns to an existing application?
3rd Level related fields for views
Is there a way I can have a view that could pull related fields from a Parent's Parent. I have a Client Form - Submission Form - Submission Details Form. Submission Form is related to Client from via a lookup and submission form related to submission details via subform. It would be nice if I could pull client details from a Submission Details view. Any help would be appreciated.
Application Question
Can I rename an application? If so, how do I do that?
Keyboard shortcut
Is there a way to use a keyboard shortcut to add new line in subform ? Thanks
Next Page