Zoho is so slow today, its not functional!
we are using creator, anyone else have issues today?
permalink - no any responses
hi! try connect zoho creator reports with zoho reports and try take permalink from a view click on permalink and there is no any changes - in chrome and safari mac how can i take permalink without login?
Can't Receive Notification of Application Completed
I've been to the Notification area and added my mails, but when I fill out and submit my application form I get no notification or copy of the submitted form in my email. Puzzled. I'm sure it's something simple but I can't figure it. Please help. Thanks. Mike
Syncronize fields on multiple forms
I have two forms set up, and I need two of the fields on both forms to always be in sync. For example: Form A: Due date: 1/1/2014 Form B: Due date: 1/1/2014 I need to set it up so that when I put in a due date in Form A, it automatically shows the same data in form B. Thanks
new lookup radiobuttons fields always displayed as dropdowns
When you try to create a radiobuttons lookup field you have surprise to see that the created field is displayed as dropdown. Even if in the form definition the field is specified as being chekboxes type and you can even set the number of columns in field properties, it is always displayed as dropdown and there is no way to change this. Regards, George
Updating the value of a field in one form, based on the completion of another form
Here’s my scenario and my request; I hope you can help me. My organization does community outreach events, and I’m building an application to track them. When planning the event, we will use an “Add an Event” form, which will record the details onto two reports: a list of events, and a calendar. When the event is over, we will use a “Record an Outcome” form to record what happened at the event. (There is a lookup field in the “Record an Outcome” form, which lets you select any of the events that
Need report to list Table A records with no matching Table B records
Hi I have two tables: Table A (Jobs) has Job Number (Autonumber) and Job Name (single line) Table B (Visits) has: Lookup on Jobs (Job Number) Visit Date/Time I need to create a report that shows all Jobs where there has not yet been a Visit linked to it, but I can't see how to do this in Creator. I can see how to report on visits and link them to Jobs, but cannot see how to reference Visits (or the lack of them) in a report based on Jobs. I have attached a Deluge Script export of a simplified version
Insert an AVERAGE or AGGREGATE Total in a report?
I have a Report Grouped as above by Facility Name Employees enter a STAR RANKING 1 to 5 to rate each facility Is there anyway to show the Average ranking for each facilty in the report as shown above?
zoho.currentdate
Hi guys, I cannot use the zoho.currentdate to express condition that a service is not available today or in the past. Anyone have found a different solution about? Thanks Mike if (zoho.currentdate >= input.Day) { alert ("Times availables only from " + zoho.currentdate.addBusinessDay(1); }
Q; Re: record limits apply to lookup tables?
I'm new to Zoho Creator, and exploring it as an alternative to GApps. I'm rebuilding a flight booking small app as an experiment. One feature I need is a lookup of IATA airport codes. My list has about 6,000 airport cities, and the corresponding IATA 3 letter airport code. Will this simple lookup table bounce me into the $499 per month category due to the limit on records? If so, it's a deal-killer. Is there a workaround? Thanks in advance for your considered reply.
help with reminder
Can someone help please On a database I have written there is a field that is named tasks. So a task could be {call client at 2.30} How can I set this to popup a reminder on the screen at 2.30 Thanks
Stop Users from Exporting in Zoho Creator
Hi Zoho, Can I stop my users from exporting my data in my zoho creator data application? If so how do you do this? Can I just nominate certain users that can not export? Deanna
Error... left expression is of Type BIGINT and right expression is of type int
In the past week I started getting this error when I try to Fetch records. In Criteria left expression is of Type BIGINT and right expression is of type int and the Operator == is not valid Is this a bug? or did something change?
Accessing Zoho Creator Apps on Native Mobile Device
In looking at the Zoho Creator App for Android and Iphone, it says: Zoho Creator native apps for Android and iOS devices offers mobile access to your Zoho Creator applications available on the web. The apps are available in the following sites for download. To use this application from your Android / IOS device, you need to have 'Native Mobile Access' enabled in your online Zoho Creator account. Is the "Native Mobile Access" enabled as a function of the type of Zoho Creator Account I have or is this
To push data into a stateless form temporarily
I am trying to push data of a record in a stateless form on a custom action and then after editing in the stateless form, I am trying to update the existing record. I know how to update the existing record from the stateless form. How can we push the data of an existing record in a stateless form? Is it possible to create an instance of a stateless form?
RemoveElement from a list
Hi, In a FormA I have a date field DAY that ON INPUT have a script that display in another dropdown TIME the options that was not selected from none until this moment. So i try to collect in a list (timelist) people choice by fields GUICHE, DAY and TIME and remove this option from TIME field with removeElement command. But nothing. Field are not displaying correctly the options. Anyone need solve the same problem? timelist = (FormA[((Guiche == input.Guiche && Day == input.Day) && Time== input.Time)]);
Silly question .Customer Inquiry form submission
I have an application in ZOHO Creator to track clients and Service providers In my application I have a form with the following fields for customers to complete once they have used one of my recommended suppliers Your Customer name Your Email Facitlty Attended Date attended Star rating I want to be ale to have this form available to any one in the world and have them be able to submit the form, and the data automatically show up in my application, which is private only to my Customer Service Reps.
creating a temp db using a lookup in the form i am creating a temp db from with a field that is not a lookup
In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator == is not valid this is what I rec = TimeDB[ID == Employee_Name]; input.Regular_Hours = (rec.Employee_Name == input.Name2).sum(Regular_Hours); Employee_Name is a lookup field in the TimeDB Regular_Hours is the field I am trying to update with the sum of Regular Hours in the TimeDB Name2 is not a look up in the form i want to update the sum in
Checking a field value before changing a status
Hi all, I'm trying to create some code so my users cannot close a request unless they have the service value field populated. So the "Status" field should check the "Total_Service_Value" field for a value other than blank, when I select either "Closed (Complete)" or "Closed (Failed)" status. Is this possible ? I've had a play but not sure of the code I need to put in. Kind Regards Matt
Autopopulate CRM form field based on the selection made to an another CRM field type
Dear All, As we know, in Zoho CRM we can have an account which is possible to have 3-4 or more contacts. Lets say that in a form, I have two Zoho CRM fields. The first Zoho CRM field is an account based CRM field and the second is a contact based CRM field. My quetion is the following: If I choose an account in the first Zoho CRM field, is it possible the second CRM when I click the button next to it to show me only the contacts of this account (and not all the contacts which I have) for selection?
Can you show AutoNumber fields when the form loads?
Can you show AutoNumber fields when the form loads?
Creating a report (view) using data from tables in multiple applications
Our non-profit organization helps sponsor children in Africa. We have multiple applications set up to do separate functions. One application contains tables related to the child, school info and sponsors name. Another application contains tables related to the sponsors and their pledges, financial info. etc. Questions: - Is it possible in Zoho to create a report (view) in the child application that can display all the child/school related data plus access the sponsor table in the sponsor application
is zoho down?
I'm having an import issue and support is none existent. nothing works! I created a new form, a new application and now giving up.
Unable to see all user defined fields in bidirectional relationship
Hi Zoho Team, I have set-up a lookup field "Supplier_Item_Code" in the form "Create_Sample" in my database "New_Sample_Database". This field is looking at another database "Sourcing_Database" in the form "Create_Product" field "Supplier_Item_Code" and I have activated the bidirectional relationship based on ID field Now in my "Sourcing_Database", form "Create_Product", I want my users to see all the samples related to this product. I can display, "supplier Item code" and "quantity" from the form
Calendar disappeared
I am in Zoho Creator, and clicked EDIT THIS APPLICATION to change which fields would display when a calendar appointment was opened. When I finished making the change, I clicked ACCESS THIS APPLICATION to view the calendar again. The calendar had disappeared, replaced with a message that says We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com I edited again to reverse the change, but the calendar is still missing. I logged out
Updating a column in one form from another in a form
Hi, I have a master table where the values of ModelNo, TallyID, SUPC Code are updated. There is another form called Tally Stock where there are 3 columns, Tally id, SUPC Code and Stock quantity. Currently these 3 columns are imported from excel, i.e. each and every time, i need to delete the existing all the rows and update it to the table with new values of Stock quantity, but the tally id remains the same. I dont use the submit functionality. Now i want to update the SUPC Code from the master
Is it possible to make a mandatory field, NOT mandatory based on a selection in the same form?
Is it possible to make a mandatory field, NOT mandatory based on a selection in the same form?
Cannot edit layout and theme
Shared to support: g.wheless/abis-new
nested zc-componentrs
I have a page that dynamically displays a form/view using zc-component This works well for forms / reports / pages - in most cases However when the target is a page that also contains a zc-component, this inner component is not rendered Is there a way to get this to work - or does ZOHO just not suporrt this type of 'nesting' ?
Change delete confirmation message
Is there a way to change the delete confirmation message in Report ? I would like to be more explicit as I will have to do other actions if the delete is confirmed. Many thanks ! Guillaume
Can I store a LOOKUP field from a form in a different form?
I have 2 forms/tables One form has Facilty Name, Address etc and the other form has Client Name, DOB, address etc. I want to be able to use the Facilty Name in form 1 as a lookup to populate form 2 and store it in a field named FaciltyKey. The 1st form only has 1 record per facilty and therefore it is the Master. The 2nd form can have many records for each facilty so it should be the child ( a one to many relationship) How do I store the value of the Loookup fiield in to the 2nd form?
New Addition: Record Level Security & Permission... Where?
I do not see this in my Creator and I am an enterprise user. Can you look into this for me? https://www.zoho.com/creator/blog/new-addition-record-level-security-permission.html
Record summary for edition?
Hi, I have been able to modify the view mode of my record item to my needs. How can I modify the edition mode of my record item ? Regards, Chris
Line Breaks in Multiline fields being removed in HTML views
Is there any way to get line breaks in multi-line fields to display when fetched from html pages. I keep running into to this issues over and over. Is it a known limitation that has no plans to be fixed? or a known bug that does plans to be fixed? Does anyone else have this issue and if so how is it handled?
Auto number
Does zoho creator provide for the ability to assign an "autonumber" for a given form entry?
Migration tool issue - Shared Apps not available?
When I use the Zoho Migration tool for Excel/Access to try to upload my Excel file to a shared app, no shared apps are listed in the "Shared Apps" dropdown within the tool. However, when I login to Zoho Creator using the same account and go to Dashboard > Shared Apps, I can see that the application is in my list of "Shared Apps". Is this a known Migration Tool bug, or am I doing something wrong?
Add number of days from a date field into another field
Hi, I have a date field called Date Valid SSI Submission Received and I need to add another date field called 70 Day from Application. I want the date field called '70 Day from Application' to automatically work out and populate the date 70 days after the date that is inputted into Date Valid SSI Submission Received. Please can you advise how I can do this? Kind regards
Sorry, we are unable to load the form
HI. It often happens that I have this error on my pages with zoho creator. "Sorry, we are unable to load the form. Report this problem to support@zohocreator.com" For example http://www.rossatogroup.com/prodotti/impianti-solari-termici/pannelli-solari/pannello-solare-piano.html
ISBN trouble importing
I am trying to import data from a spreadsheet that contains ISBN data. In the import process, although I have allowed for up to 25 digits, the conversion process seems to declare the values as single digit E power numbers.. it that why it won't accept the entries as numerical ??? The import process does work for digits less than 10,000 ... Should I declare the field as a string instead ???
Best way to share apps to clients
Hello, I am starting to develop apps for clients but I would like to know what is the best way to share with them so that they have full rights to add/modify data and test the apps. What is the best way for me to do this? Not sure if this matters but I have two zoho creator accounts. I have an older $25 account which includes 5 users and I also have a a newer Professional Single account. Some of my clients have newer Professional accounts in zoho creator and others don't have zoho accounts. Summary:
Next Page