Data Access lookup fields
Hello I need some experts help asap to make the below function workable. Very simple...yet... FORM CATALOG: Product_name will list only Products on the selected Category. Price will show selected product price Have created 3 forms: Form Product_Group containing Category (field) Form Products containing Category (lookup), Product_Name and Price fields Form Catalog containing Category, Product_Name lookup fields and Price currency field Tried already filters, fetch record, for each record, an several
Is it possible to get GeoLocation for mobile form?
I am trying to create a custom app where we record the geolocation on submit. I have been able to get user IP, latitude, longitude and submit with form. However, IP is not very accurate. Here's what I"m using: IPAddress=zoho.ipaddress; User=zoho.loginuser; location = getUrl("http://freegeoip.net/xml/"); Latitude = location.executeXPath("/Response/Latitude/text()"); Longitude = location.executeXPath("/Response/Longitude/text()"); I would like to use something like this from client-side: if (navigator.geolocation)
Domain mapping
Does anyone know how to create domain mapping in ZOHO CREATOR ? I have tried to follow the documentation but on my setup screen there is nowhere I can enter the domain name to be mapped. The documentation leaves a lot to be desired. Mike
How can I integrate my zoho creator app inside zoho people?
Hi! is it possible to integrate my zoho creator app inside zoho people? if so, how can I manage that? I would really appreciate your help! Thanks.
Using bookmarks in the HTML page
Hi there, how is it possible to use bookmarks inside the HTML page ? I set up a bookmark with <a href="#link">Part 1</a> and mark the HTML block with <h2 id="link">Part one</h2>. When I run the app, open the page and click on this hyperlink, app opens another view/form which is placed first in my app. I checked the URL behind the link in the running page, it looks like https://customerportalname.zohocreator.eu/portal/appname#link which is clearly wrong as it misses the page name. Any ideas how to
add a subform item opening its form as a dialog
I wish I could add a subform row by filling its form as a dialog. That way, subform would act like a view. That could be an option when a subform is created based on an existing form.
Date-Time Field valication
Hello,I am developing an Room Booking apps for my company. I am using the date-time fields to create Start & End points. How can I block certain hours from the fields or maybe display a warning on form validation? Many Thanks
Iterate multi picklist errors
Hello, I'm trying to set up a script wich iterates values in a Lookup field with multiple entries. I have 2 forms: Werkopdracht wich contains the lookup field medewerkers_select Medewerkers wich holds the field Voornaam (text single line) wich is related to the lookup field in the Werkopdracht form and has a field wich contains and email field; email_medewerker I want to send any individual selected person in medewerkers_select and email when the Werkopdracht form in succesfully submitted. I
Load all [input] Fields in Form with specific 'Fetched Record' Values
Hi, Till now, we are able to only set individual field values using the 'set variable', in a Form. Could we have a statement, or variable name, for the current unsubmitted records, i.e all the form input fields, so that all their values can be set to a fetched record value, in a single statement. This can only work for, forms fetching data from the same form, or in an identical stateless form. lastrecord = (Songs[ID == input.ID]); //fetch record e.g formdata = lastrecord ;
Customizing the embedded report from Zoho Creator
Hi there -I have a report from my Zoho creator App that I am embedding on an external html page in an iframe. I am trying to customize it a bit further and was wondering if anyone had an idea on how to accomplish these 2 things? 1) Would like to customize the drop down column menu when clicking on the header/title row - right now it shows the eye to search and i can click 'Start' below and have it show me the 5 options of Sort by Asc, Desc, Group by Asc, Desc, and hide column. I want to get rid of
Zoho Creator PDF Export
Hi, I would like to export a page with a record view in Zoho Creator automatically with the URL structure http://app.zohocreator.com/name/application name/pdf/page name. But unfortunately when I open the URL and open the downloaded PDF it shows me instead of the records just Loading... Is there a way to make a delay that Zoho Creator can load the reports before the page is downloaded as PDF? LG Niklas
Hide Submit Button
Hello, I am using a form that calculates user data and displays the result; http://www.beergrains.com/priming-sugar-calculator. I have no need for the SUBMIT button and it is causing confusion with the users; when they click Submit the results appear then quickly disappear. They just need to view the result without submitting data. Is there a way to hide the submit button?
Issues with Customer Portal feature.
Hello ZC Team, I have a couple of problems in using customer portal: When the settings is such that users need the approval of the admin, the entire workflow doesn't tell that to the signing up user. The user gets the invitation email, gets the add-password link too. All this gives a false impression to her/ him that there is no approval involved. We really need the message to read something like - "you will receive an email with further instructions *after* the administrator approves your request."
Dealing with a poorly formatted query string
Hi! A third party is opening a form that I've made, and is including the query string "?first-name=Rob". Is there any way to get the value of "first-name" into a field in my form? Right now it doesn't work because Deluge names can't have "-" in them. Thanks!
Custom domain for zoho creator app
I am creating an app for the workplace of a large company. Unfortunately, it is like working for the government and I cannot convince the enterprise security folks that zoho does not pose a threat to their security and they have banned the zoho.com URL via their firewall. So I am considering whether or not I can use a private domain access to zoho in order to access a creator.zoho app. I believe that if the app were accessed through my_domain.com in some way that things would work. Am I understanding
mobile app - notification on android/iphone of new records in view?
hi employees use zoho creator mobile app on their androids and iphones for employees there are opened few views how to make that mobile app will notify about new records? icon stickers, pop-up messages
Subform dynamic lookup filter lost after creating a relationship with Main form
Please can you help explain how I can filter the choices on a subform lookup field based on an entry in a field on the main form and at the same time keep the subform row choices in the Main form report so I can analyse them and calculate a total. I am very new to this! I am creating an invoicing application. I have created an Invoice form. I have worked out how to select a customer from a customer database. Each customer has an insurer, but the amount I can bill the customer for different tests
Calculating number of days between two dates
Can this be done, perhaps as a custom function? If I subtract date2 from date1 I get a (large) integer, which suggests that dates are just integers under the hood. So there would be a way to do element date match. A good example might be to calculate accounts receivable aging...a fairly common sort of thing. Before I try to hack my way through this, is there a straightforward method or has someone written code they would be willing to share? Thanks!
Printer for mobile app
Hi! Need to connect Zoho Creator App on iOS to printer. We have to print right from the app PDF documents.
Reference field Lookup not having the value 20. Adding records from one app to another Error
I am trying to insert records from one application's form to another, but there is one problem. The lookup field DocNumber which links the designated form in second app gives an error during the Insert into process. I tried making the field both Autonumber and typing the value manually. Here is the code I have: Initial application and form name: app1, Form_request Target application and form name : app4, Form_Expenses Function in app4: void form_expenses.createRecord(int var1, int var2, string var3,
Add table to query from?
I would like to use two fields (thickness and length) to fetch a price from a grid. I would like to transition from excel (or zoho sheets) to creator. For example: If a user input in on a from lengthfield "31" and thicknessfield ".375", I would like to see the value of $7.84 returned.
Subform lookup field not populated when offline
Lookup fields on the parent form work when offline, but any lookup fields that are in a subform always show the "no internet connection" screen when offline - even if you previously load the list (and theoretically cache it). I even tried downloading the list of values hoping it would use that - but I just can't get it to show lookup values in the subform when offline. Anybody encounter this? I really don't want to have to hardcode the options in a dropdown as the list is fairly dynamic.
Check if subform has records.
Hi! :) I have a mainform and a subform. I want to disallow that a record at the maiform can be deleted if there are records at the subform. Please advise
OpenUrl to Export Record Summary Template to PDF
Is it possible to export PDF of custom Record Summary Template using OpenUrl? So On Submit it exports to PDF? Using the script below just creates a pdf of the actual view. Not of the individual record. openUrl((((("https://creatorexport.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/pdf/<ViewLinkName>/") + input.ID, "New window"); Damien Cregan Hire an Expert
input null to a functions - get an error
Hi Zoho, I have a function, with few variables including a date variable. I have a script in the function for cases the date variable is null. On some cases when I use the function - I have no date variable - meaning it's null. When I write Date01=null; thisapp.function(var01,var02,Date01); I get an error: Mismatch data type for function 'CreateSolveDeleteFnA' at argument index 15 expected data type TIMESTAMP found data type NULLTYPE How can I enter a null variable ? Ravid
How to build report using check box data?
Zoho Creator says that a known limitation is that reports can't be built from data recorded through multi-select or check boxes. Surely there MUST be a way to do this! It's true that these fields don't show up in the drag and drop menu for me to build a pivot chart from but has anyone found a way to do this? It's pretty essential for my application. Thanks, Lindsay
Check Box field in Pivot Table
Is there some problem with using a check box field in a pivot table? When I go to set up the table none of my checkboxes appear in the field list to select from. Weird and really a problem for me. Thanks for any thoughts.
Adding a rule to style
Hi Zoho, I have some parts of page that I'd like to show only to one user. Instead of using "if" every time on the page, I'd like to create a style. I've created this function: string styles.EditPossible( String UserName) { if (UserName = "CorrectUser") { EditPossStyle="<style>.EditPossStyle{display:inline;}</style>"; } else { EditPossStyle="<style>.EditPossStyle{display:none;}</style>"; } return EditPossStyle; } And i call it one the html page using <%=thisapp.styles.EditPossible(zoho.loginuser)%>
Connecting to my Zoho Reports Database via Google Appscript & JDBC
I'm wondering if this Google AppScript (below) can be used to connect to Zoho Reports via JDBC. I have successfully managed to connect to my database via the JDBC driver and DBVisualiser but haven't managed to adapt the script to work so far. Are you able to provide any assistance please? Or can you advise another way to get my database info into google sheets? Thanks, Stuart. // Replace the variables in this block with real values. var address = 'database_IP_address'; var user = 'user_name'; var
Automatically add subsequent datefields over a time periode
Hi I'm quite new to Zoho Creator but the possibilities seem endless...if you know your way around. I'm building an application for the management of participants on a long term training course. Participants have different start dates. Form 1 has all the details on the individual participants. Form 2 is a attendance protocol foremost for adding participants to the report. The report is the actual place where I do day to day updating of the protocol with attendance/no attendance/sick/absent with
to copy an specific field from a lookup - dropdown field
Hi, I have a form named "Customer" with Name, Lastname, Address, etc and I have another form named "Orders" with a lookup/dropdown (this field is named "CustomerOrder") to the first one. In "Orders" I need to have a field with the name of the customer, then I did a Formula Field related to CustomerOrder Field, but it returns the ID of Customer and not the name What can I do? Thanks in advance
Unable to install Order Management 3
Hi all, Can any1 help me or guide me on how to install order management 3.0 apps, as i stuck up on loading OM 3 page and doesn't move further. Thanks in advance
Mixture of number of columns in a form
Hi, My sub forms need to go the length of the form because their information is presented horizontally but data from my other fields would be more successfully presented in 2 columns. Is it possible to develop column breaks so that I could more effectively present my information? Thanks
Senmail with Toaddress
Hello Zoho Team, The code below was working months ago, now its not working, can you help me in order to identify where is the error? Thanks a Lot. void busqueda.busquedahr(Armar_Publicacion myRecordID) { for each record in myRecordID { for each email in record.Toaddress { sendmail ( To : email From : zoho.adminuserid Subject : "Busqueda Consultor - Posicion : " + record.Skill
Custom action to edit record in edit mode..
Hi I'm trying to use a custom action use a function to open a form at a specific record...e.g. http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> Here is the command I've using.. I know the form name is right and the reportLinkName is right (as far as I can tell..) - the form shows up but there is no data in it.. when I mouse over an existing record I can see the ID - which I've copied and pasted... any ideas what I'm doing wrong?
Filter subform items based on parent form
I have a purchase order form with a subform for adding items to the purchase order. I only want parts that belong to the vendor selected in the parent form to be available in the subform lookup field. Each part in the subform is related to the vendor selected in the parent form. How can I apply a filter to the lookup field in the subform based on the vendor selected in the parent form? I'm trying to use the Set filter in the field properties section but maybe this needs to be done with deluge.
what happens to data entered into form if user loses connectivity?
Im designing an app for data entry and was curious what happens if connection is lost (or user goes into airplane mode). For mobile users, I'd expect that the reports will be unavailable, but will the form be unable to be accessed? For PC use... Is there a way to have it store records locally until connectivity is restored, then automatically push them back up to the cloud once connection returns? My users travel a lot and I think being able to enter data while in flight would be valuable.
Create New Record Summary?
I want to create a new record summary which only shows certain information. I've been trying to follow the online help, but it's not working. Online help: Select the Record Summary option from the Report Settings page. Click on New Record Summary to create a custom record summary. If you look at my screenshot, you can see I'm on the record summary page, but there is no New Record Summary button. Am I missing something?
The names of the fields in a pivot chart appear different from the form.
I have more than 5 pivot charts, but the name of the fields appear like: "Number", "Number1", "Number3" etc etc etc.. why happend this? and I can't change it or fix it, can someone one help me?
Decision Field width in subform.
Hi Everyone, I'm new here, but am getting my feet wet with a fairly complicated app. I'm just wondering, why can't I resize a decision field in a subform? I have a lot of columns in my subform, and three decision boxes. They are killing my column real estate. I expected this answer to already have been asked, but I have been right over the forum and can't find anything similar. Thanks, LJ
Next Page