element positioning
Hi , I have selected two column in my application. Now after inserting some elements in the left column I want to position an element in the right column adjecent to specific element. Only problem is the space above is empty and any element inserted in column 2 gets positoned to the top. How to solve this?
RMA TRACKER
Is there any way something in Zoho can be setup so that I can issue and track an RMA?
Retrieve associated field in nested lookups
Hi I have a a set of nested lookups in forms: Country Region (with Country lookup & filter) State/County (with Region lookup & filter) I have another form Profile on which I have a State/County lookup. When a user selects a State/County, I want the associated Region to load into a regular input field. So if the user selects Nottinghamshire, East Midlands appears in an input field. As Region is a lookup inside State/County form I can't access it the same way as I would do other fields. Can you help?
break one field into many
I want to split one field into two.How Can I do that : for example I have a field name Company Name: Kader rahman tonmoy I want to split first word under FIrst Name and rest of the string under Last Name Like below : First Name :Kader Last Name: rahman tonmoy How can I solve my problem or Which string function I need to use?
Embedded URL Row Limit
Hi, I was using the "Embed to Website" link from a Application generated report to provide a feed for a Power BI report. This appears to be working great except that I only seem to be able to pull out the number of rows that are displayed on the first page of my report. I have 200 Rows visible on the first page of my report, but there are 357 rows of data in total. When I pull the refresh of the data to my report it only gives me the latest 200 rows. Is there a way to have the embedded report to
Webhooks - Update Creator Record from ZOHO People
Hi All, I have a CREATOR application that gets populated whenever a new Employee Record is added in ZOHO People. I have used Webhooks and Creator ADD API for this. It works fine. Now, I want to UPDATE the Creator Record whenever the Employee Record is Updated in ZOHO People. I have used Creator UPDATE API. It does not seem to be working fine. I am getting the below Error, that says no CRITERIA is specified. <response><result><form name="E"><update><criteria>null</criteria><newvalues><field name="Email"><value>krithika@langoor.com</value></field><field
Paypal Within the Portal
A few years ago, there was a problem where Paypal payment notices were not getting back to forms in the Portal. So if the form connected Paypal and the user made a payment, the On Add/On Success event of the form did not know that the payment had been made and never completed the transaction. Does anyone know if that has been fixed? Can I put a form that uses Paypal in the Portal and have it receive Paypal notices reliably? Thanks Jon
Build contact manager in Creator
Hi, I want to replicate Contact manager in Creator. That is I want a vendor page that I can link multiple contact records to. What is the best way to go about this? Thanks
deluge statement execution limit
Hi. I have function: float z(float k, float g) { // size = XS and 6 s = 0.0; if ((input.k < 700) || (input.g < 700)) { s = 6; } // size = S and 8 else if (((input.k >= 700) && (input.k < 900)) || ((input.g >= 700) && (input.g < 900))) { s = 8; } // size = M and 10 else if (((input.k >= 900) && (input.k < 1100)) || ((input.g >= 900) && (input.g < 1100))) { s = 10; } //size = L and 10
Change portal name
Can you please change my current workspaces http://creator.zoho.com/workspace/valeriano.bonacina to http://creator.zoho.com/workspace/bcccarugateinzago is it possible?
Timesheet Totals
Hi you clever people We have a form TIMESHEET with the following fields TIMESHEET_ACCOUNT - (Lookupfield ACCOUNT NAME field from ACCOUNTS Form) TIMESHEET_START - Date/Time Field TIMESHEET_FINISH - Date/Time Field DURATION (h) Formula field - ((timesheet_finish - timesheet_start) / (1000 * 60 * 60)) timesheet_transferred_to_accounts - Decision Box Is it possible to have two read only fields in our ACCOUNTS Form as follows: Hours Billed - which provides a dynamic total of all the durations where
How to populate a drop down field with data from last two records fetched from another form
I just don't know why this does not work. I'm fetching all the records from form "Received_Ingredient" in which the "Grains" field is "Rye". I want to populate a drop down field, "Rye_Lot_Number" with the "Lot_Number" in the latest two records. I think the last two records will be the first to be fetched, but if not I can sort by a date field in each record. This won't compile without error. count=0; for each delivery in Received_Ingredient[Grains="Rye"]; { if(count<2) { count=count+1;
does the strings in Zoho Creator starts with "." ?
I am trying to get a number from US Format "11.11" to European Format "11,11" using strings and the built in function: "replaceFirst". However I found an interesting behaviour: tmp_string_price_ = "abcde"; tmp_string_price = tmp_string_price_.replaceFirst("c",","); returns "ab,de" as it should be however tmp_string_price_ = "ab.de"; returns ",b.de" Correspondingly, it seems that an "." is found at the first position, even if is not what I have stored in that string. Obviously, with numbers
updating data from a field in child so it appends to a field in parent
Hi, Is it possible in Creator to write a Deluge script that will over write data in a field in the parent with up dated data from the mirrored field in the child? I am bringing in data, from a lookup, into the child record. I have created mirrored field names in the child form and the lookup deluge script functions as expected. If the data changes in the 'Remarks" field of the child record I would like to over write the data in the "Remarks" field in the parent on save and on edit... How best to
Migration from zoho.eu to zoho.com
Hi, I hired a developer to create an app in creator, and it worked perfectly but I needed Zapier integration, which is not available on Zoho.eu, so I migrated to zoho.com and imported the app. However the app is acting up whereas before it was fine. The issue is an autonumbering system that is now listing as "NULL" when before it was working fine. Anyone know what the issue could be. Zohosupport sucks crap, I had to migrate everything myself, took them 3 days to NOT DO anything about it, and I´m
301 Moved permanently
Creator cant export to PDF , 301 Moved permanently
Session Variables in Zoho Creator
Hi, I want to set some session Variables for a user using the Creator from a particular IP Address. For example Zoho.ipAddress is a session variable I want something like user.key Is it possible?
list separator
Hi, I am using below function and it contains a list variable by default list separator is comma (',') but I would like to use other separator in list like # or @ .. So how can I do that so the content in list variable will be separated by "#" or "@" instead of "," see below function : void API.Conver_MasterLineup(string mrkt, string lineupID, string lineupName, string lineupType, string ProviderName, string ProID, string SerArea) { lineID = List(); for each rec in lineups_Zipcode[Market == input.mrkt
Login User Profile
Good day its possible to get thru deluge the current login user (customer) profile name? Thank you,
Criteria for: date_field = ONLY 3rd month from today
Hi, I am using total_for_May = FORM [date_field in 3 months].sum(total_field) to sum all the total_fields only in May. But this criteria also includes the 1st and 2nd months. What is the criteria for ONLY the 3rd month? Also, I would like a solution that only takes up one line of script because I am planning on doing this code 12 times (1 for each month) I tried balance_2month = New_Invoice[Date_Due.getmonth() == zoho.currentdate.addMonth(2)].sum(Balance_Due).round(0); But this returns null
How to auto populate based on previous field entry from linked lookup?
Hi, I've got 3 forms, Customer, Product, Quote Quote is comprised of Lookup fields Customer.Name, Product.Name and I want it to get the Product.Price field from the Product Form. So to generate a quote I will only need to select Customer from a drop down, select Product from a drop down, then the price of that product I've selected will be automatically filled into the third field. Any ideas about how to go about this, it seems a simple thing to do but I have limited experience with the scripting
Unable to update multi-select field from another form's "On Validate"
Hi Zoho, I have a form with a multi-select field. This field contain nothing, and populate on load of the form. When trying to updating its data from another form (UpdateMe is the entry, MultiSelect is the field, Test123 is a list of strings (currently containing only 1 spot) I get the following: Error in executing On Edit - On Validate script. Error. Error in executing IF rule : Error in executing If block. Error in executing Iterate List task. Error in executing Update Record task. Unable to update
Zoho Creator - Embedded - Zoho criteria -
Dear Team, Can anyone suggest the solution for below use-case . Use case Model I am using Zoho creator for Form - data entry User Login in Zoho creator via Customer Portal self registration mode Populate Data from creator to Zoho Reports and do all analysis and generate dashboard in Zoho reports Use "Page" component in Zoho creator - embed "Zoho reports dashboard"". End user can now view "Zoho reports" embedded dashboard in Zoho creator page What we could not achieve ? We are unable to restrict
Creating and using reports
I am very new to Zoho and Deluge but I am finding this to be an excellent resource. I am a Workplace Chaplain and have created an application to track Prayer concerns. I have been able to create some basic reports which allow me to filter by work location or action needed. But I would like to have a "dashboard" type of report that will give me record counts of newly added records on a month-to-date basis. I do not want the record or any content iterated, I just want a number. My question seems so
the latest date
hello there :) I have got a little problem, something i can't find out I would like to code in terms of deluge the following : " Find the latest data submitted for this field" in order words, my criteria must based on the date of submission. ( fetch) thank you in advance
I wish that when you click a record in a report, were redirected to a PivotChart report with the corresponding information to the registry. How can I do that?
Dear, I have a simple report with data from enterprises (customers). And I wish that when you click a record, a button or a link, were redirected to the report where I have a chart with the information about each customer bought goods in certain countries. This: Could someone help me please? I don't know if I can explain it. Any questions please let me know. I thank you very much.
Associate two form entries via a number field
Hi I have two forms, Membership and Payment. Both forms have a Membership ID field and the Membership form contains Payment as a subform. I want a person to pay their membership entering their Membership ID. On success the Payment form should compare the Membership ID of the entry to Membership IDs in Membership and add the payment record to the correct member in Membership (in the subform). Basically I need to associate a payment with a member via the ID. ID is just a number field (can't be a lookup
Adding images
Hi everyone I would like to know how I can add images to my form from my computer when i create the form. Thank You
How to divide 24h in 5 minutes and add them to a dropdown
I would like to create a dropdown with 5 minute options like 00:00,00:05,00:10....23:55 I do not want to keep these values as records and then to fetch them using a lookup field as it will keep hundred of records in my database. Except of I fill it with the 'for' loop and using ui.add but without keep these values in the database. Just only to load these values in the On Load. Which is the easiest way to fill this dropdown? Via deluge (if it is possible) or will I add them one by one? If there is
Selecting records based on a dropdown
I have two data sets (reports), properties and bookings. I want to create a form that uses a dropdown to select a property (from the property report) and then have all the bookings (from the bookings report) for that property displayed. I know I can do this by searching but can I do via a form? I'm new to Zoho Creator today so still trying to find my way about.... Thanks!
How to show a hidden single line field by a multi-list selection?
I want to create a form with a hidden field that is only shown when a specific selection is made in a multi-list drop down box. Say the list is of choices of what the customer is contacting me for. Their choice is not in the list, so they'd choose "Other". When "Other" is selected, a single-line field is shown. I've been able to hide the single-line field, but when i have not been able to make it appear with the "Other" selection from the drop down box.
Sales Order Items to Creator Form
Hi, I am looking to see if I can transfer the items on a sales order to a form created in creator using tick boxes Example, we sell a basic pizza with various topping. The products on the sales order are Pizza, topping 1, topping 2, topping 3, etc. Can Creator take this information and populate the form as a Pizza with check boxes ticked if a topping is on the list? Hope this makes sense. Thanks Richard
two lots of data to import
Hi we currently have one set of data in creator (customers equipment) linked back to our zoho crm via contacts name. We would like to import a set of data into a second form (service calls). these are currently in zoho crm and are also linked to contacts name. the aim is to be able to print service sheets in creator for customers showing the site engineer the equipment and previous service calls for that customer. I am at a loss on the best way to create the link between customers equipment and service
ListB = ListA updates list ListA when ListB is updated,later on the script!
Hi Zoho, On my script I have ListA ={1,2,3}; ListB=ListA; ListB.removeelement(1);%> <%=ListA%><br> <%=ListB%> I get: 2,3 2,3 Instead of 1,2,3 2,3 Please fix? thanks Ravid
Reset Subform Items when re-selecting Parent Form
Hi, Currently my current form for RECEIVE part of Inventory Management has the following structure: Suppliers (Lookup) Items (Subform) - Product - Quantity [Default = 0 rows] Now, the Product dynamically populated from Suppliers with the following code in "Item --> On Add Row" prodlist = Add_New_Product [Suppliers == input.Supplier]; clear row.Product; row.Product:ui.append(prodlist.ID.getall()); which works fine. My question is 1. Is there anyway to populate
Beautifying Zoho Creator forms
Hi I've been working with Zoho for a while now and one thing I always find is that the forms are just FUGLY. But I was really impressed by this one: https://www.zoho.com/creator/help/getting-started/register-with-zoho.html Can anybody share the code for this, or something similar, so I can see how it was done? Also very glad to receive links to any other beautiful Zoho Creator forms others might have produced.
CRM Task Question
Hello everyone, Based on what I have read in here, I may be one of the few people on the messageboard who aren't super experienced with coding. I am learning bit by bit, though. I'm posting here because I'm trying to get a handle on the different tasks associated with the CRM field. For example, I have read the articles on searchRecords task for the CRM, but there are still gaps based on the examples that they give. In the example, it's already predefining specific data that you know will be looked
Merge 2 Calendars Together
How can I merge 2 calendar reports together?
Captcha and Zoho REST API
I am new to Zoho Creator and I wanted to use Captcha screens in my form validation settings and make a HTTP POST request to Zoho REST API in App Inventor 2 to add, delete and update records. What link name do I need to use for the verification code in my requests - VerificationCode and captcha didn't seem to work? If I use a web viewer to view the Captcha image in a published form can I use its value and pass it as a parameter to a separate POST request to the REST API?
Sales Funnel / pipeline report
Hi! I would like to know how can I create a sales funnel report using Pivot charts. I haven't found any information related to Zoho Creator and when I try to do it myself, I choose the sales funnel graph and it starts to load but nothing happens and the chart goes back to the previous chart format. We have a grupo of predefined sales stages and I would like to show something like: For the current month: - Stage 1 -> 50% leads - Stage 2 -> 30% leads Something like this: Any information will be welcome
Next Page