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.
File Uploads from Local Computer and Google Docs, but no Zoho Docs or Dropbox?
At this link: https://www.zoho.com/creator/help/fields/uploading-files-and-images.html it states "The File Upload field type is used to upload Files in Zoho Creator. Files can be uploaded from your local computer or from any of the supported cloud storage services like Zoho Docs , Google Drive, OneDrive, Dropbox and Box ." But the Browse Options at that page only show Local Drive and Google Docs. What am I missing?
Columns missing in Pivot Chart/Table
Available Fields for Selection (Missing): Actual Fields in Form:
Records sent to 2nd form
I have one form that creates records when filled out. Is there a way to have some info from that record automatically get sent to a second form and add an entry there? I want that second form to be populated with entries from the first form but also other manually entered and imported records.
Pivot Table not showing fields.
I have an employee form with some fields. Now I am going to create a Pivot Table report for that form. And In report creator its not showing all the fields that are available in form. I am stuck in this and don't know how to show all fields. http://prntscr.com/aeo99p http://prntscr.com/aeo9li I have also used "Column Properties", but nothing happen. I hope you have solution this. Thanks
<style" onload=alert(1)>.aa{}</style>.aa{}">
"> .aa{}">
Zoho Creator REST API VB.NET Samples
Hi Everyone I need to be able to update my Zoho Creator instance with data from my on premise ERP system. I believe i can perform this with the use of the REST API but am unable to locate any samples of the coding for this using the auth token. I was able to locate a ticket based sample but this has been discontinued by Zoho. I was unsuccessful with converting that sample to auth token. If anyone has a .NET sample code for an add/update REST call to Zoho Creator it would be of great assistance
Report Column Not Sorting
Hi I have a report based on Form A. I have also included a date field from Form B. The report is working fine, except I cannot sort asc or desc by the date column (the one coming from Form B). Is there a trick to getting the data sorted by date in this instance? Thanks.
Delete pre-made app
Hi I found how to delete the (useless) intial pizza delivery app. But I am not able to delete the installed pre-made app (Project Tracker). If I cannot edit it, I don't want to have it sitting there. But there is no option to get rid of it. Can you help?
Creator Html page with auto fill
Hi there, I would like to set up a creator page that has a dropdown list, and when i select a value in the drop down list i would like values on the form to populate. So for instance i would have a form with Job number and Price fields and when i go to this page i would like to select the job number and the price field to be auto populated. Many thanks
zoho crm field
using the zoho crm field button on our forms and recently the data it pulls over is from the same form but not the field we want. Example product name . screwdriver product code . scr11 price . 9.99 if there is no product code it will use product name but if there is it pulls over the code instead. It did not use to do this and the girls in the office are shouting loudly at me. Help
Drop Down Menu Search Breaks on Dynamic Drop Down
Hello. I have a dynamic drop down menu set. On mobile, when I initiate a search within the drop down, no results show for my en try and I have to back out of the application in order to have the results refresh. Thanks, B
Next Page