Criteria from multiple fields for lookup
I know similar situations have been addressed, but I'm having trouble implementing a solution. I am working with 4 forms right now. Crops_form Section_form Planting_form Harvest_form One record in Crops_form is related to many records in Planting_form One record in Section_form is related to many records in Planting_form In the Harvest_form, there is a single-select look-up field "Crops_field" which looks to the Crop_form a multiselect look-up field "Section_field" which looks to the Section_form
Make fields smaller? (lots of fields on a form = lots of scrolling to see the fields)
Hi there Is there any trick to squeeze more fields onto a Form? One of my Tables has about 25 fields and the standard way Zoho lays them out means the user has to scroll down to see them. I don't see this being possible but thought I'd ask anyhow. I have also tried to break the Form up by making some fields looked up in a different table - but this would be a 1 to 1 relationship. Thank you Brynley
Zoho.support.create function call
I submitted a support request last week, but, not unexpectedly, there has been no follow up from Zoho technical support. I am hoping for better response on this forum. I am trying to integrate several Zoho products (Creator, Support, CRM, Projects, etc.) into a workflow. At this point, I need to have Zoho Creator submit at ticket in Zoho Support via integration task/call function zoho.support.create. When the function is executed, the ticket gets created correctly. However, the data contained in
Domain validation
Hi I have ".photography" extension domain email ,i try insert the email like as " name@abc.photography " but its not inserted in form Thanks Satya NHM
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
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
Next Page