Application layout rendering issues in Zoho Creator
One of my clients is facing issues in rendering of the layout for a Zoho Creator application, with the views getting nested somehow on his browser. I have given below the screen-capture of the application screens below. On wide-screens.. On iPhone : Personally from my account and from another, I do not face issues when testing the app from wide-screen devices. Kindly let me know why this might happen when my client accesses the app and how to avoid it. Thanks & Regards, Z.App.Maker
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?
"Add Notes" - having url links open in another window
Hi! I added notes (Add Notes) in my form but the notes I added are URL Links. It works fine but it opens in the same window as my application form is. Is there a way to have the links opened in another window? Please advise. Thanks a lot! Regards, Queenie
Sub-Form help required
I need some assistance please with the new sub-form facility. I need to create an application to record jobs, and be able to allocate those jobs to certain people or vehicles. I would like to be able to view a certain person or job, and have a sub-form display the various jobs allocated to them, I would also need to be able to re-assign jobs from one person or vehicle to another if required. Can anyone tell me if the above scenario is possible, and if so give some pointers as to how it can be achieved.
Question about updating records
I am creating a Mileage Tracker for my motorcycle group. I would like for the application to update existing records when a user submits new data. Let's say I have 3 fields: Name Email Mileage If User1 inputs 350 miles one day, then comes back next week and inputs 225 miles, I want to have the app check to see that User1 already exists as a name, so add the new mileage data to the current record, instead of making a new record. To keep a running total of mileage per user. Does that make sense? I
dynamic picklist problem
Hi, I have just noticed a problem in my dynamic picklist recently, let say I load a Vehicle No picklist from form B with the criteria of matching date. The vehicle no in form B is not unique and it can show up in different date. Supposed I selected a vehicle no ABC 1234 of 4/12/2011, this vehicle no ABC 1234 also showed up in various date before. When I clicked the link to view the record in View mode, it will show the vehicle no ABC 1234 from another date, instead of 4/12/2011. Is this a bug or
Popup a verification screen from the function?
I have a function that is called as a Custom Action on each row of a view. The function makes a change to a field in the corresponding record. I would like to display a message for the user giving them a choice of OK or cancel. Something like this "You are about to change information for John Jones. Press OK to continue or Cancel to not make the change." Is there a way to popup a verification screen from the function? Herb Wexler
FIELD UPDATE WHILE FILLING FORM
Dear Sir / Madam In my form, There a some checkbox, I want when applicant start cliking the check boxs, one another fild start counting number of checks. based on the number of checks I would apply a formula in another field. Please help
HTML View: Sort by parameter passed through URL.
I have an HTML view in which there's a for each record in form loop. Now I'd like to sort these results by a parameter passed through the URL. For example, if ?sort=name is passed on with the URL, I'd like to execute the loop for each record in form sort by name. Is there any way to implement this directly instead of performing consecutive if - else loops containing the same piece of code, except for the sort by parameter? E.g. for now this is implemented like this : if ( input.sort == "name" ) {
Is there any way to make a Creator Form act like a Web to Contact form
The Creator is ideal to organize new leads, but if I have to manually re-enter all of the form data into a new contact, that is redundant. I would greatly appreciate any assistance. (I'm not looking to have the creator form operate on a website like a Web to Contact page, just integrate the data)
contains() function inconsistencies - case sensitive in some cases, not in others
Hi, There are two other threads discussing this situation but I am not seeing any responses from Zoho support so I am consolidating these discussions here. My original post generated this thread and led us to include this other thread in our discussion. With some thorough testing Gaev discovered that, "Looks like .contains("xxx") is NOT Case Sensitive when applied to Collections ... otherwise it IS !!! Please respond to this. Thanks again for your excellent support. John
contains function is case sensitive despite documentation stating otherwise
On this help page:https://help.creator.zoho.com/Built-in-Functions.html ...the following is stated: A function is a set of code, that takes a finite number of input and optionally returns a value. None of these functions are case-sensitive. However, it turns out that the "contains" function is actually case sensitive. This caused me to waste a lot of time debugging the wrong parts of my scripts over the past few days! Anton
help with case conversion and contains string functions
Hi, Is it possible to do a case conversion and search a string for a substring in one step? For example, I have tested: for each title in Books [Title.contains(input.Title_search)] - works but is case sensitive. for each title in Books [Title.contains(input.Title_search.toLowerCase())] - substring is converted to lower case successfully but obviously I need to convert the Title string as well. for each title in Books [Title.toLowerCase().contains(input.Title_search.toLowerCase()] - problem with
Customizing look and feel for multiple page forms
Hi there! We are in the process of creating a multipage form. The first form we embed - which is the lead form - looks fine when we embed it in a website. But all subsequent forms result in the default look and feel. See this example: http://www.jessweiss.com/testing/brandeisinfo/index2.html How can I keep this from happening? Thanks!
views and hidden fields
2 questions: 1. I duplicated a number of views based on a view that appears under the View button. For some reason the duplicated views are appearing under the Forms button when using the application. How can I change the views so they appear under Views? 2. I have a form where I have hidden a number of fields. But when I run the application, they appear on the form. Why is that? Is it because I am the admin? thanks, Ray
TABLE CREATION
Dear Sir/Madam I making a Application form, where I need a table in which the applicant will key-in the data. Please advice how I can create a table. I created a table thru Add Note but after creating the applicant unable to key-in data in that table. If I create table thru Sub form then type of matrix table not possible like 9FT 20Ft 40FT own - - - hired - - -
Disabled RTF the grey box appears below the field
I have a disabled RTF after several fields that are hidden. They grey shading that indicates the field is disabled appears 2 inches below the field. This is about where it would be if the hidden fields were displayed. I have the same result in FF and Chrome. Herb Wexler
Logo in the Forms or at Header Level
Dear Sir / Madam Please advice how a company logo can fix at header or inside the form I tried copy paste thru Add Note but unable to do Please help
User Forwarding Once Form Is Submitted?
I would like to forward my users toa thank you page once they have submitted my form, how can i do this? Thanks, Cal.
Multiple users of same permalink - non-login version
alsingerzohorecruit 1 - seconds ago Does the use of views provided by permalink (the version NOT requiring a login) allow for multiple users accessing the same permalink form at the same time? For example, lets say there is a stateless form that is shared with a number of users by NON-LOGIN permalink... The form asks the user to enter two fileds of data which are then checked against a file to return a certain value.... Can multiple users be executing this one permalink form at the one time - without
automatic calculation
hi ! i did a form where my users site complete the result between two fottball team , and i want to showing them a view based on result : win draw or lose , the points of that teams . For example : Team no 1 vs Team no 2 ends up 2-1 for team no 1 . Team no 1 will have 3 points and the team no 2, 0 points. In the second match the score is 0-0 , and team no 1 will have 4 points and the team no 2 , 1 point. and so on . This is my form : https://creator.zoho.com/adiman/rezultate/form-perma/Rezulate_inregistrate/ and
Re in view of the number in the format
Hi How can I format numbers in view? I want to the format like 12,345,678.00,but the format always display 12345678.00 in VIEWS even the field is "$currency" also can't with a thousand digits,so it's not easy to read large numbers. I knew that in form and function in a format function can be used to solve this problem, but I do not know how to solve this problem IN views. Thanks Stanley Guo 2011-12-22
Backreference in replaceAll()
Is there a way to refer back to the search statement in the replace statement of the replaceAll() function? For example, I want to search (case-insensitive) for "abc" in a given string and replace it by "<0>" + found string + "<0>": "xxABCyy".replaceAll( "(?i)(abc)", "<0>\1<0>" ) ---> returns "xx<0>ABC<0>yy" "xxabcyy".replaceAll( "(?i)(abc)", "<0>\1<0>" ) ---> returns "xx<0>abc<0>yy" In other programming languages this is realized by creating a capturing group using round brackets
Adding multiple records to different forms based on calculations from initial form
I have a form (called ServiceRequest) that collects input for services that we provide. The input includes "Start Date" and "End Date". From this, the "Duration in Days" is calculated and a price is quoted (column name = Quote) What I would like to do upon submission of this form, is have it calculate the number of weeks in the duration (Duration_in_Days/7). Using this value, the equivalent number of records would be written to the table named (ServicePaymentCalendar) passing with it prorated
Can create a form that would allow web users to search my spreadsheets?
I would like to create a form that would allow team captains to search my database of players looking for a team and see a list of players that meet their criteria. Is this possible? How would I start this process?
loop through records and display them a certain number per page
When I perform a for each on records I can access all my records. But what I would like to do is say: show me the first 25 records. Then I want to access the next 25 records. And so on. I read some forum postings with solutions about adding an extra field to my records for this but when using criteria to filter records this would lead to strange results because the number of records per page would be different. And also I would think that this is a feature that Creator should support. Creator's
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?
Next Page