Show checkbox in view, versus true/false
How do I change the view to show a checkbox instead of true/false for a decision box field? I have a test view that it will work with. But my main form view will only show true/ false.
Issues with Button in stateless Form
After recent changes in creator user interface & modification in application, I am finding that I am unable to pass any value to stateless form field through deluge code written under an action button. Example : I add a field named Message in a stateless form , I also add a button called say " Show message " and under this button i write code Message=" This is test message" When I press the action button, the field does not get the value and does not show on the screen. It use to work well in the
shared options
i want to see sharing details based on user
password field
i want to allow password field in my form. how to do it?
Back Ups
Is there a problem with back ups except for the first one I did they have all failed.
D.O.B and Age
Does anybody know a way to create an age field that automatically updates based on a date of birth field?
location search
I am looking for an app that will allow me to search my database for customers that are located within a 100 mile radius of a zip code that I enter. Please respond if you know of a way to do this using ZOHO.
Attach a document stored on ZOHO Creator to an email
I have a form to upload PDF files to ZOHO Creator I have another form with client name, address and email address I have a 3rd form that does a lookup on the client name to get their email address, and capture further information about that client Is it possile to be able to select a document (from a browse or drop down list) previously uploaded and stored in ZOHO Creator and attach that document to an email to the clients email (from the lookup field) when the SUBMIT button is clicked on the form?
duplicated report has incorrect name in url
How do I change the name in the url address for a duplicated report example current https://creator.zoho.com/appbuilder/dbob/nameofapp/report/Copy_Of_report1_Progress_Overview2/ this is the incorrect name as the report name in dashboard is baggage so should read https://creator.zoho.com/appbuilder/dbob/nameofapp/report/baggage/ How or where do I change /update this thanks DC
If record exists bring up edit records with openurl in same window not working?
In the date field's(named TYDate)-> "On User input" event I am checking to see if their is a record with the same as input.TYDate if so use openUrl with "/record-edit/", the result is not nearly as useful as going to the report and selecting edit on given record? It will open the correct record in a "new window or pop-up' and no header labels such as "Edit Record", but not in "Same window" as expected when I use the "edit " link from the report for the same record. if (Fat_Daddy_s_Destin[TYDate
How can I add fields in "search" for a report?
I am not sure if I am using the proper lingo here, so I think a screenshot would be best to illustrate my question. See, what I need to do is add multiple "Software" and "Title" search fields, because we often will be searching within our spreadsheet for a freelancer that may fit multiple titles and is proficient in multiple software applications, so we have to be able to search for more than one term within each of those columns. We might even like a few more non-specific search fields added so
Force Edit in Report?
Hi, I think this has been answered, but I could not find it. I have a field in "FormA" that uses data from "FormB". When I create a new record or edit a current record in FormB, script executes that updates the field in FormA, but it does not show up in the report unless I do a manual edit in the report. Is there a way I can force an edit or otherwise update the report? Bruce "Speedy G" Peaslee The World's Fastest Programmer
HTML in Formula Field
Today I found that my lists which include values with hyperlinks (such as quick reply) are being displayed incorrectly. I have been working on other modules today, but found this specific behaviour to be happening - as of today - to all of my lists displaying formula-based fields. After reading the forum I found that - for security matters - deluge scripts should be used instead of HTML. I have tried to restore a backup from 13 hours ago, but that process threw an error. Could someone please help
Working with multiple applications
If I'm understanding correctly, I can have multiple applications which share and use the same forms (where form is equivalent to a table, or object). This is great, as it helps me organize my thoughts and keep 'modules' of my leggy master application separate and distinct. Is there a way to create a page/screen that links the applications together into a menu? Or is that the generic zoho.creator/home page?
New price
Hi! Whether old customers ZOHO Creator upgraded to the new price or for them to remain the old conditions.
IF Statement in Conditional Formula Expression
I have looked at all the forums and support docs and still am having trouble with this. Currently I have several formula fields that calculate a discount based on the input of the general price. Here is an example of the current working formula expression: ((General_Ticket_Price * 0.1 - General_Ticket_Price) * -1) But now I have a request to have different discounts based on the type of event. For instance IF input.event_type == "workshop" there would a different formula expression than IF input.event_type
ical feed
I cannot get the ical feed to work in any of my calendars (goole, yahoo, iphone) - Also the export in CSV doesn't seem to work either - I also can't make it public, I want to see the info on my phone without being logged in, it says to upgrade but i'm already on a paid subscription and it does not tell me what plan I need to be on - all very confusing, this was supposed to make things easier! please advise?
Finding all locations that call a function
I think I must be missing something, but I cannot find a way to get a list of all the locations from where a function is called. I used to get this list of locations by changing the name of a function and then saving it - and Zoho would tell me all the places I needed to make the change. But now it automatically changes all the calls to the function - which is good - but I've lost that useful feature. Is there another way to get the information? Thanks Alex
Phone questionnaire linked to record
We have a form that has questions we ask leads to qualify them. I have successfully created the form but what I would like to have happen is to have my salesperson simply have to click "Add" within the lead details area and automatically associated to the form similar to when you record a call or add a task from the lead detail area. Right now I can search for the Lead name and associate it manually, but I don't want that to be part of the process. I want it as seamless as possible just like your
Hide/Show Fields in Stateless Forms
Hello All, Is it possible to hide/show fields on a stateless form based on conditional criteria (user checking a decision box) just as you can on a regular form? Thanks, Adam
Can a form have mutliple related sub-forms?
As the question says - if I have a parent form, such as CITY, and there are related forms (such as Restaurants and Hotels), can the City form have two sub-forms? One for restaurants and one for hotels?
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
Next Page