Problem with Report Filter in Zoho Creator
Namaskaram Zoho Creator team, we have found a problem with Report Filter in Zoho Creator. We can't set a filter based on an image field from 'edit' mode of the application. But we can do the same from 'live' mode of the application. After setting it from 'live' mode, we have tried to edit the filter of the same report from 'edit' mode. Then we saw an error in that filter editing window that is the filter what we set from live mode based on the image field has been cleared automatically. Please
hyperlink
Hi, I wanted to insert website addresses in zoho creator. How to just insert a name, and then add link to instead of writing the full hyperlink address. Thanks Budcare
Line numbering / background toggle in PDF template
Hi, I'm currently building a Print & PDF template for one Report. The related form has a subform I'm inserting in the PDF. Customizing the page is quite difficult as I try to customize the HTML code. Customizing the subform field is even more limited it seems, and not html can't be changed as it's rewritten each time. My goal is to either add line numbering to each record, or display a gray background every 2 lines. Is there a way to customize this field and how ? Also, how can I write my own column
Urgent Help with Sending Attachments on Emails
I have a form where the user can upload a file. Once the user submits the form, an email is sent to a group of people with the fields completed by the user. Is there a way to attach the uploaded file with this email? Thanks!
Remove Customer Portal
HI, As a test I created a customer Portal for one of our Creator app. Now, I like to remove the feature. Not only disabling it, but removing the full access and URL. How can I achieve this ? thanks.
Pivot Chart not Showing Form Fields
I have Table Called Material Used. There is Date_Created Field Which is not able available While Creating Pivot Chart Report. I need to created Weekly Material used report But this Field is not Available in Column Section
Send Multiple Records in Record Template Format as email attachment
Hi - I know it is possible to send a single record in Record Template format as an email attachment on success, such as an invoice attached to an order confirmation email. Is is possible to create a custom function or scheduled email to include multiple records in a form as an email attachment in the Record Template format? Currently, we can do this manually by printing the displayed records in a report as "Print as Summary" However, it would be very helpful to automate this process so that multiple
when was the custom domain feature changed ?
the feature was changed from premium to ultimate subscription???, we needed to change our payment method and resubscribed the next day and suddenly that feature is unavailable, we had all these past years the "premium "subscription and we were able to use custom domains, so what happened?
Add Business Days BUT excluding holidays and sundays only like workdays
Hi! Please, your help with the following: Please, use the example bellow to understand my idea: Initial_Date: '20-12-2019'; "Add" 32 "business days" to "Initial_Date", but with the following criterias: - 1st: Considering like workdays from Monday to Saturday. - 2nd: Considering the following Holiday list: Holidays = {'25-12-2019', '01-01-2020'; '15-02-2020'}; My problem is that the function "addBusinessDays()" do not permit both to exclude holidays like other functions (i.e. workdays) but to
Ability to define the appearance (currency, decimal, etc.) on Formula Field
The Formula Field does not allow the user to define the appearance/format option, it would be great to add it so that the user can define the appearance for this field same as currently supported in Number/Decimal/Currency fields: Post discussing this topic: https://help.zoho.com/portal/en/community/topic/how-to-display-formula-result-as-currency
Using addbusinessday formula with holidays and weekdays
Please, your help with the following situation. I want to use the formula addbusinessdays() but I cannot enter both holidays but specific workdays ranges. In my case I need to add some business days to a start date but considering workdays from Monday to Saturday and a short list of holidays... Please your help! Some formula example?
Enter value for input arguments
What does this mean? "Please enter the value for the input arguments." Room and Bed Registration is the name of the form I am trying to run this schedule on. I don't know what it is looking for. Thanks so much to all you who understand these things
Can't see headings in subform when adding multiple lines
Hi guys, My users are having trouble when entering more than about 5 lines on a subform. As more lines are entered the field headings are scrolled out of view on the page. I fixed this in the old version of Creator by adding a tooltip to each of the fields. When the user hovers over the field it displayed the tip. However, now I am using Creator 5, the tooltip only appears next to the heading which is out of view, not in the field itself. Any thoughts as to how I can keep the field headings in
Prevent 'via usermail.zohocreator.com' in email header
Emails sent from Zoho Creator to GMail have this "via usermail.zohocreator.com". I have tried setting up the SPF record to v=spf1 mx include:zoho.com ~all as suggested in https://help.zoho.com/portal/en/community/topic/which-spf-should-i-use and it doesn't work. This may be because the DKIM for usermail.zohocreator.com domain is present in the email header and Google identifies that to be more representative of the sender's domain. I have contacted tech support and have received frivolous replies
Notification senmail action does not work
Hi, I appreciate if you can help me with this problem: When forms submitted, success message work. The confirmation mail to the form sender work. But the notification mail to the form manager does not work. Im using the sintax below: success message "custom message"; sendmail [ From :zoho.adminuserid To :input.email Subject :"custom message" Message :input.fieldname ] sendmail [ From :input.email To :"myemail@customaddress.com" Subject :input.fieldname Message :"custom message" ] Everything works
Creator 5 reverting to Creator 4
Hey, All of my companies apps keep reverting to Creator 4. We starting using Zoho after Creator 5 was already implemented so none of our apps have ever been on Creator 4. We went to edit the forms and they forced us to "Move to the New Builder" and they moved us to Creator 5... the only one we have ever used. This fixed all problems for about 30 minutes until our apps got reverted back again. This is causing people to be unable to access all kinds of reports, pages, and forms. Is anyone else having
Page - Maximum Value
I can only place manual number in Maximum filed for numbers in pages. Is there way I can fetch value for that ?
Using Added Time in a Pivot Chart
I am trying to find a way of using the Added Time field in a pivot chart. I thought you could previously create a pivot chart on a view (which contains the auto Added Time field) but it seems that now I can only create charts on forms. Can anyone help with how I can achieve this?
Create solution and sell to multiple clients
Dear gurus, Is it possible to develop a full suite solution and sell to multiple clients? Let say i develop a complete HR product and sell to 20 clients, how is the charging to be like? Zoho charges me and i can charge my 20 clients? How's the relationship? My ideal case is, i have full control (in term of payment) on my customer and zoho only deal with me.
Many contacts
What if Company has many contacts in New Client form? And what if Individual has relation with several Companies? How to relate that?
Intergration Zoho Forms with Zoho Creator
our system utilises both Forms and Creator the some data that is input into Forms is also required in Creator. is there a way to integrate the two so that when a Form is submitted it automatically sends the data needed to Creator. btw I have attempted to use Zapier, it is not great at recognising and setting fields, there are constant errors it is not user friendly AT ALL! any help is apprecited
Display calendar report more than one field?On any chances?
Hello, I have a seminar date form and It has 3 different time value. I want to show these 3 dates on same calendar. What I read that it is not possible on calendar view? I also tried add zoho calendar events but this time I can't add seminar names to event name because It shows only string data :( I also use .toString() expression but This time zoho calendar shows me just long numbers because seminar names are lookup data :( I spent lots of time for this, How can I found a better way instead of
Deluge Skript Send Mail by Date
hi, I need a Deluge script that checks on schedule if a date in a form is reached and then sends me an email with the corresponding form title. But I can't get anywhere with the Deluge script. Can anyone help me? I have the schedule already Can someone write me an example of a Deluge script? I dont understand it.
Idea : Creator Apps should be automatically added to Zoho One
Namaskaram. When we create a new app in Creator (if the account is part of Zoho One subscription), then we need to explicitly add the App to Zoho One, by opening the list of Apps and tap on 'Add to Zoho One' option. Instead, it would be better to have the Apps added to Zoho One automatically. Crafted with ❤️ Zoho Gurus | Zoho One Practice Team @ CubeYogi Zoho Authorised Partner | 8+ Yrs | 200+ Projects | 100+ Customers
Pass Form Text Into Panel
Is there a way to pass values from a form in ZML into a panel? You can access form data but not seeing where if you pass a page parameter you could also pull string data into the panel through ZML. I know you could do this in HTML snippet.
Search for Multiple Values In Field
If I have a field in a View called Name, how would I search for records where Name = "Jones" OR Name = "Smith"?
How to Upload the XML file and read the XML file in Zoho Creator?
Hi I would like to know about deluge script for XML reading . I want to upload the XML and read that XML file with the help of deluge script in zoho creator. Is this possible in Zoho ? Let me know Thanks
Printing a custom recepit
Hello, i have a custom made app in zoho creator. here is a view of the report that i want to work on Report : Orders, it has the following items Order ID Customer Name Customer Phone Number Product Code Product Size Product Price every order has the same info, i want to create a function that would print all order for a certain customer . the receipt would look like Customer Name Customer Phone Number Products ordered: Product Code 1 , Product Code 2....etc Products Sizes: Product 1 Size, Product
Customize Layout option missing from Application and Form settings.
Hi Everyone, I want to change the layout of my form and found these instructions in the help. Select Application Settings icon in the home page or Click on the Settings icon in the edit mode of your application. You can select the required layout for your application from the Settings -> Customize -> Layout option. No you can't. There is no Customize Layout option for the form or even the application. I can't find it on the Applications Settings menu. Where do I access this? Also, I have seen in
Column width in table layout should be kept per user
We have multiple Report in Creator, with a lot of columns. My users noticed that when manually resizing these columns, width is not kept when they come back to the same report at a later time. Width seems to be "reset" to a default size. It would be nice that reports keep the user defined width.
Count of related records for each parent table entry
Parent Table: Deployment Child Table: staff Deployment has a lookup field (called related_staff) to select however which staff worked on a specific deployment. I need to report the number of staff who worked deployments at various points in time (monthly, quarterly, yearly, etc). First I need to know how many staff worked each deployment. I added a field on the Deployment table (called staff_count) and tried various deluge workflows, but I can not get it figured out. Thoughts? Also, is the zoho
Sample app won't install
I am trying to install the Product Catalog app in Creator but can't get past the "Setting Up Application" message. I have tried this in 4 different browsers (Edge, Chrome, Firefox, Brave) but the same thing happens. The last thing I've tried is installing it in a private window in Firefox. I got this error from the Console: Source map error: Error: request failed with status 404 Resource URL: https://js.zohostatic.com/creator/zcs10247/js/dashboard/tp_jquery.js Source Map URL: jquery-2.0.3.min.map
Zoho Creator Update a Task in Zoho Projects (DELUGE) Error 6890
Hello, I'm trying to update a simple task on my Zoho Projects using Deluge on the app i've created on Zoho Creator. This app haves a worklow that runs on record update. This is my function on Zoho Creator Workflow: And this is the error i get everytime: I've tried to change the function, for exemple to only get the projects status or something else. Everytime i get this error. Thanks
Zoho Creator integration with Zoho Forms
Hi, I´m searching for a way to integrate the Zoho Forms with Zoho Creator databases. Is there a way to do that? So that instead of the creator forms I can use the Forms from Zoho Forms. Thanks!
フォーム/アンケートにデータベースを表示する
フォームやアンケートにデータベースの結果を反映させることはできるでしょうか。 ルックアップで選択肢にできるのは存じていますが、特定のデータベースの結果を表示させたいです。 例えば日付付きの売上のデータベースで、1月分の売上を表示する、のような形をイメージしています。 Kintonではフォームの特定の値を拾って、他データベースの結果情報を表示させることができたかと思いますが、zohoでお同じようにできるか教えていただけますと幸いです。 何卒よろしくお願いいたします。
Updating Records in a Form from Excel
Hi: We need to update existing records in Creator from records in an Excel spreadsheet. We see how to do this using the Migration tool, but the problem is, we are on a Mac. Is there another way to accomplish this? As presented from another post, here's the functionality we're looking for: 1. If the keys match, we would like to update/overwrite all the fields in the corresponding record using the Excel sheet data. 2. If the keys don't match, we would like it to create a new record and populate it
Alert or a Pop up after on click submission
Dear Sir / Madam I have created a form, where user having facilating of deleting a record, But I want before deleting record, user must get an alert or pup up box which shows "Are you really want to delete ?" On user confirmation only record can delete. i.e I need a double confirmation from user before record permanently delete. Could some body tell me how I use this functionallty on "On Click" Option.
Sticky search panel
Hi, While I'm developing a Creator app, I see my colleagues using a lot the search panel available in Report page. I see they are struggling when they are narroying a search. It would great to have a "Leave search panel open" button (or similar), so the panel stays open, until they they want it closed. Regards
Filter subform records and autopopulate a subform field
I have a pretty simple setup with two forms. There is a Projects form (parent) and a Tasks form (child). The Tasks form is used as a subform within the Projects form so that each project record can show multiple tasks associated with that project, and tasks can be added and edited from within the Projects form. This mostly works with the following two issues: 1. I want the Tasks subform to display all of the Tasks records that correspond to the current Projects record. The Tasks form contains
Unable to add new users
We currently have 17 users in our application. When I try to add a new user, the pop-up dialogue states that we have reached our limit of 19 users and will need to pay to add this user. Any ideas how I could fix this?
Next Page