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?
adding a value to a longlist field type in DS
Hi, FormA has a lookup field of IDs from FormB called formb_ids. I would like to update formb_ids (add an ID to the longlist type) with a variable v. How is this written in DS please?
How to change copyright information on pages
Dear Everyone, How can we change the copyright information appearing at the bottom of pages "© 2013 ZOHO Corp. All rights reserved." to "© 2013 My Company Name. All rights reserved.". Thank you. Kashif
Message field in "Scheduler" not accessible
I am trying to create a schedule for one of my forms; specifically, trying to program the app to send out an email alert one week before the driver's license of the company vehicles' drivers expires. I run through the "When to do" but when I get to the "what to do" I can only get as far as inserting the message subject. The field for the actual message is visible but not accessible. I cannot type on it and it does not show the tabs shown in the "Message Subject" field (Insert Expression, Switch to...).
Uploaded File Validation
Is there any way to validate a file-type and size? I'd really like my users to post only PDFs, JPEGs, or Google Docs under a certain size. Cheers, John Whitney
Paypal Integration question
Hello, I have a quick question on how paypal integration works. When the customer is making the payment from a payment form setup through creator, during that process do they have to create a paypal account or can they just pay with their credit card? As a note I do not want that to be the case as it makes the payment not very business friendly. I want a customer to be able to just pay with their credit card. Thanks David
automatic updating of database from external link/spreadsheet
I am new to Zoho, but am very interested in Creator. I have forms being submitted via another service which updates a google spreadsheet in real-time. I believe I saw something mentioned in a forum about the scheduled updating of a database from an external link/spreadsheet. Is this possible, and if so how, because that would be awesome?
Import from Google Spreadsheet with Merge
Is it possible to import data from a Goole Spreadsheet using merge data so that records are edited not just added again? Just like in the migration tool?
5 FORMS INTO 1 REPORT
I have created 5 forms that are all linked together by one common reference number. I need the output results to all populate into one report. I do not want to look at 5 different reports when the forms have been completed. Can someone tell me how to merge 5 reports into one easy to read report?
populate form via email
hi there is form on website which takes from user name phone city email form sends email notification, it is possible to customize notification how can i populate creator's app via email from web-site form?
Has Zoho changed the login process for new accounts?
It appears that Zoho has changed the login process for new accounts. Previously when a new account was created Zoho asked for a username and email address. Once the account was created the username was required for login. Now when a new account is created Zoho does not ask for a username, but ONLY an email address. The email address must be used to login. I have 75 users who were set up with usernames. Can users still log in with the username? Or do they have to use the "email address" associated
Dropdown
Hi I have a dropdown box where the user must select a certain period (three , six , twelve months) When the user select the option the formula needs to calculate the correct amount of days to add onto the input date. Ex . - if user selects three then the amount of days must be 91 that are added onto the date entered. How would the formula look ? any ideas ?
Delete a View
How to delete a newly created VIEW. Made a duplicate View by mistake and want to delete one of them.
Field Types
I had an application running on the old Builder Platform. Now when adding items to it, such as a lookup field, when I start to write a script, that field, gets a field type change to an Integer. I wanted it to stay as a string. Can I change it at anytime?
importing data to a subform from the main form
Hi, I saw this forum https://help.zoho.com/portal/en/community/topic/importing-data-to-a-subform#2266000002822095 and I tried using the steps but really it doesnt work for me, I don't know if the title on the spreadsheets are wrong but is it already the same with the link view name. I have allowed edit access on the application named SAMPLE. Please help this is urgent thanks.
Next Page