How to use link in message of sendemail task
Hi, I am trying to use a tag and href for link inside the message, but it is not working. like sendmail [ from :zoho.loginuserid to :client_email subject :subject message :""<p><a href="https://www.w3schools.com">Visit W3Schools.com!</a></P>"" ] i have
Tip 26: How to hide the "Submit" button from a form
Hi everyone, Hope you're staying safe and working from home. We are, too. By now, we at Zoho are all very much accustomed to the new normal—working remotely. Today, we're back with yet another simple but interesting tip--how to hide the Submit button from your forms. In certain scenarios, you may want to hide the submit button from a form until all the fields are filled in. Use case In this tip, we'll show you how to hide the Submit button while the user is entering data into the form, and then
Enable displaying individual user data and aggregate data from all users on the same chart
This would enable showing users how they are going relative to the whole user community, which is a common usage scenario. For example, the chart below has red bars showing the range (min to max) for all users, and blue dots showing the logged-in user's
How do I fetch and input data from parent and child form?
I want to transfer data from a parent and it's child form to another form. I drafted this code but it throws an error once it gets to the child form fields. What am I doing wrong? if(Master_Database[ID == input. Number].count() > 0) {
Creator JS SDK - How to use any "array" field??
Hi team, I've tried every single way to addRecord where I want to parse an array, just ANY array. I don't know why there is no single field that would allow me to use this dynamically. I tried multi select, which when I fetch the record, it returns an
Deluge script to create new record in custom module not working
The below results in an error message when using the API name of a custom module voidCreate_building_from_name(string Address1,int lead_id) building_map = map(); building_map.put("Buildings_Name", input.Address1); building_map.put("Address_1", input.Address1); create_building = zoho.crm.create("Buildings", building_map); info create_building; info building_map; Results in: {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"Name"},"message":"required field not found","status":"error"}{"Buildings_Name":"test","Address_1":"test"}
Invoke URL With Zoho Creator and Multi Part Form Data
Hi, I have been trying to get an external API working with Zoho creator, I have managed to get loads of different API's working fine over the past few months but I have a problem getting the syntax right for this specific API. I think this is the first
Two Way Integration between Salesforce with Zoho Creator is Possible Using Zoho Flow ?
Both way synchronized Integration is required. For Example, 1. Create/Update - Data has to be pushed from Zoho Creator to Salesforce. 2. Create/Update - Data has to be pushed from Salesforce to Zoho Creator. Is that possible to achieve this using Zoho
Reloading the page while redirecting to internal link using openUrl
I am changing the portal user role from deluge as shown in https://help.zoho.com/portal/en/community/topic/tip-28-how-to-auto-assign-profiles-to-portal-users on submission of a form and redirecting the user to another page in same tab. With new role,
Zoho Creator API v2 Sort Order
Hello, What are the correct query string parameters to change the sort order of my GET records request? I can't find this documented anywhere. I have tried the following, but get a 401 error: https://<base_url>/api/v2/<account_owner_name>/<app_link_name>/report/<report_link_name>?from=1&limit=1&sort_order=<field_name>&sort_by=desc
Filter Reports based on Company Region
I am working on an application for a mortgage lending company. This company will have regions servicing homes in different areas in the United States. Borrowers will be the ones creating records in the user portal, and those records will be assigned to
Print multiple pages with page parameters at once
Hi all, I have a dynamic page based on the parameter passed through the URL. I can print it to PDF using a default setting in creator, but is there a way to print all the pages created from all the parameter values at once if I have a list of all the
Is that possible to give different application access in the workspace to the customer portal users ?
Dear Team, Please refer to the below requirement. Is that possible to give different application access to the customer portal users ? For example, Once I logged into the customer portal credential I want to access the different application in the workspace.
Is that possible to delete the customer portal users automatically using Custom Function ?
Dear Team, The requirement is, We have one registration form for the customer portal users to auto assign the portal permission. If the same user is requesting to change the portal permission. I have to change the old permission to current requested permissions. How
Property folder in payload has a value that does not match schema
the graph API request to create a folder in one drive is POST /me/drive/root/children Content-Type: application/json My code: callMap = Map(); callMap.putAll({"name":"New Folder","folder":"{}","@microsoft.graph.conflictBehavior":"rename"}); headerMap
Adding a row to subform at a specific position
Using the "insert into" function adds a new row to a subform field at the end of the subform. Is it possible to insert the new row at a specified position in the subform field rather that appending at the end?
Zoho Creator - Development
Dear all, I'm new to Zoho. This is in regard to Zoho Creator and Extension development. 1) In the Zoho Marketplace, there are many Extensions (and custom apps) available for sale. I'm wondering what programming language is used in Extension development?
Zoho Creator
Hello, I have app in zoho creator, and have invited my employers .. but when my employers open invitation link .. it redirects to blank page! Screenshot is attached.
Adding values to a multi-select field with deluge
Because subforms will only create new rows, I'm using deluge to recall information from a form into the subrows to mimic the behaviour of updating a row rather than creating it. I have a multi select field called "locations" that is a list of locations
API Greater Than (Zoho Creator)
If I make this request, it works, returning all records for 12-Jul-2022 https://creator.zoho.com/api/v2/xxxxx/certification/report/Rapport_d_taill?Date_field=12-Jul-2022 But I then add a > https://creator.zoho.com/api/v2/waterprotec/certification/report/Rapport_d_taill?Date_field>=12-Jul-2022
Query Parameters for "Today"
How do I put Query Parameters equals to "Today" for date field in page when we put Open Report as action?
Options to re-filter report
Greetings, I hope find all doing well and safe. I have a report that list All Customers. There is a field "status" with values Active or Inactive. The report is filtered to load only with Active status. I would like to get an option to the user see the
How do I change (error) display messages
Hi! I would like to edit display messages like "invalid entries" and "enter a value for Nome" and so on into Italian language messages. How can I do that? Already tried on Validate on form submit. Where I am failing? Thanks in advance.
lock some records at a subform
Zoho support told me there is no way to disable for editing some records on a subform, based on field's value of that same record. Can someone think of a workaround to achieve this? Thank you!
Commission Calculator
I am looking for some help with calculation commission for my business. I have a Form called Policies and a form called Renewals For each policy, there will be 1 renewal each year, and commissions are paid on the total premium of the renewal. However,
Sum value from Json response
Hello, is there a way to get the sum of all qtaconsumption values in the Json response below with a function like sum() instead of having to do a for each loop to sum each value? Can't figure a way to do it with sum(). {"historyQuota":[{"time":"2022
Error code 2930 : unmeaningful message
Hello, I wanted to get a specific record from a report in Zoho Creator with a function in Zoho CRM. I have created a connection and used a simple zoho.creator.getRecords(with arguments). The response a got from that was a : {"code":2930,"message":"Error Occurred. We are sorry for the inconvenience."} Function executed successfully Is it possible to understand where this error comes from so I can efficiently correct the source code? Thanks
Logging task time in Creator
Using Creator I want to be able to log in task time. For example: If you are assigned Project A to work on and in Project A you have Task 1, Task 2, and Task 3 to complete. You're going to work on Task 2 so you log in your date/time and at the end of working on that project you log off your date/time. It will log that time and put it in that particular task. Then the next day you come in to work on Task 2 again and once again will log in and log out the hours you worked on that task that day.
How create audit logs or history of report ?
How create audit logs or history of report ? I know there is logs option for the same and check with selecting form; but we need in report. How ?
POS system of Restaurant
Hi Team Is it possible to create something like POS for an Restaurant management providing access for reservations of table, keeping track of reservations, and adding orders for the reserved tables using existing Restaurant Application of Zohocreator.
Function Inputs in Report Filter
Is it possible to pass a field into a function in a report filter? I have a use case where employees are broken out into different branches based on geographical region, however there are certain regional managers that reside over multiple branches. I'd
can we add deluge code in condition
Hi, can we add here the dyanamic date, before 1 day Day of Interveiw start date in condition ,... ??
function as a filter criterion works in some reports and not in others
In several reports I use the same filter that is the value returned by a function.It worked fine until recently. Suddenly now in some reports it works and in others the criteria of the type: "thisapp.MyFunction ()" has been replaced by "<FUNCTION ()> " and does not let me change it.I have already contacted the technical service and they have been checking it for days but at the moment no solution. If anyone has any ideas, help is appreciated.
Send mail to every e mail address in a subform with the respective information.
Hello, I am creating a form in order to report happenings in a company. The main form is to collect data from the person who reports the happenings and the case. There is a subform too, in which the person who reports should describe al the different happenings he found for that case and who is reponsible for it and his/her email address. I would like to send email notifications to every email address in the subform with the respective information. How can I do this?
Report based on subform entries
Can anyone help me with how to create a report which shows data from a subform please, which I can export to a spreadsheet? When I do it, it only shows that there is a subform rather than the data within it. Thanks.
Zoho Creator SaaS app with multiple client AND multiple users
I am close to finalizing a Zoho Creator app that will be used by different companies to manage sale info, and each company can have multiple users using the app. Things were going perfectly until I tried a search on a report. I use a database field in each table to separate the data for each company, which works great. BUT when I do a search, I get to see ALL the data. This means that Company A could easily see the data from Companies B and C via the built-in search. Is there a way to set up the
Trying to create a ZML snippet to show a forecast of revenue
I am trying to create a ZML snippet to show a forecast of revenue based on a count of records from a form from a different app. The app name: latxoperationslivedispatch The form name: Today_s_Truck_Assignment Date and Time: MMM dd.yyyy /12-Hour These
Trying to pull a owner name (and other data) from CRM in Creator
Hello guys ! With the help of this great community I was able to pull some data from CRM "Contacts" into my Creator Form. As you can see below, it's working like a charm but I now need help to be able to fetch only the name of the owner (my "commercial"
Upcoming Updates - February-March 2022
Hi all, Greetings from the Zoho Creator team! A new year is here and we're looking forward to bringing in new features, improving performance, and delivering on all the exciting updates we previously announced. In this update, we'll go over the: 30 new
Dashboard data from deluge function
Hello, I'm trying to figure out dashboards so this might be a very basic question. Is it posible to display a gauge element using data obtained from a Deluge function instead of stored in a form? For example if I want to check the status of a customer's
Next Page