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
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,
Field Service Management Application
Hello all...I am currently trying to use Zoho Creator to create a field service management ticketing application. I am new to Zoho, and coding in general, and know that I am in over my head at the moment, but this effort is borne out of necessity. Right now I am working on a relational database style diagram on how everything will tie together. I initially thought that everything that needed to be visually present when working a ticket (not necessarily creating a ticket) would be included on a
Deluge Script: Option to copy Rows from another Subform
Hi Zoho Team, Do we have an option to copy existing Field Rows(excluding the value) from a subform to another subform(stateless) on the same form. I hope I make sense :d
Please can we have an edit link when viewing a related form from a list view report?
Its great that a list view can display URLS for lookup field values which give you a preview of the related form. However, without being able to edit the displayed record you tend to have to bring up and other browser window and locate the other record from its dedicated list view report. Ive seen complicated work arounds to bury the edit URL into a field which is the included in the linked record view but thats just nasty IMO. Please could zoho add an edit link into the view record popup.
Click on Table Row to Edit
Hello, I am very new to Creator. Thank you for your help. I created a Report and added several Tables from Related Blocks. I want to be able to click on a row in the Related Block Table to edit the data. I am creating a Sales Pipeline App. The Contact
Accepting Callbacks in a Zoho Creator application
Hello - I have a Zoho Creator application that needs to query data from views (asyncronously) in Zoho Analytics. Using the Zoho Analytics API, I can submit an Export Job that includes a CallbackURL, whereby Analytics will POST to the URL when the export
Do we have an update for Subform Hide/Show function
This gives an error invalid task in subform action - under >User Input of Field
Zoho Creator - [Free Webinar] Creator Tech Connect - Canvas Builder in Zoho Creator
Hello Everyone! Gear up for our next session in Creator Tech Connect Series! About Creator Tech Connect Series Creator's tech connect series would comprise of pure technical sessions in which we delve deep into key essentials and technical nuances while
Drawing
Trying to build my first app, I need to be able to make small drawings/sketches. Is there any way to embed a drawing tool into creator?
C6 - URL Filter for Pivot Tables and Pivot Charts
With the changes in C6 ... is there now available a way to filter Pivot Tables or Pivot Charts using URL criteria in Creator? This would be extremely helpful if we can filter like in Zoho Analytics. Creator is using Analytics for the Pivot Charts and
Hyperlink to local network pdf?
I appreciate that this may seem a strange request but..... Is there a way I can allow users insert a hyperlink in a form field, to a pdf file stored on our local network rather than upload the file? Appreciate that this will mean that users will not be able to see the file when not on the company network, but this is the desired functionality. tried to use the URL field type but this appears not to support the file:/// preface, it almost works but the browser opens without the ":" Hope this is not
Work flow not triggering-- in creator 6
I have an application. It has a Payment received form with the 'Inv/Ret' field, 'Amount', and 'Amount accounts' fields. My requirement:- When 'Inv/Ret' is null AND 'Amount' is not null and 'Amount accounts' is not null. It should send a mail to the login
Zoho Creator - [Free Webinar]Learning Table Series for Trading and Distribution Management + Canvas builder
Hello everyone! Mark your calendar for the next Learning Table Series on Trading and Distribution management + Canvas Builder. What Trading and Distribution management is the process of overseeing the movement of goods from supplier to manufacturer to
"code":2930," when I use creator.getRecords()
id = input.batch_transverse.ID; info id; A = "ID == " + id; response = zoho.creator.getRecords("xxxx","xxxxx","xxxxx",A,1,200,"oauth"); info response;
Chart comparing different filtered records
Is it possible to have a line chart that compares different filtered records. So for example I have a form where a customer can be marked active or inactive. In this form, I have another field which has the month and year that the customer started. I
Inventory SKU barcode printing
Hi I am a developer and am wondering if zoho creator or even zoho inventory have the capability to print barcodes upon submitting a form. I have been researching the forums and have not been able to find any way to do this natively in Zoho. Can someone
Portal and Main environment blueprint stages not aligning
Hi, We have a customer and order system using a portal account for our sales rep's to be submitting orders and customers. We've recently implemented the blueprint feature on the orders as order status management, we're finding that there is a delay in
import file upload and image
Hi, Good Morning. While importing records by "Import data" in reports, Am I able to import file upload and image ? Thank you
Fetch Zoho Learn data (Article ID + Article Title + Article Link) from Zoho Creator
Hello, I'm bulding an app to keep track of who's responsible for each task in the company + keep track of the procedures needed to perform the task. Here's the structure: Each procedure can contain on or more "procedure step". Each procedure step can
Next Page