In zapier get lookup field as string.
I am trying to Zoho with Zapier. I am setting a filter on a lookup field. But look field showing a record id instead of actual string value, so in Zapier i am unable to match value for the filter. For example in filter:- if look_field_name = some_string then add record to google sheet.
on integration zoho creator to zoho books for transfer the data creator to books in items module , how to push the unit field (lookup) data(name) zoho creator to zoho books in (Unit field) . Pleas
Resolve soon
Circular Math Calculation Formula
Hi i have a need to do a rotational calculation between a set of values FOr example Lets assume the below values assigned to the Location Location-A= 1 Location-B=2 Location-C= 3 Location-D= 4 Location-E= 5 IF I PASS a query asking : what is the distance
Image Display in HTML Page in Portal
I have an HTML page that displays an image from the database. It works fine when outside of a portal. I want to put that HTML page in a portal but I cannot get it to display the image. I get the broken image symbol when I try to run it from inside the portal The code that works is below. The input.property is the record ID of the record that I want to display and comes across from a stateless form that is used to open the page. I moved the stateless form and the HTML page into the portal and
Updating a Multiselect Lookup Field
I'm currently trying to update a multiselect lookup field in a record, but it's giving me the error {"code":3001,"data":{"ID":"3268991000041877010"},"error":["Invalid column value for Staff"]} . I've tried the list method and the collection method. The
[Free Webinar] Creator Tech Connect series - Active Directory and SAML Authentication
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
Help with Workflow to include subform attachment
I have a Form Release_Drawing and another form Drawing_Files Drawing_Files has a file upload field named File_Upload I am using the Drawing_Files as a subform in Release_Drawing form. The name of the subform is Drawing_Subform The user typically fills
Seeking Advice on Implementing Subscription Verification in Custom Zoho Creator Application with Zoho Subscriptions
Hello Zoho Community, I am currently developing a custom application using Zoho Creator and Zoho Subscriptions and need some guidance on managing user subscriptions effectively. Current Workflow: Users create their password. Users complete their individual
Get a random record
With the introduction of randomNumber() fetching a random record is as easy as: //fetch records myRecord = My_Form[ID != 0]; //check if records exist if myRecord.count() > 0 { //get ID list idList = myRecord.ID.getall(); //fetch random record randomRecord = My_Form[ID = idList.get(randomNumber(idList.size() -1))]; }
How to edit related block tables in canvas?
i am creating a canvas that uses a related subform as a table, but the table columns are all the same width reguardless of data and it makes the table very long. is there a way to set the column widths like we can in record templates?
Updating data in one form to another form using Subform
Hi, I have problem, i can update data to another form. But just using standar field. The question, i want to update data to another form using subform. I want to update JUMLAH base on BUKU. Thank you ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Update Subform record into another form
Hello All, I am trying to update the subform record into another form Following is the code i have used: for each rec in Accessories_Inward { fetRecFrom = Stock[Record_ID == Record_ID]; fetRecFrom.Item_No=rec.Item_No; fetRecFrom.Quantity=rec.Quantity; } whereas, Record_ID = Unique Identification code to recognize the rec i want to update Accessories_Inward = Subform of the Main form (not linked with any other form) Stock = Form where record is to be updated. Now the Problem is When there are multiple
How can I print comments.
Hey guys, a few hours ago I started building a Student registration form, and I saw that you can print out the Report for that form, as in select a specific "Student" that was added and print as summary, however I also noticed that the comments that you can place on those students didnnt get printed, is there any way to accomplish printing a Student report with all their data alongside the comments that I have added to it?
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
How to get data from certain fields in one form to another form
Hi my query may sound simple but it is stumping me! I have several forms one of which is called the 'organisation mastersheet'. In this form I have a column named 'organiser name' and in each 'organiser name' record I want data to appear from a seperate form called 'organiser management' (contact name, email and telephone number) instantly as it has been fed into the organiser management' form. So when entering the name, email and telephone in to the 'organisation management' form when I switch to
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
Allow uses to clear out URL Filters
Users link into a Zoho Creator report via URLs. These URLs have filters. Something like: https://creatorapp.zoho.com/acct_owner/app_name/#Report:SomeReport?SomeField=123 This is problematic. The report (default list view) does not indicate to the user
Application is Not Showing Data Properly
Hi everyone, I will be grateful for any help I can get on this issue I have been unable to resolve. Context - This application I'm working on was built years ago by someone who has left our organisation. I do not have any coding background and experience.
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
New to Zoho Creator
Hi all, I'm new to low code platforms. I've written an application (a statistical model) in Javascript. I want to develop some additional components in a low code platform such as some basic screens with a user interface and a database which will store
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.
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
Multi language support for Notes Fields and Published Forms
We just upgraded to take advantage of multi language / translation support, and have the following questions: 1. The "notes" field does not appear to have translation support. Is there any workaround? Our forms included instructions using "note" fields, and we want to have these instructions showing in the appropriate language. Is it possible to display/hide note fields based on the language setting? 2. On a published public form that is embedded in a webpage, is there any way to have the user select
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
Minutes / Hours DELAY IN ALL OUTGOING MAIL
All my outgoing mail has been lagging by minutes / hours (randomly) or sometime 12-14 hours delay. and i can receive some email as normal (receive 1-2 minute after the script sent email) It's not very certain. When will there be a problem. Some days there
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"
External data sources in Zoho Creator, powered by Zoho DataPrep
We’re thrilled to announce that you can now expand your data connectivity capabilities by integrating external data sources with Zoho Creator with help of the new Zoho Creator connector within Zoho DataPrep. This exciting feature allows you to connect
What does this error mean?
Can someone please explain what this error means when I try saving my deluge script?
Field/Column Width in Subforms
I am new to Zoho. So far I have like all, but I am having difficulty with the limitations of the sub-form paradigm. Is there a way to set the column/field widths that are displayed in a sub-form. It seems to be forcing equal field widths, and I can't find a way to change. If i set the pixel width in the originating form, but those default back to mandatory widths when displayed in the main form. Thanks in advance for any suggestions.
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);
How to Upload Report in zoho drive from zoho creator as a pdf
Hi, I am using Zoho Creator and am sending an email to the customer with a copy of its record Now I want to upload this pdf file into Zoho WorkDrive how do I achieve this?
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
Next Page