Add User Role as content into hided field
Hi all, I like to store the accessing User Role in a hided field to activate and deactive visibility of other filelds before openeing the form. Is ther some deluge system variable to fill fields with the user role (or user datas in general)? Thanks,
Related record counter
I have table 1 "sources" and table 2 "applications". Each record in table 2 has a mandatory lookup field to table 1. I want a counter that says: record 1.A from table 1 appears in x records in table 2, in the lookup field. I'd like this counter in different
Copy Form does gives an Error
Dear all, I try to copy a form and I do only get an Error message like shown below. Is this a known error or is this my misuse? In case I deactivate the hook to store the Data in Creator the form is created without error.
Retrieving Zoho Inventory records by Category
We are attempting to get records from Zoho Inventory based on the category but are having some difficulties. Can someone please offer any insight on the following? We began by attempting to add a query for the category_name field: query = Map(); ... query.put("category_name","Accessories");
old.getFieldValue(EachField) doesn't work?
Hi Zoho, Each time I reload my script On Validate page, old.getFieldValue(EachField) is changed to getFieldValue(EachField) (showing the current data instead of the data prior to change). Why is this happening? I need to compare the data in each field before and after the edit: FieldsList=getFieldNames(); ChangedFiles=List(); for each EachField in FieldsList { if(getFieldValue(EachField) != old.getFieldValue(EachField)) { ChangedFiles.add(EachField); } } Thanks Ravid
How can I add my live application to Environments without wiping out all production data?
So I have been developing a custom application for a small business for about six months now. We have done a soft launch as we continue to test and improve the application. I am realizing more and more how much I need a development/testing environment
Fiscal Year Settings in Zoho Creator
Hi, Is there any way to change the fiscal year settings in Zoho Creator App development. Our Fiscal Year starts from April (Q1 - April-May-June) instead of January. In my pivot reports, when I select data to be filtered by "This Year" it by defaults assumes
How to add or subtract the values of two panels on a page.
I have created a Page and there are two panels there showing some values from two different Forms. (They show the Sum of the forms as number.) I want a third panel that will show the subtract of these two panels. It might sound easy, but I can't find
Formula to calculate age
Can anyone help me create a formula that will calculate a persons age. I have the date of birth and the zoho.currentdate variable, but I am note sure where to go from there. Thanks, Dave
download image on input
Does anyone know of a way to download an image field file right when it is uploaded on user input? I seem to be able to do this with a file upload field but wanted to try to do it with an image file field because I think it would be more useful for us.
add border to a list view
Hi, Is there a way to separate fields with borders in a list view in order to have a more printer-friendly version. Thank you!
How would I change "State" from single line to picklist without creating a new field?
Hi just trying to figure out a solution to the problem.
openurl New Window blocked as popup
When using the openurl statement with New Window the browser is blocking it as a popup. I've tested with Firefox and Chrome. Are there any workarounds? Here is the code I'm testing: url = "https://www.zoho.com/"; openUrl(url, "New window");
Push data to Zoho CRM
Zoho Creator can push Form data to Zoho CRM. Below example steps (and explanation) tell you how to add a CRM lead from Zoho Creator Form. We have created a sample application for this at https://creator.zoho.com/sampleapps/push-data-to-zoho-crm/# . Sign in and click on options (at the top) -> Copy application to copy it to your account. 1. Create a Lead Form in Zoho Creator: Create a Zoho Creator Form with the following fields. (See https://help.creator.zoho.com/By-adding-new-forms.html ) Company
Associate correct user with API transactions
Hello- I have a Zoho Creator application that performs actions in Zoho Books and Zoho Inventory via the REST API's. For example, one transaction we perform is creating packages in Inventory. Currently I have Connections set up in Creator that are authorized
Since Tuesday our users have not been able to access most of the reports one of our core applications.
On Tuesday morning one of our our core applications suddenly denied access to all user reports except me. I am a developer not and end user and have administrator access. There are 3 other users with the same access although they also have been denied
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
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
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
Next Page