email field limitations
Is there a limit on the number of characters that can be after the . in an email address? This email produces an error when I try to save the form. name@xyz.consulting A shorter domain does save name@xyz.consult
How to display the first item in a list... as the first item in a drop down box?
I've created a list from items stored in a form, sorted the list and placed it into a drop down box. "Everything works as expected". I would like to display the first element in the sorted list as the default choice in the drop down box. As it is now: As I would like it to display: I'm thinking the syntax should be something like --> input.Service_History = <sorted list> element (1) ; Thank you for any help Alan
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?
Auto populate crm fields contact and account in creator
I have added a contact and account field from the CRM to Creator. When I access it form the CRM I would like it to auto populate the contact in the CRM I was just viewing. How can it auto populate those fields? Joe
Authorizing Zoho Creator to use Google Calendar
I am trying to add an event to the google calendar using a form in zoho creator. I'm unsure if I will need OAUTH 2.0 working between zoho and google. If this is the case. Is there an example for connecting to google calendar with oauth 2.0 authorization? Here's what I have so far posttest = "https://accounts.google.com/o/oauth2/auth?scope=calendar&redirect_uri=https://creator.zoho.com/oauth2callback&response_type=token&client_id=Client_id_from_google_oauth"; responsy = getUrl(posttest); The error
Google map not showing in add notes field
Hi 1) Google map not showing in add notes filed i use below script input.plain = (("</br><div width = '320px' height = '320px' style='border: 1px solid #A4A4A4;'> <img src='http://maps.googleapis.com/maps/api/staticmap?center=" + input.Address1 + "&zoom=17&markers=size:mid|color:blue|label:S|") + input.Address1) + "&size=320x320&sensor=true'> </div>"; 2) is it possible to insert map in image filed? Thanks Satya NHM
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
how to add file via webhook?
hi how can i add file from any system to creator's app via webhook?
Is it possible to call a function that opens a form record in Edit Mode and then Updates that record?
Reading here it seems I've painted myself into a common corner here at ZC... BACKGROUND INFO: I have a form dense with scripts and formulas, lets call it JOB. Another form called INVOICE is populated with information from JOB. In order for an INVOICE form record to be correct, one has to make sure the JOB form record that will feed data to the INVOICE form record is up-to-date. Currently, to make sure an INVOICE form record is correctly populated with up-to-date JOB data, one has to manually
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
help
help
Validation -- between Zoho Report Query Table and Zoho Creator Form
Hi, What I am trying to do is to validate the user input comparing the Zoho Report query Table. I have a Stainless form which is used to update the Data inside creator. and I have another query table in Zoho Report also .. now I want to make user input the data correctly based on the Zoho Report Query Table. So I would like to create a script that validate the inputed data inside Zoho Reports Query Table first if it is true then user can enter the data. Zoho Report Table Screenshot : MVPD :
setting a default value where no value from a non-mandatory lookup field has not been supplied
Hi, I have a client name field and and client number field with a dynamic lookup field for client number so that if the client types their name in (accurately) only their client number will appear on the drop down list. However, for situations where the client does not have a number (e.g. new client) or types their name in incorrectly, I would like a default client number (say 1234) to be entered automatically. Ideally I would like clients to be able to select this from the dropdown list, but I can't
Changing owner of a ticket
Hi There, I want to change the owner of an open ticket based on a "On User Input" event on a status field. So if the Status field is changed to "Collection booked" then my "assigned to" field changes the owner. Both the "Status" field and the "assigned to" field are lookup fields. Kind Regards Matt
Getting more than one field from the record.
I have a sales form. On that form there is an item field that selects from a drop down list. I want to get that description and get the price to populate another field on the form. I am very new to this so use third grade language. Thanks.
I have problems fetching data form one form to another
When I tired to fetch data form one form to another de my application did not work. I put the followin script in the look up field and the application dont work if (input.Principal != null) { temp = Principal [Id_de_Voluntario == input.Principal]; input.Estatus1 = temp.Estatus; } Heeeelllpppppp
Heelp urgent: Somebody can tell me why my script did not work. Fetch data from a father form
Hello I have dificulties to retrive data from a father form, because the system not retrive me the information I need. I puted the following code in the look up field on user input action: if (input.Correo_Electronico1 != null) { tempo = Principal [Correo_Electr_nico == input.Correo_Electronico1.toString()]; input.Nombre_Completo1 = tempo.Nombre_Completo; input.Estatus1 = tempo.Estatus; disable Estatus1; } Somebody please heeelp me, is urgent
sort a combined date/ string field
I have a form that I'm viewing service history with a drop down list. All of the information I need is stored in the Service_Request form. I would like to pull out the service date, the type of service and a description of the request. Below is the code to pull the data from the form assemble it, sort it and place it in the drop down list. for each rec in Service_Request [Site_ID == ThisAccount.ID] { ThisRequest = rec.Schedule_Date + " - " + rec.Request_Type + " - " + rec.Description_of_Issue;
Problems Total on A SubForm
Im trying to Total the cost of a list of products in a SubForm. I take a look for the same script in the New Order form for the Order Management app, with no satisfactory results. I use this code: This Code is Located on User Input in the field where I change the quantities row.subtotalcost=(row.pcostadd * row.pqty); totaltemp=0.0; for each rowvar in Subformpadd { totaltemp = (totaltemp + rowvar.subtotalcost); } The error message I got when I fill the SubForm is: Error in performing the operation
Users And Permissions : addon price from old Express Professional Plan
Hi, I manage an old Express Professional Edition at 99$/month with 19 users. What is the price of addon to use feature "users and permissions" ? Or should I migrate to new plan ? Thanks a lot
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.
CRM Plus or CRM versus Creator...?
Hi there (I have already had a brief discussion with Zoho on the phone re this - so am just seeking others input) I have already signed with CRM module - all good - and you can customise it etc - even better! And it has Vendors and Products (which I can also customise) and of course Creator can pull in records from CRM. And CRM is pretty sexy etc. The question is - why would one buy CRM or CRM Plus when you can basically do the same stuff in Creator (just your development time). It is not about saving
New - HTML / Custom Actions - number of records - lots of q's
Hi all New to Creator and so far VERY impressed. 1. A couple of things - is there a way to have custom buttons? I see you can have Pages (and have not played extensively there yet) which looks like u can embed HTML... not sure if that is an option...? 2. What defines an app? Considering an app can have as many "tables" as you like - why would you have more then one app? So if an app can have plenty of tables and forms and even "call" (relate/refer) to other apps or forms of apps. I then thought maybe
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 )
custom json export (link creator report to external app)
hi just need integrate creator's app database with external application application query data from creator's app via json how can i make creator's view so that external app can access it and query data via json? (in manner as on screenshot) or it can make via Zoho Reports functionality? example of data that external app understand:
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.
submit hide
Hi, I want to hide submit field,becoz my data is very important,If i make any mistake,the whole record gng to be wrong,thts y i am asking.If i finished all the fields then only show submit button.Its possible? Please reply me! Thank You!!
Retrieve data based on previous two drop down selection
HI, I have a form like below image . What I am trying to do is update this form data by using stainless form where user first Enter the "TV Station" Name form drop down and a script will run on User input on "TV station" to populate all related "Network" name in the "Network" drop down field. After that User will go forward and select the "Network" name from populated value. So on User input on "Network" Field I would like to populate the "Cable" name to corresponding field automatically. For
zoho table
Hi, My Application is Reservation System, so i want to show my field company_name,occupancy_type,Room_type,etc.., I got ans for all possiblity, becoz i give some condition in back end process if((company_Name =="aa") &&(Occupancy_Type=="Single_Occupancy")) { input.Rate =2300; } so i put more condition like this (i have 20 and more company).My another idea is these values store under one table ,so dont giv a condition but that field take this table and display that values.That table
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"
Using images as hyperlinks; Adding Alt and Title strings; Setting Image size
Here I am sharing my experence as tutorial; could be helpful Using images as hyperlinks; Adding Alt and Title strings; Setting Image size Scope: Following Tutorial applies to images added as field type image (not file upload). Step 1.Please prepare image named “TestImage.jpg” with approximate size 100X100 px. Step 2. Create form “Images” with 2 fields: Field 1: Type: Image; Field Name: Image; Field deluge Name: Image Field 2: Type: Multi Line; Field Name: “Multi Line”; Field Deluge Name:
How to calculate difference date?
Hello İ have form A And i have form B İ want in form B a field to calculate Added time form B - Added Time A (or current time) İ tried to this with formula but there is a error whic says one field is string the other float Thanks for help
Fetch total number of unique values
Here is an example of what I am trying to do. There is a Projects_Form and Employees_Form. In the Employees_Form, there is a multi-select field named Related_Offices. Each Projects_Form Record contains a multi-select look-up to the Employees_Form. I would like a field in the Projects_Form called "Total_Number_of_Related_Offices", that automatically displays the number of unique related offices for that project. For Example: Form: Projects_Form Record: Project One Lookup: Bob - Human Resources,
Next Page