Two column layout
Hi All, I would like to have two dropdown lists on the same line, ie hours and minutes. I have never tried the two column layout before but if I select this option and add a field, the system places it right at the top of the form in the second column and not next to the field required. What am I not understanding here please? Many thanks
target="_blank" issue
Hi Folks, There appears to be a problem in Add Notes. To allow a user to get the geographical coordinates of a location, in my application I have a Note field that contains a Google Maps image and the following code: <a href="https://maps.google.co.nz/?ll=-41.343825,174.089355&spn=14.262413,33.815918&t=m&z=6" target="_blank"><img src="http://www.precisionhelicopters.com/images/site/googlemaps1.png"></a> Until recently, a click on the image nicely opened Google Maps in another browser tab, but now
Unable to Customize Embedded Forms
I have a set of forms which are colour coded for specific teams to complete. I have therefore been trying to format the Header & Footer BG colour setting. I have tried this several times with different forms, but the setting is not saving on the form. When I got back into the form, the settings have reset back to defaults. I cannot see any way of saving these changes.
does zoho creator compatible with visual basic?
because now i'm build a system that need to connect with online database...hope anyone can answer me :) Thank you
Clearing Picklist Record On Load
I would like to clear a static picklist record on load. I want the record to be lose whatever it had before and have no selections. This seems simple, but I have not come across a solution that works thus far.
Check box automatic populating issue
Hello I have a check box in the first and second view of my database. With existing records if I uncheck the box in the first view it does not reflect in the second view. Please can you advise what deluge script I should use? I’ve used a “ input.Commercial = main.Commercial; ” script which works with new records, but if I uncheck the box in the new record in the first view it still does not reflect in the second view. This is also the same with date fields. Thank you very much.
Issues today
Is anyone else having issues with creator today? I have functions that were working this morning, that no longer work. I am having issues with reports pulling up and running after I have created them, and shared users can't pull up new reports. I have one user that can't access any pivot table reports, lists are okay (this is about two weeks old at this point).
Two small animated semi-circular arrows appear after updating a field by script. ??
If I check user input (On User input), format it, and then write the formatted data back to the same field, two small animated semi-circular arrows appear to the right of the field and the field contents persist into the next record. I can't find any reference to this in the documentation. Can anyone help/explain?
URL view criteria involving lookup fields
I have a view that contains a lookup. The lookup refers to an ID in another table(form). I'm trying to open the view with criteria which only displays records where the lookup has a certain value (an ID): E.g. openUrl("...#View:MyView?MyLookupField=1234567890); The functionality based url criteria seem to work fine for non-lookup fields. Can anyone confirm if this works at all with lookup fields? If so, what is the trick to work. Thank you
How to delete applications?
I've create two dummy apps in my account for evaluation purposes. Now I've got paid subscription and I'd like to delete those 2 apps and create a fresh customer facing app from scratch. How do I delete the exiting apps in my account? Thanks, Vijaya
Indentation
There has been some discussion in this forum about the editor/compiler and indentation. Some people don't like automatic indentation. My suggestion is this: whatever automatic or non-automatic indentation is provided, please at least leave my indentation alone! Yesterday I spent something over an hour going through a long script adding comments and indenting sections of it to make it more readable, just like any good code does. I saved it, but then when I came back to it all my careful indentation
Yet another question about dynamic lookups
I have two tables/forms: Franchises and MasterFranchises. Each has a field named Franchise_Name. The forms are identical except that the Franchise form also has a field for MasterFranchise. All franchises are "owned" by a master franchise. In some other forms, I have a Franchise field that looks up franchises in the Franchises table. So far so good. But in some forms, I would like to have a Franchise field whose picklist is a combination of both franchises and master franchises. Is there
Account address to post in contacts
Can you develop a quick and easy way for Account address info to copy or be posted to contacts, it is time consuming to have to enter that info more than once?
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?
Next Page