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.
Open a Record View Without "Edit"
Hi I have a very simple question: How can I open an entry in my creator database (in the records tab) by simply clicking on it. Much like in Zoho crm all I have to do is click on a contact, for instance, and it opens up a view of the record. How can I do this in creator without needing to go to "edit"? Thanks,
The Image field seems to be broken
Hello, The image fields does not seem to be working: I create the image field in the form add a new record - I put a link to a graphic in the image field - save - it shows the fine in the default report view telling me the link was saved okay - if I use IMAGE FIELD it displays fine in a PAGE view. (so far so good) However if I UPLOAD a graphic from my hard drive (instead of using a link) - it shows the graphic fine in the default report view - but it shows as a broken link in the PAGE view
What programming language
I am looking at Zoho for my on-line database. I currently use Access and programme quite heavily in VBa to achieve input validation on controls. What is the programming language that I must use in Zoho to achieve the same? It looks like C. But there are many variations. Which one does Zoho use please?
Create report within the Zoho Creator
Good morning, Some fields I created in Zoho Creator does not appear in report generator, I need these fields to set up my report. They are fields of type Currency. Thank you!
sendMail question
I have a field called input.Stakeholders in the active form. It's selecting the names of stakeholders from "New Stakeholder" via a lookup. I wish to get the email addresses associated and map them to the "to" field in the sendmail function. Any help is greatly appreciated. if(input.Job_Status == "Shipped") { sendmail [ from:zoho.adminuserid to:(NEED HELP) subject:"Job: " + input.Job_ + " has been shipped!" message: "test" content type:HTML ] }
internal execption error. Please help.
My scripts are suddenly failing today and I am receiving an "internal exception" error. These scripts normally run fine. I do not know the cause of the error but this has occurred before when you guys have pushed new updates to production. Please help me troubleshoot this ASAP. This is a very serious issue. Suddenly all of my URLget and URLposts are failing. with {"responseCode":"-1","responseText":"internal exception"} This occurred several months back due to mishandling returned results. https://help.zoho.com/portal/en/community/topic/internal-exception-for-creator-function
Viewing multiple records in multiple forms?
I have a clients form that serves as a lookup field for multiple other forms -- for example, a documents form, a phone calls form, a meetings form, a notes form. So, each document, phone call, etc. is tied to a particular client. What I want to do is create a view or views that allows me to select a particular client and then view that client's information alongside each record from the other forms that are linked to that client. In other words, if I select John Jones as a client, I would then see
SUM Function
How do I add a SUM function into my script? jsoto
Prevent on user input calculation for null case is failing
I have a dropdown list with years in it. When a user selects a year, the code converts it into a number, and then does a calculation. However if the user selects "-Select-" from the dropdown, the form throws an error. I have tried to prevent this using the following code if(input.HSGY == null) { //nothing } else { n=input.HSGY.toLong(); input.Grade=thisapp.Grad_Year(n); } It's ignoring the null case (which is "-Select-") Cheers, John Whitney
Meta reports
Hi, In larger applications with many forms and views with different permissions, it is difficult to track which report has which permissions, and who is able to view what. It would be great if admins were able to run a report which would show all meta information, like all forms in the application, and views associated with those forms, as well as views permissions (add, edit, delete...), who has access to forms and view and other useful meta information. Thanks, Lyubko
How to parse a response from Creator API
I want to build a related list function in CRM to access a view in Creator. I have successfully linked to the Creator API and got an Authorization code and have also passed back the view in question with a number of records using PostURL How do I now parse this XML/Map to extract the data in the records so that I can show it as a related list.
Error duplicating view
I get the following error when I attempt to duplicate a view from my application. Original view: https://creator.zoho.com/essistmgmt/assets/#View:CONTRACTED_ASSET_View Note, the application is shared for support editing. Can you please investigate?
Form stopped working overnight
I haven't changed anything about this form, which we use every day and have been using for over a year now without issue. All of a sudden this morning the "on success" script is not running completely. I get a "Data submitted successfully" message *and* and an error message. Is this some temporary technical issue or did Zoho implement back-end changes that I should know about?
Disabling fields on subform - zoho script isn't working!
My subform field is Students the subform's fields are Student, Status, Type I want to disable editing Student and Type on Form Edit So On Edit Code is something like this disable Students.Student; disable Student.Type;I save script with no errors, and the behavior doesn't result as expected.
Error on success Edit record
I have this Error. It show after edit any records, after press Update button. If delete all code in On Success block in On Edit scripts - no this error. But if add any code, like sample "x=123" or just comment "//test comment" - always have this error. How to solve this?
Formula between multiple forms
I'm unfamiliar with the scripting language and I'm creating a database for a non profit managing the inventory we maintain. I created a form for the individual Inventory items. I'm on a second form an Order form where I added a lookup field linking to the Inventory item. Another field on the Inventory form is Cost. I'm trying to create a formula field on the Order form that will add together the cost field from the inventory page for each Inventory item selected. Making sense? Thank you!
need help, how do I add a link to email instead of print the view?
where it says "EDIT PRINT DELETE" is it at all possible to say "EDIT PRINT DELETE EMAIL" and configure the email to send to email address associated with this record? or can you suggest a way I can have this record's view emailed, when the user clicks on something on this screen?
Next Page