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
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
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
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,
getDayOfYear() with leading 0's
I am trying to use getDayOfYear() to generate a date code for orders, but would like the output of the Day of Year to always have three digits. For example, I would like Jan 1st to be 001 instead of 1. Feb. 3rd would be 034 instead of 34. Here is how I am using it: if (((input.Wash_Date != null) && (input.Washpack_Step != null)) && (input.Batch != null)) { year = ((input.Wash_Date.getYear()).toString().getSuffix("20")).toLong(); step = Washpack_Step[ID == input.Washpack_Step].Number;
Hours Worked Time Sheet
I put together this script for calculating for my time sheet. All hours worked are during the day. Start_Time and End_Time are Date-Time fields. Break_1, Break_2, and Time_Taken are decimal fields. This appears to calculate correctly, and meet my needs, but I want to check before implementing it. Does anyone see any reason why this wont work? startmin = (input.Start_Time.getHour() * 60 + input.Start_Time.getMinutes()); endmin = (input.End_Time.getHour() * 60 + input.End_Time.getMinutes());
Users And Permissions
Dear Sir I would like to set permissions for some fields But i can not do that In the notes it says some old accounts can not do this I have to solve this please help What i want is easy I want to create roles and i want to set some fields to be shown some groups and some other other fields What i see now Show field to Admin or Everyone.I need to create some Other goups such as Account Department or Exporting etc Thanks
Zoho Creator Won't Take Pictures on iPhone 5C
We noticed on our iPhone 5C that we can't take a picture while in the mobile app. Everything else works great. When we hit the camera option all that pulls up is a blank screen. The camera will not work. Is this something that just occurs for the iPhone 5C and is there a fix? Thanks!
Date Time problem
Dear Sir, I already try Many Date, only 2/11/2014 return Wrong Result.. Why same formula return two different result ??? (((End_Time - Start_Date_Time) / 1000 / 60 / 60)).toLong()
Tooltip not working
Hello, I configured a tooltip message as indicated here: https://www.zoho.com/creator/help/fields/configuring-tooltip-for-a-field.html but is not working. The field is numeric and I've tested in Chrome Version 38.0.2125.111, Safari Version 8.0 and Firefox version 33.0 Thanks!
Create an upload button as Custom Actions in a report
As we know with the custom Actions in the reports we can create buttons with call functions. I would like to ask you if there is any way to create an upload button in the reports in which I can upload files from my PC. Like the upload button in the form creation.
problems using a lookup in a stateless form
I have a table <MyTable> which has a lookup to another table <Data Table>- so far so good. I have a stateless form which receives the ID of the row in <MyTable> via a function. I can then pull the row in <MyTable> and populate the stateless form. I need to be able to populate the Lookup with an existing value from <MyTable> and allow the user to change the lookup value in the stateless form - eventually to save back to <MyTable>. Currently the stateless form has a lookup defined in a similar way
Formula Field return with dollar symbol
Hi, Create this formula (Pago_Total - Pago_Total * Porciento_de_Descuento / 100).round(2) and work great but I need the return value with the dollar symbol ($) in the formula field and in the column total.
Fetch records from Zoho CRM and update picklist
Is it possible to fetch the values stored in a Zoho CRM picklist and add them to a Zoho Creator picklist. i.e. I have a field in the CRM called 'Roofing Type' in which I have about 10 different types of roofs which I select depending on the job. Can I have zoho creator pull this list onto a picklist in zoho creator. That way I only need to add different roofing types into crm and it synchronises with creator.
Retrieve all related data based on lookup field selection
Hi, I have a form and which has several fields but two fields are TV station and Market ( Market is the lookup field of market Form). below is the data format. I am trying to update this form data by using another stainless form.What I am trying to do is put a Market field drop down above on the stainless form and when user select the market name from drop down then a script will run to retrieve the related TV station name in the next tv station drop down field. For instance , if user select
New User field being assigned a value unintentionally
In an application we are using the new User field. It is being assigned a value when a user changes to a record by a function. The field is not referenced in the function. Is this normal behavior. My understanding is this field works like a normal dropdown and is not changed unless selected by a user on the screen or is explicitly set with a script command. .
Error in REST API call
I am testing the REST API call in command line with curl. I have a problem and I can't find what I am doing wrong. The following call works fine : curl https://creator.zoho.com/api/json/applications?authtoken=********&scope=creatorapi It gives me the list of applications. But this one does not work : curl https://creator.zoho.com/api/json/chouette/forms?authtoken=******&scope=creatorapi&zc_ownername=aaa.bbb I have the following error: {"errorlist":[{"error":[2892,"Specified application name is not
how to make regular report in plain text from creator?
hi just use creator.zoho.com and reports.zoho.com all works well i need every night report in plain text from creator. Zoho Reports can send report only as attached pdf file. how can i make and send report from Creator in plain text by email? what report? there is report1, in this report i need - total summ of entries - total summ of entries with fields field1="id1" - for all entries with field field1="id1" - total summ of numbers from field2
Date field without day
Hello, Is there any way to insert a date field in a form that lets you select month and year without the day? So, for example the options would be November 2014 December 2014 January 2015 February 2015 etc. Thanks, Matt
how to make - filtering entries in view for different users?
hi just made new view there is 2 users - user1 and user2 entries in view contains data "data1" and "data2" how can i make in view so that - user1 can view entries that contains "data1" - user2 can view entries that contains "data2" ? thank you!
Simple Question: Fetch Records based on Date Function
Hello all! Thanks in advance for your insight. I'm having trouble trying to fetch records based on date. Here's what I'm trying to accomplish: Given Activity_Date(date field), month(int), and year(int). list = Booking[Activity_Date.getMonth() == month && Activity_Date.getYear() == year]; The error message says "Invalid Criteria." This is probably something simple I missed in documentation. What am I missing?
Problem with Lookup ID, BIGINT and STRING == not valid
Dear Sir, I am not a programmer and have been trying hard to work with Zoho creator. I am working on an app to calculate a total process cost for a work. Form 1 : Work_Order Work Order # (single line) Work Completed? (decision) - if this is "true" then run script below: Total Process Cost (number) - wish to calculate and return a total based on related values in Production Form if input.Completed = true // { Total_Process_Cost = 0; for each r in Production [ID == input.Work_Order] { Total_Process_Cost
Problemas com contas de e-mails
Olá! Boa noite, Além do e-mail principal adicionei mais dois, sendo que o primeiro funciona perfeitamente envio e recebo mensagens, porém os dois últimos não funcionam, ou seja, não envia e nem recebe mensagens. O que fiz de errado? Se puderem me ajudar fico muito grato. Atenciosamente: Adilson M.
Sub forms
Hi i have subform , fields are food name no.of plates,price food name is drop down if user select food name and enter no.of plates and automatic calculate price i want set criteria ,user don't select previous row selected food name please check attachment Thanks Satya NHM
How to create a lookup field after the two forms are already established?
Hi. I have imported Excel data to create one form. I would like to import data for a second form, where one data field contains data which is identical to a field in form one. Is it possible to create a lookup field after I establish the second form, with its data? Also, I see that there is an Excel Migration tool for Windows users. Is there something comparable for Mac users? Thank you.
Fetch Records and print on Page
I created a form that allows me to input data, which is saved in a Zoho relational database, then I created a report to view this data. All of this works perfect. Then I tried to create a page, so the data can be exported in custom layout, but I have been unable to fetch (access) this data and print it out in my page. Can someone help me with the structure and syntax. I am familiar with PHP/SQL, so here is my code below: <% firstname = BasicInformation_Information[ID !=0].First_Name; lastname = BasicInformation_Information[ID
fetch records and display on page
Hello, I have created a form, where I made one entry. Then I created a report to show the data entered. All works perfectly. But, then I tried to create a page, so I could design a customized report, but I am unable to retrieve the data from the database and display in on my page. Here is my code below, could someone help me with the syntax. Thank you, Collin <% firstname = BasicInformation_Information [ID ! = 0].First_Name; lastname = BasicInformation_Information[ID ! = 0].Last_Name; %> <table width="200"
Formula field displayed on form does not round
I have a formula field (a/b).round that displays correctly on the View and when clicking on view tot he left of the record. However when I edit the record it shows all the decimal places.
how to check which last user who changed entry?
hi, community! there is app in creator 2 sales users - user_1 and user_2 1 admin user - user_admin each user can open and modify entry in creator's app how can i check which of user_1 or user_2 has at last modified entry? for example, i can make field in which username will be filled (how?) and how can make, so that field will be filled only with user_1 or user_2 usernames, but not with user_admin username?
Problem filtering a lookup field
Hi, I have a problem trying to filter a lookup field ad I need some help. Let's say I have a form called Form1 with just one lookup field called Lookup which "points" to a second form called Form2 which has a numeric field (Form1_ID) and a text field (Text). When I edit a record based on Form1, I want to filter Lookup with this criteria Form1_ID == input.ID. I don't understand why it doesn't work (the dropdown list is always empty). If the criteria is something like Form1_ID == xyz (where xyz is
Inventory Turnover Form
My Creator experience is very limited, but I have created an Inventory Management database and input data using the form "File Input Form". The important fields for this discussion would be "Warehouse Arrival Date", "Consumed Date" and "Status of Inventory". I am trying to figure out how to get Creator to calculate inventory turnover for me with the data in the database. I would need a form or report that would take 2 user designated fields; "Begin Date" and "End Date" and perform the following.
Next Page