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?
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
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.
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.
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
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
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
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
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)
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 ?
using this </br> in script submits it as text not a next line
Hi we have </br> set in a 'on edit' 'on success' script and it is submitting the the </br> as text instead of next line. I have also tried "</ br>" and "<br />"
Subform and Picklist
Hello I have a Subform related to a main form and I want to retrieve information based a third form , I wrote the code below and if a test that from the subform itself this is working, however when I test from the Main Form containing the subform and click on add row and then when I click on Nacionalidad field which is a lookup field trying to reduce the numbers of occurrence the picklist candidato its not working, why is that?, which are the differences testing the subform isolated like a form
Ability to Add Record to a form in a private application as a shared user through API
Hello, I know in your REST API webpage (http://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html) you state that "Only the owner of the application can add a record to a private Form." but it is also stated that "Any user with an API Key, Ticket and share permission can add a record to a shared Form." I want to ask if its possible for a user, who is not the owner of the application, to add records to a form, in a private application, it has a share permission to? (maybe i'm a little
Fixing chart scale in Creator reports?
Is it possible to inhibit the auto-scaling of the Y axis of charts in Zoho Creator reports? It's really annoying that it rescales when filters are changed as you don't see the relative changes if the chart compensates. If I know the range is 0-5 then I would like to fix the scale at that. Have I missed it, or is this a feature request? regards Simon
Relationships between Forms
Can data from a Field "Event Date" entered in FORM A be simultaneously entered in Field "Event Date"in FORM B of the same application? I can get the data in the look-up box on FORM B but that isnt much help.
Custom Filters for a view based on tableA
Hello all, Is it possible to generate a set of custom filters for a view based on the values from a separate table (TABLE A)? TABLE A is used by several forms in my application, and if I only have to update one table, instead of this table, and filters it would be much easier. Jason Rapp
Invoice integration - BillingState/City in invoice function and createEstimate
Is there any way to specify Billing State & City by invoice function ? I referred to the help page and found that I can specify "BillingAddress", but there weren't BillingState or BillingCity. Without these, we need to combine all the address values into "BillingAddress" but it will cause problems when we retrieve those data in templates etc. Also, I want to create estimate in the same way to createinvoice(). Is there any function to create estimate such as createestimate()? If not, will it be supported
Formula field not resolving in reports
I am having problems getting a formula field to work in reports. The formula is to get the season of birth from a DOB field: if((DOB.getMonth() < 3),"Winter",if((DOB.getMonth() < 6),"Spring",if((DOB.getMonth() < 9),"Summer",if((DOB.getMonth() < 12),"Autumn","Winter")))) It works fine in the list, but when I try to report using a pie chart it reports "No data Available" and the legend has 1 item "Unknown". Is this a known issue, or am I doing something wrong?
How do i limit the number of times someone can submit a specific answer.
I have created a basic form with numerous questions. The selection for answers are all the same: Do not use that feature of the product Not important Important Very important How do i limit how many times they can select Very Important? They should only be able to select this 10 times. Thanks!
Publish a counter on the webpage after the form is completed?
I'm using a form as a way of collecting online pledges towards a goal. --#1 -- Is there a way to post the number of people that complete the form to a webpage? --#2 -- Is there a way to make this editable (meaning we collect pledges at events too and need to update the numbers manually as well. Thanks in advance, I like you all.
return a list in a multi-line field
I'm trying to fetch and return a list into a multi-line field, but can't figure out the script. Select a region (radio button) fetch a list of records = region (which I can already do) Return list from the records that = region in a multi-line field (rather than a drop down lookup) so they are easy to see I don't need the list to be selectable, but rather are just for reference.
Creator links not working in FF8
After upgrading to FF8, links in Creator projects are not working properly. For example, when the link for a pdf "Tech_Notes.pdf" is selected, FF8 does not know what to do with it. Response: You have chosen to open DownloadFile.do which is a Adobe Acrobat 7.0 Document (-1 bytes) from: https://creatorexport.zoho.com ===== this same error occurs for *.doc, *.docx files (i.e., the exporter thinks the link is pointing to an Adobe doc) since this is the "filename" for both *.docx and *.pdf files, it is
Data in my reports does not match the data in my table views
I have created several reports using the Reports tab in Creator based on 2 different tables in my database. But the data in my reports do not match the data in my tables. I used to be able to "fix" this by going to "More actions/ Regenerate" but now when I do that, I get a message that says you cannot regenerate my reports. (The problem is not isolated to a particular report or a particular table view; it seems to be universal.) App is at: http://creator.zoho.com/kellyanderson/bd, and-although
Email header: change to return-path
HI, About 24 hours ago there was a change in the email headers going from my Creator application. The field "return-path" is no longer using the administrator email address. Instead it is using <mailserver+(myname)@zohocreator.com>. This has created problems for me with downstream service providers and has prevented these emails from being delivered. How & why did this change occur? Can it be changed back, and if not, why not? Please can you help? Many thanks Anna
How do I display the result of several formula fields in the same form?
I have several formula fields that calculate the subtotal price of products when the quantity is entered. How do I generate a sum total of the formula results and display a "total cost" field in the form ?
Decimal Fields Calculating a Whole Number
Hi, I have a "Total" field that is the sum of all "prices" in a sub-form. I have this working using the formula below. However, the result is giving me a round number as opposed to a decimal. So, if my prices are 22.10 and 11.13, I get a result of 33 as opposed to 33.23. All fields are specified as decimals, so I don't understand why the result is rounding down. Please help! Steve ------------------------------------------------------------------------------------ temp_total = 0.0; for each Title
Error in counting the number of record in my account
When I access my Usage Limit and go to Add-Ons I see this S.No. Particulars Your quota Used Remaining 1 Records Count 6,000 1 5,999 2 File uploads and Attachments 500 MB - - Although I have more than 1000 records in one application!. Most of the records are add as a duplicate or through API. Please help ASAP
Multiple criteria in a lookup field
I have a lookup field in form "Dispute" which looks up data in a form named "User", and which uses as a criteria "User_Type == "A". This works fine. But in addition to the above criteria, I also need to add as a criteria where the field "User_Country" in the User form = the field "Country" in the Dispute form, so that the user does not need to scroll through lists of users that are not relevant to the country. I tried to look this up in help and forums, but I couldn't find how to do this. Could
View records created that week for a non-standard week.
I have a need to show new records created that week, but using a non-standard week. I have a client whose work week runs from Saturday to Friday. I was trying to use the getWeekOfYear function, but due to the non-standard work week it would not work properly. Any help would be greatly appreciated. Bill
how to protect previous text in a multiline box
hi everyone i would like to have notes added to a record. so each time it the record is updated by someone it will record the date and save some text the user enters into a multiline box. how can i protect this text so next time someone edits the record they are unable to delete the last text added. also how can i get it to add the current date when a user edits a field? or is there a better solution? cheers Lathan
Update on custom domain feature
Could you provide an update on the progress of the custom domain feature? I'd like to be able to mask the Zoho URL with an URL from my own domain. Thanks, John
Scheduling HTTP Post Actions
Are there any limits to scheduling http post actions? The reason I'm asking is because my script is set to perform 10 such actions once a week and it always stops after 8. The code below shows the basic loop. for each r in CALENDARS [(SUBLIST is not null)] { standard_name = r.Organization + ": " + r.Calendar; TOPIC = "Weekly News for " + standard_name; POST_BODY = thisapp.NEWSLETTER(r.Calendar); POST_MAP = { "FROM" : r.Sender, "SUBJECT" : TOPIC, "BODY" : POST_BODY, "FILTER" : r.SUBLIST
Next Page