Can't locate existing script to edit
I want to edit an existing script (Email notification – Edit – On Success) but I can't find the existing script! I get to here https://creator.zoho.com/gstann/form/1/scriptbuilder/# but it's just the generic stuff not the actual current script which I'm trying to get the Part # to show in. Please help. Thanks, Geoff
Problem with picklist inside a subform
Hi, We have an Order form and inside it – an Order_Item form. It has two dropdowns, Category and Items. A change in Category is supposed to repopulate the Items dropdown. I'm using the following code, which generates weird errors: if (count(Products[Category ==row.Category]) == 0) { clear row.Items; } else { itemlist = Products [Category ==row.Category] sort by Product ; row.Items:ui.add(itemlist.Product.getall());
Values not escaped in Manage Users page in Zoho Creator
When inviting users I had entered an email-id in the "display name"<email@example.com> format and this is now causing java-script error in the manage users page (as shown in the image below). I would like the 3rd user's entry to be deleted if this error cannot be fixed at once. Thanks.
emailing out of Zoho with file attachememt
Hi Zoho peeps, It would be great if we could include a file attachement from create with an email when an action is complete. Can this be done? Thanks
New view appears under Reports tab
Hello, I created a new view by duplicating an existing view that was located under the Views tab. (Creating a view by that method does not permit you to select where you would like the new view to be located.) For some reason, my new view appeared under the Reports tab, rather than the Views tab. The only explanation I can conjure is that I set the permissions on the View as Add record:No, Edit record:No, Delete record:No. Can I move the view back to the Views tab? Thank you in advance for any help
Free-form Script Editor Issues
I'm using Chrome... OMG! John M. Whitney
1. Romanian diacritics disappear in .pdf export 2. Exporting 1 (specific) record per page in Summary view imposible
Hello, I discovered Zoho database and it's a great product. I want to implement it for my bussiness but I have two little problems: 1. When in View mode, when I try to export data records in .pdf format if the records contains diacritics they will disappear. Those diacritics are: ș, ț, ă, î, â (romanian language). 2. In Summary view there is no posibility to filter the records in order to view just one (desired) record. Search function is not available (which could be used to filter the records
Comparing two strings or two list, Usage Limits?
1) "Solicitar Oficina en Renta" Stateless Form This form searches in "Buscar" Form 2) "Colonias Separadas por Commas" String Field This field provides with "Colonias" separated by commas. 3) I compare the "Colonia" field of fetched records with the string field "Colonias" 4) Them I convert "Colonias" into a List and try to compare each element with the "Colonia" field of fetched records. 5) I do this in order to get this result: Options Searched Roma Sur Polanco Chapultepec Options Available Roma
Display a List on the Form View
I have a contact manager application. On the form where you can input/edit a contact, I have a dropdown box that lets you categorize the contact. I would like to have a list display below that dropdown box which displays the name of every other person that has that catagory selected (should be about 5-10 people). Preferably, I would like to be able to select more then one (a multiselect) and have all of those display. I assume that to do this I have to write a script that will retrieve the names
Add "&" symbol in field thanks to Zoho API
Hello I would like to add a field with & symbol Here is my request : <field name='Company'><value>"&"</value></field> Zoho response is : <?xml version="1.0" encoding="UTF-8" ?> <response><errorlist><error><code>2830</code><message>XML document structures must start and end within the same entity.</message></error></errorlist></response> Of course & is an xml reserved character. I have tried CDATA : it does nothing Can you tell me how to add a & symbol ? Thanks for your help Regards
Can i make form like this image in zoho creator?
How i can make a form like this image in zoho creator?
How to create Autocomplete textfield?
Hi All, Anybody can help me for creating autocomplete textbox. I have already created one form " Test Form" . In this form we have one Field "Manager". I want to make this fields as a autocomplete textfields. when user start input value it should search from "Contacts" Form and field name "Full Name". Below link is my application link which is public. https://creator.zoho.com/sujeetsocial/copy-of-celebrity-invite-database/#Form:Test_Form Please anybody can help me. Thanks Sujeet Kumar
Scheduler Scripting Question
Hi I have a Daycare application and I want to charge tuition dues every Monday for Cash paying parents. I know how to set the scheduler but I need help creating a script that does the following: Find the kids who pay "cash" from the payment_type field in the add_kids _form For each kid who pays "cash", select the child's name (ID) and weekly_tuition_amount from that kids record Then create a new entry in add_bill_form with the child's name (ID from add_kids_form) and weekly_tuition_amount amount
Incorrect columns
All of a sudden, I am unable to correctly IMPORT records into http://tinyurl.com/Ind-Vets - A database of Indiana Veteran Graves. This just began a couple of days ago. I high-light and copy info from an XLS table, IMPORT & PASTE into the CREATOR database. I am positive an equal number of columns are in each. But when finished, the first column (NAME) is missing and all other columns are shifted one to the left. In the PREVIEW all looks okay, with info in correct columns. I must load each individual
Can I set a default value for a field in a view (not in a form)?
Hi folks - I've just started using Zoho Creator, and I'm hugely impressed. I have one general transactions table ('activity') with an 'ActivityType' field to identify different activities. I'm setting up a view for data entry of one of the activities - in this case, 'Swimming'. How can I set a default value of 'Swimming' for the activitytype field in this view only? Many thanks in advance Shane
User Authentication
I had developed an app in zoho crm. In that application i made 4 forms. What i want is that only 20 user can see one form with there own records(No other person can see others records). And there is 1 group which can see only 1 form which nobody can see other than people in that group.
Cannot Create Report
When I try to create a report I get this message " You can only have a maximum of 2 reports under this account. Kindly upgrade to a suitable plan to create more." The thing is-I have no reports at all. Any ideas? Thanks.
does a zoho form have an email address and can I send an email to it
so that the form fileds are filled with appropriate content? would be awesome. what API do you offer for integration with a third party tool, so the form can be filled with information from that tool?
After linking with Google apps, no users can see Creator app
I can still access my Creator application here: https://creator.zoho.com/justinroffmarsh/engagement-update However, the application is not visible to ANY user via Google Apps (or via any other means, other than that URL). My domain is .ballistix.com My ZoHo username is justinroffmarsh and my e-mail address is justin.roffmarsh@ ... How do I reassociate my app with my Google user account (I am super-admin). I've checked admin/email and the only listed email is my Google one. Justin
Changing Single line to Drop Down
I am not able to change a field from single line to drop down. I tried to delete the field and re create however it keep giving me a script line I need to change.
location of 'custom filters' in the filter list
could you move the location of 'custom filters' in the filter list from the bottom of the list to the top of the list? thx. hughes
On Success Clear Form
After the user clicks on the Submit button, I need the form to reset itself to the default values. How do I accomplish this? Thanks
hi im trying to send emails from a chech bo
Hi im trying to send emails from a list of 7 check boxes. i have inputted this code suggested by zoho but i cant get it functioning the form is here at this link. https://creator.zoho.com/timgarrett111/project-charter/form-perma/Projects_Tasks/ help would be very much appreciated. on success if (Do_you_want_to_email_this_to_members.contains("x")) { sendmail ( To : "x" From : zoho.adminuserid Subject : "Subject of the email" Message : "Your message"
How do I Copy Fields from One Form to Another
This is probably a stupid question, but I am very new to database creation and have no experience with scripts or anything; but I am trying to learn. I have two forms: Existing_Activities_University and Contact. They are both Subforms to University_Data. In the Contact form, I have a checkbox field that I would like to have show up in Existing_Activities_University. I would like for this to be dynamic, i.e. if I add or change fields in the checkbox in Contact, I would like the field in Existing_Activities_University
On Success print Print_rep view
On Success script: openurl (((("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/Print_Reparation/ID=") + input.ID,"same window"); ID is checked in column properties - works great Now I tried to create a HTML view so I could format the output. I get the message that the ID variable is not defined. There is no 'column properties' - so how do I define this variable that contains the last or active record ID? (I just started with zoho and find it completely awsome although
Data Validation Before Sending to Email
Hello, I am a newbie and I have created a form that my colleagues can add information like -- email, contact name etc. After adding the information, I wanted to validate the data entry and send a custom email to that email generated by my team mates. I hope you could help me figure it out. Many thanks. Cathy
Backup
How to backup to my hard drive, all of a database ?
Need your help to explain in detail the new BUILD IN FUNCTION matches ()
Hi Very pleased to see that ZC have added the new builder in functions matches (), add the following code to explain one by one: phone = "(123) 456 7890"; if(phone.matches("^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$") == false) (?) { Info "Please enter a valid Phone format"; (it's understood) } Mainly above the regular expression is explained in detail。 Thanks Stanley Guo 2011-10-25
XML - Error occured in the insert Html task
Please check the app below. I have allowed support access to the app already. It is giving me the "Error occured in the insert Html" task error. The xml works fine if I view it but in the app it doesn't work. https://creator.zoho.com/nazario.mariano/qa-department-lab/#View:Call_List Thanks.
Using the "AND" and "OR" operators
I know this is an easy question for the experienced, but I am not. I am a network engineer pulled into a project for a client. I have created a form for inquiries, but am having problems creating some of the required views. I need a view that will filter records based on the following three criteria. If the attorney_week matches one of my values AND has been added within the last 8 days. But I also want to display any records that have an empty/null value for the final_disposition field regardless
Use Zoho Creator to create mass Invoices in Zoho Invoice
Hi, I am current Zoho CRM and Zoho Invoice user looking at Creator. In reading some posts, it appears that I can integrate my Zoho CRM Contacts with Creator. It looks like I can also create a single invoice for a customer one at a time in Creator and have integration with Zoho Invoice. What I would like to do is create multiple invoices of the same product based on the customers I have selected in a list. Here is my application. I need to invoice about 50 people for my club's membership dues once
Render Image
I know that there are several threads on this issue, but I have read everything that I could find and can't get it to work. When I go to the View for the form the pictures will not display, and instead give a broken link icon. I have a file upload field names Image_Upload and a formula field named Student Picture. The expression I have is as follows: ((("<img width='64' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Image_Upload + "&sharedBy=" + zoho.adminuser) + "&appLinkName=")
Which AP is right for me.
Hello All; I'm very new here. I'm not even sure which AP is right for me. I'll put my simple case study and see if I get answers. I'm a member of clergy in a church, we have out congregation database, that we have on a central computer. Me and the other clergy members also have the contact information for the church members on our smartphone. The very basic idea here, is that I would like to move the database to be on the cloud, while any of us (clergy+office staff) makes any changes on the contact
Creating an applicant view for jobs still allows add/edit/delete
Hello all, I'm new to Zoho but find it very simple to get a working database running. I'm trying to integrate a jobs database for my company's internal Google website and need to be able to push changes to the public corporate website. For my jobs site, I've successfully embedded the app into the internal Google site but anyone can add/edit/delete jobs even though I unticked all three in the settings. Is it because I'm logged into my account? If I could get permission to make the site public, then
Radio Button Display adds the intial choce to the List of choices
Hi Did Radio buttons always work like this or has something changed Radio Button A B C Initial value: Z (why because i want a default other than the choices BUT The Initial value:, is now displayed as one of my choices Radio Button A B C Z
Can't download or delete a backup
Hello, I'm currently trying to delete the oldest backup version for one of my apps in order to create a new backup but when I click to delete it nothing happens. Also for the same backup version when I click download I get an error page: "An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused." I can download all other backups and I would assume I can delete the others although I do not wish to delete them yet. Thanks
Error in views editing
If I have a view with a lot of fields in a view, and I enter in the view definition where I delete most of them in order to have just a few displayed on the view (and there is no syntax problem), the following error message is displayed: Error modifying the page Exception occured while publishing message to the topic :: [DataModelTopic] I don't know if this is something specific to the application I work on it or there is a limitation in views editing. Regards, George
ZOHO DOCUMENTS
I AM NEW TO ZOHO TRYING TO DO A LEGAL FORM BUT WHEN I TRY TO FILL IN BLANKS THE FORM MOVES. WHAT DO I DO TO STABILIZE FORM?
Error when creating report
I have been trying to create a report for our team -- but each time I try, it fails. I have tried changing some of the parameters (different name, save to different location, based on different query). To no avail. I keep getting this message: "Sorry. Error occurred while creating the report " Any suggestions? This is the first time this has happened -- perhaps a temporary hiccup? Thanks, Kim By the way, have tried with both Firefox 7.0.1 and Chrome 14.0.835.202
Creating conditional code based on form selections in the same page
I have a product selector where there are four fields: Category Item Price SKU Each SKU is a unique combination of Category and Item. I'd like to create a field that automatically populates the Price and SKU based on pulldown selections of the Category and Item. If I were able to code it in SQL, it would look something like SELECT SKU, where Category={pulldown.category} and Item = {pulldown.item} AS SKU SELECT Price, where Category={pulldown.category} and Item = {pulldown.item} AS Price I'm not
Next Page