dynamic dropdown
I have a dynamic dropdown but i want to add a search function to it, It's possible?
Pivot Tables: Associate data shelf with different rows
I would like to have my Updates column relate to "last modified" while my New Issues relates to "added time". Is there a way to do this in the same pivot table? In the example below, I want the number 8 to be on the month Apr because all my updates were during the month of Apr. The example below shows that 3 updates were in March because the record was created in March. I need to see the sum of updates that happened within the listed month. https://creator.zoho.com/appbuilder/joeybuck/host-care-managment/report/Month_to_Date/edit
Fetch record referenced to on another form
Hello, I have three forms in my application: "Projects", "Contacts", and "Activities". On my project form, I associate every new project with a contact. On my activities form, I want to be able to pull up a list of all active projects via a lookup, choose one, and then display that project's contacts details (e.g. full name). How would I go about doing that? Activities Form Lookup -> Project A -> Project A Contact Record -> Full Name Thank you!
How to set different logo in different Customer Portals under the same organization account
I think that my question is not supported for now. We have 2 working companies under the same organizational account. We have also created 4 applications (2 for the one company and 2 for the other) and we also use customer portal for these apps. My question is if it is possible to have different company logo in each application. 2 applications with the one logo and 2 with the other. I think no, as it is not possible to manage 2 companies under one organization account like Zoho Books for example.
report on creator
hello india ! I have created several reports based on different part of a same form Is it possible when i edit (update) a report to show only the corresponding part of the form without showing the entirer form? thank you in advance
Multiple Payment Methods
I am setting up a registration form for classes that we offer, and I'd like to give people the option of paying either online with PayPal or with cash or check at the event. Is there any way to do this?
Run script On Load of application?
Hi! I would like to run a script when the application loads. If this is possible, how do I accomplish this?
Exporting to spreadsheet creates duplicate lines
Hi! I have a client who is exporting a report from Zoho Creator. In the Creator report, there are no duplicate lines. In the exported spreadsheet, however, there are (very occasionally) lines that are duplicated. Has anyone else experienced this problem? Thanks!
Auto populate form based on dropdown selection
Hello all, Thank you for taking a moment to read my request for help. It has been a few years since I have worked in creator, so please be patient. I have a form named Build_Sheet where several values are entered during an assembly process. Such as serial numbers, configurations etc. I have a second form named Data_Collection where additional information is stored about the equipment in the Build_Sheet form. Workflow is as follows. Assembly builds a new tool comprised of multiple serialized
Sending cv's to zoho recruit by e-mail and create the candidate
Hi all, I would like to know if its possible (and what will be the process) sending cv´s by an e-mail account to zoho recruit and create the new candidate by that. Thanks in advace. Pedro
HTTPS in iFrame not working
I am trying to create an iframe of the page of my gmail. But I cannot do this. Why? I have experimented with "www.zoho.com" and I can click on everything without having problems except when I click "access my account" then the iFrame goes blank. How do I fix this issue?
Show a specific report when application loads
I would like to show a specific report (calendar) when the application first loads. I have 3 main menu items positioned at the top of the application.These each have links under them to pull up certain reports. I know you can change the order of the sections, but in this case I do not want to. My 3 main menu headings are: Patient Information Calendar Reports The Calendar report does not have any drop down links. The other two do. I would like the Calendar report to load as the as the default
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
Next Page