Manage Territories in Zoho Creator
Hello, I want to manage territories and it's related permissions in Zoho creator app? I didn't find anything related to that. Is this feature available? if not, what is it's workaround? Thanks Rabia
Subform - disable 'add entry' if mandatory fields not completed
Hi all, I've been playing around with a few different ways to solve this and none of them work perfectly. Is there are way that I can disable 'add entry' on a subform if some mandatory fields in the previous row have not been completed? I.E. in row 1 the mandatory field has not been completed therefore they cannot proceed to add a new row 2 etc etc. Thanks! Lindsay
Month Name
I want to extract the month from a date as "Jan","Feb","Mar" etc It seems to me that I can only use getMonth() to obtain the month number and then construct a if,else if,else if,else if etc to test the number and apply a string value, through 12 iterations if the month is "Dec" Is there a swifter and/or more elegant way to code this? Thanks Greg
Fetching a function from another creator app
Hi, I have two apps in creator. App A has two fields; 'Product code' & 'Product name'. App B also has two fields; 'Product no' & 'Name'. The 'Product code' field in App A is lookup field which looks at 'Product no' in App B. When filling in App A, I would like the 'Product name' field to auto populate based on the selection of the other field. I know I have to create a function in App B and then a script in App A to call in said function. i have found a lot of contradictory articles on line so am
How do I reference a related field in another application?
In "Application A" I have a form called "Customers" with fields name and email. I am working in "Application B" where I have a lookup field that gets the ID from "Application A" - "Customers". Question: I want to get the email field from "Application A" - "Customers" while inside of "Application B" deluge script. How do I do this?
display an image that I uploaded
I have been trying to create a display for an image that was uploaded. I have found this workaround (its 7 years old) but I can't get it to work. Im not sure if it is my inexperience or what but I could use some help! https://help.zoho.com/portal/en/community/forumHome.do?forumGroupId=2266000000002001&forumTopicId=2266000000011648&highlight=file+upload+url&sid=d3a4f81d9f4c1cba5f4b410f7ba70bff I would appreciate any help - thank you!!!
Autopopulate related fields
I have 2 forms: 1. Salons - with the fields "Name" and "Area" 2. Sales - with the fields "Date", "Name" and "Area" The "Name" field in the Sales form is a lookup from Salons. I need a script that will autopopulate the "Area" field in the Sales form, with the related area from the Salons report, whenever someone selects the "Name" field in the Sales form.
Attach Uploaded File while Sending Email
Hi, I have a form where user can upload files. On clicking submit, I want to email the uploaded file as an attachment. Is is possible to do so using "Send Email" function? Thanks! V
trying to add an event
I am trying to add an event from Zoho Creator so it appears in the CRM calander but I am having no luck I am attempting to adapt Damian's suggested script //create contact map contactMap = map(); //populate contact map contactMap.put("First Name", "Damien"); contactMap.put("Last Name", "Cregan"); contactMap.put("Email", "damien@example.com"); //add other info as needed //create contact in crm crmResponse = zoho.crm.create("Contacts", contactMap); //create task map eventMap = map(); //populate task
Remove options from drop down/lookup field?
Hello, I am creating an app that has 2 forms (Entry Form and Teams). In the "Entry Form" is a lookup field to the "Teams" report. In "Entry Form" I also have a drop down list that could have the same values as the "Teams" report, not sure which is best to use but I am guessing the lookup field? What we want to happen is that when a user selects a TEAM on the "Entry Form" app for that TEAM to be disabled, or no longer able to be selected by another user. So if we publish this app to a webpage
Tax calculation
Hi, I've taken the default Order management app from Zoho and trying to customize as per my requirements. I'm experiencing a challenge with Tax calculation. With the requirement I've to calculate Central_Tax, State_Tax and Local_Tax and display the Tax value (sum of Central, State, Local) + product value under Net_Total. Here is the default script I see. //Calculating the net amount here if(input.Federal != null && input.Sub_Total != null) { taxAmount = input.Sub_Total * input.Federal / 100; input.Net_Total
Create custom login form
Hi, I want to create a custom login form. I also know the custom portal features that can fulfill this requirement. But i want to have customized my own theme for the login form. I am not able to customize the customer portal. Is there any way to achieve this?
How to insert PHP form values to the zoho creator form?
Hi I need to help for inserting values to the zoho creator forms.Details are below. I have one PHP form , when i submit the form the values of the form will be insert to the zoho creator form. How can i do this? Any help Many thanks in advance!! Thanks
Html 5
Hi, Does Zoho Creator support html 5 in pages? Tks Pippo
need to create a search form from the application i made
i need to create a search form from a uploaded data so that user can search from a unique value suppose admission no pls help
Offload file to FTP Server on Upload
I am in the process of doing some integration with my site and the CRM. I was curious if it's possible to upload a file on ZOHO and have it be stored on my private server through FTP or some other means. The files are about 10MB. I'm open to any suggestions to get the file from ZOHO to my own server. Thanks!
Extracting Xero data using Xoho Creator
Has anyone successfully used Xoho Creator to do an API call to a Xero? I have everything set up in Xero with Consumer Key and Consumer Secret for a private application but cannot seem to get the call correct in Xoho Creator. Does anyone have any suggestions? thanks in advance.
Sandbox permissions vs full app
hi can I share access to an sandbox app without sharing precision to the full app? for example I don’t want the developer to have access to all data and information within the app.
Update Field From Button in Report
Hello, I know that the answer to this must be very easy but I just cannot manage to work it out. I have a report in my app which lists all pending orders from the Order Form. The report is displayed as list and I have got a button on each "row/record" named MARK AS COMPLETE. I want that when the button is clicked that it updates the field "Date_Completed" in the Order form for that record to today's date. Can someone please help me! I have followed all the guides but either nothing happens when
How to add relational filter based on start date column in table
Hi, I have created a table with Company name, A start date, and time (mins), which is data from desk. Each company has a different start date. I want to filter the data so that the time (mins) shown, is relative to the data that has taken place since each company's start date. The issue I have run into is that this date is different for each company. I have tried adding a filter with the start date, chaning the setting to relative and adding 'this year', however this doesn't work. Any ideas?
Backup Creator 5 App with Basic Plan
Hi Zoho community, I'm trying to decide whether Zoho Creator 5 is suitable for my small business. I think that the Basic plan most suits my 1 person business. If I were to go with the Premium Plan I would still only be 1 user so would get no more than 25,000 records. My main concern is that there is no off-line backup facility within the Basic plan. That's the only extra option that I'd need from the Premium plan. I'm reluctant to pay double the price just to back up. With the Basic plan it seems
Can't view component in Published Page
As the title, perma-link: https://creator.zohopublic.com/hoangnl.tst/viking-account-service/page-perma/ORDER_TRACKING/xU2E6OQ6xkEeQ0s2CE1Gn4SjEfeTYeG0HZVJtY8B8gWyhM9Uf1DsQfWV1MPCT9Ej5eMMePskOgmJ2g5ZPHZMvdqFGmEqCuFGCurw It shows: "We failed to retrieve this form. An error occurred when we tried retrieving Order Tracking Key. This error has been reported to Zoho Creator support." I try to publish all the component but it's sill the same. Can anyone help me with this problem. Thank you,
Connecting to an Oracle Database
How can I connect to an Oracle database inside my company so that certain data and charts are refreshed periodically?
Reduce image size uploaded by user
Hi guys, is there any workaround that can reduce or resize the image uploaded by user as in the storage size provided by zoho is limited. thanks Jeff
Wrong language of zoho creator's app
I have installed the zoho creator's app version 5.17.1 on my iphone 7 version 12.4. The OS language is set to (swiss) german. Unfortunately, since a couple of weeks, the zoho creator's app appears in dansk language! log in = Log ind, logout = Log ud, settings=Indstillinger, and so forth. I have deleted and reinstalled the app but the bug remains. I want to use the app in german as it used to be. Can you please check this bug? Kind regards, Daniel
Filters and duplicates are not working.
Hi guys, today I got a problem when I tried to duplicate report not able to duplicate the reports and all filters that were worked yesterday crashed! and even when i try to create the new, they are not working too. Please fix it or let me know what went wrong. Best, https://prnt.sc/p1lh82 https://prnt.sc/p1lh82 - filter described https://prnt.sc/p1li2h - issue
Sending an email notification when a quantity in a report reaches a specific quantity
I have set up a form PPE Disbursement for our inventory that has a subform to enter quantities used and quantities returned. The amounts entered in the subform update our quantity on hand in another form called Add PPE. This Add PPE holds the fields PPE Description, PPE category, Total on Hand, and Inventory Reorder Level. We will use Add PPE to update records when an inventory count is completed. I have been able to set up so that an email notification is sent when this form is edited and
How do I change the color of the Help text?
I have many fields in my form that need Help text lines but all are in Tundora color, how can I change the color of the Help text to Red?
My Search Textbox is missing in Zoho Creator Report
I read the guide from Zoho's Help page: Search records But in my form, the Textbox for inputting texts to search is missing, what I need to do to make it appear? Textbox for Search is missing
Convert to JSON format
How can i convert following to json format using deluge, i have debugged a bit found that i need to replace ],[ with , (comma), but i have no success. [{ "name": "Ron", "email": "ron@test.com" }, { "name": "Jaby", "email": "jaby@test.com" }],[{ "name": "Karen", "email": "karen@test.com" }, { "name": "Clowy", "email": "clowy@test.com" }]
How to read xml file with zoho creator
Hi All Hope you all are doing great!!! I need help, whatever u know about this topic. Please share with me. Because am new to zoho ,if anybody help me it will appreciate. My questions are below : How can i read the xml data using deluge script using zoho creator? And how can i store the xml data to the database? Then build a report with these data in zoho creator? Note : The xml file will be upload using file upload in zoho Docs/Workdrive Hope you all are help me and share your knowledge here:-)
Duplicate of app or Restore of app is not working
Zoho Support, I have two apps that will not duplicate or successfully restore from backup. Other apps work but these two will not and I need to duplicate at least one of them in order to not spend hours and hours re-creating the app. Please let me know what could be causing this.
How do I display images in my report using the inbuilt zoho creator PDF.
Hi, I have a parent form called Invoice with an Invoice Details Sub-form. In the Invoice Details Sub-form there is a Rich Text Field which correctly displays a product image both in the form and report. See the attachments. When I print the form these images print correctly in the html view. Also when I print to an external PDF creator the images also show. When I print a PDF using the Zoho creater inbuild PDF the images in the Rich Text Field are blank (see attachment). They are also blank if I
Adding "amount" to a multi-select lookup field
Hi, I have two forms. The second form(recipes) has a multi-select lookup field to the first (components). The problem I'm running into is that each recipe could include multiple of the same component. Is this possible and how can I accomplish this? Basically, I need to add an "amount" field to each of the chosen components in the multi-select lookup field.
Unknown form field tag when editing form
I had never seen the tag next to the field name before and can't figure out what it means, please help! None of the other field labels show the tag next to them. Thank you!
Portal headaches - Setup, users and access... None of it works.
As much as I enjoy Zoho Creator's ease of building apps, the customer portal feature is the complete opposite. Nothing about this good or useful because apparently it doesn't even work. Boy am I glad I paid $99 a month for it. What a sweet deal. Let's start with the image I see when I click on the portal link I setup... Uhh... what exactly am I supposed to do here? By the way, it looks like this in every single major browser and on two different computers in my home. I've unpublished, republished,
zoho creator does not show stateless form when adding subforn
When modifying an existing form to show a subform, you have to add the subform into it. But when adding the subform field, the selector does not show the stateless form !! Any help would be appreciated Peter
Merging creator apps
Is it possible to merge 2 existing creator apps into one? Other than manually recreating the forms, I am wondering how best to approach this. Thanks Sowmya
How to resend user invitation Zoho People
With the new interface of Zoho people, I cannot find a way to resend my invitation for a user. How do I do that exactly?
How the data may affect the one application by updating another application.
There are two different java based applications. Application1 and Application2 Suppose a user has registered in application1 and just after clicking on submit, the user must have checked in application2, whether the user is present over there or not, if not then the user should have registered in application2. And the process should be automated. like when one user is inserted in application1 then right after submission if the user is not present in application2 then the user must be inserted.
Next Page