Cannot edit records
Users of my application are unable to edit any records. I have logged a support request and need someone to contact me immediately
Possible bug with date-time list
I have a records with date-time values (Program_Starts), and have copied some of the values below to explain what I'm seeing 29-Apr-2014 13:00:00, 29-Apr-2014 17:00:00, 30-Apr-2014 09:00:00, 30-Apr-2014 13:00:00, 30-Apr-2014 17:00:00, 01-May-2014 09:00:00 What I'm trying to do it make a list of records that only have date-time values after today. Here's my code class_list = (Classes[(Program == "XYZ" && Program_Starts > zoho.currentdate)].Program_Number).getall(); When I run this, it returns all
Calling Zoho Creator API from .net CSharp
I'm able to make the request with desired fields (WebRequest.Create), using csharp code but got an error in response. Below is the response (request.GetResponse()), all required fields are provided still I get the error: Failure, Enter a value for...... <response><result><form name="Decision"><add><values xmlns="add"> <field name="LDC"> <value>AGL</value></field> <field name="Commodity"> <value>Gas</value></field> <field name="Customer Name and Parent Name"> <value>TEST CUSTOMER</value></field>
Autopopulate value in sub-form
Hi, I have a main form with sub-form that fetches another form. Sub-form has product related fields. What I want to do here is, based on the selected product(From CRM Module) I want to fetch its related price to a field. But it is not working as I expected. If my lookup field for product is within creator I dont find any issue. If I want to get the product from zoho crm I am not able to auto-populate unit price field.I don't know what I am missing. Help me sort out this issue Here is my code, [Products->On
Backup Failure
We set up Sales Management 4.0 for testing purposes, and we're getting failures when trying to create a backup of the app. Is there missing data we don't happen to see?
how do i change where the email notifications of a new request go?
the admin who created our request form left the company and i want to change where the email notifications go, as of now they still go to his email address. ps im a programming noob. joe
No access even after sharing
How come when I shared my app to my friend, he get's "You are not allowed to access this application." message even after he clicked on the link that came in his inivte mail? I have shared the application with him.
File upload does not appear in record
I created a form with a file upload field and in the form I can upload the file but when I view the record in the report view the field is missing. What am I missing or what am I doing wrong? Is there a place in the properties of the file upload field that I don't enabled or modified properly?
user roles can be assigned only after approval of Manager
hi, if admin assigned roles to user , mail goes to manager and if manager approve then only respected role assigned to user.. it is possible,if yes how?
Issue about HTML page
Hi, In old edit mode, I can using the code in HTML as below: <%if (count(Dept[Dept_NO == 1])>0){%> You have already added the department. <%} else {%> You need to add department first. <%}%> But in new edit mode, I can not using this code in HTML. It displays "null". Kindly help me to check it ?
Implement search algorrithm on zoho data
Hi, I have to created a form which takes the user input and stores data, for example a form like expenses. Now i have to create a page which will take input like expense type/date/ expense by fields and select all the rows belonging to the input and calculate the aggregate expense and display it to user. If i give all the parameters the logic works but i want to know if we can build dynamic queries based to user input to fetch the records from the database.
MS Access Migration issue
I have used the migration tool to migrate a small database from access to zoho. Each time I try I get a pop up that the migration was successful, but when I go to my account on zoho it is not there. Is there something else I need to do? I have tried waiting a whole day and checking back, but it is still not there. Thank you , Matt Holtzclaw
Zoho Creator - Mobile App
Hi I was using the filter to search for a customer in Zoho creator mobile native app. I received a message "Sorry" the application Zoho creator (process.com zoho creator.a) has stopped unexpectedly. Please try again. I thought I would wait 20 mins and try again...i got the same message. I am on day one of the 15 day trial.
Date field, how can i limit a value up to 30 days?
When i enter a date, how can i set limitation til 30 days? The date purchase will not exceed to 30 days, if exceed, it will pop a alert? I just need the If Statement for this, hope you guys can help me
getUrl has stopped working. Are others facing this issue too?
I had a working application until yesterday and the now, the getUrl call returns null for the code and text!! I have verified this both ways - I make the get call (from my browser) from my own PC and it works without any issues and I have also tried several other urls in the getUrl call. getUrl simply does not work. My suspicion is that a backend upgrade by Zoho could have caused this issue. Is anyone else experiencing a similar problem?
Invited new users being put into "trial" accounts that have no ability to access shared applications
Help! Starting today, my invitations to new Zoho users with whom I have shared my applications can no longer access them. They never see the "dashboard" screen - only the screen that prompts them to start creating their first application. They have to "upgrade" to a paid subscription in order to see my shared applications. I am supposed to have unlimited users on my subscription. Please advise ASAP!
checkbox to show/hide fields
I figured out how to have a field hide/show when a specific radial button is clicked. But I can't figure out how to get specific fields to show when specific check boxes are selected. Can someone help me with this?
need help with regular expression and matches function
if(mystring.matches("?")) == true) I need to check if mystring starts with number or any letter in alphabet A-D, not sure how to do it. Thank you in advance for help.
Execution Failed
Hi, I'm getting an Execution Failed error when trying to execute a Scheduled Report. Execution Failed Error details Error in executing ... (Custom Schedule) Error. Error in executing Send Mail Task Please advise on what should be done.
Execute Script Error
Hi, I'm getting an error when trying to execute a test report. I've attached the error. Thanks, Jon
How to get GetURL variable and pass it to another form?
I have a form that is filtered using a url variable. Example: ..//#Form:Income?invoice=123 When I click the "make payment" button from mu invoice page. The user will be redirected to another payment page and the payment page will inherit the selected invoice ID (in this case is 123). How should I code this in my "make payment" page?
Using my own domain to display pages
Can some please direct me to information or explain if there is a way to display a "HTML Page" under mydomain.com/ Thanks
Need help for stateless form
I am currently want to learn how stateless form work. I look at the instruction zoho provide but I don't understand and could not make it work. I am new to Zoho and programming. could any one help me make it work please? Currently there is no error but when I pick the list, the name field is not pulling the name in to the field box I am welcome any example that could help my understanding such as example application or explanation of the code. Thank you
Login System with Master Admin, admin and users
My question is quite general and i would like your suggestions. It is not about technical problems etc. Well, as we know, customer portal has limitations (unfortunately, we can have the same permissions to all the users) my question is as below: Is there any way to create manual a login system with Master Admin, Admin and users? Let's say an example. We have 3 hotels (A, B, C) which are parts of a main hotel (D). We would like each hotel (A, B, C) to have separate users (login for each user). Each
Open URL function and invoking "on user input"
I have a view with buttons next to each record. When you press the button, a form opens up and a couple lookup fields are populated. Then the "on user input" action are invoked and additional fields are populated. I made one change...instead of open "popup" now I open in "same window" and the "on user input actions are no longer invoked. It appears that opening a "popup" and pre-populating fields will invoke "on user input" actions for those fields that are populated, however, when opening in
Customer Portal
I'm evaluating whether Zoho Creator is the right tool to implement an application that I need. The application is a booking/payment system for a mobile car wash company. There are many vans, going around to many buildings and washing residents' cars on-demand. Here are some of the requirements: 1) database storing all buildings, customers and all their respective cars 2) schedule of which vans are going to which building and when 3) secure login system for customers to register, store/edit all their
Issue in assigning the value to a field on User Input
I try to create the Sales Order form in creator. I've created two forms named "Order Form" & "Order Line Item". "Order Form" has the sub form "Order Line Item". In "Order Line Item" form, I've two fields named "Products" & "Unit Price". "Products" is zoho CRM field for Products module & "Unit Price" is float type. I tried to assign the "Unit Price" while selecting "Products". I wrote the following script on Field Actions --> Products --> On User Input Script: row.Unit_Price = 10000.0; When I running
CSV Imports & Relations
We need to import data stored in CSV into Zoho Creator, and have built into Zoho Creator multi-form relationships. How do we get that to work? For example, we have a form for adding Employees, and a form for adding Companies. The Employee form has you select a Company from a drop down that links to Companies. Then, we have a CSV file of Employees, with a "Company" column that lists the company as a string. How do we import that CSV file into the Employees database in Zoho Creator to where it will
Changing Import Data field from type Radio Buttons to Drop Down list
Dear ZOHO, I have an Import Data field in my form and it is displayed as a Radion Button control. However, I want to change it to a Drop Down list display. In the editor, I does not seem to be possible to change the diplay type. Do I really have to define this field all over again? This would be very cumbersome and difficult. Is there a way to change this more easily? Thanks in advance. Silvester
Include Parent Table Fields in DropDown Form
I know there must be an easy answer to this: I have 3 tables with the following fields: Customers - Fields(First_Name, Last_Name, Phone) Jobs - Fields(CustomerID, Job Name) Billings - Fields(JobID, BillingAmount) The relationships are one customer to many jobs and one job to many billings. When I enter a billing entry, there is a dropdown for Jobs to select the JobID and the values that can be shown are limited to the fields in the Jobs table. Is there a way to include fields from
Make hidden fields "required"
Hi I would like to make a hidden field "required", but only when it is visible (the field is visible when a specific value is selected in adropdown. Can this be done? BR Skouboe
Convert decimal to big int in .addDay() function
I am trying to use the .addDay() function but the number of days will be determined by a calculation using several date fields. I'm getting the following error and don't know how to avoid it. Mismatch data type for function addDay at argument index 1 expected data type BIGINT found dataType DECIMAL The code I'm using is as follows: request.Date = request.Date.addDay(((request.End_Date - request.Start_Date) / (1000 * 60 * 60 * 24))); I know there is a function to change a big to decimal but
How to get GetURL variable and pass it to another form?
I have a form that is filtered using a url variable. Example: ..//#Form:Income?invoice=123 When I click the "make payment" button from mu invoice page. The user will be redirected to another payment page and the payment page will inherit the selected invoice ID (in this case is 123). How should I code this in my "make payment" page?
Creator reports restrict access by user ids
Here is what Im trying to do. I want to show records of my report only to selected users, in my case I have many Hotels and I want users to see records only for their own Hotel. Here is how Im doing this: Im creating certain groups of users by creating a form User_IDs which holds "hotel_id" and an Email (which is zoho.loginuserid) , so each logged in user belongs to a "hotel_id". In my Hotel_Details form I have a lookup field hotel_id, so I want to show records only if zoho.loginuserid in form User_IDs
Email notification
Hi I have an online form which, when submitted, sends an email notification to specified people when certain fields are populated. When those fields are not populated, it still enters the details on the calendar view, which is fine, that's how I want it to be. However, now, all of a sudden, ALL submitted forms are being emailed, regardless of whether or not those fields are populated. I have changed nothing in the settings so why is this suddenly happening? It's so annoying when you change things
Easy way to remove Microsoft Word formatting from rich text fields?
When I export my data from Creator into Excel, I notice that the rich text form fields contain a lot of unnecessary Microsoft Word formatting code embedded - such as... <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility>
Creator removing final zero in decimal field displayed on a page.
Im having a display issue when I am showing decimal fields from a form on a page. Creator is removing the last 0 in the number. The problem is that my decimal fields are set to 2 decimal points but they display with the wrong number of decimal points. I want the number to display as follows: 45.00 or 45.50 or 45.20 Trouble is they display as follows instead: : 45.0 or 45.5 or 45.2 Creator is cutting off the last 0. I want this zero to display. How can i get the zero to show? My page uses the following
printing help please
Ok Hi, I have the following conditions PDF file on external site that I want to print Page view for staff Name Tel No File to print (which is the pdf file) I use a script to populate the "file to print" field Looks like this https://drive.google.com/a/signedfast.co.uk/#folders/0B8WoWXP12Cw0TTR3ZHUyejZQcmM/" + input.Job_Code + ".pdf" When the page is viewed the link is underlined and clickable but is does not print the PDF file. What am I missing please. Thanks NIgel
Linking ZOHO Creator to ZOHO Reports -can we link Creator to ZOHO Reports?
We have been using ZOHO Reports extensively for the past two years. We are thinking about using ZOHO Creator to create forms so employees can update the data in ZOHO Reports directly from Creator forms. Is this possible? I am seeing that we can import CSV/XLS and Access data but I have not found anywhere that states we can link a new Creator form to an existing ZOHO Reports databases. Is it possible? Also using Creator forms can we add, edit, and delete data from ZOHO Reports? Michael Kokernak
Customer Portal
My agency has multiple applications that team members need to access. How do they get access to all six at the same time as opposed to having to enter multiple portals separately? We have granted them permission to use all applications and sent out email invites. Now each of them has several usernames and have been required to set passwords for each portal. Most of them don't work and now everyone's confused yet few people have access. How best to proceed with this? Also, we have deleted some applications
Next Page