Logic-based form calculations - Conditional Formula for Zoho Creator
Hi, I see Zoho just introduced a Conditional Formula for Zoho Forms. It would be great to implement the same feature on Zoho Creator Formula Fields. Here the details of the this new feature introduced in Zoho Forms: https://help.zoho.com/portal/en/community/topic/logic-based-form-calculations-introducing-conditional-formula-for-zoho-forms
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
How to update a form with data from a crm look up field in another form in the same application so that it shows as a text value rather than the ID number?
Hi there, I need to create update a form called "US Customers" with data from a form called "Customer Cancellation Form". This works fine using the Data Access/Add Record /"insert into... procedure . The only problem is that one field I need called "Organisation name" is a look up field to zoho crm . This field in the new form displays the Organisation ID not the name of the organisation insert into US_Customer [ Organisation_Name=input.Organisation_Name Contact=input.Contact Email=input.Email
In-App Notification Counter on Menu
See attached screenshot. Would be really nice to have a "counter", especially on the "Approvals" workflow tab.
Barcode Scanning
Hello, I would like to integrate hardware barcode scanner with Zoho creator, how do i do it?
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
Workflows with translated dropdown fields on mobile
Hi, I tried translating the values of a dropdown field to sapanish and found that my existing triggers related to the options chosen on that field still work while using the web but fail when using the mobile version. Is it a known error? Thanks!
Cancel subform delete
I have a form with a table of subform rows. I need to allow users to delete rows but not all rows. The capability to delete a row needs to be determined by a value in the subform record. I understand that I cannot conditionally enable/disable the delete function but was wondering if there was another way to achieve what I want. The onValidate function of a form provides the ability to 'cancel submit'. A 'cancel delete' function in onDeleteRow could give me what I need but alas it doesn't exist. onDeleteRow()
Menu - Sync Across Platforms
Hi, I've just noticed that my menu's are different across the different platforms. Is there a way to sync them all to my laptop view? Thanks
Data Limitation
What is the real limitations of size data and columns of a table in Creator? How many rows of data can it handle in a real production environment? At what point the performance of an app starts suffering because of size of table or total data size of an application?
Amount in words
Hi, Is it possible to get Currency in Words ? for e.g Total Amount is Rs 100 In Words: One Hundred Only.
Is there a way to send Uploaded Files from one application to another using postUrl?
I need to send a file from an application on one account to an app on another account, possibly using postUrl(). I'm currently getting an error when attempting this. Is there a way to resolve this?
Timeline in detail view
Hi, How do I create a more rich details page about, for example, a project. So when you click on a project in a list it goes to a new page which shows the information about it, but also a timeline for that project only. I think the pop-up sliding in from the right isn't big enough for large projects with lots of information. Thanks, Stefan
Zoho Or Knack
Hi, At the moment i'm creating an app with Knack that needs to handle team scheduling, equipment reservations / bookings (with stock on certain dates) and combined with this a ticket system (and maybe in the future time tracking). With Knack i'm running into the issue that it doesn't handle time/reservation systems very well. Does Zoho do this better? In the system I want to have multiple types of data that all needs to be combined: Team / Crew Projects Freelance crew Equipment (with the possibility
Statement Execution Limit Problem
Hi, I'm trying to fill some drop down boxes based on a previously entered value, where it has to search through just under 1000 entries. here is the code: for each AT in Asset_Types { if(input.Asset_Type = AT.Asset_Name) { for each AC in AT.Asset_Components { for each CT in Component_Types { if(CT.Item_Name.contains(AC)) { prefix = CT.Component_Code_Prefix; for each comp in Component_Stock { if(comp.Component_Code.contains(prefix)) { if(i = 0) { input.Part_1:ui.add(comp.Component_Code); } else
Changing Subform Fields via Script
Hi I have a process that basically confirms an order, the MainForm sends Email, the Email links to Stateless Form, the Stateless Form changes the Confirmation Field on the MainForm. This all works wonderfully but I now need to change the value of a field in rows on a subform in the main form when the Confirmation Field is changed. I've tried daisy chaining the scripts via 'On User Input' of the changed field but this only works when I change the field manually in the form, how do I get it to change
Passing a parameter to a drop-down field
Hi Zoho, How can I pass a parameter through the URL to a drop-down field? Thanks Ravid
SaaS Challenge - No Admin or ability to preload data, what are my options
Dear friends As we all are aware Zoho is launching a SaaS model, and I know there has been quite a heated debate - and as it is still early days, more debate to come. Personally I think it is a good move, but it is posing some challenges. You might be aware there is no Admin function (from developers point of view) so only the customer has access to their instance. This is mostly OK. You may not be aware that there is no Audit function, nor is there the ability to preload a form with data. The audit
Error with json response in REST API - List Forms in Application
While working today on an application, i needed to fetch all the forms in my application, using the REST API - List Forms in Application to perform some functions on it, then i noticed the json format ruturned - the "display-name" was interchanged for the "component-name". here is the response in json below: {"application-name":["chservicesalesmgt1-ide",{"formList":[{"formCount":20},{"linkid":26,"displayname":"Add_Invoice","componentname":"CheckOut","type":1},{"linkid":27,"displayname":"Add_Discount","componentname":"Add
What is the difference between customers & users
Hello, I don't understand the difference between customers and users. Can someone explain it to me? What are the limits for customers? Thanks, Stefan
Write a common function for invoice calculation.
I have an Invoice form. I need to calculate invoice totals every time there is change in some fields (for eg. product, quantity, price). Is it possible to write a common function to calculate the totals instead of doing the calculation in every field.
In zoho creator do we have search with barocde scanning for form detail page?
i want to create an app from which a person can read the barcode of prouct and get the details of that stored in form detail page
Access MainForm dropdown selection in subform
Hi I have a lookup in a subform that i want to filter based on a lookup selection in the main form. how to do this? e.g Main form i have a dropdown called Customer - based on the customer selected, in subform, i want to show only products pertaining to that customer. I did a set_filter for the lookup in the subform: Customer == Main.Customer This doesn't work. If i hardcode a value, Customer == "abc" it filters correctly and shows
Pivot Table - Query - Last Records
I have a log of sorts. Each log has a unique key pair (two values) and based on random dates, I add an entry. For example: Item 1 - Sub Item 1 - 01-01-2019 - value1, value 2 Item 2 - Sub Item 2 - 02-13-2019 - value1, value 2 Item 1 - Sub Item 1 - 06-05-2019 - value1, value 2 Item 1 - Sub Item 1 - 07-01-2019 - value1, value 2 Item 2 - Sub Item 2 - 04-14-2019 - value1, value 2 I only want to produce a report that is based on the key pair - Item # plus Sub Item # for the last date. So the report would
Change Text Color for each choice in a drop down box form.
I have attached a partial image of my form. Under the Status Field, I have 5 choices in the drop down box. Is there a simple way to change the background color for the text? I would like to have a different background color for each choice in the drop down box Is an html page used? If so, how is it done. Thanks so much, David
Import - CSV or Paste
Hi, If I import this data, the import date-time field shows up blank. Any suggestions on why?
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
How to round down?
I'm not sure what I'm missing here. But I cannot find a way to round down. In my situation I'm calculating the amount of Years between two dates represented by a Decimal with only 1 decimal place. I'm calculating this based on the days between the two dates. If I have two dates that are not quite a year off say 0.9888888888888889 days, then .round(1) will give me 1.0 and returning 1.0 when it's less then a year would not be accurate. I need it to round down to 0.9 but I can't seem to find a way to
OpenURL to pass ID to stateless form within a page
Hello All. I have a Form called 'First' A Report called 'All First' A Stateless Form called 'First_Party' (identical to 'First') And a Page called 'Ticket' On my Report I have a Button (report workflow) that runs the following when clicked: openUrl("#Page:Ticket?Field=" + input.ID,"same window"); 'Field' is a single line text located on the Stateless Form (First_Party). Expected behaviour: The Page is opened and 'Field' dispays the ID Actual Behaviour: The page is opened and 'Field' is blank. Can
How can perform a bulk record deletion in a zoho creator app?
Hello, I am Developing a solution and i am trying to create a function that will delete all records in all forms in the application. here is what i've been able to come up with: string AppConfig.clearAllAppData() { /**********************************Log variable declaration**************************************/ fullLog = ""; name = ""; recCounts = ""; deleted = false ; /**********************************END-Log variable declaration**************************************/ /*************************CONST
filter multiple reports on a page by clicking on a record
Hello, I would like to filter several reports displayed on a page by clicking on a record. Example: I have a parent form: "Patient" and several child forms: "consultations", "sport" etc ... displayed on a page. By clicking on a "patient", I would like the "children reports" to display only the data for this patient. Here is a diagram. I thought to define a variable "Patient_Id" then to filter the other reports using this variable but I block at the level of "Filter". Thanks.
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
Import - Excel - Number to Long
I am importing an excel spreadsheet and during the import, one of the fields looks like this .. 32.799999. However, in excel, I put 32.8 and format the cell to only 2 decimals. Is this is a bug in the XLS import?
Update All Rows in Sub form
Hay , Have one Form Named as OWNER with fields:- NAME (Name Field) CURRENT ADDRESS (Address Field) ADD CONTACTS (Sub Form of CONTACT- CONTACT is Different Form) Sub form Fields- TYPE , COMPANY , ADDRESS , DATE , COMMENT , BID i need when user enters NAME , then Automatically TYPE = "OWNER" , COMPANY = input.NAME , ADDRESS = CURRENT ADDRESS , DATE = zoho.currentdate in each row in sub form . And Disable NAME ,COMPANY,ADDRESS ,DATE in each row too. if NAME updated in future then COMPANY = input.NAME
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
Example of use of 'contains' to search for a sub-string when using zoho.crm.searchRecords - needs asterisks (wildcards)
In case anyone else has this question...I wasn't as clear from reading the documentation how to make this work...so I did some experimentation and came up with the following - the trick is to place asterisks directly before and after the 'substring' you are searching for (it doesn't make sense to me to ask users to do this)...note I am searching the 'First Name' field of CRM records... searchSubString = ""; searchSubString = searchSubString + "(First Name|contains|"; searchSubString = searchSubString
Populate data in SubForm from other Form
Hi there, I'm a little bit lost creating a subfom script to populate in this subform data from an other form. Let me explain it: I have a form (Products) to define products details... In this form, I have the following fields: - Product_Number - Product_Name - Product_description - Product_Stock I would like to have a second form (Requests) where I have the following fields: - Date - Requestor_Name and a subform (SubForm_Requests) with the list of all products defined in the Products Form and 1 additional
Use variable for show/hide field name
I need a way to use a variable to show or hide a field name (ultimate goal is to show fields based on the values in a different table) Let's assume that there is a field called "Email" What I need to happen is: foobar = "Email"; hide foobar; Unfortunately this results in an error message: "Variable 'foobar' is not defined. Is there any other way to show/hide a field where the field name is determined by a variable rather than the exact field name?
Condition Filter for a lookup field
I have a lookup field for equipment when a user is entering a transfer of equipment. This form first asks if the user is transferring equipment IN versus OUT. I want to limit the lookup results to contain only items that are IN inventory ( a field on the equipment table called In_Inventory) when the user selects transfer OUT (you cannot transfer what you do not have in inventory) and the opposite when transferring IN (you cannot transfer IN what you already have with a serialize inventory item).
Next Page