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!
Creating a PDF in Purchase Request
Hi I'm new to this system. I would like to use this application called "Purchase Request" to create Purchase Orders. Does anyone know what I would need to read to accomplish this task? What would I need to read up to get this done? Is there anyone this group that can help do it? If yes what would the charges be? Rishi
"Updating Script..." but didn't updating in Zoho Creator
I want to add "driection: rtl" to my "with action form" on "scripts" menu. but i gave Updating script... . that didn't save.
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
when will record count for my account go down?
I just deleted an application with about 18,000 records. So far, my total number of records doesn't go down. Do I need to do more? thanks Henk
bug - set criteria for a view
This occurs only when using zoho system variables in the criteria field for a view. To recreate the problem select a view to edit. Once the view is loaded, select the Set Criteria option from the View Configuration menu on the left of the screen. Next, select Restricted Records. Next, select the Added User field from the drop down, then select Equals and type in zoho.loginuser. Finally, select Done. The system will save the system variable with quotes leaving the system variable useless. In
User limit same as admin edition?
Hello, I just realise that apparently my users have a free edition even if I suscribed for a professional edition. What does that imply for the number of records and the number of applications? I import data in my admin account, that my users access with a shared view, but they didn't appear in the record counts in the usage limit tab --> Add-on on the home page. I also shared with my users a form to enter record. I entered a new record using that form in my user account but it didn't show neither
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
Suggest add a criteria function in “for each <element> in <list>”
Hi Suggest add a criteria function in for each <element> in <list>，like for each <row variable> in <form/collection> [<optional criteria>]，it's can be repeated to achieve a list read until the value of a given filter.. Thanks！ Stanleyguo
Count existing entries in a form with a specific criteria and return value of new entry by +1
I am currently working on a way to generate codes for items. I have two main questions concerning my application, which are: - How can I have zoho automatically number based on existing records and a specific criteria - How can zoho automatically display a code which is based on another field AND a count function Let me explain in detail... My application has two forms: Items & Product Code Generator In a first step I will add an item to the Items form. The form has three fields which are Item Name,
Reports and Multiselect fields
Are there any workarounds to the limitation that multi-select fields can't be used in reports? I am considering building a new table that would be similar to the table I want to report on. This new table would have one record for each of the values selected in the multi-select field. The table would be changed in the on Success of the original form. Does anyone have a better suggestion? Herb Wexler
"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?
How to Enter/Edit only Hour & Minute (e.g 08:30 or 17:45) portion of a DateTime field in Zoho Creator Form?
1. In my TimeSheet application I have two time fields say From Time and To Time AND I want enter/edit ONLY the Hour & Minute portion of a Date/Time filed as 08:30 or 1730 OR 12.15. Whatever way I entered the time should be formatted/visible as 08:30 hidding the date and second portion. 2. My objective is to calculate the time ( Hours & Mininutes) between these two datetime fields. 3. FYI, I have been able to create a CALCULATED Field showing the time as 08:30 by using the SubString function BUT
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
Access all applications without go to the home page -
Hello, I need Zoho to be the most userfriendly and the most simple for my users as they are not really geeks... (not at all actually ) Here are the things I would need: After login, I would like them to arrive on one specific tab, on one specific view. I also want them to access the other applications without have to go to the home page. Finally I don't want them to be able to create any application, or to add a user to their account. They should only be able to add and mofidy data in application/form/view
Page flashing for https sign-in using IE 8
Signing in using IE 8 to an https only app, the page flashes and seems to reload a few times while displaying https://creator.zoho.com/appcreator/jsp/showapp?appurl= John M. Whitney
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.
Terrible IT Support Both Phone and Email
Hi, I'm an Enterprise Zoho Creator subscriber and I just wanted to document the terrible tech support experience that I have been having. I wanted to upload a .csv database with 40,000 records. I tried first to use the migration tool which, despite the promise of ease of migration, did not work. The status bar stalled at around 30% indefinitely, even after an hour. Repeated calls to the supposed 24-hour support phone hotline were unsuccessful. I then raised an IT support ticket. The reply came
Passing string longer than 255 characters to an HTML view
Dear ZOHO, I want to pass a string longer than 255 characters to an HTML view. I generate such a string when I invoke a function. In the html view that is generated, I have to set this variable as type STRING. There is no type such as LONGSTRING for example. Please see the attached screen shot. How can I achieve this? Thanks for any help. Silvester
Create View that accepts a URL parameter for record retrieval (for use with REST API)
Hi there, I have searched high and low through the documentation and forums and can't figure out how to get this working, so I'm hoping someone here can lend me a hand! I am using the REST API to pull in data from my Zoho Creator app to an external website. Data entry happens in the Zoho Creator application, but public perusal of the data happens elsewhere -- and I'm using Views to aggregate and build the data I need to pull in as JSON objects. I need to create a view where I can pass a URL variable
Performance
Hello, I'm using Zoho Creator in Free mode to try if Zoho could satisfy our needs and I'm answering if the response time is better in the other modes (Basic, Standard, Profesional,...) or not. Thanks, Fidel Martín
Next Page