Trigger workflow when data Import being imported
Hi, I have created a workflow to be triggered during form submission, the workflow will insert a new record in another form when the form being submitted. Scenario : Form A -> Submission -> Insert Into Form B I would like to know is it possible to
Signature Possibility via iframe?
Hi All, i know there are a few topics already stating this can't be done but I've stumbled across this https://github.com/szimek/signature_pad check out the demo seems to be clean... and i was thinking to run the .js and .css on our own server and embedding it as an iframe then getting a cal back function to add the image url to the record or use that url t upload it straight to zoho? i know this is slow but i can't think of any other way soho creator will let it work Possible or waste of time?
How to create Sub Menu or Sub Section
Hello Support, Please share how to create Sub Section/Menu under Main Section/Menu in a application. Regards Vinod Kumar
Need information on Zoho Creator
Dear Team, We are currently working on exploring no-code capabilities of Zoho Creator application for our organization. Problem Statement: 1. We are currently maintaining Project Lifecycle Data on Google Sheets and different teams manually input data
Client Portal Including ZohoSign, Projects, Desk, and Books
Hi, I am relatively new to Zoho Creator, so I'm not sure how to go about achieving this. We want to create a portal for our clients that shows ALL of their stuff in one portal instead of having separate portals for each zoho application. Basically,
Repeat X times
Hi, I need to auto-add entries to a form, number of entries as a number the user enters (if the user enter 5, I need to add 5 entries to a form). How can I do this? Could not find a "repeat" function... Thanks! Ravid
Stuck in Sanbox for the last 6 months....
Hello, Even though, from what I've seen, a lot is promised for C6, I'm stuck since February 2022 because I can't manage to publish some components! 6 months and several dozen emails with support...hearing that the problem can be solved and then being
Change E-Mail receipt Address in E-Mail-Notification according field content
Hi all, I like to change the receiving E-Mail address of the E-Mail Notification according a field content. Example: the Notification receipt field should be filled with address xxx@xxx.com in case a Pull down Field is choosen content xxx or if the Content
How Download Attached Files from the Email Templates?
Hello, I have a new form which has attached files field. After summit the form, this one send an email with email layout indicate the "link" to the attached files. But when the user press the link for download the attached file, says the follow lines: You
Image fields display as Landscape when the original pics are in Portrait mode, why?
Hello, I took some pictures from my Iphone in Portrait mode then uploaded the images into image fields in a Zoho Creator app via the Iphone Zoho Creator App. All good. From my computer I then created a report with the image fields and set the image fields to 100 Width and 100 Height. When I ran the report the images displayed in Landscape mode. This is not good. How do I get the images to display in the report as Portrait? And in the future if I upload Landscape pics into the fields how do I get
File attachment force to be Viewed NOT downloaded.
I have a app built in Creator where the use can attach a document / file (alway a pdf) , The default behaviour when the user clicks the link is for the file to download. I would like to file away to force the file to be viewed either in my chrome browser or in the default app,,Adobe acrobat I have thought of copying the link and modifying it in some way and drop it into a url field with the hope to force the file to open in the default program Adobe Acrobat. Any ideas ?
SubBusinessDay function??
Hi I wonder why there is no SubBusinesDay date function? or alternatively why we are unable to use minus days with the addBusinessDay function? In my app I have a deadline date that is fixed and I have a number of business lead days necessary to calculate the date that a project needs to start by to meet the deadline date. While I can use subDay, it doesn't take into account non-business days. Any ideas of how I can accomplish this without this date function? Thanks!
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
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.
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");
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
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
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) {
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?
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?
Next Page