trim spaces without ending up in a loop?
If a user enters a space at the beginning or end of the field, I need this space removed. .trim() will do this, but.... the script input.value = input.value.trim(); creates a never ending loop. is there any way to get this done? Zoho creator doesn't treat a space like a regular character (eg: Creator ignores spaces), so all the tricks I could think of so far fail, like if (original_value != trimmed_value) {input.form = input.form.trim();} //doesn't work :( or if (value.beginsWith(" ") {} //doesn't
changing spacing between fields
Is this feature available with Zoho Creator? Is so where? If not is there a workaround? If not, is this feature being worked on? Thank you...Allen S
How do I push data from a Creator form to my CRM?
I have a number of enquiry forms on my site and I want them to automatically create a lead within my Zoho CRM. I have been reading through all related posts and can't come up with any answers to this question; is it even possible? I am new to this system so please forgive me if it is a silly question and if possible keep answers simple, I am hoping not to need a translator! Jade:-)
Add new record by clicking the name of record
Hi...i am a new user to Zoho:) I am poor at coding but have some experience with ms access.Ok, i want to ask whether it is posibble to add new record by clicking the name of the record. Let say i have to table Form A: List of services (To show all services of my organization) Form B: Related to the services but it a rating form to the selected service So i make a report base on Form B but showing only item in Form A,List of services so that user can add record to Form B,rating the selected service.Is
About zoho create "Customers"
"Customers: The persons who can access the information on the Customer Portal. They are usually your customers, vendors or re-sellers." I try to create 2 agent manage applications on zoho create, 1 have 8 users, and the other have 10 users, then have more then 120 agents(re-sellers) will use the system. So, if i register as a Enterprise plan, shall be 8+10 x 15 dollars for every month, but what about the 120 agents? shall pay as user or they are just customers? if they are customers can access the
subform row deletion - prompt for confirmation
Is there a way to prompt users to confirm deletion of a subform row/record within a master form? For example, a pop-up message such as "are you sure you want to delete this record?" with options to continue or cancel. I'm assuming such a thing would go in the On Delete Row section for the subform in the master, but can't sort out if it's even supported, or how to code it.
Pivot Chart Custom Formula
I'm trying to create a chart using the difference between two dates in the record. The attached screen shot is the error I get. Where is this "Custom Formula" option?
return records between two dates
I would like to add another criteria for the records. I would like for it to return all of the records based on the following criteria and add another criteria. I would like for it to return the records between the following input dates. input.Week_Start_Date and input.Week_Through_Date basically I want to see how many hours an employee has worked for a particular client during a time period I select. this is what I have...... rec = Employee_Time[Name == input.Employee_Name && Company_Name ==
Select some values from multiselect lookup
Dear All, I have a multiselect lookup which includes some values. What deluge code should I write to select only 3 values? I mean, to limit the selection only to 3 values. If I try to select a 4th one, then I do not want to accept it.
Send Mail to Added User NOT Modified User
Hello, So, I'm trying to write a short script where users adding data into our forms can receive an email if it was approved by the administrator. This is what I have, if ( input.Approved ) { SendMail [ From : zoho.adminuserid To : zoho.loginuserid Cc : Bcc : Reply to: Subject : Description + " has been approved!" Message : "Your message" Language: English Content type: HTML Trim tags: true Attachments: ] } The problem with this code is who I'm sending
What type of images file types are supported in ZOHO?
What type of images file types are supported in ZOHO?
Backups won't Restore
I get the following when i try to restore any backups com.zoho.workengine.parser.exception.PopulateException: Error at line number : 2560 Number of arguments mismatches
Developer access when report is filtered on zoho.loginuserid
I'm sure this is obvious, but I'm not thinking straight. I have a report that is filtered based on: email contains zoho.loginuserid, and that's great for the user. How do I set the filter criteria for a report so it is filtered on email contains zoho.loginuserid OR user is a developer????
Is it possible to auto populate existing records with new information?
Our Creator database consists of a main form with several sub forms linked. We use the main form to collect demographics and the sub forms to collect specific information about the product purchased. We would like to be able to pull reports that include information from the main form and a sub form. I believe the easiest method would be to add the demographic information to the sub forms (I have worked out the code to auto populate this information moving forward) but I do not want to have to go
How do I only allow the record owner and his/her superior can view the record on the Travel Expense application?
Hello! I am having trouble figuring out how to allow employees only to view their own expenses and no the entire company, (every person who as entered expenses), into the Travel Expense application provided by Zoho Creator. I don't want them to see the expense of others, just their own! Is there any way to make this happen? I tried using Users & Permissions, but I couldn't figure out how to make it private in this way. Any help would be appreciated! Thank you!
Aggregate Records Average Function Issue
When I use the aggregate records average function the result looks to be inaccurate. Exporting the report to Excel or Google Sheets and averaging the column returns a different result than Zoho did using the aggregate records average function and displaying the results in a html page. I believe it might have to do with blank fields within Zoho's averaging range that might not be ignored. So what can be done to fix this or increase the accuracy of the returned results? Additionally is there anyway
Subform Bug- Adding New Entries in a Lookup Field
Hello, I need assistance with a problem relating to the subform. When I add a lookup field in the subform while checking the choice to "Allow new entries," I have to refresh the page whenever I add new entries into the database for it to show up in the list. The problem only occurs in a subform, but not if you do it in the actual form. This would not be user-friendly for our suppliers, as a result. Any assistance would be greatly appreciated. Regards, Mohammed Alhaj
send email to Group (as defined under USer Management, not as a form in a creator application)
what is the script for referring to a Group if I want to send an email to that group on a field-update action. the group is not a list of emails in a table in the application. The Group is defined under "User Management" I know zoho.adminuserid refers to "me". but if the group name is "Cost_Change". then what is the deluge script to find this? thanks
Calculated date field causing error that disappears when field is hidden
I have a field "Art Due Date" that is calculating a date for 5 days before another date in the form. It's been workin for 2 years and then last week every time someone tried to edit a record using the form with this calculated field they would get this error "Invalid Field Found Field Name : Art Due Date" and would be unable to save the record. I changed the setting on the field properties by unchecking the "Make the field visible in the Form" and I was able to successfully save/revise records.
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.
Next Page