Email Notification Not Working On Form Submission
I am not receiving emails from submitted forms. From the More Actions menu > Set Email Notification area I have Enabled email notification and zoho.adminuserid is in the From field. The Include User Submitted Data box is checked. I have also checked my spam box just in case it was ending there but it is not. Is there a bug with this? Recommendations for troubleshooting are appreciated. Thank you.
Using Google Custom Search to search a database
Has anyone tried using Google Custom Search to search a Creator Database? I am interested in an easy way to embed a database search without customizing an html view to do so. I would be fine using creator's interface but you cannot search across fields... you can only search one field at a time. Thanks for any input. Mike
limit view access to db rows using zoho.loginuser
I want to have view criteria that will only return db rows when the current loginuser matches the added_user on rows on the db OR if a given loginuser other than the current loginuser is using the view. I am able to accomplish the first part using the following criteria without an issue: added_user == zoho.loginuser But when I try to include an 'or' condition that would allow a manager to view all of the db rows regardless if their loginuser matches rows on the db or not I get an error message 'adding
Dynamic Picklist clears data when editting
I have a dynamic picklist setup using the tutorial provided in the FAQ and populates a drop-down based on the input from the previous drop-down. But, when I edit an entry it seems I lose the data...seems to reset. I assume I have to add code to the "on update" script area for my field...but am not sure how to set it up. Here's my "On User Input" script: if (count(Add_Teacher[School == input.School]) == 0) { clear Teacher; } else { Teacherlist = Add_Teacher [School == input.School]
Printing a calendar view
This might be a stupid question but, how do you print a calendar view? There is no option for print under the "More Actions" pull down like other views. I can do it with an html view to open the iframe link in a new window but I may offer this app in the market place and do not want to use any user specific linking. I have a calendar view based on planting date and would like to print a calendar on paper or pdf.
Is it possible for web publishers to make their data available to the largest possible audience in Zoho Creator?
Hi, everybody! Could somebody, please, give me a hand? Recently Caspio Bridge has announced new SEO deployment method. Here are all the details: http://webappsatwork.blogspot.com/2009/11/will-caspio-seo-technology-be.html Caspio emphasizes the point the deployment code doesn't run on the end user's browser (using JavaScipt, for example). Their SEO deplyment code runs on your server instead. This is critical, because the search engine crawler must believe that the data resides on your own server.
In creator, how do I limit the size of image downloaded
Hi can I limit the file size to be downloaded, and also, can I specify a file type to use? Kind regards dp
Last Day in Month
Need to create a formula to populate a field with the last day of the month following the date. For example, if the date is November 12, 2009, I would need to create December 31, 2009.
Can a deleted field + its data be retrieved
I realized too late that I shouldn't have deleted a field, which contains hundreds of data entries. Any way to get that back?
How would I assign a variable from another application?
How would I assign a variable from another application? My overall objective is to auto-populate a form with with data already collected in another form. Normally, I set my variables like this when the form is under the same application: var = REMOTE_FORM [REMOTE_FIELD == input.LOCAL_FIELD] LOCAL_1 = var.REMOTE_1 LOCAL_2 = var.REMOTE_2 But, I have an instance where I need to reference a form under another application; HOW?
Request URL to get JSONP response
Hi... ....I have a database application and I need a url that response in jsonp format... how can I do this? http://creator.zoho.com/api/json/<applicationName>/view/<view_name>/apikey=<API Key>&ticket=<ticket> Thanks
Contains Client Side Scripting - Workaround?
I use mobile devices heavily with my application. I previously used on-input deluge to populate a dropdown list with a more precise list of choices for my field operators. This was made impossible with the security changes implemented in April-May. I have attempted to create my own work-arounds which have proved problematic. As such I have been left with no choice but to require my field operators to scroll through many options in the dropdown before finding the one they are looking for. Previously
Lookupo Criteria
My problem may be the same as issue 87851000000853007 http://help.creator.zoho.com/Issues-List.html I have three lookups on form A looking up information from form B. When I add criteria to the Lookup and click Done the field disappears from the form. It reappears when I refresh the screen but the criteria is not saved. I was able to get this to work by coding directly in the Form Definition. Herb Wexler
Cannot retrieve application data.
Hi. I'm not sure I am the only one having this issue, I developed an application that retrieves data from a zoho creator app, it was working properly 5 days ago, but suddenly stopped to work, I didn't change anything in the code, so tested using the direct link http://creator.zoho.com/api/json/appname/view/viewname/apikey=xxxxx&ticket=xxxxxx but it always return the message "There is no such view in Zoho Creator". I have double-checked the info and tested too much times. Do you know if anything
user cannot upload a file in a form upload field, (possible AOL conflict?)
Hi Zoho friends, My form has several upload file fields. One user is unable to submit the form if she uploads a file. she can submit the form without any files. She has AOL, and was unable to upload when she accessed the form in her AOL IE browser. We had her install firefox, and the same problem happened. The file she is supposed to upload is about 700 kb. A tech here walked her through several times, so we feel confident it is not a user error. Please help!! Zoho, the file is shared to you.
New Tab Creation option.
Hi, i am satisfied with the way of zoho handling the field level customization. But it would be a great advantage if create new/custom tab or module in addition to this. I have seen in one of the blogs that zoho is going to implement this too in future. Whe can we expect this feature to be available for us? any idea on it? Regards, Pavan
Is it safe to collect credit card #s with zoho forms?
Is it safe to collect credit card #s with zoho forms? or would the person's information be too accessible?
How do can i subtract from the sum total of a view?
How do can i subtract from the sum total of a view? , and also how can i subtract from the total sum of 2 views Sum total from view a - sum total from view b Thanks
Currency in View
Hi, I am sure this has a simple solution, I just can't seem to find it. I have a currency field that I would like to display with a dollar sign in a list view. Help? Thanks in advance!
Calendar Issue
I hope someone can help me clear up a mystery So I have created several calendars in creator and most of them look like this: https://url.odesk.com/ef4co ** note I promise this is only a screen snap link it is a photo** But my most recent one will not work no matter what I do it looks like this: https://url.odesk.com/rh6eq (** note I promise this is only a screen snap link it is a photo**)...the month and year are not visible. I have tried everything I can think of -- anyone have any ideas? Thanks
Can I fetch records from another application?
Dear Sirs, Currently I have a series of apps and I would like to start using them together. For example I have one app where I have all the information of a client or customer and another one where I have the information of it's sales and data. My question is if it's possible to fetch data from the CLIENT INFO to the CLIENT DATA in order to be able to mail the information to them without having to duplicate the form of CLIENT INFO into the CLIENT DATA form because other apps will also require to
Display name in view is not read as the field name
I am not able to sort data by year in a view. I have noticed that in the "Column Properties" of the view, the "Year1" column is listed as having both a display name of "year" and a field name of "year". As such it seems that ZC does not recognize it as the year, since it is referred to as "Year1" in the actual script. In looking at the view description, it is listed correctly. I have tested this by changing the display name of the "Year1" field from "Year" to "Year1" This means that the display
Multiple entry dates
I want to be able to set a date as an entry, then enter the duration in days. From this I can set the end date by running a formula. However, with the diary view, how can I show a marker on each day to identify something will be out for the days as shown? Presently it can only be sorted by a lead date? Thanks Dave
Can't delete records in a view
I can delete records in a view , no problem. But when I do a search query, I can't delete any record of the result set... has anybody had this problem??? Thanks...
New to Zoho Creator, 2 simple questions
I am trying to use Zoho for the first time to manage contacts in my university's christian club. Zoho seems great, but there is something I thought should be very easy to do but I couldn't figure out how: 1) I have a table for Current students, and I have a table for Graduate students, they have some different fields (for example, the Current students have a student number assigned to them but the Graduates do not). At the end of an academic year, some students graduates and I have to move some from
asset error
FAILURE :Node discovery failed. Please report the problem to the system administrator, with the Error Code - 1,257,833,735,195.
asset scan error
i have a linux workstation. i can login this server on my asset server use ssh. but i use asset scan network set use ssh ,asset always say "Problem while discovering the workstation" pls help.thanks
Client API doesn't answer?
I'm trying to integrate a form from Zoho Creator into my Webpage using Client API. I followed the explanation at Zoho API Guide (http://api.wiki.zoho.com/Zoho-Creator---Client-API.html) . But I'm only get a white page. It looks like there is no interaction between the html-page and the zoho form or the API!? My questions: - Do I use the API key and the ticket for the Client API? - If so, how do I use the API key and the ticket? - Is there more to do as described on the help page above? Thanks for
criteria for views
Each of the users of my application belongs to a given firm, and each firm can have several users. The association between firm and users is established in a form, called Users, with fields : FirmCode, UserEmail. The UserEmail is the same as the zoho.loginuserid. I now wish to construct a View on another form, called Orders, such that all users of a given firm can see only the orders of that firm, irrespective of which user of that firm has placed them. In the Orders table I have a "FirmCode" field
HTTP Status 401 - Unauthorized access
Hello, I get the below error when trying to log into Creator. The URL is http://creator.zoho.com/home/index and I have also attached a screenshot of the error. Thanks. HTTP Status 401 - Unauthorized access type Status report message Unauthorized access description This request requires HTTP authentication (Unauthorized access). **********
ERROR
Error details: Error occurred while executing on click script. Unable to update data on the form variable Unique constraint Failed in the form field null.t_161415000000850309_PIDX.null I'm using a stateless form to fix a large number errors in my data. In order to stay below the 500 insert limit, I have a counting variable in the code. The error above is generated...can we say obtuse? myCount = 0; for each r in MYDATA { if ((r.Cat == "Y") && (myCount <= 497))
Inviting users to new version of the same application
I am not sure what happens when I invite users : if I make changes to the database it seems that these are not immediately available to users, I have to share the application once again and the list of previously shared versions of the same application still appear and are available in the user account !
Captcha fail on Safari
I see there are others that have encountered this problem recently. I will add so you can see they are apparently not isolated cases. In my case, users recently began reporting unable to enter email on our website using Safari. When I tried it (I downloaded Safare to test, since I had not installed before), I also got failure. In my case the error reads: "Invalid entries found. Please correct and try again" My FF & IE work OK with verification, Safari works when I remove verification I googled
Exported Script and Imported to another account
I created an application for a friend, I then exported the script to file and emailed it to him. He imported the file every thing looks fine but the application gives an error message when you try to enter data in the stateless forms I created. The error does not help at all. It says error occurred in on click script. I look at the script and it looks fine. I opened it and edited the script and re-saved it with no problem but still does not work. I then created a dummy user account in zoho and
FreeFlow Scripting and Google Chrome
Does anyone else see an issue with freeflow scripting and Chrome? When I use Chrome and try to go to freeflow view I have a constant loading icon and it never loads. Is there a setting to change in Chrome or is this a known issue?
Autofilter list fetch?
We have a list of clients on a table. That table has 'Active' and 'Inactive' radio boxes, this indicates if the client even attends our program anymore or not so it is very important. On that same form/table we have a list of days Monday through Friday in checkbox form. We have another form and table that we track attendance on. I would like to do 2 things, but would be happy with just one for now. I our attendance doc is to be done daily by our staff and volunteers. The attendance doc has simply
Application Duplication Not Working
When I try and Duplicate one of my larger apps it does not occur. Instead a get a green box at the top of the screen but with no text in it. I can duplicate a smaller application without a problem. I really need to be able to duplicate my larger app however. Bug? Glenn.
Zoho Creator Down?
Creator is not responding at the moment. Is there a problem? If so, is there an ETA to fix it? Many thanks Anna
Creating an external document
From inside my creator app - I would like to be able to create a document (ascii or "word"). I need similar ability to creating an email message - but instead of it being an email message - I'd like to name the document and just save it to my hard disk. Any way to do that? Thanks
Get Day of Week usage example?
I will try to be as brief and clear as I can, and hope it is enough for someone to read my mind. This video clip shows I have made some progress. I am getting the day of week returned in it's numeric value now. The problem is that is not the way I need it to make the form function. I have 2 different tables. The client table has a section for each client with checkboxes checked for the days they are schedule to be there. When a staff member enters the date they are doing attendance for I would like
Next Page