Making a number negative based on a drop down
Hi, Finally I have time to explore Zoho Creator. I am beginning by making an expense tracker, based on something like SplashID. In the date entry form I want to have a drop down menu named Direction, with two options: money in and money out. Below is a field called Amount into which I will type the amount I spent or received. I want to be able to type a simple (positive) number there. On submission, if the Direction field contains "Money Out" then I want the contents of the Amount field to be saved
How to make a search field
Is there a way to make a search field ? I want to clear a picklist and add to picklist only records that "contain" not egal, a string. Thanks, Pascal
Photos, tsv, word
Hello I�ve upload a image and now i export the data using tsv and using merging with word i would like to generate my own documents with the data that i exported but how can i do to display the image inside the word document instead of showing the url of the photo?
Creator Server Api problem
Hi, we have an application with some forms. We try to access the data via CSV API and it works only for a few forms. The sample code is attached to this email (api key and ticket hidden) <form method="POST" action="http://creator.zoho.com/api/csv/read/apikey=*****&ticket=*******"> <input type="hidden" name="CSVString" value="mec314,Domains, Domain,NotEqual,aasdasd,."> <input type="submit" value="Sumit CSV String"> </form> This should return all the records but the web services return this: <b></b><b></b><b></b>
Email With Product infromation
I am trying to build a function which allows me to generate an email template with all my product information in it and then email it to any one i want to how can i do this ??
Unable to access application
Hi, The following link it to an application created in Zoho Creator, which I now not able to open: http://creator.zoho.com/stevecad/business-survey-08/ Was deleting files from a form in the application which caused the application to lock up, and remain inaccessible. Regard, Steve stevecad
Please Help
Hi, i really found your site easy to use...but, once I try to embbed the code into my wordpress blog, it doesn't work. I'm copying and pasting into the "html" part of the post, but it just won't stick, or show... thanks marksmortgage
Problem with string!
Hi I have an application where the users use our form to log a request. The request i put into our intranet via permalink. It has been working properly the last month. But two employees now have a problem when filling out the request from the form. The error that appear on the 2 persons screen is as you can see from the attached. My appl. is MD Request system ver. 2.0 - you have the access to this. I have no problem with this form. BR Dennis
Does a whole app have to be either public or private?
Does a whole app have to be either public or private? Can I have a public form that is administered privately by my registered users? How do I set that up. The publicly accessible permalink seems to be depended on public or private status. domorlando1
User logout link?
I've got an application (the whole app in an iFrame - not just a view or a page) on my web page. When the user comes to the page, they log in. My question is - how do they log out? I need a link either in the app in the iframe or something I can put on my web page (not a link to Zoho.com as I'm trying to make this look "self-contained") that allows the user to log out. This is particularly important when I am demoing the app and have to log in/out as various users...
linking data and importing
I would love to be able to import data without paste function and have linked data update automatically. I am a performer and tour the US. I book shows and I would like my clients to see when I will be in their area. Right now the way I do things is to enter client info and booked show dates into my outlook contacts. I'd like to be able to link that data to my zoho database report. Then the report could be shown to possible clients. The customer would be able to do a filter or sort by area for when
Export data
Hello I start using this application and i�ve got just one doubt i would like to export the data in word documents but my own word documents or pdf files how can i that. I would like to create reports. Maybe i export to an intermediate state and the reexport? the applicatin is great!!! Borja
Accidentally Deleted Form
Is there any way to undelete a form? I made a horrible error by accidentally deleting a very important form. captainkirkf
Bulk add of user accounts?
For our app, we are trying to create a seamless & painless user experience - we don't want them to have to go to Zoho.com and create an account to access the app we've embedded in our webpage. Is it possible for us (the app owners) to add the users ourselves - all pointed to a single email address (ours) so we can create and then just send out the login info? This is pretty crucial if we try to add large volumes of users.
How do you make a task disappear in script builder
I made a project management app. However, I can't figure out how to do something: I want to be able to click a "completed" decision checkbox and have the whole record turn red in the master view and disappear from other views. This is probably relatively simple, but after studying your documentation I cannot figure it out. Seriously, Gentlemen, you really really need better documentation on the script builder. Thanks, Coco Soodek cocosoodek
Missing fields
I keep losing fields, specifically notes, that I put on,. iainfletcher
Many to many relationship application
Hi, I was wondering if anyone could share with me whether they have managed to incorporate a true many to many relationship with a junction form/table into a creator application. I would be very grateful if you could share it with me or give me an example. Can support suggest anything? TIA, John
Analysis of entries
Thanks for your help on this. We are nearly ready to release this quiz but would like some analytics. What we'd like is a) number of entries per day/week per country (in a graph) b) country with highest number of correct answers per day / week (in a graph) c) users/email addresses with the highest number of correct answers per day / week (in a graph) I cannot seem to get the date working correctly (i.e. to set the date they entered the quiz) at http://creator.zoho.com/faheyr/sap-quiz/ Thanks
Import of data which includes uploaded files
I am attempting to switch everything I have in an app from one user name to another (I created it under my personal account, and now the app is being transferred to another account for deployment). A few of my Views have data from uploads (Word documents and image files). When I import it in any format (XLS, CSV, etc.) the fields which contain links are now populated by links to nothing, and the empty fields for lines which have no uploads have the same. How do I import all of my data without having
�Bulk Edit� problem
Trying delete around 20 entries in the view, using Bulk Edit, accured an error �Requested URL is to large� and deleted ALL entries in this View and forwarded me to �Home�. This happened already more then ones.
price details.
please let me know the pricing to remove powered by zoho logo in indian currency.also let me know the procedure ofpayment.is it bank draft or online transfer or cash etc. sendnearn
Operators for Average, Standard Deviation
Does deluge scripting have any type of operator that allows the calculation of averages or standard deviation? I'm hoping there is something like avg(input.variable_1, input.variable_2) that I can use...
Updating records in list view with > 200 records
When I update a record in the second view page, I'm bringing back to the first view page. Even if I update a record in a filtered list, than I'm bringing back to the complete list. Can you suggest any solutions to update more easily records in long list? I can't use "Bulk edit" becouse every record need different update. Thank you Lucia
Edit records using forms
Hi, I use forms (embedded in my blogs) to gather some data, say Eg:- Name , place , Date of birth I enter 10 records ( some have the place or DOB missing -- to be entered later) If i need to edit existing records.. i am using the "View" ( at creator.zoho.com) Would it be possible to pass query using forms and retrive records and edit them, without having to use the "view".. I am still learning. Please help me understand
Question
How can I adust the layout of the Forms so that when I embedd the script in a website the width changes. Also the length of the fields on the Forms need to be adjusted, eg., the State (Arizona, ie, AZ) should only be 2 characters long. Lastly, why are there 2 sections on the Creator form screen where the fields are place. Thank you. George gpolzer
Zoho creator
Dear Sir/Madam it seemed like a great program, but certain features explained too quickly. how do i create email notification every time someone submit the online form? thank you thank you thank you!! dror steiner drorsteiner
set url value with deluge
I have a form with this fields: Number Link (url) I'd like to set the value of Link to include my Number. Here's an example: Number / On user input : Link="http://www.sample.com/" + Number + ".html" It's not working. Is there another way to do that ? How can we edit the other properties like "Link name", "Title" and "Opens in" in Deluge ? Thanks. Pascal
Membership list with member access for updating
Hi I'm looking for an application that will allow me to store all the details for the members / families in my not for profit organisation. I would like each member / family to be able to login and update only their own information. Does anyone know if this is possible? I wouldn't want to go down the road of setting up and paying for individual zoho users as this would not be cost effective for us. If any one has written such an application or scripts then I'd be interested in hearing from you. Regards
Zoho Creator
Excellent !!!... Well done. Nothing more to add. info
Creator Question
The above tmueller88 was the creator of this online entry form for a website he created for me. Is there a way to change it over to me since I am now the administrator as well as owner of my website? If so, how? Also, when someone comes to my website and makes an inquiry, can the ZohoCreator form be set up so that the information (name, address, phone, etc.) is emailed to me rather than an email only saying that an inquiry is made? Currently I have to open Zoho and fish out the information. Thanks,
Help me please sum and formula field related
Hi, please help me do this, there are similar threads but not exactly what am trying to do. Am building a very simple purchase order system and the form needs to collect a few item fields, but the problem am having is when am trying to place a field with the result of multiplying item1.quantity*item1.unit.price how can I obtain a result of this operation in order to be able to later get the sum of (item1.quantity*item1.unit.price)+(item2.quantity*item2.unit.price). I can't use a formula field here
Concatenate multi-values in a variable
I have an application where a Product must be assigned to one or more MarketSpaces. In a second form, I make notes about products and want to relate a Product, with a MarketSpace and Notes. For example, a Tivo is both a DVR and an HD-DVR and the note might say "Market leading DVR." To add MarketSpaces, I created a form to enter them. To add products, I set up the input form with a single line for product name and checkboxes for market spaces. To add a Note, I created a form that uses a PickList for
Email on Edit
I would like an email to be sent when a form is edited and the body of the email to contain all of the form data - just as it does when the email is sent when the form is originally added. Please HELP Thank you, Jeffrey Rothchild jrothchild@proformapeak.com jrothchild
Getting e-mail to work on update for new field on old listin
I have an application with a lot of data. I added a new field a couple of days ago, and I want an e-mail to be sent out when that new field is updated to the status "yes". The e-mail seems to be working fine for new records, that were entered into the database after I added the field. However, the e-mail does NOT work for old records when I set the status of that new field to "yes." Any ideas how I can make this work for old records too? sharonm
View only current record
Hi, How can I create a view in Zoho Creator which shows only the current record. Can this be done by setting a criteria, or using a filter? Please advise. Regards Steve admin
Bug with Creator
After adding a Note and then editing the Note, it disappears from the application. In the editor, if you roll over the area where the Note was, the Ecit Box appears. When you open it, it's empty. The only solution is to start over. michaellamb
Passing search parameters to ZC via a URL...
I'd like to be able to screen-pop from my VOIP softphone, which has the ability to call a URL when a call comes in, for example: http://thedatabase.url/phonenumber=caller where "caller" is substituted for the caller's phone number at runtime. The resulting HTML is then displayed in an embedded browser window. Is there a way for getting a query result (for example a customer record search by phone number) to display by such a method using Zoho Creator, e.g. passing parameters in a url string? (I'd
How to add a newline into a string?
I have a multi-line text field for a little todo list, coupled with a single-line text "update" field. Example: Can you call Dan at ABC plumbers on 12345678 re: the leaky pipe? Called Dan - said he'd be available to visit tomorrow. This update field has an on user input event that is meant to add the update text to the main todo field, so I have a history of prior updates. However, when I add the field with the + operator it doesn't add a line, it just concatenates the text straight on the end: Can
Cannot update records
Cannot update records in form. Get the following error message: [t_169439000000025173] null, message from server: "Duplicate entry '' for key 3" Failed to Update Data. stevecad
online entry form
can i create an online form to collect data, go straight to my zoho database, and then run reports off of that, and provide the reports back online? i have figured everything out except how to get the online data to go straight to my zoho db. please advise, clay clay.albright
Next Page