How can I know the IP Address of the sender?
How can I know the IP Address of the sender? I found out thay when my customer submit any IP. There is no IP Address indicate. How can i view this? ronoliverclarin
Remove link from view
In a public summary view there's a link to the app. Offcourse visitors can't get into the app because it's private but neveretheless there's no need for that link. Can I remove it?
Urgent! Order by in "for each record" command
Good afternoon, I'm building an app that requires the system to read a certain form/table ORDER BY an especific field DESCENDING; I've looked everywhere at the forum and documentation and found nothing that allowed me to do that, the only place that has this option is the "View" builder, but it can't be used by the function I need. I'd like to know if there's any possible solution, such as: - adding the option "order by" to the "for each record" command OR - adding the option "order by" to the "fetch
Data disappears from view when 38th input field is created
This is the form: http://creator.zoho.com/iscbrasil/pains/form/1/ There is some data loaded in the table behind. When I create a new field in "Pain 06" all the data disappears from the view. If I delete the last input field, data reappears. Any idea ?
Picklist
Hello How can I "pick" a repeated field value only once? For instance: Field1 | Field2 A | xxx A | zzz B | yyy And get a picklist with A,B and not A,A,B Thanks Hugo
formulas not giving correct total
I have a formula field in my mileage expense entry form that enters the product of the miles driven and a constant mileage rate (50.5 cents). When I use the 'sum' feature in the creator view mode, I get an incorrect total. In the attached pic, you'll see that I have two entries of 21.51. This should give a total of 43.02, but instead shows 42. Any thoughts?
Private Database - Public Form
I would like to keep all the data collected in the database private. However, I want the link to the form to be public so that anyone can submit information, but only myself and those I share the app with can actually see the data. Is there a way to do this? Thanks
Linking interactively between views
I can't seem to find a way to create a situation - where I show say 3 of 7 fields from a form in one 'view' then link for each displayed recorded to another 'view' which I show all 7 fields probably in the summary format. This would be really useful so we can have a simple table of basic data and then allow users to click each record to view the full data associated with that record. Pete
Forum Problem
As I try to move through the forum, I often get this message: "phpbb Fetch All error: database query failed at /home/forums/zoho/newzoho/mods/phpbb_fetch_all/common.php:304" on a blank ppage. peaslee
Mobile access not working on Blackberry
I have a simple application to track expenses and miles. I cannot access it on my Blackberry. Anything I am missing?
HELP!!!
Dear Zoho Could the support team please look at the new layout! the view in the new window is now very small, when you have a lot of tables its almost impossible to edit the ones at the bottom of the list Please switch back to the old layout before this new one drives me crazy! Regards Peter moanazoho
Self-relations and hierarchical views
Hello again! It would be great if "Zoho Creator" would have a possibility to display hierarchical data in an appropriate way. The typical example: Imagine you manage a list of employees and want to model a chief-inferior-relationship (unfortunately). A good way to accomplish this is to add a field "Chief" to the form "Employee" whereas this field refers to the same form, that is "Employees". So you can input for every Employee a chief-employee. That results in a hierarchical structure. This could
Links are lost when a form is updated
I am using a Summary view (e.g Product) that links to another Summary view (Supplier details - phone number, etc.), using a formula field (i.e. href...) . Everything works as expected the first time around, but if I update the Product record, the links to the Supplier are lost. Any idea why? gabrielcoch
Dependent fields in Creator
Hi, Do you know of any way to create dependent fields in Creator like what was done ZOHO CRM? Here is the description of this functionality in the CRM app. Dependent Field Mapping This page allows you to map the parent field value with the child field values. You can map more than one child field values to the parent field value by pressing the CTRL key and select the values. adam_stone
Can't edit registers
Hi, When I try to edit a register in the view of a contact form, I press submit and just a red "null" appears and the register doesn't que modified. Any ideas? Thanks, Emilio oemilio
Can't group view by 1st dropdown
This is probably related to another bug I reported where my criteria changes because I added a dropdown to my form that pulls from the same field on another form, but I want a view that groups all products by the pages they're on for each website. http://creator.zoho.com/maureenshea/view/106/edit/ returns nothing (Website.startsWith("Cal") and the same with http://creator.zoho.com/maureenshea/view/77/edit/ that's set for Website.startsWith("Red") (which worked before I added that 2nd dropdown to
"xml has no properties"
I am getting an error message when accessing my code: "xml has no properties" I did a search in the forums, but all responses say that they have sent the user a private e-mail. Can I get one of these e-mails? Thanks.
School need help using the SUM function
My school has started using Zoho Creator to keep track of student. Works good but, it needs a tweek. 1) Students are tracked by their student#. How do keep a running SUM of the their number of demerits? 2) More advanced. If a student goes without a demerit for 2 weeks, they lose one. Then they lose 1 for every additional week after. How would I script for this? Here's a public version of the page https://creator.zoho.com/ap00/student-demerit-report/form/2/ Any help would be greatly beneficial. Thank
Private Application with public views
I have a form with three different views. 1. Input view. Should be only accessible to me 2. List view. Embedded in my site and should be seen by everybody. 3. Summary page. Comes up when user clicks an details in the list view. Now my app is public and that works almost as I want it. The only problem is that there's a link to the app in de summary page and that goes directly to the (public) app. If I make it private the summary page won't open without a password. I guess there's an obvious solution,
Using the Set Criteria in lookup fields
Dear Support and Forum Despite having worked with Zoho Creator over the last few months I am still unable to think how to use the "Set Criteria" in look upfields to restrict the number of entries in the lookup field. The box says "please specify deluge criteria below. If no criteria is specified, all entries will be shown. " However, I am unable to find any examples of the kind of deluge scripts that will work here. Can anyone point me to an example which will help me understand how this feature
Javascript and PHP support in Zoho Creator
Zoho Creator should be flexible to allow native JS and php in the script section. JS and PHP have vast libraries and developers cant develop much in zoho creator without these. Please consider this ZOHO architects. Prakash
Creator: Editing records in form view, or elsewhere
Editing records is too difficult. I have an Event table and a Venue lookup table. For some reason the Venue didn't get included in one of the Events. I've gone back three times and tried to edit the data, but it doesn't seem to get saved. It'd be easiest if it could be edited in the original Form where the data was initially entered, via record selectors. Thank you, motownmutt. motownmutt
URL Filter
Hello What is the correct syntax for a URL filter. I am using it and it's not working. Thanks Hugo
Formula help
I was able to use your sample to SUM up my numeric fields. But I use this form as a QA database to score call center agents. How do I convert my sum of points into a score as a percentage of the total possible points? I can sum th epoints they got, but how what formula do I use to say: sum / Xnbr = XX% Example: sum - 13 points out of 15 so I need formula that returns 88.66%. rgarcia
Thanks for the JSON Import of Data
Hello I googled xls to JSON converter and landed in your site. I am working on a project and needed xls to JSON. Now i dont need xls at all, i use zoho creator and export the JSON data. Great work and please continue the good work. Why is google delaying the aquisition :) Thanks Prakash prakash123
Sorting doesn't work at all in summary view
http://CallaLilyBouquets.com is set to be 30 records per page, 3 records per row. I don't think I care whether my sort criteria (R descending then Time descending) is executed vertically or horizontally, but I'm not at all happy that it's not being exected at all maureenshea
Notes are disapearing
Very confusing and frustrating. Notes keep disappearing from view and application... Don't use this yet!!!! akkdio
Atach a document while sending a Email .
HI I would like to to attach a document while sending a Email . is it possible to do . can any body suggest a way Thanks
List and Summary in same view
Hi, I'm starting to become dependent on Zoho apps... I'd like to have a way to display a list of records in the upper half of the screen and a summary view in the lower half which shows the field data from the record selected in the upper listing. Is there a way to do this with Creator? Thanks, Brian mogvaj
How do I display form contents before submitting?
I have a form embedded in my website for users to fill out. Is there a way to display the results back to them when they click submit, so that they can confirm all the details?
Embed Issue
I've designed a form "Eagle Pointe Condos" and embedded the IFRAME text into my page, with a return URL, but the return URL returns within the IFRAME even with the parent window selected option. Is this a bug? axual
collaborator cannot create new account
i did invite a friend to share the database in Zoho creator when she want to register with: erika@sagenetics.com , your registration input form gives message: NOT VALID EMAIL ID ? pls advise what to do. thanx markus vistatest
How do I update data in records in another form?
I have several user types and want to create forms specific to their function. I know how to pull the various subsets of information from the "master" form to fill in the function-specific forms based on looking up an ID. Works great. But how do I get updated items back into the right record in the master form? Thanks. Zoho is looking very promising.
How to add n days to date
Can I use a variable to specify how many days to add to a date? e.g.: Interim = 60; Date_Performed = zoho.currentdate; Next_Date = Date_Performed + 'InterimD'; 'InterimD' doesnt work, of course and Interim can change, so I dont want to hardcode '60D' Thanks for help!!
Sheet problems
Not sure what is happening but when I try to add information to a spreadsheet on my iphone, the application runs very slowly and then blanks when I attempt to write on it. Some times the screen just freezes or blanks out to black. Any ideas what is going on?
Script won't update
I cannot get my script to update. "Error modifying the page null" is the message I get.
Data not loading
I have a simple application which is like a questionnaire, with a bunch of questions, all radio button choices. I have a corresponding view file as well. As I access the application, and enter data and submit, it is not loading onto the view file...what am I doing wrong?
No e-mail notification sent!!
Hi When our user submit our form on our intranet (private permalink - from shared account), Zoho does not send any e-mail notfication! But when I (owner) submit the form Zoho send notifcation without problems! What can be wrong? The private permalink of the form, that the users submit from, is based on a shared account, due to the fact that I have some hidden fields that the users are not allowed to see. BR Dennis Skouboe
How do I filter lookup field's values based on another value
I have two forms. Here is my layout: FormA: Exercise -> Single Line Muscle_Group -> Drop Down List FormB: Workout_Muscle_Group -> Drop Down List with same values as FormA.Muscle_Group Exercise_One -> Lookup based on FormA.Exercise values Exercise_Two -> Lookup based on FormA.Exercise values Now, how can I filter the lookup values in FormB.Exercise_One and FormB.Exercise_Two so that FormA.Muscle_Group equals FormB.Workout_Muscle_Group? Does that make sense? Thanks! Alan
ZohoCreator Maintenance
ZohoCreator service will not be available for a short duration on April 3rd, 2008 from 9:00 PM PDT to 9:30 PM PDT. Update: We have had some last minute glitches. Hence we have postponed the update from Apr 3rd 2008 to Apr 4th 2008 from 9:00 PM PDT to 9:30 PM PDT. We apologize for the inconvenience caused.
Next Page