Error when creating function - on fi
Hi Zoho, when creating a new function I got this weird error. why? Thanks Ravid
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
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
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.
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?
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!!!
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
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.
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
How do you show / hide fields based on a group
Hi Could you please help I have some control fields that are used by admin staff to control a users permissions. Such as setting the type of user in the portal, business user, general user, etc. I cannot let the portal user see this information or edit it. I do need the admin logged in users to be able to change it. As field permissions only all "Everyone" or "Admin" (I would have loved this to be a user group - but I cannot find it) I am using a method of show and hide. I can turn on access for
Android Creator app login
I am having trouble signing in on my mobile phone – I am new here and this is the first time I am trying this. I am set up on Creator on my desktop and built the first demo. I am trying to sign in with my phone# which is on file, and the correct password. I can sign ok to my computer but not to the phone. This phone number is on my profile – I am entering just the 11 digits phone# exactly as it shows in the profile, tried all combinations with and without the (+1) that is on front of it.
old. values of subforms fields
Hello, Does any one knows how to access the .old field values of subforms fields in the validate event ? Thank ! Pierre
Enable or disable subform fields based on another subform field
Hi there I have a form with subform setup. On the subform I have dropdown field - i want to enable or disable another field on the subform based on what value is chosen on the dropdown field - is this possible? I have seen in the forums from about 5 years ago you could only enable/disable subform fields from the on add/on edit of the main form, but am hoping that this has now changed. Thanks Aaron
Seeking developer
I am part of a team of roughly 20 people. We have three tasks that must be completed 7 days/365. I would like a task reminder that notifies the team when the task has not been completed as well as a team email that informs us that the task has been completed. For each of the three tasks, there are three people that are responsible for completing them. The three people for each task will often change on a daily basis. I need it so that if the first person (primary person for that day) misses
Does Show Field To Admin Only setting on forms apply to reports or views?
If a form field is configured to "Show Field To Admin Only" and that field is used in a report is it supposed to show to everyone? I have a URL field that will be populated through Deluge as records are created and updated. In this case the field should not be visible. For reports I do want the URL field to be visible. Thanks
Custom icon for Zoho Creator app when accessed from iOS
I have an application that I'd like users to be able to access on the iPhone (via the Creator app). That works find if they load the Zoho Creator app and then select the application, but what I really want is a simple way to install my app so that it has its own icon/shortcut. I'm sure it will have to access the Zoho Creator app behind the scenes, but I don't want the user to have to remember that "Zoho Creator" is how they get to my app. It's a confusing extra step. Is there a way to do this?
Setting the height of a multi select list
Is it possible to set the height of a multi-select, lookup field on a form? I tried the instructions here (https://www.zoho.com/creator/help/fields/setting-field-width-and-height.html) to no avail. The height setting is missing. Here's a screenshot of the form field in question: Here's a screenshot of the field properties. Note that I have tried changing "field size" to be other values, including custom. It just change the width. Any help is greatly appreciated.
Updating Value of Checkbox On Edit -> On Success
Hello, I have a list of checkboxes, like Notifications: First Email Second Email Third Email i want to update(check/tick) the 1st option "First Email" when "if" condition gets true. What i have done so far (On Edit -> On Success) if(input.Email == "xyz@email.com"){ Notifications.select('First Eamil'); } This doesn't work. I am getting the alert like this "'Notification' can be used only in on load actions". This works in "On Edit -> OnLoad". But i want to do it in "On Edit -> On Success". Kindly
"Approve / Decline" notification when data is edited? // field and form name as a variable?!
Hi Zoho, I need to create some verification system when certain users change data in a form. So when the user tried to edit data in a form, I will get a notification on the mail with an option to either approve or decline the change (decline = no change is made, approve = the field gets the suggested data). I thought about creating a "Change data form" that will be auto-filled and sent via email when an edit is suggested. in order for this to work properly, I need to have variables used for the
"Allow HTML tags" is missing
I want to experiment with adding conditional scripted cell colors on some views. I understand I need to check "allow HTML tags" in the app settings. However, this checkbox is MISSING in the app I am working on as well as one other app but it present in 5 other apps I have created. I cannot understand the reason why it would be missing, however, when I try and apply HTML tags to cell text, the HTML tag is shown in text, which is, of course, not what I want. Any ideas here? DJ
Error: The remote server returned an error: (400) Bad Request. -Zoho Creator XML RPC API
I am trying to use Zoho Creator XML RPC API. and I always get back an error which is above. I send to this url: https://creator.zoho.com/api/xml/write/woodcliff-rewards/Rewards With this postcontent: <form method="POST" action="https://creator.zoho.com/api/xml/write"> <input type="hidden" name ="authtoken" value="xxxxxxxxxxxxxxx"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <textarea name="XMLString" > <ZohoCreator> <applicationlist> <application name="woodcliff-rewards">
Alert won't pop up on "On Validate"
Hi Zoho, I have an alert that needs to pop up when a form is sent. This only to inform the user, I don't want to cancel the submit. The alert does not pop up. Why? Thanks!
changing rich text to multiline
Hi i have two questions on that topic. 1) is any data going to be lost in that transition from rich text to multiline ? 2) how do i convert the rich text to simple text ...i.e. how do i get rid of the <br> without losing the return paragraph function...
Auto Fill Field in Subform Of all the lines
Hi, I fill in a subform, but fill all the data from it after that and add new rows. With my code I can only fill in the first line and I do not want it to be "on add row". if(input.Tipo_de_orden1 != null) { input.Registro_Mercancia.Tipo_de_orden1= input.Tipo_de_orden1; } Thanks
Hide Grand Total but keep totals in Report
Hi there, I have a report which contains prices comparisons, which are grouped by suppliers/contract terms/... and I set up price totals for each group, which is what I want. However, in the report, I keep on getting a Grand Total on the bottom line, which I don't want as the purpose of my report is to give my client the opportunity to compare prices between different suppliers, so the Grand Total does not mean anything and need to be removed. Any advice on how to do that? Thanks Maud
Disable entire subform
Under certain conditions I want to disable an entire subform. To hide the subform I can use hide name_of subform; But disable does not work disable name_of subform; Do I need to disable each field in the subform?
Multiple "for each line" statements
Hi, I'm still learning syntax so i'm hoping this is as simple as rephrasing / combing, but i basically have a couple instances where i want to use an expression to apply in two different ways, but it seems i can't use "for each line" twice like this. (On load) for each line in Prod_subform { line.Previous = true; } for each line in Misc_Subform { line.Previous2 = true; } (On Success) subformContent = ""; subformContent2 = ""; for each line in Prod_subform { if (!line.Previous) {
Overview in the building zone
Good morning... When developing applications it would nice to have a table or database type overview of all the forms in the applications. Maybe even with links that indicate the lookup fields between forms. This has been asked for before but i can't seem to find an answer. It would really be helpful. Regards, stefan
change the display name of a field via script
Hello Zoho creator developpers, I want to know if there is a possibility to change the display name of a field depending on a condition. Something like: If (expression) { // set the display name of input.fieldDelugeName to "company adress" } else { // set the display name of input.fieldDelugeName to "contact adress" } That will save me having a lot of field that do the same and use theme everywhere other script with conditions. Thank you
How can I find out the number of related records in the child table
Hello How can I find out the number of related records in the child table? Thank you. only_relational_count = SubForm [ID == ID].count(); //not working
How to use GetURL to get a form's data?
Hi Zoho, I'm trying to use the GetURL task to pass a form's parameters. Unfortunately I don't have much knowledge in programming, and would appreciate if someone can explain this a little more: I Currently have a <form> in an html page, and I would like to send the data to a Zoho form, as a parameter. Where should I put the getURL task? and how should I write it? Thank you very much Ravid
Zoho Creator > Workflow > Set rules and tasks
I am creating app as seen in Zoho Creator Video, and having issues: https://www.zoho.com/creator/tour.html# Click on Video link (in the right) under “Automate Workflow” …. “Set rules and tasks” Go into Video at 21 seconds where it sets Quantity Greater Than 21 For some reason I do not have option under this dropdown in my portal. Will appreciate help. Thank you; Ramesh Kamath
Set the value of a lookup field
I have a form with a dropdown question and below that a lookup field. I wrote a code as below to set the value of the lookup field according to what is selected in the dropdown question above: if (input.Use == "R&D") \\ if R&D is selected in the dropdown question { input.Type_of_Sale = Types_of_Sale[Type_of_Sale == "R&D"].ID; \\set the value of the lookup field (Type of Sale) to the ID # of the R&D type of sale } Because it is a lookup field for the form: Types of Sale, I had to set it to the
Unable to use If condition in For each Rec loop
Hi, I am facing following problem while inserting records in a table. If I give any if condition in " for each rec in R " loop, I get an error. If I do not give any if condition then the loop works fine. Is it now allowed to give an If condition with For each Record loop. Pls clarify for each rec in R { if (rec.Dep_Method== "Straight Line") { D_Amt = (rec.Pur_Value - rec.ESal_Value)/rec.Exp_Life; } insert into Depreciation_Details [
Next Page