Add Record - Subform with with multiple entries
Can I have each row of my subform create a new record with add record? Currently if I have 3 rows only the top row gets added to the form using add record. I don't have 3 new records in that form.
Failed to submit form data
I am getting failed to submit form data error when I try to insert records in my form. I checked that the one entry per ip/user is clear. Even when I removed the validation, I get the same error. Please guide. My application is shared for support access
Currency in millions
What is the best way to show currency in millions like $2.6
UNABLE TO UPLOAD File from Mobile Application where Form is embded with iframe
Dear Sir, In Form, there was one filed with File Upload. The form is embed in website as well as in android mobile application with iframe. The form is open in mobile application, but at the time of upload file, we are not getting file file for upload. Please check it and do the needful at the earliest. Thanks Deepak
How does the admin share the app with another user in order to enable the native mobile app on phones?
How does the admin share the app with another user for them to be able to use the Zoho Creator on Android? When the other user signs on, there is no apps available under Shared Apps.
Can't open page editor
I have an html page, and when I try to open the editor, the page hangs and never loads. The html pages still load, but I can't make changes to them. Anybody have any ideas? I have submitted to support already...
Problems - Learning how to Fetch Data between Applications
I've searched the forums up and down, and have not been able to find any RECENT solutions for what I need to happen. I bought into zoho creator because it is a database solution without having to need to know how to program and write code, however what seems like a fairly simple solution is requiring that I do just that. Here is my situation: I would like to fetch a record from a seperate application. To keep it simple here is the example Application1: "Form1" includes fields: Name1, Type1 (Name1
Linking Records / Fetching Data / Custom Buttons - How do i do this?!?!?
I am trialling Zoho as an easier option to learning how to code a database, but I am struggling with certain linking fields from different forms and to display that information automatically. My scenario is: We received enquiries from various customers that we have an Enquiries form for, we then work on these enquiries and quote them back to the customers and then when we receive a purchase order for an enquiry that we have quoted we will have an Order. The fields in the Enquiry form include: Our
upload file
Hi I've been testing the form creator and database for a job I'm working on. It's absolutely perfect for what I want. However, for some reason I can't get the file upload to work. I created the form put the code in a web pages and entered some test data. The jpegs I uploaded via the form don't appear in the database nor to they appear in the email alert. Please help I would really like to use your application. Cheers Nomes nomes
Form Data > CRM Data
Is it possible to create a Zoho Creator Form/App that can be emailed to my Clients with their "current" CRM Contact data (such as phone, address, email, etc...) and asking them to input new data for fields that might have changed, (such as new phone number, new address, etc...) then have that new data auto-populate their respective CRM Contact page?
Formula Field went blank and did not update
We changed the Formula inside one of our Formula fields and after about 25 minutes, the field went blank. We have 18,000 records, but this Formula field remains blank. Please advise?
how do i enable native mobile app from my online account?
how do i enable native mobile app from my online account in order to set up the Mobile App on my Android?
Variable Schedule Period
I'm currently struggling on one rather key element of the creator and that is to find a way of selecting on the form whether an automated schedule should be 6 or 12 months. I'm aware that there is an option to have a recurring action on an annual, but not a 6 monthly basis - an also I need for there to be an option on the form itself to determine this and feed into the automation to create a new entry. Could anyone spare a few minutes to help me out on this? Thanks in advance, Seb
send email with attachment spreadsheet
Hello, can I send an email attaching a spreadsheet file containing records? It can not be a solution to send a link to view the records through the zoho. Bye David
Dynamic picklist
Hi guys, I want to add a criteria that remove Staff that have more than 10 Service record from Staff lookup picklist field in FormA. At the moment I have script that filter Staff for Services offered. Is possible to add also this criteria? I try with IF and FOR EACH without success. Thanks for any help. Mike Copy code stafflist = (FormB[(Service == input.Service && Status == "Active")].ID).getall(); Staff:ui.add(stafflist);
How to refer form fields in other application to current application. Both the applications are in the same account.
I need to refer a set of fields in a form in other application in my account. I have written code like this. But it is not accomplishing my requirement. row.Part_Number = FormA.Part[ID == PartID].Part_Number; FormA is the other application. Part is the name of the Form in other application. I need to refer all the fields in Part to my current application. Please suggest a solution for this.
Invalid entries found. Please correct and submit again.
Beginning today, I have begun to get the error message "Invalid entries found. Please correct and submit again." as I am making very minor changes to records in the database. Not all the time, but maybe 1 out of every 10-12 records this will happen. It was a valid record before, and all I am doing is copying one field and putting it into another field. It works most of the time. I have closed and re-opened with no change. When it happens I cannot save the record.
lookup data showing up as a number
I know I have had this before, but I am having a major brain fart. data from a lookup field is showing up as a number when I try to use that field with the send mail function.
Color Code Items in Calendar??
Hi Support, Is there a way to color-code items in the Calendar view? We have a client who would like to have this feature. Please advise. Thanks, egressmedia
Zoho Creator fx formula help
I have values in my forms that are (36" - 914mm) and also (50" - 1270mm) i am trying to create a fx formula that will return the values of these forms so that i get (0.914) and (1.270) if anyone could help it would be much appreciated..
Set Filters for dependent lookup fields
I have a form that contains two lookup dropdowns from two other forms. I need to populate the second lookup based on two fields shared by the the first lookup. I used the SET FILTERS dialog to generate ((((LGA==input.Ward1.LGA)&&(RA==input.Ward1.UID)))). However, the second lookup does not populate at all and only the first part LGA==input.Ward1.LGA gets persisted. Please assist. Thanks.
Help - When trying to change Default Permissions for my forms the screen hangs.
In Enterprise addition I am trying to change the permissions on an form to allow public access. When I go to Settings->Users and Permissions->Advanced Sharing Settings. change a setting and then click 'Save' the screen hangs. Can anyone help me on this - is it a browser problem (although I have tried different browsers) and even tried on my Android tablet with the same results. I also occasionally get this when editing a script - dragging insert a function for instance causes the screen to hang.
How can i put my google calendar insde zoho creator?
Can you help me with this? I really need this done.. please
Fetch CRM Field from Another Creator Form
How do I fetch a CRM field from another Creator form? Order form has a drop down "Generator" linked to Generator form. Generator form has an Account CRM field. I have an Account CRM field that I want to update in my Order form based on the Account linked to the "Generator" drop down. (For us Generator is an environmental term for a facility that requires service / Account is the company that will pay the bill.)
Maximum published components limit - for Professional and Enterprise
I currently on the Standard Edition Problem 1 How do I do this, public sharing on the web? https://www.zoho.com/creator/help/application/application-sharing.html#Make_Public_to_all_visitors_over_the_web I don't see the option in my account. Problem 2 I know the maximum published component is 3 for Standard edition. But what is the limit for Professional and Enterprise? Problem 3 I try upgrading my subscription by selecting Professional edition and upgrade, but all that happen is the page submit,
Application Context Issue for New Users
The verification email sent to new users (example below) has a link to click to finalize the verification. When this link is clicked you get the "continue to sign in" web page. When that link is clicked, the user is not directed to the application, but to this: This is causing all sorts of issues with users wondering what they are supposed to do. The links should all direct users back to the application where they created the zoho account. Please fix this immediately! Cheers, John Whitney
Can not set Decimal and Currency Fields to 0.00 via Script
I have a Decimal Field and a Currency Field (USD) in a Form ... both defined as having 2 decimal points and initial value of 0.00. They both display 0.00 when the form is initially displayed. I have script that does ... input.Decimal_1 = 0.00; input.Currency_1 = 0.00; However, when invoked, the values in the field boxes are displayed as 0.0 ... i.e. just one decimal point. And when I return to Edit Mode, the commands have been changed to ... input.Decimal_1 = 0.0; input.Currency_1 = 0.0; I believe
Summing the data in specific field in subform and display result to main form.
Sir, I have a sub form named Request_Parts with fields customer_request_id, part number, Part name, retail price and serial number. I have a main form which contains total price. My requirement is that I need to get sum of the retail prices(sub form) in total price(main form). I am using bi-directional relationship with the child and parent table. I have used the following code. but, i am unable to save the code because of the highlighted portion. total1 = 0; for each row in input.Request_Part {
Launching a detail report from a summary
I'm sure this is easy but I haven't found explicit instructions by searching through the help pages or forum. I have one form that contains all the player information for a sports page. On my Web site I want to list a subset of the data (easy enough to do, I created a report and then embedded it in the Web page) with the option of launching a detailed report from the summary. The summary report embedded in the Web page displays Player Name, Team Name, Positions Played, Jersey # What I need to
The effects/code that made in the sub form is not taking effect on the parent form. Why?
The effects/code that made in the sub form is not taking effect on the parent form. I have made a sub form with fields like Part, Part Number etc. Where part is a drop down list and Part Number is a single line. While choosing a part, the corresponding Part number will be displayed in the Part Number Single Line field. While i am inserting the sub form in a parent form, sub form is not working as expected. Similarly, i have increased the width of Part drop down list in sub form. But it is not applying
Record limit reached - count inaccurate
Hi, I am getting the record limit reached error but am certain I have not reached my limit. I am trying to import data that keeps failing. However, I think the record counter is increasing even though no data has been loaded. I have topped up my account and attempted to load data again but it failed. However, the "Records Count" went up by 740 even though there were 860 records in the original file for import. When I go to the view, there is no data. In the past, I kept topping up more records but
How to Display Data in the Following Manner
Sorry the title is not too helpful. But I need logic help. I have the following two forms: TERMINALS - Terminal Name - Cleared Carriers (this is a multi-select lookup field) - Zone CARRIERS - Carrier Name - Setup: Terminals (The bidirectional lookup of the field above) What I am trying to do: I would like to generate a report that shows all of the unique (distinct) carriers in a zone. TERMINALS.Zone CARRIERS.Carrier Name 1 CARRIERS.Carrier Name 2 CARRIERS.Carrier Name 3 CARRIERS.Carrier Name 4 CARRIERS.Carrier
can't make page private or limit to certain users???
i have been using creator for 4 to 5 years. i have always been able to share to certain users only the three items ( forms, reports and pages ( used to be html) . The new app builder works fine for forms and reports BUT DOES not obey my share for pages. No mater what i do ALL pages are public requiring no sign in????? please help?
Report Settings: tell us the Section
From the Report Settings General screen, I would like to know which section the report resides in - Without that info, I need to navigate to Settings->Section - and then search for the report name. Also ,for apps with lots of sections and reports, I would like the Settings -> Section interface to be easier to navigate; perhaps via tree component.
Subscribed, and now I'm locked out!!
I finished my trial, decided to commit, subscribed.... and now I cannot access my database!!! Any suggestions?
HELP SUBFORM ACTIVE
Hi! Someone can help me fill in fields with a subform where the main form fields are lookup´s
Fetch record
Hi guys, I need fetch record that match the criteria of total of request submitted for day are < 100 and alert that which is the first day with less than 100 request submitted. How can I set a complex criteria that collect Day = input.Day < 100 and then return first day available? I try some count function and expression without success. Any suggestion? Thanks Mike dayavalaible = Form [ID != 0] sort by Day range from 1 to 1; dayavalaible1 = dayavalaible.Day; alert("First day avalaible"
Not a valid currency error
My client reports: I continue to experience errors when attempting to import currency from my excel files. The issue began about 4 weeks ago. Previously, for the past year, I never had an issue. I have not change anything in the excel files we import from. Seems Zoho has changed something. I am having to edit 9 excel files each week so the Zoho application will accept the import. Then I have to change each excel file back to its original format so I can email to customers. Wow, what a pain! He
Column does not show as option for report?
I have attached screenshots for reference. The column "Agency-Vendor Id" is not appearing in the pivot table I am creating, while the "Status Category" column shows up and works great. Does anyone have any insight to why this is occurring? Thanks.
Zoho Creator calendar popup
When using a date/time field in Creator, the program puts a calendar popup for the user to choose the date and time. Unfortunately, in Creator, the popup is kind of awful. It looks ugly and it is horrible at selecting the time because you can't scroll through the time. You have to click. I'm sure you know what I mean. (I'm sorry if that was a confusing description.) The date/time popup in Zoho CRM, on the other hand, is much more user friendly and looks a little nicer. Is there anyway to use
Next Page