Android app Customization using SDK
Hello Everyone, I am trying to develop a custom mobile application using Zoho Creator's Android SDK. I am going through the sample application, which was developed using Java + Kotlin + XML . Is it possible to create using Kotlin and compose? Because
Can a form be 'closed' the information retained and the same form be reused?
Hi I have a problem that I am hoping someone can help me with. I'll try to explain my issue as clearly as possible. I want staff to be able to mark what days they can work in the upcoming week I have a form that does this - it has the week days that they
Populating a field with a customers name based on their email
Hello, I am trying to auto-populate a field with a customers name base on the email address which they use to login. The email address they use to login is the same as in their customer details. Their name and email address is on a form, called customer
Set the value of lookup field based on decision box
This really should be easy but im having an issue here. Help will be appreciated because it will solve so many issues for me. I have a form that has a lookup field in it. When a user checks off a decision check box I need to set the lookup field to a specific value. Normally, if i wanted to set a field value I would just use something similar to the following: input.field = "this is the value i want to set the field to"; With a look up field this does not work. How can I set the value of the
Embedded page quarry string
I've build a page in creator where I use a querry string "?ID=XXXX" In my html snippet I can use this with the code NumberID = input.ID; But now in my creator page below the html snippet I want to use an embedded page. This page I would also like to give
How would I pass multiple IDs into a function or report workflow?
I'm currently working on an action item on a report and I'm trying to figure out how to run multiple IDs through it. It should first grab the multiple IDs and then open the stateless form with openURL, and put those IDs in a multi select field. I'm just
How to get the information if a particular Form is opened or not in Zoho Creator?
Hello, We are sending out the Zoho form link via email to respective individuals. Is there a way where we can know if the form link is clicked or not? Thanks.
Filter Pivot Chart by Criteria
Hey There Amazing Zoho Team, I wanted to see if there is a way to filter criteria a "Pivot Chart" report in the same way I can filter "List", "Calendar", & "Summary" reports. Example: I can filter a normal report like this: http://monosnap.com/image/y5q0XGzDSGZpsnOjuBYpdeUOFtSmFd I would like to do the same with a "Pivot Chart". What I've Tried: Filters and User filters are not what I am looking for. That just filters the data. I want to be able to filter criteria the data by connected forms. Like
Google Places API
Hello! In the application I am building I would like to be able to get the Google Places AutoComplete look up for Address. How would I imponent this into a form instead of using the default address field where you manual have to add it in. The reason
Getting a date-time field and returning just the time in a different format
I'm currently trying to write a script where it grabs a date-time field, reads only the time, and changes the time to a new time from a time field. So far this is what I have: eventTime = rec.Start.getTime(); eventTime = eventTime.toString("yyy-MM-dd","HH:mm:ss");
[Free Webinar] Learning Table Series - Creator for the Agriculture Industry
Hello Everyone! 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 by demonstrating how Creator can be used as a solution for various
Problem with record summary send mail inline
Hi guys, I'm having an issue with multiple elements of a record summary not showing up when sending as email inline. [ from :zoho.adminuserid to : SUrec.Email subject :"We value your feedback" message :"" Attachments :template:Send_feedback_email as Inline
[Free Webinar] Learning Table Series - Creator for the Food Industry
Hello Everyone! We welcome you all to the upcoming Learning Table webinar 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
JSON not well formed error
Hi, can anyone tell me why I always get JSON is not well formed error message if I try to create a new contact in Zoho Books with the following code? Error message: {"message":"JSON is not well formed","code":1038} response = zoho.books.createRecord("contacts", "123456", { "contact_name" : input.first_name, "company_name" : input.account_name_company, "contact_persons" : {{ "salutation" : input.salutation, "first_name" : input.first_name, "last_name" : input.last_name, "email" : input.email, "phone"
What does this error mean?
Can someone please explain what this error means when I try saving my deluge script?
Add a portal user form within an app.
Hi, Is it possible to add a portal user via a button from within an app? I tried some code from ChatGPT, but unsurprisingly it didn't work. I want to this as a time-saving measure, i.e. one customer can have a different role and be able to allocate
Map with "\" when adding text variable
Hi all, I'm trying to create an invoice on Quickbooks from Zoho Creator using the intuit.quickbooks.create deluge command. How it's supposed to work is that the user selects all the Invoice lines from a report, and then it clicks an "Invoice" button that will execute a function to create the Invoice on Quickbooks. To get the Invoice Lines data I'm using the following code: //Generate Invoice Lines InvoiceLines = Map(); LineNum = 1; AllLines = ""; for each line in getRevenues { InvoiceLines.put("LineNum",LineNum);
Error: Improper Statement
My Code: htmlpage Frame(Display_Booking) displayname = "EmbeddedView" content <%{%> <div elName='zc-component' formLinkName='Display' params='zc_Header=false&zc_SuccMsg=Data Added Successfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&Display_Booking=<%=Display_Booking%>' >Loading Form...</div> <div elName='zc-component' viewLinkName='Booking_Summary_Report' params='zc_Header=true&ID=<%=Display_Booking%>'></div> <% Userselectedid = input.Display_Booking.toLong();
Loading multiple images efficiently in Zoho Creator
I have an app in creator that is linked to a report template in Zoho Writer. One of the fields is a sub-form just for uploading images. Upon successful merge, the images uploaded through the sub-form will be arranged as a table with single column in the
How can I access associated form data using JS (trying to build a widget)?
I have a widget page that offers a detailed view of a record of my Projects form. I have other forms associated with the Projects form and I wanted to display their data as well. I have tried doing it like this: document.getElementById("Assessment_Date").textContent
How to create a budget remaining field
Hi all, I am trying to figure out a way to display a field that takes a total budget figure and subtracts it by all the associated records with that specific tag to have a remaining budget figure in the budget form. Budget Form: This form is where the
How to push item name from Zoho Books to Zoho Creator using Custom function?
There are multiple module in Zoho Books, Suppose I need to push data of Estimate into Zoho Creator, I have created similar form in Zoho Creator as well as I made a connection with Zoho Books to Zoho Creator. I am able to push other data except this Item
How can I display lookup field data on a widget page?
I have a widget page that offers a detailed view of a record of my Projects form. I have other forms associated with the Projects form and I wanted to display their data as well. I have tried doing it like this: document.getElementById("Assessment_Date").textContent
Undestanding execution limit
Hi, i'm trying to understand the execution limit on creator's function. So, take a look to this screen: This snippet work. But if i add: i reach execution limits. Also if a wrote ONLY if (condition) {} this if gives to me an execution limit error. But
Issue with Embedded Report Not Retaining Filters/Sorting/Grouping on Refresh
Hi, I’m encountering a significant issue with embedded reports. While filters, sorting, and grouping are saved in browser cookies and correctly applied when reloading the page, this functionality doesn't work for embedded reports. It seems that embedded
Detail View Layout - Reorder Block Option
Dear Creator Support, Would love to have an option to drag/drop the Blocks to reorder or add new blocks. It's a big hassle having to delete all the existing blocks to add new fields/sections to the Detail View, then re-add the previous information.
Why am I getting this error?
Can someone explain why I would be getting this error?
Zoho Creator Widgets - Do we have any option to test the widgets in Local Server?
Our current process We make changes in the widget code We pack and upload to Zoho creator then we do the testing after adding to the page. Is there any option to test this from local server? Thanks
Auto remove corresponding record from subform report
I have a main form with a subform in it. So lets say I make an entry in the main form, and make two entries/rows in the subform and hit submit. Now, the subform report should have two entries in it. But now, if I go back and edit the main entry and remove
What does this error mean?
Can someone explain what this error means when I try to update my deluge script?
api criteria Question.
https://creator.zoho.com/api/v2/customer.service_americaship/zoho-test-bed/report/Package_to_Shipment_Report?from=200&limit=200&criteria=Package_ID==“184063” && Shipment_ID==“83676” 在上面的链接中,&&条件不起作用,如果使用AND则不起作用。
Reorder blocks in Detail View
It's been a long time in coming, but I'd like to thank the Creator team for finally allowing us to drag and drop blocks within the detail view. It's not a great new shiny feature, but it's these little improvements that make working with Creator a more
Button in Subform
Hi, How is it possible to get a Button from a Form Report in a connected Subform (see Screen Shot)? Thanks Marcus
Show/Hide in Subform
Hi, I want to hide/show the fields inside the subform. Hide works perfectly on load but show action doesnt work it says "Invalid task in Subform action". Code: if(Job_Work_Challan.Accessories = "Cartons") { show Job_Work_Challan.Quantity ; show Job_Work_Challan.Dimensions_Cartons ; } wherein Job_Work_Challan = subform Accessories = checkbox Job_Work_Challan.Quantity & Job_Work_Challan.Dimensions_Cartons = Both single line fields which i want to show.
ID's become incorrect when exporting via csv
I have an application where I am exporting a view that has multiple ID's from several forms. When exporting the data via csv, the ID's are changed and are no longer unique. Yet when I export via "speadsheet" (xls) the ID's are correct. This is a similar issue that we had with the api a while back. I'll paste a link to that thread below. https://help.zoho.com/portal/en/community/topic/api-calls-on-a-combined-view
What happens to my current site SEO if i opt for zoho creator?
I have an existing website and I need to use Zoho creators for the rapid creation of my webpage creation. Currently, my IT team is creating the web pages, but I am concerned about the SEO of my current website if I shift to zoho will i loose it all?
Month/Year Data Format
I want to create a date field that only displays Month-Year. I believe the format would look like this: MMMM- yyyy. For example: November- 2017 The date formats in the general settings always has month, date and year. Suggestions? Thanks, David
Open multiple views
Hi, I need to open multiple views. More precisely, I have a button which should generate multiple views, one for each value stored in a list: for each supplier in suppliers { sURL = ((((("https://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/#View:Order?progID=") + input.progN + "&supplier=" + supplier); openUrl(sURL, "same window"); } With "same window" it opens only the view corresponding to the last value. Instead I need a view for each "supplier". Could you help
Prevent deletion record if there is connected records
I want to prevent deletion records, if there is connected records in any other Forms or Apps in my solutions
Subform scrolling problem on iPhone
Hi! I created an app with creator. Everything works fine except for subforms on iPhone (they work OK on android). A chunk of the subform stays in place, and the scrolling seems to happen behind it. I attached an image to show what I experience on my iPhone
Next Page