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.
Upload file - Creator API
I am trying to send a file to the creator using a java code through the API creator as shown in the link: https://www.zoho.com/creator/help/api/rest-api/rest-api-upload-file.html # http_method But all attempts are returning 500 error. see the parameters sent with POST: Url = https://creator.zoho.com/api/xml/fileupload/ applinkname = XXXXX FromName Requisi_es fieldname = teste_1 recordId = 836809000002270003 " filename = filename.pdf scope = creatorapi and the file ... tried to send with Content-Type
Dropdown dependent on dropdown? How ?
Hi Just make new form. Logic is next: 1 dropdown - choice of city , 2 dropdown - choice of firm in this city. How to make this logic and how upload to creator those dependencies "city-number of this city's firms" I have about 90 cities. In each city form 40 to 2000 firms. Thank you.
Lookup Issue with New Application Builder
By default, the new app builder uses ID numbers for lookup fields. You can select the display name however. I have a lookup filed type using checkboxes, so the values entered are a list. This is how it appears in the Report view: But this is what happens if you email this field: Is there some new deluge aspect to get this to display names rather and ID numbers for sendmail? Very Frustrated with the New App Builder, John Whitney
HTML views
Hi Zoho, I was wondering if you have some information on how to create html views. I have read this article: https://www.zoho.com/creator/help/views/create-html-views.html I don't find it that useful. I am looking for some more detailed information about how to insert deluge queries into the html code. For example i would like to create a table. In that table I would like to get values from one of my forms. At the top of the table I would like to have a user defined field where the user can choose
Views: Is it possible pull a value two tables away?
I've searched as best I can, but I'm falling short on terminology. Forgive me if this sort of thing should be easily answered. Here's a description of my project: We are using our Zoho Creator database to record interactions with school groups who visit our institution. Each Interaction is tied to a School. Each School is tied to a School District. Interaction --> School --> School District Our institution receives tax support from a given region, and schools belonging to districts within that
I want to put the forms I created onto , or view and use them from a secure webpage How do I do that?
I want to put the forms I created onto , or view and use them from a secure webpage How do I do that?
Dynamic View
Hi I have a number of Stateless forms that hold information for engineering configuration. The Current Config ref is stored in a variable that is global (via a table). One part of the config is a set of Widgets, Each Config can have up 10 Widgets each widget has 5 parameters. I was going to code this as 10 static sets of data in the main table but thought I would be knocking on the limits of Zoho and fields in Tables. So I was looking at a Master-Detail set up just for this part of the config
No <return> allowed in message body of scheduled report
When you create or edit a report schedule (under workflows), and would like to modify the message body of the email message such that something meaningful is added to the report attachment, then you cannot use a <return> to start a new line. If you do, you will get the error message "Error in scheduling parameters: null", which is not telling you what's wrong...
Another backup error
New app, built from scratch, backup is successful. When restored gives error: "java.sql.SQLException: BLOB/TEXT column 'Descriptio_1388351000001002559' used in key specification without a key length"
Next Page