User Permissions
Good day, I have 2 apps, for each I create a new profile. I embed a lookup in app 2 of a form for app1, always I enable the option to "Allow new entries". I shared both apps with one user and allow permissions in the form of the app1 for Tab Visibility Create View Edit Delete View all Modify All. The problem in that this user can´t create new entries in the embed a lookup in app 2, the "+" of allow new entries doesn´t appear. Best Regards,
"Failed to Add Data" when submitting form
No other information and no other clues are given. The project has open access to support. And I have asked support to help on this with no success, yet they pretend they solve it, or ignore my problem. Support staff lately is very unhelpful. I wonder if others experience this error and know what to do.
How to merge values in multiple columns into one column?
Hi, I'm completely new in Zoho and SQL and have just started playing around with some data that I'm working on for analysis. What I need to do is that I have data in multiple columns (numeric values) that I'd like re-shape the data in this manner. 1) Merge data from multiple columns into data in a single column (as variable column) 2) Create separate column for variable type (the original column names will become the variable type in a new column This can be done very easily in R script using "melt"
Exporting report to excel 2010
When I export to spreadsheet I normally want to make a merge operation in Word But as I use Word/Excel 2010/2013 I have to open the exported 2003-2007 excel file format and save in 2010 format (XLSX) Is there any way to get over that step. Poul
Record Template Image Size
Hello I want to add image in Record Template I want width 100px and height will adjust automatically. I try with codes but i can not succed. Can you check please
Configure Grid Report
Good day, Im trying to create something like a Shopping Cart with a Grid view but I have the following issues: 1. When I create the report as a Grid type and I access the report Zoho shows me like a List report (no field editable properties). 2. If the grid work as should work (with editable properties) I can disable some fields to be edit?, I only want to change a Qty field and setup a custom action button. Thanks for the support,
How to send sms as a custom action in a report view?
Hi, How do I send an sms as a custom action in a report view? I've tried using the function shown here: https://www.zoho.com/creator/help/script/sending-sms-from-a-zoho-creator-application.html and made the changes as instructed on the page but for some reason it's not working. I'm using Clickatell as a third-party service. Thanks in advance, Siya
CRM field does not populate through lookup add new value
For our existing forms that had CRM fields...we can no longer select these fields when the CRM field is accessed through another form via adding to a lookup. I tried adding a new CRM field to the form the lookup referenced and the new CRM field populated the lookup's form. so it has something to do with older CRM fields. Again this is not when selecting a CRM field in a form directly....but adding a value to a lookup field in a form through the plus button. We are having issues specifically with
message error to deliver email
hello , by sending an e-mail notification , the user enters the wrong email address , what should I do to get me the error message received ? Example : input.Email = " support@zohocreatorservice.com " To: input.Email From: zoho.adminuserid CC: zoho.loginuserid etc .... Please help me. David
Logout statement??
I am using an openurl with form-perma to avoid showing the menu structure and the global search field. It works great except there is no way for the user to log out. Can a deluge statement be added that will log a user out? An added ability to automatically logout after a set number of minutes of no activity would close some security holes. Currently a user might login to an application on a public computer and walk away, leaving the application exposed for hours or perhaps days.
Free Flow Script stripts out my code
Hi I have the following calculation - <%=Total-(Failed+Converted)%> - which works on the page. But when I edit the application it has removed the brackets and displays <%=Total-Failed+Converted%> - which produces a different result when I save it. I assume their is something wrong with <%=Total-(Failed+Converted)%> - can anyone help? Thanks in advance
Alert Box size
Hi, I have set up a alert on user input but it seems the alert size is really too big. How do I can size it to smaller ? Below is the script that I am using ************************************************* if (input.UNM_MVPD_01 != null ) { input.UNM_alertNote = ((((((((((("The " + "<b>" + "<i>" + MVPD[ID == input.UNM_MVPD_01].mvpd_MVPDName + "</i>" + "</b>" + " in " + "<b>" + "<i>" + Market[ID == dat.Add_Market].Market_Name + "</i>" + "</b>" + " TV Market Sold to " + "<b>" + "<i>" + MVPD[ID
Editing URL field in a report in spreadsheet view
When I'm viewing a report in spreadsheet view, I can easily edit various fields directly. Very convenient. But I can't edit a URL field. Why? I could enter URLs in a text field, but then they wouldn't be clickable in a report. Is there a workaround? Thanks.
How to move forms to another app?
Hi, Is there any way to move forms with data from app to another app? EDIT: I would like to show report of form in another app.
Nested Sub-Forms
I have created a form called "Form 1" and a view on that form called "Form 1 View". I also created a sub-form inside "Form 1" which also contains a sub-form. It appears that, after entering several records, when using the "Form 1 View" to display and edit the records, I am only able to see and have access to the sub-form fields but not the nested sub-form part that exists within the sub-form. I was looking to see if there is a way to have at least a link which I can click on in order to edit the
live chat to a creator page?
Is it possible to add live chat to a creator page?
Persistant forms
I want to create an employee training form. As they complete each task, they check a box next to the item. The problem is if they leave and come back later to the page, the form is reset. Is there a method to create a "persistent" form. I am doing this in Creator, is there a better app I should be doing this in?
Hyperlinks NOT functioning
I just tried to access the hyperlinks in my database and it's not working. Is there an estimated timeframe for a fix. These links are critical to my business. Thanks.
Writing to Creator database from Zoho CRM
Is it possible to insert values into a Zoho Creator database from the CRM, using a custom function or something similar? If I write the code in a custom function, I get an error that the Form does not exist in the application. Any ideas?
Send data from Zoho Creator to Google Sheets
Hi Is there a way to set up a google docs spreadsheet to automatically fetch data from a Zoho Creator form view? I need to send data to google docs. Raul
Wufoo to ZOHO
I am willing to pay for the job I require somebody to please set up my Wufoo toZoho api ? Any body that has done this or can assist please contact me.
How do I update a contacts task?
I am trying to update a task for a particular contact, but cannot find a way to find the ID for the task. I used get related record to find the task; (zoho.crm.getRelatedRecords("Tasks","Leads",thisLeadID); The map shows "ACTIVITYID", but it doesn't seem like I am able to use that that to update the task. Anyone have any id how to the ID of this task? Thanks
Script for lookup of data across different applications
I would like to do a lookup from a separate application. Here is an example: config-module: "Form1" has fields: Global Category, Prefix hr-module: "Form2" has fields: Category and Name --> Category is my lookup field. --> When I lookup a category, I would like to populate from config-module's field Global Category. The issue is, I want to create a function to get the details from the form programatically, it keeps suggesting that there is an error...the problem is that my lookup field (which
How do I round to 2 decimal places? Using Script
I have a couple of variables I wish to express as a % <%=Failed/Total*100%> This works, but I get an answer for example - 4.5454545454545500 How do I round this to two decimal places? Thanks in advance for any help
Zoho Creator Local/Hosted
Interesting post on Facebook today by ZCreator. My thoughts here: http://crediblesystems.blogspot.com/2011/07/zoho-creator-in-house.html https://www.facebook.com/zohocreator Really hope this is a precursor to a launch.
Update records from other form
Hello, I have a form (form A) with information about vehicles. These vehicles have to periodically inspected.The date when the vehicle is inspected is filled in. In an other form (form B) I can plan this periodically inspection wich will be shown in a calender. In this form B I would like to add an input field where the new inspection date can be filled in. So when a new inspection date is filled in form B it has to update the inspection date in the record generated by form A. There is a report based
Adding Multiple Records from a Single eMail
I needed to post a number of records into my form, ideally from a single email (and not having to have extra coding on the source system to implement the API). However, Zoho only supports single record submission from a single email. I therefore devised a work-around, which maybe useful to other people needing a similar system. I would also appreciate any comments on code improvement. My Form (IMPORT) has 10 fields, as below. Date Hour Channel Site Break_Type Month-Year Guest_Weeks Promocode
Subform subtotal automatic
Hello, I have made a subform with the following fields: Field 1: Aantal Field 2: Prijs Field 3: Subtotaal I have made the following script for Subtotal: row.Subtotaal = 0.0; row.Subtotaal = (row.Aantal * row.prijs); // calculate grandtotale input.Totaal = 0.0; for each rec in Werkzaamheden_2 { input.Totaal = (input.Totaal + rec.Subtotaal); } input.Totaal = input.Totaal; The script works but subtotaal will not automaticly be filled in when I put a value in: Aantal en Prijs. See attachment
Hyperlink function not working
I just tried to access the hyperlinks in my database and it's not working. Is there an estimated timeframe for a fix. These links are critical to my business. Thanks.
data typing; script error
I have an app with a subform. The whole form looks something like: Client - a lookup Project - a lookup Employee Hrs Rate Bill_Amt (a line of the subform) After entering Employee, I want to lookup the associated Rate and insert in the Rate field above. I am trying some scripting : theRate = Employees[ID == row.Employee].Rate; alert(isNumber(theRate)); //used for debugging returns true. row.Rate =theRate; When I go to save the script, I receive : Error at line number : 3 Expecting
MultiSelect Iteration
Good day, I have a form with a Checkbox Multiselect field "workerchoose1", I want to iterate the selected values, and create new records, I save the script correctly but when I send the form I got this error. (If you need access app is share Form DailyTimeReport On Success). I have this code if (input.scheduleselect == "Entrada 1") { for each selectedValue in input.workerchoose1 { workerID = Employees [wkname = "input.workerchoose1"]; fetchwk = TimeFixture [ID = workerID.ID];
Problem in form
Hello, I'm stuck in a form. In the attachments I have uploaded a print screen of the issue. When I select "Selecteer opdrachtnummer" the value in "Kenteken" has to be filled in. When "Kenteken" is filled in the field under it has to set a variable. The field "Kenteken" in the sub-form "Kosten" is based on the field "Kenteken." The problem is: Why does "Kenteken" right in the top doesn't fill in his value. Probarly there is a value because the field "Kenteken" in the sub-form is based on it.
Passing parameters to embedded form (2)
Hi, I would like to create HTML pages to customize the look and feel of the forms. However, I use navigational URLs to pass information between forms. How can I pass data to the embedded form?
formula field issues
Is there a way to make a formula field calculate properly if one of more of the items it's supposed to sum are blank? For example, say I have three number fields: Group A invitations, Group B invitations, and Group C invitations. If the formula field expression is (Group_A_invitations + Group_B_invitations + Group_C_invitations). but there's no value for Group C because no one from that group was invited, then the formula won't work. I still want the sum of groups A and B though. How can I make this
Picklist not accepting a list
Hi, I have a picklist not accepting a list of string items. The script can be saved fine but at the time of execution it generates an error. To, me nothing seems wrong with the logic here. The list is generated in another application from a database of categories filtered by another field. There seems to be an issue with this way of generating the list because if the list is generated manually with random items like "a", "b", everything works fine. I appreciate your support. here the code: Tecnicas_Lista
HTML script sections in a page
Hi, when creating a page, I added several HTML sections one after another. each section containing a table with pictures and text. At some point I wanted to add one section at the top but the insert HTLM function did not seem to find a spot to add this new HTML section right at the top. My reaction to this was to switch to free flow scripting, add a few lines at the top (to create a space), save and go back to script builder mode. The result is that the builder lost track of the different html
Dynamically Update Subform via Deluge
Currently I have a main form for Orders, a subform for the Model information and a Product form for each individual asset. The order form has the Model Form as a subform and the Model form has a serial number field which is multiline. I have a script, that works properly, to create an entry into the Product form for each serial entry. On the model form I have a sub form linked to the Product Form. After the script runs the subform in model form never updates. In my script I have assigned a lookup
zoho.userid actual BIGINT ID?
I don't need the email address, or the user name, I need the BIGINT number. Can this be accessed?
Other currency field vs chart
Hello, I have a problem. In a field I have selected the currency "EUR" --> €. When I make a Pivot Chart based on the database with the value of the field with lay-out "EUR" -->€, it will show in the Pivot Chart a dollar --> $. How do I change this? See attachment for a printscreen.
Change current index of autonumber field
Hi, We developed and are using an application for orders management since last year. We're using an autonumber field for setting the unique ID for each order. The start index was 20140001, so we could easily identify the year an order was generated. We intended to change this index, this year, for 20150001, but I figure out that this is not possible in Zoho Creator. Can you made this change for us, please? The form is at https://creator.zoho.com/appbuilder/gbpenha/pedidos, and the field name is Codigo.
Next Page