Best approach for handling multi-page form (with uploads)
Hi all, I am hoping someone might suggest an approach or workaround to meet these requirements. Last year,we used a long form with multiple subforms to have users upload various documents. This didn't work so well as in the midst of uploading various documents user would sometimes forget to add a field or two and when the form was validated the entire content of the form would get wiped out if any error existed. This caused many headaches that I am hoping to avoid now. So I thought I would approach
Can data in a View be formatted?
Is there a way to format data displayed in a View? As an example, I have a boolean column and would like only True values to display. For False values, I would like to simply display blanks. I do not understand how (or if) this can be scripted for a View.
Creator View Print As List Page Breaks
Is there any way to adjust the page breaks in a view when selecting "print as list". The default layout often breaks the pages through the middle of a row, regardless of the printer page and margin settings. Thanks.
Updating the database form Form
I want to know, how can i update a previously entered data from form itself not in view, for example if i have previously entered phone book database and when i enter the Phone No in form field, if it is previously entered then all the other fields must show related information such as last name, first name, email, designation etc, where i can make amendments and update it.
Self Relationship
Hi Support, Is there a way to create a lookup field for record within the same form (self-join)? For example, a large corporation may have many subsidiaries. Please advise. Thanks, egressmedia
I want to display two buttons in a view, and then depending on which is picked add text1 or text2 to texttotal.
Hi there, I am a Scotman living in South Africa and have just run across Zoho and it seems great! I basically am trying to write a way so people can draft their own legal contracts based on making decisions online (in this case 54). I have already got a form where I enter all the options (all 1 of 2 choices at the moment) and the question they need to answer. The data is entered. I now want to display just the question and a button for option 1 and a button for option 2. If they pick option 1, then
Embedded form login failure redirect
Hi, I have some forms embedded in a website. Users can only login in to one form. Issue I'm having is: If user enters their correct username and password but on a form they do not have permission to access, they are offered to go to zoho home. I have created the username and password for them as they are not using zoho, just my site. How can I ensure that if login fails or login attempted for form that user has no permissions, they do not get the offer of entering zoho profile page. I would like
OnEdit refreshing the ZOHO form
HI, I created a zoho form. I need to load that form in EDIT mode. For that I created a HTMLVIEW ,which opens the form in edit mode. And then I am using the URL of the HTML view in ONLOAD of the form. The issue is ,while loading the form in edit mode it is refreshing the form twice. That should not happen for me. Please suggest any solution.
script on case load success and case edit success is being wiped
Hi, is anyone else suffering from scripting being wiped from the applications when a new form is loaded on success and then edited on success? It appears that mine started doing this a few weeks ago, and the script is there in the versions, but it just wipes it when you save it. Zoho appear reluctant to comment or deal with this issue despite my calls and emails to them and them acknolwleding there is an issue. Obviously this is now business critical for us and Zoho appear not to care?
Get quote products from CRM
Hi! I try to get quote's products with such code: response = zoho.crm.getRecordById("Quotes", <quote_id>); and then it's not possible to access field "product" as a list, because it's a String. Such code: products = response.get("product").toList(); is not working, it simply breaks a string into parts by commas. How can I access products correctly? UPD: And how then to update existing products? If I pass a map with products to zoho.crm.updateRecord it will append this products to the existing one.
Width Adjustment Has No Effect On Mobile Form
I would like to adjust the width of a "Search and Auto-Complete" dropdown such that I can see all it's contents but adjusting the width in pixels on the field editor has no effect on the mobile platform. Single line fields adjust to the width of the screen when switching from portrait to landscape on iphone. If you can apply these same characteristics to the dropdown fields that would work great too.
Update Parent field Based on Child record Update
Hi, i am trying to update the field on the object activity based on the child potential's field update. is it possible to update a parent object based on the Changes made in child..?? Please reply ASAP. Best Regards' Sachin Mahajan
Issue with zoho.crm.searchRecordsByPDC
I'm trying to create a report pulling data from Zoho CRM. The problem is, zoho.crm.searchRecordsByPDC is not working as you can see in the screenshot. I have activated my application (https://creator.zoho.com/jeremy_nagel/nyko-property-group/) to support.
Need Help
Hi , My form has 66 fields and iam trying to add one LookUp to the form.The recently added lookup is not appearing in the form. Please help me out of this.
Formula question
I have two dates, check in and check out, then a field that calculates the difference in days. So far so good. Now i need to have a field (TOTAL PRICE) that takes that number of days and multiplies it by another numeric field (PRICE PER DAY) and add 55. Then I need another field (DEPOSIT) that calculates 50 times the number of days. Finally I need a field (BALANCE) that calculates the difference between TOTAL PRICE and DEPOSIT. I would really appreciate some help here. I have tried everything and
How do I change the location of a form?
I know this question is very simple, but I am new to Zoho. I've been trying to figure it out for a few hours, but I can't find the answer and I am getting frustrated...:( I figured out how to add a new form, but I don't want to delete the form/tab and enter the information again. All I want to do is change the location of the form. Thank you very much! Judit
Peculiar: Saving a working script gives errors
Hi, Peculiar problem: If I try to save my already working script unchanged I get an error message! I have a working View Script that includes this line: show all rows from Leads [(Pipeline_Stage != "6 - L/D" && Primary_Case_Owner == thisapp.getUserInitials())] If I try to save it I get this error message: Error modifying the page Error at line 4 : Function calling is not supported from Component Criteria So it doesn't like my function call to getUserInitials(). The weird thing is that I am saving
Bulk Edit remove multiple Upload Fields
I'm trying to clear out the data in 152 upload fields, just remove whatever is in them now. They obviously aren't showing up in Bulk Edit. Is there any other way to remove the data from more than one upload fields at a time?
Function call as a View Filter
While custom filters allow simple filed based expression to be evaluated, has anyone been able to call a function for each record in a view? Background: I have an IT equipment list containing date of purchase & I am trying to create a view called "Warranty Expiring". I have already written a function called isWarrantyExpired() which take in date of purchase & months of warranty included at time of purchase to compute & returns a boolean true/false if warranty is expired. What I'd Like To Do: Create
Print to Word, Print to HTML, Print to RTF
Dear ZOHO, By default, Creator offerts options for an HTML-view to print or to print to PDF. However, I'm actually looking for an option to print to Word or print to RTF or print to HTML. And maybe it is better to say: Download as Word, Download as RTF, Download as HTML. Is there an option to achieve this? Kind regards, Silvester Draaijer
Possible to populate a subform from a stateless form?
Hi Zoho, is it possible to send data from a stateless form to a subform in a 'real' form? The annotated screenshot below describes what I mean. Background I am creating a multi-stage registration process. Currently I've got the form set up using checkboxes to provide a 'wizard' effect: However, my client doesn't like the user experience of this (saying rightly that it's not very intuitive). He wants me to come up with a stateless form approach with "Next" and "Back" buttons down the bottom.
email notification with Advanced Display Option
I have a form that sends an an email notification on submit. This is the option under More Actions. This is a nice simple way to send an email with all the fields from the form. However for lookup fields the link field shows instead of what is set in the Advanced Display Options. Is there a way to change this so the email show the same information that is displayed on the screen and the associated view? Herb Wexler
Maximum fields
Hi, could someone please tell me the maximum fields you can have in a form.
Adding parameter on embeded HTML View
Can I add a parameter on the embed link (used for iframe)? Export_View/DWgdvOf6exjXZvFBmrfNX2kqm991HjuMbbq6E25AvSAVrBdemnYTGOuHXaFJNk40rNbP6Y1AkkMJ5fyEfVABJUKjKakhYA7xNkXa/?id=123456'></iframe>
How Do I Add New Line Character To Scripting Expression?
Have tried this.... field1 + "\n" + field2 .. and it gives me field1field2 ..where I am looking for field1 field2 how can i get a new line character into my expression? thanks
Customize mobile interface
Is it possible to alter the way the dropdowns appear in the mobile browser? I would like the Lookup fields that are formatted with dropdowns to function the same way that a regular dropdown field works when mobile browsing.
Duplicate Entry when changing field type
I'm trying to change a multi-line field to a Rich Text field and I get the following error. Is there a work-around? Duplicate entry '218933000003474087' is not allowed as duplicate entries already exist Herb Wexler
How to Share App with Edit Privilege
Hi, I just want to know that If anybody wants to get Edit Privilege to one of My developed Application in his account, how it can be done. It is possible in share the application with developer mode. Please guide me about. Regards NeedCom
Multiple Rebranding Logos in the Same Account
Is there a way to have different branding logos for different databases in the same account? Right now, it seems that only one logo can be applied for all of the databases in an account.
Rebranding needs significant improvement
A few ideas about rebranding - for paid users. 1. I should be able to upload a different logo for each app that I create. I do not want my logo to appear at the top of every app, I want my client's logo to appear there. 2. I have embedded my app into a frame on my website, when the clients go to the app, they are asked to login. I have done this because I do not want them to go to creator.zoho.com/.../.../..., I want them to go to my website and then log in from there. Therefore, it is very
How can i display a textbox based on user selecting one of the checkbox option
If one of the checkbox option for a field is Other i want to show a textbox next to it when user selects that option. How can it be done on a form.
Rounding a number
How do I round a decimal value in a formula field to the nearest 0.5. For example: I would like to round the number 24.20 to 24, and round the number 24.40 to 24.50, round the number 24.75 to 25.00?? Thanks
Now Break This!
Gaev's posting (http://help.zoho.com/portal/en/community?ftid=2266000000340340) motivated me to share my app that also does not use zoho auth . Rather, it uses a user's email and password. It's designed for a school project I'm working on, but could be adapted to others. Register or request a password reminder here. Login to your personal page here. Let me know if you can see others records or stumble upon some type of error. Right now, all the screens are delivered as separate web-pages outside
Bi-Directional Relationship With A SubForm.
Dear all, I'm struggling with 3 questions for more than 14hrs and still i didn't get solved. So any one can help me on this?? 1) How to fetch records from parent form and update records in subform using Script. Example : Form - Orders SubForm - Products When i select a specific order all the products related to that order has to display in subform and when i save, that has to save to "products form" as well as in "products subform". Even if i add products related to that orders in "products
Custom mail event stopped
I have a mail event that was working before I left for the holidays, but now it appears that it isn't working. Seems the last time it worked was around the 25th. They're both enabled. I'm not sure what if anything has changed. I have re-set the execution time to see if that would trigger it to occur, but even after the time passed, the debug information shows the next execution time is in the past. data2 { execute event on '2012-12-31' at '11:33' daily } I'm not sure how the debug information
Mount zoho doucments as virtual file in the local native filesystem and access using ms office or openoffice
Hi, I prefer Zoho because, Zoho has really nice formatting features, a lot more than google docs. Thanks for such a wonderful product. I was wondering if the developers were interested in allowing users to use MS Office to edit files when they like and use the online editor otherwise. Right now what any body would do is download the file, then edit it, and then upload it again, only to find that some other user already edited the file in the mean time. What I think would be cooler and more useful is,
i want to update the values automatically plz help me urgent
i want to update values automatically using zoho time. may i use if condition to update the values using zoho.currenttime in submit button . is it possible are not? plz tell me
CRM customization Drop down boxes
I am creating an app that pulls data in from CRM. When I create a drop down pick field for the CRM file, the result is a popup window and new search box. Is there a way to do this just like a drop down field for fields with in your app
The number X is not allowed for this form. Only certain numbers are allowed for this field.
Hi, I have a form created with Creator that I use on my laptop and my Android device. The form on my laptop is still working as before, but on my mobile, since a number of weeks, the form does not allow the input of decimal values anymore into an input field. The field is set up as Currency which worked perfectly before, but when I enter a decimal value and press the Submit button, I get the warning: "The number 2.5 is not allowed for this form. Only certain numbers are allowed for this field."
Formula field that calls a function that seeks records from another form does not seem to be working
Here is my scenario (simplified): I have a function - GetCount(string Name) that queries a certain form collection say Form2 and returns the count. I have another form From1 that has a formula field that calls the GetCount(Name) function. When I introduce this formula field, it calculates the count and correctly shows me in the View of Form1 at the begining and then all the values stay as-is even though the records in the Form2 have changed. If seems to be that the formula field in Form1 was just
Next Page