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.
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?
Is there any way to insert arbitrary number of rows in a custom module in one click via custom function(s)?
Hi, I have a custom module called Vouchers which holds number of unique alphanumeric voucher codes for an account. The problem for me is sometimes I might have to create more than 100 number of unique vouchers on one click. Now, when I go to add vouchers from Voucher module and choose the account and enter number for vouchers to be created then entered number of unique vouchers should be automatically created. I am not handy in building custom functions at the moment. However, lets say I grab number
Record Count Issue / Usage Details
Went into our usage details this morning and saw that we had 85,000 records of 100,000 available. In order to reduce the number of records, I did a backup and downloaded and exported the application as a file and then proceeded to delete 2 years worth of our oldest orders in the system to see how much this would reduce the record count. After deleting these "orders" and refreshing the usage details, our record count went UP by 10,000 records to 95,000/100,000. It's not possible that we input 10,000
I want to build a Flipbook App.. Could It Be Done?
Hi, My question is... I want to build an app for a magazine.... So I want that app has a Flipbook inside..... But Not in a HTML space that shows a web site inside the app.... I want it lie Native... I don't know if this could be done with ZOHO templates or if it has a plugin that works like an ebook or flipbook native in the app. Thank you for Helping me, and if you have already done an app like this, gimme your link and i will download it ir order to see how does it works!! Thank you Very VERY Much!!
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
phone number field
I would like to use a phone number field so when I pull the record up on my cell phone, it will be highlighted and I can click it to dial out. Tried numerous things so far and nothing works
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?
COMPOSITE PRIMARY KEY
My form has three fields A,B,C forming a composite key. How do I enforce an "on add" script so mass-loading of data will be filtered: only lines with composite key A+B+C that are unique and not duplicating existing records will be inserted? Thanks! I have researched this before but there seems to be no answer to this questions.
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
Calendar View First day of week
Cannot find how to change First Day of week to Monday in Calendar type of view. Can anyone suggest?
Next Page