Get value from 2D array of decimal numbers
I am trying to determine if Zoho will work for our company. The only issue I have found so far is whether we can get a specific value from a large two dimensional array of decimal numbers. I have examined the list functions that apply nicely to one dimensional arrays and can imagine some possible ways to use these. My possible ways are very inelegant, however, and I suspect others have found some elegant ways to do this. Barry Sammleton Distilling LLC
Zoho API support InsertRecords by json
Hello! I'm looking at https://www.zoho.com/crm/help/api/insertrecords.html for insert record and it seems that the only way of insert new records to the api as xml. Does this mean that json is not supported as the insert methods of the API? Can anyone please tell me when json format is available to insert the records? Regards, Debasish
Lookup field selection populating the next field
Hi All, I have had a good read through the forums and tried several of the examples but to no avail. I have a form called "Parts_Used", which has several fields that are all lookups to various fields in another form called "Parts_List". I have currently got it working so when I choose a category it only filters the part descriptions under that category and then like wise I have a 3rd field that only shows the part numbers that are relevant to the part description. What I need is that when I have
Record summary based on subform
Hello, I would be really thankful if anyone would be able to help me with the following issue. So i am trying to build an invoice creating app which would use data from subform and would result in record summary such as this https://www.zoho.com/creator/help/views/record-summary.html . Each time i try to create a record summary, it displays every item separately on different page. How can i create a table out of a subform with subtotals and totals that would appear in record summary? Thanks
Pull Information From Lead Website
I am updating old leads where information was not input the right way and I am now trying to fill out company accounts. I find myself going to the company websites and finding most of the information like address, phone number and e-mail at the bottom of almost every website or on an about page It would be great if I could give Zoho a company website and then have the basic information auto populated. If it is too hard to have the information found on the company website then give me suggestions
Sharing of Reports
I have an administrator account and an user account for my application. Let's say that in the main account I have a couple of delivery boys. EXAMPLE : Ram, Karan, Arjun, Ritvik. Now I create user accounts for all the delivery boys. Now when I log in from Ram's account(let's say), I want to show the deliveries that are assigned just to him. I have tried restricting visibility and everything. But in Rams account, I can see the deliveries of Karan, Arjun and Ritvik also. Example: List of orders- The
Thinking of moving to Zoho
Hi, im looking to develop my app and have come across Zoho Creator, I was looking to see if i could achieve the following with Zoho; can i print a pdf with data for one record and include data from other related forms. to link child records it appears in need to add a form to the parent form or in the child form have a loopup field, is there a way to progmatically link the child records maybe using caseid as a variable? can variables be initialised when selecting a record to be used whilst working
I want to create a multi-column order form for wordpress
I need a production order form for my client. I have an excel spreadsheet and I tried to import it but then it got too tricky. Does anyone have an idea about what I should do?
Zoho Creator and Quickbooks Update Records
I have successfully configured adding a Customer record to QuickBooks from Zoho Creator, but I am now trying to configure updating records in Quickbooks when they are edited in Zoho Creator. I have put in the exact code in the sample on this help page: https://www.zoho.com/creator/help/script/quickbooks-update-record.html and I get an error that the variable 'getResponse' is not defined. Has anyone come upon this issue? In searching for the record to update, I also would like to search for a record
Web page for many reports, same search parameter ?
Hello I create clinic application, To enable doctor to see all patient's reports like blood lab, radiology, need to add all reports in one web page. I know how to create button in in report to go to another page with search word in this form openUrl("https://creator.zoho.com/" + zoho.adminuser + "/" + zoho.appname + "/" + "#View:Search?searchname=" + input.Name, "Same window"); and add it to web page parameter where parameter will add to search string as a filter. The problem search string in report
Formula: Sum amounts entered in lookup field
Hello! I would like a formula to add the sum of all the amounts entered in a lookup field. (The lookup field is within the same form) I have attached pictures that I think would help. Below are all the payment amounts I would like to add. (this is a lookup field to a form) When I click "+ Add New" , this is the form that pops up.
File_Upload using Advanced Rest Client (Google apps)
Hello, I have a File_Upload field on my app in the Creator. When I am tying to upload a file using the Advanced Rest Client (Google App), I can see the status code '200 OK' , but the response is empty. Also, the file does not get uploaded in the database/table. Below are the Name-Value fields that I am passing in the Data Form section of the Advanced Rest Client: authtoken : ************** scope : creatorapi applinkname : rest formname : FormA fieldname : File_upload
How to: Show field if lookup is populated
Hello! I would like a hidden field to show when a lookup field is populated. Another way of thinking about it: I would like a hidden field to show when a lookup field is not null. How do I do this?
Initializing/updating/displaying counter variable
I have a feeling this is simple, but I'm new to Deluge and can't figure it out. I'm taking reservations for an event and want to show the remaining spaces in a disabled field called Spaces_Remaining. How/where do I initialize Spaces_Remaining so that it isn't reset to it's initial value each time On Add>>On Load? Any help would be appreciated. Bryan
Compress attachments?
Hello community, So, I'm creating my first zoho application for a friend who needs to replace an app they currently use. One of the biggest features they need to keep around is their ability to add photographs to records. In some cases they may have 20-30 photographs attached to a client record. These photo's only need to be accessible while the form is in certain status's but once the workflow has been completed and the record is being archived and used for reporting purposes only, those photo's
auto data saving
Hi guys. i have someone building a dance club databas for me with creator and i'm being told that data cannot be saved automatically within a form... when we create an event and open the booking form to add customers/members that dat is not stored unless we click the save button at the bottom every time ... whats happening in live tests are mistakes happen on a busy entrance door and while moving around the database sometimes all the data entered on the night can be lost and its even possible to
Getting Events associated with an Account record
Hi there, I'm currently getting my feet wet with Zoho Creator and I had a question about its integration with Zoho CRM. I was wondering if it was possible to get the events associated with a Account/Potential/Contact record. I've tried using this function call to no avail: relatedEvents = zoho.crm.getRelatedRecords("Events", "Accounts", accountID); I was wondering what other things I could try, and if this is even possible. Thanks!
Use barcode reader to define the list of fields and options
Hi everyone, I'm Rob, a total newcomer in Zoho, but i'm willing to learn about this plataform to use it form my company. Right now i'm building a demo app to show the capabilities of creator. My question is: Is it posible to read a barcode, fetch the data and then (with the informatión the barcode provides) fill the rest of the form (two selects and a checkbox). I'll be waiting for your comments, thx to all.
How to have a Creator App use information from the Contacts in CRM?
The idea is to have the App be able to take the contact information directly. As it is, the data that my App is using was manually imported from a spreadsheet.
Set the value of a checkbox field from a function
Scouring the help forums and documentation...it does not appear that I can set the value of a checkbox field from a function. Is this true or is there a way to set a checkbox value from anywhere other than the On Load event?
HTML PAGE IN CREATOR
Hi, I have a html page with input tag and submit button tag, In live mode, whatever I type in the input tag,I want to pass it as parameter to any one of the fields in the form of my application. Is it possible? Kindly,help me.
2 Forms, 1 Calendar Report
Hello! I have two forms. "Add New Event" "Add New Appointment" I would like to see all of my appointments and events in one single calendar report. I do not want to combine or link the forms because they have their own, separate, information. How do I do this?
Web Services in Zoho creator
Hello how are you. i have one question....., i have created a web service in Java that's connect to Data Base Oracle, this service throw me a WSDL file. I would like to know.¿ how i can include this WSDL file in zoho creator? Regards Jonathan
Bug? Zoho import create app from xls makes 'too long a decimal' from number
I did the following. Made a new blank excel spreadsheet with the following data: TestDec Name 20.4 Bob Saved the sheet. When to create an application from file. Chose the spreadsheet in question. The import fields are as follows: "Single Line" "Single Line" "TestDec" "Name" "20.39999999999 "Bob" No idea why zoho creates that decimal. If I change the fact it says "Single Line" to "Decimal", it still lists 20.399999999. If I try to finish the import, it gives an error
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)
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.
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
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
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!
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!
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,
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
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
Next Page