Function Help!
Hi I am making progress with my website and have embedded a view successfully, including an email function that allows you to select a record and send an email. Currently the only email I can get to send is the standard one you configure when building the function. What I need to do is create a function where you can write a personalised message (and attach a file) rather than the standard one. Is this possible? Many Thanks! James
relating date field to a view
i have two forms. one is for adding participants to the database. the other form is for adding "events" that participants have attended, which includes the event name, participant list, and date of event. within "events" there are several types of events to choose from that will be repeated over time, including "tutoring", "lunch meeting", "ski retreat", etc. ideally i would have used a dropdown for this field, however since dropdowns are not available for lookup fields it is simply a single line
Charts issue
Hi, I have an HTML view,where i have created 2 iframes.In the 1st Iframe i have placed one bar chart and in 2nd iframe another bar chart. By using openURL iam trying to access the HTML view in the form.While accessing the application its showing the 2 IFRAMES along with the tabs.But i dont want the tabs.I need only 2 bar charts to display. Please help me out of this.
Bug with subform interaction
Hi, I've found a bug that comes up when I'm pulling data from one subform into another. Please review the two screenshots below. ============================================================================ Case 2: I enter a name in the Child subform It seems like there's an error that occurs in the Event Location On Input function because the row.Debug updates don't work. However, I can't debug the function because Zoho doesn't let me use info commands in OnInput functions. No error messages appear.
Is Zoho Creator Down?
I was working on an App and now creator.zoho.com isn't responding at all.
Hotmail (and other email clients) converting a & to url encoded %26
Hotmail (and other email clients) are converting a & to url encoded %26. This is a problem as I have a couple of variables in my url and once this is emailed to a hotmail account or others this issue happends. Question: Is there any way that I can get zoho (in a stateless form) to recognize the %26 as an & sign? That way I can URLencode and fixe the issue?
calculated field requirement
Hi My database contains amongst other things a table of owners and a table for assets. I would like to be able to create a field in the owners table which adds up the capacity field of those assets and displays that in that owner table. I've looked around but can't see any documentation which explains this. I would also ideally like to be able to pull that information into a third view which is contacts and partially made up from the owner table displaying related fields. Please help Many Thanks
How do I downgrade zoho creator subscription?
I have looked all through the forums for instructions on how to downgrade my subscription. I cannot seem to find any button to return it back to the basic package. Please help.
bgcolor in Creator
Hi, Why is form, made with Creator, having a white bg, not using the bgcolor as set in the external style sheet? Thanks for your help. jm
how can I change the "add +" button in a subform ?
Hello, Is there a way (I guess there is !) to customize the "add + / add new" button in a subform. I need it in french for a public access form. Thanks. When you access the application, the Subform will be displayed within the main form, as shown below. Here, the "Order form" displays the "Items" subform to add the items ordered. You can use the "Add +" or the "Add New" button to add entries to the main form from the subform.
Scripting Problem
I'm having trouble getting a simple Hide/Show script to work. I keep getting this error when I try to enter the script to the "On User Action" section: Error in statement at line number 3 The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not valid here Here is the script I'm using: if(input.projectType=="Print") { show Quant_Print; } Please help.
Chinese interface
I need to used a Chinese UI for my users in China. Can Zoho Creator do this?
Send Mail when Dropdown field is changed
How would I create a script that sends an email when a dropdown of an existing record is changed/updated to a specific option. For example: a database record has a dropdown with three options (a,b,c) when it is changed from option A to option C (and submitted) I would like to send a notification email to a user. But specifically from A to C, not A to B. Is this possible?
Some preliminary set up is required for this task zoho.crm.searchRecordsByPDC
I got this error when i use this line code crmResp = zoho.crm.searchRecordsByPDC(("Accounts"), ("accountid"), input.Cliente); Error details: Error occured while executing on user input script. Some preliminary set up is required for this task zoho.crm.searchRecordsByPDC . Please contact the workspace owner to do any actions on this application . Somebody have a idea?
move database to another administrator account
How can I move a database I set up to another users account?
Formula Field & Aggregate Record (Count)
Are there any plans to allow a formula filed to support the aggregate record function? The use case is a vacation day application. Users can see the number of days they can take and the number of days they have taken (via record aggregation). I'm using an html view to do all this now. Cheers, John Whitney ZOHO Creator Developer
Hoe to create a view showing only "today" records
Hi, I want to create a view showing only "today" records submited. I already tried to create a view with the following criteria set: Criteria : Added_Time == zoho.currentdate But it`s not working (doesn`t show any records) Is it because zoho.currentdate is not the same time zone i`m using (GMT, Lisbon)? If so what can i do to correct this "bug") Thanks in advance, Jose Pedro Alvarez
Can't duplicate this application
I want to duplicate this application but can't . Please help me. Thanks
Can one delete a Zoho Creator application?
Can one delete a Zoho Creator application? If so, how? Larry
Data not populating fields in form
Hello, I am having an issue where data from my stateless form is not populating the fields in the form it is supposed to be INSERT INTO. Please see code below. What is supposed to happen is this. 1. In the STATELESS FORM The user enters data into "input.Lateral_Vibrations_Bin_One" this value should be multiplied by 0.5 then the sum should be loaded into "input.Lateral_Vibrations_Bin_One_Weight" 2. When the user submits the data the value from "input.Lateral_Vibrations_Bin_One_Weight" should then
Creating CRM Task from Creator application
For certain requirements, there may be a need for creating a ZohoCRM task from your Creator applications. This post is about using a Creator form to create a CRM Task. Below is a simple To Do form which creates a CRM Task for each record added. In the above form Client is a CRM Field that refers a Contact Module. Refer this post for including CRM modules in Creator form Below is the code snippet that should be written in the on-Success action of the form to create a CRM Task taskinfo = {
Cannot provide admin rights to my developer
I cannot provide admin rights to my developer. Can someone help? When I go into my application settings I don't have any option to add admin rights. See image attached. Please help as I'm wasting time with my developer and they too are getting pretty frustrated with the lack of access to help build my forms and capability.
Creator client api sort pick list?
Hi, Is there a way to specify a sort type for a select (pick) list using the Zoho Creator Client API? Or have it honor the Zoho Creator form attributes for the field? The default Zoho.writeInput(<fieldName>) sends a case sensitive sorted list which isn't what is displayed when using the form directly. Kind Regards, Carol Hatcher
How do you set the value of a Lookup field in a child form?
I have 2 tables - Sites and Person. I have joined the tables using a Lookup field in Persons which is the ID of the relevant record in the Sites table and displays the Site name and town fields. I need to have a button next to a record in a view of Sites, 'New person', that opens the Persons form with the Site field set to the record ID of the record in the parent Sites table i.e. to add a new person to that site with the site field already set (to make it simple). How do I do this?
How to use Zoho Produts for my site
I m owner of http://www.freecss.in/ ( Free Css templates ) . How can i use zoho products to make my site better
SQL queries in Zoho
I am going to a new job which requires a lot of SQL query skills. Is there a way to learn this in Zoho Creator? If not, how to get started on Deluge Script and programming on the Zoho interface? Thanks.
Links to Zoho CRM
Hi, I am developing a Cretaor App for a client that is to tie into their CRM, I have yet to work on the integration (phase 2) and it may all become cear but my concern is about publishing. The CRM link help implies I need to do the integration work in their own account(s) so it links through to the correct data. Is there no way to link to their data in my dev area and then share to the client via the developer Zone so I can continue the development whilst they use the phase 1 system. Thanks
How to create a new "Activity" in Zoho CRM using a Creator form?
I have just built my first lead capture form in Creator. I have installed the Creator app inside Zoho CRM as a web tab, and it works perfectly. A new record in Creator becomes a New Lead in the CRM's Leads module. However, I now realize that I want to create a new task related to that new lead, on the same Creator form. (A task might be "send brochure", or "Call Tuesday"). I want that task to show up on the new Lead's record as a related "activity" inside Zoho CRM, assigned to a user, and with
Usage Limit Error
Usage Limit Error A critical problem has occurred and is stopping our application from adding records. ZC is reporting the incorrect amount of records used S.No. Particulars Your quota Used Remaining 1 Records Count 25,000 44,806 -19,806 The reported error is 'Usage Limit reached" So I purchased another 5000 records just in case, but it is still not working. Please fix this immediately Mark
SQL queries in Zoho
I am going to a new job which requires a lot of SQL query skills. Is there a way to learn this in Zoho Creator? If not, how to get started on Deluge Script and programming on the Zoho interface? Thanks.
Set the view group back color?
Would love to be able to change the default back color for group rows from the default yellow (list view with a group set). Looking through https://help.creator.zoho.com/Style-based-URLs-for-Embedded-Forms.html#6._View_Customization there doesn't seem to be a parameter for it?
Sendmail not working with anonymous users
I've setup sendmail to email the person completing the form. The form is for leads so the people submitting the form won't be logged into zoho. Unfortunately, the sendmail function doesn't work and I've tried making the application public with no success. Ironically, other deluge scripts work (e.g., validate fields) but not the sendmail. Any thoughts? Thanks in advance.
Very slow today
Users complaining zoho is unusable today. I agree. What's up zoho?
Form Schedule Filter not working?
Hi, I'm having trouble setting up my Form Schedule in Zoho Creator. Situation I add assignments to my employees trough the system. The employees have to make an appointment with our customer. The appointment date is then saved in the assignment row (called Afspraak, Dutch for appointment), to keep track of 'open' assignments. Afspraak is a datetime field. The emloyees are expected to to this in 24 hours after the creation date of the assignment, but sometimes it takes up to 48 hours or even more.
How to export to App Engine?
Hello, I created an account on ZOHO to use the AppEngine export feature. But I cannot find the option to export the app. Where is it, or is it not available anymore... Yvan
How long dose it take
I have requested public access for my data base as i need it for my website, the website is completely point less with out the database and this will be so much better then the previous way my website operated! so due to the fact that my site is under construction wile im trying to get public access approved. about how long dose it take usually for free users to get this approved ??
Div & Iframe Problem
Hi, Iam not able to increse the width and height of the DIV & IFRAME. If i apply also,Its not reflecting while accessing the application. Please help me out of this.
Form Divide Line
Hi, Is there a way to put a dividing line through a form? Sort of like making different subjects in one form. I appreciate your help!
Edit a sub-form
Hello, I have a main form that includes a sub-form (one-to-many relationships) where the main/parent form has one or more records of the sub-form. When I created the main form view, I set the options to be able to edit, view, etc. When running the app, I go to the main form view and want to edit one of the records that I created (which also includes multiple records in the sub-form field), I discovered that I am not able to navigate to one of the sub-form records so that I can edit it as well while
What's the easiest way to duplicate a form?
I would like to duplicate a form I have created and then make small changes to that form. I see that I can create a new form based off of ZOHO templates but I would really like to base it off of the form I've already created. I would also like to be able to copy forms from one application to another. Please let me know if this is possible. If not, please consider this functionality for future ZOHO development. Thanks!
Next Page