Google AutoComplete Address DropDown
Hey Zoho Team, I need to make a google autocomplete Address Dropdown for my application. I need to know how is this possible with your javascripting code side. or any other alternative to do this. I am attaching a Screenshot for it also. Please Check and Explain with your best Example. Thanks
File Uploads Using Zoho Creator API
Hi, I'm having trouble getting a file upload field to work using the Server Side Rest API in my form. Please see code below: <form method="POST" action="http://creator.zoho.com/api/xml/myapplication/myapplication_Form/add/apikey=XXXXX&ticket=[XXXXX]"> <table> <tr> <td>Photo Upload: </td> <td><input type="file" name="Photo_Upload" size="19"></td> </tr> </table> <input type="submit" value="Submit XML String" enctype="multipart/form-data" > <input type="text" name="zc_ownername" value="[myname]"> Everything
Auto Number
I would like to auto generate a unique 3 digit number in field "wiring_reference" in wiring "table". The number needs to be unique for each "site" which is selected from a look up field of "wiring_site" in the wiring table which looks up "site_reference" field of table "sites"
Auto-Field Updates
Hi everyone, I'm new to using Creator and am confused about how to accomplish something. I have created a call-tracking form that fetches contact records from Zoho CRM. I can't figure out how to auto-update the next field, which is the customer's account number; this is a field in CRM. Does anyone know how this can be done? I have checked different help articles and am still confused. Any insight would be greatly appreciated. Xavier
Fetch Data from 2 different form?
Hi people, I'm newbie to creator and deluge, I'm following forums and help center and creating a application for my business needs. I have problem with fetch datas. Let me explain the structure that I have create and ask questions I have 3 different forms and; First form called Courses, it has 3 different single line text fields to explain 3 features of course (1st one name, 2nd one group, 3rd one Semester) And second form called Students; this form has student information and course information,
Zoho creator: How to add a record from a vb.net forms application
Hello, I am struggling for one day and I hope someone can help me. I try to add a record from a windows forms application using vb.net. This is my code: Public Sub addRecord(ByVal ht As Hashtable) Dim apiUrl As String = "https://creator.zoho.com/api/<xxx>/xml/<appname>/form/<form name>/record/add/" Dim xmlStr As New System.Text.StringBuilder xmlStr.Append("<input type=""hidden"" name =""authtoken"" value=""abcdefghijk"">") xmlStr.Append("<input type=""hidden"" name
How to Renew My domain
Need help renewing my website so it can be alive. Please assist me in this matter.
Function works only for one field !?
Hello All I created function to fill 2 fields with current infos in the report when button clicked to update instead of ask user to refill it , Function works well but with one field only , I don't know how to make it work for 2 fields when use " &" or other symbol error message appear , when use " +" no error but all string come in one field , Patient_Secludes void progress(int ID) { (this one working) a = DrNote[ID == input.ID].Patient_Secludes ; (No working even added after comma in
Looking for some one to build me a Data Base and CRM ASAP
Hi, I am looking for some one to build me a Data Base and CRM ASAP who can do it Skype gabigeva regards GG
Pass information from one form to another
The reason for my mail is to see if you can help me in a development that I am doing. The main problem is that I need to pass information from one form to another, through global variables or functions, depending on the case, I would like to know if there is a way to do this, and that my action is executed when you press a button or similar. Thanks!
search interface
Hi, I’ve successfully created a search page with html views. The search page allows our users to type in a keyword from any of these fields, Requestor, Request Details and Response. The script is – <%for each find in Add_a_reference_request [((Requestor.contains(input.searchStr) || Research_Request_Details.contains(input.searchStr)) || Response.contains(input.searchStr))]... What I like to do is to create a Boolean expression for the search. If a user types in a requestor’s name and a keyword
cannot edit site, everything isnjust freezed, no drop down menus and cannot publish it. HELP!
when i open my site editor, i cannot edit anything and when i click on publish, the loading bar pops-up and nothing happens for hours.
'item' is a lookup field and child fields cannot be accessed
Hi, I have 2 forms First with product name and rate second quantity and amount i want to multiply rate from parent form field with quantity of child form field and display in amount field. Please help new to zoho creator.. I get "'item' is a lookup field and child fields cannot be accessed" error thanks anand
Cryptography Function (SHA-1)
I need a function that calculates an HMAC hash from a Date String as the value, a shared Secret Access Key (both the sender and receiver have this key), and SHA1 as the hash algorithm. Why? This is a simple way to verify the authenticity of information. For example, if you send an email to a client and included the hash as a "signature", the data can be validated by the client. There are many instances where this would find value. SHA1 is a standard cryptography method Many APIs require a hashed
Problem with Lookup Function
I created a form which does a lookup for PO number from another form, this works fine, however when I try to lookup a second field which contains the PO Name information from the same form using the first lookup results as a filter I get a type mismatch saying I can not use that because it is a BIGINT format, but it was created as a string. Why is is converting this and how do I get around it, or alternately how do I bring multiple fields across in a lookup function and display them in separate fields
Subfrom on iOS app
There is no back button after clicking on a subform in the ios app. This is a big oversight because there is no way to return to the main from unless you add a subform record or close the app. If there is more than one record then the back icon appears but there needs to be an option to return when only one record is there or being added. What's the reason for this? Can this be fixed in the near future? Thanks
Find and Find+Replace
The utility for a Find and Find+Replace aspect to the script editor is obvious. For example, recently I have been converting all my internal URL references to relative links i.e. openUrl("https://creator.zoho.com/mygroup/inventory/#View:My_View","Same window"); to openUrl(("/" + ((zoho.adminuser) + "/") + zoho.appname) + "/#View:My_View","Same window"); Find+Replace would really speed-up the edits. John M. Whitney
Ability to drag attachements from emails straight into Zoho Creator
Currently, if I want to import an attachment from an email into Zoho I have to download it from the email onto my computer, then upload it into a Zoho Creator file upload field. It would be great if you could click and drag the document straight into the file upload field. For similar example, within Gmail you can click and drag an attachment from an email straight into a folder in Windows File Explorer.
SOS! specific entry can't be edited - user gets error
Hi Zoho When trying to edit entry in Loan_Valuations form (ID=2983417000014531035) - when trying to edit from the report, I get time out - when user try to edit using a link, she gets the following message: Loan - Vessel Valuation We failed to retrieve this form. An error occurred when we tried retrieving Loan - Vessel Valuation. This error has been reported to Zoho Creator support. created a duplicate of the entry, same problem please let me know how to fix Ravid
Creator Report with Zoho Invoice values
Hi, I would like to create a Report which include a value from Zoho Invoice. May I know what approach should I use? I read the manual of the custom function feature, but look like it is not I want. I would like to get an Invoice total amount and list it with every records on my Report, assume I already input an Invoice ID for each record. Thanks Mike
Is data stored in Creator encrypted at rest?
I know data is encrypted in transit. Is data encrypted at rest? This is a must for many governmental requirements.
How do I control column display in a subform?
My subform was created as part of the main form - i.e., it does not appear in the Dashboard as a separate report. When displayed inside the main form, it's displaying every column in the underlying form, and I don't want that. How can I control the columns displayed in an embedded subform? I can't see a way.
Error when creating function - on fi
Hi Zoho, when creating a new function I got this weird error. why? Thanks Ravid
How can I include graphics in Record Templates
Hi I have a report that shows company information along with revenues. To improve the look of the report I have created a record template. This works well for formatting text. However, I would like to create a graph or graphics to represent the revenue. I cannot find out how to do the following: 1. A Graph showing the last three years turnover 2. Display a different graphics to denote turnover level - eg A thumbs up for $100,000 revenue and a thumbs down for $100,000 Any ideas? Tony
Check MultiSelect/Checkbox is not empty returns error
Hi, When I try to use both of the following in a function I get an error: if(record.Multiselect_Field_Name.isempty() { } Error returned is: Error details: Error in executing On Edit - On Success script. Error in executing thisapp.Material_Issues_TS.Bank_guarantee_limitations function. Line:(184) Value is empty and 'isempty' function cannot be applied Line:(31) if(record.Multiselect_Field_Name.size() > 0 { } Error details: Error in executing On Edit - On Success script. Error in executing thisapp.Material_Issues_TS.Bank_guarantee_limitations
Look Up Current URL in Workflow Automation
I have created a URL field in my reports for the URL of the current project. I need this so I have a link in Advanced CRM directly back to the original project. So I've made a workflow automation that will fill in that field when the project is created. Now I just need to know how to use the current URL to fill in that URL field.
Customer Portal Customization
When using the customer portal, is it possible to directly alter the HTML for the template. For example, if on the sign up page I want to change the "Name" section to say "Company Name" instead, is that possible. Also, how would I directly alter the CSS of the template? Thanks in advance for your responses!
Relationship Between Forms and Subforms for Reports
I am trying to generate a report that simply shows me the sum quantity products sold. Form Name: Order: - Name - Address Subfom Name: Products: - Product - Quantity How do I generate a pivot chart report that gets the data from the subform? When I try to generate a report from the Order Data, I do not get the fields of the subform, and vica-versa. How do I run a report of this data with relationship? It seems the subform model is very broken because the relationship
How to integrate a sales order with the company stock?
Using the lookup field for the product, I need to associate the requested quantity with the quantity in stock. What is the best way?
Show Percentage as a image
Hi I am looking to put a percentage value in a record template. It would be nice to have this as a graphic. So rather than showing 10% i show bar with 10% filled in... So a graphical representation of the value. Is there any way to do this in Zoho? Tony
Client Script Actions Enhancement
So what are the enhancements? Client Script Actions Enhancement The Client Actions such as Form On Load, Field On User Input, Subform On Add Row and On Delete Row have been optimized for better performance. You can enable/disable this enhancement and test your applications on your own. Please write to support@zohocreator.com if you face any issues. The enhancement will be rolled out automatically in 7 days
How to change the width of a spreadsheet report?
I have a report with display type as spreadsheet. As we know, we can change the width column in List-Grid display type. What about spreadsheets? There is no menu 'change column width'. Maybe with a 'hack' CSS way in a HTML report? UPDATE from Manual The options to Add, Modify and Delete records will be displayed only if the Edit permissions are provided for this report, by the application owner. A Spreadsheet report does not support Set Grouping, Custom Action, Record Summary and Set Column Widths.
link of import data dialogue
old version has link of import data dialogue. but in the new version, there is no link in the form page. How can I get one? many thanks.
API Call Error - There is no such form
Hello, I am trying to make an API call to my Zoho Creator application to get the field names of a form to display in a mobile app. However, I am getting the following response: <!-- $Id$ --> <div style="text-align: center;vertical-align: middle;font-size: 14px;margin-top:150px;">There is no such form in <a href='/'><strong>Zoho Creator</strong></a></div> Here is the code I have written: var url = "https://creator.zohopublic.com/api/json/gymfinder/playerregistratation1/fields/"; var XHRResponse
Translation doesn't work with the new theme
Hi, I have six users and i pay $50 additional for each user to have the "Translation" option. Unfortunately, it doesn't work on the reports tab and it shows the drop down values as it is. Are you going to fix it soon or i need to change to the old view. Because the old view is very old and reports' options are not nice and not easy. In addition, i can't duplicate my application at the home window. I am looking forward to hearing from you. Best, Rami
Webhook/DB query/DB cache timing issues.
So On Create webhooks are firing before the data is populated/available, so when I send a Sales Order to my creator app I can't use it immediately which is causing my creator side stuff to die. Strangely enough if I put the same query in a REST client and send it to the creator app it works fine, every time. Is there an internal caching of db entries that the webhook hits or maybe the timeout is too short and it won't wait for the update?
Images captured within and uploaded through iOS app are highly compressed
Hello, I am trying to create an internal product review application where a user would submit an image via mobile device. However, all images submitted through the mobile app are compressed to 50kb or so, which is very small. I'd like to have images be larger and am willing to change file type (Image to Attachement) if necessary. However, even if I try to use the attachment field type, the same issue occurs. Thanks, B
Quick "On User Input" Question
I have a field that I want to to an action when the value has changed. Is there any way to know what the previous value of a field was? Field Name: Carrier On User Input input.Send_Email_to_Carrier = "Yes"; How do I test against the previous value? Hypothetically... if (previous_field_value.Carrier != input.Carrier) {//actions} Any help would be great. Thanks!!!
Hide button "Add new" in subform
I've always read that hiding the "Add new" button from the subforms was not possible, even with online help. I even searched the forum and they say it can not be done. (Hope I was wrong) I show you how I found a way to hide it with a simple ruler. 1. In automation, create a new task: 2. Create a new ruler: Result subform: If they already have it in good time. Otherwise I hope you find them useful. Note: I am also coultando the "X" that deletes a row. Greetings from Cusco - Peru.
Success notification emails not working on a regular basis
Some of the emails go but not all. Have checked spam folders and found nothing.
Next Page