Upload images from an excel to an applicaition
i´ve got an excel that has registries, each one with an image. i want to migrate it to an application that i did in zoho creator but i don´t know how to upload images in the zoho application from an excel. they hace told me to use these exampel: https://creator.zoho.com/yoge_babu1/runtime-calculator/#View:File_Header_View look the attachement . i have´t got to work the example.
Service Confirmation Link - changed from HOTMAIL service
Hi, I send to our subscriptors a link that allow to confirm data. People receive this link and clicking confirm that or data are right. The final parameters of link are: /zc_Header=dfalse/Numero=945 People that have HOTMAIL service receive the link in other format that is not clickable, HOTMAIL transform = in %3 so people cannot confirm data and we can't use our application. There's a solution? /zc_Header%3dfalse/Numero%3d945 Thanks Mic
email sending
Is there any way to use the sendmail function to send an attachment? avma
Individual Record View?
Hi Zoho, Lets say I have a view of list of customer accounts. Is there a way to break it down to individual view for each customer? so each customer can use the view to check on their account activities. They sure not need to look at other customers ones. I need to put this on another website, so that the customer A can access this view. I tried the "RIght Click" "View" in general view. It opens up in a new window. I need more than just a URL, plus i dont want them to see the whole link traced back
date email trigger
For my application, my customers contact me by submitting a form on my app, and then I email them back. I am trying to make it so, the customer gets 4 days to email me back (so I can tell if they are serious or not), and would like to get an email notification by that 4th day if they haven't contacted me, so I can delete them. Any ideas on how to make this happen? Thanks
Subforms with the API and User Document Sessions
Hello, I'm inches away from being able to use Zoho Creator as the back end for my clients project. It would really be great if we can solve the following three issues; even with some kind of workaround. How would I go about using the API to submit data to a subform within a parent form as opposed to accessing the subform form directly. I hope that makes sense! The difference is that when adding a record in a subform it, quite rightly, doesn't treat the subform record as a new record but instead a
How to put number counter?
I want to create a form for registration. I have to create a student ID which can not be duplicate. How do I create an ID that is a number and is in counter. The new form should just add up 1 to give a new ID.
Zoho Creator should officially support WebKit browsers = Chrome and Safari in one effort
A strategic suggestion regarding browser support by Zoho Creator: SUPPORT THE WEBKIT BROWSER ENGINE Let's see, that'd take care of Google Chrome and Apple Safari browsers in one effort. Hmmm... those names, Google and Apple.... I've heard of them somewhere before. Maybe it makes sense to deliberately support their browsers that both use the same engine. One effort, two browsers supported. Is that too logical? Any thoughts? Oh, because WebKit isn't supported by Zoho Creator, the text in the Free
forms
why can I not save my customize form after changing all the settings such as background colour and fonts. also is there a way to change the actual overall of the form width and height with border around it. I wanted to be 150px width and height 300px. how to set the fields when a user fills in that the email address is legitimate and not a fake or spam email. please help. thanks
How to remove "Powered by..." from internally embedded form?
I have a formed embedded by iframe into an HTML view, but it dows the "Powered by ZOHO Creator" graphic, which is a bit silly. How can I remove it? This is on free plan. Thanks.
from field problem
I created a form and send a email notification with the form fields to the person who filled in the form. I want to send a copy to a different email adress for administration purposes. The problem is that mail looks as if it is coming from the admin id always. I would like the from field for the copy to be the email adress of the one who filled in the form (so the collected email adress). Is there any way to do this?
Functions Acting on a List
I have a function that operates on a string list input. I noticed that the script fails in the case of attempting to convert a string to a list inside the function request: my_app.MY_FUNCTION(string_item.toList()) or my_app.MY_FUNCTION({string_item}) To get this to work, I had to convert the string to a list outside the function: my_list = string_item.toList() my_app.MY_FUNCTION(my_list) John M. Whitney
Translation and Localization
Does Zoho Creator have a way to localize applications into different languages? I.e., can there be a look-up table that allows you to create the same labels for various langauges so that translation is simpler?
Reports not updating
My reports aren't always updating when the information has changed. It will be working fine and then all of sudden, it won't update again. I have to create a new report to have the changes reflected. Is this a known issue? Am I doing something wrong?
Detect Record Open for Editing
I'm working on a time input manager application. In order to limit a user entering more than 8 hours total for a few projects on a given date, I'm applying the aggregate function in form validation to sum the total number of hours for a given date+user. The problem I just found was in editing an entry for a given date. This may best be explained with a simple example: Let's say a user has two projects for some date. Project A has 6 hours and Project B has 2 hours (totaling 8). Now let's say his
Calculating a SUM and Show it
Hey Folks, i try to build up a Form for a Sales Funnel. For that i create a Form with several Fields, including my List Price and a Discount. I can calculate the discount and can calculate a new Sum. But i would like to see it on the Form too. So - Listprice: 100 $ (User Type in) Discount: 10 % (User Type in) Sum = 990 $ (Seen on Screen, Calculated) Anonye out there, who can help me?
Freeflow Script Issues in Chrome
When I'm at work, behind our corporate firewall and proxy server, I have issues with v16.x Chrome's freeflow script editor. Interestingly, this is not the case for IE. Part of the issue is rooted in the page css, where using Chrome's inspect element I found that by changing an opacity value to zero, the ghost text is removed. However, there is still an issue with using the mouse cursor to select lines - the cursor seems to still select ghost lines of text. It seems to be an issue with https://creator.zoho.com/appcreator/edit_area/edit_area.js
Issues in implementing email processing within Zoho Creator application.
Hi Zoho folks, I have a client who needs to automate his processes, which are primarily based on incoming emails. Each of these emails represent a Request which needs to be added to the Zoho Creator database and tracked to Completed status. These automated emails come from an external source, but are in some standard format. So the emails were added to an email-inbox and data processing was done in the On Add --> Validate, parsing out the data. This is okay until there are no issues in the email
Can't find 'Deploy in Google App Engine' link
Can't find the Deployment link to Google App Engine, Is this option still supported?
Form Schedule can the record be accessed
Hi I have a form schedule which looks at a record dates in my form and sends me an email 7 days before that date (this works) Now when this record is matched i want to also include some additional fields in the email and also do some updates to the record Question, is there a way to access the record which triggers the form schedule ? i..e does it exist in a collection variable somewhere ? Thanks
Help with Decision Box Display
I am not sure how Zoho Creator treats true and false. Are they 0 and -1 or 1 and 0, or what? I have several decision boxes which when displayed in Form View show either true or false. Is it possible to display either a box with a tick or (no tick or cross) or a Yes or No (true and false are too similar to be easily distinguished by eye).
HELP in access Data From another Application
Hello there, I need Help in order to retrieve data from one ZC App to another ZC App. Application A has a form called orden, here we track all the contracts belong to a Consultant, so for example I have the following fields: Name (Import file) from other form Contract Number (Single field) .....other fields... In this application one record is created every time the consultant has a new contract. Application B This application have the mission to store each payment for that consultant, so something
Format Pivot Columns
I have a pivot chart which includes a column generating an average. The default average value contains 4 decimal places, how can i remove the decimals or reduce to 2 decimals ?
Failure in emailing to add a new record - "Error occured while adding record"
Hello, When I send an email to add a record into a Form, I may receive an error email, subjected as "Error occured while adding record"; and the email content suggests "The Following error has occured while adding this record: 50". I created a new form to test this. The form has only one single-line field named "ZC_Subject" and one multi-line field named "ZC_Content", and no other deluge statements are involved. I noticed this may occur for long emails only. Please help! Thanks!
In View Sorting After Group is applied
Hi I have a view for which i have set up grouping in the view definition When i look at this view it is grouped as i expect. BUT I cant seem to apply any live sorting to this view , seems like any view sorting functions are now disabled Is this the way it is meant to be ? Thanks
How to send hyperlinks to Zoho CRM
Hi, I'd like to send hyperlinks from Creator to CRM (in a multiline text field). The result in CRM is : <a target="_blank" href="https://creator.zoho.com/account/app/view-perma/Actions_view/Zoho_ID=454220000000064827">Clic here</a> And when I clic on edit (in CRM), I get it : <a target="_blank" href="https://creator.zoho.com/account/app/view-perma/Actions_view/Zoho_ID=454220000000064827">Clic here</a> This is working well when I copy-paste this code directly in CRM, but it desappear when
Could you please add a COUNT function in the view?
Hi Latha Now the view already has sum functions, can increase the count function in the view? because in the group statistics, only to see the total sum, there is no way to see the total count. Thanks Stanley Guo
HTML Print question
Hi, I've to print an HTML page to print a table : the Table has a bold separation. But when I want to print it, bold disappears. I thought about the browser's option "print background and images" (essential to print colored background) but it's the same.Do you have an idea to print those bold line please ? The style of this border is : <style>tr.bordertop td {border-top:2 solid black} </style> Thanks !
error when entering Creator [ServletException in:/jsp/newhomepage/newhomepage.jsp] null'
We were using a very slow connection this weekend and all of a sudden we got the error above when entering into Creator. Any ideas what we can do about it?
Creator runs very slow
Creator runs very slow at me now. Does anybody have a similar problem with Creator?
Summary view labels
Hi, I am curious if there is any way to turn off the field labels that appear in a Summary View. It is the only View where field labels are used and I have tried using the zcLblWidth parameter set to 0 with no success (I know that zcLblWidth is a parameter for Forms but I was hoping that it might work for the Summary View). If I could just switch off the field labels I could achieve my design goal without creating a more complex HTML view. Thanks in advance for any tips. John
Some help with criteria in a view please
Hi, I have a field in a form that I am trying to use in the criteria on a view but zoho wont let me. Can someone please tell me what I am doing wrong. Field 1 Date_Completed where we enter the hate when a job is completed. Now in my view, I want the criteria to say, if (zoho.currentdate is > Date_Completed + 14 days) Can anyone please help. Thanks Nigel
How to send email from a view including record data....
Hello Zoho Team, I want to send an email from a view, in order to do that I have a Function & custom action (Show action for each record), I want to send email only to a selected record each time. Until now I test and it work for plain Text only. Problem that I have is I can´t see how to include the data from the record selected, i.e. the record has Customer field, Prime Contractor field and other fields and I want to inform those fields as part of the message. How can I add field record
No option for Gapp Advanced Field
getting kinda frustrated with this set up a creator account through google apps, would like to have access to gapp user field in creator but its not there. have added/removed gapps, deleted/recreated app, closed/opened new zoho account. followed same steps with different domain, it worked fine. please tell me what needs to be done to gain access to the google advanced field
cross reference values
I have created an app for inventory management for my online sales. I have created a drop down menu for shipping options. My goal is to select the ship type in field1 and automatically populate the cost for that type shipping in field2- rather than having to manually type it in each time. I would also like the option to choose "other" as shipping type and enter my own value if needed. And if shipping charges change, I can change it at the data source... How should I be doing this? As a form within
How do I update the HTML page holding the ifram everytime the iframe reloads?
I have an HTML page holding an iFrame with a form. When the form is submitted, the next form loads within the iframe (i used an openURL function), passing the necessary values with it. However, what i really want is to use a function to open a new HTML page with the successive form and necessary variables. So i guess i would need to pass the variables through the URL string, is that correct? The reason i want to do this is because I am using wordpress and dropping the form URLs in the body. However
Separating multiple items from a Lookup field in a view
My app uses a lookup field to a form with the paragraph text box (long text?). When a record is linked to multiple records in another form, the view shows the other records separated by commas. Is there anyway to separate them by new lines/carriage returns? For example: Col 1 Col 2 Record in form a This is a long sentence in form B, This is a long sentence in form C. want to change to: Record in form a * This is a long sentence in form B.
date criteria generating error
In a user defined function the following form criteria generates an error: apt_rec = Appointments [((((Client == inv.Client && Appointment_Type == "Assessment") && Cancelled == false) && Start_Date >= inv.InvoiceDate) && Start_Date <= inv.Closed_Date)]; However, the following version (without the end date specified) works fine: apt_rec = Appointments [(((Client == inv.Client && Appointment_Type == "Assessment") && Cancelled == false) && Start_Date >= inv.InvoiceDate)]; What is the correct syntax
How to connect form with database?
I have created a database with Zoho Creator in order to house pertinent information for our organization. This database includes basic contact information of members as well as fields that we will use internally for our own use. I have also created a stateless form that I would like to use for our members to submit their contact information. If the field names and designations are exactly the same, is there a way that the member who submits the contact information form (a new record completely)
Populate field with IDs of related records
Hi, I need to create a new field "related" which is automatically populated (comma separated) with the IDs of all the records which are related to that record. Records are related by having the same value in one or more fields. For instance, I need it to look for value "X" in field "A", and/or value "Y" in field "B". If "X" or "Y" are present in a record, then amend the ID of that record to the list of IDs in the "related" field. I'd be really grateful if anyone can help
Next Page