Notification into one form
Hello, I'm building an application and have a question about it. I would like to script the following: Step 1: 1. An user can make a mention in Zoho Creator for his vehicle like: Mirror is broken. 2. An other user can make another mention in Zoho creator for the same vehicle like: headlight doesn't work. Step 2: The manager can check out these mentions and fill in another form for a supplier to fix it. Step 3: The manager fills in a form and selects the licenseplate of the vehicle and the supplier.
Image field and File Upload field in stateless forms
Image field only takes image links in stateless form and we cannot create a file upload field in the stateless form.
is it possible to make this app
so i need and app where i can import xlsx tables filled with new data every month and be able to create new data based on lookup fields except the Price (Euro) it is auto filled. What i have at the moment is all the lookup fields, the auto calculater, the hidden reports (not hidden atm), the single field to create new column lookups names to a hidden report which is fetched by the lookup field. Is this possible to make a Main report and combine all these hidden reports so that the main report updates
Can I open a Stateless form from a Report custom action
Hi I have a referral system that I am developing and the main referral form has been created ok. However part of the process for the referral is for there to be a follow up call via a call centre to arrange a telephone consult. So I have created a report which filters new referrals which only the call centre will be able to see. But I would like them to be able to click a 'view Referral' button next to each entry in the report and see a version of the main referral form with some of the confidential
Notification form when value
Hello everyone, I have a question. In a form I have a choice box. You can chose: 1. Yes 2. No When "Yes" is selected I would like to send a notification by e-mail with user submitted data included in PDF. If I make a on update function "send mail" I can't attach user submitted date included in PDF. When I go to the form settings notifications I can. Can I us the notification in form settings for this function? If yes, how can I? Hope to hear from you soon, this would really solve some problems for
Creation of HTML page Problems
Hello, 1) I have a problem. when I try to create an HTML page, screen becomes gray and nothing is clickable. I have to reload the page. 2) at link https://www.zoho.com/creator/help/views/create-html-page.html i read: "6. You can create your view based on a template by selecting the Choose Template button". where is this button? thanks a lot
Error Executing Workflow On User Input script
so i get this message when trying to convert from native price to euro in lookup to single field - Error Executing Workflow On User Input script Price (Euro). - Error occurred while executing the workflow. please contact support@zohocreator.com failing code: euprice = Price_Native_currency1 [ID == input.Price_Native_currency]; if (euprice != null) { EuValue = (euprice.Price_Native_currency.toLong() * 0.10836).round(1); input.Price_Euro = EuValue.toString(); } And if im not doing "if" then
Users can't download file uploads.
I am having troubles making it so a user who is in a group can download a file that has been uploaded. They can see the link inside of a view, they can click the link but they do not seem to have access to download the file. The user has the view and the form shared to them already. The file upload is inside of a subform on the main record. What is wrong? is there something else i need to do? I don't want files to be public, I want a logged in user to be able to download any file they can see in
Possible to set filter on multi-select lookup?
Hi, I have two lookup fields in one form: Lookup 1: Services Lookup 2: Activities When these are single-select lookups I can set the filter so that the menu of activities is dependent on the service selected. However, when these are multi-select lookups the same filter does not work. i.e. on activities lookup ((Service.ID == input.Services)) Is it possible to set filter to multi-select lookups so that all services selected display all activities related to those services? Thanks! Lindsay
Link auto number across forms
I want to use a lookup field to link two forms. One the first form I have an auto number field, as well as a single text field. I would like to use the text field as a lookup to another form, and to have the auto number auto populate on the second form in order to maintain data integrity. How would I get the auto number field to auto populate? Thanks
Html Table Fix
Good day, could you please help me how do I align this columns to put one beside each other (no intermediate space), output = output + "<table class='tableSize' align='center'><tr><td style='width:60%;vertical-align: top;'>"; output = output + "<table border='1' cellspacing='0' align='center' style='border-color:#EEE;width:60%;margin:0px 0px 0px 0px;' id='billingAdd'>"; output = output + "<tr class='rowHead'><td>Nombre</td></tr>"; for each y in EquipoUtilizado { output = output + "<tr class='rowVal'><td>"
How to insert a chart in XPATH?
I need to add a Xpath code that be displayed as in the chart below where varibles replace values. Whether this is not possible, I would like to create graphics as it is in HTML or any format that supports Zoho to use variables such as values, and was told that was impossible, or use different forms within the same graph. <?xml version="1.0" encoding="UTF-8"?> <chart> <title>Población</title> <subtitle>Fuente: INE (2004)</subtitle> <name_value1>hab</name_value1> <type>bars</type> <header_height>80</header_height>
Zoho authentication API
Dear team, Do you have by any chance an API to authenticate through Zoho? I need to do a portal (and I cannot use for this purpose Zoho Creator) and I would like to have my users be able to authenticate through a Zoho account. We may use Zoho Creator to create the users but then front end will be in another technology. How could we proceed? Is this something already existing? Many thanks in advance for your input. Best regards, Christophe Mendez | MZ Consultants - Zoho Alliance Partner
I Can't access my Zoho Recruit information to populate in Zoho Creator
Dear Support, Please could you verify what is wrong at my script? I'm following the instrutions on help but I can't have success. I include some alert to debug, but the end doesn't show anything for resp. I include some printscreen to help you to understand the sequence that I'm doing. Thanks. Paulo Miguel. script: moduleName = "Candidates"; condition = "(email|=|" + input.Email + ")"; fromIndex = 1; toIndex = 20; resp = zoho.recruit.searchRecords(moduleName, condition, fromIndex, toIndex);
How do I duplicate entries more than once?
Hi. I am trying to put together a raffle which gives the user the option to purchase more than one 'ticket'. What I would like to do is multiply the data entry based on the amount of tickets purchased e.g. if the user purchases 3 tickets, the form would automatically create another two entries. If anyone could help me with a way of doing this, it would be much appreciated. Thanks
Is it possible to upload files to Zohodocs from zoho creator using api
Hi Is it possible to upload files to Zohodocs from zohocreator using api I refer the zoho docs api below link, but its not clear https://www.zoho.com/docs/zoho-docs-api.html Please help me how upload files to zoho docs form zoho creator ,if any sample code please post it Thanks Satya NHM
How can access zoho pepole employee form from Creator
Hi We are bulding an application wich needs info from our employes, this info we have into ZOHO PEPOLE ¿how can acces the info in zohp pepole form zoho creator?
logs - to admin email?
hi! how to send all error logs to admin email?
how in form make verification of data in other report?
hi! there are 2 forms - form1 and form2 and there is report1 which made on entries of form1 how can i link in form2 verification report1's entries? example if in report1 there are entries with "input.datadostavki >= zoho.currentdate.addDay(3)" then in form2 there is alert =========== if (input.datadostavki >= zoho.currentdate.addDay(3)) { alert("alert"); }
I would put a filter for a single month without putting a specific day.
ML_01_Last = Stock1[Fecha == '01-Jan-2014'].count(); I would put a filter for a single month without putting a specific day. ML_01_Last = Stock1[Fecha == 'Jan-2014'].count(); The filter should be something, but I'm not sure how.
How to do an "Or" param on an HTML View for a View Link
Hello. I'm trying to do a View criteria parameter that uses an "Or" condition. Here's what I currently have: <div viewlinkname="Orders" params="Entity=<%=Entity%>" elname="zc-component">><div> - which works correctly for providing a View that contains only the "Entity" name that I want. This is what I'd like it to do: <div viewlinkname="Orders" params="Entity=<%=Entity%>" OR "Added_User =<%zoho.loginuser%> elname="zc-component">><div> I'd like the view to give me all items for the correct Entity
eMail template with a lookup field
I am trying to develop an email template for a form per "on submission success" action. The "submit success" action triggers this email. In designing the template, I found that the "lookup field" defined as <%=LOOKUPFIELD%> shows a value of the ID of the related form. How can I make it shown the other values of the same row on the related form? Thanks.
Number field help
Hi How do I get a number field to display 09 instead of 9 I am using to sort Thanks
Viewing Reports in a form
Is it possible to view a report in a form, much the way sub form can be seen? If so how can this be done? Thanks!
Making a Static Form Field (non-editable for standard users)
I'm trying to find out the easiest way to be able to "lock" a form field after entering information in the record. I want to be able to import records and have my users only be able to edit certain fields but still see the other information.
Will Zoho Creator ever provide customizable layouts for forms?
One of the most wanted features for me and my clients is the ability to have better layout options for forms. The rigid 2-column vertical layout is not enough for many situations, and looks rather primitive and not elegant like many commercial applications.
Html Table Container
Hello I have 2 tables in HTML, I want to know how do I put one beside the other, I have the following code //CONDICIONES AMBIENTALES if (CondicionesAmbientalesNoVacio != null) { output = output + "<div class='invHead2'>Condiciones Ambientales</div>"; output = output + "<table class='tableSize2' border='1' cellspacing='0' style='border-color:#EEE;margin-bottom:5px;'>"; output = output + "<tr class='rowHead'><td>Zona</td><td>Hora</td><td>HR</td><td>TA(°C)</td><td>TS(°C)</td><td>TD(°C)</td><td>TS(°C)-TD(°C)</td></tr>";
Exporting schedule backups automaticly
Hi guys. I have scheduled a backup creation daily for one of my databases. I need a way to store that backup every day without having to go to the website and downloading it manually. Is there any way I can do that with CURL or using the API or something?
delete an Associate Existing Tasks
Hi from Roles How can I delete an Associate Existing Tasks ? Omar
Mapping fields from Creator to CRM
Hello, I am attempting to create a record in CRM Contacts from a Creator form submission. The form contains the fields First Name and Last Name. "Name" seems to be the only acceptable field in Creator. Is there a way to map First Name and Last Name separately? Thanks! Quotemap=map(); Quotemap.put("First Name",input.First_Name); Quotemap.put("Last Name",input.Last_Name); Quotemap.put("Company",input.Account_Name); Quotemap.put("City",input.City); Quotemap.put("Phone",input.Phone); Quotemap.put("Email",input.Email);
Automation of User invites in Customer Portal
Hi, I want to know if it exists a way to automate the user invite in the Customer Portal via a custom Form, via api call or other via without user interaction. I would like, for example, create "Students" in my database using a Form and add them automaticaly in my Customer Portal. As I can Allow Self-Registration in the Customer Portal and set the default profile (in this case one that filter the info related to the Students), I thought I could create to every Student an account to my Portal just
Help! Anyone know how can I get user to choose a unique ID name?
Thanks for any help you can offer folks. I have a very simple form. The only field is ID_Name. I want the user to choose a unique ID name, and I want to be able to control the responses. if(input.ID_name == "Jenny") { alert ("Sorry, this ID name is taken. Try again."); cancel submit; } This On Validate script would work perfectly if they chose the name Jenny. Basically, what I want is to say (instead of Jenny) - any name that is listed in the field called All_ID_names, which is in the View called
Export XML file with child element
Hi, I would like to export the data in Zoho Creator to XML. However, there is a child element in the XML, the XML look like this: <?xml version="1.0"?> -<Batch xsi:noNamespaceSchemaLocation="http://www.google.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="1.2" TradeId="3333"> -<Order TradersExternalReference="4456"> -<ShippingInformation> <FirstName>John</FirstName> <Address>road 25</Address> <Country_ISO2>US</Country_ISO2> </ShippingInformation> -<Products> <Product
Adding the value of items in a picklist
I am creating a simple equipment builder, where I have a catalogue of components, with costs, which are pulled into a form in a multiselect picklist. As each item is selected, I would like to fetch the cost of each item, and add them to a running total.
Restricting numbers in a decimal field
Hi there, I, like many others, am really surprised that Zoho Creator doesn't cater for a time field (hh:mm) to capture time spent on certain tasks. So I've opted to use a decimal field and ask people to round up to the nearest half an hour. I would like to restrict the allowable numbers after the decimal point so that they can only enter .5 or .0 and nothing else. If they try to enter anything other than a 5 or a 0 after the decimal point then a message will display - "please enter time to the
Send information from one form to another via OnSuccess
Hey guys, We are making a multi-part form where our guys will fill out some base information and then select a category to be taken to a particular form based on the selection. We need a way to transfer the information from the fields in the first form to the form they are sent to. Thanks in advance!
Generate Part Number
Hello, How can I Generate Part Number From another fields and see it and add it to the ID part field Sample: Size: 2 1/2 Grade: Steel Weight: 23 Custom: 111 Result: 2 1/2 Steel 23 111 Thanks in advance / Omar
Pivot Charts work as a Creator USER but not a customer portal USER
Can someone explain why I get beautiful charts ( even if my form data is multi-select) as a Creator USER ... but when I access the Chart as a customer portal user - it just won't work? Seems to me that if I can create a chart and view it as the administrator - I ought to be able to make this available to my portal users - ( or am I being totally unreasonable?) Thanks in advance for your response, Craig
Lookup result not showing in export CSV files
Hello all, I have form A in which I enter a building number and save. On subsequent forms to reduce entry error I have a look up field to select the building from the already populated list. When I am checking the backups, I notice that the column which should hold that lookup result is blank. Is this a limitation or a bug? When exporting the list manually, the column shows with correct data. Just not in the combined Backup/Export version. Please help. Thanks, Scott
Calculating the number of days between a date field and the current date
Can someonce check my formula I am looking to count the number of days from the current date - back to a count field Here is my formula ((zoho.currentdate – Initial_Contact) / (1000 * 60 * 60 * 24)) Initial_Contact - is a date field entered by the user. I modified the formula found on this page - https://www.zoho.com/creator/help/fields/configuring-a-formula-field.html#Script_Actions Thanks in advance
Next Page