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
ability to reorder the filters
Could you please add the ability to order/reorder filters either in Live mode or GUI mode....preferrable in Live mode. For example, I want my 'Status' and 'Priority' filters at the top of the list. My 'Status' filter only includes 'open' and 'closed'. However, my 'Company' filter contains hundreds of companies. Therefore I have to scroll through hundreds of company names to get to my 'Status' and 'Priority' filters to select them. And typing the name of the filter doesn't always work because, for
Confirmation Page Link
Where do I put the confirmation link so that after my form is completed, it takes them to a confirmation page?
How do I create a link to associated records filtered by the record?
I have a form where I create projects. I have an form where I create messages, some of which are associate with some of those Projects. In a Projects View, I would like to have a hyperlink to the Messages that are associated to it. How would I do this?
HTTP Status 401 - Unauthorized access
Hi, I can't access Zoho Creator, I got this message : Unauthorized access and this status HTTP Status 401. Thanks for your help, Bruno
Custom function not pulling individual record
I got this to work on a separate section of my application but can't get it to work here. It's pulling all the records, not just the individual record matching the ID. Situation: I have an Equipment form and in that form is an Invoice_Number lookup field. I'm trying to create a custom button that when clicked will pull up the invoice record based on the Invoice_Number field. I used the same script for a maintenance custom button for the equipment form and that works fine. However, when I modified
On User Input script executed at On Update
Initially I thought that the problem is related to a single application belonging to one of my clients, I reported it to support a few days ago, but it seems that it was not even understood. I discovered that the problem is in fact a generic one, not at the application level, probably introduced after a recent update. The fact is for some fields, I did not test for all kinds of fields, On User Input is executed also at On Update for a field. See a sample application as example (it is also shared
Criteria : Since last connection
Good evening everybody, I apologize in advance if the question has already been asked... I'm triying to have a different view for each user, in which will appear the contacts entered since the last connection of the user. Explanations and details: My contacts have a State field (NY, NJ, CA...). I have one user for one state. Each user can add contact for any state, but is allowed to view contact only for his own state. For each user I want to have: - a view with all the contacts from
Changing field from single line to multi line
I have a form with a single line field which has been populated with many records. I'd like to change this field to multi line but when I do this Zoho reports that I'll loose all the previous data entered as single line. Is there anyway to keep the old data and change it to multi line? thanks
Script to Send Email if Value is Null for Field, Date Ranges, Batches (oh, my)
I did a quick search in the forum for this topic but came up empty. Please redirect me if this thread exists. I use Zoho as a tracking mechanism for international shipments. A lot of the tracking has to do with dates - e.g. ETA west coast, ETA final destination, ETA delivery, etc. What is the syntax for the null "if ETA west coast = null" send email? Does the "null" in the code need to vary depending on whether the field is a string, numeral, multi-select, etc.? Another question I have is that
Colour Highlighting
Hi there! Its been a good experience using Zoho Creator. I'm working on a task report. Where I have different categories I would like to colour code my data for ex: Those rows of records which have Status as Pending, I would like to colour code them some colour. Please help ASAP Thanks
A list of reusable functions!!!
I was wondering if there is a list of the sample applications to show how certain user created Functions work? If not I think it would be a really good idea to have a list of Functions with a link to the sample app which uses the function. Maybe a Sticky Post? Just an idea!!! Damien.
export parcel label from form data
I have put a form on my website using zoho creator, into which customers can enter data. Now I would like to export this data to a custom parcel label to print out and send using snail mail, displaying for instance: ***************************************** Parcel Label Customer: Harry Potter Hogwards This is my autograph: _____________________________ ***************************************** The cursive entries will then change per customer. I've just started using Zoho, and I have looked around
How to get monthly calendarview of sessions
I have a table with sessions. Each session has start end enddate with about 3 days long sessions. How to get a monthly calendar view of this sessions as html-site? What about using Google-Calendar? Ralf...
Next Page