Is it possible to call forms without having to use the custom portal, through a user table?
What you want to implement is a user table s to have more control of the forms you view, since the portal costumer no longer gives us the filters we need.
Also, how could we fill fields if we have a form on an external website?
xml-based POST html form keeps downloading files?
Hi Zoho, I have an html page (Dashboard_test) with an html form is it, forwarding the data using POST command to a Zoho form (FnA_Bulk_Edit). Two problems: 1. When submitting the form, the user gets an xml file auto-downloaded. How can I prevent this? 2. In the On Add -> On Success script of the Zoho form, the script is processed but fails to open the url (last command is OpenURL). How can I fix this? Please check the page and form and let me know how to fix this. I'd really like
Duplicate an entry that doesn't allow duplicate entries?
Is there any way to code, to change the data that doesn't allow for duplicate entries. I have a LOT tracking system and the LOT numbers can not be duplicated. YYMMDD## I want to duplicate the record and sub forms but change the ## before doing it so the record won't be a duplicate. I've tried from a report to check the box and click on the duplicate icon only to have it fail. Any way I can do this via a program or catch it before it it tries to store the record? Thanks Andy
Deluge - if no record found set value to 0
Hi there I'm using the following code //Get the discount amount based on the discount code fetchdiscount = DTKC_Discount_Configuration [Discount_Code == input.Discount_Code]; input.Discount_Amount = fetchdiscount.Discount_Amount; input.TOTAL_TO_PAY = (input.Total_Cost_Before_Any_Discount - input.Discount_Amount); My question is - if there is no match for Discount Code, how do I force the input.Discount Amount to be 0 At the moment if there is no match I get an error saying something to the effect
Traversing the fields on a form not restricted to tabs and mouse
Using the tab or mouse to move from field to field will not be acceptable for my application. I would like to move from field to field via hitting ENTER. Upon hitting ENTER at the last field, the insertion point would move back to the first field. Submission of form would be by button.
Subform in subform
Hi, it´s possible to have subform in subform? When I do this in creator.zoho.com, in mainform (view) on app.zohocreator.com I can´t see that. First subform contains Date of order, products (it´s subform) and user. Second subform contains select products, price, quantity and total price. On the picture you can see forms and subforms. First picture is subform in mainform. Second picture is subform of Order (Objednávka). In this subform is antoher subform, but is not possible to see in mainform. Third
Passing "OR" criteria through URL to a view
i have a view in which i need to pass logic that contains OR such as displaying a list of employees whose name is Richard or Dick, how would i correct this url to include OR DICK. http://creator.zoho.com/zchelp/employee-manager/#View:Employee_View?Name=Richard
Drill down not possible
Hi, I have given a user permission to view a pivot chart. I have enabled " View underlying data" in the report. With my adminitrator account I can see the "Drill down" menu when clicking on the graph, but when I try to log in as the normal user I can only see " View underlying data " and can not drill down from months to weeks to days. Is it a permission issue?
make conditional forms for pivot chart that only include certain values in the fields
Hi I want to make conditional forms for pivot chart that only include certain values in the fields, but I do not know how to do it inside the pivt chart. Usually the code would be: ventasebay= Ingresos_Egresos[Tipo_de_ingreso== "Ventas Ebay"].sum(Ingresos); I would like to have that code for pivot chart: Example: Sumif (Region = 'East, Sales, 0)
Customer Portal Redirect
When working with the customer portal, is it possible to redirect the user to a specific form on your application? Or will it always by default go to the first page in the application hierarchy?
input.Field = old.Field doesn't work when old.Field=null
Hi Zoho, On my "On Edit -> On Validate" I have a script with a rule, in case the rule is not applicable, I'd like to revet to the old data. for this I'm using input.Field = old.Field. but - on fields when the old version does not have data (null) the input.Field is not updated (say with the new data entered. Please fix this Thanks Ravid
Need upload function using curl/Rest Api in zoho creator
Can you please send the example working code that to upload a image via curl_exec() function what are the fields i need to pass via curl call
How can I save a file on a File Input field using script/function?
Hi there! I need to put a file into a File Upload field using script. How can I do that?
Is it possible to move/copy a Personal App to Workspace App?
Inadvertently created an app under Personal rather than Workspace. Is there any way to change the type of app from Personal to Workspace, or to move/copy it to Workspace?? Thanks!
data saving
Hi, I run a mobile dance club in the uk. I've had a developer from this site working on a simple datadase with a event calendar with some email support.. this has taken longer than expected but looks and works ok... But i have a problem with the event payment section... Zoho does not save data automatically and the way the adding members and payments has force me to start looking at other software... the designer has given up he cannot work out a way to do it... this is how it works now . Open calendar
Validating SubForm Data
Hi there I have a Parent form "Bookings" - fields include Name, Company, Email, Phone I have a Subform "Booking Detail" (field name Booking Details). I have code on the "Add Row" to populate fields on the subform - effectively transferring the parent fields to the subform. The problem with this approach is if a user adds a row to the subform BEFORE filling in the parent form, the details don't transfer down. The other scenario is where they enter the parent form fields, add a row/s, and then before
Zoho Creator Android app - offline forms with workflow workarounds
One of my main requirements was offline data entry, and I made the mistake of not fully understanding the limitations of the mobile app. I built an application with all sorts of workflow scripts and lookup filters only to find out that neither of these are supported when accessing forms offline https://help.zoho.com/portal/en/community/topic/zoho-creator-ios-app-3-7-2 My question is if anybody has found any workarounds for some specific cases: 1 - filtering lookups when accessing the form offline
Update a record through zapier
Hey zoho, I would like to update a record when a specific event from another app is trigerred using zapier. As you dont offer updating through zapier, is there a way to do it anyway ? Thanks a lot for Tour answer
calculation on date field
I'm new to zoho I have a form with date field which the user has to enter. I have another field which I want to calculate based on the date entered by the user. I want the calculation to be "the date entered + 9 days". What s the best way to do this ? thanks for any response
Unknown Error
Just got this error: Left expression is of type BIGINT and right expression is of type BIGINTLIST and operator + is not valid Anybody know what it means?
Zoho creator to Quickbooks customer mapping
So I wanted to be able to create a customer and add info from a created sheet when it is submitted. I am able to create the customer and add Family name, display name, and billing and shipping address info with the following code: //Declare Map Variable to hold the customer details Customer_Details = map(); temp = Quote_Sheet [ID == input.Customer_Name]; //Add the customer details to the map variable Customer_Details.put("FullyQualifiedName", temp.Customer_Name); Customer_Details.put("DisplayName",
Contact Form Not Redirecting to "thank You" page
My contact form is not redirecting the user to the thank you after they fill out the form. I'm considering zoho for my company but having this issue is not helping. http://residencialsantaelena.com/contacto/
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.
Next Page