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?
Service Interruption?
According to my users and this http://status.zoho.com/, many ZOHO services are having issues. John M. Whitney
Fun With PHP
This may be obvious to some, but it's the first time I ever did this... If you have access to a web host that allows PHP, you can use Creator to post to a PHP page and send an email. Here's an example of the Creator post script: (the input.message is the rich-text field) MAIL_DATA={ "to_email" : input.to_email, "from_email" : input.from_email, "subject" : input.subject_field, "message" : input.message }; RES = postUrl("http://my.site.org/index.php",MAIL_DATA); alert RES; And here's my php form: Note
Example source code for PHP Post Method call to Creator Form (from PHP Command Line) - seems to work.
Hey all, after some happy hacking...I appear to have been able to get this working from a command line call like this... C:\PHP_TESTS>php testcalltoZohoCreatorForm.php ...the PHP seems to work OK whether from a Windows (XAMPP PHP) or Linux environment. Being able to do this is useful if, say, you ever need to schedule some activity, such as a nightly or hourly data transfer from one server to another. Thanks to some other forum posts, I was able to get this working from a HTML form (i.e. webpage)...and
Grid views values being blanked out
Hi, I had posted the same problem in August 2010. We have been facing this problem over and over again and there doesnt seem to be any logical reason. Can you kindly look into this problem again. Here is the description. I have a form A in which the name, registration number and other details of a student are stored. I have another form B in which the name, registration number are imported from form A and marks of the student are stored. I have a GRID view based on form B in which I use the lookup
How to control window dimensions in opened URL link from HTML View?
I have an embedded iframe containing a ZC HTML View, seen in-part here: I want the "More Info" button to open a new window containing another ZC HTML View, and the window is *sized* and preferably *centered*... i.e. a popup. But since ZC doesn't allow any Javascript, I'm at a loss for how to do this. Though the openURL() function does have a popup size parameter, it is an immediate-acting function... i.e. it can't be triggered by a click on a button in an HTML View, as far as I know. Anyone have
How to add a parameter to a Embed View in a HTML VIEW
My question is, how can I add a parameter into a Embed View. The parameter and the Embed View are in the same HTML VIEW. The code of my html view htmlpage Entidad_Comercial1(Identity) displayname = "Comercial Enterprise" content ... <div elName='zc-component' viewLinkName='EContacts' params='zc_Header=false&zc_Footer=false&zc_SecHeader=false'>Loading View...</div> ... In the EContacts I have one "Comercial Enterprise" field and I wanna show only the Contacts of the EContacts list when the field Comercial
Need row variable to be formed as a result of user input or as a result of an expression
Hi, I have a form and am using a for each record statement which gets assigned to getroomstatus in my form i then need to check each column in a row for a value, the column is selected by user input I can use if getroomstatus.column1 == free , if getroomstatus.column2 == free etc etc This works ok but i have have 50 columns to check better would be to make getroomstatus.column1 as a result of user input I tried whichcolumn=getroomstatus+input.roomslected but this does not work also tried whichcolumn="getroomstatus."+input.roomselected
Embed Uploaded Document In HTML View
I am trying to find a way of embedding an uploaded document into my HTML view, like using scribd etc. Can anyone help? Thanks, Damien.
Bulk Update - is it possible?
Hi, I want to add some new fields to an existing form and then update these fields for all existing records from a spreadsheet. Is it possible to do this type of Bulk Update somehow? Thanks, Lee
IMPORT and REPLACE
Hi. I think that Zoho Creator is a big step for all in building Great apllications. Bravo ! I would like to use it as a lead repository for my sales people and partners. (Channel Management) I would love to have the possibility to have an IMPORT and REPLACE functionnality This feature will help us 1/ "Export Data" in a spreadsheet, 2/ Mass change and Mass update these existing data, 3/ re-import my data and have them REPLACE the whole "old" record (perhaps we can do this if we provide the Record
Public Access pending
Hi, Good day, I made the request last few days ago, but now still pending, can kindly help me to solve this problem. Thanks, Calvin
Data base limitation
well, first a couple of quistion, what is the data limitation of a table in Zoho creator? how many rows and columns of information can I paste? I have being trying to create a table importing from excel but it crash every time, the excel sheet is 4 columns 10,000 rows, about 1.16mb. thank you, nice software! urena.jose
Questions about users and shared elements
Hi We have a professional plan with some users. When an added user log in a shared app, he has a message like "you are in free edition, we have special offer for you etc" : if he is included in my plan, why those messages ? If he creates its own app, what are the limits : the limits of my plan, or is he considered as a new (and unknown) "free" user ? Just another idea/suggestion about my users : when they go to their home page, they just see the (my) shared app. Is there a way to also display the
Passing a form to a function
I hava a same question; http://help.zoho.com/portal/en/community/topic/passing-a-form-to-a-function if I can use this feature to include returning form object from functions? thank you . on line waiting .
Calculating between two dates
So far i'm able to calculate the days between two dates, but is there a way where it can update the number of sick days the person has instead of it defaulting to the initial 14. For example I put in for Mike that he was sick between 14 and 15 and now he has 12 sick days left, is there a way where if I put that Mike has another 3 sick days it will use the formula from the previous email but instead of 14 it will use 12? This is the formula i have so far but i keep on getting a error message. i
Update field based on selection of lookup from another field
Hi, I am new at Zoho, and I am starting a new database. Right now I have 2 forms: Client and Call Log. The Client form stores all contact info: name, company, address, phone numbers, etc. The Call Log form will track all phone calls, emails and meetings with our contacts stored in the Client form. I have created the relationship between the two forms using a the Client Name field. Now what I want to do is have the Company Name field on the Call Log update automatically based on the selection of
Change in Field Position Failed
I am getting this error when trying to move a column in edit mode of a view. It says to try to refresh or try again later, any clue? IS this related to the slowness right now?
Insert html in multitext
When I click on the 'insert html' option in my form view, it doesn't give me the option to insert html; instead, it acts as if it's opening a window but never does. Any suggestions will be appreciated.
Upload Documents When Not Logged In
Maybe I'm just missing something, but is there a way I can create a form for non-Zoho users to upload documents as part of a form? I'm creating a scholarship application that includes an essay, and it would be much easier to have the option of uploading documents, rather than using a very large text field. Thanks, JP
setting up records that are based on other records?
Hi, please pardon my naivete in advance...I'm not the most fluent person in database-speak, although I do know the very basics. I'm helping my local tennis club set up a small database to track all our members. The complicating bit is, some of our members are "individual" members, and some are members in "group" memberships. For instance, I have an "Adult (18 and over)" membership, as an individual. However, a family of four people can join under a "Family" membership. In that case, the membership
Import Error
I'm getting 100% import failure and have no idea why. I don't see any other error messages. The preview looks fine. The fields are all text. I've tried Excel and CSV. How can I find out what the problem is?
Use of primary and secondary admin email
In Send mail task, it could be useful to be able to choose the email "send FROM" between the primary or the secondary email registered in the admin infos. Example : in temporary events where a specific (temporary) contact email is used to send mails, we have to set this temporary email as "primary"... Then the notifications af all the other app are sent with this "temp" address. Same remark for the forum (but not very important) : choose the email for the notifications. Cyril
Speeding up renedering of images
Hi I've managed to get uploaded jpegs to appear as thumbnails in my list view - thanks for the forum tips to get this done...BUT Even TINY 100px wide thumbnails take forever to load in, and I plan to have a lot of them in a list. I presume there is a way to speed this up a bit? Thanks for your help!
A new be question - Live update of a numeric form field
I would like to be able calculate cost for items and see the tax amount in a field and the total in a field, but I'm not sure hoe to do this, with out using the function field, the going to the view. cost - $100.00 --- I enter tax - 8.25 --- auto calculate total - $108.25 --- auto calculate thanks
how do i get a feild to react to another field
i see the "add item" option that allows me to select an item from a pick list based on an input into that field, but what I'm looking to do the same function, but insert the data into a numerical field. Similar to a spreadsheet. So I could say what the tax and total would be on a purchase for example.
Condition Display in HTML View
Hello, I am trying to create the Delivery Note after adding the values through Forms & HTML View. I am successful in doing so. I am facing some problem with - The HTML View on top is displaying Powered by Zoho Creator Logo, Can i eliminate it? I need to conditionally load values from record in the HTML view. Like if srno is not empty then only the html row will be display.Thanks. Umesh
How can I close automatically, a pop up after clicking on update or cancel?
I lauch a pop up by a custom action, to update record by record, i would like that the pop up closes after I click on upadte or cancel. Thank you.
Next Page