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
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
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:
The new Creator 6 - How to migrate?
Greetings, I hope find all well and safe! Last days I have seen some social media posts about Creator 6, from Zoho, as an example this website link: https://www.zoho.com/creator/whatsnew/creator6.html But when I log in to my account (inside Zoho One)
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!
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
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
Dynamically adding sorted record IDs to a multi-select Lookup field
I can dynamically add IDs (on User Input of another field) to a multi-select Lookup field, but I can NOT add sorted IDs. IDs = Form1[Criteria].Lookup.getAll().distinct(); IDsSorted = Form2[ID in IDs] sort by SortField; input.MultiSelectLookup = ??? I've
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
Can't Add Developpers (Users) to Zoho Creator App
Hello, I've been using creator individually for a little while now, Recently, I wanted to add one of my co-workers as a developer on our app so that they could also help with troubleshooting, development and scripting. However, whenever I try to add
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
Multi file upload
Hi, I just wonder if one could upload multiple files in one shot, say between one and three files, without adding multiple File Upload fields? Thanks, Alalbany
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
Delete Blank Records
Hello, I'm very very new to database and Zoho. I imported a spreedsheet from Excel and when I do, it brings tons of blank records. Now that those bland records are on my report, how can I I do a mass delete to delete all blanks. When responds...please don't get too technical. I'm very new to all this. Donna Z
How to add action on click on submit
Hi, How to add action on click of submit like below i am trying ; but i am getting only form submission option , where should i find this option Thanks and Regards, Sidhant A.
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
Sandbox data
Another useful feature would be to migrate the data from production into Sandbox. Otherwise making up test data in the Sandbox is a very very tedious job to say the least.
Fetching records with multiple sort criteria
Wondering if anyone has had success running through a for each collection with multiple sorting instructions.... Example In a view's script you have.... sort by ( rep_name_grid ascending Talked_to_this_rep descending ) In a collection it looks like this..... for each r in Form_Name [group == group_var] sort by rep_name_grid range from startval to (endval - 1) However, in collecting records you set asc and desc in the scriptbuilder :) I tried to make the syntax work
Rename a template as PDF
Hello, Is it possible to rename a template when we send it by attachment mail ? For exemple, I've got a template named ""DevisJour"" and when I send it by mail I would like to rename it "DevisJour & N" Thank you for your help
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
Tip 33: How to create custom forms and reports using widgets
Hi folks, In this month's tip, we're going to talk about how to use widgets to create custom forms and reports in your Creator application. But, before that, let's cover a few basics. What are widgets? Widgets help you extend the capabilities of your
Cannot change japanese text font when doing pdf export
I use openUrl to export my report with specific ID, but the Japanese font does not look clean when exporting. I have tried changing the font within my RTF, but no luck. Any idea on how to fix this?
Creator roadmap for the rest of 2022
Hi everyone, Hope you're all good! Thanks for continuing to make this community engaging and informative. Today we'd like to share with you our plans for the near future of Creator. We always strive to strike a good balance of features and enhancements
Can't fetch data from JSON response
I'm connecting to an external API with a postURL and saving the result to a 'result' variable. I'm getting the correct response, as shown in the screenshot below, but I'm unable to extract data from it with get(), getJSON, etc. If I manually copy and
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
Determining user device
I need to be able to determine whether the user is accessing the form through a desktop or mobile browser. Is there a way to determine user client? If not, is there a way to read the url of a page using deluge scripting? I know that when a user access the form through a mobile browser, there is a "form-mobile " in the string. The reason I need this functionality is because Zoho Creator only allows the user to take a picture using their camera through mobile browsers, but I need to create the
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
Grammarly and Zoho Creator
Hi there, I cannot get Grammarly to work on fields in Zoho Creator - this is especially important when we're writing important client documents. I have run the tests suggested by Grammarly, all of which pass (https://support.grammarly.com/hc/en-us/requests/new#/resolve-a-technical-issue/grammarly-browser-extension/i-don-t-see-the-grammarly-icon-in-some-text-fields/) This needs resolving as a matter of priority. See from the screenshot there is no Green icon in the bottom right of the text box.
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
Next Page