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?
HOW TO INTEGRATE ZOHO SHEET WHIT ZOHO SHEETS FOR A UPDATE EXITING RECORD IN ZOHO CREATOR FORM
I HAVE ONE FROM IN ZOHO CREATOR AND SOME DATE IN THIS FROM BUT NOW I WON'T UPDATE THE EXITING DATA WHIT ZOHO SHEET IT IS POSSIBLE OR NOT IF IT IS POSSIBLE TO UPDATE HOW?
Add custom day and date to Date Field
Hi Everyone, I have case like this. If Day in Date Field A > 8 in current month, Date in Field B should be 23/Date A + 1/Year (dd/MM/yyyy) And if Day in Date Field A <= 8, Date in Field B should be 23/Date A/Year (dd/MM/yyyy) Example: The created date is 09/05/2019 so end date will be 23/06/2019 The created date is 07/05/2019 so end date will be 23/05/2019 Sorry about my description. I cann't find function to add custom date like this to end date.
Restricting Fields in Bulk Edit
I have carefully hidden some fields in my Form as I do not want them to be available for editing. However, it seems that enable bulk edit allows any field to be edited. Is there any way to stop this? Thanks, Julian
"Work offline" in Zoho Creator ?
Is there any way to work offline in Creator? I have some forms that I fill out... take notes in... at a location that does not have internet. It would be great if I could do that there, and then come back to the office and have all that data upload to Creator's database. Thanks for any input. Tom
Migrating info from Form A to Form B
Hi guys, I have a question regarding migrating information from a form to another form. I have same fields on both forms, and here is my code when customers fill out the form A, and I migrate them to form B. insert into User_Sign_up_Form [ Added_User=zoho.loginuser Yellow_Fever=input.Yellow_Fever ] But somehow when I update the report for my form B, It created a new customer in the list as shown below. I am supposed to update the second row. I appreciate any help! - Sally
How to add a flow created in Zoho flow into Zoho creator app?
Total newbie, so apologize for being lost. I have a contacts app in creator, and set up the Zoho Creator Gmail flow for when a new record is added. I tested by adding the new record, and my email is sent to me. However, there's no indication in Creator, that there's a flow working with my app. It only shows flows I created inside the App under the workflow tab. Should I be able to see Zoho Flows from here?
Date filter: this week
Hello, If we use a calendar report we can configure what the first day of the week shall be. I can not find this feature any other reports (pivot chart, pivot table, list report etc). The default setting is Sunday. In my country the first day of a week is Monday. So I always have to use user filter in reports if I want to have "this week data" from Monday to Sunday. Anyone can help if the feature still exists somewhere and I miss something, or any tip how to hack it? Kind regards George
Combining 3 reports into 1 with all information
Hi, I am working for a NGO and we have 3 different sign-up forms for activities. Is there a way that we can combine all 3 forms and sort the information according to the volunteers' name? For example, volunteers provide their basic info in Form A, activities they want to join in Form B, and availability in Form C. How can I combine all of these into a single report? Thanks. - Sally
Using Formula Field with a Lookup Field
Hi all! I have a form with a "Job ID field", a "Client" field and a "Job Title" field. The "Client" field is a Lookup field that pulls from a client database form. I made a new formula field to merge all of the information in an easy to read format for other forms. The expression is this: Job_ID + " - " + Client + " - " + Job_Title But what I get is: Job ID - XXXXXXXXXXXXXXXXXXX - Title Instead of the Client field from the client database form I get the 19 digit ID of that entry instead. Is there
I am having a problem with emails inside a zoho creator Form Action sent to email addresses for my users where I know that I have used the exact email address
I am having a problem with emails inside a zoho creator Form Action sent to email addresses for my users where I know that I have used the exact email address - including using "zoho.loginuserid" both with and without the quotation marks. The user does not receive the email, I am sending out several different emails from the same field - is there a limit to the number of emails one can send from a single Form Action? Inside this Form Action I have another email that I send to myself and I do get
Uploading photos as fields in a Zoho Creator Template
I have an application where one of the fields is designed to store the photo of a user. I used the image category field and the system seems to accept it when I load from a JPEG on my PC - it identifies the jpeg and assigns a number on the screen. However, when I look in the Report, the JPEG is not there. When I edit the record and I add the same JPEG in edit mode, it does accept the JPEG and the the JPEG does appear when I view the edited record in the Report view. Attached is a screen capture of
Filter lookup to select only most recent
Hello, I have a lookup field where I want to select ONLY the most recent record that fits certain criteria. For example, if a customer renews their service plan, I may have two records that filter to [Customer_Name == input.Customer_Name && Transaction == "Purchase Service Plan"] and I'd like to select the one with the most recent Date. Is there a way to do this? Thanks, Elizabeth
Popluate a drop-down list with data from another database
Popluate a drop-down list with data pulled from a database that is maintained by another form....Does anyone know how to do this?
Separate content from a String
Hi All, I have a form with a rich text field and a single record. The field contains email content My second form sends a notification using the fields value as the body of the email, on success. The problem I have is separating deluge (such as + input.anyfield +) from the HTML / content. My code so far: EC = email_form[ID == 45644000002346541]; req = EC.email_content.toString(); sendmail [ from :"zoho@zoho.com" to :"chris@zoho.com" subject :"subject for this email" message :req ] is it possible
More than one attachments in Send Email task
Is it possible to attach more than one file(PDF- Record Summary) in the Send Email task inside Zoho Creator?
There MUST be a way to update records in bulk. But how?
I have created a database with thousands of records. Occasionally, I need to add another field, after which I need to populate those fields for each of the records. I do NOT want to go through each record one by one to update it. The information I need is in a spreadsheet, which can be converted to CSV or TXT file with no problem. The information is numerical, therefore the bulk update option does not work, as that allows you to update records only with the same value. Most databases allow you
Removing Export Options without Embedding
Seems to me we should be able to customize a standard list's export options. Maybe there is something undocumented to add to the report definition? Cheers, John Whitney
IP Address of internal LAN subnet
I have a published form that I would like to restrict to a certain subnet in our organization's lan. Windows ipconfig gives me the internal ipaddress, but the system field zoho.ipaddress gives me the external public ipaddress. is there any way I can get the internal address on our internal network?
Delete Records using Multiple Conditions
Hello, I have "Kids" form where i have design no, shade no and multiple sizes say 28, 30, 32, 34 and so on and they are updated when delivery challan is created. Now i want to delete the particular design no. when all the sizes of the particular design no is reduced to 0.
Pivot Chart / Subforms
Hello, I am not able to use subforms in pivot chart so i think subforms and pivot chart relation is not supported. Are there any future updates on this topic?
Send an Email
I want send an email data to my department which is approved in last month.
Financial Year
Hello, How do i setup financial year in Zoho Creator.
Help counting and calculating date differences in arrayed data
I have no experience scripting for arrays, indexed lists, etc. and need help to deluge-script the following business need: I have an event_form, with a date_field, employee_field and time_field. For any given date, the number of records logged by a employee varies from one date to another. I also have a summary_form, with a date_field, employee_field, recordcount_field, and hours_field. The script should accomplish something like this, diagramed in plain English: For each date_field value and each
Next Page