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?
Dropdown reversing the order in report
Hi, We have developed a catalogue publishing database that includes a list of colour options for each product. The list is populated by a Multi Select field from a pre determined list of colour options. I have specified Alphabetical order for the list. When editing the record the colours appear in ascending alphabetical order, however when exporting of viewing the record the list is reversed. It is important for the catalogue that the colours appear in ascending alphabetical order. Is there any way
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
Ask the Expert 5: 5-hour live discussion about integrating payment workflows to your apps.
Hi everyone, As you might already know, every application that you create on Zoho Creator can be connected with other services — be it a Zoho product or a third-party service like QuickBooks, Zapier, or PayPal. In this upcoming Ask the Experts, we would like to address all your questions related to integrating your Zoho Creator application with a payment gateway like PayPal, Razorpay, Authorize.net, and more. In this session, we would cover the following topics: How to configure payments using
Split Multi Select Fields from a form into separate rows on the report
I have a form that I'm using as a class register to record who has attended a particular class session. I have added a script to pull a list of students based on a selection of the type of session. The list of students appears in a multi select field and then you just deselect the students who weren't in attendance. What I want to do is add a script so that when the form saves it adds a row in a report per person in the multiselect field along with the other single fields in the form. I then need
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"
Set default value for a subform field
Hi, I am using the subform field by setting default entries as 3(i.e for displaying 3 rows). And I need to set a default value for each row while loading. How can i acheive this?
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
Pivot Report - Form & SubForm Data needed
I need to generate a pivot report based on the data from a subform but I need the ability to filter on two fields from the main form For example: Form A contains 2 keys fields: Store Store_Number SubForm A - Store_Name = Store - Store_Number all numbers needed for pivot report I created a pivot report based on SubFormA but I need the ability to filter on FormA Store & Store_Number Any ideas how to best accomplish this?
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
Conditionally Required Field
I'm trying to conditionally require two fields to be filled (ie, not EMPTY) BEFORE a specific lead status is used: on validate { if ((input.Lead_Status == "3. Qualified Lead") && ((input.Forecasted_Monthly_Revenue == "") || (input.Forecasted_Hourly_Rate == ""))) { alert "enter BOTH Forecasted Hourly Rate an Forecasted Monthly Revenue"; cancel submit; } } This code sample is as close of a mirror as what I found in the documentation here: https://www.zoho.com/creator/help/script/app-builder-deluge-scripting.html#fieldmandatory
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.
using zoho.loginuser to restrict views
I have an application for employee data and am trying to restrict the view so that the logged in user can only view his/her record. I think I've done it fairly simply by doing the following: Create a field in the employee record called Username and populate this manually with the assigned username Set the Criteria for the view to Username == zoho.loginuser (I seem to only be able to set this properly by editing the script itself, otherwise Zoho adds " " around zoho.loginuser) The view then only displays
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
Fetch last record based for reporting
Can this be done? Please advise...Thank you! payment table: customer, billing code and payment information I need to fetch the last payment made into "Payment_Details" by customer AND each billing code for reporting so basically for each customer I need to get last payment made in each billing code I have many iterations of the code below and it's not working properly. IDList = List(); IDList.clear(); for each R in Payment_Details [Customer_ID ==input.Customer_ID] { PRec
Concatenate issue
i am using Zoho Creator to mark the attendance for my staff: Form: Attendance_Form - has the Field:Employee_Name (its is a lookup field from Form: Employee_List Field: Staff_Name) i want that when i select the name of staff from Field: Employee_Name, it should Concatenate the name of the employee with the Field: Date_Field (with is also in the Form: Attendance_Form) Example: if i am marking the attendance of "09-11-2018" (DDMMYYYY) for Staff "Mark Rogers" then the output of the concatenate function
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?
Update a field in second form from Look Up
Hello I have 2 forms that have a relationship through a lookup. I am trying to update a status field to complete when that record has been looked up. The lookup field is looking up an auto number from the first form. Can someone guide me on this Thanks Amanda
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
Add note/ description to CRM contact via Zoho Creator
Hi, I want to add a new note to a Zoho CRM Contact via Zoho Creator. I have tried different versions of the following code on "on success": crmResp = zoho.crm.updateRecord("Contacts", input.Zoho_CRM_1, { "Description" : input.Info_02 }); But it doesnt work. Could anyone give me an advice on what the problem is? Thx Bo Thygesen
Currency Field Formatting
Howdy - Seems simple. I added a Currency Field to the Form. However, when in runtime, the Form isn't formatting the field as currency ($#,###.##). It's instead (#####.###). How can I get a Currency Field to format itself on the screen as Currency? Thanks for your help - R
Images in JSON REST API
Hello, I developed a contact-like form using Zoho creator and I access the content through a view using an authtoken and JSON. I have an image field in my form and this field is set to appear in the view I use. However the data that I get does not make any sens in the context of JSON because I get an HTML IMG tag. Furthermore, the url of the image in that tag is relative. So to actually get the url of the image I would have to parse the HTML then contextualize the url, but this won't work because
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
Next Page