Filter Lookup By Another Date Field
I followed the instructions listed on this post but still receving an error when I post the below code on input for date field https://help.zoho.com/portal/en/community/topic/picklist-criteria My code: z = Log_Shipping_Document [Arrival_Date== input.Arrival_Date]; Shipping_Document:ui.add(z.Shipping_Document_Number.getall());
Left pane side tabs opening in expanded display. Would like to open them collapsed. anyone know if this can be done?
Hi, I'm using the Left pane side tabs, they always open in expanded mode. I don't see anywhere to have them open "collapsed". When the app opens I'd like to have them all collapsed. Is there a way to do it by adding some code? or is there a setting I'm missing somewhere?
Import Failed - unexpected Expected error
Hello, Yesterday when I first tried to import from an excel file into a Creator database I had some errors related to allowable field length. A number of records were however, imported successfully. I have fixed the maximum allowable field lengths now on the form and have tried to import from excel again. After mapping the fields correctly and clicking Import Data - it comes up with the error "Import failed - unexpected error, Please contact support@zohocreator.com". I did contact support but have
Conditional formating
This would be cool: Like feature of for instance PowerPoint, the ability to have fields or whole rows have a certain formating depending on the value of certain fields. So, for instance, have rows be printed bold if a field "priority" is set to 1. Or things like that. I think that the option to make a row/field bold and/or have a darker background would be sufficient. Maybe have a choice of some colors.
Getting data from user.
In a function, how do I prompt the user for and collect data such as an exchange rate?
Published Search Query - Failing to Load
I have this simple application (ds file attached) whereby I have a form (titled "Search") that acts as a basic search query with one field, "Name", in order to direct me to data in a report (titled "Form A View"). My search query works fine when I use it in the admin panel -- if I search for data it properly brings me to my report. However, when I go to the published/public version of my search query, the report always fails to load any data -- it just says "Please wait..." for upwards of 20 minutes,
Re-inviting a user to Creator and to use my app
Hi There, I have a number of users using one of my applications in Zoho Creator, I have recently added another user, who didn't get the initial email. We de-activated that user account and then added her again as a new user but now when she tries to click the link it says there is no match for that email address but I can clearly see the user and her email address in the "Manage Users" section of Setup. Is there a way to re-send the original invite ? Appreciate any guidance. Kind Regards Matt
request to type the date
I have had several requests for the user to be able to type the date in a certain format ex. DD/MM/YR instead of having to select it from the calendar. is this possible?
help with date
Hi Simple request I think This_is_the_Date_field 25/6/2014 What_is_the_Month 6 What code do I use to return the month only in my second field Thanks
How do I customize the Zoho URL to myDomain URL?
Appreciate your help. I am in the Standard Plan. How do I customize the Zoho generated URLs to a myDomain URL? Some of our application users are put off by the long Zoho URL when they are submitting their personal information. They have a trust issue because of the long Zoho URL. How can we sort this out?
Validate multiple fields.
Hi, Is it possible to validate multiple fields in a form to make sure that data is unique? I want to count the records and if fields StarDate & Location & Employee are already present in that certain combination, Cancel form submission. Iif(count(WorkSched[StartDate=input.StartDate&Location=input.location & Employee_Name == input.Employee_Name]) > 0) { alert (("StartDate, Location and Employee_name already exists")); cancel submit; } Thank you.
BIGINT / STRING error when trying to fetch data from another form
I have a situation where I need to populate a text field (Assign_To_Email) with data based on a selection made in a dropdown (Assign_To). These are both in a form called Support_Tracking. The values in the Assign_To dropdown in Support_Tracking correspond to values in another dropdown also called Assign_To, but this one is in a form called Names_and_Emails that includes one other field, Assign_To_Email (a single line text field). When someone selects a value in the Assign_To field in Support_Tracking,
Report - Averages Not Working
Hi, I have a table with multiple dates and a value of 0+ for each date. Some dates have 0. I created a report and if I use Sum, everything works great. Most days are in excess of 100. However, if I change to average, the value in the report is always < 5. At first, I thought it might be related to many dates having 0. I created a filter and said all values of 0.01 + and that still didn't work. In fact, I tried to even say only average values of 25 - 50 and the report still displayed ~5. Any
Count Records Issue
Have an issue using the Aggregate Records Count function and displaying the results in a HTML page. Zoho's example seems simple enough. Or I'm just missing the mechanism that displays aggregate record count? Zoho Example: //to count all records in a form input.Total = FormA.count(); I have tried: input.Quote_Number1 = RFQ.count(); Quote_Number1 = RFQ.count(); NOTE: Quote_Number1 is a Autonumber field Nothing is displayed in my html page. Any ideas?
How to validate a decimal field
This may be a dumb question. I have 2 decimal fields and a formula field. If you enter a , in the decimal field the formula field displays null. On the input script how can I validate the input as a decimal field (i.e. stop people entering anything but numbers?) Thanks for your help in advance.
Creator API - access View data
I am brand new to Zoho Creator and am trying to create and access a View on an existing application developed by others that can be accessed via the Zoho Creator API. The view is named: myob_student_record I am submitting the GET request in the form: https://creator.zoho.com/api/xml/ownername/view/myob_student_record?scope=creatorapi&authtoken=xxxxxxxxxxx In the "general settings" area of Zoho Creator are two fields: Application Name and Application Link. In our case the application name is "Record
Receiving a message that reads: Failed to submit data, please contact application owner
what does this mean? how do i fix it? their call support is only open monday thru friday which is ridiculous considering most businesses operate 7 days a week.
openurl criteria to related table
I am using an openurl to filter a view. It works fine if the criteria is on a field that is part of the form that the view is based on but I can't get it to work if the criteria is for a field in a related table. Is there something special I need to do to search records based on the value in a related table? Herb Wexler
Zoho Creator only validates numeric fields on submit. How to validate numeric field on user input not validate!!!
Zoho Creator only validates numeric fields on submit. I have a series of numeric fields which a script calculates on user input to display the total in another field. A user can enter non numeric information into a numeric field and the on user input calc displays an error on the screen. How can you validate if the input into the numeric field is numeric before doing the calculation? Thanks.....
creating a temp form based on field variable, then insert all records in the temp form into another form
creating a temp form based on field variable, then insert all records in the temp form into another form i keep getting an error, is my syntax incorrect? rec = SR_Import[Imported != "Yes"]; { for each row in rec {insert into PS_Work_Order_Purchase_Order [ Company_Name = rec.Company PS_Work_Order_Purchase_Order = rec.WO_Number Description = rec.WO_Description AFE = rec.AFE Site_Code_Location = rec.Location_Full Field_Ticket_Signer = rec.Field_Ticket //= rec.PS_Contact Attention_to_on_Invoice
Sign in Issues
I get onto Zoho Creator from my home PC, office PC, and my Ipad. I also can get on through my iphone through Safari without any problems. But I tried downloading the app for my iphone and though I am signed in, it says i "don't have permission to access. Please contact Zoho support." I am the owner of the app and the administrator and I find it frustrating that I can't get in. I tried calling support but never got a response. Thanks. Paul M.
Trouble calculating the number of days between two dates.
I have a last service field in a customer form. Using a formula field I'm calculating zoho.currentdate minus the last service date. (This is a date field) / 1000 * 60 * 60 * 24 The result gives me 169.95833334. I've changed it to a decimal field with a decimal length of zero (0). and get the same result. 169.95833334. If I change the field to a number (no decimals) I get an error telling me the zoho.currentdate is a bigint and and Last Service date is a date field. All I want to do is have a result
List Only Contacts relative to Customer
We have two forms, say Form A and Form B. In form A we collect basic info Account Name Contact Title Email. We also have 6 other fields for Contact2 Title2 Email2 and Contact3 Title3 Email3. Over in Form B the first field is Customer (same as Account Name in form A). What I hope to accomplish in a lookup field is once we select the Customer that in the next lookup field only the Contacts (Contact, Contact2,Contact3 ) relative to the Account Name will show and then once we select a contact their
Form filtered by zoho.loginuserid
I know that I can have a report in a section, and the report can be filtered to only show rows where an email in the report matches the zoho.loginuserid. If the relevant data is a person's profile, theoretically there would only be 1 row per user for their profile settings. So they don't really need to see a list .... Is there a way to include a form in a section, so that the form is filtered based on zoho.loginuserid? Or, is the 'solution' to use a Summary report, rather than a List report?
Script Error
The following fails to compile: fetchedNotices = Notices [Violation_ID == input.ID]; input.Resolution = (fetchedNotices.count()).toString(); Error at line number : 20 Form 'fetchedNotices' does not exist in this application If I remove the parentheses that were added by the system and use: input.Resolution = fetchedNotices.count().toString(); it works just fine. Bruce "Speedy G" Peaslee The World's Fastest Programmer
show records based on login
Our application contains records for several hundred customers. Each customer has an account manager assigned to them. (This is a one-to-many relationship, in which each customer will only have one account manager, but each account manager will have many customers.) Account managers should only be able to view/edit their own customers' records when they log in to the application. In the past, we have managed this by creating a separate view for each account manager, with a filter so that only the
Calendar Item Display to 25 Characters?
Hi Support, Is there a way to adjust the display of the items in calendar view to 25 characters length instead of 15? Please advise. Thanks, Egressmedia
Vertical list report
Hello, Can I create a vertical report but not as a pivot table but as a regular list? How could I achieved this? Thanks!!
default to current date
Is there a way to make date fields in a form or subform default to the current date (with the option to select a different date, of course)?
Slow access in China
I have a collaboration tool developed in Zoho Creator. People in the US/Canada and China are accessing it. People in Zhejiang, China, today told me that the access is very very slow, unbearable so they can't do their job. Is there a way we can go around this? The same people in the same location used to access Zoho Creator with decent speed. Thanks.
Can not copy Url and Image field contents to a Stateless Form
@ZOHO Creator Team: I have a Sateless Form ... in its on Add on Load section I have commands like ... thisClientProfile = Client_Profile [Client_ID == input.Client_ID]; input.Business_Name = thisClientProfile.Business_Name; input.Client_Email_Address = thisClientProfile.Client_Email_Address; ... and ... input.Website = thisClientProfile.Website; input.Business_Photo_1 = thisClientProfile.Business_Photo_1; ... etc. etc. ... When I render this
Multiple Fields in One Look up Field
In form A we have a field for Contact Name and Contact Email. Also in form A (in case the customer has more than one contact person) we have fields for Contact2, Email2, Contact3, and Email3. In form B, we have a look up field that pulls from the Contact Name field only and than auto populates that persons email in from B. Is it possible that the look up field in form B could also pull the data into it from Contact2 or Contact3 if data is present there and also populate the email field? Cheers!
setting column sizes in subforms and reports
I'm trying to limit the width of columns that appear in list view reports and subforms. The default width is often much larger than the field name or any data contained in the field, and it makes for a lot of undesirable scrolling just to read or enter data. For the reports, I've tried going to column properties and setting the width for each column there, but it doesn't work. For the subforms, I have no idea how to go about doing this--and I really need to limit the amount of scrolling across the
Custom choice for checkbox field
Hello there, I'm new to Zoho Creator so I'm sorry if my question sounds silly... Is it possible for a checkbox field to add user defined choices, in addition to pre-set choices? Like in: 1. Choice 1 2. Choice 2 3. Choice 3 4. Choice 4 - Example (specify): ................... 5. Other (specify): .............. Thank you in advance for your reply! Igino
HELP!!! filter lookup in subform android app
Hello. I'm having an issue using the set filter option. I have a lookup list filtered based on input from another lookup list on a subform. Works perfectly on the desktop but does not work on the android moblie app. The lookup doesn't populate the list. Anyone have any ideas? Thanks
Related List App and Prefilling Field
Hey All, I've been working on creating a Zoho Creator app that acts as a related list within Zoho CRM. Until recently we had trouble getting it added, but thanks to support, it's not linked up in Zoho CRM, and showing the records we want to show. That said, there is one minor usability quirk that I'm wondering if anyone know's how to work around. The "Add" form is "keyed" on the record we're looking at. (In this specific example, when we add a record to our custom app, it's keyed on the potential
Create, Embed, and Auto Fill a Form
Hello all, I am very new to Zoho Creator and am having some difficulties. I am trying to create a form so I can embed it and then autofill that form in correspondence with another form. I need help figuring out how to: 1. Successfully create the form (I'm trying to import it but it's not working, does it need to be a certain format?) 2. Code correctly so the form I create and embed will autofill in correspondence to another form that already exists Any and all help is greatly appreciated! Thank you
How to validate multiple fields within a form?
I have a form that has the fields "Name" "Email" "Mobile Number" and "Office Number". I wanted to validate that when they entered a Mobile Number they were entering 10 digits with no dashes so I coded this: Mobile_NumberFormat = input.Mobile_Number.toString().replaceAll("([0-9]{10})","correct"); if (Mobile_NumberFormat != "correct") { alert "Mobile Number Should Be 10 Digits, No Dashes"; cancel submit; } I want to do the same thing with the "Office Number", but I don't know how to say if
A few problems
Hello guys, I am new to zoho creator and I was wondering if it would be possible to allow a customer to enter their details via a zoho CRM lookup and make it fill in the rest of the form from this, for instance their Sales Orders, Purchase Orders etc. Thanks in advance for reading through and responding to this topic.
Autopopulate a field based on 'New' action
Hello, I have created a custom module that has a mandatory name field. I need to autopopulate this field with a default value 'BST' whenever the user clicks 'New' to create a new record. The user does not have to enter a value in the name field. It should autopopulate. Please help. Thanks, Imran
Next Page