Create records in one form from a multiselect lookup field from antother
Wonder if someone can help; I am trying to find a way to select some records from one form and then use these to create new records in another form. At this point I have created a stateless form with a multiselect lookup for my unit "serial number"s and an action button. I have then tried to create a script for the button; 1 for each key in input.Serial_Number 2 { 3 insert into test 4 [ 5 Added_User = zoho.loginuser 6 Serial_Number = input.Serial_Number 7
Making a field required - code not working
I'm trying to make a field required if the check box above it is checked. This is the code I've input, but it comes back with an error. ((input.VAT_registered == "yes") && (input.VAT_number == "")) { alert "Please enter VAT number"; cancel submit; } Please help! Thanks J
next url doesn't redirect
"next url" doesn't redirect but attempts to open the url within the iframe.
Any way to sort forms listing when adding a Lookup drop-down menu?
As the image below illustrates, there seems to be no clear order or logic to the listing of forms and their fields that is displayed when inserting a Lookup drop-down menu into a form. My application has many forms, including many that are not in use, so the listing of forms is long. So, when inserting a Lookup menu into a form and needing to identify the field of a particular form to import from, the long list is unsorted... clearly it would be better if it were alphabetical by form name. Is
Recommendation: allow some simple layout control in live Form views
I'm sure most of us have at one time or another wished we weren't constrained entirely to only one way to have our forms laid out. Currently, like it or not, we must all live with two vertical columns for fields that stack vertically into those columns -- one way. Well, it could be worse, but it sure would be nice to be able to have greater control of that layout with more variety of options. One simple option that would make a world of difference in some forms would be to control the width of
sendmail with for each function
Hi, I have a form in my application https://creator.zoho.com/username/consulado-app/#Form:Arquivo_Cform in which I have a sendmail function for each email in a field. This is a multiselect field and the first data inserted was correctly sended to the emails selected in the multiselect field. But when I try to insert others data with differents email seletect (field Funcionário) zoho sendmail at all email selected in the data inserted before and also at the email selected in the new record. There's
Inconsistent behavior in list view with search and page size
Hi List view , i do a search get some results, change page size at the top (see red circle on attached screen shot) Select 10 , 20, 30 40 all good Select 50 and the "Page Size" Option vanishes go to the bottom and select 75, 100, 200 it comes back .. Just the option 50 has the issue Must be it is i hate "50" at Zoho day
Non documeted limitation - maximum number of Expressions in HTML view in Edit Mode
Dear Zoho Creator Team, What is maximum number of Expressions in HTML view? According to my testings more than 200 and less than 400. And limitation is that HTML view with such number of expressions is loading FOREVER in the browser. Limitation is presented in IE, Firefox, Chrome. Below are described steps to reproduce this behavior. Step 1. Create HTML view: htmlpage Expressions_400_Bug() displayname = "Expressions 400 Bug" content <%{ a = "b";%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%>
Zoho xml rpc request returns success but no record in database
I have problem with my application, when i try to insert record from custom html form from localhost i get success response. But when i try to view records in the database view the record is not there. And if i delete record from my view and then i try to insert new record i get success result and the record is there i can see it in the view. By the way i am sending the post request with php curl and it is working ok Any help with this will be appreciated. Here is the code: $apikey = "xxxxxxxxxxxxxxxxxxxxxx";
Share Bug
I made my application public then reverted to private. Then I attempted to share with a user and got: buzzap/abis is shared with ZC support Cheers, John Whitney
Set subform field only to Display
Hi ZC Team I have a Form with a subform, when I click on Add I have a field on the subform that is completed with a value existing on the parents form. What I want is to show as today but disable the possibility that the user update that Field (is a dropdown field) I was trying at subform level on Load Add disable but it doesn't work, is any way to only display a field in subform and avoid alter it?, please let me know. Thanks a lot. Victor Miranda
"Other Postal Code" Field Error
Hi I have written a form here: http://www.rentlondonflat.com/rent It works fine in Zoho Creator. All the data is recorded. Everything we put in the form is recorded into Zoho Creator and we can access data there. There is also a script which passes the data to Zoho CRM. All this also works fine as well apart from one field. The field to which we are trying to pass the post code across from Zoho Creator to a "Standard Zoho CRM Field" called "Other Postal Code". This is name when set to UK English.
Form relationships
It all starts with the need for a calculated field on a report. I need to multply a price from an inventory form by qty from an activity form. I have related the forms by lookup in the activity form. My thought is to create a calculated field in the activity form but I don't have access to the price field from the inventory form despite the lookup and relationship. What is the best solution? Thanks
Given several applications and many users, how can I associate applications to users?
I have 3 applications and 5 users (u1,..., u5). I want application 1 to be used by users U1, U2 and application 2 to be used by users U4, U5 and application 3 to be used by user U3 only. I will be the admin for them all. Is that possible in ZOHO Creator? Thanks.
form asking for login details
Hi, The form I created for our website is now asking people to enter login details. We're on a free account but don't appear to have exceeded any of the imposed limits. Any help would be really appreciated. Thanks, Joe
Backup limitations?
Hello, I wanted to ask about the limitations of a Zoho Creator Application Backup. Does the backup contain uploaded files? Does the backup contain application permissions? Thanks
Can I see an example of a application that manages relationships?
I run education programmes for schools and need a decent database. I need to be able to look up what instructors have delivered what programmes, what sudents have been on what programmes and create relationships between instructors and programmes, clients and programmes and students and programmes. I have hada look at Zoho but I cant see anything that will provide an example of what an end product might look like. Do you have any examples of how clever Zoho Creator might be?
Using zoho.adminuser variable instead of static "ownername" in urls
I want to publish an app to the market place without code, ie client can't have edit mode. I have certain html views that happen to have url links that include my app_owner_name. The variable zoho.adminuser returns the username of the application owner. Is there any way to construct an url to a view/form with the variable instead of the static <ownername>? Example: http://creatorexport.zoho.com/myname/app_name/print/printable_HTML_view Where zoho.adminuser replaces "myname" so that anyone who downloads
How do you update a CRM record from a Creator form when you don't know the CRM ID?
Hi I have a script which simply adds a record via a form to Zoho CRM. tenantinfo = { "Salutation" : input.Salutation, "First Name" : input.First_Name, "Last Name" : input.Last_Name, "Mobile" : input.Mobile_Number, "Email" : input.Email_Id, "Date of Birth" : input.Date_of_Birth, "Employment Status" : input.Employment_Status, "Organisation" : input.Organisation, "Monthly Income" : input.Monthly_Income, "National Insurance No." : input.National_Insurance, "Other Street" : input.Current_Address, "Other
Preserve Multi-column Layout for Dynamically Created Radio Buttons
This may have already been mentioned, but I just noticed that setting a 3-column layout is ignored when the radio buttons are dynamically added upon form loading. Thanks, John Whitney
Google Apps UrlFetchApp.fetch to zoho creator session does not close
Hi , Am calling the Zoho Creator get ticket API call using UrlFetchApp.fetch After the call the session remains active on my Zoho Account and as is the case if too many sessions remain open to Zoho the API will stop responding. Anyone know of this issue or knows of a way around it. thanks
Special View Criteria
Sharing a view with a user gives that use full rights to see all the data. What if we only want him to see a sub-set of data? I'm guessing view criteria is not sophisticated enough to handle this. The only way I can figure out how to enable this would be to have a new column in the data with the user's zoho ligin ID and set-up criteria to filter on that. Comments? Cheers, John Whitney
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
On this page: https://creator.zoho.com/webmagnets/view/17/edit/ I am getting this error: [ServletException in:/jsp/edit/view/viewedit.jsp] null'
The Speed vs Quality Tradeoff in Software Development
There are two broad categories of criticism we get in Zoho Creator (and Zoho in general): 1. I asked for this simple thing months, years ago, it is still not done. Is your development team sleeping? 2. How can you put this bug? Is your QA team sleeping? In fact, sometimes the same person would offer both of these criticisms, at once. Let me first say that we have shipped over 20 services in Zoho and we are now on our 7th year. The broader Zoho Corp itself has over 60 products, and has been in business
Help needed- need to total hours worked per person in understandable format
Help needed- need to total hours worked per person in understandable format Anyone know how to do this? I have a formula box that totals the time, but it comes out in seconds, and it would be great to somehow look up each person and get a total in readable hour/minute format. Any ideas? formula zoho end time date-zoho end time date = total time person worked (I have this already) BUT WHAT I really need is a sum of all of the hours that person has put into a work month... Any ideas please help,
In-place editing of a lookup field for multiple records
I have an application for organizing people into focus groups. When a Study is created, the user names 1-n possible focus groups (e.g., "group 1" "group 2"). People are recruited to a study and must be assigned to focus groups. To assign a Person to a focus group, the user needs to look at a variety of background information on each person. Thus, I'd like the interface to look like: (for a given Study) Person 1's name Gender Experience etc... <lookup drop down with possible focus
Upload File to GoogleDocs via Zoho Creator
Hi Is it possible for an uploaded file from a Zoho Creator Form using the upload field to be uploaded into a GoogleDocs Account instead of Zoho for storage? Thanks Gene
Zoho Creator Page Load Speed
I have noticed that at about 12:30 PM (EST) to about 3:30 PM (EST) that the page download / upload speed has been drastically reduced. I am wondering if this is when you are doing your updates which would be 10:00 PM (IST) to 1:00 AM (IST). I performed a speed test for my browser and the results are: Ping : 15 ms Download: 23.45 Mbps Upload: 23.77 Mbps From the results stated above you can conclude that it is not my browser and in fact it is Zoho Creator that is having the issue. My company cannot
Hide / show fields with conditions
Hello; I want to hide some fields with conditions, for example, if the user choose ' No answer', some fields don't appear, I feel very lost in functions, since I'm a novice. Another thing, if the user types '2 'in the field ' number of children ', two fields will appear for each child's name and date of birth, how can I handle this action. I'll be very grateful. Thank you very much.
many mails in input.Mail
Hi, i made a variable Mail, can i put more than one mail in input.Mail? if so, what is the separation, ";" or "," or any aother?thanks
Sendmail to picklist
Hi, I'm unable to find an help in this forum and in sampleapps. I have formB with list of employee and formA with subform for uploaded document and a picklist lookup field with email of employee showed as name of employee. I need to do the simply action to send in attachment (as link) the uploaded doc to the employee selected in the picklist. I look for it in the iterate https://help.creator.zoho.com/Iterate-Records-in-a-Form.html and https://help.creator.zoho.com/Iterate-Data-in-Radio-buttons-and-Checkboxes.html and
Email notification to multiple picklist contacts...
I have a "To Do" form + view which allows you to select a member of staff from a picklist linked to an accompanying "Contacts" form, and assign them to the task being created. When the form is submitted, an email notification is sent to the member of staff concerned. All this works as it should. What I would like to be able to do is to make the picklist allow multiple selections, and send an email notification of the new task to every selected contact's email address on submission of the form. Can
Multi select causes an e-mail to be sent to staff on submit?
I have created a task management application with a form that tracks tasks and a form that contains staff names and e-mail addresses. The action form contains a Multiselect that allows someone to choose who is responsible for the task. This field is populated by a lookup from the staff field. I want an e-mail sent to each staff member set as reponsible upon submission. Can someone help? I am new to deluge and really struggling with this. http://creator.zoho.com/basketballscotland/action-manager/
Create a search function that will pull existing records
Situation: I am allowing users to enter membership data. But, if a membership record already exists, I would like for them to search for it and then be redirected to an 'edit' page where they can edit that existing record. I'm not sure how to do this. What I tried: I made a 'search' box where 'on user input' it searches for any record with the information entered and populates the form with the record information. BUT it will save a duplicate copy if you submit it...that's my dilemma. Any help
Hide / show fields using conditions
Hello; I want to hide some fields with conditions, for example, if the user choose ' No answer', some fields don't appear, I feel very lost in functions, since I'm a novice. Another thing, if the user types '2 'in the field ' number of children ', two fields will appear for each child's name and date of birth, how can I handle this action. I'll be very grateful. Thank you very much.
Does delete or backspacing a Date field to blank create the null value?
The on Input script below is designed to set the penalty field value to 30 if the day of the month is after the 15th, and to 0 if the date is not after the 15th OR if the date is blank (I'm assuming a blank date is null). The problem I am having is that when I delete or highlight and backspace the date to a blank (and then click outside the field to trigger the script) the penalty field is not reverting to 0. Can anyone hazard a guess as to what is wrong with my script? Thanks to Gaev for sending
Simple 'many to many' search example
Hi, I am trying to find a simple example of a many to may searchable database built with creator. For my needs, there are a number of 'instructors'. The only details I need are the full name and the postcodes they serve. Each instructor teaches in a number of 'postcodes'. Each postcode can be served by a number of instructors. The list of current instructors is a lookup from another form so as to always be current. In the end all I want the user to see is a search box. They would input the postcode
View to show latest record for each group of data
Hi, New to creator and just starting on my 1st project. Have some self taught experience of access and SQL but this is a long time ago. Am working on an asset tracker for use by us as an OEM and our customer as they use and distribute our machines. Mostly I need to track current location and current condition. I have a base form for my machine data such as serial number and then some other forms for input of location change and condition change. As the machines are used they will move around to lots
HTML view print problem
Hi, I have a html record view which get parameters from a form, when i wan to print the html record view, i get the following error Not Found The requested URL /bilgain/hr/print/Payslip/&Name=test&Date_field=01/12/11 was not found on this server. this is the print link https://creatorexport.zoho.com/bilgain/hr/print/Payslip/&Name%3Dtest&Date_field%3D01%2F12%2F11
Audit or History of Changes
Is this correct? 1. If I use a combination of getfieldname and getfieldvalues: a. Used in the ON LOAD or VALIDATE - it is null b. Used in the ON SUCCESS - it returns the new value 2. The old. property only works in the VALIDATE Is there any way to marry these two, so I can build a routine that will store the original value of any field that is changed?
Next Page