platform update problems - why on a Friday and why so many bugs every time?
Why do these updates cause so many problems and break so many features so frequently? Why is there not thorough testing done using multiple browsers?? Why do the updates typically get rolled out on a Friday evening, thus leaving things broken on the weekend when I am usually working on our business's apps in preparation for the upcoming working week??? Why...why...why..........??!!!
alert messages broken by latest platform update
The latest platform update has broken the display of alert messages. This can be replicated this by testing an "On Edit / Validate" script which cancels form submission and generates an alert message to the user. All that happens is a generic "Failed to update" error is displayed without the alert message specified in the script. Why is there so little testing done before rolling out these updates which so frequently seem to break things that were perfectly ok beforehand??
subforms gone funny
Hi, Have any changes been made to the sub-form feature as they are displaying rather strangely in my form. https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job Regards Nigel
Subform disaster
Hi, My goodness someone has really messed up the subform feature that you offer. Can I suggest you change it back until you have a chance to test it properly. Nigel
subform display broken by latest platform update
Subform display has been broken by the most recent platform update yesterday. Kindly please fix this before Monday morning!
How do I choose from 1 dropdown and fill 2 fields.
I have a form with a lookup field. It lets you choose a contacts name. When I choose the contact name from the dropdown list (or after I submit the form) I would like the email address of that contact to also be added. Can someone help me figure out how to do that?
opeurl record-edit and form-perma
I have a stateless form embedded in my website that calls the following statement openUrl("https://creator.zoho.com/abc/xyz/form-perma/Customer_Info/record-edit/Customer_View/" + Customer_Record.ID, "same window"); The Customer_Info form appears but all the fields are blank. If I take out the form-perma then I am asked for my Zoho Username & password. After signing in the Customer_Info form appears with all the information for the Customer_Record.ID. Both the form and the view are public. Is there
Help building a function to filter data?
I have a form that contains a record for each branch (of which there are 5). Each branch has different territories (states) that they are allowed to access, but some of them may overlap (i.e. Branch 1 may be able to see records for IL and WI, whereas Branch 2 should only be able to see records in WI). The Branch records have a field which contains the emailaddress for the user in question. What I would like to do is create a function which will return the states that the logged in user has access
Drop down limitations
Thanks for any help you can give me.... On a form we used to collection data about our teaching, I noticed that some of my fields were disappearing for "Academic Quarter". When I added a field for "Winter 2012" an older option for "Fall 2009" dropped off. I found info that there is a limit for the number of drop-downs in view. But what do I know now? Is there a work-around to keep this form going? I like my zoho database! https://creator.zoho.com/lemieuxref/lemieux-library/#Form:Instruction Thanks,
Hide/Show Based on a Checkbox
I'm having a lot of trouble getting my hide/show when a checkbox is selected to work. I click on my checkbox and then go to "On User Edit" Script for that particular checkbox. I click on the edit if statement and insert input.Decision_Box_1 as I've seen previous and i get an error message that says Decision_Box_1 is not declared. However, when I click to set up a checkbox I can't find anywhere it tells to define field names for individuals checkboxes, only for the entire checkbox area. Can
Null a Date Only Works in Free-form
When is scrip-builder mode, if you attempt to update a date field with null as follows: r = CALENDARS[Sender == zoho.loginuserid]; r.EXP_DATE=null You get this: expression type does not match: type required:date type found:null Changing to free-form mode, this error is not seen. John M. Whitney
Too many decimals in Currency field?
In my app, sportspenguin, if Asking_Price>0, then months * Rate (USD) = Total (USD), where Rate = 1.2 (USD). So why, if Months = 3, does Total = 3.5999999999999996???? USD currency fields are 2 decimal points.
view add records permissions
Hi, I'm embedding in my website a view for our users to see the database and I'm creating another view for the admins with add,delete,edit permissions). It is possible to only have one view for all and if you are loged in as a Zoho user and I'm sharing this database with that user, they can edit,add,delete records? What I'm trying to avoid is having to create 2 different views for each database. (one for the user to see the records and another one for the users with permission to add records.) Thanks,
number format
Hi there, I have two form fields that I've defined as a Decimal with 2 decimal values each. One of the fields is automatically calculated as (input.price_a = input.price / 6) Unfortunately when this operation is performed I get a number with 10 decimal values in the price_a. Is there any way of formating the result of the calculation in order to add a double with two decimals in input.price_a? Thanks very much in advance for your time... Luis Pedro
using "set criteria" in lookup
Him I have two forms one with the columns (Event, Number, Name....) and one with unique entries (Number, Name). In the first I'd like to lookup the "Name" from the second form when the "Number" columns are the same. There should be only one match in the second form. I don;t know how to set the criteria to do so. Is there some guide on this? e.g. if I enter the following in the second form Form2 Number,Name 1001,Joe 1002,Jim then if an entry is added to form2 for Number=1001 then the Name should
How can I let my user to import data by xls?
I share my application to my user, however, my user can't import the data by xls. How can I do that? I already setup that view permission. Thanks.
Unclear about form schedule frequency- please advise
Users post records that will be displayed in a view until they expire in 3 months. At 7 days before the expiration date, I want the user to get an email letting them know that their post is expiring in 7 days. I created a form schedule to do this, but I am not sure if it should run once or daily. Can you help? I only want them to get 1 email at 7 days before, so I assume that once is the frequency, but then I am confused, because the schedule needs to run everyday to email those whose posts
Unable to set email notificaton on delete from view
I created a view for users to delete records from a list. When a record is deleted I want to have an email sent to the administrator showing which record was deleted. I tried to do this in the Script for the view but it would not let me. Any suggestions?
How to delete record with email notification
I have created a view displaying records that can be deleted by one of our users. I would like to know how to receive an email notification when a specific record is deleted and include some of or all of the record details in the notification email (ex. first name, last name from the record). I have to perform a manual deletion on a server after a record is deleted from creator and I'm trying to make sure the notification is automated and not forgotten by the user doing the deletion.
Creating Ticket from email
Trying to figure out how exactly a ticket can be created by just an email sent from the user? Looking for better set of instructions. Thanks Bill
¿Spam Filters?
Does email data has spam filters, I am still testing it, sorry.
SSL in creator free version
I have a site using ZOHO Creator (free version) and need to find out more about network security. On your security.html page, you say to check the product pages for details on which applications support SSL but I can't find that in the Creator pages. In the forum, it sounds like you were working on it but is it in production? I also think it said all pages are now https but ours is still http and still works. Can you give me more information on network security using the free version of Creator?
Multiple Select List and Advanced display options
I'm using a Lookup field in FormA with Field Type: "Import Data" from FormB and Display Type: "Multiple Select List" (one-to-many relationship), also using the Advanced display options (displayformat showing 3 fields from FormB) 1. In the FromA EDIT mode, I want to display the records in the Multiple Select List that are only the related to FormA. Is there a way to do this? currently it display all the records in FormB with selected iteams related to FormA. 2. As a work around, I tried to clear the
Updating lookup picklist with "Advanced display options"
Hi! In a form ("SampleForm") I set lookup field "Client": [Appname] - ClientsBase [Form name] - ID [Field name] with Display as: (Advanced display options) "ClientName" In the same "SampleForm" I also set another picklist field "ClientType". My target is: When I pick "ClientType" I'd like to see in "Client" piclist Names of those clients only of choosen Type. I've tried: "ClientType" - on user input: clear Client; client_var = ClientsBase [Type == input.ClientType]; Client:ui.add(client_var.ClientName.getAll());
Devoloping a function
hii... Here is my requirement To develop a function to populate list of items . To develop a function to close the window . is this possible in zoho creator ? Thanks You
Can I restrict manual date input, So user will only be able to select date from pop up calendar ?
I want to restrict access for manual access in the date field.. My date field is called [Workshop_Date] in form [new_ws_entry] in my application called [new_ws_entry] No brackets Its set up to have the user enter dates, either by clicking the calendar icon, or by manual entry. I don't want manual entry as it leads to mess ups in the date field. The users are from Canada and US, so when they enter dates.. its 2011/04/04 or 04/04/2011.. This leads to issues .. I have diabled the field, but it
Display table with only (Edit or Delete) option
Hi, I have an application i.e view form ->having this field fist name : svenu last name :gopal email : venu@zoho.com etc fields With Edit and Delete options . once we click Edit or Delete -> that will go to the database table view . If Edit -> in database table only Edit has to show ... all options has to disable. If Delete -> in database table only Delete has to show ... all options has to disable. Is There any option to do like this or else Any other way functionality that will work on
New update in precreator.zoho.com
We have updated a new build in http://precreator.zoho.com . You can view the change logs in https://help.creator.zoho.com/Feature-updates-and-bug-fixes.html . Noticeable change, Deluge alert task used in Form "On Load" and "On Validate" will be displayed as "HTML Dialog" instead of native JS alert (to support latest browsers) - More Rajesh
Help with code please
Hi, could someone please tell me what is wrong with this code... if (input.Inspection_Fee != input.Inspection_Fee.round(2)) { input.Inspection_Fee = input.Inspection_Fee.round(2); } Thanks Nigel
need your help for how manipulate multi select picklist field
Hi Ruben I chosed multi select picklist field data, but in edit mode is topen it, will not want to see a lot of other data, how to keep only the selected data when I edit the record. Thanks! Stanley Guo 2011-11-28
Mass-update lookup fields values with regular dropdown fields values.
I want to set for a record a lookup field (let's say country lookup field) with country regular dropdown fields of the same record. I've tryed .select function, and nothing.
Help my form has gone lobsided
Hi, My form https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job has some how changed the column widths so the right hand column is wider than the left. Not sure what I did to make this happen but it has worked fine with all the current fields. Please help. Cheers Nigel
How would you set this up?
I have tried doing this myself but am getting confused on how to structure an application. If someone(s) experienced could help me, I'd appreciate it. The application is for keeping track of hundreds of websites, their promotion campaigns, their rankings in the search engines, development and maintenance. The websites need to be able to be dealt with both individually and as bulk groups. The websites have a front page, and then 20 or more sub-pages. Each page on a website has 3+ keywords that each
Help in performing calculations in Zoho Creator fields
I have a particular problem, and I've been struggling with it. I thought I'd just go ahead and ask here. I'm a book review editor, and I want to use Creator to track books I've assigned, review due dates, how many days a book has been out, etc. Specifically, I have a field titled "Date Review Due." I want to look at another field, "Date Book Received," check to see if the reviewer has received the book, then look at another field, "Date Review Received," verify that the review has not been received,
Importing to two tables.
Good Morning, I wonder if someone could give me some advice on something I am looking at. I am starting to build an application in Zoho Creator that will import data via csv files from other applications. The 'live application' will only be interested in looking at the data from the last import but I want to keep an archive off all data uploaded so importing and deleting current items wouldn't be suitable. So is it possible to import to two different tables at the same time with the first adding
NEED HEPLP: structuring application for a SEO company
I have tried doing this myself but am getting confused on how to structure an application for this project. If someone(s) experienced could help me, I'd appreciate it. The application is for keeping track of hundreds of websites, their promotion campaigns, their rankings in the search engines, development and maintenance. The websites need to be able to be dealt with both individually and as bulk groups. The websites have a front page, and then 20 or more sub-pages. Each page on a website has 3+
Sendmail script on edit
I am trying to create a script that sends an email if my Assigned_To field is changed. So the conditions would be as follows. If the Assigned_To field is changed then send an email to the user specified in the Assigned_To field. I can get it to send an email on edit if the the Assigned_To field is equal to a certain user, but I only want the email sent if the Assigned_To was changed during the edit. Otherwise every time a record is edited an email will be sent to the Assigned_To user even if it
how to publish the same 3 application at one user from one application
Dear Sirs, We plan to publish our application to other user. In that case, is it possible to make the same three application at one user from one our application ? If possible, how do we do? Best regards,
Searching in View
Hi! Is there anyway of adding a search bar in the view, or adding a filter that will search anything a user enters rather than setting up a filter option (There is no option for Equals to Anything) ? There is current an Equals to in there, but that means I'd have to enter every word in the dictionary to have a specific result! Thank you,
Limit number of records displayed in a subform
How can I limit the number of records displayed in a subform, both when it is displayed in a view and when the detail is opened to edit. We gather monthly statics on clubs in Africa. Years of data is collected, and I only want the user to see the current year at a time. Our main form has club info with a subform for attendance records. In a test (which didn't work) I tried to just limit to the Month of November. Below is a snipit from the parent form code: Weekly_Statistics ( displayname
Next Page