Library Database?
I am looking for a online database to catalog DVD's, CD's, books and the like. I stumbled across this website, and I was wondering if this program is designed for that. This is my first time maintaining a database, and I was looking for something that was easy to use and flexible to fit my company's needs. Thanks!
Auto generating a field scripting error
I have a subform on my Equipment View that when you hit will open up an html view in a new window that shows additional information for that particular item. I have it set up so it will automatically fill in the Asset number (Pick_Asset) based off the meeting application. That works fine. What I'm trying to do is then auto fill in the Asset Description as well so when you click on the subform it will pop up with the Pick_Asset and the Asset_Description already filled in. However it's not working,
Problem with coding 'Actions on user input'
Hi, I am a bit new to making this kind of thing and would like a bit of help with making a bit of code to make my form look better. I have a question with a drop down box with lists of towns in. At the bottom I have added the word 'Other' in case the town they live is not listed in the box. The next question is 'If other please specify' which is always viewable to everyone and I would like it to pop up when someone clicks on 'Other' instead. I have this kind of situation around 5 times through my
Variable Questions
I need a variable that can be accessed by multiple 'on user input' things. I don't seem to be able to declare the variable in the onLoad section and then access in the onUserInput sections, is there any way to make this work? I don't want to have to make a form to store a variable in a database. It seems like such a waste.
Sending information from one form to another quit working
Sending information from one form to another quit working I set up a form called Test_Reserve and a form Called Test_Cal_Form Was having great luck sending information from Test_Reserve to Test_Cal_Form so I could create a google cal feed. It quit working after I changed a field, but I looked up all the fields and as far as I can tell they match up fine...help? insert into Test_Cal_Form [ ENDS = input.real_end_time_date STARTS = input.real_zoho_start_date_time DETAILS = input.Riders_Names_Ages_Weights
Easy Styling of Forms and Views?
Is there an easy way to customize the way my forms display? I'm specifically interested in having more than one field per row per column, and allowing more than one checkbox/radio button per row. Instead of: Field | Field Check | Check | Check | I'd like Field Field | Field Field Check Check | Check Is this possible?
script execution tracing
Is there any way to do this? I'm getting an ambiguous error on a user function and it would be perfect to be able to trace through it, even without a full breakpoint capability.
Android & RTF
On an Android phone using http://mobile.zoho.com RTF fields show as plain text but with the html code showing. Is displaying these as full RTF fields on the roadmap or is there a workaround? Thanks Herb Wexler
Custom Action html View
I have created an html view called Maintenance that combines the Add_Maintenance form and the View_Maintenance view together. I have created a custom function so I can put a button on my Equipment view that when clicked will pull up the html view for that particular record. I have successfully created custom function buttons that separately pull up the Add_Maintenance or View_Maintenance subforms but having both was rather cluttered which is why I combined the views in an html view so there would
Problems with special characters
Hello, A time ago I had a problem with some scripts in my forms: https://help.zoho.com/portal/en/community/topic/deluge-script-if-condition-in-on-user-input-is-behaving-oddly and now it seems that there is the same problem, as the forms were working wrong again. May be it's exactly the same, because I was told that there was an issue with special characters, and I tried changing the characters that caused problems then (á, ñ), and everything works well, but I need those characters. Greetings
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!
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?
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!
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.
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
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!
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
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
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.
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
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
Zoho Creator - RSS includes to many fields
Hi We have in our cafe/bar a Zoho Creator for our events. I have a RSS feed off these, which I would like to implement on our website. I have how ever run in to a bit of a problem. The RSS feed includes to many fields. In the Description field it includes: * <b>Eventtype</b> * Koncert<br/><b> * <br/><b>Entre</b> : * <br/><b>Billetpris</b> Is there a place where I can specify which fields it should include in the RSS feed ? Please help a newbie in becomming experienced in Zoho + RSS The RSS
Render image in html-view on a view-perma page
Dear ZOHO, I'm trying to display rendered images on a HTML-view page. I display this page via a view-perma view (example: https://creator.zoho.com/sdraaijer/qdst-nl-dive-conv-support/view-perma/Print_page?MAIN_TOPIC=Cellen ..) I try to diplay the image with the following code: <img src='http://creator.zoho.com/DownloadFile.do?filepath=/<%=r.UPLOAD_IMAGE%>&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=Questions'/><br></td></tr> Now the difficult bit for me is the viewLinkName
Code to check if the file upload field is empty
Dear ZOHO, How can I check in deluge script if a file-upload field is (or is not) empty. I tried the following code, but that does not work. r.UPLOAD_IMAGE != NULL What is the code for this? Thanks in advance. Silvester
"On Success" emails ending with <br><br><br>
They end with <br><br><br><br><br>-------------------------------------------------<br> I have no codes or anything at the end. I have two "send mail" functions there and both are having this problem. The forms are also not recognizing HTML.... it sends all the text together without line breaks and won't recognize URL codes with <a href> </a>
Email Formats Problem
Hello We are using Zoho creator to maintain the complaints. In the Zoho creator the mails are sent on several phases. Till couple of days back the mails were coming properly in HTML, table, color etc format. Now these mails are not coming in formatted way. Is there any problem with the mail system of Zoho?? Please suggests some solution as the complaint logging system is live and it is causing the inconvenience. Thanks in advance. Umesh
HTML formatting in emails is not working
When I use the "send mail" function on Deluge Script, it no longer respect the HTML tags for bold, italic, underline, etc.. When I am in the Script Builder, the preview seems right, but when I test the forms and the mails are sent automatically, the text is all written as if it were plain text aligned to the left. Also, it doesn't show some characters (such as à, ó, ñ) and sometimes it doesn't even respect line breaks. I didn't have any of these problems before, and I didn't change anything in the
Deluge script: IF (condition) in On User Input is behaving oddly
Since some days ago, most of my forms behave oddly when I use the "if" and "else" in On User Input, to show or hide fields. The application seems to completely ignore the condition and always executes the "else" part. I didn't change anything in these forms since a week ago, and everything was working completely right, so it's not an error made by me writing the script, I even reviewed the script and everything seems to be OK. This is one of these scripts: f((input.medio == "Página Web")) {
Using Amazon Simple Email Service with ZOHO Creator
Those of you that follow my posts here know that I have a love/hate relationship with mailing lists. I love the idea offering the service to my large community of users, but hate the various implementations available. Right now, I'm using Mailman. This required purchasing a VPS and learning my way around CentOS and dealing with python script craziness. At the same time, my community of users visit my ZOHO Creator site to publish calendar events and emails (sent to Mailman for distribution). I have
Is it possible to use deluge to update a field with web data 'on view'?
Hi there, I'm using web data in one of my application and it works great. However, this data is prone to change from time to time. I can get fresh values by editing the form, but I have not figured out how to do this automatically. Is there an 'on view' function or a scheduler for getting new values from dynamic data sources?
Use of Amazon SES
Always on the lookout for mailing list applications, Amazon recently released their Simple Email Service (SES). The developer guide shows an api using get and post commands to send an email http://docs.amazonwebservices.com/ses/latest/DeveloperGuide/ Post example POST / HTTP/1.1 Host: email.us-east-1.amazonaws.com Content-Type: application/x-www-form-urlencoded Date: Tue, 25 May 2010 21:20:27 +0000 X-Amzn-Authorization: AWS3-HTTPS AWSAccessKeyId=AKIADQKE4EXAMPLE,Algorithm=HMACSHA256,Signature=lBP67vCvGlDMBQ=dofZxg8E8SUEXAMPLE
Required fields
Hello, How or where can I translate a error messages of type "Enter a value for ...." or " Invalid entries found. Please correct and submit again." please? I need that to localize to another language thank you in advance Miroslav Osicka
Equipment Booking
I am trying to create an equipment booking database. What I'd like is for the person booking the equipment to pick the item from a lookup field (if possible to do multiple items at once would be great for those who need to book multiple items at once for the same time/date) then they would pick the from and to date fields. From this point when they submit I want it to check if that particular equipment is booked at that time and if so to alert the user that it's booked and to choose another time.
Next Page