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();
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
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 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
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
Attaching deal emails to a deal record in Creator
I'm developing a customer portal using Zoho Creator. In the portal, my customers can see all their deals. One of the things I love about Zoho CRM is how it collects all the emails related to a deal on the deal record. I want to add that same functionality
Issues Fetching Emial ID in a sub form using a fuction in delgue
Hi All, I have two forms: Form A and Form B. Form B is a subform in Form A. In Form B, I have a lookup field (Action For) from another creator application. I am looking to populate a field (Email ID) in Form B based on user selection in the Lookup field.
Is possible to populate the values for many fields in openurl?
Hello Team, Hope you are well...! We need to pass the values to the particular form fields via open url as popup window is this possible to populate the values from the functionality. Thanks in Advance, Thisai Moorthy.
What is the purpose of CANCEL SUBMIT?
I have been researching the Alert command for use in a script. The documentation says the syntax is alert "type your message here!"; cancel submit; But you can only use Alerts on "Validate, on Load, on User Input" and you can't use cancel submit on "On Load or On User Input" BUT you HAVE to use cancel submit on "On Validate" or else "On Validate" will ignore it. AND when you use it with "On Validate" you don't get a pop-up box with your alert message and the option to "cancel" the submission or
Zoho Creator | Auto Number
Hi this is working but is it possible don't update the one autonumber field if it's not selected. latestDP = Client_Submit_Card[ID != 0].maximum(DP_Auto_Number); latestJSP = Client_Submit_Card[ID != 0].maximum(JSP_Auto_Number); vendorsValue = input.Vendors;
Publishing in a specific language
Is it possible to have a "?lang=XX" paramters in the URL to force a published form/page/report in a specific language? (Zoho Analytics can do this)
Add to picklist dynamically in a subform
I have a form with a subform The subform has a dropdown field wich is dinamically populated accordingly to a value inputed at a form fieldI have this code triggered on add row event: ListProd = F_Produtos [Fabrica_Produtos = input.Fabrica_Encomenda]; row.Produto_ItEncomenda:ui.add(ListProd.ID.getall()); It works great when i add a row, but if i want to update a row, the script obviously won't run and the picklist shows all the values, not only the ones needed. I guess an "on focus" event would
Next Page