AutoNumber field type
I would like an autonumbering field please. e.g. it would automatically hold a value according to certain ranges, or formats. e.g. then each record gets a unique number. tosh1
Use IP
Is it possible to capture the User IP address when capturing form input on Zoho Creator? I don't see a Zoho Variable for that. steve_caldwell
I know this is basic question !
Apologies, I know this is basic stuff, but I just can't seem to find where to do it ! When a user adds data to a form and clicks on "submit" I want them to be immediately redirected to a particular URL.. How do I do that?
Application size
Hi, Need a way to determine the size of each application in GB or MB. Will be creating an application for each of my clients and need to factor in storage costs in my pricing model. The idea is to start charging clients for storage when they exceed a maximum storage limit. Would be great if could automate billing of this using Zoho Invoice. Any ideas? Thanks, Steve
Way to build logs?
Is there a way to create a field that the user can type a message into and enter it as a log entry. Then have another field where those entries are displayed. Is this possible in Creator?
How to create a "close subscriptions" function
Hi all! I try to best explain myself. I've created a form in which users should insert data required - like name, surname, mail etc.. But they have a limited time to do so. Let's say that on day "14 of June" they shall no more insert data. How can I do that?! Actually I've managed to create this code: if (input.chiuso==true) { hide Nome; hide Cognome; hide email; hide matricola1; hide matricola2; hide chiuso; show infochiusura; } else { show Nome; show Cognome; show email; show matricola1; show matricola2;
How to add '&' in Zoho creator with API REST
Hello I would like to add a record with a & or a � : if you put directly in request it does not work (error which is normal)... if you put data in CDATA nothing is add to Zoho. How should I do ? Thanks for your answer Best regards
Value in dropdown based on value in another dropdown
Hi I would like Zoho to set a dropdown to a certain value based on value selected in another dropdown menu. How can this be done! BR Dennis
Performance in "edit mode"
Hi Within the last 2-3 weeks I think the performance of the system has decreased a lot. My own band witdh is apprx. 1-2 Mbit so it should not be a problem. It takes a least 2 -5 min.(if possible) for me to go into script builder. If I get into the free script there is no problems. BR Dennis
Form not displaying in IE6
Hello, http://creator.zoho.com/showForm.do?formLinkId=15&link=true&sharedBy=rajivraj throws js errors in IE6 and doesnt show anything. Am using this form in a live webapp so I hope you fix it sooner. Rajiv
Related Fields not in arguement list
Hello: I am attempting to follow your instructions to send email to a group of records in a view. I have created the function and am now attempting to assign the fields from the view to the arguements needed. But it only lists the field from the primary form that the view is based on. In this case the email address is in another connected form (table). I have added the columns I need to the view but those added columns don't show up in the list of fields when I am assigning the arguement. Thanks
Edit Feature
When updating records in Zoho Creator, it would be nice if the edit feature were available with the summary view as it is with the list, spread sheet, and calendar views. Thanks, Hugh admin
Filtering Dropdown
Can you please help me with the right syntex using the following as an example: form FormB { IndianStates ( type= picklist values = FormA[Country == "India"].State ) } Instead of a fixed string value eg "India", I wanted to refer to a field on FormB called States. Cheers, Martyn martynhale
Firefox 3.0 does not display images in embedded web page
On testing Firefox 3.0 with my application (webpage with embedded Zoho database), the images that were being displayed in Firefox 2.4 no longer appear when I am logged out of Zoho. The application can be viewed here www.edinburghrc.co.uk/about/equipment/equipment-inventory Any help with correcting this would be most welcome. Regards Graham
Urgent Issue: Form submission not completing
Hello, http://creator.zoho.com/rajivraj/ist/form/15/ All was ok until I copied IST to create WST! After this, the form submission every ends though data is submitted. FireBug says _80 is null showFormSubmitMsg(Document , [], [])zohocrea...orlive.js (line 513) (?)()()zohocrea...orlive.js (line 4462) [Break on this error] _80.innerHTML=""; I deleted the copied app (WST) and still the same error. I launched http://www.smartwebworks.net/IndianStartupTimeline/ and Boom! this error pops out a hour after
Urgent Issue: Form submission not completing
Hello, When I try to submit a form http://creator.zoho.com/rajivraj/ist/form/15/ .. Data is submiitted and user never gets a confirmation. _80 is null [Break on this error] _80.innerHTML=""; There was no problem until I copied this app, IST to another app! I deleted the copied app too. I tried creating another form http://creator.zoho.com/rajivraj/ist/form/23/ but same problem. Request you look into it asap. I announced my app @ http://www.smartwebworks.net/IndianStartupTimeline/ and within an hour
forms
can form data be emailed to me? i just cant see that option chris
Help debugging error 2830
Hopefully someone here can help. I'm using Zoho Creator & the API to insert some data into an application. All seems fine - accept when i attempt to add this value <field name="referrer"><value>www.centralstation.com.au/search/results.asp|cx=000956394664824970001%3A0izazm-6ft4|cof=FORID%3A9|q=wild volume 15</value></field> I get: <response><errorlist><error><code>2830</code><message>XML document structures must start and end within the same entity.</message></error></errorlist></response> if i remove
Google Analytics errors!!!
Hello, I have embedded to views on my webpage and I get 6 js errors which seem to be Google Analytics related ones. 1. viewArr is not defined 2. missing ) after argument list [Break on this error] var gaJsHost = (("https:" == document.lo...pe="text/javascript"%3E%3C/script%3E")); 3. _gat is not defined Since I have 2 views, I get 6 errors. Eagerly awaiting for response
Hide fields on embedded form
Hi I have created a form which is being embedded in my site for people to fill in. I have 3 fields on the form which I don't want them to see, as they will be completed afterwards by myself. I chose "hide this field to others" when adding the fields, but they still show up on the embedded form. Is there anyway to hide them on the embedded form so that when I login I can then update them? many thanks
How do I import data from Excel into a new Creator app?
Hello, I recently created a new application in Creator. I would now like to upload data from Excel tables into the database. I cannot figure out how to do this. The only information I found in help is that you can upload a spreadsheet to start creation of a new app, and I did see a post from someone else about emailing data for upload. Is it possible to upload to an existing app? If so, can you provide me with instructions? I have multiple forms/tables in this application. Thanks very much!
look up date
I've been trying to do this for almost 48 hours and I'm having no luck. I have two tables - Position Details and Time Policies. The PD table contains an employees hire date. The TP table contains a form field entitled start date. I am trying to populate the start date field with an employee's hire date from the PD table. What am I doing wrong?
how to build a record index code?
Greetings, I'm trying to build an index code for each record in the database any help someone can provide will be MUCH appreciated! The solution could be as simple as incrementing the number in the last record of the database by one. Ideally, I'd like to build an index code that starts with the the day, the month, a letter, then a 5 digit incrementing number. But I will settle for the simple incrementing number as well. So it looks like this "0701a10004", using today's date, the letter a, and the
Show view results
How I make for menu off in view results? I want show results only. eduardogotardo
2 fields same input
first of all great product. Second since I am pretty knew to the creator, its kinda hard using the codes. My problem is with this: I have managed to create a dropdown field based on a selective entry from another forum. But My issue is to make a normal text field along with the dropdown field which updates the same entry in the database. Like for example within the dropdown if I click others I should be prompted / I could input the details absent in the dropdown. Inaddition, will it be possible for
Bandwidth on the paid versions
I have two accouts, one is free and the other one is paid ($25/Mo account), both accouts are planned to grow big time, because they are used in two worldwide Christian directories (one in English and the other one in Spanish). www.ChristianMembership.com www.ContenidoCristiano.com My concern is that later on there will be a lot of worldwide traffic to these sites, and the databases will be huge. At this time I can't afford two paid accouts, and I considering to merge the two databases into the paid
Link in Formula field
I'm trying to make a dynamic link in a formula field. I have read this post forums.zoho.com/viewtopic.php?t=139273&sid=4279a2a4bcd58ae31792162a5d1d751b After read this post and similar the way is perfectly explained. Well, I'm going: I make a formula field. I put this code (very simple link to try if works): "<a href='http://www.google.com' target='_blank'>Detalles</a>" or "<a href='http://www.google.com'>Detalles</a>" In the view, in the formula column doesn't appear "Detalles" like a link name,
Decimal Places
How do I make the variable [Gross_Margin] in the example below, calculate to only 2 decimal places. The field is a percentage set to 2 decimal places, however when the calculation is performed the value is many times greater than 2 decimals. The problem is, when I edit a record and try and save it, I get an error message saying round up to 2 decimal places. //input.Gross_Margin = ((input.salesvalue - input.costvalue) / input.salesvalue * 100); Martyn martynhale
found a bug:
it appears that I cannot add criteria to a picklist :( i am trying to show a picklist of all form1.Title where form1.Copies_Available > 0 so, in the "Set Criteria" box, I type (form1.Copies_Available > 0) and it says that the thing is saved, but then I go right back and there's nothing in the box please fix this! thanks! pbh101 pbh101
Access to an application without a form
How do I provide access to a database application I would like to create without any type of form? Not clear after spending some time on this how I would go about doing that. Thanks much, -Chris cross
Bug in embedded form after submit
Hello, http://www.smartwebworks.net/temp/addevent.html If you try to add a record, after click of Submit the formatting is lost! The same form @ http://creator.zoho.com/rajivraj/ist/form/15/ losses the formatting too! Please suggest.
Change Date Format
I am trying to change the format of a date field to mm/dd/yyyy. I created a function to do that string dateformat.ChangeDateFormat(date inputdate) { mon = input.inputdate.getMonth(); dat = input.inputdate.getDay(); year = input.inputdate.getYear(); outputstr = mon + "/" + dat + "/" + year; return outputstr; } and this script: thisapp.dateformat.ChangeDateFormat(input.Purchase_Date ); But it doesnt work Can you help?
"Hangs" forum submission
Hi, My Creator forum suddenly is not no submitting; It just "hangs" upon submission. It was working fine yesterday when I implemented. Please help! To help you debug, I've change the app to a PUBLIC one, but when I tried to give support access to this app, I also got an error message "Error occurred while providing editing access to support". My app link is -> http://creator.zoho.com/liuiwa/copy-of-sharewor The form is in this site > http://www.shareworld.org/signup.html Thanks
New user set-up
Planning to have business clients which I will set-up to share application I've created in Creator. Have found on testing, that when I set-up a new user and select Send Invitation they receive an email from my admin email address, which is what I expect and want to happen. What I'm not clear about is why they would receive a second email, but this time from Zoho asking them to confirm their registration. If I'm going to be paying for my own branding I wouldn’t want my clients to receive an email
New user set-up
Can an application be configured in Creator so that: a) When a new user is set-up they do not receive an email from Zoho asking the to confirm their registration?, and b) When a user logs out of the application can they be automatically be re-directed to my home page, rather than the Zoho login page? Regards, Steve
Making 1 of many views public
Hello, I have 1 forms and 2 views. I want one of 2 views is as Admin and while the other as Public. I was able to make the form public while keeping the application private. Now, I would like to make one of the views public. When I goto the Share tab, select the view and click on the "Change" link, I am justed to creator home! Is this by design or a bug? Cant I have different views as both public and private? Thanks.
View customizing problems
I embedded the View on my web site and customized its look and feel. But after any action (deleting, sorting, etc) all customized settings reset to default. Could You fix this, please? Roman Ravve
mail registration not working?
I've added my login name and email ID into the registration form, but all I get is 'data added successfully' and no mail program. derrick.farnell
how can i change my admin email
Hello how can i change my admin email Thanks lauradelicato
Totals
I have a three querries: 1. Having just subscribed to Creator, is there a dedicated login screen, or do I have to access creator via the main ZOHO creator area? 2. I'm trying to invite a colleague to join my workspace. I've added him as a user but he doesn't get an invitation. 3. I've created a number of lists that display invoices and totals by month. However, I've noticed that now the list is >200 lines the overall list total (i.e. all months) has disappeared. Thanks, Martyn martynhale
Next Page