cannot import data into form
created a form via upload of an excel which was done perfectly. then i tried upload data from xls it showed the 3 steps and then said import successful "close now" How ever on going to the view im unable to see the data!
Create a List:int from a string
Hello, I would like to create a List of integers from a string that contains integers separated by ",". For example, I have the following string: mystring = "106215000000457125,106215000000457129,106215000000457132"; and I woulk like to create a integer list with those values, like myintegerlist = {106215000000457125,106215000000457129,106215000000457132} My final objective is calling a function that has this list as parameter How can I do that? Thanks, Fidel
On Add/On Edit How about both
I frequently need to put the same code in On Add-On Load and On Edit-On Load such as Disable xyz. It is also common to need the same code in On Add-Validate and On Edit-Validate or On Add-On Success and On Edit-On Success. Any possibility of having a section for On Both Add & Edit? Herb Wexler www.PreventingMediocrity.com
Implementing Captcha on a web form
Is it possible to implement Captcha on web forms? If so, how do we do this?
support hours? ticket portal?
Earlier today I read somewhere on the Zoho Creator website (although I can't find the page right now!) that Creator support is offered 24 hours per day on week days. However, I never seem to get any replies from support staff until late evening local time (GMT +10). It really seems that support is only working on US time. Is this right? Also, there doesn't seem to be any support ticket management interface, where we can access and update support ticket details. Why not use Zoho Support for this?
Problems with creating HTML views
I'm pretty new to Zoho and to database design and management, so bear with me. I'm tring to create an HTML view for a form that I've created to embed it into a website. The problem I'm having is that I have 2 forms saved in a project, and I can only create an HTML view for one of them. The program seems to default to that form, and I can't create a HTML view for the other form. Do I have to open up a seperate project for each HTML view I want to create, or is there a way to select which form
Verification Code Image NOT loading
Verification code is only loading the image only 10-30% of time. Also form displaying internal server error 500 when my form is attempting to be submitted. donotreply
Check for duplicacy
Hi, I have created a form, in that there is a field called "UID" thats get generated once I submit the form. I want to avoid the duplicacy for the "UID" field, how should I avoid it. RGDS Himanshu
In a view how can I set critria of a checkbox that is not checked
Hi I am new to creator and a i am sure a simple question. I have a form with several check box's When I set criteria for a view to contain yes if checked it works great. But I can not set criteria to show unchecked box's. I have tried every combination of criteria.Thanks in advance for the help.
Mutli-select on dates
Hi folks, 2 questions. 1) My ultimate goal is to be able to obtain a list of dates within a column. Is there any way to select multiple dates in a field or do I have to have multiple date fields? One possibility is to use the multi-select field but I don't know how to automate the dates to be selected. Is there a way to do that? keep in mind my ultimate goal and if there is another way to achieve that, I would be open to hearing it. 2) If I have a date, how do I send a reminder email 2-3 days
Search Page Embed results in list view ColumnS Getting stretch
Hi, Thanks for reading I have made a search page which function fine within ZOHO But when iembed it within my site it works but the result which i display in a list view become stretch for some reason. i have no idea why this is as it appears fine in zoho and it only 6 Columns which should easily appear within a frame which is 900 - 900 so i dont know why this is. i have try to work with the column width being adjusted but this did not have any effect. SO I AM REALLY STUCK PLEASE HELP!
Selective editing & user registration
I'm a ZOHO newbie, so please bear with me. I've looked through a lot of documentation but haven't found what I need. The app I have in mind can be best compared to an alumni list for your high school or whatever. I'd embed the app in my web site and welcome people to create their own personal profile/recird with a standard form: years attended, current location and occupation, etc. But, I'd also like these people to have the option of going back and changing their own record ONLY, if their information
Sharing problem
I shared access with invitation to this email: <> He tried to register and sign in. Zoho simply said access denied.
I need a simple contact form with mobile = sms verification
I need a simple 4 field form with name , mobile , email age field with no replica. I need email field to check againt previous entries. Mobile should verify and send sms code to user that authenticates himself filling out the code. I have sms gateway and http api with me. http://your_domain/pushsms.php?username=your_username&password=your_password&sender=your_senderid&to=your_recipient&message=your_message&priority=route But i am unable to make out how to integrate it with zoho creator application.
Column Properties wont' submit
I am in the Column Properties of my View edit and for some reason whenever I try to check or uncheck one of the fields to add/delete it from the View, when I click Done it gives me "Please select view to link." It's doing that for all the views based off my Add_Task form and it just started doing it today so I'm not sure what's going on.
How to read json data of zoho-creator via url ?
I have url of zoho creator from there i can get json data. here is this url " https://creator.zoho.com/api/json/yugapp-feedback/view/Guest_Book_View/apikey=" This script i am using for read json data $(document).ready(function() { $.ajax({ url: 'https://creator.zoho.com/api/json/yugapp-feedback/view/Guest_Book_View/apikey=', type: 'GET', dataType: 'json', contentType: 'application/json; charset=utf-8', success: function (data) { $.each(data, function
Bug in Script Builder: iframe dialog does not work properly
Dear ZOHO, The Script Builder dialog for OpenUrl with an iframe does not finish correctly. When I try to add a parameter to the dialog box (such as the name of the iframe), the correct code is not inserted. Maybe you can fix this? Kind regards, Silvester
problem with stateless form
Hello, I constructed a stateless form: PSP Work Accomplishment. It wont submit a data. Please help. Edith
Problem with currency sign in the report builder
Hi, I have a currency field configured with Philippine peso sign (Php). But when I fetch the data in the report builder, the $ sign appears instead. Regards, Edith
How can I SUM a numeric field dependent on a date selected?
Hi. I'm hoping I can get some help here. I figured out how to aggregate a numeric value and I felt like I was close to my solution, but so far away. I need to pre-populate a numeric value based on the sum of that numeric value for a specific date selected. Let me explain: I'm adding a customer to a delivery log for a specific date. When adding the customer, I define how many pieces of furniture are being delivered. Now I want to add a numeric value to the form that gives a sum total of the number
Integrating a Creator Custom Application with Zoho projects, discussions, documents, etc
We are new to using this tool and have developed a basic database application in creator. We now need to add some PM type features to this, and are looking at/how we could integrate our application into zoho PM system. How does this owkr? can projects in PM be linked to our database items/rows easily in creator? what about discussion forums?
Import + Global variables + linked fields
Hi everyone, and thanks fro stopping by… Here is a problem I have, I already spent several hours on it without success, so you're my last hope... (codes are below). I have 2 forms in 2 applications: Form1 in App1 and Form2 in App2. Form1 is for contacts and form2 is for restaurants. For each contact I have to link a restaurant, I can link the same restaurant to several contacts (the manager, the chef, the waiter...) Each restaurant has a reference contact, who is in the contact list. In
Stateless forms? Not sure
I am trying to create a web form that a use inputs contact info and then clicks a next button then an additional screen appears where they put additional info and then clicks submit. Any assistance in this would be appreciated. I have tried using the stateless form and I can get the fields to populate. Thanks!
Column Group Headings
In views, can I mark a "grouping name" ABOVE a series of columns. That is, "Shipping" saying that these columns pertain to shipping... "Customer" saying that these columns pertain to customer info.
Search More then 1 Field in a list view
i am looking to search a property app Which Allow user from a drop down box to select area, Bedrooms required & Property Type i have got the app to search one field thanks to this sample app which i use the code from but how do i get the search to take in to consideration the 3 fields https://creator.zoho.com/sampleapps/search-app/# Any help will be greatly Appreciated
Insert data in an HTML view and submit it
Hello, I would like to show several registers composed with the data of several forms in an HTML view. And then, change some of that data and submit the information. The submit button will have to gather the inserted data and update the registers in the database. How can I do that? Thanks, Fidel Martin
Send reports from Zoho crm to zoho reports in real time
I want to know if it is possible if i want to get the zoho reports from CRM in real time (ie in every 10sec updation of particular report be done).
Add to Lookup Field Bug
In my application there is the Task View or the Add_Task form, when someone adds a new task, there is an issue when someone attempts to add a new item to the lookup field in the form. In the add form, there are several lookup fields along with the Add To beside the field in case you need to add an option to the list. When someone is in the process of adding a task, and needs to add something to the lookup field an error message pops up that says an error has occurred, however the item you just added
create subform for purchasing form
Hello, I create a purchase form with date, purchase id and total cost. Than i create a purchase_item form with the purchase id, product, unit cost, qtd and total item value for every line of the purchase. There is a way to create a easy purchase form where the user could set the purchase data and id, than add many purchase lines as she want's? Thank you very much, joão melo
Send relational database record to external XML parser
I have a relational Zoho database, with a few dozens of forms. The relationship between forms is created using drop-down import fields and the records are identified by a customized record number. Every record is identified by costumized number which is the same in all tables. I want to be able to export a record (identified by a customized record number in all tables) from the database to an external XML parser, at once (using a single click). Is this possible in Zoho Creator? If yes, how can this
Want to use "deselect all" but no fields listed...
My assumption is I can use "Deselect All" to basically "uncheck" radio button selections? I use the script builder to drag "Deselect" into my script page. I click on "DeSelect all" and when I go to select the 'field name'.. the drop down is empty. I have everything from radio buttons, dropdowns, etc on my form and this list is showing nothing. What could I be doing wrong? I basically want to deselect all items in my Radio Button list when someone changes another field. I'm putting the code in
Recurring text input
Hi, I am using Zoho creator and inputting data into basic forms. In a section of the form I created (called notes) I have a phrase that I am having to type for every form that I input data to! This is making the work tedious! Is there anyway i can use the edit application feature to place this recurring text phrase into all my new forms. Thanks.
Zoho Creator for Google Apps: afterparty
Ever since its launch, Zoho Creator for Google Apps has been providing successful solutions to many. While our users have been building databases on their own, we've been busy figuring out how we could better the integration; importing and sharing, to be precise. These enhancements have already been enabled to all users via Google Apps. Others can expect it very soon. Importing Spreadsheets directly from Google Docs: Importing spreadsheets into Zoho Creator has been one of the much-loved features.
Why the button to generate the pdf is not working?
Why the button to generate the pdf is not working? See https://creator.zoho.com/marcosulzbacher/rbni/view-perma/Ficha_Publica_do_Imovel/Ag3ECRKSdAxRO9OTaK2hsSybNGQ0OuG1Fuf57eVMyjGyqhYmXWxVAS0FaD6Bdr1sW6g8q5usFHfjCAvv66vxPdzGUF60HCwuNUEq?potential_idstr=679162000000850015 Thanks Marco
** Easy Question - Need to get rid of "No Data" in fields that are empty.
Is there a way to show a blank field in view or report mode instead of it showing "No Data" when field is left empty? Thanks.
Photos do not get loaded
Hello, I have created a very simple form with the need for the user to upload a photo as a required field and when I test it and I Add a photo in the required field this does not get loaded and as a result the e-mail notificaiton I get has everything apart from the photo that was to be uploaded. Can you please help me? The code of my form is the below. <iframe height='500px' width='100%' name='zoho-form' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/bettykarastatira/free-or-sell/form-embed/form/'></iframe>
How to trigger script in a stateless form via API call from external site?
Is this possible? In my tests so far the API call itself is successful but the code in the "on click" action does not run. Is there a trick to getting the script to execute via the API call?
Updating application across multiple zoho accounts
I have built a zoho creator app but this app is to be deployed to multiple clients. As a continuing service I am going to continue to develop and improve the app. My problem is i dont want to update each application separately as I update. Im sure there is a name for what I am trying to do. Is there a way to create on app that others can use that when I update will also update their version? I want to avoid doing new installs and exporting all data from the old version and importing into a new
user login not working
i created a very simple tracking db and embedded it into my website login required i am the admin i created a user account for my partner i can log onto the database but when my partner attempts to it does not recognize the username and password I verified that he is a zoho user and logged in as him
Populate field value based on another field input
I have two fields - a dropdown field "dropdown1" with two values: "valueX" and "valueY" - a numeric field "numeric2" which should be populated with value "1" if "valueX" is selected in "dropdown1" or should be populated with value "2" if "valueY" is chosen in "dropdown1" field. Is there a script which can solve this problem? Where it should be placed on (on user input, on success, etc) Thank you!
Next Page