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
Deep/complex UI
Is it possible to create a form that allows you to work with more than 2 levels. For example, creating an order to sell widgets. Each order will have one or more widgets. Each widget can have a different size, and number/type of drawers (e.g. 1 ring
how to pass basic auth using getUrl() function
Is it still the case that zoho getUrl does not support basic authentication? Someone suggested a workaround here, but I'm new to web programming so I'm not sure how to do it. https://help.zoho.com/portal/en/community/topic/geturl-posturl-cannot-pass-authorization-key-in-header-map Does it involve setting up another server to run PHP and have my ZC app talk to that PHP for every single API call? Any someone elaborate?
Retrieving custom field into Zoho Creator from Zoho CRM
I have one integration field that provides me the account name from the accounts module in Zoho CRM. It works fine. I would also like to populate another field with a custom field value in the Accounts module for the same account. For example the account
What (if any) reason would there be to NOT use bidirectional for all relationships?
I'm trying to understand a situation where one would NOT want to use a bidirectional relationship. It seems bidirectional relationships provide more flexibility with data manipulation in the future, and it seems it would be tough to move from a unidirectional
Prefilling name fields and address fields using URL parameters
Hi, quick question: In my Zoho Creator form I'm using the standard name and address field. How do I prefill those using URL parameters?
Lookup displays as field ID rather than contents
I know I've come across this before, but can't remember for the life of me. The add record code I have is this; Where Users is a lookup field (basically a form that contains a list of staff). The line that starts "Description=" produces this; whereas
Conditional Alert Message If Another Form Populated
Hi community, I'm building an application that has a "Settings" form. The settings form will provide logic to other forms throughout the application. When a user opens another form in the app, On Load, I want the application to check whether the Settings
It's time to evolve: Upgrading to Zoho Creator 5
Dear App Creators, With our commitment to continually refining and improving our user experience, we're gearing up to upgrade all accounts to Creator 5 on (UPDATED) from December 1st, 2020 , in phases . In other words, from this date forward, all your
Custom SMTP Settings
In the admin's account settings, provide a way to enable custom SMTP settings so that any sendmail script will route thru another SMTP server rather than ZOHO's. Example: Amazon SES now offers sending mail via SMTP (as well as an API). The typical settings for their SMTP server are as follows: Server Name: email-smtp.us-east-1.amazonaws.com Port: 25, 465 or 587 Use Transport Layer Security (TLS): Yes SMTP user name: XRASRT565FGR8909 SMTP password: XRASRT565FGR8909XRASRT565FGR8909 I'm not sure if
Zoho Creator Published Form on Wordpress Page
Tried using the embedded iframe and perma link on a Wordpress page for a published Zoho Form, however, Wordpress won't show the form. Am I missing something?
Ability to clear the search criteria on a page
I have a Zoho Creator 'page' with a search box, which sends the search term to a 'report' on the same page. This works nicely, except there is no way to clear the search criteria....the only option a user has is to enter another search term (which is
How to convert firstName.lastName@domain.com email to a proper name in formula field
I'm having difficulty converting an email field into a proper name. The email address all are firstName.secondName@domain.com Here is what I've created in a formula field based on the "Primary_Tax_Partner" field but it only seems to work sometimes: (input.Primary_Tax_Partner.getPrefix(".")
Community Webinar: Integrating Zoho Creator and Zoho People | October 27, 2020
Dear developers, Thank you for your support and encouragement towards this initiative. We hope to continue our efforts in creating an extensive knowledge base for our developers. Next up is a session on "Integrating Zoho Creator and Zoho People". Date:
How to integrate Record to external database (MySQL)??
I wanto to send data in 3 fields when my new record add, or record updated to MySQL Database outside Zoho Creator For Example: New Zoho Creator Recorded Added=> Send data to MySQL database for new Line adding Store Order Number Order Status A
Gantt Chart
Is it possible to create a gantt chart in Zoho Creator?
Convert a string to date
1) How can I convert a string (numeric) to a month or date format? For example: I have a field that contains one numeric string: like 0-9. I would like to convert this into month format, such that when the string is "1", the month will be January, when the string is "2", the month will be February, when the string is "3", the month will be March, and so on.... I tried the toDate() function, but it did not return a value. 2) On another note, i tried the getMonth() function on a form field (DATE type),
Zoho Creator as web app to handle results from scraping / API response
Hi, I am planning to scrape thousands of URL on a daily basis. As an alternative to handle this all in Python, I am evaluating, if this would be feasible in ZC too. Typical workflow: * List of URLs is generated in ZC* List of URLs is send to an API
IT Asset Tracker app Search by QR Code
I am setting up the IT Asset Tracker and I would like to be able to search by a QR code via the mobile app. I am able to use a QR code to input data in form fields for Add New Hardware. But when I click the search button on the All Hardware page, I am
CAUSE=INVALID_PASSWORD
Hi I tried generating an auth token but getting an error whenever i added the url in the browser kindly help. See the full result below #
#Tue Dec 01 08:05:54 PST 2020
CAUSE=INVALID_PASSWORD
RESULT=FALSE
Next Page