Best way to display API data within a Creator Page?
I'm trying to build a Page that includes: statelessFormA w/ Lookup and text fields, a report view, and a section containing data from an API call. I've got statelessFormA and the report in place and the report is updating based on my inputs in the stateless
OpenUrl Button in Report not working when embedded in Page
I have a reportA with an action button that opens a reportB in a pop-up. It works when using reportA in stand alone mode. But when reportA is embedded via iframe in a Creator Page, the button does not work, I get the "failed to retrieve this report" message.
Registration forms
Is there a way I can specify that a field on the registration form is required so that the form cannot be submitted when there is no information entered for that field?
How to get zoho.loginuserid or loginuser in JS SDK Widget in Creator?
I want to use zoho.loginuserid and zoho.loginuser variables inside my JS widget. How to achieve this? Keeping in mind that these 2 are very important variables. Would parsing as parameters be an option?
Like Operator
What exactly is the "Like" operator in the report search options used for? I want to not have to use exact wording when searching a report. For example, if a field contains 1/2" Ash, and I search Ash 1/2", I would like it to still find it. I thought the
Skipping rows with certain empty column fields .csv upload in Creator
Hi, I have a script that parses data from an .csv file upload and pushes the data into a Zoho Creator Form. The script below is supposed to assign "0" value to the empty fields and delete them from the upload if they match the criteria. Unfortunately,
Stateless form on-click of custom button not doing anything, mostly.
Can functions be called on click of custom buttons in stateless forms?? I have: input.note_field = thisapp.function(input.field1,input.field2) and nothing happens, but this very function runs on user input of any other field in the form. I've tried something
Zoho Creator - Extend PowerBI connector to Excel
Hi, The Zoho Creator PowerQuery connector for PowerBI is great. This could be extended to PowerQuery for Excel which would be equally useful. At present I am going Creator -> PowerBI -> Excel and would love to be able to skip the PowerBI layer. Chee
Using Macros to Open URLs
Hi there, Currently, I am trying to use the Macros tool on Desk tickets to provide more information outside of our Zoho Desk environment. Is it possible to open say, a Zoho Creator form from pressing a macro button on the ticket? I've tried using "openURL"
Simple math return wrong result, or I am wrong somewhere?
Guys, please see below, am I wrong somewhere?
Display a Sign-up form on first logon
Hello, I am working on a customer portal and would like to somehow conditionally display a form (can be stateless) to a new user only on their first login or until the complete the form to collect more information about them, which I would then use to
Can you access mobile Cliq app from mobile Creator app?
I'm currently making an edit to the page where someone clicks a name and it takes them to their chat/profile on Cliq. It currently works on browser, but if they were to use the Creator mobile app it opens up it's own browser instead of the Cliq app. Here's
Vertical Continuous Scroll Calendar Report
I'm assuming there's no way to do this, but I thought I'd ask just in case. Is there any want to make a calendar report that has all the months on one page, or like all in line vertically so that I can just scroll through the months instead of having
Link to an individual record from related block on detail view of another record
Hi, I'm new to Zoho Creator, so excuse the beginner question. I have two forms -- Clients and Staff. I have lookup fields connecting the two forms, so that each Client can have multiple Staff records associated. From the detail view of each, I would like the ability to link to the other. So, if I'm looking at the detail view of Staff #1 and I see that she words for Client A, I would like to be able to click on Client A and go directly to the detail view/page for Client A. I would like for the
Subform of subform in layouts or record template
I have a form that has a subform with parts that also have a subform. Say I have a work order object, with part objects as a subform or lookup, and the parts just have a normal subform non-linked with two fields(operation, and runtime) Work Order ----Part(link)
How calculate total of rows from a subform in the mainform?
Greetings. I would like to calculate the total of the rows from my subform in my mainform. It is a screen to add transactions, so I have: Mainform with three fields: Transaction Type, Transaction Category, Transaction Amount Subform where each row has: Item Description, Item Price, Item Qty I would like that on each row added in the subform the field Transaction Amount in the mainform be updated with the total. Thanks in advance.
zoho creator customized report - web print not working gives a blank page
When I try to print from the Custom Report or as pdf it is blank If I use the URL to print same thing
Display Submitted Form Results
Hello, After someone submits a form I would like to immediately display the data that they just submitted so they can print out, etc. I don't want to display all records in the database, just their particular submission. Please help, thank you.
How do I change the size of an image that's fetched via API?
I'm using a Notes field in a form to build a table of API data, including images. Since the size of the image is embeded in the URL that's being fetched, is there a way to resize them? So, I basically have this: tableData = collection(); for each id in
Update Related Records - Need Deluge Assistance
Thank you in Advance. I know enough to be dangerous - and i need help with a Deluge Script. I have two forms that are linked. Client_Details - (One to Many) - Associations I need a way to update specific fields on all of the related Associations when
Add multiple records from another form - deluge help needed
I know enough to be dangerous - thus i can't seem to figure out what i'm doing wrong here on this script. It won't let me save, saying error in line 1. Any help is appreciated for each fetchrec in Client_Details [(Status == "Customer") && (Status == "Pending
Record-Edit view in Page
Hi, I've been looking around but haven't found a solution. I'd like to have a page that displays a record in record-edit mode. I've tried an iframe using the structure below, but the app menu shows. https://app.zohocreator.com/<app_owner_name>/<app_link_name>/#Form:<form_link_name>?recLinkID=<record_ID>&viewLinkName=<report_link_name> I've attached a picture that shows this problem. Any help on this?
Using Zoho Creator Widget JS API with External Widget
Hello everyone, We are willing to use Zoho's Widget to serve an already published external website. The reason we want to use this external link inside a Zoho Widget is to use Zoho Creator Widget JS API to use Zoho itself as a data source for part of
Needing help with coding workflow
I'm not great at coding and haven't been able to get a lot of help. I'm struggling to get this coding right and nobody has been able to solve it yet. I will try to summarize and explain as best as I can. We have a parts form with all of our parts that
How to find out Leap year using Deluge Script
We need to find out the given year is Leap year or not in some calculations. any one Suggest ways to find leap year via script or any functions in the Deluge Platform. Thanks & Regards Thisai Moorthy.
Basic API Help
I've been learning Creator/Deluge for a few years. I don't have any other development experience, so I might just be in over my head right now, but...I think I've made a very basic API call from Creator to the music database Discogs.com. I can select
"Multilevel" lookup
Hi, I'm dealing with the following scenario: -I have a form to manage customer registry, containing fields like name, surname, telephone, email, etc. -Another form is used to manage contracts. Here, I input contract data and reference the customer using
Zoho Creator - [Free Webinar] Creator TechConnect Series - Customizing mobile applications in Zoho Creator
Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
[Free Webinar] Learning Table Series - Creator for the Logistics Industry
Hello Everyone! We welcome you all to the upcoming free webinar - Learning Table Series. The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience
Item Quantity
So, I have a form to take orders. I would like a dropdown/multi select to select the items the customer is ordering. I need a way to also specify the quantity for each item they are ordering. What is the easiest way to do this? I have about 85 items to
Auto Number Field
I would like to have an auto number field in my form that automatically resets back to 1 when it reaches 31. Or, if I can't reset an auto number field, is there any way to do this with a number field and a deluge script?
How to mass update field in one form with information from another form in Zoho Creator
Hi, We have a database in our Zoho Creator app with thousands of records. We have a 'Waiting List' form for children who register for our programmes and once they are enrolled (there is a button that 'enrols' them) they are pushed through to 'Students'
Zoho Creator Widget readFile API is Responding with the Outdated File (cached file)
What is the issue: - The download API is responding with an outdated version of the file (cached file). How to replicate this issue: In a form with a file input, upload a CSV file. Download the file using readFile method. Replace the file of the same
Ability to define Custom Filter as a parameter in the URL
I would like to be able to construct URL in such a way so it applies predefined Custom Filter, which should be supplied as a URL parameter. Hypothetically it should look something like that: baseUrl?CustomFilter=my custom filter At the moment this is
Is there a Deluge way to DUPLICATE or COPY a record?
I have a need to duplicate a record from inside a Deluge script, and then modify one or two fields in the duplicated record. Is there a facilitated way to duplicate or copy a record in Deluge without having to manually do an Insert Record and set each field value, which is extremely tedious on long forms? Thank you. Datazen1 datazen1@gmail.com Santa Fe, New Mexico US
Endless loop after open a report on successful form submission
Hi there, I usually add records by clicking the "+" button from a report view. On successful form submission, I can open a report at my preference (example "openUrl("#View:Sales_Closed","same window")"). It works well. However, when I add a record directly
List function not working as expected, no idea why not
I'm trying to feed in a list to a function, perform another function on each item, store the results in another list, and then return that second list. However, all I get is the results from ONE item in the list I'm inputting, not the whole list of results. Can someone help? Here's the basic function idea: list myFunction (list firstList) { secondList = List(); for each topic in input.firstList { x = thisapp.anotherFunction(topic); secondList.addall(x); } return secondList; }
Multiple event dates on Calendar report.
So, I have a form that has 9 different date fields. When I go to create a calendar report, it only allows me to select a start, and an end date. Is there a way that I can just have it show the job name on each of the 9 dates specified in the form?
"Code sign failed" when trying to download Zoho Creator application as Android Mobile App
Hi All, I'm trying to download my Zoho Creator 5 Application as an Android Mobile App. I fill the form with keystore credentials, package name, Firebase config, FCM server key. After clicking "Code Sign" button the process of generating the mobile app seems to be started. After some time when I refresh the page I get an error "Code Sign Failed", "Error occured while connecting to the server. Please try again after some time." I have already tried couple times with same result. What could be the reason?
Marking records that haven't been update on a specific date
HI, I'm building a Creator app, with 2 forms "Work Orders" and "Helper". Every day, an excel sheet is uploaded / imported to the Helper form, where each row is added as new record. One column of the excel sheet is a unique number "WO number" and is saved
Next Page