SaaS :: Building a Recurring Revenue SaaS business with Zoho Creator...
HI folks, for the last 2 years I have been building SaaS apps for various hyper niche industries using ZC (Zoho Creator) I have developed a whole heap of short cuts and libraries for the development plus a number of marketing resources that you can use for actually selling the solution to multiple new clients... Is anyone interested in learning about how they could leverage their current ZC skills and projects and turn them into money making SaaS apps? Just message me if you know of someone that
Importing from Excel - Phone Number mapping error
I'm trying to import a phone number and keep getting the mapping error : "'Number' column is mapped to a 'Phone' field" or "'Text' column is mapped to a 'Phone' field" I have refined the phone field so that the country code will automatically pull from
""a specific field" does not exist in this form" Deluge error message
Dear all I can't see what's wrong in the line 18 of this portión of code in a "on edit/on load" form action. i would appreciate any advice 1 hide ConceptosdelDM.Documento_de_medici_n; 2 disable ConceptosdelDM.Total1; 3 disable Total_Habilitaciones; 4 disable Total_DM; 5 defaultnumber="4500056465"; 6 if(input.Orden_de_Compra == null) 7 { 8 Orden_de_Compra = Orden_de_Compra[Numero == defaultnumber].ID; 9 } 10 filas = (ConceptosOC[Orden_de_Compra == input.Orden_de_Compra].Concepto_Facturable).getall();
Pivot Tables report problem
Hello, I pressed Regenertate on my pivot table report page and now it's stuck for over 2 hours. "Regeneration has been initiated for this report. You will be able to regenerate again when this process is complete" Can you help, please? Thanks,
IOS ‘Tab’ key
I’m currently building a app for customers to fill out their details and there’s a lot of fields for them to go through, they’ll be primarily be using the application on iPads using the creator or customer portal iOS app. I’ve noticed in testing that
Creator: How to add subform row to main form with deluge
We have a stateless form named "Bulk Schedule Jobs". When this form is submitted, it loops through existing account records that match the selection made in the stateless form, then it creates a new record in the system via the "Add_Job_Form". Essentially,
Update Date
I am trying to use a start date (manual entry) for a program "Start_Date" and add 6 weeks to the start date to come up with an end date "End_Date". I want this value to update all of my members in a report so I can see who's program is ending soon. I
Pivot Tables problem
Hello, I pressed Regenertate on my pivot table report page and now it's stuck for over 2 hours. "Regeneration has been initiated for this report. You will be able to regenerate again when this process is complete" Can you help, please? Thanks,
Reorder a waiting list
Hi guys, I'm new to zoho creator and I'm struggling to find why to reorder a waiting list I have. For example I have these records: Positon, name 1, dave 2, steve 3, bob 4, clive 5, phil What I'd like to be able to do is to move Steve from position 2
Cannot see multiple forms when creating new report
Curious if someone can help explain. I have 3 forms in one of my databases. However, when I try to create a new report, it only lets me pull from one option. Am I missing something?
HTML Snippet - Section that occupies same space but appears based on what is pressed.
Hi, I am fairly new when it comes to working with HTML script. And I know javascript isn't something that works within a HTML Snippet (at least as far as my own experiences go anyway). Something that I need to script in, is a section that appears and
Converting Estimates into Invoices using a report action - Calculating Subtotals
I am trying to create a report action or button to convert my estimate into an invoice. I have everything working up it will not calculate the subtotal and grand total after it is converted. Any help or suggestions would be appreciated! Here is what I
Creator: Using stateless form to pass page parameter
I'm trying to filter a report on a page via the page parameter, but am stuck. I made a 1 minute video below showing the issue: https://www.loom.com/share/35446dcf5ec74f62ae9b49a2e6e7f355 Can anyone see where I'm stuck with this video? Thank you for your
Creator Super admin - Need to deactivate my account.
I am the Super admin in Creator I Need to deactivate my account and give all permissions to another in my company however i cannot change from Super admin. I need to change this today as my billing renews tomorrow.
How to share records
I've created a data sharing rule where one role can share a specific set of data to another role, but I can't see how to actually share an item from the UI and can't find anything in the documentation. How do you share the individual records with another
How to get permanent API Key
Hi, I've read over the API OAuth documentation (https://www.zoho.com/accounts/protocol/oauth/ and https://www.zoho.com/creator/help/api/v2/openapi-specification.html) and see that there's a way to generate client id, client secret, and code here: https://api-console.zoho.com/
DS File Import Error - can't edit the script in the browser
I am unable to edit a DS file in the browser when presented with an error during import. For example: Error at line number: 5896 The "from" address can only be zoho.adminuserid, zoho.loginuserid, or a verified email address. Please specify a valid email
Zoho Creator - [Free Webinar] Learning Table Series for Education
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
Setting fields width in subforms
Hello, Please, add extra parameter for form fields: "width in subforms" Especially it;s important for multiselect lookup fields, as it's not very comfortable to select values from narrow list, or when values text are displayed in several lines of drop-down list Thanks
Html View / iframe help
Hello, I would like to some how use this website https://www.randymajors.org/city-limits-on-google-maps?x=-94.8359213&y=38.7401548&cx=-94.8359213&cy=38.7401548&zoom=17&state=KS&onestate=show&cities=show I was able to input the long & lat in the website
Employee Productivity Percentage
Hi, I am really struggling. I have a form, where our employees fill the data in the screenshot below, date, name, task they are doing [product building], how many they built and how long in total they were doing it. I then have a formula to work out how
Finding Duplicate on a for loop
Hi, I'm trying to find a duplicate on a for loop on an index. but getting error. Please help me x = Employee[ID != null && Status == "Active"];
4 y = Time_Log[Employee.ID == x && T_Date == "14 Jun 2023" && T_Date != null].Employee.Name.getAll();
5
Custom order in subforms
Review this please. Custom order on subforms doesn't work. When the record is saved, changes made to the subform are not saved. Happens in both grid mode and list mode
Creator: How to combine two forms into 1 lookup field?
Form 1: Add_Invoice_Form Form 2: Add_Service_Form Form 3: Add_Material_Form Forms 2 and 3 both have a field within them called "Name". We want to add a lookup field (dropdown) in Form 1 called "Service/Material Name". This lookup field should combine
Scanning not available for Cutomer Portal
Hi all, I have created a small app in Zoho Creator where i have 2 single line elements that support QR and Barcode scanning. If I access the application through the Creator mobile app as a Zoho user, then I am allowed to scan as i get the relative icon
Iconos en Botones de Informes
Hola. A modo de sugerencia para futuras actualizaciones de Zoho Creator (a no ser que ya se pueda y no sé como hacerlo), sería muy interesante que en los BOTONES que podemos crear en un INFORME, en vez de mostrarse un texto identificativo pudiéramos poner
How to open record template in a new tab
Greetings i have a report that i want to add a report action to to open record template of the desired record in a new tab (or popup window), is there a way to do that? thanks
Footer and Page No not taken in Record Templates while send as PDF attachment
Hi team, We have Added Footer and Page no in HTML Page. When we access it on page and make print then it will display. but same code added for Records Template that to send as PDF through email in attachment, but the footer/page no will Not added. How we can do ? because no of pages will be there.
Update related record in Zoho Creator
Sorry if this is an obvious question, I'm starting to work with Creator and there are things I don't understand in the docs. I have two related forms. Each record in form B has a field to connect it to a record in form A. The relationship is one-to-many:
Zapier integration Name Field
Hi, I've done plenty of integrations from Webflow to Zoho Creator in the past but i'm struggling with this one. I have a form in my Webflow site which captures First Name in one field, and Last Name in another field. I'm using Zapier to push the data
Showing sub-form records in a approval process
Form A is a purchase order with a sub form containing product items related to Form B. I create a approval process for this Form A. But when I tried to approve the form A others have submitted. I couldn't see the sub form content. It only showed the ID related to the Form B.
How to Start Page or Default Page for Customer Portal
Hello, How can I set the Start Landing Page a Zoho Creator App client portal accessed via mobile? I am currently seeing sections. Thank you!@
Create Multiple Filters for Report Based on Customer Profiles
Hi folks, I am currently building a creator app for order delivery. I have two profiles for the customer portal, Admin and Driver. We have a delivery report to keep track of the delivery. Here is the question: Without duplicating the reports, how can
Fetch data
Hi, I am trying to do the following. I have developed a plant database where I want to create an observation record from a plant record. So when in the plant record I click 'Observe' (Havainnot) which opens the Observe record. I want it to automatically
Set expression for formula field on Zoho Creator
Hi guys, I am stocked with an apparently simple formula that should calculate the time between a “start time” and “end time” fields. Can some one please share some ideas to solve this? The formula field should calculate and show the time in hours and
Zoho Creator Upcoming Updates — May 2023
Hello everyone! We're back with more monthly updates after a short hiatus. During that time, we've been hard at work improving the user experience and adding new features to our platform. Today, we're pleased to announce a wide range of fascinating new
Creator: Calculating and Recalculating Sum of Two Subforms
We have a form with two subforms within it. I’m trying to run a loop through both subforms to calculate the sum total in a field that is separate from both subforms. How can I calculate the sum total of all “Rate” fields within both subforms? Also, I
pop form in a report action buttin to update a filed
Hello i know i am missing a simple thing but can someone help i have this (Update price action button ) in a report named Hold_item with this code inside the workflow openUrl("#Form:Update_Hold_Price?Cartlow_FBS=" + input.ID ,"popup window"); its suppose
Access subform fields from a lookup field in template records
greetings I'm working on a record template for a form where i have a look up field which allows access to a subform in another form, now i want to list that subform fields in a table, but i'm not able to find anyway to access any of the subform fields,
Creator Pages : URL actions in panel using parameters
Is there anyway to set the URL action of a panel to include a page parameter ? I have a parameter of "Sector" so how could I get the following URL to work : https://MYSITE.zohocreatorportal.eu/#Report:all_carbon?sector=Sector I've tried sector=input.sector
Next Page