Getting Proficient with Zoho Creator
I'm a beginner developer looking for some great resources to help me learn zoho creator. I would prefer a book or video collection that would help me rapidly understand zoho creator. Any suggestions?
New update in precreator.zoho.com
Change-log for the latest build in https://precreator.zoho.com : Related fields of Lookup fields in Views - Proper handling done in Sorting and Grouping when a field in a form is referred from twice in another form Performance (Loading time) improved in the above case in views Performance (Loading time) of Calendar view improved. Creating applications from .xlsx file. Charles
Show Parent Field from Parent of Parent?
Can I show a Parent Field from the Parent form of the parent form? If my Forms (tables) were: Product (i.e. Product Type field contains "Beverage," for instance) Brand (i.e. Product Brand field contains "Wow Cola", which is selected as a "Beverage" from the Parent forms lookup field dropdown.) Type (i.e. Diet Wow or Cherry Wow, etc, which is selected as a "Wow Cola" from the Parent form's lookup field dropdown) Can I show all three fields on the "Type" form from the Parent form AND the Parent form's
More zoho._____ variables for easy debugging && full app source search
1. more zoho.____ variables and perhaps an assert method I just built a simple logging system for debugging. In my functions I just use something like... log("functionName", "line #", "messages") If we had zoho.funcName, zoho.line_number, zoho.funcId, zoho.formId, etc we could build some pretty awesome logging, documentation systems. I could create links straight to the form edit view! I'm trying to use unit tests as much as I can for testing functionality so using info messages for debugging is
API development
I have an account with ChannelAdvisor where daily there are some orders generated: I have developed some Zoho Creator forms to hold the data from these orders, manually. Now I am looking to use ChannelAdvisor API to let Zoho Creator automatically grab orders from ChannelAdvisor: http://ssc.channeladvisor.com/howto/sales-and-fulfillment/fulfillment/downloading-orders Look in "Developer Network APIs". Can you guys help develop it?
Import and export the bulk data
Hi I created a duplicate application .i am able to duplicate the structure and not data .You people replied that there is a option to import and export the table data. But I have so many database tables in my application . Now i am able to import and export single table data at a time. can i have the option to importing and exporting the bulk data(like more than 10 tables data at a time ) ?. Please Help me out Thank you
Show a list if entry is duplicate
Am a complete newby. If a Lastname and Firstname field are entered and these already exist I would like to show the existing record to the user and ask if they need to edit this record or not? Can anyone help to get me started with the coding? Thanks
Subform: Limit number of additions
I think there should be an option on the subform field to limit the number of items a user can add. Until (or if) that's implemented, what's the best workaround to limit a user to only adding one item? John M. Whitney
Payment Gateway (paypal)
Hi, I would like to give a feedback on your tariff plans, as I am using Zoho from last 5 years and learning more n more things but I'm little bit disappointed. Payment Integration is really great feature I have seen in Creator after Schedule Job but I am unlucky :), I have business free plan in my account and I'm surprised when Zoho has removed Backup and Restore feature from my account and not even give few transaction limit for Schedule Job nor for the Payment Gateway as like Reports (Maximum
How to select DISTINCT record to picklist?
Dear All, It's ok to add record into the picklist, but how to just add DISTINCT records? For example: Here are records in FormA.FieldName: Item-1 Item-2 Item-1 Item-3 Item-1 I would like just to add Item-1, Item-2, Item-3 into the picklist (the DISTINCT records). When I used : type = picklist values = FormA.FieldName There are 5 Items in the picklist. Is there any UNIQUE or DISTINCT function to select record? Thanks!!
Sharing an application
If I share an application in the developer zone to a client "Without Source" and then later i do an update to the application and want my client to have access to the source is this possible to change? When they more to the updated application can they have access to the source on the updated version? What I want is the client to not be able to view the source but i do want them to be able to create new views on their own. Would this be possible when publishing without source? If not, can i do what
How to get database tables data with duplicate application
Hi, I duplicated my application .In The Duplicate application i am unable to get the database tables data .I need the total database data in to my duplicate application . Can any one help me out Thank You
Zoho creator csv feed to Zoho reports
According to your slideshow available at the below link to make data available from Creator to Reports, from view mode, you select 'more actions', Export data and select CSV feed (a screenshot is provided). However, the options within export data is different for me and all export data options exports and downloads the data in the selected file format. There is no option to select a feed. Please advise urgently as I have just spent 2 hours trying to find pages in your help section as your 24/7 phone
Bulk Editing a Check Box Field
I'm a new Zoho Creator user and I've been impressed with the service overall. Very robust and simple to use. But before I can bring my organization's data over fully, I need to figure out a solution to one problem ... I can't seem to figure out how to bulk edit a check list (multiple item) field without deleting the existing data in a record. This is a frequent need so I need figure out a work around. In another thread, "Suggestion for bulk edit of a multiselect field", a Zoho employee indicated
Re need need your help for how use ZC API to run pic data of Flickr
Hi Could you please giveme a sample code how use ZC API to run pic data of Flickr.. Thanks Stanley Guo
Auto mis-direction in Internet Explorer - link to form
I have a public view embedded on our website. There are links on the view that take people to a form. http://www.gormanfarm.org/volunteer.shtml When the links are clicked in Firefox or Chrome, they work as expected. When the links are clicked in IE, they re-direct to the wrong form. If you watch the navigation bar, you will see the correct URL for a second, and then it redirects. This is a huge issue for us. People cannot register interest as they are supposed to. I tried these issues both logged
Show link for adding new value
I am creating a class registration database for a nonprofit, and Zoho looks very promising. I have run into one stumbling block. When creating a field of type "import data" you get a drop down interface showing all the values of a specified field in another table. You also get an option to "Show link for adding new value" Is there a way of getting the "link for adding new value" without creating a dropdown list? I have a class registration database that contains a "parents" table and a "students
Wufoo to Zoho Email Integration
Hi Anyone got this to work successfully, initial testing indicates that the wufoo styling feature causes an issue and the incoming email is not added to the zoho database Thanks
Adding Record in to Zoho Crm
Hi When i Add the record in to Zoho Crm from Zoho creater . Getting theis error An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home Can any one help it out Thank you
Filtered dropdown
I am creating an app with the form name Salesman Data . Now in this i have different fields . One of them is Salesman name and other is salesman id ,etc . the salesman name is looked up by new form !!!if salesman name is not found !!! it can be add !!! now what i want to do is when someone want to add salesman id !!! it should be auto generated and the same id be used the next time the some user use tat salesman id. Please help me asap
Rss/ twitterfeed problem
I'm trying to set up a twitterfeed from a zoho creator view and am getting this issue: your feed might be empty or missing publish dates or GUIDs. A feed needs to contain publish dates or GUIDs in order to work with twitterfeed the view does include a date/ time function as follows. has anybody else had this issue that can help?! thank you! anyone?!
Version Number NOT incrementing when taking Backups ...
This morning, when I attempted to take a Backup of one of my Applications, the Version Number remained the same as the one for the previous backup ... see attached screen image. I asked one of my Clients to attempt a backup in his Account ... and the same thing happened to his backup. Gaev
Building a PTA Volunteer Database
New to Zoho! I'm looking to build a database app to: 1. Record volunteer names and contact information 2. Record the interests and skills of each volunteer 3. Record committee head contacts 4. Ability to link volunteer based on interest and skills to one or more committee Any suggestions would be appreciated. I have experience with Excel and Access. But I want it on web some I can create and let someone else do the data entry and management. I do not need to have volunteers register via this app.
sort order of past entry items
i add a lot of data into my forms that is the same over and over again. if i click on a field twice, i see a drop down with the past entries into this field. i would like to sort and/or edit this list. i use the same verbiage over and over again to input into my forms. i may have well over 100 entries that i would like to click to add to the field instead of having to retype each time. But this is difficult if there is no order to the entries in the drop down box. Is there any way to access these
Fetch Record Select field (Optional) Parameter
Hi Looked, cant find the answer never used it as it is optional BUT In Fetch Record what is the "Select field (Optional) Parameter" meant to be used for ? Thanks
Many-to-many relationships with large forms
I'm trying to find the best approach to creating many-to-many relationships between a series of forms (tables) that have hundreds of entries in them but generally only a few are selected. For example, - a farm will sell their produce to one or more restaurants, - a farm will sell their produce to one or more distributors, - a farm may be a member of a market group, - a distributor will sell to one or more restaurants, - a restaurant buys from zero or more farms, - a restaurant buys from zero or more
Duplicate AND Bulk Edit at the same time
I often need to add records that are exactly the same as others but have 1 or 2 fields that are different. Currently, I select each field and duplicate. I then select each duplicated field and bulk edit the different fields. Unfortunately, because some of my forms can't have duplicates, I can't get past the first step in this process. Can run scripts off of duplications? For instance, if I duplicated 20 records in a form that didn't allow duplicate records, it would ask me to change a field to make
Suggestions for bulk edit of multiselect field?
Hi everyone, I only started using Zoho yesterday, and I love it! I hope someone can help me with this (or suggest something else I could do instead). I'm making a marketing campaign tracker. So I have a list of customer and a list of campaigns (several customers are linked to each campaign). The only way I can think to do this is by using a multiselect field (or checkboxes). That's fine if I'm adding customers to a campaign one-by-one, but if I want to add a whole heap of customers to a campaign
How to update records in a form from Excel, using migration tool (or otherwise)
Can you tell me how I can update existing records in a Zoho Creator form using data I have in an Excel sheet? The Excel sheet has a primary key, which I could use to key updates for the Zoho form data, which also contain the same key. Here's the functionality I'm hoping to achieve: 1. If the keys match, I would like to update/overwrite all the fields in the corresponding record using the Excel sheet data. 2. If the keys don't match, I would like it to create a new record and populate it with the
Verification Code
64RPL verification code is failing on one user's IE 8 I suggested re-starting the browser. Please check your captcha internals. John M. Whitney
User Email Activation
Hi! Wondered if you could help me - I added a user to my list, and it didn't send a activation email. The junk/spam folder has been checked. Thanks for your help! :)
Best practices for Zoho Creator migrations
I will be working on a Zoho Creator application that was previously developed by another group. I have a series of new enhancements that will need to be incorporated in the application. Part of my challenge is determining the most effective way to make changes to the existing application. There does not appear to be any sort of migration tool and/or best practices around change management. I have thought through a couple scenarios: - backup/restore the production application, make changes to the
Restrict user access to certain records
I'd like to use Zoho Creator as a database to keep track of several client details including notes from client contacts. We have several consultants spread geographically and a staff at the main office that would be using the database. Is there a way for the consultants to see only their records and the staff to see all the records? I've seen solutions on these forums where the consultant can only see the records they create but that won't work for us because the main office staff will also be
Build a drop down list
Hi, I want to build a form that has a drop down list of items e.g. grocery bought. How can I make it into such a way that if a new item has been bought and is not in the list previously, it allows the user to key in manually and be added into the drop down list?
Unknown Host error message
I get an unknown host error message when I try to log on to zoho creator from my company blackberry. Is this an administrator issue? Any help will be greatly appreciated ray
Auto complete of a field for certain users? URGENT!
Hello, In my application, I have a form field for which Public users are required to enter their email address. I want to HIDE the email field from my logged in users. I don't want PUBLIC users to see an initial value for the email field. Is there a way to set the field to load an initial value for logged on users only? Thank you!
How to keep the track record of users in an application
There are many peoples ( or active users ) working on application in zoho . They are feeding data constantly , but who can I find which person has submitted which data.
changed and saved code not actually run in Deluge
I've changed and saved code in Deluge, but when I run it, it runs the old code. However, when I then look at the code I saved, it still displays the new code, even though it runs the old code. This lag takes a few minutes, and then suddenly without any input, it runs the new code. odd...
postUrl problem - XML beginner
Hi all, I'm a complete noob with XML, HTTP Post & the like. I have a Saasu account and I'm trying to send client details from my ZC database to Saasu. I'm getting a response code 200 but it's not working, ie no record is created in the database. Here's the response code the saasu server is returning: {responseCode=200, responseText=<?xml version="1.0" encoding="utf-8"?> <tasksResponse />} The Saasu team have had a go using the output string I provided them (FinalDest below) and they were successful
Subform Invalid entries found error
Hi, When trying to use the subform function every time I want to craete a mother record that includes a subform record, I get this error message, invlid entries found. the detail says that there was an error during the on success script but i cant see any script on success in the mother or subform script. any clue?
Next Page