RMA TRACKER
Is there any way something in Zoho can be setup so that I can issue and track an RMA?
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
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
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
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
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
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
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
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?
Update Quantity in record of lookup
I have a attached a test application to work out a problem I'm having. As a row item is added to an invoice , I'm trying to subtract the quantity from the underlying lookup record quantity. I attached the code: tempQty = Products [ID == input.ID]; tempQty.Inventory_Quantity = (tempQty.Inventory_Quantity - input.quantity); To the OnUpdate area of input.quantity of the subform. any help would be appreciated ! Thank You. Chris
Unable to import a spreadsheet
Hi trying to import a spreadsheet and keep getting this error: Error in creating the application. Please check if the formulas are applied on compatible data types and try again. There were 3 colums with formulaes in them ( detected as type formula) but are now set to Date.
Auto payments in creator
I am building an app that will take online sign ups and where users can subscribe to services. The app should integrate with Stripe to set up a payment record (user token getting stored to Creator) and charge the credit card each month for the services. step 1: on new user registration through a Zoho Creator form, user is presented with a Stripe form to enter payment information; step 2: after succesful credticard registration, user is sent back to my website. Payment token is stored in Zoho Creator.
Function cannot return String:List ? get an error
Hi Zoho I have the following function returning a list : list Data.TestProjects() { TestProject = List:String(); TestProject = {"ZZTestProject", "XXTestProject"}; return TestProject; } but, on a page, when I try to script ProjList4banner = Add_a_Ship.distinct(Project_Name_TEXT); ProjList4banner.removeall(Data.TestProjects()); I get to following error: Mismatch data type for function 'removeall' at argument index 1 expected data type STRINGLIST found data type LIST for a combined script
Zoho Creator Tutorial Series: Vacation Requests
Hi, I'm working on the tutorial you made (well done by the way!): https://www.youtube.com/playlist?list=PLlC7sQNISSUQb2ikBRmlMRWNtbRpvNKX3 and I'm having problems with the custom actions. When I want to send an automatic email notification and when the request has been accepted or rejected, it works if I "edit" the Vacation Requests Report, but if I just want to click on the custom buttons (Approve, Reject) it doesn't work, the notification will not be sent. Do you know what I can do to avoid
Open url
Hi, I created two pages , want to take print and pdf in a single custom action click. Now, after clicking custom action, a stateless form will be opened and there is a drop down to list the pages which need to be printed and allow user select page and click "generate " button , then page will display in new window and the page itself have a button to"print" and "pdf". these buttons are options given by creator for pages Now,I want to generate all pages into pdf format and print-out in a single
Create a ZOHO app and host it on AWS?
Is it possible to use Ziho creator to create an App and then host it under windows or Linux so I can use AWS?
App Missing
I have an app missing. Hauling Tail Rescue
Customer Portal for application with multiple clients/customers
Hello - I'm building an application that will store sensitive data for several large customer companies. We want the customers to be able to login and see reporting/dashboards related to their info, but obviously not see the sensitive information of the other companies. The information will be uploaded by our team, and not by the customers themselves. Is there a way to associate customers to only their related data, so when they access the portal they only see their information? Is it secure to
Creator Page w/ Multiple Charts
Hello - I'm creating a Page in Creator to show multiple charts to customers. It seems that when you embed a chart into the HTML, the charts are full-width and full-height. Is there any way to limit the chart dimensions, and have multiple charts next to each other (in half-page columns) instead of full-size on top of one another? Also, is it possible to make Pages responsive or is this not supported? If anyone has any Page templates that sound similar to this, would love your guidance! Thanks Brian
Create Google Drive folder after record is created
I tried using Zapier, but it is not fast enough. Any ideas? I want to create a google drive folder after adding a record. Would i have to use API calls for this?
Open URL does not work after success in calendar view
I am using the calendar view, and I have scripted an openURL after success of a record. In calendar view, if i click on the little edit button or click the record, then the edit button, after success, it does not open the URL. The URL only opens if I'm in list view, not in calendar view (or summary view). Why is this happening? This is the report with edit access: https://app.zohocreator.com/deranged/deranged-entertainment/#Report:Add_New_Event_Report
how to set "OR" operator usig URL criteria for a view?
I need to specify criterias for an embedded view using URL. How can I make the view show records matching the criteria Field_A == Value_1 OR Field_A == Value_2?
Need to specify "OR" operator when setting criteria for displaying a view
From the docs: To set criteria for a view URL format for setting criteria with "=" (Equal) operator is given below http://creator.zoho.com/<app owner name>/<app name>/#View:<view name>?<FieldName1>=<FieldName1 Value> &<FieldName2>=<FieldName2 Value> This allows for criteria of the form <criteria 1> AND <criteria 2> as I read it. I need the form <criteria 1> OR <criteria 2>. There's other logic operators listed but no OR. Is there some way to use an OR in this situation?
Spreadsheet View with Sub Forms
Is it possible to use the spreadsheet view with a form and a sub-form? We would like to have the cut and past functionality that the spreadsheet view provides with fields in the sub form. If not the spreadsheet view, any other ideas would be appreciated. Thanks
Sort by returning ID of Lookup Field not Value
Hello, We have a static HTML page (stateless form) that is a report pulling data from multiple forms. a search value is passed from another form to this HTML page. Then we have a variable asset which looks like this: asset = Add_Edit_Assets [Assets_Account_Lookup == search.ID] sort by Assets_Type_Lookup ; Later in the page we have a "For Each" that looks like this: <%for each x in asset { type = Default_Device_Types [ID == x.Assets_Type_Lookup]; manu = Default_Manufacturers
Adding CRM Task from Creator Subform
Hi I am trying to add a Task record to CRM in a Creator Subform when the form action On Success is executed. Its a simple statement x = zoho.crm.create("Tasks", { "Task Owner" : "someone@company.com", "Subject" : "Chase Up" }, 2); This does not work for a subform On Add -- On Success action BUT does work on the main form On Add/On Edit -- On Success action ? Please can you advise why ?
Updating Records of a form based on the input of another form.
Hi, I have a form Product that contains the Product Name and and the Available Quantity. This is added through lookup into a subform in another form. I need to update the value of Available items with respect to the Required quantity in the subform. Any idea how to do that, because storing the value in as it is retrieved is not working.
New to Zoho Creator (non-developer), need some help understanding how to build a simple App
Hello Zoho Community Team, I am a non-developer and wanted to assess the viability of someone like me to be able to create applications without any real coding knowledge. I was wondering if someone could help me create a super-simple application, as I have been struggling for a couple of days to create a very simple 3 page app. Essentially I am creating an interview observation Application. I want the screens to essentiallt look like this. Home Page: ---> Client 1 ---> Observations
Next Page