Error creating reports
Application: https://creator.zoho.com/essistmgmt/assets/reports/new/ I get errors when I try and create a report. Can you please investigate? Note, the application is shared to support for editing.
View filters bug
I have a view with 1649 records When I Search a column for "Is Empty", I get 1645 rows. However, when I save the view, I see 0 rows. Why does the view not show any records?
Example of validating log in
Hello How can I use log in form to open specific page for user, I know there is using for in success and rest of script, but need example, Thanks ?
Email Notification Sent on specific date
Can i send email notification to user exactly the date he/she inputs in the date field when submitting the form? I need to make a reminder form to remind user to do something in organization. please advise.
Problem with getting SalesOrder ID BUG??
Hello I am trying to access Product Details in the Sales Order form and trying to do it through Sales Order ID. I put a Zoho CRM field on my form called SalesOrder Name and I was expecting to have a SalesOrder_Name_ID provided to me in the Deluge "Refer Fields" list but all I get is a field called Zoho_CRM_ID. So I tried it: crmresp = zoho.crm.getRecordById("SalesOrders", input.Zoho_CRM_ID); input.SO_ID = input.Zoho_CRM_ID; Nothing shows up in SO_ID field on my form. Can you help my understanding
Employees to access Lead From
Hi All, Currently we are developing Application in Zoho Creator with Free version. We have one form, through which we want all our employees, to enter Leads information. When i created a Lead form and share the form with all employee id (10 emps, with their email id), the Zoho Creator considers it as User. The employee should login with given username and password and then enter the lead information. Is there any way, we can retrict users in Zoho Creator, but give access to this functionality to
how to add my form in wordpress page
I am using wordpress.so i have this form, how do i put or add my form in my wordpress page?please
Currency Decimal on Edit
Hi, i put a currency field with 2 decimals, like 0.00 When i am in the report, and edit the value of the field, like 8.45 it will not update, but if i edit and fill with 8.00, it will update. There is a problem with updating fields with currency type?
Live updates to a form
Hello, I am creating a form for our team members to access. I was just curious if one of our team members updates something in the form will it update live to the other members in the form at the same time? I tried testing it but relaized it will only show the update if you refresh the browser page. Thanks, Darren
Can't edit Message field when setting up a "send mail" function
Setting up a "send mail" function on a form, I click Edit to edit the From, To, Subject, and Message. I can edit the first 3 fields fine, but cannot edit the Message field. Clicking on the text box does not show the "xxx Mode" tabs and does not allow changing of the text. This happens to be for the Form Action "On Edit" | "On Success". I did just now try the Free Flowing Script option, and that does allow me to change the script, so that is a work-around. So this problem is just in the Script Builder.
Lookup Setfilter based on another field on the form
Hello, I came across your tool just today. Seems interesting but i would expect a lot of improvments before i spend money to buy it. Please help me with this situation. I have 2 field for names on the form. I get to choose a name from the lookup of Names for the first field. For the second one i will want the same look up minus the name on the field field. 1) My thoughts. I should be able to filter it out 2) I should be able to create a list after the first name is entered ( Everything
What are some options for other Custom Reports
I want to be able to use data from my Zoho Creator database to generate custom reports that are formatted in a particular way that is not supported in the reports feature of Zoho Creator. Does anyone know of some other options for creating custom reports with the data from Zoho Creator? For example, is there a way to link to data in Zoho Creator from Microsoft Access so that you can use Microsoft Access's reporting features? Or is there an on-line report generating tool that can pull data from
insert/add a record
How can I add a new record to a 2nd form when using deluge scripting When I add a record to table 1 (detailed data not suitable for display) , I want to add a record to Table 2 (presentation information). ramona
Access to report - User specific.
Hi All, We are developing our CRM using Zoho Creator. We are basically Pharma company. We have created a form called "Leads". This forms as all required fields along with MR Number. All Medical Representatives (MRs) should log into system and enter Leads information. The Drop down menu in Leads form will show MR number, so that they can choose his/her ID while submitting Leads information. Later Business user can see, who has submitted how many Leads on a given day/week etc.,.. The Issue is with
Currency Symbol in Reports
Hi Sorry if this is a silly question - I am a newbie user. I have created currency fields in my database to be shown as GBP. The £ symbol shows fine in Forms but default sback to $ (USD) in reports, Is this a bug or sonething I am doing wrong? Many thanks Mike
creating application
i'm making an inventory system.. is it correct to make separate one application for the entries/forms database, and another application for the reports?
Simple Currency Related Formula Not Working
I seem to be missing something with currency related formulas - I'm trying to do the following: "input.Assessed_Land + input.Assessed_Structure" Both fields are currency - it gives me the following error: "com.adventnet.ds.query.QueryConstructionException: Datatype [CHAR] of the column [t_693811000000018081.Formula_693811000000025013] can " The error is cut off in the window - I cannot see the rest. What am I missing? Thx
Merge 2 fields
I have two basic forms .... one one (Contacts) I have the basic Contact Info and on the second (Opp's) I have the opportunities that have been identified for each contact. On the Contact Form are two fields ... First Name and Surname ... on the Opp's form I have a look-up to pull in the business name from the Contact form. Is it possible, and if yes, how do can I based on selecting a business from the Contact form pull in and merge the First Name and Surname from the Contact to the Opp's form.
Is it posible get data from IMDB to creat a Zoho creator database?
Hi everybody: I am a new member of Zoho comunity. I would like to create a database for my movies and wondering if there is any way to automatically extract data from imdb to complete my own database. Another way of asking the question is: Can I create a script that extracts data from IMDB to complete my own database?. Thank you very much.
Enabling public access disabled for Trial and Free Edition users
Dear Users, Due to security reasons, we have disabled enabling public access of form and application for the Trial and Free Edition users. Regards, Karuppuchamy
permalink in iframe
hi guys, i have this problem. I have created a permalink of an html view with a zoho table inside. The table allow users only to view and print records, not to edit or delete. When i check the permalink in browser everithing works good. But when i check permalink in iframe, the table allow users to edit and delete records. Why? Someone knows how i can solve this? Please help me bye
Check for a null date in a formula field.
In my application, I would like to create a custom field that would perform the following actions If (initial_date and clear_date are BOTH NOT null/empty) - display "Complete" else if (initial_date is NOT null/empty but clear_date IS empty) - display "Pending" else - display "Incomplete" For some reason, even when I try to check if a date is NULL in a simple formula, nothing will show up e.g. if((initial_date ==null),"Test1","Test2") Any help would be appreciated!
Custom summary view to be shared among all users
Let's say the app owner has created a personalised summary view which applies everytime he access the app and clicks on view the record (or record summary). This custom summary view does not apply to other users (whether they are developpers or regular users). Is it a way to share custom summary views with other users? Do you think in any other way around to do this? Thanks in advance.
Duplicating applications
Does anyone have problems with duplicating applications. I submitted a service request but can't get any answer. I asked for an urgent status update, still no answer. Generally, I get answers and resolutions on my requests fairly quickly; however, this one is worrying me because I am not able to get any communications back from Zoho technical support. A lot is riding on this for me!! Can anyone shed some lights on this issue? Any fundamental problem with duplicating an app? Thanks
How can I use a sequential number for each form?
Hi, I'm creating a form like invoice and need to add a sequential number jump automatically with each entry. How can I do it? Thanks!
Moving from GoDaddy Easydata Base to Zoho
I am NOT a programmer. I have emailed you several times, spent hours researching your site following the links I get in response to my emails (which usually do not come within 24 hours), reading forums, all sorts of instructions and suggestions, user guides,get started guides, and FAQ sections - all to no avail. I have been told I can hire someone to customize this for me, but I think I shouldn't have to pay to understand how to create something that should be very basic. The only GoDaddy customer
HELP!!!! Setup form in Zoho creator, but don't know how to automatically send invoices or attachments to clients?
Hi, I have a question for anyone. I have setup a form in zoho creator but from that information that I collect I would like to send invoices and contracts to my clients. How do I go about doing this? I need help. I don't know how to write script either, so I think that is what is stopping me. Do I use Zoho crm to do this all or what? HELP!!!! Tess
hidden fields
Hi, How do I unhide fields depending on whether a particular field has been selected on a drop down list?
Federated Login Improvements
This is related to my application context post. The changes Google made recently make having both a Google and Google Apps login irrelevant. I tested out signing in via my Google Apps account using the Google login and it works just fine. Support can remove the Google Apps login option. Using the Facebook option, the logo looks rather unprofessional. Please fix that. After federated login for new users, Zoho asks for a user name. Note that the instructions mention the zoho email address which should
URGENT! Script no longer working
Hello, I have the below script on my application 'KiwiOz Childcare.' For some reason it has stopped working and consultants are not receiving their emails: /*if (input.Item == "7. Interview (KPI)") { sendmail ( To : zoho.loginuserid From : zoho.loginuserid Subject : "Interview booked" Message : input.Item + "<br>\n" + input.Client + "<br>\n" + input.Candidate_Name + "<br>\n" + input.To_complete_by + "<br>\n" + input.Comments + "<br>"
On Add / On Success Error
I've got an issue with On Add / On Success script in "NECATNetworkDatabase" - "Show_Times" Form I can't access it. Any help is appreciated.
Custom Action to edit a with less number of fields
I am trying to create a custom action which opens the edit window for the view record. But I want some fields to be hidden in this edit window. How can this be implemented?
changes to formla triggered by update to drop down
Hello, I have a drop down list of shirt sizes and a text field for quantity of shirts. The size ordered determines price. I am using a formula field to calculate the total cost of the order (quantitiy of shirts * shirtcost). It works well the first time (user selects size and inputs quantity). But if the user changes the size of the shirt without changing the quantity of shirts, the forumla is not updated. Is there any way to force the formula to check for a new value from the drop down? Sonya
Duplicating or Deleting An Application
I get a "Duplicating...Please Wait" window that never goes away. Also my database never is duplicated. Same for Delete chris
Allow users to save a partially completed form and then complete it later?
is it possible to allow users to save a partially completed form which they could then complete at a later time?
Formatting Record in view
Good morning, I need technical information and I can not find an answer. By inserting a new record, I can ask for a verification of those already entered and make them change? Example. I put the record name (single line) double (decision flag) I already have a record (1) entered: name = "Andrea", double = false I insert a new record (2): name = "Andrea". The system can understand that there is already a record with field name = "Andrea" and enter on (1) Double = true? Or write the name field in the
Default Report Page displays Unwanted Records
Hi, can anyone assist me with this one please? When I open a Report page, it by default displays some records, even though it hasn't been specifically searched for. Because people will pay for viewing the records, I would like them to only see what they have searched for and nothing else. I would really appreciate any assistance on this.
dynamic form fields?
Hi, I'm building a form with Zoho Creator for users to register. Users might be from all around the world, so I want the form to offer different pulldown menues to chose from depanding on their input of the My Country field. E.g. if a user chooses USA another pulldown field shows up to select a state - for UK a pulldown menu shows up to select a county etc. It all gets stored in the form data table. I was able to achieve this functionality by the "On User Input" script for Country where I hide or
How can I combine multiple databases into one view
How can I combine multiple data views into one view.
Lookup Import 2 or more fields
Greetings Community, I am having 2 forms , 1 form is customer form that contains 1) first name , 2) last name 3) Autonumber ( unique value ) Data is already imported to this form. The tricky part now, the product form contains lookup field from customer form that contains 1) last name , 2) first name 3) Auto number ( unique value ). No matter what i tried, i can't import anything in the products form when i am using more that 1 fields on the lookup field. When i am using ONLY last name its working.
Next Page