Adding Data Value to legent
Hi I want to view the data legend on a chart permanently not only when I hover over the chart with the mouse. I'm sure it is something very simple but I am unable to find a solution. I'm using both pie chart and Funnel chart Thanks Amanda
Read USB scale
Any ideas how to read the value from a USB scale and present it on the screen?
Upload output from report to an FTP Server
I need to post data from a report to an FTP Server for others to access without going into app. How can I do this?
Send email with attachment created from filtered results in a report
Hi, The business case is simple, a operator creates leads for different partners, at the end of the week the user wants to filter the report for a specific partner, and with the push of a button a email is sent to the partner, who email address is kept in a table. How can I create a automatic action in a report, that sends a email to the partner email address with a attachment that contains the results filtered in the report? Best regards, Rui
Creator with integration field to CRM Contacts (or leads,etc)
Hi. I am still struggling with this issue. I have an Integration field on a creator form, which is linked to the Zoho CRM, Contacts module. It is providing a list of emails from different though it does not matter what field I am looking to use for the selection.) The dropdown list for this integration field will never return the complete list of contacts (emails from the CRM). It will only ever list the first 200 (or 20, if you write deluge script to perform the action manually). It seems there
CRM Contacts and Zoho Creator
I would like to link one of my forms with a contact in CRM. I've made an Integration field but it let me show only one field, so I've choose Last Name. Unfortunatelly it's not enough to identify a contact. I also tried to make a custom field in CRM with a formula containing both First and Last Name, but it seems Zoho Creator doesn't let me to use custom fields on Integration fields. Any other idea will be welcome, thanks in advance!
merging records
hello I have a requirement that sometimes more than 1 person will record the same incident, I want to link these records or merge them and use the first record as the main one with the other records linking to it. Is this possible? Ultimately I would like to say this incident has been reported X Number of times? Thank you Amanda
long number show as 2.98342E+18 on exports!
Hi Zoho, On a form I have a field containing a long number (like the Zoho ID). when exporting the form to CSV, it looks like 2.98342E+18 and all the last digits become 0000 (it rounds it up....) how can I prevent this? thanks Ravid
How to open a selected form, from a report window using script on a specific button click
Hi, I am developing a sales management app. I have New_Purchase_Order form and All_Purchase_Orders Report. I want to add a status change button which will change the status of the selected form. But at a time I need to input some details based on the status. So I need that selected form to open in edit mode while clicked on "Change Status" Button. Please suggest the best way to do it. Thanks in advance.
Strange problem (bug?) with drop down
I have a dropdown field in a form which contains 10 choices but when I access the form only 8 are showing. Even stranger, when I mix up the order of drop down items, I still can only see 8 but the ones that are showing change. Is this a bug? Any ideas?
Set filter in look up in sub form based on parent form input
I have a Purchase Order Form and Purchase Order Items form. Purchase Order items is a sub form in Purchase Order. I have Supplier in the Purchase Order. In the Purchase Order items, i need to show the Products based on the Supplier selected in the Purchase Order. I am not able to set filter condition based on input.Supplier. Let me know if this can be done.
Adding and deleting records-automated
so...I have a script written: when a subform for a record is updated in form A, it will reflect in record B. so: without condition-form A deluge script on success: for each rec in Direct_Carriers { fetRec = Add_Carrier[ID == rec.Carrier_Name]; x = fetRec.Direct_Agents; x.add(input.ID); fetRec.Direct_Agents=x; } for each rec1 in Shared_Carriers { fetRec1 = Add_Carrier[ID == rec1.Shared_Carrier_Name]; y = fetRec1.Shared_Agents; y.add(input.ID); fetRec1.Shared_Agents=y; } for each rec2 in Restricted_Carriers
Problem with Lookup Fields with Filters in Mobile App
In our app, there are many lookup fields which are constrained by a filter at design time. However, with our recent upgrade to Creator 5, these lookups no longer function properly in the mobile app. Instead, the dropdowns display no values when selected. In the browser, these fields work fine. To work around this, I have modified the On Load scripts to manually populate the lookup fields with the correct records. However, this code has the unintended consequence of calling the "On User Input"
FYI: Form-mobile permalinks are not supported in C5 and will break on upgrade. Any potential workarounds??
Really wanting to switch to C5 but I just found all my published forms using the form-mobile to be mobile optimized will NOT be supported and will break on upgrade. Any ideas from C5 users? Is there anything such as CSS styling or any other new features that could help with this?
Add brackets to last field in
I have been searching and can't seem to find if it's possible to add brackets to a Display Field. I have attached an image to help show what I mean. For instance: Customer Name (Company Number) Sorry - the image has gone huge
Weird function behavior
I think possible your platform have a bug... one out of the lines below does not compile: string2 ="2018-03-11 02:17:17"; info string2; info string2.toTime(); //this line does not compile; very very strange string3 ="2018-03-12 04:15:17"; info string3 ; info string3.toTime(); Can you investigate? I am on C4 not C5.
Fetching Data Into a second form
I have a New Form which looks-up the ID from another form to create a relationship. I then want it to pull in data from the other form to fill some of the fields on the open form. I have tried writing the script in various ways but it keeps throwing up error in line 1 or 2 (if I leave the ; off the end of the first line it throws up an error for line one and if I include it as per below, the error is on line 2: if (count(Students [ID1 == input.Team_Member_ID]) >0); { getrecords= Students[ID1 ==input.Team_Member_ID];
Paste into Date-time field
I have the Spreadsheet view of a form open. I need to paste in 100 date-time values for a date-time column. But it's not working. Is this by design?
Want to use image as a option instead of dropdown, checkbox etc
Dear zoho help, i want something just like this in zoho creator I want to select any of the image how can i do this?
Can I pass multiple values for one field in an openURL statement?
Is there a way in an openURL statement to pass more than one possible value for the same field? Example: I have a report that lists companies by territory. I know how to open the report to show all companies in Kelowna (Territory_fld=Kelowna) and I know how to do the same showing all companies in Penticton (Territory_fld=Penticton), but how do I open the report showing all companies in both Kelowna and Penticton?
Filter Returned Lists in Creator
Hi All - I'm looking for an example of how to filter the results that are returned from a CRM module either in a drop down field using a deluge get statement or using an integration field. I feel like this should be something that is possible but for the life of me I can't figure it out. We are developing a Creator portal Application for our Reseller partners to log into and communicate requests and updates directly to us. Example 1: View Potentials that the logged in user is associated with:
Zoho/Mailchimp integration
I'm trying to figure out how to use an existing zoho webform to add a user to my mailchimp marketing list. I'm sure there's something I'm missing - but if i create a "subscribe to our newsletter" checkbox on the form - I want it to automatically add to mailchimp. Is this through a workflow rule? Thanks
Select customer by email HELP PLEASE!
Hello. I am new to Zoho Creator and the Deluge language and I really need your help. I installed the Order Management app. The New Order form, a customer can only select their name using a lookup field which shows all customers in the dropdown. Since our customers will be ordering online, this will not work because we don't want to show all of our customers in the dropdown. We want the customer to enter their email address and have the app to search for the customer in the Customer database using
Integration field for Customer Records - look up by first AND last name.
Hi team, Many months ago there were several threads regarding the fact that integration fields for CRM contacts can only show contacts' first OR last names, which is useless for real-world applications. Worse, using manual code to fetch a list of contacts for a dropdown field was limited to 200 records. I seem to recall Zoho said they would modify the integration service to allow the field to display BOTH first and last name in the pick list. Can I please get an update on the status of this?
How do I edit zoho.loginuser value
I use the `zoho.loginuser` in deluge script if statements and somehow my `zoho.loginuser` was changed and now my app behaves incorrectly and I did not personally change this value for `zoho.loginuser` and everywhere I look I cannot find a place to edit it. How is this value accecced and how could it change if I didn't do it?
Restrict record view based on user
Hi! I'm currently using the trial version of Zoho Creator as I assess the possibility of using it for our program management. We have a group of consultants that meet with clients across the province, and I would like to be able to set up an App that houses all of our consultants information (including allowing them to submit expense reports, scheduling information etc.), and I want to have another App that has our client information, each client being assigned to a consultant. Is it possible
Deluge IDE, intellisense, crtl+S save, etc. not working
Deluge IDE, intellisense, crtl+S save, etc. not working. What's up?
Round to 1 decimal place
I have a function field to convert Centigrade "C" to Fahrenheit "F". The conversion calculation is simple: "input.TemperatureC * 2 - input.TemperatureC * 2 / 10 + 32.round(1)" but it displays as 2 decimals. I only want one decimal rounded correctly. I know I can achieve that by converting to text but do not want to go down that route. What am I doing wrong? Or, if I am not doing anything wrong, how do I accomplish my requirement? I am using Creator 5.
zoho.loginuserid VS zoho.loginuser?
I understand that zoho.loginuserid is the Email address of the logged in user and is null for a public user. I also understand that zoho.loginuser is the User ID of the current user and is "Public" for a public user. I'm concerned that since email addresses can change over time, my views will break if I use zoho.loginuserid. So, is it best practice to filter views with criteria like Added_User==zoho.loginuserid, or Added_User==zoho.loginuser ? Thanks, Jeff
How can we make the magin on top adjustable
Hi, Im developing an operating tool and UI is really important. I found that the space on top of the application is to big, probably by reducing it we could gain some screen space. Is there something that can be done?
Fetching Records from another Applciation
hello I am trying to fetch records from another application Current application name is SMAT Application trying to fetch record from is HR Training, below is what I have tried but getting an error on the first line. x = hr_training.employee_details.employee_name[ID == input.Employee_Details]; //input. refers to fields in current form input.Email_1 = x.Email; Any Help would be greatly appreciated Kind Regards Amanda
Fetch record not working in subform
Hello I have a form(child) called Training Attendees and a (parent) Training Details The fetch record works when in the training attendees form but it does not work when being used in the subform. Can anyone help me with this Thanks Amanda
Schedule on Workflow not picking correct records
Hi I am new to Deluge and I was assisted by one of the Call Center guys to create a Schedule in my workflow. The schedule works fine except that the records that its emailing to my clients based are not correct. I have a date-time field. Based on the date-time field, i would want records only for THAT date and not to include records from the previous days as well. Below is the deluge script. Pls assist if(zoho.currentdate.getDayOfWeek() != 1) { sendmail [ from :zoho.loginuserid to :zoho.adminuserid
zoho.books.getRecords dropdown get items from Books
Hi For an order form i am creating i want customers to be able to select the items i have (in Zoho Books) to be shown in a dropdown list. Is this possible by using the zoho.books.getRecords or by an API? I checked the following article but with no luck. https://www.zoho.com/creator/help/script/get-records-zoho-books.html#Example Kind regards Kevin
Change Form Title on Edit
Is there a way to change the title of a form for each individual record when editing? For example, if I have a form to add employees, can I have that employee's name listed at the top of the page if I ever go back to edit their record, instead of the original form name? Thanks for any suggestions!
Invalid Authtoken (Code 14)
Hi, I am trying to access contact data from Books from within Creator with the below: I have omitted the organisation ID for zero's for obvious reasons: if(group_client != null) { response = zoho.books.getRecords("contacts","00000000000","contact_name=Gina"); info response; } I keep getting the following message: {"message":"Invalid value passed for authtoken.","code":14} I have tried everything and nothing works... Can anyone help!?
Sliding Commission Scale
Hello All, I have two tables. The first table is my sold jobs and has the Profit Margin. The second table has my commission rates. In this table there are two records. The active commission scale and an inactive commission scale that is not being used any longer, but associates with some older Sales. Each record has the commission rates and the breakpoints . see screenshot: for clarification. The sliding scale works like this: If the profit margin is between 0-20.99% it pays a 2% commission,
Display uploaded image in HTML view
I'm new to Zoho Creator and need help understanding how to render an uploaded image onto an HTML view. I've read other posts and I've tried different things, but I still can't get it to work. Maybe I'm not understanding something??? I have a form with the upload_image field and display_image field with formula (as noted in the forum). I created a List View based on the form and the image renders as expected. Now, on each record listed in the List View, I have a custom action called [View] which
Problem fetching images, and displaying in Creator App
I'm designing a mobile interview process application for my school system. Applicants can add a photo to their registration, but getting their uploaded image to display in another form was problematic. Instead of just displaying the image field value, I had to use: person.Portrait.replaceFirst("sharedBy","[MY USERNAME]").replaceFirst("appLinkName","fcss-job-fair").replaceFirst("viewLinkName","Registrants_Report").replaceFirst("fieldName","Portrait"); This allowed me to display the image in a Notes
Creating a custom page
Hi there I have a report called "All Transaction List" which lists all transactions including date of transaction, chart of account code, Dr and Cr amounts. I now want to create a Profit and Loss report using this information. So I am trying to create a Page for that. I have written some code for doing that but it gives me errors when trying to save it. Can someone please help me with what I am doing wrong in that code?? The error shows up in line where the Myfunction is defined? It keeps saying
Next Page