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
Problem with form mobile within an iframe in Chrome and IE
Hello When I try to open a form-mobile within an iframe I can see just the title. None of the fields are published. I happens in both, Crome and IE. In Firefox, however, it works OK. this is my page's code <html> <body> <iframe id='formulario_reservas' name='formulario_reservas' height='900px' width='100%' frameborder='0' allowTransparency='true' scrolling='no' src=https://creator.zoho.com/calterras/reservas-usategui/form-mobile/solicitar_reserva/></iframe> </html> you can try in this link http://ziaboga.com/usategui14/pzm.html
Second bigger record fetch
I have a form that contains kilometers and amount of fuel; I want extract the second bigger values from fetch for calculate: [ amount_fuel / ( bigger_kms - second_bigger_kms ) ]. My problem is find second bigger value. How can I do? Thanks
how to disable save entry on alert?
hi! just made alert On User Input example: if (input.datadostavki >= zoho.currentdate.addDay(3)) { alert("alert!"); } how can i disable save entry when there is true "if (input.datadostavki >= zoho.currentdate.addDay(3))" ? in this time user can see alert, close it and save changed entry i need when there is true "if (input.datadostavki >= zoho.currentdate.addDay(3))" - disable to user to save entry. please help to make this.
Zoho Creator Calendar View
Hi, I am trying to create an electronic Vacation Request form, but creating a Report in Calendar view does not seem to be working the way I want it to. If someone approves the vacation, it is then shown on the calendar, but say, the vacation starts on March 2nd and returns to work on March 14th, it only shows up on March 2nd with the details. Is there any way for it to show up on every day, including March 13th? Thank you in advance! Joy
Workflow Script to Reload a Form with Saved Field Values for Selected Fields
I'm new to Creator, and Deluge, and I'm trying to develop a workflow which I thought would be basic, but I need some help. When a user inputs values to one of the forms I've designed, I want the user to be able to select certain fields that do not reset their input values when the form is Submitted. Is there a field property somewhere that I can set so the form reloads with the last input value? Or must this be done with variables by storing the user's input during Validation and then retrieving
Deluge, not easy?
Hi all, really looking forward to getting more into this product, its great so far! I am definitely struggling with scripting though. The help manual says the following "Should I have programming experience to code in Deluge? Definitely not. Zoho Creator/Deluge primarily addresses the needs of a large number of people who have a requirement for a web application but do not know to build it on their own. You need not be aware of Java, JSP, PHP, JavaScript, HTML or CSS. You just need to have a clear
looking at existing clients
Hi In my application, the user can add new clients while looking at existing clients. Currently I am having trouble with fetching client information from the same form. I've had a look at these links but im not really sure how to implement/use these to make them workable in my application https://www.zoho.com/creator/help/script/fetch-records.html https://www.zoho.com/creator/help/script/fetch-a-value.html Thanks :)
iterate distinct records in one form and check a check box if it matches any distinct records in another list
iterate distinct records in one form and check a check box if it matches any distinct records in another list how do i do this?
Importing Data
Hi, When I import data (csv or excel), how do I import the data of a lookup field? Do I import using the related ID or do I import using the corresponding string. If I import using ID, does the format have to be number?
Is there a way to get usage metrics such as logins, pageviews?
We are aware we can get record create/update measurements with a crosstab report run daily that counts #records with modified within the last 24hrs, by user. Are there additional metrics available? Such as login or pageview logs or metrics? Thank you!
Record Summery Template absent
Hello, I would create a record template for a report. I created the Template in Form Setting. I don't know, now, how i can apply the Template. If I select the report, not appear "summary record Template", as explained at link https://www.zoho.com/creator/help/views/record-summary.html. In FORM Setting i can see "Record Templates", but is not present the field "active" or "inactive". 1) How I can Apply the template? 2) Can I insert in the Template a lookup field for select a customer and visualize
Scripting lookup from another application
This is from one of your demo apps empRow = Sales_Reps [Email == zoho.loginuserid]; if (empRow.ID != null) { input.Account_Owner = empRow.ID; } I would basically like to do the same thing but my Sales_Rep field is in a different application.I was trying to do something like below but it doesnt let me access the other app through script but it does in look up. empRow = Employyes.Sales_Reps [Email == zoho.loginuserid]; if (empRow.ID != null) { input.Account_Owner = empRow.ID; } I
Where are my apps
When logging into Creator I am presented with only a blenk screen of "shared apps". My apps are not shown. The apps still work via iphone app and URLs but I can not get to edit any of them. I am just gone live with the first app and now am completely stuck. HELP!
Migrate from FileMaker Pro on Mac
HI there, I am trying to import a database from FileMaker Pro to Zoho creator. if I export as xml or csv it doesn't work as we have more than 70 columns, so wanted to try to export from FileMaker Directly. But when i try to download the migration tool, the link is dead - https://www.zoho.com/creator/help/application/ms-access-and-excel-migration-tool.html and seems to point to the MS Access tool. How can I install the migration tool on my mac? Thanks
Maximum Authtokens
Is there a way to increase the amount of tokens for an account? I'm getting an error that the maximum amount has been exceeded. Zoho should take into account how many PAID for services per account are being utilized . I currently pay for CRM, Creator, Campaigns, Invoice and Projects. I also use Docs. Factor in the iphone / ipad apps plus the service to service integrations and you see quickly you need many more than 10. I need at least 10 for Creator alone. I'm at a standstill right now in Creator
Help with data fetching
Hi In my application, the user can add new clients while looking at existing clients. Currently I am having trouble with fetching client information from the same form. I've had a look at these links but I'm not really sure how to implement/use these to make them workable in my application https://www.zoho.com/creator/help/script/fetch-records.html https://www.zoho.com/creator/help/script/fetch-a-value.html Thanks :)
Power a number to a Decimal X^(1/8)
Good day, I try to raise a number to a power usin power(X,(1/8)), the problem is that the script tells me that the 2nd argument only can be a BIGINT, Could you please tell me which function should I use, Best Regards,
Next Page