Sendmail function cannot be saved. "Improper Statement Error might be due to missing ';'"
Hi, I'm trying to make new rule to automize new-data-added notification. what I did is 1) I drag&drop "sendmail" parts to script field, 2) change "from", "to", "subject", "message", 3) press "save script". but I cannot save this script with error message "Improper Statement Error might be due to missing ';'..." Could anybody give me any suggestions? thank you Tadashi
Fingerprint support to capture thumb expression
Hi all, Does anybody have an idea of how to include fingerprint access in a form or do you know any third party API's for that ? Your help is much appreciated ! Thanks, Adhi.
Don't Zoho Creator support company logo in the trial version?
I have a trial Zoho Creator trial account. When i am adding company logo it is not showing, but i my favicon is showing. Don't Zoho Creator support company logo in the trial version? Note: Please take a look at the attached file.
Happy Holidays!
Dear all, 2020 has been a difficult year for all of us. Yet, it has also been a year in which people have shown extraordinary spirit, courage and compassion towards one another. In many ways 2020 has brought the world together towards a common goal, shedding
Customer Portal user variable
Hi, What I am trying to do is to restrict some of the fields on the form from Customer Portal user but not from Internal User. What I anticipate is if there is a system variable like "zoho.loginuser" for only customer portal user something like "Zoho.Customer_portalUser" which variable only holds customer portal user and exclude internal user .. Not sure something like zoho already has ? I know a workaround that I have to create a form for all internal user and list of of that and use that form data
Revisting this Question
Hello Everyone, I'd like to revisit this question I had, https://help.zoho.com/portal/en/ticket/58164440. I still have not figured out how to get the lookup field on the active form to populate into the Add New popup window when adding new entries into
Export image stored in record using summary report?
I have a record summary report that displays an image stored within the record (image field type). Looks great in the browser but when I export the summary report to PDF the image does not display. How can I get the image to export/print from the generated record summary report?
Deleting records from a blank subform
Welcome everybody, I have a form with two subforms: a blank form and an existing form. https://www.zoho.com/creator/newhelp/forms/fields/subform/understand.html Quote: ======================================================================== When you add a subform field to your form, you need to define if the subform is a: Blank Form: This option enables you to create a form within the main form such that, the subform's existence is inside the main form Existing Form: This option enables you to add
Send mail with multiple attachments through a list
Hello! I need to send emails attaching multiple files included in a list, as indicated here: The formats to attach multiple files: List of files file: <file_attachment_list> where, <file_attachment_list> is the LIST containing the attachments. How should
Create footer with page numbers in HTML View
I would like to ask you if you found any ways of how we can add footer with page numbers in HTML Views...What I want to do is when I press the print button then to create the pages with page 1/2, page 2/2 etc as a footer. Do @page and @media print work in Zoho? because I tried the following and it does not do anything @page :left { @bottom-left { content: counter(page); } }
I am uploading images in my form. How do I display it in the sendmail?
I Have a form with and RTF, and a file upload field in order to upload an image and also a single entry field in order to stored the following on the submit button: a = "http://creatorexport.zoho.com/DownloadFile.do?" + input.Imagen + "&sharedBy=" + zoho.adminuser
Integration of Creator app with Zoho Inventory
Is it possible to integrate my Zoho inventory data (clients, sales orders, etc.) with a Creater app I developed?
View URL with OR condition
I am trying to create a URL string to be added to openURL() function. I have a view set up and I am trying to dynamically open the URL by providing two filter criteria. My problem is that my filter criteria require 'OR' option instead of 'AND'. I know that 'AND' option (& is used for AND as shown below) in such a scenario works and its syntax is below. What should be done if I want to use OR option? http://app.zohocreator.com/<app owner name>/<app name>/#Report:<report name>?<FieldName1>=<FieldName1
Beta tester group
I'm a pretty annoying ZC user to be honest, I have waaaaay to many chat support tickets and I've been posting and suggesting complex feature requests. But that's because I LOVE ZC and really think the product is WORTH my time. I'm definitely NOT the only one. Users like us are valuable for a company because we're attentive to the product and to where its heading. We're invested enough that we are willing to spend time and effort helping out the employees making sure the product is living out to
This application is not accessible. Sorry "Username", you are not allowed to access feedback. Please contact this application's administrator.
I am the administration and i can't even access the form or the report. That happened after i published the form. This message appears: This application is not accessible. Sorry ramialjildeh, you are not allowed to access feedback. Please contact this application's administrator. What shall i do? This is very important and i use it for a big audience!!
Passing signature fields from Creator to Writer via deluge merge script
Hi all, I am having issues passing am from a creator signature field to a zoho writer document via a deluge merge script. My hope is to email to final result to a customer. Attachments - Deluge Script 1 to 3 is the deluge script in creator. Write Doc
Exporting Report PDF in Landscape view
Hi, I have followed directions at http://help.creator.zoho.com/Functionality-based-URLs.html regarding how to generate landscape PDF views, but I can't get it to work with the reports on my account. For reference: 4. The url format to convert an HTML view to PDF with the PDF's orientation value. The orientation value can be landscape or portrait. The default value is portrait. http://creatorexport.zoho.com/<app owner name>/<app link name>/pdf/<HTML view link name>/&zc_PdfOrientation=<orientation
Is it possible to preload a sub form?
I would like to preload a sub form with standard rows. For eg., I have ordering form with a sub form for items. The items are standard items. I would like to preload the items in the subform and the user enters the order quantity. Is this possible?
Fetching Records selected on Multi-Select Lookup field.
My skills are getting rusty...please help... Upon Add/Success I want to update the certain fields of the records selected in a Multi-Select Lookup field. I've been hunting through the this forum archive, but just can't get this work. Any help will be greatly appreciated.
how can we Update records in Google spreadsheet and zoho Creator through API ??
Hie , whenever i update my Google spreadsheet data ,i want that Automatically update on zoho creator too through API but don't known how it can be done , can anyone help ??
Is it possible when clicking on the portal link, in the invitation email, to push the customer to download the application where he can set up his password and eventually login ??
Today, the default behavior is for the customer to configure their password, and log in, in the browser first. And then (maybe) the customer will download the customer portal application and try to log in, in the app. The problem with this setup is that
Dynamically alter calender report properties
I am trying to dynamically change the date wich is displayed by the calander report. For Example: I have a calendar report wich is embedded inside a page with a HTML snippit. I have made a workflow to automatically add a day to any event I choose. The
Images uploaded not showing on customer portal
Hi, I have ran into problems with showing the images that user uploaded for the event. I have a Post Event Report Form with a Event Photos subform created from Image_Upload form. I have uploaded all the photos from my admin account and simulated a customer portal user to login to see if the images can be seen. Using instructions here: https://help.zoho.com/portal/en/community/topic/need-help-with-images-in-html-view, the photos are able to be seen in my admin account, when i click Edit (Post Event
Update Records without a loop?
Is there a way to update a batch of records WITHOUT a loop? I ask because of statement execution limits. For example: Records = Form[Field == "ABC"]; Records.Boolean = false; @damien?
Set Lookup Field with Deluge
Hi i want to set the value of a lookup field by deluge and this does not work somehow there are two forms: TRANSFER and ENTRY when TRANSFER is saved, this workflow should create a correspondig record ENTRY, setting several fields and should set a "back-reference in TRANSFER to the field "Entry_from" (this is a lookup field referencing to ENTRY) "rec" is an object-handle for the current TRANSFER document "b" is the ID of the newly created ENTRY record (type bigint) the last line should set the back
Unnecessary gap in the marketplace
Hi, Digging in the creator Marketplace. There is a missing opportunity to use the full height of the page. Screenshot from Chrome. Not better on full screen. Screenshot from ChromeRegards
is it possible to parse the searchParam with zoho.books.getRecords ?
Hi. I contact to request help about getRecords function. Is there a way to get records not only with the exact match searchParam, but also get records who "include the searchParam" or more string? For example, with the next code I get all the purchaseorders
Opening Up Google Maps App Via Link from Andriod or iOS
I am running into an issue. Goal: I would like for a link I have added to a Zoho Creator Form in this format <a href="LINK">Test</a> to open in the Google Maps app on each respective mobile device; android and iOS. Problem: The link format for iOS is:
Users Field (Record Owner) Instead of Added Users Field for Pivot Charts
Hi, I would like to use the Users field (Record Owner) instead of Added User field because I want to change it's value and system fields can't be changed and I also what to use them when creating a Pivot Chart Report. From what I've seen, pivot charts
Add elements to a list through a variable that changes by "for each"
Hello. Please could you help me with the following code? data1 = map(); data2 = map(); all_data = list(); item = map(); all_items = list(); data1 = {"name":"Jose", "age":"20"}; data2 = {"name":"Maria", "age":"25"}; all_data.add(data1); all_data.add(data2);
REST API Authentication Session Management
Hi, Does anyone know if it is possible to manage your own user sessions by authenticating through a 3rd party REST API? We've got an ordering app that we want our clients to log into, however the only authentication option for the customer portal is SAML,
Transfer ID from Stateless form to Stateful form
Hi, I have 2 forms: Page1 (Stateless) MasterForm (Stateful) Scenario: In "Page1" I have fields like Names,Phone etc and a Button "Next". When I click Next, it will show "MasterForm" and it has other fields for user to fill in and a "Submit" Button.
Is it possible to get a specific image size from API?
I am trying to retrieve an image attached to the zoho creator record via the API. After I get the report via API, it includes a field which has the API URL for the image: For example: https://creator.zoho.com/api/v2/<>/<>/report/User_Hub_Summary/<ID HERE>/Employee_Hub.Image/<ID HERE>download I can then make an HTTP request to retireve the binary data of the image. That works as expected, however this only returns the original image file. Is it possible to access, via the API, the lower resolution
Update 1 field for all records in 1 step.
Context : I have a field in a form that fetches it's value in another field in another form based on the value entered in another field in the same form (like a lookup field). That bit is taken care of with a script that fetches the value "On success"
Showing related records on the same screen - is this a subform
I have created a rudimentary asset database and so far it's working well. There is a form for the assets that looks like this; These assets come in and out from our warehouse and when they come back we create a condition report using another form. It's
ACH Processing and Zoho Creator
Anybody using an interface to process ACH payments through Zoho? I believe we could push to Zoho Invoice from Creator and do it that way....I was hoping for a direct option to push invoice data stored in Creator to an ACH processor. Any ideas or solutions?
Data Field, Time Field and Date-Time Field Arithmetics Question
Hi, I have a date field and a time field (or even a date-time field and a time field) and I want them combined and then place in a date-time field, how can I do this, I tried a couple of things but I can't reach the desired results or even a correct one.
Field being blanked out after form load action
I've got a deluge script to set the dropdown contents of the section and adtype fields in the screenshots. Can anyone have a look at it and tell me why it's clearing out the Adtype field after the script has run. The debug window is showing the contents
Page Builder doesn't load and keeps spinning tried on 5 different devices
Hi, Suddenly I am not able to whether create new page or edit existing. The page builder is stuck on this (Screenshot below). The rest of Creator works, form builder, reports, workflows etc. I tried opening the Page Editor on 5 different devices, including
How Can I sell A custom app develop in ZOHO?
I am new to Zoho and I am trying to develop an application with the plan of selling it to several customers separately. I am not sure what are the requirements to this could anyone please give me the clarification on this? What are the steps? How can
Next Page