why i am facing problem in uploading Zoho plugin on Wordpress website?
I am facing an uploading issue of the Zoho plugin kindly give me the solution. regards:
Unable to create a pie chart
Hi, I have a form with multiple fields (field A, field B and field C) and a field which is the sum of Field A, B and C. I am trying to create a pie chart for this. When i try to create a report, the option for pie chart is not enabled. Can you guide me with the right steps so the pie chart option is enabled. Thanks!
WARNING! Don't upgrade to C6 if you have apps with lookup fields to other apps
After many months of being bombarded by the great new "environment" functionality, I could finally migrate to C6 on my Zoho One account. One of the items on the checklist to migrate is "Sandbox enabled in applications". I deleted my sandbox and upgraded,
Format for adding to a multi-select field via Zapier/API
I am using Zapier to act as an intermediary between a chatbot and Zoho Creator - to allow our clients to add records to the database via a communication. I have it working well, however when trying to pass a value to a multi-select field (it will only
Currency Exchange Rates
To enable me to calculate currency gains and losses, I wish to use today's exchange rate as published by organisations such as XE.com in my multi-currency accounting package. So, I would like to automatically update a table of currency exchange rates every day. I know Zoho provide a number of accounting/invoicing etc. solutions; does any of these provide automatically updated currency exchange rates and if so, can I access these data from Creator?
Dynamically adding sorted record IDs to a multi-select Lookup field
EDIT/Solution: instead "equals to" or ui:add, use .select (https://www.zoho.com/deluge/help/client-functions/select-deselect.html). IDs = Form1[Criteria].Lookup.getAll().distinct(); IDsSorted = Form2[ID in IDs] sort by SortField; input.MultiSelectLookup.select(IDsSorted);
how to send email or sms for all customers ?
Hi, This is like i am thinking ; let me know if it is possible like this or is there other solution for the same. first form lookup field may be - for all customers which has name -- so we can take email , phone then message - we willl put message in
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,
date time and currente date time
hello im creating a grapg or a page snippet on where user can view on real time the expected date time of a ticket minus the actual current sisteme date time so i can create a graph or a report that is green if expected date time has not expired related
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
How to fetch Multiple values when Lookup field type is "Multi-Select" ??
Hi.. I have Project Live Form Window, where my Lookup Field - Employee_ID (Multi - Select Value). when I choose Employee_ID ( Multi Select value) field ---> from Project Live Form Window, I want to Fetch Employee data automatically from Employee_Info form. Suppose If I choose , 2 Employee ID from Project Live Window, It should display that 2 relavant records, say Email ID. I tried using Script Builder, but getting Error. How to do this task?, Kindly assist me, doing this task. Thanking you Regards
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!
would be nice if zoho creator had a spell checker option for text fields
would be nice if zoho creator had a spell checker option for text fields
Unable to COPY / Duplicate Application
Dear All, I am desparately in need of help. I had worked day and night on a CREATOR application recently and now wondering to COPY the application to another user ID and give it off to a friend. The application works absolutely fine in my account and I have currently made it public so that I could copy the same application from my friend's account. When I login in his account and do a search for applications, I am able to pull up my application but then the system doesn't copy the application to
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
zoho creator view is not present in the workspace and blank reports
Hi Support, Users who have "write" permissions keep getting this error for all of our embedded reports all of a sudden. See screen shot below: Meanwhile, my developer permissions account sees a blank screen in view and edit mode as shown in the screenshots
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
Next Page