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
RegEx for Numbers
This script should report "good" but is failing. I need a function that tests if a string starts with a number. string test() { street = "12 yadda"; if (!(street.matches("^\d+"))) { yo = "bad"; } else { yo = "good"; } return yo; } Ref: http://stackoverflow.com/questions/6372318/c-sharp-string-starts-with-a-number-regex Cheers, John Whitney
subforms
We are determining whether to use zoho. One of the features we are looking at is the subform creation. When trying out the subforms in the free version it says our current plan only allows a demo of the subform. Could you please tell me which of the zoho plans include the subform capabilities? I don't want to make a mistake when upgrading. Thank you.
Script stops working, can't make changes
Hi, I have set up a lightweight learning management system for an educational initiative. In the attendance form, there is script in the On User Input block of one of the fields, that automatically populates several other fields with data when called. This has been working fine for several months, but this morning the script seems to suddenly have stopped working and fields are no longer automatically populated. I can't think of anything that could have triggered this as I haven't made any changes
data-clear-btn= true not working
Hi Can someone please help as to why the clear button is not showing up for this input text ? <input class="text-box single-line ui-input-text ui-body-c ui-corner-all ui-mini" id="searchInfo" name="searchInfo" type="text" value="" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false" data-min="true" data-clear-btn="true"> Many Thanks festiva_96
scripts for multiple select has stopped working
As i have seen reported. all of my scripts that need to fetch date and populate a multiselect field DO NOT WORK and have caused some forms to go INVISIBLE. of course ZERO response from zoho. PLEASE ZOHO HELP. PLEASE
image in RTF
Is it possible to paste an image in a Rich Text Field? Herb Wexler
Many to Many Relationships
Hi there, I am trying to create a database with a many-to-many relationship. Specifically, I am creating a database for a children's project, where each child is being mentored by a person. At the same time, each mentor has a number of children under their wings. The idea of a many-to-many relationship is that there are 3 tables: 1. Mentor Name 2. Child Name 3. Mentor/Child Link Table I have created tables 1 and 2. How do I go about implementing the 3rd table? And also: how do I then create a view
Secondary header on Mobile
Hi, I found a good tip in the forums saying that in order to be able to view more than 5 entries in the view on mobile - I should Embed the view in an HTML view. It worked great but the problem is that the secondary header is not big enough so that my Pagination buttons are hidden. (I added a picture) Any way to solve this? Increasing the height of the secondary header? Thanks, Guy
Parse data uploaded from File Upload field
Say I put a file upload field in my form where my users upload an excel file. How do I parse the file data? I would like the data to be uploaded on Zoho Reports but I can't directly upload the file because I have to process the data first like separating a text, replacing a specific text inside the excel file, format the texts inside excel and so on, before uploading it to Zoho Reports. Just in case you were wondering why can't we just format the excel file before uploading, we want it automated
Next Page