Any ideas on how to get around the restrictive record pricing?
I need to build a couple simple applications for a handful of users. Unfortunately the pricing for additional records makes this project a nonstarter.
Solution Needed, Please
I am looking to create a form where people can preregister for an event. The idea is for the person to select a team for that event. Once they select a team and submit the form, they will, as an example, take up one of the slots for that specific team. When the 11th person tries, because only 10 spots are allowed, they will get a warning asking them to select another team. I also want to be able to blow away all of the registrations for that single event, and start over each month. Each month is
Show only columns of the current view while editing?
Hello, I want just to show the fields of the current view when editing. How can i get the info which view is displayed? Thanks in advance. Markus
disabled Text_Area
hi can u help me i want disabled Text_Area2 or enabled Text_Area2 if i write in Text_Area1
HOW TO GET CONDITONAL VALUE FOR A FIELD
Dear All, I have one Form in which fields are as Name, State, Mobile No. etc... I have done successfully 50 records. Now I have second form As Message in which fields are State, Message, MobileNo First I have select State as Maharashtra, After that I want MobileNo (Text fields) as 9876543210,900000000,800000000 etc. How to get in the value of field MobileNo. for State = Maharashtra in the New form Message All Mobile = 987654321,9000000000,8000000000,7000000000,6000000000,5000000000,4000000000,3000000000
Dates and Days
im trying to write a script where if a persons joining date is 2/18/2011, six months later they start accuring 1 vacation day each month. So far this is what i got: dateDiff = input.Date_of_Joing - zoho.currentdate; If (dateDiff < 180 (refering to days) Number_of_Days_Available = 0 else Number_of_Days_Available = I dont know what to put after that
Send an email with from View A with details in View B...
Hello there, I hope Someone can help me, I'm trying to develop an application which main function is send available consultants, in oder to do that I have a Conctact Form where we have the comercial contacts with an email field. Then I have another form where we are putting the Available Resources and their skills and what I want to do is send this available resources to our contact list. Forma A: Contacts (with email info) View AZ : List of contacts , on this view I have generated a Custom
More decimal places
Hi, How do I change the settings to enter/get more than 2 decimal places in calculations? Thanks!
How to fetch data from 2 forms in HTML
Question about fetching data... I have 2 forms - called "Customer" and "Purchase" Purchase form has a lookup field for my employees to enter in Customer name (if already in Customer form), or enter in a new customer. When Purchase form is submitted, an HTML page is opened from which we can print out a sales receipt that the customer signs etc. This HTML page has data fetched from the currentRecord (for Purchase), but I would also like to have it put the customer information (their name, address,
Have date time field, want to set criteria on only date
I am trying to set criteria "today's date" using a date-time field. Anyone have any example code?
Accrue Days - PTO
Is there an calculation i can use to accrue days such as vacation days. For example, after 6 months of employment and employee can get 1 vacation day per month.
need to auto update field when date expires in another column
First let me say i am a newbie to this application and to writing script. so please be explicit. I have a field in my application (named expires_on) that holds an expiration date, I also have a field that is a check box (named active). The Active box is NOT checked by default and will return the answer of NO when checked. I only want text in the Active field that states NO. I need script to make the check box automatically check itself when the expiration date has passed. thanks
Completed forms LOST, i.e. do not get emailed to designated email!
I have created and successfully embedded a form to our website. Upon testing that it works, I completed the form on three occasions and have yet not received the completed forms to the designated email. When answering, please note I am a "website DIYer", i.e. not familiar with code but found it relatively easy to put together the form and embed it. Any ideas as to how I resolve this? PS. The form can be found at: http://www.catcuddles.org.uk/6.html
Import updating existing data : pb with "else" please !
Hi all, I know that importing data today is just to create date, not update. Will you (soon?) developp this feature ? I do need to import data matching for example on ZohoID or any another field (formula field witch concatenate several fields could be useful too). We also should ba able import data into multiselect fields, where data are separated by , or ; Waiting, can you propose us a script to do this please ? Thanks Zcreator !
Maximum size of a column cannot be reduced
I am trying to update a form via the Form Definition page, but I get the following error message when I try to save the script Error modifying the page Maximum size of a column cannot be reduced, when the table is not empty -- tableName : t_116668000000015301 -- columnName : City_116668000000015428 I am not even trying to modify the "City" column. How can I resolve this?
How can i attach an iframe in my Form?
Hello Respected Members of Zoho. I am in trouble, i want to add an iframe with my form. i am use Add notes field for attach an iframe in form but i seems it doesn't support iframe option. Like i want to add iframe in my form. So users didn't go anywhere for getting any information, also in another window or another page they get their information in my form. just take an example of iframe option:- <iframe src="http://www.w3schools.com/" width="100%" height="300"></iframe> Please provide me solution
Why can't I control the view column widths?
Creator seems to ignore my column width settings (n pixels or percents) for a view. The view definition is shown below -- do you see what I am doing wrong? list module_View { displayname = "module View" show all rows from module ( Title ( width = 200px ) Description ( width = 300px ) URL ( width = 100px ) Keywords ( width = 100px )
One field Form1 - Many fields Form2: View a list?
Hi all! That's my brief doubt: I'm creating a database for my phd research. I need to record the title and name author, the important quotes existing in the text and a "keyword". Example: The Lord of the rings, Tolkien, " And then Sauron....", Middle Earth enemies. I designed it like this: Form 1 -- Fields like Title, Author, Edition, Number of pages ... (Bibliographical data) Form 2 -- Field Keyword Then in Form 1 I put 10 Rich text Quotation spaces (Quotation 1, Quotation 2,...) and the correspondent
Set grouping "by exact value"
Hi ZC I'd like to group data from multi-select fields. When we set a group, the data are grouped according to the checked values, separated by coma : exemple on checkbox field with colors : --- blue, white, red (where data displayed are those tree colors) record blue record white record red --- blue record blue --- blue, red record blue record red Is it possible to set a "group by exact value" to have this : --- blue record blue 1 record blue 2 --- white record white 1 --- red
Popup size
When viewed with Internet Explorer 8, all my html popups are cut off on the right side ("Close" is only partly visible). I call the popups like this: openUrl("#View:Testview", "popup window"); Even a dummy html view like this one doesn't display correctly: htmlpage Testview() <%{%> test test test test test test test test test test test test test test test <%}%> Thanks for your help. Filip
Problems with Importing Data
Hello, Problems I encountered in importing data from the view: 1. It also add trash data into the source of my look-up fields. I just remove them manually to avoid delay. Ive been experiencing this since i started importing data. 2. But just today, I could no longer import data. We are approaching dabbledb closure. Hope Zoho can attend to this asap. Thanks, Edith
Date Picker - On User Input
I am using two date fields to update the number of nights between the two dates using the On User Input command. Check In: Date Input Check Out: Date Input Nights: Calculated; Disabled input I have error messages and defaults based on upon the user input (e.g check out <> before check in, check in !<= current date). My problem is that when the user selects the date using the date picker. As they scroll through the date and try to select a date the application is triggering these messages before
Creater view color and layout
Good evening, I have two questions that I have failed to find the answers to in the documentation. Any help would be greatly appreciated. 1. I have a view that I have embedded in another website. I would like to modify the colors to fit the colors of that site. I have tried the commands at https://help.creator.zoho.com/Style-based-URLs-for-Embedded-Forms.html#6._View_Customization . Some of the commands work, but those that are intended to change the color have no effect. Anyone knows what I am
Can you use cURL, REST or some method to script file upload?
I am migrating some applications from Dabble to Zoho Creator and the migration tool only migrates the text data, not the attachments. I tried using cURL and a public version of the form I created to POST data to the application, but I could not get that to work due to there being javascript and several other forms on the same public form page. I tried the REST API but again could not upload files. Is there any way to script the uploading of files? My client has thousands of attachments and they can't
Help with Date Time Function
Just subscribed to zoho paid subscription. Thanks! I found this post in the forum, is there an example application that uses this function? This would be really useful for my customers. What are some good resources on how to use functions? Trying to get it so that customers can schedule with dd mmm yyy AM/PM and have that converted to date:time that deluge understands, then be able to add one hour week ect for the end time based on their choice for calendering purposes. Is it possible that separate
Lookup list not sorted
I'm using a lookup field to a table with 355 records. Even though Show choices in alphabetical order is checked the items are not listed in order. Approximately the first 200 show correctly the rest are random. I did add another display field under Advanced display options but then took it out. Is this a known bug? Herb Wexler
Firefox 4 support
Firefox 4 was launched, but unfortunately the most advertized Zoho Creator part - fields drag and drop - does not work on this much improved version of Firefox. So I would be very happy if this aspect will be solved soon, even if maybe the full official support for Firefox 4 is a long term task. Is there a chance that at least the fields drag and drop in Firefox 4 to be supported very soon? Regards, George
Relationship between forms/tables
I have two forms, one is CustomerInfo and the other is Memo. The customer info is made for such as name, phone, email, ect, for every customer. I then have a memo form that keeps track of every message or phone conversation that goes on. Both forms have a field Customer ID. When I look up a customer from the field CustomerInfo, I would like the capacity to see all the phone conversations from the Memo field. Also be able to add a new memo for that customer. Any way I can do that? I have "subforms"
Invalid Entry Key 2
I'm getting invalid entry key 2. What's wrong? I double-checked my applications and took out the double entries setting. Help!
Update for challening problem
couldn't edit my previous post for some reason did more work on the database ap Test the question I have is written in red Gaev built a text to string and back to date:time function/expression, wondered how to use it for my application
How to let user to see a record ?
hi, i want to embed a record view into a site but i do not want the user to delete or modify the records , just to view them . it is possible ?
date/time
I am considering building or hiring someone from the marketplace to build a time sheet for my business. I have build some sample forms, but the "Date-Time" field seems really hard to use (from the user's perspective). You cannot type or select the time in an intuitive way, and it seems to be in a 24hr format. Is there a good workaround? The date function is fine.
Using external API
I am trying to send a post request to an external api but cannot figure out how... DS keeps giving me error messages. is there an example of how to do this? Thanks, Damien.
Australian Zoho Creator 'people'
Hi, I would be interested in speaking with others in Australia who have experimented with, or are developing, with Creator. I am especially interested in integrating with Zoho CRM, and soon, Zoho Invoice. I am emailable at liamzoho2@zoho.com. Best Regards, Liam
Hitting "Escape" clears out data from Creator Form
Has anyone else seen a case in Zoho Creator where if you hit "Escape" in a form it clears all data?
File Upload Issue
When I use a file upload button in my form, it tries to get someone to select a document from Zoho docs. The form is public, so I'm not sure whey they can't upload documents. Here's a link: https://creator.zoho.com/s_carolina/usta-sc/form-perma/SC_Tennis_Patron_s_Scholarship_Application/ JP
Very easy question (but not for me)
Hi all, I am going to try to explain myself as clear as possible. I have a list of clients in a table call “Contacts” with typical fields like “Name, Surname, Phone and email”. I have other list of visits that I make to any client, of course I can visit a client several times. I see that the “email” field in the “Contacts view” is underlined and in blue color, and when I click on it it opens the mail, resuming it makes an action. What I would like to do and I don’t know how to, is that
criteria
I have tab with users and user groups.Can I set criteria of some view( for another tads) for different user groups?
Update Deluge Language
Dear Sir, We bought Zoho Creator, but we found the Deluge Language is not enough (5000/Time) to setup our System. So can you help me to improve the limit of the Deluge Language to 10000/Time? How the payment?
Please Help Migration Tool Problem
Tried to upload this information to make a new application called Time using this menu option Yes I have room for one more application Yes I have .Net framework installed Only has two fields Text and Date:Time How do I solve this so I can upload my database with list of date:time and text field
Next Page