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?
How to create a short customer ID
Just wondering how I would go about creating a shortened customer ID number.... I know Zoho creates a unique ID for each form entry, but I was hoping to create ones unique to my form, though only 5 digits or so and not the 18 automatically generated. Thanks!
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?
About Record Add Permissions
Hi there everyone, This might be a simple question, and I might just be overlooking something minor. I am trying to figure out how to allow the permission to add records for the Zoho Support team. As I am working with them on an issue and they asked me the follow: "If the script is triggered while adding records to the form, please provide your permission to add records from our end. " I know right now they are busy, so I may not get my answer for a bit. I was hoping someone could help me here in
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 = "["
Help regarding hide Reset button from form.
Hello I need some help. I have a form in which I am getting a value into single line field. I have two button Submit and Reset. I am doing functionality on Submit button. Reset button is no use for me. I want to hide reset button from Form. Please tell me how can I hide reset button from the Form. Otherwise suggest me alternative.
Developer / Creator EU licensing per user cost please
I am looking at Developer Creator Application, and wondering what the licensing model is? Is it the aligned to the Developer Creator Solutions starting at $2 per user, or Creator Apps starting at €10 if in the EU? Thank you.
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
Creator Calendar - On Validate
In my app, I've added some On_Validate logic to prevent users from changing a date field to a day that is "off", i.e. Sunday or Holiday. However, in the Calendar report, users can drag any appointment to those days. In other words, the On Validate script seems to only fire when the record is opened for editing. In the Calendar view, the date field gets updated. I could write the code for the "OnUpdate" event but by then, the data has already changed. Also, I don't not have access to the old date
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>
JSON Import into Creator?
Hi. I hope the answer is "yes", but if "no", there's a huge opportunity area for Zoho to fill: * Imports of JSON data feeds After Googling the internet, I was lead back to Zoho's docs which indicated Creator has a very robust API/export option, but I couldn't locate or confirm if JSON imports are supported. Also, as a former DabbleDB user JSON, XML, & RSS feed scheduled imports was one of their better features that abruptly went away when Twitter terminated the product upon acquisition. Please confirm
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?
Workflow schedule to send email
Hi there I'm setting up a workflow schedule based on my add employee form to email reminders annually on the employee's anniversary date/hire date. I want to remind the employee's manager to book the employee's annual performance review. However, the fields I have on the form are the employee's email address and the employee's reporting manager, which means that I would need to fetch the reporting manager's email. How can I use the reporting manager's email address in the To: line of the notification
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
Multi-Page Registration Forms
Is there any way to break down a really long form into multiple pages? What is the best way to handle multi-page forms? My client's event registration forms have approximately 5-6 steps in the form.
View As - Building Apps
Can we please get an option to be able to View As (both for Customer and User) I'd like to be able to see what a particular customer will see based on their permissions without having to set up a dummy user.
Common Workflows
For most of my apps, one of the first workflows I add is to fetch customer names from my Zoho Books application to populate a picklist. Since I have way more than 200 customers, this usually involves multiple API calls and quite a few lines of script to filter out vendors and inactive customers Currently, I have this script saved as a text file on my desktop and I cut and paste whenever I need to reuse this for a new app. Is there a better way to do this?
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.
Next Page