Webhook to creator
Hello I am trying to send a webhook to creator from an ai scanning software. I was wondering how do I do this so it creates a record. I have not been able to find any resources for it, is this something that is possible? I would need a url to send the
SaaS / Stage / Issues / Horror
I have been trying to use the new SaaS platform, and it is fair to say, a lot of effort for zero business benefits - so far. I tried to raise these issues through online support, but it keeps responding there is an issue... they are right, quite a few. Rather than wait for online support to work, I have posted here... I need to take comfort from the community as my already grey hair.... The are: on pricing i cannot say it is an annual plan, only provide an annual discount on pricing the text box
Calendar Report - Day/Week View - "all-day"
Dear support, It would be nice if you gave us the option to remove the "all-day" section at the top of the "Day" and "Week" Calendar Report since this feature is inoperable if we're using Date-Time fields. It would be even nicer if you made it operable
How can I create a list of dates between start and end dates?
I have the Start_Date and End_Date variables. I would like to create records for each day between those two dates. Is there any workaround to create the list of dates and then iterate it? I would really appreciate any help or workaround you may know.
How can i customize app theme color?
Hello, Am using Zoho Creator Professional Edition. I have created a app, but am unable to customize my theme color. After search around the forum i found some solutions https://help.zoho.com/portal/en/community/topic/how-do-you-make-a-custom-theme-in-zoho-creator But, i didn't see the "Customize" option under the "Application Settings" menu (see attachment). Where can i find these settings in Zoho Creator? Thanks in Advance.. Thanks, Selvamuthukumar. R
Add report button to card layout
I can add a report button in list view - is there anyway that I can also use it in the card layout ?
Deluge Calculations
My application has a main form and two subforms. Main form = deployments Subform 1 = incidents - incidents responded to during each deployment. Subform 2 = staff - employees who worked on each deployment. I have successfully linked the relationships using the main form's ID. The main form uses a look up field to show which employees were deployed on a given day. Then the Incidents form has a lookup to show which staff responded to which incidents. The main form has a formula field calculating
Report filtering with functions : show all or ignore filter
I would like to know if there is a way to conform a repor filter to show all as well as a single value. Context : I have a function that will return the ID of a single organisation based upon an option chosen by a user that's stored in a form called client_access_form
Edit record link in Customer Portal
I have an application and I am using the following script on my form "Contact_Information" > on load: (I have inserted <appuser> and <appname> in place of the correct code below) record = Contact_Information [Sponsor == input.Sponsor]; if (Contact_Information[Sponsor == input.Sponsor].count() > 0) { openUrl("http://creator.zoho.com/<appuser>/<appname>/#Form:Contact_Information?recLinkID=" + record.ID + "&viewLinkName=Contact_Information_Report", "same window"); } When I am logged in, this
Lookup field filtering
Hello, I have a lookup field that I need to filter based on input in another field. I have already filtered this by setting the filter in form builder to Model(look up field) contains input.Model(single line text field) and this filters it almost the
BCC address or character limit?
Has anyone else encountered a BCC address or character limit? I'm trying to BCC 144 addresses (3424 characters) at the same time, and while the Sendmail task completes successfully, nothing is received on the other end. I was able to BCC all 144 addresses
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:
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,
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");
Next Page