existing study id
So I have a form and have uploaded 160 study ids into this form. I want to be able to enter data only for these study ids and also have other people add data to these study ids. How do I show the study id? For example in an access db you would just go to the next id enter data then select the next id. But I am new to zoho and don't know how to select the study id. Currently it is a text box field. do I need to create a dropdown box with all the studyids? Then I can write a script to excluded the
Need help on sendmail
I am trying to use the sendmail function to send an email to the person that a task has just been assigned to. The form is New_Task. The table with the employee information is emp_list. I have a lookup field from the New_Task form to the emp_list that pulls up a function field concatname which combines the last and first name. Here is my code below, please let me know what is wrong with it, thanks. { assignedtaskemail ( type = string ) assignedtaskemail = emp_list[concatname = input.emp_list1];
Nested checkbox list
Hi, I am wondering if it might be possible to accomplish the following through deluge and a standard form (seems you can do it as a html page but I'd rather not go there). I have a set of checkbox lists that look like this Checkbox 1 Checkbox 2 Checkbox 3 Checkbox 4 These items are not hard coded but rather are dynamically added from a table in the application. What I need to be able to do is to nest some items under each checkbox. So for example, if you click on checkbox 1 you would see something
Create a relationship between two records?
Hi pals, I'm building a marketing content inventory application to keep track of all the content my marketing department produces. (Brochures, white papers, case studies, etc.) One way a content department makes itself more efficient is by deriving one piece of content from another. For example, if I write a 3-page white paper, I can derive a blog entry and a newsletter article from the white paper with very little effort. Each one of those items are a "content item" on their own. They're all entered
Column limit
Hello, How many columns can I have in a zoho creator database? Is there a page with all of the limitations and/or specifications? Thanks. Iram
dropdown data creating merged categories
I'm creating an app to inventory my marketing content. A piece of content can only be one KIND (e.g. datasheet, brochure, white paper), but it can have many audiences (e.g. CIOs, CEOs, CFOs). The form that I've created uses dropdowns to select the audience, and the user can select more than one. However, in the reports, the system is creating merged categories, instead of listing the assets twice in each category. Here's what I'd like to see: AUDIENCE = CFO Assets A, B, D AUDIENCE = CEO Assets A,
subString() not working
I am trying to validate and format North American phone numbers They should always be ten digits in the format (xxx) xxx-xxxx. Here is my code: // get input without special characters rawno = input.Cell_Number.getAlphaNumeric(); // remove letters rawno = rawno.removeAllAlpha(); // get number of digits noln = rawno.length(); if (noln != 10) { alert("Number must be ten digits.\nYou entered " + noln + " digits.\nPlease re-enter number."); } else { areacode = rawno.subString(0,2); etc.
Second level lookup question
I have three tables/forms: "Franchise" lists details about each franchise, including Franchise_Name. "People" lists details about each person, including the lookup field Franchise, which looks up from Franchise_Name in the Franchise table. "Call_Record" which a person completes when they make a sales call. It contains their name in the Caller field (which is inserted automatically by matching zoho.loginuserID against email addresses in People and then extracting the person's
"if" statement causes error.
I keep getting an error from a simple "if" statement. noln = rawno.length(); ... correctly returns the length of rawno. But... if(noln != 10) { etc. ... gives an "Improper Statement" error for the "if" condition. Huh?
Restriction on RTF on Load of Stateless form
Are there any restrictions on setting the value of a RTF in a stateless form? In the on load section I'm setting a RTF equal to a RTF field from a fetched record. Nothing shows in the screen field. An alert statement does show the value. So I know I have fetched the record properly. I can put the value of the fetched RTF into a multiline field with no problem. Once the form is loaded I have a field that fetches the record and properly loads the RTF field with the correct value. It is only in the
Can't duplicate an application.
Neither is the export and create new application from DS file feature working. Please help. App URL is: https://creator.zoho.com/appbuilder/360hvpl/health-vectors Access has been granted to Zoho Support -Varun Yagain.
I'm having trouble importing a .ds file
When I Create New Form / Import File It takes me to an error page after selecting my .ds file and clicking the Create button; An error has occurred. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home I don't know why I was unable to import my .ds file.
type mismatch on code that was not chnaged?
I have this error showing when I click on save: "Mismatch data type for function 'getAge' at argument index 1 expected data type TIMESTAMP found data type BIGINT" it occurs in the line beginning row.age: if ((row.personId.dateOfBirth != null) && (input.dateAndTime != null)) { row.age = thisapp.stc.getAge(row.personId.dateOfBirth, input.dateAndTime); } this is code that was not changed but with this error I cannot make edits any way.
How to get values from multiple records?
Hi All, I thought this would be straight forward but I've lost the plot ... I have a form Customers. On Add Customer, sometimes, the customer name already exists in the table, which is fine because the address may be different. So we could have "Doe, John" with an address of "Hokitika" and "Doe, John" with an address in "Taranaki". Perfectly ok but I'd like to bring this to the attention of the user. It isn't possible to compare addresses as there could be slight differences between entries. What
How to make consistent values in a field of the main Form and a Subform
Hello, how can I make it to have date-fields in an Subform be consistent with a date-field in the Mainform? Or in other words: I have a date field in MainForm, when I update this, I want that all dates in the depending Subform-rows are being updated.
Lookup fields and null state
Hi All, I have a simple bit of code that doesn't appear to be playing by the rules! Both Task_Helicopters_Required and Task_Pilots_Required are non bidirectional Lookup fields. if (Task_Helicopters_Required = null ) && (Task_Pilots_Required = null) { enable Task_Type; } else { disable Task_Type; } The above is accepted as valid script but Task_Type is immediately disabled on form load. I have tried changing null to "" and again it's accepted but in this case, Task_Type is never disabled. Am I being
Clearing Multiselect On Edit > On Load
I have a multiselect check box that I would like to clear of its values upon On Edit > On Load. I have tried input.Field = null; but the previously selected values are still selected.
Get subform records
Hello I ahve an application with Shops and Contacts. A Contacts can work for many shops. Used forms : - Shops - Contacts with a subform ShopWork with is a lookup field, drop-down list of Shops called Shop I want to display all Contacts for a given Shop. Input.ID is the Shop ID. lst="" ; rs = Contacts [ ShopWork.Shop == input.ID] ; for each Contacts in rs { lst=lst + rs.ID + " " + rs.ContactName + "<p>" ; } input.ListeContact = lst ; I get some names but, they have all the same values...
Change color of embedded Zoho-Calendar in Zoho-Creator
Hello, is there a possibility to change the color of Zoho-Calendar (like in Zoho-Mail) when I embed it in Zoho-Creator? I created a page and embed Zoho-Calendar with the following code: <iframe name='zohoview' height='800px' width='100%' frameborder='0' scrolling='Auto' src='https://calendar.zoho.com/mycalendar#' ></iframe> Because the blue theme of Zoho-Calendar looks not good with Profesional-Black theme of Zoho-Creator → I want to use grey theme. Is there also a possibility to hide the Header
auto-create form and run calculations
Hi - I have a Calculations form which runs a bunch of calculations on User input of a Project name. I would like a record to be created in the Calculations form each time a set of criteria is met in the Project itself (i.e. if I enter the finished length of the project, create a new Calculation record for this project and run all the calculation statements). It would also be nice if the Calculation form would update if the Project form updated and that two of the same calculation form couldn't be
Script Builder Deleting Parentheses and Throwing Error
In free flow, I type this and save it without any errors: Changing to script-builder it deletes the parentheses and throws an error: In Criteria left expression is of type STRING and right expression is of type BOOLEAN and the operator + is not valid If I fix it in script building and then go back to free flow, it again deletes the parenthesis. ZC must have some additional error-checking when switching between the two edit modes that should be analyzed and fixed. Cheers, John Whitney
Bypass print dialogue
Any way to bypass the print dialogue? for frequent printing this is becoming a hassle to close the print dialogue each time.
Editing a record someone else created
I am running as Admin. I am trying to edit a record using this link: https://creator.zoho.com/..../Contracts/record-edit/Contracts_List/1526298000000568067 That works OK. If I use the ID of a record created by someone ELSE, I get You are not authorized to edit this record. BUT, if I use a different view which has exactly the same permissions.... https://creator.zoho.com/.....Contracts/record-edit/Contracts_Testing/1526298000000568067 I CAN edit any record. Anyone have any ideas? Alex
how add entry via email?
hi how can i enter new entries in my app via email?
Date-time "daysBetween" is not being recognized.
The compiler isn't recognizing the method anymore. daysBetween(today,today.addDay(3)); throws up the error: Error at line number : 1 Not able to find 'daysBetween' function -Varun.
auto populate problem
i know a lot of people has discussed it earlier but i have problems with my auto populate fields i want to share my problems with the developers so they can fix it for me as i am very new to zoho and programming bitsi can give links to my app if they wanna have a look into it the code i am using is this if (Quote_Info[Quote_No == input.Quote_No1]) { temp=Quote_Info[Quote_No==input.Quote_No1]; input.Date_of_Issue1=temp.Date_of_Issue; input.Acceptance_Date1=temp.Acceptance_Date; } quote info is the
Chart based on record entered by UserID
Is it possible to have a chart that only shows information that was entered by the current userid? Actually I'm looking for something more complex. The application has multiple stores. Each store manager has a Zoho Login ID. I would like a function that checks the userid against the store file and and gets the store ID for that user. It then displays a chart of the activity for that store ID. Is this possible?
On User Input error, evaluating STRING
I have a subform that has on user input coding that is supposed to auto fill the a majority of the form. When I use the form on its on it works perfectly. When I use it through the main form the sub-form gives this error. I understand where the error is occurring I'm just not sure what is wrong with it. Especially when it works find on the main page.
Sharing of a subform
I am using the new style subform which does not require a separate form. One of the fields in the subform is a file upload field. On the view of the form I show some fields from the subform as a hyperlink. When the user clicks a window pops up showing all the fields from the subform including the file upload field. When clicking on the upload field they are asked for a zoho login ID as if they do not have access rights to the field. Since there is no separate form how do I change the rights for the
New App Builder: discussion/feedback?
I haven't used Zoho Creator in the last 2 months. I have recently found the "New App Builder". How are people finding it? What are the pros/cons? I'm used to the old builder and don't want to switch to the new app builder if there are problems/bugs.
input field in Mail Sujbect...
Hi Zoho Team, It seems like many things working on old UI now are working different or not working as expected in the new dev app builder. For example I'm using a mail subject string + an inpunt field and Zoho shows when email arrive the following: Solicitud de Dia por Examen del Empleado:282109000002355476 The number 282109000002355476 should be displayed as the Consultant Name. Code used was: Solicitud de Dia por Examen del Empleado: + input.name Can you tell me why this is happening?. Thanks
Need method to show relationship between different records in the same form.
I have a contacts form with multiple subforms with in it. I need to show that any one record could be related to several other records in the same form ( One to many relationship between multiple records in the same table) The method I attempted was to create a relationships table with a lookup pointing to the contacts form. I then placed this relationship form as a subform in the contacts table. The view displays properly and seems to work however the contacts form crashes with the unable to
What's Going on?
All admin names are now numbers Example: creator.zoho.com/824604 I'd report this in the bug tracker, but I'm no longer granted access
Republish Application doesn't seem to work properly
Hi, I'm working on an app in my account and have regularly been 'republishing' it to my client's account. The problem is, it doesn't seem to republish correctly. I will supply the application details in an email. I thought I'd post on the forum to see if anyone else has the same experience. cheers, Jeremy
Google Apps User field select list displays no users
1.Creating a new creator app/form. 2. Drag Gapp fields to form and select user name and another with ID 3. Run application, no users or ids show in the select list? Looks like creator can not get to the google users? Is there something i missed in the configuration?
Stateless forms single table
I have a form I am creating and it no longer let's me add fields as I think I have reached the limit. My thought then was to create two stateless forms that update a single table upon submission. How do I link two stateless forms to a single table and submit the data? I've also noticed that my stateless form is continuing to allow me to add fields past the limit on the regular form. Should I use a single stateless form and then have it update to a single table? Any help would be greatly appreciated.
Show which columns are being sorted.
Using a View in Creator, you cannot tell which column(s) are being sorted. Add small (maybe colored), up/down arrows above the field name to indicate: That it is sorted Which direction it is sorted What level in the sort order (add more arrows horizontally to indicate the sort level) And add a 'Clear All Sort Fields' button, just like you can clear all search filters.
Could anyone please help?
Hello there, After spending several hours reading the forums and checking with other developers I still can't find a solution to the following problem: seems there is no way to see a scale on the axis of a radar/web plot. See example below: The data is there, the categories are there but there is not scale on any of the axis, and as you could imagine, a graph without a scale is basically useless. I have posted the same question/request in other ZOHO subforums without any response and I really
URGENT! auto-fill a field from one app to another
hi there is one account with 2 apps inside app1 - orders from clients, app2 - contacts who make work on sold order in app2: each contact entry has 1) id like "eurorem6701" 2) email id 3) sms id in app1: each order entry has same fields (that fields need to be filled in time of assigning order to contact) assigning order to contact is via selecting contacts's id in dropdown list (in app1) how can i tune app1 & app2 together so that: dropdown list in app1 take list of contact's id from app2 when
Error with Drop Down selections - form fails to write to Database
Hi, We have an error occurring that is to do with drop down selections in forms. 48 hours ago we believe someone in zoho changed some generic settings on the forms. When "Allow Other Options" is now selected for a drop-down the form fails and does not allow the data to be written back to the database. We know it is to do with the the "Allow Other Options" as without this ticked the drop-downs work. It is occurring across all of our applications so we believe it is system wide and is not something
Next Page