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
XML RPC API Issue
hi, I am using XML RPC API "http://www.zoho.com/creator/help/api/xml-rpc-api/xml-rpc-api-add-records.html" for adding 20 records to my form. I have prepared the required XML request as per the your documentation and made a request. But in the response I am only getting the last record with 'Success' status. Also, the form reflects only that last record. Kindly look into this. Also, let me know if you need anything from me. Thanks Gurpreet
Creator to Invoice API
Is is possible to send the Billing Postcode/Zip code over from Creator to Invoice when creating a new customer using the API. Been reading this page and it doesn't mention it https://help.creator.zoho.com/Create-Customer.html
can i convert the default value of dropdown field into integer value such as zero / 0 ?
//question: I have this Script that I want to calculate: (IF(How_many_days_is_your_group_skiing != "-Select-",How_many_days_is_your_group_skiing.toLong(),0) * ( (IF(Kids_Skis_Age_12_and_under != "-Select-",Kids_Skis_Age_12_and_under.toLong(),0) * 23) + (IF(Adult_Skis != "-Select-",Adult_Skis.toLong(),0) * 30) + (IF(Performance_Skis != "-Select-",Performance_Skis.toLong(),0) * 41) + (IF(High_Performance_Skis != "-Select-",High_Performance_Skis.toLong(),0) * 50) + (IF(Kid_s_Snowboard_Age_12_and_under
Query regarding the send email
HI I have question regarding send email functionality in zoho creator. To : r.EmailId From : zoho.adminuserid Subject : "Regarding subscription to our newsletter" Message : "Your subscription is approved" If i want to address to be dyanmic then in that case do i need to have paid account because it is not allowing us this in free account Regards Rana Ammar
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
Feature Request: Merge records
Hi, I've recently started developing an application for our organisation. The data that has been imported has some duplicates, and this is causing problems with our records. It would be great if in one of the views, I could select two records and click on "Merge" (which would display any conflicts, as well), and fix up any record relations. Is this on the cards?
Sum of field on related table
Good Afternoon, I am trying to find a solution to the following and haven't been able to find any help articles on it. In a table called Client I have a field called Total. I have a table called OpenItems with a field called Value I would like the Total field to be the sum of the Value field when the ClientID field matches. Any help on completing this would be appreciated. Many thanks. Best regards John MacPherson www.saffuze.com
Document date in age ?
Good Afternoon, Could someone please direct me on how to create a field that generates the 'age' of a document in days (not years). I can find the help file on calculating date of birth but I don't really understand the formula and which section to remove to convert back to days. ((zoho.currentdate - DOB) / (1000 * 3600 * 24 * 365)).round(2) I am confused why (zoho.currentdate - documentdate) doesn't appear to work. Also will this field only update on creation and if so how do I get the field to
View showing empty fields as NULL: how to show nothing/blank instead?
Hi, In a form, I have two picklists which can be selected, or left empty. I then have a formula field which gathers these picklists in one field using the calculation picklist1 + picklist2. In a view based on this form, I have the formula field showing, but whenever any one of the picklists have been left empty, the column shows the word "null" instead of a blank. How do I get rid of the word "null", and just list an empty field if nothing has been selected?
About the Express Pricing
Hi, Since the changes Zoho has made, and I have moved into research and development. It appears that ZCreator has become exactly what I now need. Strange considering about a year ago, my position was reversed in using Zoho at all! Creator is exactly what I need...exactly, especially for our new embedded-design projects! What exactly is this express pricing? Thank you, Mario Stevenson, P.D.L. & TTEE, EQEACT
Report User Filters - Date locale not respected
Hi I've added a date range as a user filter to a report. The calendar drop-down works fine, but if I type in the date the system is forcing interpretation to US date format, despite the application settings being set for European (e.g. if I type in range 1/9/2010 to 30/8/2011 the first is interpreted as 9th Jan and the second is not resolved). Am I missing something or is this a bug that needs fixing? (App is Pupil Assessments and report is Pupil Progress. Support access is on)
Subform: How can show a field value existing in the main form?
Hello Zoho; I have a main form and a subform in order to track availability of consultant skills, idea is to add into main form all the information regarding an Technology open position. Then in a second instancy HR will add on the subform all the candidates matching that open position (Name, available date, CV file, etc). In order to easy track that I need that the open seat # field which is a field generated on the on add of the main form can be automatically passed to other field in the
schedule quota
We have same problem as same as bellow topic about schedule quota (though our plan is standard). https://help.zoho.com/portal/en/community/topic/schedules-quota-are-too-few How do we do ?
How do you change the value of a List() element?
The help documentation is clear about how to add and delete (remove) an element from a List(). But, unless I'm missing something, there's no explanation on how to change the value of an element in a List() using an index. Example: myList = List({"Larry", "Mo", "Curly"}); myList(2) = "Shemp"; <-- this is what I want to do, change the element with index=2 (the third element) to "Shemp" ...now the list should contain "Larry", "Mo", and "Shemp" or, something like: myList(2).set("Shemp"); <--
Next Page