Importing a csv file. Matching records and updating fields.
Hi, I have a 'Contacts' Form in Creator from which I export the following CSV file to email marketing software. Export File: ID,Title,Name,Email It returns a report after the marketing is done in the form, Email,Date,Status as below. example1@gmail.co.uk 2012-12-17 22:47:00 Email opened example2@tiscali.co.uk 2012-12-17 23:47:07 Email opened example3@btinternet.com 2012-12-18 21:18:26 Email opened example4@btinternet.com 2012-12-19 12:06:50 Email opened example4@btinternet.com 2012-12-19 15:34:21
Criteria
I am not a programmer and would appreciate some help. I have built an app to control the rental of vehicles. I need to ensure that I do not duplicate the hiring out of a particular vehicle. I need to search the database and if a vehicle is already rented out, someone entering data must be prevented from hiring out the vehicle again. How can one achieve this? Derek
Shared Users - Access to Print Reports
I have shared one of my apps with several users in my office. I have built reports for them to use, but the system does not allow them to download to CSV and print. They have full access to all reports and views. Any ideas why they don't have the CSV download function after they run the report?
how to delete a "field" in form definition?
hi i have created some fields in a form, and now i have to delte a field from by using form definition script,i know how to delete visually, i want to delete a form field in field definition.
gmail
hi can i make all gmail users send mail to add new row to the database ?????????
Problem: View not being displayed
I get the following error message when I attempt to view a view. How can I see the data? We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com
Send views if new data
I currently have two schedules that periodically send views as spreadsheets to me. I'd really rather them only send when I have new data. My idea is to have a table that keeps track of the last maximum record ID and if the current maximum record ID is higher, send the views as spreadsheets. Is this possible? Ideally, I'd have it done as part of the success event, but it says that file attachment is only applicable to scheduler actions. Thanks, Carl
Based on dropdown selection,how to show and hide the "Add Note".
Based on dropdown selection,how to show and hide the "Add Note". Iam able to do the thing like,On form Load event iam hiding all the "Add Notes". But once i will select some value form dropdown based on selected value i have to show the selected value "Add Note".(This iam not able to do).For example,i have 4 "Add Notes".On form load iamhiding all the 4"Add Notes".And on selecting the dropdown only that note i have to show. Please help me out of this.
500 Server Error when trying to change application name or link on Settings page
I made a copy of an existing application. That application was entitled 'Copy of ProjectName'. When I go to the settings page for the copied application and attempt to change the application name or link, it gives me a 500 server error. Robert
Does Zoho have servers in Australia?
Hi Zoho, I love Zoho Creator but find that applications load very slowly. For example, look at www.cocoride.com.au, a website I set up with a Wordpress backend. The wordpress pages load within 1 second, but the Zoho Creator HTML view takes 11 seconds to load on average: The interesting thing is, it's just for Australian visitors: I also note that Zoho's server status page does not list any Australian servers: This creates major problems for me as an Australian Zoho developer. My clients are dissatisfied
Formula Syntax
Can anyone help me get the syntax right for this formula? I have 4 fields. field1 is true/false field2 is a number field3 is a number field4 is a formula I want field4 to perform this function: If field1 is false, then field4 = (field2 * field3). If field1 is true, then field4 is null. Thanks, Tom
More effective Group Member management
We have hundreds of volunteers in several counties around California, each of whom will be a User in our Zoho account. We are creating an Application and a Group for each county's volunteers, and Sharing each county’s application with that county’s volunteer Group. Volunteers come and go all the time, and only current volunteers should have access to one of our Applications, since the Applications will contain sensitive information. Thus, we need to be able to easily compare each county’s list of
Double Vision in Chrome Version 23.0.1271.64 @ Freeflow script mode
Hi ZC team Double vision happens in all apps (personal, shared, developer access) when viewd in chrome irrespective of form / view / Schedule / Functions etc This happens only in FreeFlow script mode Script builder mode is working fine Please see attached jpeg. Thank you Best Regards -Deepa Govind http://homepreneur-online.com/
Add Items in a PickList Dynamically - Not Working
I am trying to add some Products to a picklist dynamically. I have a form where there is a lookup field called product1. By default it gets all the products from a separate form. I then have another form called "Setup_Delivery_Locations" where I have another lookup field back to the same products list. I want the products list to be filtered by the "Setup_Delivery_Locations". So here is the code that I have: VShiptoProducts = Setup_Delivery_Locations [Delivery_Locations == input.Delivery_Locations];
Adding records to zoho creator with REST API
I'm trying to add a record to one of my forms in zoho creator using the REST API and python. My code looks like this: from httplib2 import Http from urllib import urlencode access_token = 'AUTHTOKEN HERE' h = Http() data = { 'authtoken' : access_token, 'scope' : 'creatorapi', 'zc_ownername' : 'reviewpro', 'external_id' : 1 } resp, content = h.request("https://creator.zoho.com/api/json/desk-com-cases/desk_cases1/add/", "POST", urlencode(data)) print content And I always get the same
Missing tabs even log in as site admin. Please help!
The site works before but just missing all tabs all of the sudden. Thanks,
Missing tabs even logged in as admin of the site. Please help!!!
tabs are missing even log in as admin. It works before but just disappear suddenly. Please help!!!
Counter Field in Subform
Hi - new user I like to use a counterfield as a unique ID for related Forms. I have placed script to create the counterfield value - it works fine in the forms . However it does not work when the form is placed as a subform. eg it returns only the previously succesful data - not the current field I am trying to link to: eg Form . Clinical Counter Field Clinical ID Form . Clinical Detail Counter Field . Clinical Detail ID as above they work fine and auto update for the next "new"
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
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?
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
move database to another administrator account
How can I move a database I set up to another users account?
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
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?
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.
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.
Very slow today
Users complaining zoho is unusable today. I agree. What's up zoho?
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 ??
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!
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?
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
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 ...
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
RSS feed?
Is it possible to subscribe to an RSS feed when updates are made to a table? If not, make this a "feature request." lpress
Next Page