asap
Hi We're launching our database on the weekend, so I need a quick answer to this. When someone searches, there's an error, all the data goes away and the user is left without being able to do anything! The error says: "We are unable to fetch this data, sorry! Pleae note that your data is SAFE. Report to support@zohocreator" We CAN'T have this message come up with all the data gone and the database no longer working... Please advise. andrea sirman andi123
How to jump to another form 'on success'
Hi, Pls excuse this newbie question (and I hope I'm in the right place) but I'm trying to work out how to open one form after completing another. What I want to do is this: [list=] fill out 'New Sale' form On Success, open 'New Line Item' form with order number prepopulated (Ideally) On Success (of New Line Item), provide option to add another line item (i.e. loop back) or finish In this post I am particularly interested in getting step 2 to work, but more than happy to receive advice on step 3 also.
Time and Formulas
Is there a way for a formula to calculate duration when referencing 2 date / time fields? I have tried but the result is not displayed in hours and minutes, just some unrecognizable number.
How? Creator forms feeding data to Zoho DB?
I need to create a Creator app that will be published on the users desktops. I need people to feed data to a Zoho DB from that form. Is there a good sample script how to connect to DB for the record add?
Suggestion: Response to Scripting Questions
I truly appreciate how quickly the Zoho Team responds to the forum (in general). I has hoping to add a suggestion that might help accomplish two things... 1) decrease # of repeat questions 2) Increase effectiveness of users I notice that there is a personalized response to individuals asking question about how to create a specific set of code. Unfortunately the solution can be too personalized and decrease the effectiveness of the "Forum" It would be nice if the scripting solution was shown in a
cannot see a shared app
One of my users cannot see an app I have shared with her. The app is http://creator.zoho.com/cambridgemta/trademaster I have shared it with Customer Support. The user is claire.hsieh Password hwt801228 Interestingly, although she cannot see the app in the shared apps area, if she types in the URL of my app, she can still access it. Please check why. Thanks
Get the 1st three characters out of a text field?
Hi, Please advise the code of how to get the first 3 characters out of a text field's value. Thanks.
ZC wil not show certain attached document!
Hi I have a ZC appllication where ZC cannot open the attached document! It is my application AFB system the ID on which the document are attached is no. 35901000000995173 Could you please help me on this BR Skouboe
Application details are not viewed on market place
Dear Harsha, I discussed this issue with you on phone, that my application "Abhilakshya Placement Services" is not showing it's proper details, which i entered on market place. how can i solve it. Please tell me. Abhinandan Sharma apsplacements@gmail.com
Requester's Details
Dear Harsha, I published an application "Shiva global tech. Pvt. Ltd." in sales option. It's a paid application and i got my first request for same. But i don't have the details of that person to contact. If i want to have the details of application he want or changes he need how can i contact him. More or less, how will i retrieve my payment. Please tell me. As it is very important to have full detail of your client to sell anything. Either it's me or you. Please help me in that. Somebody is interested
filter dropdown list
I have a list of about 150 names. On a transaction form the user uses a dropdown to select the appropriate name for the transaction. With this many names it is cumbersome to find the correct name. If a few letters can be entered in the field before clicking on the down arrow then only names containing those letters would show on the list. If an exact match is found then the dropdown list will not show and the focus will go to the next field. If this is not possible are there other suggestions for
Dynamically Adding Items to a Picklist
Hello, I pasted the following code into free flow scripting, as directed on the Zoho help page with the same title as my post: Country ( type = picklist values = Country.Country_Name sortorder = ascending on user input { if (count(State[Country_Name == input.Country]) == 0) { clear State; } else { for each state_list in State [Country_Name == input.Country] { State:ui.add(state_list.State_Name); } } } ) and received the following message when I tried to save the script: Encountered "=" at line 4,
BUG report === SOS
hi , I created a form and added a NOTE at the bottom which is ok then I added an additional NOTE at the top of the form. here is where the bug starts. 1. when I view the application - the note that shold have been at the top appears at the end of the form, at the bottom. 2. when I edit the form - the bottom note is invisible and seems to be vanished. and all I see is the top form .- located at the bottom. sometimes I need 2 note fields in the form 1. for introductsion 2. at the bottom for clarifications
exporting data
I sent this morning a querie about a problem that I have exporting my data but didnt give you guys enough information. When I try to export my database this is what I get.. < Internet explorer cannot download (the files name) from creator.zoho.com. Internet explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later > How can I export this data? Thanks Alvaro gcisbj
View's filters are not sorted.
How can a view's filter drop-down be sorted? tonythomas
Custom Action behaving erratically
I am using a custom action to jump from a record in a View to another View. It works for the most part, but sometimes the Action executes correctly but the other view doesn't display. If I close the browser and re-open it, it may work well on the record which previously didn't work but not work for one where it worked earlier. Any suggestions? gabriel.coch
Calculating daily totals from cumulative totals
Summary: I want to subtract a previous day's numeric field from the current day's numeric field and display the result in a column in a view. The catch is, I do not want this based on the record ID or even the built-in add date Zoho pulls - I need this based on the Date field in the form. Details: I need a daily record of activity for several different web properties, that can be exported to excel and/or viewed as charts. So I have created a form (Activity_Entry). While it should be submitted every
File upload via Zoho.writeInput
Hi there, I'm working on a html form via the following tutorial: writer.zoho.com/public/help/creator-client-api/fullpage Everything goes fine except the file input. When I do the following nothing appears: <td><script type="text/javascript">Zoho.writeLabel("Copy1");</script></td> <td><script type="text/javascript">Zoho.writeInput("Copy1");</script></td> Is there a way to put an input file to the form? Thanks in advance, Greetings Roudy
Currentdate
Good morning, I REALLY hope I am not repeating the subject, but here it goes. ---- list Novembro { show all rows from Tarefas [((Inicio > '01-Nov-2008 01:00:00') && (Inicio < '30-Nov-2008 23:59:59'))] ( Inicio as "In�cio" Fim Tarefa Utilizador Tipo_de_Apoio as "Apoio" Instrumento_de_Trabalho as "Instrumento de Trabalho" Local ) filters ( "Hoje" : (Inicio >= zoho.currentdate && Inicio <= (zoho.currentdate + '0W:0D:23H:59M:59S')) ) options ( display rows = 10 ) } ----- This is the view i have created.
�Filter params via URL?
Dear ZC Team! �Is possible to filter specific records in a embeded view or permalink adding filter parameters in the URL? Example: http://creator.zoho.com/userzoho/view/1/mEqgu5...Y12DtHUZnv7HYF4qJb/?fieldA="valueX" Thank you!
Do not store data in view if entry already exists?
I have data entered by 5 different people, if 2 users have the same customer the same day, each one of them is gonna create a record A and a record B for the same customer. In my customer database view, I'll get: Company x: -record A -record B and so on When record A and record B are the exact same... (Same cust name, same email, same telephone)
I love it
Dude this is the coolest site I have ever been on. I dont have any money otherwise I would have donated you. great work Dude. ashik.ratnani
Performance creating collection is slow
Performance is VERY slow. This simple code adds 20 seconds to the load time of a form. If I move this code block to a "On User Input" the form loads instantly. When invoke the code it takes approx. 20 seconds to run. Removing the sort does not increase speed of execution. Removing the criteria does not increase speed of execution. Repacing ui.add with simple string concatenation does not increase speed of execution. for each rec in Deals [DealStatus == "Active"] sort by Deal_Name { DealsList:ui.add(rec.Deal_Name);
Error on script
Hi I have the following to populate Name+Tel+Email IF Cust_ID is already in the database ELSE Name="0", Telephone="0", Email="0" if (Cust_ID == input.Cust_ID) { r = HD_INPUT_FORM [Cust_ID == input.Cust_ID]; input.Cust_name = r.Cust_name; input.toaddress = r.toaddress; input.Telephone = r.Telephone; } else { Cust_name="0"; toaddress="0"; Telephone="0"; } If the cust ID already exists it's working fine and all fields are populated, which is great; But if I input an unknown user ID I get a script error...
ZC 3.0 is slow!
Hi ZC Team Is ZC 3.0 suppose to be that slow? Every time I use the dropdown menu it is very slow! Before the choice in the dropdown is listet, it takes at least 6-12 seconds. In the old version it was there in an instant! BR Skouboe
Error In Edit Form on Detail View
Hi Support, Is there a way to correct the double Close buttons on the Edit Form of the Detailed view record? Please see attached for the error. Thanks. Jane
Grid edit problems
Editing records in grid view has been causing odd behavior - e.g. in a filtered (date == today) grid view, I edit a field that is not the date field and save - and the record disappears from that filter view, even though I have not changed the date. I have seen other odd behavior with sorts and filters when editing in grid view.
NEED DATA TO APPEAR IN OTHER DATABASE
I HAVE 2 DATABASE, ONE FOR MY CLIENT WITH INFORMATION AND OTHER WITH MY SERVICE, I NEED TO CREATE A LINK WITH THIS 2 DATABASE EX; I CREATE A LOOKUP FIELD IN MY ''SERVICE'' DATABASE FOR LINK TO MY ''CLIENT'' DATABASE, WHEN I ENTRY A NAME OF MY CLIENT IN MY DATABASE ''SERVICE'', I NEED THE ADRESS AND OTHER DATA APPEARS IN MY ''SERVICE'' DATABASE, PLEASE HELP ME SORRY FOR MY POOR ENGLISH
File upload - Permalink
Hi, What is the permalink of an uploaded file ? I'd like to see my uploaded images and pdf in the browser (without dowload). Also, I'd like to show thumbnail image in edit mode. I think that I be able to do that with the permalink, right ? Thanks Pascal
ZC does not show the Id no. in email
Hi I have a problem in one of my applications. When ZC is sending an email notification on "submit" I have set i up to show the id no. but my problem is that it only shows the text "<input.ID%>" I have used the scriptbuilder to create the mail. What can be wrong? BR Skouboe
Uploading XLS files to ZOHO
Hello, I'd like to upload an XLS files to zoho, I tried by Import data -> XLS but the collumns are not correct. I'd like to import the file and fill in the zoho columns with the XLS data. Thank you for your help.
Zoho form conflict with IE?
Hi there, Could you please help me how to fix this problem. My application runs well on Firefox web browser but it has problem with Internet Explorer. Is it script fault or not....? Thanks a lot,
Relation one-to-one: bug or misunderstanding
Hello! I have a question about the concept of one-to-one relation that can be used in forms. I will you use a simple example for my question; a system with members. Those members have only one card each. It's seems that for Zoho, one-to-one means: - One card belongs to one member - One member can have one or more cards For me, one-to-one means that: - One card belongs to one member - One member can have only one card The solution I need is the second. So, is it a misunderstanding of me for the relation
Problem with embedding forms on website
Hello, I have a problem with embedding ZOHO forms on my website. I created a contact form where people can fill out their name, phone, email, etc. Then on the website it says: Sign In Username: Password: And then after I sign in with my ZOHO info, the form shows up. Obviously this is not going to work out if I want anyone to be able to see and fill out the form. How can I solve this problem? customerservice
"Edit" button popping up the wrong row for editing
When I click 'edit' in my application on some rows, they will consistently pop up an edit box for a different row. I've noticed that these rows tend to be near each other alphabetically for one of the columns That is, a row whose title field starts with '40' will consistently pop up an edit box for a different row whose title field is '13', or 'sleepy' instead of 'shaggy'. Again, this isn't happening to all rows, but it is happening every time to specific rows. This only manifested itself after I
Restore data problems
Greetings and thanks for a great product. I have noticed several postings of restore problems and I am having the same. I backuped an app and then restored it to a new name so that I could make changes and upgrades without affecting the original application. The app seems to be ok, but when you are looking at a view of data and click on "edit" beside a record, you end up (randomly) looking at a different record to edit other than the one you clicked on. In addition, the bulk edit function doesn't
Filter Record for User Login
Hi Support, Please advise how to filter records to show only for that user login. I have create an Owner field in every table to auto-insert the user login id evey time a user create a record. In the views I have set the criteria of the Owner field to == zoho.loginuserid. But when I login as the user who created the records, no records display. Please advise what happened? The application I am referring to is the Sales_System_Move and all the views in the Admin tab. Thanks.
Help and Blogs & Forums
Please add a link to Forums and blogs under the help drop down menu. These are also forms of help and very useful sources of information. herbwex
Can I copy or duplicate a form ?
Say, I am creating an application with similar looking multiple forms. After creating the first form I want to copy the same and do some minor changes required and save it as the second form. Can I do that or I have to create the second form from scratch ? msivakumar
Help for an idiot.
I'm evaluating Zoho Creator to potentially replace another service. So far, I've liked Zoho better,but the other one (formspring.com) has a very easy logic procedure. I am not getting Zoho's at all. I don't want much -- two things, really. 1) To be able to show fields based on user input. 2) to be able to send email to specific addresses based on user input. Can you direct me to a tutorial that is designed for idiots like me? Something step by step that assumes total ignorance on my part. Thanks
Next Page