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
Importing Data
I'm trying to import data into my view and the problem im having is when i try to import into the date/time field the date part comes in correctly but the time doesnt. It gives me the time 03:00:00 for all of the records. And i tried using the migration tool but its not allowing me to upload my excel sheet into the migration application. What should i do?
Prevent double vote/submit from a single user
How do i restrict a user to vote/submit only one time ? i don't want that user to vote second time or third time . or how to make the form to be "invissible" for that user after he submit ?
form2 send data to form1 with count script
Hi, I can't find the correct script tu autonumber data filled in form1 with form2. Any help? Thanks, Mic on success form2 if (count(form1[Lugar == input.Lugar]) == 0) { input.Numero = 1; } else { highestMatchingRecord = form1 [Lugar == input.Lugar] sort by Numero desc range from 1 to 1; number = (highestMatchingRecord.Numero + 1); } if (count(form1[Numero == input.Numero.toLong()]) > 0) { rec = form1 [Numero == input.Numero.toLong()]; if (input.Numero == null)
How can I force CSV export from creator to ALWAYS use double quotes around data?
I would like to export to a CSV file and have all my data fields be double quoted. Is this possible at all? normally the fields are only double quoted when I have a comma within the data itself. thanks!
Mobile Creator Not Allowing Date/Time Selection Drop Down
Is there a way to get the date/time drop down to work on mobile so I do not have to hand type in date and times? Do scripts work, if so maybe I could add a button that fills the current time into those fields.... Dominic
Row number
Hi there, I have created an app to record and sort pupils scores on various activities. This is a link to one of the views: http://creator.zoho.com/seb.slater/global-gamez/view-perma/M_Sprint/evYz1qvRD6QsNmRG8904h5jU0DQDhZf7s5BmmGuMgKfksqgN43SVY5BK8g4GaukmVj2Z9BJYVsmAVN6683zWfKwB5DD1FMNXkJhQ I want to sort the results by 50M Sprint (lowest to highest) but not to 50M Sprint column but instead show a ranking as a row header. can someone help me please? I am new to zoho creater and have little coding
Formulas that reference other formulas
A newbie question, After trying and failing to reference a formula field within a form, I read in the FAQ that this feature is not supported. It seems kinda surprising since there a variable declared and available in other forms, but I guess it creates some sort of timing issue. Is there any chance that this might get a look-in for future releases. Or is this an old chestnut that's not going away? cheers
I want to get the data from zoho reporter and get the data in list.
I am creating a function in Zoho Creator. In function, i want to get the data from zoho reporter and get the data in list. How this is possible ? Code is : ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=<your username>&PASSWORD=<your password>")); ticket = (ticketDetails.toString()).subString(((ticketDetails).indexOf("TICKET=") + 7),((ticketDetails).indexOf("RESULT") - 1)); query = "select * from Products";//Sample Query url =
Reorder Radio/Dropdown choices
You should be able to reorder the display order of Radio/Dropdown choices in the Form Editor.
Embedded Form - Move to another page on success - send an email with attachment on success
I have built a form - lets call it a survey - a list of questions. I embedded the form in my website. Worked great. On clicking the submit button (on validation) I have an email form that is sent. Still good - got it to work. Two requests: - first, I want the viewer to be moved from my page with the embedded form to another page on my website - a success message. -second, I would like a pdf copy of the information submitted on the form to be send attached to the email sent to the party completing
API Ticket Question
Hello. I'm new with Zoho so please excuse my lack of expertise. I have created an iPhone app, which is subscription based, and am looking at using Zoho to track licenses, logins, etc. I have created a database on Zoho, and have successfully added records from the iPhone app using the Zoho API. My question is with the API Tickets - They only last a week I understand, yet it is needed for the iPhone app to POST with the API. Right now, I have the license key and ticket hardcoded into the app. However,
pick names from list to create a new set
Hello, I came across with Zoho today. Looks very fascinating. I am having an excel list consisting of membership information (names, address, phone, etc.). I want to pick from this list some names, and create a new list ....it should be simple, but can you please help, since I am newbie, and do not know coding. Thanks in advance!
Zoho Creator data stored in Amazon S3 or similar service
Is there a way to create my application with Zoho Creator but have the data stored in Amazon S3 or similar service?
Next Page