Documents management
I sometimes attached multiple documents to a main record. Can Zoho develop a way for me to download multiple attachments in a single package, like a Zipped file, like Gmail is doing? Thanks.
Email Confirmation Link
Hello, I need to create a simple email address verification system, as you see on many websites when you create a new account. I want to send out an email to a user which will authenticate their email address. The email would contain a link, which when clicked, would toggle a field in our database confirming that the user has clicked the link and is using a valid email account. For example, a new user signs up and enters their email address in a form. The user then receives an email saying, "Thank
URGENT - My forms no longer submit
Since your update this morning my customers (and me) are reporting that we can no longer submit forms for our quotes and booking system ... disaster ... please roll back immediately. Mark Australia
ZOho creator form not loading
Dear Team I m sure since when my application forms has stopped working. In fact, most of the forms on the on ZC page are not working (even submit support form ) are even missing. When trying from IE getting the following error: "'ZCTemplate' is undefined" & "ZCApp is not defined" Thank you for quick reply
can i use a upload file in a stateless form?
i need to show a stateless form, where the user will insert 1 ou 2 files, then i need update the register in form, this is possible?
Last 'if' condition does not output to field
Does anyone know whats wrong with this statement. the problem is that the last output value in red (1025) in this multiple 'if' statement does not register in the field 'Forcast' All the others work fine...is it possibly that i am not closing the statement correctly? Thanks for any help with this, its driving me nuts..! if (input.Lookup_1 == "Full Full") { input.Forcast = 895; } else if (input.Lookup_1 == "Part Part") { input.Forcast = 790; } else if (input.Lookup_1 == "Full Upper")
Synchronizing Zoho Creator and Gmail directly?
Hi, I was wondering if there is a way to sync zoho creator with Google directly, without using CRM? I have a list of contacts in a creator app and I just want to sync these up with my Google Apps account, but I don't really have the need to implement CRM in this case. Has anyone done this, or know of any third party apps that will let you do it? Cheers, Ryan.
Form Action On Edit Validate should Update Record or Add Record Work
Hi Think my code is ok but i cant seem to Update a Record in another form (Collection Variable has been formed) or Add a Record to another form When I execute these script commands in an On Edit Validate form Action Should these script command work here ? Thanks
Adding Google Calendar Events stopped working with new UI
I was successfully adding Google Calendar events until forced to use the upgraded UI. Any ideas what changed?
Export Records to Local Computer
I have form that I plan to use where the form will be filled out and a receipt is attached to the record. I know this database will grow fast and I am wondering if there is a way to export the records to a different program that I could store on our company's servers. I know I can export records to excel then upload to different program but the receipt attachment will not be attached anymore. I guess I am wondering if there is a way to export the records along with the receipt attachment and store
Assign a list to a dropdown ?
In a form I have -a text field (for example: "apple, orange, cherries"). and -a dropdown with 3 values (1, 2, 3) Now, I convert the text into a list and I want to assign the values of to the list to the dropdown. ("apple" instead of 1, "orange" instead of 2...) Is it possible? Or dropdown accepts as values only those of a form or the default definition?
Visitor Count
Any way to show a Visitor Count ? How many people have visited the database ?
Attach Google Doc using Deluge
Is it possible to attach a Google doc (The long URL) using Deluge? Regards
One or more fields were dynamically changed / Disabling Enter Submit
Similar questions been asked several times before, but can't seem to find a solution. Is there a way of disabling "enter" from triggering form submit? Yes, using tab to swap between fields and enter to submit is logical to experienced users, but to the average end user it can be confusing, especially since it causes the following error in the app II'm developing. I have a field with an on User Input script section that updates picklists and hides/shows other fields. If the user updates this field
using reports: dropdown field is available but only shows 2 of the 6 options
hi, i am making a simple report based on my main view, and in the filters section i am able to filter by a dropdown field, however it only shows 2 of the 6 options: in my case, the options are: - yes - no - n/a - don't know - graduated - previously enrolled but the report builder is only allowing me to filter by these values: - yes - no - don't know in other testing i have found that the report builder often limits and seems to edit the values from a field when trying to filter. can you help me
openurl while passing a parameter on a mobile view seems to fail
Hi, To emulate search, I have an html view with stateless form that when submitted its open the same location url while amending an id. This works fine on the web view. However when going to the same place while creator.zoho.com/m the parameter is not read/passed. It remains null. Any clue how to resolve this please? Regards, Idan
Deluge Script Advice Request
Hello. this is my first time trying to create a script and I need a little help. I have a "parts" view and a "add parts" form. The "parts view" is already populated with data. One of the fields in this view is "part number". Upon load I would like the "part number" field in the form to be automatically populated with the next sequential number available from the "part number" field in the view, lets say 06200. I would also like it to be display only. Any advice is appreciated.
Count function for Date within subform
I have a time sheet application that I have made, and I need a little help with the final feature I would like to add. See the attached image before reading, in order to give you a better understanding as to my need. On the load of the parent form, 7 rows load on the subform (one for each day of the week). Currently when the parent form loads, each row in the "Day of the week" field is labeled with the respective day of the week (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday) What
Problem with dynamic picklist
Hi, Here's my problem. I have an app with a subform containing 3 picklists. The user chooses an option from picklist 1 and I match the criteria to a table to populate picklist 2 using on user input script of picklist 1, if there is only one matching record then picklist 2 is automatically updated with that record (to save the user from having to select it). I then use the combined criteria from picklist 1 and picklist 2 to search for matching records to populate picklist 3. This all works fine. However,
changed domin name
the domian i selected isn't working, so i want to switch back to the domian given by you..how to do it?
Automaticly Share a newly created View
Hi, Is there a way to automatically share a view upon creation?
Need help with uploading an image and re size it.
Hi, I have this form that uploads images, and in the View, becouse all the images are different size, I want that in the View, they will be re sized to width="200px", something like this. Is there any solution, need some help here, thanks, much
How made the background color as transparent for embedded form in HTML view？
Hi How made the background color as transparent for embedded form in HTML view？ and then take the view insert to website. Thanks Stanley GUo 2012-12-21
URL field and passed parameters
I want to include a hyperlink in the body of a form that says Click Here . Clicking will take the user to one of two zoho forms. Which one will depend on other information in the main form. I want to include the record ID of the original form in the information sent to the second form. Is this possible? Should I use a URL field or put the information in a Note field? Herb Wexler
Filtering Lists
I've posted on this topic in the past, and now most post again since I'm running into the dreaded "deluge statement execution limit exceeded the maximum limit". The records in my application contain a list. What I'm trying to do is count all the records that match values to another list. It's best to illustrate this, as lists can be confusing. Here are some records and their lists. A (a,b,c,d) B (b,c,f,g) C (a,f,z) D (a,b,z) Count the number of records that contain either a or z. It's 3. In deluge,
Creator offline
Hello Is it possible to have an offline - like Gears on other apps - that could work with Zoho Creator? Thank you Hugo
How to Control Users Permission and Their Log Activities
Hi there I have two important needs 1. I would like to make User Permissions to one or the whole forms and views as follow : - 1 or 2 users as the admins - some users can ADD only - some users can ADD and EDIT - etc How can I do this ? 2. Is there any Automatic User Log Activities or should it be created over script ? If Over Script, can you inform me the steps ? Thank you and regards
Modify checkbox labels through Deluge scripting
In my form, my users can indicate if a requested change is for an entire week or for specific days. If they choose specific days, I have it display a checkbox field that allows them to specify which days. However, I'd like it to dynamically change the labels based on a date they chose earlier. So, for example, if they pick 10/8/2012 from the date field, the specific days should be: Monday (10/8/2012) Tuesday (10/9/2012) Wednesday (10/10/2012) etc etc. Is there any way to do this through deluge scripting?
Importing Parent records with Subform record HELP!!
I was hoping someone could explain where I'm going wrong. I have an excel file with 2 tabs relating to parent and subform. 1) "my Parent record" (named exactly the view name) With an added column with the Subform field name with records = 1 2 3 4 etc 2) "my subform record" (" ") with added column with REC ID linking relating to above 1, 2, 3, 4 etc I then go to creator then to the parent view - more settings, import excel with subform data enabled I can see both sheets on the import
How to get deluge script criteria to show the correct records in a view
I'm pretty new to zoho and deluge scripting. I have tried to do this thing that seems straightforward, but it is not working. I have a membership form and a payments received form. Members pay dues each year. I want two views: one that shows who paid dues for 2012-2013 and one that shows who did not pay dues for 2012-2013. My deluge criteria for the NOT PAID view is: show all rows from Payments [Year_Dues_Paid_For != "2012-2013"] This fails because if people paid in other years, they show up
Schedule limit
Hi - I created 10 schedules. Some are form schedules and some are custom schedules (automatic emails). I realized that they suddenly stopped working. I believe that the issue is due the limit. Does the 31 schedule limit refers to number of scheduled that are set up? Or the number of actual occurrences within 24hrs? If this 31 limit refers to the occurrences within 24hrs, can you please increase it to about 300 for my application? We planned between 100 to 300 occurrences every night. They are
For lookup list widgets, there is a built-in function that provides the record ID of the item selected in the list ?
Hi. A lookup-picklist displays a list of names to choose from. I want to know the record ID# of the selected item. Say, formA and formB. In formB there is a lookup field that import data from formA. After selection, i need to know the item's ID, cause i need to fetch from formA the value of the item (eg. ID 1, value "pippo", i need to fetch "pippo") and copy in a text field in formB. i.ve tried with: var = formB [ID == lookupfield.ID], but it's wrong. Please see this message: https://help.zoho.com/portal/en/community/topic/how-to-get-the-correct-record-id-from-a-selection-in-a-picklist-where-there-are-multiple-records-with-the-same-criteria%3f
Getting values from Zoho Invoice in a Formula Field - NOT WORKING
Here is what I have: A formula field on the form that calls a function, The function accepts the ID field of the form as the parameter. The function makes a call to Zoho Invoice Get Invoice Item API (https://invoice.zoho.com/api/items/) The function works perfectly when tested independently for the same ID values that the formula field would have passed in. However, the view on this form which has this formula field as a column, does not display any value. Regards Moiz Tankiwala Smart Training &
Conditional fields
Hi, I have a question about creating forms I'm willig to have an application that gonna contains many froms, one form is going to contain some versions, and in the other form I should display this versions, added in the first form, as a dropdown field. is it possible to do so? And, I'd like to have conditional fields, for example a field is not shown till another field is well filled Kind regards
Automation API that facilitates import of Zoho CRM Accounts into Zoho Invoice
I need Zoho CRM and Zoho Invoice working in an integrated fashion. My requirement is custom and needs to be built on top of the integration already offered by ZOHO (Zoho Accounts import into Zoho Invoice via ZSC key and display of invoice within Zoho CRM). Moreover there is a custom payment gateway implementation that I have for payment collection for my invoices. Zoho CRM only recognizes invoices of customers that have been imported in Zoho Invoice from Zoho CRM via the ZSC Key. Because of the custom
No way to find my pictures
I made some tests, containing a few pictures. Now, when my students make the test, they don't see the pictures anymore. What's going wrong?
Registration form or log-on
I embedded a registration form into my web site, but some users are reporting getting a log-on field rather than the form. The log on will accept my log-on info and go diectly to the form. lesli.adler
Alternating table row colors in HTML View?
Hello, I could use some help. I have an HTML view of meetings searched by country and city. Some of the queries will return dozens of records, and the table being all one color makes viewing the records confusing. I would like to alternate the colors of the even and odd table rows but I can't find anything to help me in doing this. I have found this link where the rows are exactly as I would like mine to be: https://creator.zoho.com/sharipriya/testing-criteria/view-embed/Testing_View/zc_HdrClr=green&zc_BdrClr=lime
Display CRM data as text
I have selected a sales order from the CRM in custom app using Creator and I want to display the details of the products ordered in the sales order as text or ideally each item as a checkbox. Thoughts?
Where form results open
My form results are opening on top of the form itself and I am not taken to the next URL. My form is at http://jaxareagolfassn.com/Championships/2012/ClubChampionship/2012ClubChampEntryForm.html but I want the user to be taken to http://jaxareagolfassn.com/Championships/2012/ClubChampionship/ClubChampReservations.htm. What am I doing wrong? Thanks, Barney
Next Page