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.
Using ZC to control electrical relays
Hi, I'm trying to find a way to use ZC to control real life electric appliances (lights, etc.). Is there a way to use ZC to control electric switches/relays? Did anyone ever tried that? I cannot find a relay that would work with a rest API call. Thanks
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
Using Roles and Profiles in Deluge
I have a form with a section called "Billing_Details" for use by our billing department. I would like to hide the section when the user is not a member of the Billing Department. I have a user profile called Billing Department. My question is this: is
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
How can I use add record to create multiple records from one?
I can use add record to create one additional record, but not for the multiple that I want. I am using forms to submit orders for advertising, so I need the same form to apply to various dates in order for a report for a given date to be accurate. The solution, I though, was to have a field assign a number of "runs" or "insertions" of a given advertisement, then the function could create copies of that same record, with .addWeek(2) for the date field, according to the number of times in that field.
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
Document Editor does not show correct Field Content from Lookup Fields
Dear all, I do have a strange content showing in the Document Editor. I do have multiple Lookup Fields in a creator form like shown in following screenshot When I import this field into the document editor it does not show the content of the field, but
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");
Next Page