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!
How to set master transaction relation ship
I created a dept master with only one dept_name field. I want to create a list and it should appear in employee master in a dropdown list box what ever i added in dept master. Please help me in this regard. I am very new to Zoho
No reply to "Hire an Expert"
Hi, I have a project which may interest an expert and so from the Zoho Creator, "Hire an Expert" link, filled out the form and duly sent it off, waiting for my reply within 2 business days, as advertised. 2 business days later, I'm still waiting and although I'll be patient considering the potential time differences involved, I do wonder whether I haven't had a reply because of condition 1 : "Your requirement is not possible". If I don't get a reply because my requirement is not possible, how on
RSS feed displaying data under wrong header
I created two RSS feeds from a database. Both seem to be displaying the info incorrectly in the feed, although if you click through to see the original, everything is in the right place. Here's the link for the feed: RSS feed Everything from "cat's age" on down is displaying the data under the wrong heading. Is this just a glitch, or can I fix it somehow?
Need to get IFrame in zoho form.
Hi, How to Get IFrame in Zoho Form.(Not in HTML view)
Related Record ID
I have a subform (Fulfillment Activities) which is related to a parent form (Service Orders). I want to create a functional URL that lets me open a subform view and only display the records related to the parent. For further explanation: https://creator.zoho.com/cvanputten.contactpoint/pro-services-ams/#View:Fulfillment_Activities?ID=660708000000316925 will retrieve records for this form based on the record ID of the subform record. However I want to substitute ID for whatever the field name is that
Payment page
I need to create a web page where an item is selling for $1; my customer can purchase any number of units to make a payment to me via credit card. I have a merchant account and credit card payment gateway..... how can this be setup?
Stateless form: issue with lookup fields
I tried creating some stateless form. The issue with this kind of form is... the lookup fields can't be assigned a default value. ....or can I do something to rectify this?? please let me know. thanks gurus!!!
Creating a Relational Database in Creator
For sometime now I have been researching the most appropriate tool to develop a Relational Database from the ground up. No imports, no legacies. It would appear that both ZOHO Creator and CRM will be able to do the job but I am looking for some reassurance that the tool that I finally select is the one best suited to the job. First things first. I am not a programmer. I run a small Personal Financial Advice business and I am looking to create a database that will allow me to store and access all
CAPTCHA Error
In the last week, I've see this error a few times. Cheers, John Whitney ZOHO Creator Developer
please help me
sir i am using zoho creator. i am try to fetch weather report values in my database using xml executexpath but i cant fetch the values it shows error while executing.i attached my xml code. plz help me.........
Create a Form
Can any one help me how to create form.With separate column names .I need help on this ...
Scheduling tasks
I organise my work with tasks. Scheduling them is important for me. If I would like to schedule an existing task for tomorrow, I have to work with the calendar function. Wouldn't it be great if there will be a possibility? a) + (schedule the task for the next day) b) ++ (schedule the task in two days) c) w (schedule the task in one week) d) ww (schedule the task in two weeks)
Reports in Creator -No Value-
How can I get the report within Creator to display without the -No Value- showing in the report?
scoring a simple questionnaire
greetings, I am new to zoho creator. I am trying to create a simple questionnaire where I will be able to have a few questions that need to be added up to give a final score. Each question will have a few answers using the radio buttons field and each answer will need to have a numerical value assigned to it. It seems that we cannot assign numerical values to each radio button option. Is there a way to do such a thing? I just want to add up the answers and get a final score. And I want my users
Scheduled Data Export Backup Script
is there a way to write a script that will export your all of the data from an app. as an excel file and email it to you on a weekly/daily schedule? if not, then i guess this would be a feature request. BTW, Zoho Creator is one of the best things i've seen on the net in a quite a while. I never thought i'd be able to create some of these apps without hiring a programmer. thanks Steve
Next Page