Pivot Chart
Hello all, I am trying to create a pivot chart to display predicted versus actual savings based on a month or a timeframe. This chart would also be able to display based on one initiative, multiple or all. It seems that you have to have your data sorted in a particular fashion in order for pivot charts to work. I have placed screen shots below of the form that I am using. The Predicted and Actual savings fields are currency fields. The "Entry Date" field only shows the date the info was placed, it
store text
I’m trying to store some text from fields (i.e. Submitter_Email and Quote_Serial) in my Job_Information form and then recall that to use the built in sendmail function. I simply can’t get the text to store properly for recall in the email. Here is my test script for a send email Function. I know what is circled in red is completely wrong. What do I use here to store those form fields/text properly?
How to connect two forms with a custom function button
Hello, I've configured Zoho CRM to address all but 1 thing for my company. I'm trying to use Creator to address that one thing using a Creator App that consists of two forms. So far I've created the two forms within my app. I'm struggling with how to put a button that works (custom function?) on the report view of form 1 that will take a user to the data in the report view of form 2. I've attempted to create the custom function but I'm not doing it correctly. The custom function's button appears
Convert Excel formulas to zoho creator automatically
Hi Is there a way to import formulas from Excel to Creator? I am trying to create an application based on an Excel sheet. The calcs are using basic addition, multiplication fields.
Customise Email Notification
In the customise email notification panel does the TO need to be: zoho.loginuserid Or can it be one of my business email addresses
Filter not working on updating record
I have a field called devices_room which filters the look up based on input.devices_site. This works fine on a new entry but not when editing a record. Any ideas?
Pivot Table report sub-total recalcualation
Hi, I have a simple application to manage a warehouse for an ONLUS that provide food to poor people. We are obliged to maintain a warehouse report in a specific format Each time a new product go IN or OUT we add an entry with: OPERATION DATE: date of opertation PRODUCT: name of product IN: quantity in OUT:quantity out the report must have a row for each OPERATION DATE in the below format OPERATION DATE_________PRODUCT 1_________|________PRODUCT 2_____ | IN |
Variable as field in fetch item?
Hi Zoho, Is it possible to fetch an item with a variable as the field given? for example fields = {field1,field2,field3};%> for each EachField in fields {Current_Fetched = Form1.EachField;%> <%=Current_Fetched%><br><%}%> And I'll get the data from the 3 fields? Thanks Ravid
Organizing form
Hi Zoho community, I created a form for empleoyees managment and it has 48 fields. I would like to have this fields in smaller groups, like Basic Info, Education, Health Insurace, Social security, among others. is it possible to arrange them in tabs or something similar? I do not like how it looks like if I use subforms or having a very very long form to scroll up and down. is it possible? any idea or can someone refer me please where in the user guide should I read. Any help will be appreciated.
data submitting issue
Hi all i have a peculiar issue.I am developing a application for my business using a developer who is working a lot to sort out the issue bt he is not able to find a solution.SO now seeking a help from you all I have a order Form- which holds the data for the orders received I have a Trip Form where the actual order dispatch details are entered . along with these forms there are many other forms. My problem is when i try to enter a Data in Trip Form- there is lot of delay in submitting data and most
add entry via email - is there any field for sender's "from:" email?
hi! add entries to form via email https://www.zoho.com/creator/help/forms/email-data.html#Adding_form_data_via_e-mail_in_user-defined_format there are system fields ZC_Subject and ZC_Content is there any field to capture FROM email field? field of email sender
Sorting records by date - how to only use day/month?
Hi, We are currently trying to sort our subscriber database so we can see who has birthdays this month, and whose membership will expire in the coming month. However, we have found that trying to use the search filters does not work. This appears to be because the sort filter is looking for the next 30 days this year - not the next 30 days of any year. Is there any way to fix this? Currently our admin team is having to repeatedly export the db to Excel and then use Excel's sorting to find the relevant
UK VAT calculation in Creator
Hi, does anyone know the simplest way to calculate VAT in Zoho creator
Cannot close Live Chat popup
Hi, Whenever I use the "Live Chat" there is no option to close the popup window, see: http://prntscr.com/atooyl Please fix this. Damien Cregan Hire an Expert
Show/hide with multi check boxes
Trying to show/hide 3 fields (17, 18 and 19) based on checkbox values. So far I have the following, which works fine if one box in field 16 is checked but hides all 3 fields if more than one check box is ticked. Is there a better way to do this? if (input.intake_form_1_question_16.toString() == "Completion Date") { show intake_form_1_question_17; } else { hide intake_form_1_question_17; } if (input.intake_form_1_question_16.toString() == "1st Fix Start Date") { show intake_form_1_question_18;
how to add record from anyone via stateless form?
hi! need to make next logic: 1) email from anyone -> 2) public stateless form -> 3) private zoho creator form task what i need to solve - every email that was sent to email "order@myemail.com" will be as unique entry in my private zoho creator form there are - private zoho creator form (yachting_zayavki) - public stateless form (email_data1) in both forms there are same fields ZC_Subject and ZC_Content how to make linking from fileds of public stateless form (email_data1) to fields private zoho creator
Mass-import date values
I found it hard to understand what date format to use when mass-importing rows into a view. Looks like it has to be : dd/mm/yyyy . Looks like : mm/dd/yyyy or yyyy-mm-dd would not work. How is this configured for the view? Or is this configured at the account level?
Limit number of records in report
I am using Zoho Creator for project management and for each project I have a list of upcoming tasks and a deadline. I am trying to create a report that will show upcoming tasks for each project, but set a limit on the number of tasks displayed for each project. For example, if Project A has 10 upcoming tasks, I only want to see the next 3 of them with the newest first. I know how to limit the number of records per page, but I'm looking to limit the number of records displayed for each project.
Fetch details from Contact module of the CRM to a form in Creator
I've used a lookup field (CRM) in the Creator form to get the contact name. On selection of the contact name, I want the form to auto update the Account, Email, Location and the number of the respective contact. Can some share a code to perform this operation?
Capcha Image not displaying (Zoho Creator Form WebEmbed)
Looks like the captcha image is not displaying in WebEmbeded forms. without the image, this feature is unusable. please resolve.
Testing and deployment practices for Creator Applications....
I'm coming from a world where we deploy changes to a test site (via a migration), and then once tested we deploy to a production environment. What are the best practices for doing this in the Creator world? I appreciate your help in advance.
Custom Action executes only on one record
Hi, I configured a custom action in the report header. The code is only one line, updating a field in a record. void WalkIn.OrderManager.MarkTasksPaid(Task_Subform t) { t.Payment_Status = "Paid"; } I don't understand the help document: https://www.zoho.com/creator/help/script/custom-actions.html#Configure_the_function_as_custom_action_-_in_View_Header n the Execute action for each record, the custom action will be called for each record. This is supported for functions with any argument type.
How to stay informed about changes to Zoho Creator
I've noticed some improvements to Zoho Creator Free flow Workflows lately. Is there some way I can find out about recent changes and planned changes? The roadmap showed up blank for me. Ideas in progress seems to have items that have been completed but are still marked in progress. Ideas implemented doesn't reflect the kinds of changes I'm seeing. I imagine there are new functions and perhaps functions that will be changed or removed. There may also be changes to the interface for end users. I love
Is it possible...
... to dynamically update a selection field, say Multi Select from another table? For example, If we have a table of Room Names. We want to be able to have a Multi Select question that states, "In which rooms..." and populates the options with the names of rooms from the Room Table.
different logo for multiple applications
I will have multiple applications in one acccount I manage them for different companies. They all need their own logo. How can I add a logo to one application and a different logo to another application all within the same zoho account?
Calculation of Values
Calculating values from 2 forms I have searched high and low for examples on how to calculate values from multiple forms. Im trying to calculate a running total from a staring balance field + deposit amount field + withdrawal field from 3 forms and display it in a Control Page, im in the process of creating an application that hopefully i can roll out to many members in the future and the formula above is an example of how majority of my field values are calculated. If i can get an example then it
How to Find a Field in Deluge Script
I want to delete a couple of fields, but I am not sure where in the deluge code it is referenced. How can I see where a field is referenced in deluge? And what if I don't want to delete a field, how can see where in the code a field is referenced?
can not add user to Zoho Creator
Hi, I had two users attached to Zoho Creator but deleted one so that I could add someone else. I added her to Zoho CRM and she can access that but when I attempted to add her to zoho creator - which we have two user permissions for and only one showing it says both are being used and I need to buy more. This is clearly not the case, what is going on? I have left it a day to allow the system to clean out and it has not worked.
send post url
Hello, i need help for some questions. I need to send data from table (For example: from row1 the sum of the all values, from row2 the sum of the all values etc) to web merge url. Url is: https://www.webmerge.me/merge/54626/7irksc Test data: ?&initial_users=My_sum_values_from_row1&growth_rate=My_sum_values_from_row2&arpu=My_sum_values_from_row3 But i really don't understand, how i can do this. So what i want to create [button], after clicking on this downloaded webmerge file from my data Thanks!
Disable "Switch to Plain Text" on a Rich Text Field
I have a rich text with all the toolbar options disabled. I do this because on load I am setting some default values that utilize html tags to create a predefined data entry template/guide for my users. Is there anyway to disable the "Plain Text" toggle option? I just essentially want a multi line field that can render html tags such as bold, pre, etc
Is it possible to make a lookup from a multi line??
Hi zoho fans, does anybody know if it is possible to make a lookup from a multi line field?
Make parts of mult line field read-only/un-editable?
Hello, we have a multi line field in one of our data entry apps that pre populates with a "template" of sorts that guides/reminds the user of certain things that must be present in the multi line field. We must use a multi line field because the info varies too much for us to dedicate specific fields for each. My question is, is there any way to make certain parts of a multi line un-editable or read-only? Problem we are facing is sometimes users will delete the parts of template on accident or get
subform field won't trigger
Hi, I am trying to get a on user input script to copy information from a emergency contact form into the join table that is part of a subform. The master form is Call_Sheet, the join table that is part of the subform is Emergency_Contact, the form where the information is held is in Emergency_ContactsINFO. Basically the alert doesn't trigger which means my if isn't working- and I don't know why. Another user has suggested that it is a zoho area. if (Emergency_ContactsINFO[ID == row.Emergency_Contact].count()
Large numbers on html page display as exponents
Hi Zoho, On my form I get large numbers values (millions, billions...). when displaying those numbers on my html they are automatically displayed as exponents (350000000 displayed as 3.5E+8). How can I make Zoho 1. display the full number 2. add commas for thousands ? I'd like to have 350000000 displayed 350,000,000. Thanks Ravid
Form type icons in Form builder
Hi, Could you put the type of field that each field is into the form builder on the right hand side of each field (just put the icon if you want) so I can see at a glance what type of field I am looking at? It would be really helpful when I am making join tables
Submit form without PayPal if total is $0
I have a registration form created in Creator that has several free and several paid choices. If a registrant's total is $0, how do I set the form to bypass PayPal to complete registration? Here's a link to it: https://creator.zohopublic1.com/heather.hare/event-registration-hsg-2016/form-perma/HSG_2016/TvrjweWR219CJ9PWr6zO3HnVbtZE5CJhgQrq3GTm245p9FF2gJVUeBnE8A2A51YP3HBJZDYQBeV4DhzkG7rUJmtx2YyN6Urb8jzz
Trouble with the total value of a subform.
Hello, I am working in a purchase order form with the following structure. Purchase order: date - date company - text provider - text email - email subform total order cost - currency Subform (in purchase order): reference - lookup to product catalog description - text cost - currency IVA - number cost plus IVA - currency quantity - number final cost - currency I wrote this code in the subform_quantity on user input section. if (row.cost_plus_IVA != null) { row.final_cost = (row.cost_plus_IVA
How do I hide the 'Add' button on reports?
When I want to allow users to add records, I need to copy information from a parent record in the same table. I can do this in deluge using a Custom Action button on each form and the Record ID for the row where the button was. Having the built-in Add button visible at the top of the page is confusing since it should not be used. Thanks!
Deludge script to modify all records in database
Hi, I have added a new field to an existing database and need to populate it based on the value in another field in the same database. New records aren't a problem, but I'm not sure how to run it on all the previous records that already exist. Specifically, I have a new 'Grade' text field (that is empty in the existing records) and an existing 'Standards' text field. I want to loop through all existing records and extract the portion of the 'Standards' field that precedes the '.': Example: 'Standards'
is it possible to embed a subform into a stateless form
Example I would like to create a stateless form to basically create header information for a timesheet application. I would like the information from the stateless form to be applied to each row in the sub form (not stateless) with the add row function. Does this make sense?
Next Page