If Condition
Hi! Need help on this please: I have the following fields: 1. Property_address1 2. Auction_Venue (dropdown) with following choices: On-Line, On-Site, Live But Off-Site 3. Auction_address1 This is what I want to achieve: If Auction_Venue is On-Line, Auction_address1 = "Online Only" But if Auction_Venue is On-Site, Auction_address1 = Property_address1 And if Auction_Venue is Live But Off-site, user must enter a specific address. Please help me with the script. THANK YOU so very much! Regards, Queenie
“amp; ”perhaps this is a bug?
Hi When re-editing function, the code will be auto add "amp;" If you do not remove the "amp;" the function will run an error or loss of data, perhaps this is a bug? void ht.open_htdz(string htbh, string cjmc, float htje, string xmmc) openUrl("#Form:formhtdz?htbh=" + input.htbh + "&cjmc=" + input.cjmc + "&htje=" + input.htje + "&xmmc=" + input.xmmc, "Popup window", "height=100,width=100"); Need your help and thanks Stanley Guo 2011-8-11
Schedule not sending out at the stipulated time
Hi, I have a schedule that is supposed to send out birthday wish email to my members on the actual birthday @ 00:00 hr. However, I noticed the email will only be send out at 11pm, 23 hour after the actual stipulated timing. Please look into the matter. My time zone is Singapore.
Date Format
Hi! Currently, zoho creator's date format of DD-MMM-YYY will show something like this: 30-August-2011. Is it possible for me to change it to something like this: 30/08/11? If indeed possible, please let me know how. Thank you so very much! Regards, Queenie
Can you limit entries to a form from specific email domains?
Sorry, I am new to scripting. In my form, I ask that the user provide their email address. I would like to limit submissions to the form to only persons with a specific email address ex: name@univ.edu. Is there a way to do this?
Another Example of RegEx
I wanted to count the number of words typed in the rich text field to limit the amount of text users can type. Using regular expressions and a list, these three lines of code will do the trick. Note that input.BODY is the rich text form field name. body_text = (input.BODY).replaceAll(("<(.|\n)+?>"),""); body_text = (body_text).replaceAll(" ",""); body_words = body_text.toList(" ").size(); alert(body_words); Originally, I tried to count the occurance of strings using RegEx, but this currently
Latest additions to Zoho Creator
If you've been using Zoho Creator regularly, you would have noticed that enhancements and new feature additions are constantly happening. Our recent update contains some noteworthy new additions that we are sure you'd love to use. 1. Accept Payments and Donations - Introducing the Payment Module 2. Share seamlessly within your organization - Organization Level Sharing 3. Import Google Forms 4. Sharing Interface makeover For more details, do take a read.
Setting criteria
I want to create a simple view wherein only records wherein a date field is blank are shown. What is the proper syntax? Also, when I choose a criteria like "equals tomorrow", it doesn't seem to save the criteria. What is the proper syntax? Thanks
limit users from viewing fields while editing form
Hi I am new to zoho creator and using a free subscription while still trying to figure out if this can really help us with our needs. Here is my first question so far: situation: I created 3 different views for an application intended for 3 different groups of users. This is mainly to let each user group see only the fields that they need to see. It works well so far. The spreadsheets show only what needs to be shown and when one clicks on "views" he sees only the necessary fields. However when a
linking forms/views, and adding documents?
Hi there! My company is using Zoho Creator to create a searchable database of market research vendors. Using a combination of forms and views, we've created a great source for searching for/adding vendors, their points of contacts, and user reviews on the vendors. The team had a request I haven't been able to figure out, and I'm wondering if it's possible. Is there a way to link the views together? E.g., the user would look up a vendor, and would see the points of contact and average 1-5 scale rating
My Apps don't show up on Home page
When I try to duplicate an app I've already created, it doesn't show up on my Home page with the other apps. Instead, I am taken to a different screen that looks like Home -> My Apps. That's the only place I can access the copied apps, so in order to get back to it, I have to duplicate one of the apps that shows up on my home page. Is there a setting I am missing?
How to use the same contact form with different websites passing some conditions or identifier?
Dear zCreator team, I have one contact form designed for my personal website with the help of Zoho Creator. I am actually looking out for the following. How can I use the same form for my other websites and/or blogs. However I want to pass some identifier from the website or blog for a unique identification. Also can the notification from different website be configured dynamically (like through a hidden field)? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Zoho Creator IFRAME embed passes big strings in GET requests
Dear zCreator team, I have a simple contact form designed in Zoho Creator to embed in my personal website. I observed that the IFRAME URL passes even the success message as a querystring. Can we a simple request and use a POST method instead of GET please? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
How to hide my username in IFRAME Embed URL of zCreator?
Dear zCreator Team, Currently I observe that when I embed my Zoho Creation in an IFRAME it shows my username in the URL. Is there a way we can hide the URL please? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
updating balances from one record to another with same ID?
How can I get a balance from one record to transfer to a new record of the same person? Example: I have a client that has made a payment to his account on Monday. On friday, this same client wants to make another payment. I am using HTML so that I can see each record individually
Why "&&" turns to be "&&"
Hello, Every time I open the scripts in Functions, I see "&&" are replaced with "&&". But if I save the script, "&&" cannot be accepted; so I have to change "&&" back to "&&". However, if I reopen the script, it's still "&&". In addition, if " " is involved, the script may give like this: "&amp;nbsp;". Previously it functioned OK so I wonder whether it's a new bug. Thanks!
Deleted data from form is still showing up in reports
I deleted several records from the "iControl Release Detail" form within my application "iControl Partner Device Certification". For some reason, these records still appear in the report "iControl Release Detail", but I cannot view them in the View of this same form. Can you please delete these records permanently from this form? Thanks!
The && converts to & ;
This issue started few days ago everytime I save a page and come back to it i find all the & characters converted into & ; For example r = Add_Material [(Category = input.Category && Name != "")] sort by Category ; would become r = Add_Material [(Category = input.Category && Name != "")] sort by Category ; and what is worse if i make any changes to the page with the & ; i cant save it, i have to change it all back to & to save it! Any help please
Calender view stuck on a month and year
We are using a calender for booking but we can not change moth or year in calenderview. How can this be solved?
How to change a requester's email ID?
Is there a way to change a requester's email ID? We created some test requesters using names of clients, but our own email addresses. I tried to change it, but the email ID field is inaccessible when I am in the edit screen. Do I have to delete the requester and recreate it using the actual email address?
Blocking access to shared applications for users who have not confirmed their email addresses
Hi, Confirmation of your email is mandatory for every Zoho account. Zoho Creator will be blocking access shortly to shared applications for users who have not confirmed their email addresses. To confirm your account, please click on the link in the confirmation mail that you would have received while signing up with Zoho. If you have not received the confirmation mail, you can resend your confirmation mail as follows, * Log in into your account and access https://accounts.zoho.com/u/h#profile/email
Custom schedule on every 5 minutes
Hello, i try to create a custom schedule that runs every 5 minutes daily which is described in this post : Can I lock a record that is being edited, and restrict more than one user from editing the same record at the same time? How can i do this ? I get always errors when i try to create the "execute event"-statement. I found nothing in the help section. Thanks in advance. Horst
Where is the button to create an application?
What a frustrating user experience at Zoho Creator. The form I used to report my initial issue crashed and asked me to fill up another form to report the crash. The new form doesn't work either. I'll keep it short this time because my longer message I tried to submit earlier is lost now. Issue 1: I can't see the button to create a new application on my ZOHO Creator homepage. Issue 2: I can't insert images in your HTML WYSIWYG editor. I just wanted to show you the screenshot of my ZOHO Creator homepage.
Using Google Analytics w/Zoho Creator
Can anybody tell me how i can use Google Analytics to track activity for a Zoho database; Specifically, where do I place the tracking code?
Can not update VISA information???
Hi, Our products(Creator) goes to be expired, In this case we can not revise the VISA information when we deside to update the product edition in China. We want to make a payment,but It is blank! Why?? Urgent!!! Doug
Creating a professional-looking PDF catalog from an HTML view
Hello there! I am currently experimenting with the PDF exportation of an HTML view I created. I would like this PDF export file to look as 'professional' as possible, meaning I would like to be able to print it out or mail it to clients 'out of the box'. This html view displays the result from a search query within the records stored in my form: it shows a list of project references, each one complete with a couple pictures, and a definite set of information. Right now, I am still encountering some
Express Editions
Interesting... John M. Whitney
Allowing customers access to read only databases
Hi Please see below, can Zoho Creator do this and what version would cater for it. Also which version would we have to buy while we only have 5 customers One of my web design clients wants to give their customers the ability to log on and view a specific access database in a read only format. They currently have 5 clients that they want to do this for with plans for this to expand to 20 in the coming year. The databases are large up to 1 gb including associated folders . Obviously each client is
Question About Functionality
Hello, My company would like to implement the following idea and I wanted to see if your platform is built for it. The idea: Friday Focus. What it is: A tool that forces people to start thinking about what they need/want to accomplish the following week. Every Friday people spend a few minutes filling out an online form, and on the following Monday morning they receive a copy of it in their inbox. This helps kickstart the week. How we want it to work: - Every Friday an email goes out reminding the
How can you remove only certain items from a dynamic picklist?
Hi, this is driving me nuts and I'm wondering if someone can help me figure out how to make this work. I'm a newbie to Deluge and Zoho. I belong to an organization that provides teams of mentors to mentees. I've created an application with the following forms: Contacts - where the Role can be defined as a Mentor, Mentee or several other fields Mentorship Teams - where you can associate contacts based on their role on the team Mentorship Team Meetings - where we track who attended and what happened
Customize Forms
Hello, How can I customize the following form? https://creator.zoho.com/gnachtwey/friday-focus-application/# I would like to add my company logo to it and adjust some of the spacing. Is this possible to do?
Zoho Creator is DOWN
Can fellow users confirm with me that their Creator applications are down right now? Thanks!
How to delete a Form and a View
Hi guys, The title says it all actually. I have one application that contains two Forms and two Views. I wish to delete only one of the forms and ones of the views. Thanks
Order management
Hello! We have online store and I need online management software. I know that it is possible to do but all solutions are very simple. I need to: 1. make a new order 2. attach new or existing customer 3. add MULTIPLE goods to one order, NOT ONE. There is no problem to add one good to order. How could I add multiple goods to one order? There is lookup form but it's not convenient to manage and edit orders. Are there any ideas or solutions? Zoho CRM is very complicated, Zoho Creator should solve
Referencing a formula field from another formula field
I am new to Zoho, and building my first app to calculate sales commissions. I understand from other posts and the user guide that you can't reference a formula field in another formula field. However, I need a way to do the following, which I'm sure there is a script or other work-around to do: Revenue (Currency Field) Overhead % (Percent Field) Overhead Rate (Formula Field) = Revenue * Overhead % All of the above works fine. However, I can't figure out how to do the following: Net Margin = Revenue
Internet Explorer 9 support
ZC Team, Internet Explorer 9 was launched a few months ago and it is already delivered to Windows Vista and Windows 7 users by OS automatic updates. Have you plans to include it soon in the list of supported browsers? Regards, George
HTML view has lost all formatting.
I have created a couple of HTML views, which display as brochures, with the required property information as entered into my database. Everything was working correctly, until an hour ago, and now the CSS formatting which was being applied appears to be ignored, and all elements are simply listed one after the other on the page, in plain text. Here is the link to the view: https://creator.zoho.com/4732209/propertyprosperity/view-perma/Standard_Brochure/PyRNmxShbOzrD941hzp2uYY4YqASNa0Jy6COSTdAVhuQq9OmC3bddFTzAB3176VZSsCRxGzdmOYg3SqhWgSOV8KP5dCvEksDvCUC/?recID=623880000001192015
Can the Add/Edit form for a View be made to contain only the fields in that view?
I had assumed that, when I have a view with a subset of the fields in the main view, the Add/Edit form would only show the fields in that subset. That does not seem to be the case. Is there a way to make this work?
Dynamic Picklist - retaining field values on edit/update
Zoho Support, I am using dynamic picklists in an application and adding records works as advertised. When editing the record, however, I am using an "on load" script to re-populate the picklist values. This re-load of the picklist values is causing the original entry to be removed. Is there a way to keep the original field value intact, while re-loading the picklist with new values?
Send email task with embed HTML view
Hi, I create a html view in Creator. I would like to embed this html view in message field of sendmail task. The embed url is a Functional-based URL. I try to put iFrame code in the message field, and the html can display in the message box, however, after send the email to my mailbox, I can't see it in Gmail or Outlook. How can I embed the html view in sendmail task? The url look like this https://creator.zoho.com/123/salesforce/view-embed/Enhtml/JjZSkMMXHUVmSwWjvHRNf6n6/code=123 Thank you.
Next Page