left expression is of type BIGINT and right expression is of type STRING and the operator == is not valid
Hi, sorry for my English it's not soo good. I have one problem, I have one form with a single line field call "Title"and a subform(Task) in the same form, in the subform I have a Look up field call "Name", I try to put the data of the single fiel "Title" in the Look up field "Name", and I get this error: In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator == is not valid This is my code: temp = Project[ID==input.Title]; row.Name = temp; Please help
Updating a Field in Another Form Based on the Input of Another Form
Hi, I'm facing a challenge when trying to create an app to track how the members of my sports team perform over time. What I'm trying to do is to record all the games and the players involved in the game and how they perform in that game (goals scored,
Retrieving HTML field input to change a href value on a button in an HTML snippet on a page
Is there any way to achieve this? Please let me know, I have desperately been searching for a solution
Zoho Creator - [Free Webinar] Creator Tech Connect - Technical Series - Session 4
Hello Everyone! In the past few months we conducted extensive sessions on Deluge inbuilt functions and Canvas builder as a technical series in Creator's Tech Connect. Its incredibly important for a developer to understand the functions, syntax and most
How to modify options for Approvals
Hi, I have created a form in a Zoho Creator solution. Approvals for the form was automatically added by Zoho Creator. It has a feature with two options - Approve and Reject, using which I can either approve or reject a submitted form. How can I alter
Pass parent form values to subform fields
Hi. I have a order form with a subform. The items are as follows: ・department(dropdown) ・name(dropdown) ---subform--- ・date ・product name(lookup) ・name(single line) ---------------- The name field in subform is automatically entered the name selected
Zoho creator send the generated pdf from zoho creator pages via sendmail
Hello, I want to send one form report as pdf via sendmail function. The problem is that this pdf I want to generate using the export and pages template from zoho creator I mean the PDF received from the link, for example https://app.zohocreator.com/export/.../quontation-system/pdf/quontation_view?qt_id_str=3661979000001045002 quontation_view is the HTML template by creator pages that become the ID as paramenter for one Form_Report and generate the pdf page for this ID. But I dont undestand how to
limiting decimal places in a formula field
I have a formula field that calculates a percent. I'd like to limit the result that is displayed to two decimal places, but can't figure out how to go about this. Using decimalplace=2 (as shown here https://www.zoho.com/creator/help/script/expressions.html) doesn't seem to work. Is there another approach that will keep me from getting insanely long numbers like .2398759845?
Zoho Creator's panel suddenly stopped working?
So I have a couple of panels in my page that counts the number of times a text appears in my form. Previously it was working fine until I started using a page variable for one of the new panels. Then the previous panels stopped working with the error
Can charts in Creator pages have two separate series of data?
All the icons for adding charts to Creator pages show two coloured series of data. But I can't see how to create a chart with two separate series. My choice is between a Web chart, which only seems to show one series, and a Stacked Web, which takes two
Viewing details for : maximum Customer Portal User
We have recieved the following message : Hi there, You have reached 90% of the maximum Customer Portal User permitted for this account. View here Upon reaching this limit, the associated actions will not be permitted in your apps. We recommend that you
Customer Permissions
How can I restrict records access for customers? Right now, customers in the portal can see everything another customer enters. I want to set permissions so that customers only see/edit/add their data, not anyone elses. I can't do that in the permission
Zoho Creator - [Free Webinar]Learning Table Series for Agriculture
Hello everyone! For the month of September - Bringing on to your table - Zoho Creator for Agriculture 12 Months 12 Industries Agriculture Industry The agriculture industry is the backbone of our food supply. It encompasses everything from planting crops
Code that insert attachment to zohobooks expense
Hello there, i already did code to insert attachment into zoho books projects, so i copied the same one and changed the values to expense and it doesn't work, so i need a help to send an image from zoho creator to zoho books expense as attachment, could
Auto populate field when creating new record in lookup field.
I have 2 lookup fields on my form, new repair request form, one lookup field for the customer and one lookup field for equipment. I already have the customer and equipment forms connected with a bi-directional relationship and only the equipment related
Passing a parameter from a URL to a Form in a page
Hi, I can see you can easily pass a parameter from a URL to a form, simply by putting: xxxxxx/?Field_Name=Value I have tested this and it works passing a parameter to a form. I have created a Page, and embedded the Form within that page. The page has
How to create a new sales order from deluge?
I have a creator app that creates a new sales order. For the line items, I'm specifying the product Id, quantity, rate, description, and the item total in the following code. subformRows = List(); subform = Map(); subform.put("product_id", "2728329000000450184");
Is it possible to fetch a list of data based on a criteria?
Hello, I'm new to Zoho Creator, so I'm unsure if its even possible to do so. So I have 3 forms: Form Name 1: F.Forms Form Fields : F.Name Form Name 2: M.Forms Form Fields 1 : M.Name Form Fields 2 : M.Connection Form Name 3: FT.Forms Form Fields 1 : FT.Name
How to create a new record in Zoho Creator via Node.js code
Hi, I am running a workflow via Pipedream and I need to create a new record in Zoho Creator with node.js. I have gone past authentication, but I am very new to node.js coding - can anyone please point me to the right doc/reference how to do it and where
Add Subform Row Into Existing Main Form
Hi, I have a main form A with subform AA. I want to add data from main form B to existing main form A subrows. How can I achieve this using deluge scripts? The current example I see is adding subrow in new main form record, but how do I add to existing
Ticket
I can't find from where I create ticket in zoho creator please give us a proper tutorial on this if you can.
Solution to circumvent API Limit
I have a report (1) for which I make 1 API call to get 200 records. Each record is connected via lookup (2_id) to another report (2). Now I want to get some fields from report 2 for each record in report 1. (without adding every field as a lookup) I tried
Photo Upload Field: Reduce File Size
Hi Zoho Team Do we have a roadmap for this topic to reduce the uploaded file. As of now, we noticed that whenever our Engrs. upload a photo onto our service report app, Creator will retain the original file size. Unlike Zoho Forms, it does have an option
Concern with the Record Template
Hi Zoho Team Do we have a way to have this alignment issue be addressed. Here's an issue when a report been generated back to Zoho Desk as an attachment on the email. On the report, if a page been added tendency is that the alignment was off on the 2nd
Control Over Pre Set Print Settings
Hi, I was wondering if theres any way to have control over the print settings. For example i have two HTML pages that require printing frequently. However they both require different printers with different settings. It becomes annoying having to set
Is creating this Order Management tool possible in Zoho Creator?
Hello! My company is looking to automate our open orders (we still use paper…) and has tasked me with finding a solution. I have worked with Smartsheet and ventured down a few other platforms that have not worked. (Our POS is pretty limited and does not
Create dynamic link in HTML snippet - link change based on form input value
I need to create a page in CREATOR, where there is a form and a iframe below the form. The iframe will show a picture so I need the link to be changed dynamically each time the field input (field name: ClassID) I added the form as usual, then add a HTML
Create multi-value lookup field for recording class attendant
I am a newbie for Zoho Creator and facing an unsolved challenge. In a lesson, the teacher need to record all attendant student (children). These are two requirement: - The student data should be retrieved from ZOHO CRM (Account object) so the teacher
Custom filter with muti select partially working/broken
I have configured a custom filter on my report as <multi select field> does not contain <value from options> OR <multi select field> is null. I have done this through the UI, which leads me to believe such functionality is supported. If I only select
Redirect to Form populating field based on the report item that called up the form
I have a Report named "All Invoices". I have added an Action button to that report that once clicked redirects to a Form "Worked By" where I select the staff that worked on that invoice. That Form "Worked By" has two fields: - Invoice Number (lookup to Form Invoices); - Staff (lookup to Form Staff); Is there a way to pre-populate the Invoice Number on the Form "Worked By" based on the line item on the Report "All Invoices" that caused it to be opened? Thanks, OV
"Copy Link" missing on web?
I see copy link on mobile for a form item, but its not on web?
Error parsing XML List
Hi, I'm trying to parse an XML list the way it is shown in the Zoho documentation. Here is my code: mapvar = getUrl("http://xxxxxxxxxxxx"); xmldata = mapvar.toXML(); strdata = xmldata.executeXPath("/root/value/items"); xmllist = strdata.toXmlList(); for each thing in xmllist { datestring = thing.executeXPath("/items/date/text()"); } When I execute, it gives me an error when it gets to the last line. This is the error: Execution Failed Error details: Error occured while executing
Custom SMTP relays
Hi, It is possible to use a custom SMTP relay server to send out email? Thank you
Redirection in iFrames
Hi, I have a Form which is published. The Form directs to a Page on submission, which is also publushed. When I put the iFrame code provided for the publish Form on a website the Form works fine, however the redirect to the published Page does not work.
Dynamic Lookup boxes?
Hi, I have 2 forms. One is a form of Training Sessions (location, date etc), and a form of Bookings, where people have booked the sessions. I need to create a Register, so another form where attendees can register their arrival to a session. I want the
Zoho creator Integration with Biometric
Hello, Is there anyway to store biometric details for each employee inside my custom made Zoho creator application as a field and then use it to track attendance of the employees, if there is any what device do you recommend to be used for tap-in\out and what api should i use. Thanks,
Page Parameters broken with Page Variable Release
My page parameters are coming through as empty now that page variables have been released. I am unable to use the name of the page parameter to create a new page variable and I am unable to delete the old parameter to free up the name. I have tested a
Track date variable across a page
Hi I'm creating a page that has a few charts that pull data from another table. At the top of the page i have 2 buttons that allow the user to go back a month or forward a month in data that they're looking at and a text field that displays the current
Activate python application
Is it possible for a deluge code to activate a python application ? Say i create a deluge program, in that deluge program, i need it to activate a python application stored on my drive Would that be possible, and if so, what would the code look like
Sending Emails - Creator/ZeptoMail/Campaigns
Hi There, I'm looking for some advice on the topic of sending emails triggered by content in a creator application. We have a customer & order system application in creator and would like to start sending out emails to customers for order confirmations,
Next Page