Reg - background image for published form
Hi, Good day to you! Can I have a background image for published form? if not please let me know what can be done for the below query. I want to share the form in public with my favourite image as a background. Background color is not enough. Thanks, ITKES
Failing validation of commas on decimal fields
Hi, There's a huge problem with decimal fields and commas. Commas are not recognized as illegal characters, but are simply deleted in the decimal field. This is ridiculously problematic and should be fixed asap! We cannot have any kind of confidence in the data collected by Zoho. Here's a screenshot of a simple alert box script on input. As you can see, the input contain a comma, but it is not converted to a decimal point. I have honestly never seen anything like that. Please make commas illegal
Lookup field with a FILTER and SORT not sorting correctly
Old program, no changes on my end. I have two lookup fields. First one for Category the second Product. Select Category. The second field Product has a FILTER from the Category field. The list shows up but the items are not sorted correctly. How do I get the items sorted like they use to show up? Do I have to manually sort the list now?
How to create report of multiple form which are not linked by lookup -
Hi, I have a form - which in turn has a subform. They are not linked by lookup. It has a 1 to many relationship. I need to form a report with data from main form and subform. Only problem is that the multiple rows of the subform data comes together in one cell/row. I need to have them in seperate rows For Eg Main Form Subform A A - 1 A - 2 B B - 1 B-2 B-3 After looking at the advise given in other
Can a report be generated and displayed [no edit] without a base Form?
I am trying to generate and display a free formatted worksheet like report [say Daybook] based on a set of records created using a Form [say invoices]. New fields [columns] will make up the report based on field-values collected from Invoices. How to do it?
Replicate data from one form to another based on drop-down selection
Hi I'm a beginner to ZOHO Creator (and programming) and trying to understand the method of populating fields in a form (fetched from another form) based on a selection in a drop-down box. Let's say I have 2 forms; - One"Golf_Bag" form with following information fields created; "Club", "Brand_of_club", "Model_of_club", "Loft_of_club". - Another "Input_data" form with corresponding fields, and where "Club" is defined as relation to the "Club" in the Golf_Bag form and is selected in a drop-down box,
Generate Record Summary in Pages
Hello to all I have a Question, i'm trying of developing in the part of zoho Creator "Pages", generate a Record Summary, my question is. How can is generate a Record Summary from pages of Zoho Creator. Example if ((formulario.ID_OPORTUNIDAD != null) && (formulario.ID_OPORTUNIDAD != "")) {%> <div elName='zc-component' <iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/irojas/formulario-acta-de-entrega-vendedor-cliente/form-embed/Acta_de_Entrega_Vendedor_Cliente/VU9OXE27r0B8b1RNAHbptV3atDHpfOmkHOumnzrknJ5kTNwpfs6wBO35ARr7bGOTY8zmTPhMqADNm1SjOfu3gpAF4wKAxM137740'></iframe>
More than one copy of the same subform in a form - data from subform copies not added to report
Hi Zoho, I have a form and I'd like to use a subform in it. Among other fields, the subform has a "type" field with 3 options. I'd like to have 3 copies of the same subform inside the form, one for each option - so all entries will be joined in one report (also for ease of use so I won't have to create 3 copies of nearly the same form). How can I do this? Trying to simply add copies looked ok at start but viewing the report the entries from the 2nd and 3rd copies were not added (the form was submitted
Problem in Lookup field in Sub Form
Hi i am having a Sub Form in a main form. The Lookup Field in Sub Form is baased on a value from the main form.SO while adding i dont have any issues the Lookup field works good But if i try to edit that drop down field its showing all values in the LookUp rather than the fiterd value Seeking a solution for that. Code for Subform On Add Row if (row.Order_No == null) { ord = (Order_Management[((Client_Name == input.Client_Name && Rate_Id == input.Rate_Id) && Order_Status == "Active")].ID).getall();
Creating a good looking form in the form creator
Hi Everyone, How would I make a form that looks like this form including custom placement of fields, buttons etc. and also tab controls just like the form I'm writing this posting in the form creator? I'm assuming it's also made with the form creator. Currently the form creator will only create very crude and basic looking forms that stretch across the entire web page. Truly, Emad
Best Way to Merge Offline App Forms with Regular Forms Data?
Hi, I have users who go out into the field without Internet. We need to enable them to enter data into our Forms. Given Zoho restrictions I can't cache Forms for offline access if they have any Deluge scripting anywhere in the Form but in On Validate and On Success (see: https://www.zoho.com/creator/help/application/offline-mobile-access.html)... As I have a lot of automation in my Form's Field Actions, I have to create a separate Form specifically to allow offline access. For example, let's say
Auto Stock Level with a Reorder report
I am starting to create an Auto Restock level based on Products Used, Current Inventory and Purchase orders. I have a form for Products Use, and Inventory, and a Purchase order. I am trying to determine if I use a "For Each Statement" or a "GetTotal Statement". Here would be the theory; when a product is used, it would count how many of that product were used in the Past (Selectable time, say 90, 120, 365 days), and put that number in the "Stock Level field" of the Inventory Field. Then auto create
Duplicate report function not savings duplicate reports
Good afternoon. When clicking on the "Duplicate" link under the report while in the Creator Application Dashboard, the system gives a "Saved" message, but does not return a duplicated report. This has worked as recently as an hour ago. Now, no reports are duplicating. Can someone assist with troubleshooting? Thank you!
App from G Suite - Spreadsheet
Hi, I converted by Google GSuite Spreadsheet - to zoho creater APP. My question is - once i have converted to APP, is the communication still there with spreadsheet. I mean any change i make in G Suite Spreadsheet - will it get updated to ZOHO app and vice versa. Any one with any experience on this
HTML to PDF
I'm going to use a page to generate an HTML invoice. I will then use a webhook to send a URL to pdflayer to generate a PDF. pdflayer will respond with a URL where I can download this invoice in PDF format. Question: is it possible to take that URL , download the PDF and save it to a creator form?
Custom layouts for forms and pages
I have seen many posts where people indicate they are using custom layouts on their forms, but the Zoho Creator does not have custom layouts. I hope some of you will share how I can also do that. Since I'm still learning how to use Zoho Creator, it's very frustrating to find out there are no tutorials on the Zoho web site or even on Youtube showing how to do it. I have seen that many of you have used inline CSS to make the custom layouts. I can look for some inline CSS layout code generators, but
Stop Rounding Results in an Equation Until the Final Value
We have a formula where we calculate a daily rate down to the 6th decimal place. A precision calculation. For example: 1000 * 12 / 365 = 32.876712 Despite trying many alternatives, I can not figure out how to get this number, the result is always rounded to 2 decimal places. Like so... 1000 * 12 / 365 = 32.900000 I have the result going to a decimal field with 6 decimal places. But it still shows up as 32.90. I tried the round function..still 32.90. I have also tried toDecimal function too. (1000
Integration with otp
Does zoho creator support OTP integration?
Inventory Management
I am trying to use custome action on a report to transfer data from one form to another and make the new form editable is the possible
How to sort results of CRM API response
I'm requesting records from CRM API inside a custom Creator Page using code like this: apiUrl = "https://crm.zoho.com/crm/private/json/CustomModule3/searchRecords?newFormat=1&authtoken=XXXXXXXXXXXX&scope=crmapi&criteria=(Device_ID:99999999999)&sortColumnString=ID&sortOrderString=desc"; apiResponse = getUrl(apiUrl); I need the records to be listed in DESC ID order. So the most recently entered record will show up first in the list. How can I accomplish this as the searchRecords method does not seem
Problem in sharing application
Hi, I have tried sharing my application with the other user, but unfortunately it is opening with the other section instead of opening with my section which I shared. I don know from where it is taking that url. Whichever the section I share it is opening for the user only with the particular same section. It is urgent. Please help me out of this issue. Thanks, ITKES
Insert sub-form records individually in record template
Hi, I need to add the fields of my sub-form record individually in my template and the hard part is that i need to do it individually for each record. Is it possible? Regards
Function - passing current (sub)form data to function impossible?
Hello, I am trying to make a function, that would as parameter get the current subform data, and based on that make calcualtion. But it seems impossible, I get an error: Error details: Error in executing On User Input script of the field, Štev. obiskovalcev Error. Error in executing Set Variable task. Unable to update template variable tot. Error evaluating NUMERIC expression : Error evaluating COLLECTION expression : New Collection row cannot be passed as argument to function. It seems like Zoho
Lookup fields stopped working today
I have been running my app for almost a year now, no changes on my end. Today my lookup field to lookup field stopped working. I have a Category and a Product lookup field Category is selected first I have about 7 categories (flour, sugars, spices.....) I select flour and the next field should limit the Products to just the Category of flour, but today it saying "No Matches Found" I havent changed anything on my end. I look at the FILTER section on the Products field and it has SET FILTER checked
Missing display fields in a lookup field
Hi Everyone, I have a lookup field that has a filter set based on a previous lookups selection. Similar to the country and state scenario. My scenario is a vehicle make, model and variant scenario though. I have a form for each - one for make, one for model, one for variant. Make just contains a single line for vehicle make Model contains a lookup to the make field and a single line for model Variant contains a lookup to make, model and a single line for variant but also a dropdown for year from,
multi select lookup with reports
i want to create a report for that selected lookup field entries how can i do that can you please send any sample code ? for each item in input.Students1 { ins = insert into filtering_students [ Added_User = zoho.loginuser Add_Academic_Year = item.Academic_Year Manage_Course = item.Manage_Course Manage_Batch = item.Batch Date_field = item.Date_field Add_Subject = item.Subject_field Students =item.Students1 empname = item.empname ]; } its my code . students1 is a multi select look up. but it throws
Acceso de info a clientes
Hola. Existe la posibilidad en zoho de dar algún tipo de acceso a mis clientes donde únicamente puedan ver su información sin necesidad de que tengan un usuario o rol???
image are not getting fixed size in pop up window
hello zc, In a form i add a notefield where that note field is used for showing image.when the form opens in main window the image size getting fixed when the image opens in pop up window it is not getting fixed.can anyone tell how to make a fixed size even in pop up window? input.plain = "<img src='https://www.smashingmagazine.com/wp-content/uploads/2015/06/07-functions-opt.jpg' height='300' width='1000'>";
Sub-form templates
Is it possible to combine multiple templates(templates of a subform) into a single template(template of main form)? I want to show all the subform templates together in the main form.. is it possible?
Grouping Drop Down Values
Hi All, I'm trying to get a Parts Selection sub form working in my Repair ticket form. I have 4 fields in my sub form: Model Parts Catagory (Base Plastics, MotherBoard, Screen PLastics, Screen etc..) Parts Description (this would list say Screen Fascia, Palm Rest, Screen Lid etc..) Part No. What I want to be able to do is Choose a category, which then lists the descriptions under that category but only category once. So for example, I choose "Screen Plastics" as my category and I want 2 options,
Retrieving actual text from a Lookup Dropdown
Hi Everyone, I'm following Zoholics videos on Deluge and used this statement to lookup the pizza price from the Inventory: colPizzaDetails = Inventory[Pizza == input.Pizza && Size == input.Pizza_Size]; This error is displayed when trying to save the script: In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid In the video, he was able to save the script. Looks like a BIGINT is stored in the Lookup Dropdown now instead of text as shown
How to Cache Lookup Fields for Offline App Access?
Hi, In the Offline App access section it says that my Form will be cached for offline access if it meets the conditions here: https://www.zoho.com/creator/help/application/offline-mobile-access.html My app meets these conditions and is available offline, however, I notice that the lookup fields are blank. Obviously this surprised me, shouldn't the lookup fields be cached so they have all existing choices in them when offline? I noticed that if I load the Form online, go through all lookup values
Simple search interface with a Lookup Field instead of Single Line
Hi, I want to apologize if my question seems too trivial - I am just getting started with Zoho, and I figured almost everything I need except for the search function. I want people to be able to search my records using their email. I used the Search Interface in Zoho Creator tutorial available on this page - https://www.zoho.com/creator/help/application/search-interface.html. Search works when I am querying a form that uses Single Line to store data. However, the problem arises when I search the
Google maps
Hi guys, Is it possible to integrate google maps? Simple example: I have road warriors working for me, but sometimes they don't the route. Is it possible to just input a location into a field and let google maps get it automatically ? THanks!
openurl popup
Using the popup option in the OpenURL is there a way to specify which monitor? I have 4 monitors and would prefer the popup to open on a different screen rather than cover the original creator screen.
View field records
Hi guys, On the zoho creator app, how can i modify what i see, when i click on reports? For example: Report A: Record A Phone number A, Status A Record B Phone number B, Status B But i would like to see: Record A NamePerson A, Status A
Question about round function
Good Evening. Maybe an easy question but I am trying to understand how the 'round' function is working. So, I read the tutorial but my question is the following: If I have a number lets say 13.26 how can I round it to 13.50? Another examples: 13.26 -> 13.50 13.24 -> 13.00 13.76 -> 14.00 13.74 -> 13.50 I think that you get my example. I do not know how can I do it with the round function.
Fetching or Updating records between form and subform (in another form)
Hopefully it is easy to fix; else it might be a cool challenge ;-) I am building an application where we try to provide customers a service where we collect offers from partners that we work with. I have a main form called Leads where our customer request is being stored. In this form there is a subform (Offersummary) with a simple lookup picklist dropdown to select to which partners (field: Offerpartner) we request an offer. In general we have 3 partners receiving a request from us to make an offer.
send mail record update
i have seen some post relating to using send mail and with in the email it contains a link to the record to edit the record. However I want to know if it is possible to have a URL to actually update a record, with out the user ever having to open the form? Use case would be something like a invite email and with in the email they either hit a will attend button or a will not attend button and this will update the forms accordingly.
Edit and replace an uploaded PDF?
In an application, documents are uploaded for management review and signature. Is there some expeditious way in which we can avoid downloading from the link, editing and then uploading the new document? All ideas appreciated.
Next Page