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
How can I make when a person enters a report are hidden / display fields depending on which report is?
Hello everyone, I have like 7 reports, and in every report so i want to show/hide the fields when the boss enters to edit the report depending what fields i show in the report. something like: I'm the boss, so I have permission to see all reports, and if i go to the report 1 the fields that have to show will be "field1", "field2" and if the boss go to the report 2 the fields that have to show will be "field3", "field4". so "field1" and "field2" will hide how can i do this?
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.
Adjust Quantity in lookup record based on quantity selected in parent record
I would like to adjust the inventory quantity of a product based on the quantity selected in the parent Order form. is this possible? If so please explain with example code or concept. Thank you!
How do implement my Zoho database in my Wordpress webpage?
Hello, Me and my fellow students are working on a project for school. We've made a database using Zoho creator. We are trying to link our database to our Wordpress webpage. We want the filled in data on our webpage to be updated to our online Zoho database. How do we make this possible? Do we need certain plugins or upgrades? Kind regards, Koen
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.
Custom Themes
Hello, The custom themes do slow down the responce time of the form very much. Even a small change causes this effect. Haddo vuputten
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
Zapier Authenticating
When trying to authenticate my connection between zapier and zoho I receive the above error. I've generated a new authtoken but for some reason I receive invalid ticket id?? Any ideas? thanks in advance
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
Why appear in the report the total of the fields disoriented?
Here is the total that is disoriented:
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
Transfer of applications from creator workspace to developer workspace
For the past three weeks I tried to get my applications transferred from my normal creator workspace to my developer workspace. The sollution from customer support is to export as ds file and import resulting in the loss of all my records in the applications-database. Please provide a sollution because I am seriously frustrated with the situation.
Next Page