Deluge Records of Current Month
Hi I want to pull from the form "Job" and find the number of warranties in the given month. The underlined portion is what i need. On the job form I have a field called Date Received. I want the deluge script to count all records from the current month with the job number than contains W. I can do this via records however this script runs daily and need to do it from deluge. thanks Jobs_Day_Count = Job[Job_Status == "Approved" || Job_Status == "In Queue" || Job_Status == "In Progress" || Job_Status
Public Link Zoho Creator Basic form
Hello, I am trying to find a way to share the public link from Zoho Creator. I see that they say it's been done, but when I press on my share button, many options that appear on these solution sites don't appear to me. Is it because I have the free version? Best regards, Sabrina
Zoho Creator for Zoho One and SSO
Hi, In zoho creator for Zoho One, I can't find the "Click on the SAML option." as described in the help (cf. https://www.zoho.com/creator/newhelp/app-settings/configure-saml-authentication.html). I would like use SSO for customer portal in zoho creator. It is very important for me.Is it impossible with Zoho Creator for Zoho One ? Thanks a lot
Bootstrap
Wondering if it is possible to use Bootstrap for custom html pages.
Submenus & relations
I have a database setup like this : Warehouses > Sections > Boxes. Boxes are located inside sections and sections are divisions of warehouses. Considering that each section is linked to one warehouse only, is there a way when creating a new box and assigning it to a section to have the drop menu list only the sections of the warehouse selected for that box, like a "sections" sub-menu of the menu "warehouses" ? Secondary question : is there a way in a "warehouse" report that have Zoho Creator list
How to access individual fields of a blank sub-form in a report
Hello, I have a form which consists of a blank subform (with 5 fields). Is there any way to generate a report with these 5 fields individually? The only solution which I found for now (in a report) is in a single column to add these fields with space (or comma) as choice delimiter or by creating a link to view (and then the system shows the detailed view). But I would like to have these 5 blank subform fields as 5 columns in my report.
how to enable my application through my proxy server
I have a squid proxy server on my network that is used to block access to internet, i want to allow my application through the proxy settings , what ip addresses should be allowed in the proxy server so that the browser can run my application while keeping blocked the internet access in general.
Field Focus on Mobile App
In a web browser the first field in a form has the focus and is active when the form is loaded. This is not true on the iOS or Android apps. The filed must be tapped to bring up the keyboard. Is there any way to give the field the focus and make it active automatically? My application uses a keyboard wedge barcode reader. If the field is not active, the scans are not entered. It is a common error for the user to forget to tap on the field. I'd like to avoid this by making the field activate
Formula fields are null when they are accessed in "on field input" workflow
Hi, I am trying to access a formula field (KGPerUnit) value in "on input" workflow of a field ($ Per KG). The field KGPerUnit have value. But its value is returned as null when accessing in action. It is the same for any other formula field. Please look at the screenshot. Anyone facing this issue? or Is it specific to my app only? Zoho support is analyzing the issue for past 15 days. But no reply so far.
Restrict type of file uploaded
Is it possible to restrict the file types in the file upload field?
Getting Map information from Google maps
has anyone tried getting map information using an interface with Google maps? If so, what information do we pass to the URL
Conditional format based on lookup field value
All, this may be a very simple question. I am trying to apply conditional filtering to a report based on the value in a lookup field. However I am getting error when setting up the criteria. Would I need to code a fetch the lookup value before being able to use the conditional filters?
Charts being made from Reports/Views
Hi, I see something on the forums, related to Charts being made from Reports/Views, is this still possible with Creator 5? This could actually be a solution for a problem of mine, if it still can be done. https://help.zoho.com/portal/en/community/topic/record-owner-field-is-not-being-honored-by-the-charts https://help.zoho.com/portal/en/community/topic/pivot-chart-based-on-views
Limiting access to a record to one person at a time
I am building out a very basic inventory cycle count application. At times, there might be multiple people using it at the same time. I want to limit access to a given record to one person at a time. How can I do this? Thanks Gregg
Limiting access to a record to one person at a time
I am building an Inventory cycle counting application in ZOHO Creator, and I would like to know how I can limit the access to a given record to one person at a time. When I create the application, I am uploading a set of countable materials. I then will have as many as three people counting these materials around the warehouse. There will be times, that a given material is stored in multiple places that will be counted by different people. How can I lock down a record that is open by one person,
Criteria/Filter Problem for Charts in Zoho Creator
Hi, We need help with another issue in Zoho Creator, we need some sort of criteria/filter for Charts similar to Reports, right now in Charts this is the only thing that filters records - Records Show all records & Show logged in user records, and we need to insert this filter (in Reports you can do this): Location_Lookup.User == zoho.loginuser || Table_Lookup.User == zoho.loginuser Also we tried to use the Filters from the Chart inside (the one that has Wildcard in order to filter), we tried using
How to run a schedule from button click
Hi, Is possible to trigger a schedule workflow from a button click? What I want to do is to send a specific report by mail when the user clicks on a button. Thanks, Javier
For each only outputting last and single record in set
Hi all, I have created a simple function that sends an email to admin when a member of staff requests some stock items. It's all working perfectly, however, I must be doing something wrong as it's only outputting the latest and one row, whereby sometimes it can be 3 + items. Foreach Loop: for each r in itemsSubform[ParentID == requisitionCollection.ID] { cat = Stock_Categories[ID == r.Category].itemCategory; subcat = Stock_Sub_Categories[ID == r.Sub_Category].Sub_Category1; // Output items = "["
Undocumented error code 2932 "Profile inactive" when doing API POST
Greetings! This isn't really a question, but a note I wanted to share in case anyone else comes across this issue. We've been testing API integration with Zoho Creator - specifically, for creating records. Naively, we thought that setting the "format" in the API URL to "json" instead of "xml" would also mean we can submit the required payload as JSON. Unfortunately that doesn't appear to be the case. Trying to do a JSON POST results in a response with error code 2932 and message "Profile inactive".
Controlling user filtering for report embedded on a page - C5
I have a report (price list) embedded in a page in a client portal. I pass a parameter to the report based on the market the client is from and that filters the price list report for that particular market. That all works fine and was created in C5. The issue is that the user can then just go to the search function, remove my filter and access the entire price list for all markets. I have searched for solutions for a couple day and I did find this link that mentions that includes: The Menu Bar
REST API error code 2932
Hello, I am trying to use the REST API to add records from an external application. I have followed all the steps in the documentations and I am using the generated authtoken, but I keep getting the error below. Any suggestions? <response> <errorlist> <error> <code>2932</code> <message> <![CDATA[Profile Inactive]]> </message> </error> </errorlist> </response>
Subform Best Practices: Blank vs Existing Form
I would like anyone's input as to what the BEST PRACTICES are when adding a Subform to a form in Zoho Creator. The two options given are: Blank Form: This is when you can add the fields directly to the subform. Existing Form: This is when you can connect it to an existing form in your application. What I don't understand is why you should choose one over another. Is there a downside to one or the other? Example: What started me down this path is I generally create a blank subform when I am trying
Trying the count function for multi select in subform and also removing already selected employees
Good morning, I am try to count the recurring employees under the "Employees Assigned" subform field. I have the initial count working for a single row like seen here And this is the deluge code I have to make this work. I have tried putting something similar to this in the on add new row for the subform but can't get it to work. It starts recounting as I select more employees. Example. My last request is to remove the employee names from the list after they have already been selected in the "Employees
Zoho Creator : hide Section doesnt work in Published Forms - Edit Mode ... Probable Bug
Hi, Have come across the bug that "Hide Section " doesnt work in Published Forms - Edit Mode only (Add mode - it works fine) Interesting part is that within the app as a normal user it works just fine .... Any explanation ?
Is there a Site for ready made scripts
want to know if there is a repository available for developers
Search Records from zoho creator bsed on multiselect dropdown in delugue
I have two forms "candidates" and "companies" have both having multiselect dropdown "skils_set" . I want to search the records from skills_set of company and filter records of candidates using delugue in zoho creator. Let me know if anyone can help
Page item not updating when form on page is updated
So I have a couple counters in a few panels that reflect the count of items in a form. The form is on the same page. The buttons that are associated with the form work great and update the form just fine. The form itself also updates post button, however the panels do not. You have to refresh your window to see the new count. HELP! Worst case would be fine with a command to refresh the page, but much prefer just to push the panels to update the figures based on the updated data. Any thoughts?
Need help with my Deluge Script (it partially works)
Hello, I am having trouble with this deluge script working fully. When a form is updated or edited the deluge script needs to auto populate a dropdown field with either (Region 1, Region 2, Region 3, Region 4, Region 5). This is based off of what was inputted into the "State" field. My deluge script I wrote looks like this: However, when I run this code it will read through until line 21 and put "Region 4". Any thoughts?
Download PDF files stored in a file field
HI All, I have a file fields where users upload a PDF for each row, How can I download more than one pdf a time with a button? I actually made a button, but only works for one row :( a = "https://creatorexport.zoho.com/file/felipe.concha/invoice-tracker/All_Invoice_Trackers/" + input.ID + "/Backup/download?filepath=/" + input.Backup; openUrl(a,"same window"); Any solution? Please Best Regards!
Zoho CRM - Zoho Creator two-way sync
Hi, I am setting up a two way-sync between Zoho CRM and Zoho Creator. The creator app is used a client portal for Loan application. The brokers review the applications directly in Zoho CRM. Records can be created either from 1- Zoho CRM: a broker creates a Loan application in CRM, which creates a record in Z creator and invites the client user to fill the Loan application data; 2- Zoho Creator: a returning client creates a new Loan application, which then creates a record in Zoho CRM. I see that
How to close a pop-up form opened in Zoho CRM
Using the open URL function only opens the URL WITHIN the pop-up. It doesn't make sense why the form shouldn't close on clicking Submit/Update.
Printable report with subform record on each page
Hello there. Is it possible to produce a printable subform report that has each single subform record on it's own page? Many thanks, Matt.
Multi - Select Lookup Field
Hello, I am trying to add values of Multi-Select Lookup field and store them in another field Value should be updated On User Input Following is the code i used to add values var = 0.0; for each rec in Quantity { if(Quantity.size()>0) { var = var + Quantity.todecimal(); } } input.Total = var; Values inside the Multi-Select lookup field are all decimal values Following is the error i received :
List elements separator / List values separator in record summary
I have a field that contains schedules. A record can contain many schedules. A typical record is used to illustrate my problem: When this field's content is displayed in a REPORT, it looks like this : 06h00, 07h00, 08h00, 09h00, 10h30, 11h30, 13h00, 14h00, 15h00, 16h00, 17h30, 03h15, 05h00 All fine. The values are separated by comma+space. When this field's content is displayed in a CUSTOMIZED RECORD SUMMARY IN A TABLE, it looks like this : 06h00,07h00,08h00,09h00,10h30,11h30,13h00,14h00,15h00,16h00,17h30,03h15,05h00
Copy image from a an image field to another.
Hi there! I need to fetch an image from an image field to another field in another form. So i have: Form A: Risk Levels Image Form B: Other non related fields, Subform B: Risk description Risk Level (lookup from form A) Image. I whant that whenever a user selects a risk level from the subform B, the image is copied from the form A image field to the subform B image field. I tried this code (wich works great for other type of fields) but had no luck... IMG = Lista_Niveles_Riesgo[ID
Automating Customer Email reminders
Hi all, I am trying to work out (not successfully) how to send a customer a "Service" reminder email. I need to send an email to a customer based on a few different fields and conditions. So a customer would get a reminder email if they have a service due next month, once the email has been sent the system then changes the next service due date, this new date is based on what level of service they have purchased (bronze 6 months, silver 4 months, gold 3 months). But i only want it to send the email
How to add a record to a filtered report
I have a single form - LISTS which includes merged lists of organisation departments, categories of objects, etc., all in the same list in order to minimise multiple Forms. I was advised by Zoho Developers this is best practice. So I have a single Form with filter Query in a Panel object on a Page (filtered by department, object category, etc.). So there are 2 Items in each Record, Name of Item and List Type (Radio). I have tested by creating a Report with Filter and same problem. All I want to do
Feature Request: Button Field Type
Oh how easy that would make so many features I want to add to my Zoho Creator apps. I would like to be able to add a Button as a field type. This Button would be able to be referenced in deluge "On input of a form". That way I can add slick features like: Calculate Taxes: This would do the complex call of calculating taxes and then writing the taxes to the subforms. Show/Hide Sections & Pagination: Right now to make it feel like multiple pages on a form, I have to do this wonky stateless forms stuff.
Basic Creator Form -> CRM Case
I've built a basic form in Creator that has 2 CRM Integration fields to find 2 different account profiles that will be linked to a case. We're using cases in this manner for requests between 2 different account types. Account A has requested something from Account B, for example, so both should be linked to the case. I've got the form set up no problem, but when I go to create the workflow to create a record in the CRM, the two CRM integration fields are not available for mapping. Any ideas here?
Fetch Application Users List
Hi, Is there a way to fetch a complete list of all users in the application? I'm trying to develop my own approval process rather than using the in-built one and I need to send an email to all users who have the "Approver" role. Therefore I need to grab the list of users and loop through them using the thisapp.permissions.roleForUser function to retrieve their role. However, I can't find a function to list all users in the app. Any help anyone can provide would be greatly appreciated. Thanks, Harry
Next Page