Issues with Web Embed
Hi all, I'm having a couple little issues with embedding my database on a webpage, I wonder if anyone has encountered similar issues and if there's an easy solution. The first is that when I embed my reports, initially they never show up. It's only when I change the display from say List to Summary that they show up. Another issue I'm having is that when I search my app on Zoho, if I have a multiple select field when I go to search that field all of my possible inputs show up and I can just select
Bidirectional lookup from one subform to multiple mainforms
The solution offered here works perfect when there is one subform and one mainform. I have a scenario where I have one subform that is included in multiple main forms, and I'm looking to somehow link them together. If I try to add bidirectional lookups to the subform based on the existing relationships - I can only choose one at a time - so it only works for one main / sub relationship. Ideally I would have a single 'Source' column in the subform that is linked to the main forms that were used at
"Other" option is added to a drop-down even when the option is not marked!
Hi Zoho, I have a form (Loan_Valuations) that for a drop-down field of its suboform (Loan_Valuations_Broker - broker name field) it takes a list from a third form (Loan_Comp_Req - approved brokers field) and append it to the drop-down list On Load both on On Add and On Edit. This should not have a "other" option, and it is not marked as applicable anywhere. But: On Edit mode, there is an "other" option available !!! Please fix this ASAP. thanks Ravid
Complex criteria in pivot reports and charts
Some time back pivot reports and pivot tables were created based on views. The criteria embedded in those views were carried over into the reports. Since pivot table and charts are now created using the form, criteria restricting others from seeing the data is limited to 'Only logged in user records' and 'all records' but not to others authorized to view it as well. What am I missing?
Filter within an sub form
How do I filter within a Sub Form? In the "wiring" form we use Filter Site.ID equals input.wiring_site on a Device drop down. I want the same filter within a Sub form but it states wiring_site is not defined?
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
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
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!
'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
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
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
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?
Next Page