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"
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,
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
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
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
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.
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
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
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.
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];
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
Custom Filter - Display only records with a 'Blank' field
Hi I want to set up a simple Custom Filter that only shows the records which a certain field is blank. The field is called "REM number" and I want to create a custom filter so that only records which have no text (blank) in the "REM number" field is displayed. Is this possible? I've had a look and have tried: REM number > does not contain > "" However this doesn't seem to be working as it returns no records at all. Any help is greatly appreciated Many thanks Tom
Problem with latest Android mobile update for Creator
It would appear the search-a-field ability has gone bad with the latest Android Mobile update. Anyone else having a problem?
Failure submitting to FORM through email
Hi, We cannot submit anything to Form by email. It's been working well but not these two days. No errors found in Log, nothing, email just could not be received by the system. Please help check and advise. Thanks!
Can't update Creator form from Apple or Android device anymore
I have been successfully using Windows IE, Apple, Android browsers to post data to my Creator app for several weeks without issue. Now only Windows/IE works. When I use Apple or Android, I get a "Please Wait" message that never ends, and data does not post. I havent' changed the Creator app. How can I fix this? Thanks
add columns to form fields
Hi, I'm sure the answer is somewhere on here, but I can't find it. I've created Dynamic Content. It's a simple excel sheet. It has 4 columns. When I select it and edit it, there are only 3 columns. I need 4. In future I would suspect that I would need way more than that. What do I do to add columns to it? Thanks!
using Formula Field for Totaling or ??
I am trying to use a formula field on a form to total up 9 currency fields to generate a total that the user can see and then I can use to initiate a Payment. I can't seem to get it to accept all the fields? Is there a limit on the number of fields the formula filed will accept. Is there an easier way to do this with a currency field? I am new to Zoho and trying this out for the first time, so any help is appreciated. Thnaks
How do I bring the price from my product/service form to another form linked by a look up field?
Hi, I am trying to figure out how to get the price from the parent form into the child form. I am kind of new to this and haven't been able to figure it out. Any help would be appreciated. Parent Form Form Link Name: Add_Product_Service Fields: Product_Service_Name, Price Child Form Form Link Field: Kit_Sub_Form Fields: Product_Service (Linked by lookup field from parent form), Price (NEEDED FIELD FROM PARENT FORM) Note: The Product_Service and the Price of the child form will be used by a subform
Show summary on submit
I want to show the summary of the inputted data on pressing submit so that users can review it and print it. I tried redirecting the On Submit to the report page, but no success. It just lists all submission.
Create a table based on two or more forms.
I would like to create a table from two different ways using columns expenses (Ganancia Bruta,Ganancia neta, etc) in two different ways, for example. Do not know if I explained wellI want use what they I show in the following pictures: want to create a single table with a lot of data from different periods, different columns, different form and think "Auto view" limits me to only what is in that Form Thank in advance!!! Happy Holidays!
How to modify mobile views
Hi, I asked this yesterday, but maybe something goes wrong because I can't see my question in forum, so I ask it again: How to modify mobile view of the report? I have 2 fields in my report and I would like to see them both in same row. 'Edit' and 'delete' commands should also place in same row. -Toni
Send automatic email
I wish to send automated email when you register operations. if(Proyecto1[ID == input.Proyecto1].count() > 0) { x = Proyecto1[ID == input.Proyecto1]; //input. refers to fields in current form Email=x.Email; sendmail [ from:zoho.adminuserid to:input.Email subject:"Subject of the email" message:"Your message" content type:HTML ] } I have done different methods used en the same a fetch mail, etc. I could not send mail. I want to know as how to send an email to a client of a lockup or fetch.
Creating events in Zoho Calendar using Zoho Creator.
Quiet simply, how do I do it? I am having trouble finding the information. Any help would be greatly appreciated.
Transfer Form Data to External Form
Hello, I have a typical form, where I add my student's data: name, email, phone address etc. In an external website, I have to copy-paste the above student's data one-by-one in a form, in order to apply to an organisation to acquire exam date for my students. Imagine that I have 50 students with 10 fields = 500 copy-paste actions. Is there any way to bypass this procedure through a function (maybe) or another action I can't think of. Thank you!
Record Level Security & Permission
Why I already upgraded to ENTERPRISE USER still can not use this fuction ?
Are Creator Reports currently down?
I am unable to access any of my reports right now on Creator. Is this function currently down? Please see result from link below, which is one of my reports https://creator.zohopublic.com/fiscalservicesboe/bid-portal/view-perma/Bid_Portal1/d7w38RHSJT8xARafvT8DUXzetO7eBpHXEXjetu2NyxuEFs9KyYEjE71dtSQAMNkrBfNBHFs2DwGZNpHhG26jKxD6eAaf51jqH0wr: Can you please help with this issue?
Add Symbol cash to the result of a formula.
I need help with something and I have not resolved my doubts in a long time. The table above is in the dashboard, the hize starting from: todayExpense = Gastos.sum(Monto); thisMonthExpense = Gastos[Fecha in this month].sum(Monto); thisMonthSales = thisapp.checkNullNum(thisMonthSales); todaySales = thisapp.checkNullNum(todaySales); thisMonthExpense = thisapp.checkNullNum(thisMonthExpense); Gastos = Gastos.sum(Monto); GananciabrutaSP = Ordenes[Fecha_de_compra1
Error with iframe mobile
Hi Until a few days ago we were using the mobile form on our site in joomla and functioned properly. Now the modules do not appear. The code inserted iframe. is this: https://creator.zohopublic.com/rossato.group/contatto-generico/form-perma/Modulo_contatto_generico/fAp73ypfp2eQDqwEKWBBJJ7JOpjUv0dkKP5Ew1kxMMVnOeFRrO1bMgrZZwfb2A1PHTCxa7e2JNatKx8C3Cpwr2X2YWzDzWMbCrpE/ But if I replace "form-perma" with "form-mobile": https://creator.zohopublic.com/rossato.group/contatto-generico/form-mobile/Modulo_contatto_generico/fAp73ypfp2eQDqwEKWBBJJ7JOpjUv0dkKP5Ew1kxMMVnOeFRrO1bMgrZZwfb2A1PHTCxa7e2JNatKx8C3Cpwr2X2YWzDzWMbCrpE/
Creator Reports Links Not Working
Hi, I have two separate apps in Creator and the links to the reports appear broken. I'm copying the link directly from the "Publish" section and when I try to go access the URL for the reports, it does not work. The embedded links in my website also do not work. For example: https://creator.zohopublic.com/fiscalservicesboe/assignment-tracker/view-perma/Assignment_Tracker_Report/OHHwvjyukwTqC8RMY82yTw7NG7vKhQ8RuJh26aOQODnO0k2Oazm87pqChgywAG2zXdy7zK3SKfG3xYRVszNJHhtTQUBFBmTdz1K8 and https://creator.zohopublic.com/fiscalservicesboe/bid-portal/view-perma/Bid_Portal1/GjZ8XJxxORs9ehGUUHuMMgYWHE0a3JqVggYuKkGPQaNfJ1pPdrdSV4KHxTZnZtFaZxptH3BuYR0zjXDwH2amqQPWAknrvdUCpjv3
Can no longer update a creator form from Apple or Android devices
I haven't made any changes to my app, but I can no longer submit and post data from mobile devices. I used to do this successfully from Apple and Android devices. Now instead of getting a "data submitted" confirmation, I am presented with a "please wait" response that continues to hang. The application continues to work just fine from Windows 7 IE
removing edit ability on public share
New to Creator but have created an online data submission and using the public share so I can have the data be viewable online. Awesome tool! However, I do not want general viewers to be able to edit/ delete data and cannot find function which allows a public view w/o public edit rights? Any ideas/ help? Thanks, Eric eric.c.seto
How can i fetch the products in the qoutes modules?
Is that possible? if yes? can you give me some idea since products in quotes is not a field? im no sure Please help me:(
how - move old entries from creator to zoho reports database?
hi need to move entries older than 30 days to zoho reports database there is synchronization in place i need exactly move functionality as scheduler in zoho creator oк zoho reports
Auto fill in fields on base from a lookup field
Hi, I'm new to Zoho. i'll build a form where the first field (name) is a lookup field (from the table Customers). When my users select a client. So far so good that's not a problem to build. The 2 (adress), 3 (zipcode) & 4 (City) fields must be auto fill with the data witch is also on the table Customers. And i don't know how to build that or how to construct that Can someone please help me with this. Kind regards Maarten
Next Page