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
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
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
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
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.
Next Page