Phone validation script
Hello, I am using the following validation script to change some phone numbers that are being sent to one of my forms. if (!input.Phone_Number.matches("[0-9]{10}")) { alert "Enter the numbers only (Example : 1234567890)"; cancel submit; } else { input.Phone_Number = (((("(" + input.Phone_Number.subString(0,3)) + ") ") + input.Phone_Number.subString(3,6)) + "-") + input.Phone_Number.subString(6); } While it works when the phone number comes in as all numbers (i.e., 5557771212), I also
Customer Portal quetions
I'm investigating for use by an organization where I volunteer: I'm assuming I can parse data by customer so that multiple customers using the customer portal can't access each other's information. Correct? Can the survey feature be used within the customer portal? Meaning that surveys are presented, responses are captured, results are displayed all within the customer portal. Is the customer portal branded with my company name/logo, or zoho? Can I use my own domain for the customer portal? Thanks
Update Multiple Lookup Fields
Hi. I have fields which are lookup fields which are numerous and need to be updated with the same data. However, the condition fields are also lookup fields. Is there an easy way to do this? the script would be if(lookup field1 == "text1", update all lookup field2 with "text2") Thanks
Security of data?
what safeguards does Creator have for the security of the information
On User Input - Submit Form
Is it possible to submit a form on user input? We're incorporating bar code scanning with Creator and having to manually click submit slows down the process. We want scan, then scan, then automatically submit if both values are not null.
How to delete unconfirmed users
I shared my application with another user, but I made a mistake and I inserted the wrong email address so she didn't receive the invitation. So I reinvited her using the right email address and everything worked fine, but now I have the old email address between the unconfirmed users and I would like to delete it. Is it possible and how? Thanks, Michele
How to print message based on radio button selection in html page
i have a problem, when User select "No" in Contact Form, i need to print following message in html page to print pdf. "Please dont contact Customer" How to write code for this condition in html page?
Calculated Field Look Up
I have a table of 120,000 fixed records that are used in a formula based field. The record relevant to the user is filtered through a series of dropdowns on a local database application. Field 1 Choose A and this then gives you Field 2 with Choices of A1, B1, and Choose A1 and Field 3 gives you a choice of A2, B2 etc. When you finally identify your record from the drop downs i.e. record A-A1-A2 the tool then produces a calculation using the number fields attached to the A-A1-A2 record and
Pivot Table of records created by users
A pivot tablel showing activity by user is my goal. When creating a pivot table in Zoho Creator, the Added User field is not available. Is there some way to create a pivot table showing each user and how many records with a certain attribute they have created? Thanks for any help. Jim
List - remove element
Hi, I've troubles in filtering a list with a condition : for each item in list(condition ex. var1=>Var2 ) { list.removeelement(item); } Field:ui.add(list); Creator return that is "Not able to find 'list' function" . I ask if possible or I have to achieve the solution in another way. Thanks&Greetings Mike
Problems with Sharing / Google APPS Usage issue
After going through and setting up the sharing in the Creator application on the desired database that I would like to share, I continue to receive a permissions error. I have triple checked the settings and seem to be not having any luck. This is the error I receive. You have logged in as user@xxxxxxxx.org. You are not allowed to access this application. Please click here to login as a different user. Click here to go to your Home Page. Any help would be appreciated. Jon
How do you set the Home or default page for users?
I want users to see a company Dashboard when they log in. How do you make a default landing page in an application. When my app starts I see a form to add some data... I want it to default to a certain view called Dashboard
Cannot duplicate application
When we try to duplicate the application we have called Ci Production 3.1, it says "Duplicating" for about 10-15 seconds and then the screen flashes, but the application is not duplicated. Please help.
Maximum number of forms per app?
Is there a maximum number of forms per App? I was unable to find this information in the user documentation.
How to line fields horizontally.
Considering there's currently an option to have double columns in a form, do you guys support multiple columns? I am trying to build a form to mimic the layout of the spreadsheet we currently use, so the request quantities are inputted into fields named by the Week Number. I've tried using a SubForm to manipulate the field layout to line up horizontally, but the data then isn't stored properly. If there's no way to create multiple columns in forms, do you guys have any suggested workarounds?
Locked out of Creator account
I signed up to creator and paid the money. I was issued with a receipt conforming I had paid. My bank account was debited. I created my first important application and all worked well for two weeks. I was still in the process of developing it. Recently I transferred my email hosting to ZOHO as well. I set up a few email addresses which work great. Now I can't get in to my Creator account. Is this related to setting up email?
Drop Down Picklist Issue
Good day I got some problems creating an automatically filled picklist, when I try to Save the Script I got the following message "Error modifying the page" Null I have this code must have Equipo ( displayname = "Equipo" type = picklist values = Products.ID displayformat = [ Products ] allow new entries = true [ displayname = "" ] searchable = true width = 206px )
Delete Records
Hi. I wish to delete records if a field contains a certain character. "contains" isn't allowed in the script builder. Sorry I'm new. Learnt Excel over many years, now switching to Creator. Also, I need a place to learn how to do all this kind of stuff. Any suggestions.
Calculated date from formula shows up as text in pivot table report
Hi there, I have a formula in a form that displays a date in a list view report that I have created. It displays as a date with no problem there. However, when I try to include the same formula result in a pivot table, it's not showing up as a date but rather as text. What do I need to do to this formula so that I can have it display as a date in both my list report as well as when I am trying to build a pivot table report around it? Thanks.
Some criteria can't be supported when edit records via Creator API
This is my appication url： https://creator.baihui.com/creatorissue/testapp/#View:view I've tried to update record by using Email as criteria. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <form method="POST" action="https://creator.baihui.com/api/creatorissue/json/testapp/form/test/record/update/"> <input type="hidden" name ="authtoken" value="0b9a1897ac10cf66a9e699f688cb6522"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="text" name="criteria"
Question about making data publicly available
I have a report from a private application that is embedded in a Web site. My understanding is that using the permalink feature allows the private view to be shared publicly. Now I want to add a custom action to that report that will allow the viewer to generate a record summary report with one click. Here's the custom action: openUrl("record-summary/Force_Player_Profile_Report/" + input.id, "Same window"); It works when I am logged into Creator. However when I execute it through the embedded
if (First time user input)
Is there a way to only execute a function if a user has not inputted into a field? For example, I have a form with a Start_Time and End_Time. I would like that if "On Edit", the End_Time will be set to now, but only if it has not been previously inputted by a user.
Email Address
I've created a web form that's embedded in our website to enable clients to register support requests. I want to be able to automatically send an email confirmation back to the client for each request. However, at the moment if I send an email automatically, it shows my personal email address, martynhale@vct.uk.net as the sender. I want to be able to use something like support@vct.uk.net. How would I do this? Thanks, Martyn martynhale
My schedule doesn't work
Hi there, I have a problem with my schedules. I tried both custom and form ones, set the right timezone (CET) and they don't seem to be working. Even though the right time, set in "When to do" passes, no activity is reported in Usage Logs neither the e-mail is sent. Can you help me please? Thanks in advance, Stan
IOS linked record searching
Hi, I am using zoho creator on ios devices now, after using it primarily on android before. One thing that I have noticed is that when searching a linked record in a form on ios, the full list is not populated, only the first portion. This is fine for me as the list (typically) loads more results as I scroll down. The problem I have been having is that when swiping up to reveal the search box, the search will only return the results that are already loaded, which kind of makes the search useless.
How to reference Sub-Fields in the URL Field via script ...
Hi: Is there any way I can automatically set the "target" component of a URL field via script ? I am working on an Application where the requirement is to enable the user to enter the URL Address (like www.zoho.com) ... but not be given the option to specify the "target" (Same Window, New Window) ; instead, the "target" should be set to New Window ... so when the same field (column) is clicked in the Form's View, the specified web page is displayed in a New Window. I thought that I would force the
Share Option setting is not available in Another Person's Account
i am using an enterprise edition in creator and i need to get an application via sharing from an another person's creator account and he want to assign some permission for me but he can't able to assign permission for me because the option "users & permissions" option is not available in that account then he too using an enterprise edition plan. is there any way to do it for assign such option ? then i attached that accounts screenshot below.
Creator Can't Handle Several Formula Fields?
Dear Sir/Madam, I tried to create a form with several formula fields, there are 4 formula fields that calculate based on an input value as below. Input field - Duration Formula fields - Production Efficiency - Machine Cost - Labour Cost - Process Cost When I tried to input and update "Duration", I got a refresh icon, and the form just froze there, and I did not get any result from the formula fields which depends on the input value. I have tried it over and over, it still froze after keying "Duration"
Add multiple Records from Stateless Form
Is there a way to add multiple records to one form using a stateless form? For example: Stateless_Form field_1: "Number of Times To Add Record" field _2: "Category" //Is there a script to repeat insert based on the input of field 2 (""Number of Times To Add Record")? insert into form_1 [ Category = input.field_2 ]
How to link to record summary from within a list report?
I have a very simple list report that is embedded within a Web page. The target audience/customer of the information is generally computerphobic and has zero time or interest in exploring menu options, even the ones as well-defined as they are in Creator. What I need them to see is a simple list of records and have the ability to create a record summary report from within a row without having to think about it. Ideally it would be something like this (and I'm being facetious): Hey you, click
How to get matching record from another form to display in main form
I have 2 forms; One main form (Form1), and one form containing static data (Form2) every time I enter a new record in form1, and physically type in the "postcode", I want the matching "region" pulled in from form2. Please excuse me if this is easy but I have tried a few ways with no success. BTW I am a new user. Thanks in advance for any help Roly I
Update Date after editing
Hi, Is there a way to show a date field that records the last time that a record was modified/edited? Thanks in advance!!!
zoho-migration exe.
Why can I not install zoho-migration exe. I have tried to run as administrator [ which I am ,single user machine] Message reads "Windows cannot access the specified device,path,or file You may not have the appropriate permissions to access them "
website-embedded table header cells changing width during vertical scroll
I have a table that when I embed it on a website page has the mysterious behavior of the header cells changing width when you start to vertically scroll. Upon initial table display (when the vertical scroll involves top-of-table) the header cells display at the correct width; however, if you start scrolling down in the table then the header cells change width and don't match the width of their corresponding column cells below. here's the test table location: http://inorml.com/testo2/
Subform Entries into 1 Main Form Field
I have a subform lookup where a user selects a code. I need the string value of the code selected for each row in the subform to post in a main form for printing. I've tried subform variables but either I get duplicate entries of the code or just the value of the last code selected. Sample code that kind of works but stores wrong data if user selects a wrong value...it adds the value for each input: r = ""; for each RCRA_Code in input.Manifest_RCRA_Codes { n = input.RCRA_Codes_Print; r
Invalid Email in Logs - How to troubleshoot?
Hi! I have a couple of questions. Problem: I am getting errors in the logs for an invalid email address. And because of that error, the rest of the script seems like it stops. Error details: Error in executing On Add - On Success script. Error. Error in executing IF rule : Error in executing If block. Error in executing IF rule : Error in executing If block. Error in executing Send Mail task. InValid email Address Found. Possible Solution: 1) how do i get the script to continue even if it finds
Added text suffix to a Number field
I have number fields that are measured in Feet ("ft") and Inches ("in"). Is there a way to add a text suffix so that my number fields will read: 100 ft instead of just 100.
Report Headers
Is there a way to keep my report header on all report pages that I print. Thank you.
API Question
I have tried a Support request but got no response. I am trying to create a Content Management System for my web site. The content is saved in my Zoho Creator database and includes links to images, tile, desCription text etc. From my web site php or similar script, I need to use an API to get this data. What API choices are there? Which is best for this application (speed)? What is the format of the API call?
Multiple Conditional If Statements
I am having trouble writing a script for "On User Input" for field_2. Here is what I am trying to do. IF field_1 IS NOT = null or 0 AND IF field_2 IS NOT = null or 0 Then set the value for field_3 = ((field_1 * field_2) / 12)) All of these field are in the same form.
Next Page