Problem in downloading PDF from Zoho creator.
I have created a form in zoho creator and I have created a custom view for this form in HTML. Now i want to downlaod the PDF from this form. But everytime I try to download the file from this form it prompts me to log in. I want to download the PDF without sigin in the zoho creator. Help me out as how can I do this.
how can i import more than 70 columns all at once from Excel table?
Hi, how can i import more than 70 columns all at once from Excel table? Thx!
Display Field on Calendar ... can the number of characters be extended?
I need more characters on the display field in my calendar. There is room for more on this particular calendar.
Google authenticate not working on Ipad
Here is the situation: This is a Zoho Creator with Google apps setup I have a Zoho Creator form that is embedded on a Google site. The form has an upload file field that can upload a file from Google Drive to the ZC database. This works just fine on the MacBook Air On the Ipad however the Google Authentication periodically just hangs. ....are there any solutions to this? I have been unable to get any useful answer from Zoho support.
field-level access for editing in my custom creator's view?
hi for managers who works next on entries in custom views how make next functionality 1) i take for work view with fileds 1, 2, 3, 4 2) fields (when they open entry) 1 and 2 they can only view without ability of edit 3) fields 3, 4 they can and view and edit examlpe when they open entry for edit first 2 fields they see but can't change, next 2 fields they can change.
Creating a function to open a list
Hi, I've created a list and now I want to be able to create a function that provides a button in the list that when clicked opens another list that is related to a value in list one. I've looked through help & forums but can't find anything - can you point me in the right direction please. Martyn
Encryption
Is there any news concerning encryption of stored data in Zoho Creator? It is a great product, but until we cannot store sensitive data in a secure way, we are prevented from using it as much as we would like to.
Want to create a Dashboard for Response Rate and Converted Lead Rate
I want a visual dashboard that shows the percentage of contacts who responded to my mass e-mails and a conversion rate from being a contact to a lead. How can I do this? I apologize for the broadness of my question, but I am not familiar enough with the system.
Deluge statement for showing "Edit record" for lookup fields
It will be excelent to have following abilities: Additional option for lookup field: Checkbox "Show Edit link". If you select it, you can also select View for this Form, which will be opened for editing Deluge statement to show or hide this "Edit link" on client side We ofthen need to make some changes in selected in lookup field related form
Displaying views with many subform rows
I'm using subforms for a few of my forms. Some of the records have many subform records, ie 50+ children. I have views that display the form and subform results. The views currently display 1 subform entry per line. For entries with multiple subforms, it is very hard to read. My suggestion is to have subform records either comma delimited or per lined as an option. It will make it easier to read rows with multiple subform rows.
Can't log support issue on website....your website is broken....
Can't log support issue on zoho creator support site, see error below, rather ironic that support site is down!!!! An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go toZoho Creator Home
Online Documentation for getDayOfYear() incorrect ?
The text regarding 'getDayOfYear()' on page : https://www.zoho.com/creator/help/script/built-in-functions.html#Time_functions Looks like it refers to 'Day of the Week' and not day of the year ? "returns a number in the range (1-7), representing the number of the day of the year,that date falls. The number "1" represents Sunday, "2" represents Monday and so on." Does the function not return a number 1-365 or does it actually replicate the functionality of getDayOfWeek() ? Neil
Function error message
I am updating the following function Application: https://creator.zoho.com/essistmgmt/assets Function: udf_history.save_subform_row_deletions I am getting the following error Function is modified successfully However the following other functions have argument mismatch in invoking this function Make a note to correct them as early possible, as it may lead to execution errors In action script-->COST(form)-->on success with arguments (string ,int ,string ,string ,date) In action script-->EVENTS(form)-->on
How can I monitor my users?
Hi, I've just built a new application and want to make sure my remote users are using it correctly. How can I monitor their activity and undo errors as necessary? Thanks
what, really, is an application?
Hi, I am using Zoho Creator, new to it but I do have an MSC in I.T., I totally get Zoho Creator, no problem, even with limited experience on it. What I cannot seem to wrap my mind around and cannot see from the knowledgebase is the answer to this question: what exactly is a zoho creator application? Of what consequence is it? I mean, say i have 30 forms i plan on building, why should i not dump them into one application, even though they may not be related, as opposed to create a separate application
Hide/Disable Submit Buttons
Hi Think its critical to have the option to incorporatre the submit/reset/custom buttons into the deluge script so programmers can hide/dissable etc those buttons like any other fields. Rgds,
REST Api downloads a file
Hi all, I am integrating a website we have on Magento, so that a newsletter subscriber on the website is added to our MEMBER database. The website is in PHP though so my tweaking is not very strong. The REST API and form are working fine now, but the result is that an XML file or JSON file are downloaded whenever you click submit. Can I avoid that ? tx, Seppe >>> Here's the code. <form action="https://creator.zoho.com/api/my_owner/json/my_application/form/MEMBER/record/add/" method="post" id="newsletter-validate-detail">
Multiple attachments of xls sheets in scheduler
Can i have 1 schedule command that has more that 1 attachment in it? It seems silly to have multiple schedules for multiple docs at once.
data entry focus
While entering data in to the application, pressing enter takes you to the next data record..this is good. ... but... the focus remains on the last used control...which is not what most people would expect i guess tommyjonas
Is there a delay to send mail through scheduler?
Like 30 minutes? I'm so confused by this thing, is there a sample application that shows how it works?
Can't get my field to show or hide based on user input.
Hi. I have a field called 'In Foreclosure?' When a user selects 'Yes' from the dropdown menu, I'd like the 'Docket No.' field to show. If any other selection is chosen ('No' or 'Unknown' are the remaining choices), then I'd like to hide the 'Docket No.' field. Even after it shows as a result of me selecting 'Yes' (let's say I change my mind). I'm hiding the 'Docket No.' field when the form loads. But I can't seem to get the remaining script to work under 'In Foreclosure'. Here's what I have: if
Changing imported field type
I have a POSTCODE_SUBURB form that has a POSTCODE field as a number. I will now be adding UK postcodes that are in a alphanumeric format so I want to change the field to string type. The POSTCODE field is referenced in many other forms and scripts. I cannot easily recreate the relationships/script logic/etc. The import fields that reference the POST_CODE field are also used in other script logic. How can I change the field to string without spending too much time? Please do not give advice to create
New App Builder : How Does Auto Number Work ?
I can add the field, but it doesn't appear on the data entry form, neither does the data appear in a view or even if I create a formula field to display the content (on a data entry form) using the 'Auto_Number' value as the input.
Need some advice on forms layout
I am new here to ZoHo and I already have my database/form setup but the problem is I have a ton a fields on the form and I am trying to figure out how I can make sections collapse/expand - I haven't been able to find it, not sure if it exists. If not is there a way I can have the user added additional fields as needed for add more content? I have it split up in two columns but that's not enough. Can anyone provide documentation on how to work with this? Thank you.
Anyone come across "invalid Subform Comp Name <columname>" error - Subform
Hi While setting up a dynamic picklist at subform, I had used clear row.<subform-field'scolum name> to clear the list eg: clear row.Area This would clear the list But, now i am unable to save this line of code as it says Error at line : 1 'Invalid subform Comp Name Area' Anyone come across a similar error while trying to clear subform's droplist? -Deepa Govind http://homepreneur-online.com/
Links stopped working in zoho creator from 2010 how to I update the links so my website updates correctly??
A former coworker set up the zoho database in 2007 & 2008 with various views that would automatically show up on our website, and the links used to work correctly.. now the website will not update with the zoho creator data. HELP!!! here is one source page of the website. where the heck do I find the new or updated link for zoho creator? it's supposed to automatically populate the following website: http://www.hchlibrary.org/gala/sponsors2013.php <title>The Henry Carter Hull Library | Gala
Creating a Function - variable not decleared
Hello, I have a script to calculate prices in a subform. This script is duplicated in three fields price, quantity and discount. I want to create a custom function called 'Price calc' so that I can alter the script in one place. To create the function I'm simply copying and pasting the script from one of the fields, into the Function script area. However I get several variable undeclared error when I try to save the function. What am I doing wrong. Thanks Stephen
Default image in form
I need to set a default image (QR code) in a form so that it is displayed in a report and when exported to a spreadsheet. The QR code will always be the same as it will direct third parties to another Zoho form (permalink) once scanned on a phone to fill in. Is this possible? It would seem actually adding the image detail could be achieved through a notes field but notes unless I'm mistaken are only for reference on a form and can't be used in report. Also the information I've found online to actually
Get lookup fields
I have lookup dropdown field in my app, it import date from other app like ID, name, age. How can i get all fields for selected lookup entry? I try to get like: mylookup.name or mylookup.age - but error. And mylookup give me just current lookup ID.
Fetch phone number from Zoho CRM to Creator?
Hi, I've been fighting this problem quite some time, and still haven't found the solution. See the attached picture. When I check of the "Contact person = costumer" box, I wan't the application to fill out the fields "Contact" and "Mobile". The "Contact" field is easy, cause it's equal to the "Costumer" field, but how do I get my app to fetch the phone number from the CRM? Hope you can help me, Kind regards, Mads R. Svendsen
using business name in application URLs instead of personal user name
The Zoho Creator URL structure is: creator.zoho.com/[user.name]/[app.name]...etc. I would prefer not to have my account's personal user name form part of the URLs of my apps in Zoho Creator. My account is for business use and I would like the URLs to reflect the company name (or an abbreviation) instead. I understand it is not currently possible to change this without going through the hassle of creating a new account. This seems very inflexible and counterintuitive for business users where the account
Limitations on Script Size
Are there any restrictions on the number of lines of code that can be written for one script ? Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
Iterate all Records and check a checkbox if match
Hi , I have tired to get this working for a while and have also tried various methods but I just can get it to work. Max has offered a solution involving a report but I would like to try to get it working like this. I would like a view in a room booking application that would show me the Rooms/units that have same day arrival and departure, so that I can put some sort of priority on the units that will arrive and depart on the same day. This is the solution I am working on: for each Record
Form update button at the top
I would like to suggestion adding a form update button at the top of the form. A few of my users have requested this feature as I have some very long forms and when they want to edit records, they have to keep scrolling down to find the update button. Can you please add an update button to forms at the top of the form?
linking two forms
if i have two foms 'a' and 'b' . while validation form b i want to check whether it is already in form a and if it is there then the form can be submitetd.how can it be done.?
Forms for customers to fill inn.
Hi all :-) I'm currently using , CRM, Support and Creator. I'm searching for the best way to get information from my customers. Ideally I would like to send a link on email to my client, directing them to a form online they will fill inn and attach documents. The data they fill into the form should ideally be editable into the future, hence a login function is desirable. Also important, the forms filled in, should be linked to their CRM Contact, for us to easily access it. Our business sell travels.
Forum responses
Hi, In the last few weeks, I've noticed that my forum questions have had slow response times. 1-5 day response times has become more like 1-4 weeks. Has anyone else noticed this too? I think zoho creator needs more moderators since this forum gets a large number of posts.
Differential User Permissions
Just occurred to me that there's no simple way to have differential user permissions for a view. For example user john can delete while user jack can add and edit. I know I can edit the forms tied to the views to allow this but it seems to me this type of segmentation of user permissions should also be available in the view context. For example, in the image below, it would make sense to have a drop-down list of all users with the ability to customize permissions. Maybe this is the group-sharing
Deleting fields from forms
Application: essistmgmt/assets/ Form: PRODUCT I want to delete the following fields PRODUCT_CODE_PHASED_OUT SERVICE_CODE_PHASED_OUT However, I am getting the following error message This field is referred in the following places. Please remove them and then delete this field. Functions 1. udf_product.get_product_service_id_896426000011845953() 2. udf_product.get_product_service_id_896426000012564478() I did not create the functions above & I cannot find them when I view the udf_product namespace.
Simple filter
Working on my first app, I'm just trying to put a date filter on a report to show records for the current year. I created a custom filter and chose date field After 1/1/13. I get an error message saying to please specify proper criteria. I've confirmed that the field in question is indeed a date type field. I don't know what I'm doing wrong - it seems pretty straightforward.
Next Page