Lookup Sort Order with Hidden Field
I have a multi-select lookup list called "Categories". Within Categories, I have two fields - a "Category" (string) field, and a "Sort Number" (decimal) field. The purpose of the Sort Number field is to manually allow the user/admin to re-arrange the Categories on display/print. I would like to display the Category field of Categories as a multi-select, checkboxes lookup in the order of the Sort Number for each Category, but I do not want to display the Sort Number. How do I do that?
Hidden fields show as "null" on confirmation email
Is there an option to either: 1. suppress hidden fields from showing in confirmation emails or 2. show hidden fields with their value, instead of a value = "null" Currently, hidden fields are showing in User Submitted Data as follows: User submitted data Name : Ellen McGilliv Email : ellenmcgilliv@comcast.net Town : Westwood State : MA Phone : 7817628568 Comment : test thursday 10:07 PM Record created : null Record last edited : null
Report with max Date
I have a form Assign Resource, the resources are people for example programmers. A programmer can be assign to multiple projects, so the name is duplicate in the Report. I need to select the row o registry for each Resource with the last date that he will assign. For example: Resource Date Juan Perez 3/2/2014 Pedro Diaz 5/5/2014 Juan Perez 6/7/2014 Mery Combes 10/10/2014 Mery Combes 3/9/2014 When I create the Report my result should be:
job scheduling app
Hi, I'm new and have a few questions. We are a monastery. We get volunteers that come in and offer to serve doing a particular recurring job. The job stays the same the volunteers are ... volunteers, constant turn over. I want to assign volunteers to a task/job for a specific day or for a number of recurring days. I have looked at People app and it seems like overkill for our needs...that plus we would have more than 10 'employees' so that puts us into the $40/mo plan. The volunteers will not have
Missing Column on "Click to See Data" from Pivot Chart
When I click on the bar of a chart to see the underlying data, one of the columns is missing. What determines which columns are visible or are all columns supposed to be shown?
Import Files
I am using a stateless form to move data from one form to another. I want it to create a new record in the first form from existing records in the second form that don't already exist in the first form. The share a common field. I know I am missing something here.
Field Update
How do I tell a field which references another field that the original field has changed and then to reflect those changes ? ie. Field A is a sub-total value Field B points to Field A to show the same value but further down in my form. When Field A is updated , how do I tell Field B to reflect those changes ? Or If Field C uses Field A's value in a calculation. When I change Field A, Field C's value doesn't update based on the change done to Field A. ie Field C = Field A + 99 If Field A = 1, Field
need help apply form problem?
i made a apply form for my website but the other user that is trying to apply, they see a sign in and password to get in zoho but not my apply form....how can i make them see my apply form without them signing in ? please help
i need to view a file or image in a stateless form that was uploaded to a regular form
I am trying to view an image or pdf file that I have loaded into a different form in a stateless form. example: I load a doc or image into Form1 but I want to fetch it and view it in StatelessForm1 How do I do this?
Help with code to view an image in a stateless form
I've read the reply by Gregg and Herb, but still can't get the code to work. <field type> Note: Here is how it's adapted from an user input. <Description> <on user input> Parts = Master_Inventory [ID = input.Description]; if (Parts.Image.contains("/image/")) { alert(Parts); Image_filename = Parts.Image.getSuffix("image/").getPrefix("border").replaceAll("\"","").trim(); Image_link = "https://creator.zoho.com/zoho_alan18/atelier/Manage_My_Inventory_Add/" + input.Description + "/image/image-download/"
"insert into" code not working
Yesterday, I set up a form so that when a subform row is deleted, its contents are automatically archived in another form. It works great. Today, I attempted to do the exact same thing for another subform, using the exact same syntax (only changing the form and field names) and IT DOESN'T WORK. This is driving me nuts. Any thoughts on what's going on here? The code below is in the On Delete Row section for the subform. insert into Deleted_Training_Records [ Training_Record_Number = row.Training_Record_Number
Number format
Hi, I need check if people insert in correct format a number in text field: 123.456.789-00. With the below script ON INPUT of the FIELD I do it with success. I also need to check that people insert 11 characters not less (up to 14), because with this wrong behaviour script return an error. Any suggestion? Thanks Mic if (input.FIELD != "") { FIELDFormat = (input.FIELD).replaceAll("^[0-9]{3}.[0-9]{3}.[0-9]{3}-[0-9]{2}","correct"); tFIELD = (((((((input.FIELD ).subString(0,3)) + ".") + (input.FIELD ).subString(3,6))
Form automation
Hello, I've heard it's now possible to disable the red "X" on subform rows. I'd like to do it for all users except admin based on login user. Can someone give me an example of script and instructions where to place the script? Can't seem to find the form automation tool. Thanks
Matching notes font size and style to form
Hello, Can I match font size of notes to other from elements. I cannot make note text look the same as a title of the filed. So form looks incositent, any help please. Thank you see image attached: as you can see 1. 2. looks different from the rest
Failed to submit data. Please contact application owner.
what about this error " Failed to submit data. Please contact application owner " it appear to me when i try to save my data please anyone feed me back
Cant duplicate my application
When I select Duplicate, It does not seem to be working.
How to configure report to show empty fields as empty spaces?
When I create a report and I have an empty field, this field appears in the report as "-No Value-", as you can see in the picture below: How can I make to the report show nothing (just an empty space) in this field? Thanks
Reporting with a Date Range
Hello all, I am attempting to create a Report or Form that will perform a simple task. I already created a form for reporting Incidents and have input data into this. I would like to create some type of report or Form that pulls from that data and run a simple calculation. I would like the form to pull all Incidents in a date range and count them. Take that amount an divide it by a user input number. Output that answer into a text box or something on the same page. Number of Incidents in Date
Functions for faster accessing to application items
Hello I have applications with a great number of forms, reports, pages and so on (for example, in one app: 83 forms & 535 reports, 111 HTML pages, 715 deluge functions in workflow tab) I want to fast acces to: last modified elements (Forms, Reports, HTML-pages) - actually - very often it's hard to remember the name of report, you have worked on 3 days ago or name of the test function you use to make some changes in database and so on Please....... 1. add SORT BY LAST CHANGES link which will show
Use one box on another form.
First of all, I hope you understand me, because I'm from mexico and my English is very limited. I am trying to send emails through automated 3 different forms -Clientes -Ordenes - Articulos The form "Clientes" contains a box with an email and it's easy to create an automatic email., But "Orders" and "Articles" contains "Email" and would spend much time repeating 3 times the box. I wonder if Link "Email" with the other 2 forms possible. This is what I try,but I have an error: void sendnotification(Clientes1
Formula field strips off trailing (zero) 0
I have an inventory form. There are two fields one is the (Item Cost), the other is the (Pack Quantity) If I have an item cost of 19.50 and the Pack Quantity is (1) and you divide the Item cost / Pack Quantity ie: ( 19.50 / 1) the result in the formula field is 19.5. Is there a way to always round to 2 decimal places and show a trailing zero (0)? hence 19.50.
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.....
Next Page