Get Quickbooks Customer Details
I've been able to get quickbooks customer details using the quickbooks integration functions; however, I'm having trouble accessing the individual child attributes. For example, I can pull the Customer ID, First Name, etc. with no problem. When I request the BillAddr, it provides all the child attributes in one large string. I'm trying to get the individual child attribute values Like BillAddr Line1, Lat, Long, etc. The code I've used to successfully get the info is: searchResponse = intuit.quickbooks.searchRecords("st_Rate_QBO",
Customer Survey
I have made a customer survey form. I would like to have it go out with an email form I already have being sent. Do I need to publish this form first, then add it to my existing email, or do I need to have it sent separately? If Seperately, what is the best method for scripting? if(input.Billable == "Yes") { if(input.Customer_Name == "Savings Bank") { sendmail [ from:zoho.loginuserid to:"@jbank.com" bcc subject:(" Savings Bank " + input.Terminal_ID) + " Service Call Response" message:(((((((((((((("<em><strong>This
Custom Filter - Display only records with a 'Blank' field
Hi I want to set up a simple Custom Filter that only shows the records which a certain field is blank. The field is called "REM number" and I want to create a custom filter so that only records which have no text (blank) in the "REM number" field is displayed. Is this possible? I've had a look and have tried: REM number > does not contain > "" However this doesn't seem to be working as it returns no records at all. Any help is greatly appreciated Many thanks Tom
How control View display of record retrieved from global search?
When you do a global search, there is a "View" option (#1 below). This view is different than a regular "View Record" --has fewer fields (#2 below). Compare with regular "View Record" display (#3 and #4 below). How can you control what appears in the "View" list display? #1 #2 #3 #4
Is there a limit to the size of an HTML upload?
Hello, I'm trying to create a page. I have a HTML document that is 22,000 lines long. It doesn't seem to upload on save. Is there a limit?
Using Image field to take picture
My target device for my Zoho Creator app is the Chromebook. I'm looking to allow users to take a picture in addition to uploading a file in the image field. I know this is feature is available in iOS and android devices, is there a way to implement it through a browser (because there is no chromebook web app for zoho creator)
Newbie questions
Hello, I am new to Zoho, and I don't have any experience in creating applications. I have 2 or 3 projects that I believe Zoho could provide solutions for. Is there phone support, or an option where I can consult on how to create the tools I'm looking for? Thanks
Android app of creator
We are having trouble with the Zoho Creator app (Android Version). When enter information and click submit, it works fine. But once all the fields are cleared and we go to enter the next bit of information, it automatically submits and duplicates the previous record. What is funny is that once this duplicate is created, it works fine again. But then when you submit the next set of information and all fields clear, the same thing happens and makes another duplicate. Is this a bug issue in the Android
Problem with latest Android mobile update for Creator
It would appear the search-a-field ability has gone bad with the latest Android Mobile update. Anyone else having a problem?
Create Rule Based Upon Unselected Dropdown Field
Is it possible to create a field rule that is based upon a dropdown field NOT being selected? More specifically, I want to hide the rest of the Zoho form below this dropdown field when the user hasn’t yet selected an item from it. Basically the rest of the form shows ONLY once you make a selection in this field. Before you do this, everything below this field is hidden. I don’t know what language to use when writing the rule to refer to the unselected dropdown field. It displays as -Select- when
creating a new input page
Hi I need some help with an input page please Lets say I have a form with the following fields Name Address Tel no Visit time Agent Instructions agent special instructions ETC Now I want to create a new form with the fields Name Address Tel No I want this form to have the ability of creating a new record in form 1 Hope this makes sense
Cambiar "Single_Line" a "Multi_Line" /Change " Single_Line " to " Multi_Line "
Español Buenas noches, tengo un cambio el cual inicialmente fue creado como "Single_Line" el cual ahora es necesario que sea "MULTI_LINE".. Campure los valores de este campo junto a su ID en otra tabla para luego realizar el cambio volverlo con su informacion original. Pero al querer eliminarlo me dice que este esta relacionado a varios objetos, la lista parece ser tan larga que realmente no se cuantos podrian ser. existe alguna posibilidad de realizar este cambio de alguna forma mas practica? Aguardo
Failure submitting to FORM through email
Hi, We cannot submit anything to Form by email. It's been working well but not these two days. No errors found in Log, nothing, email just could not be received by the system. Please help check and advise. Thanks!
Creating Navigational URLs for mobile
How do I create navigational URLs for mobile browsers or the app as hashtags do not work outside of the web browser. Is there a way to check for the browser or OS?
Lookup based on a lookup
I want to create a form called Billable_Items that is related to a form Projects which is related to a form Clients . Form Clients has a field Client. Projects has a field Project and a field Client which is looked up from Clients. On Billable_Items, I want a field Client looked up from Projects. The system won't let me do this. It will let me do a lookup on the ID; i.e., system record number. Then I want a field Project looked up from Projects and filtered based on the Client selected in the
Fetch Records Case Sensitive?
I'm looking for the scripting syntax to fetch records using criteria that is not case sensitive. For example, I'd like to find all people with a particular first and last name: recordCollection = People [firstName == <criteria1> && lastName == <criteria2>]; However, the criteria appears to be case sensistive (i.e. <criteria1> as "John" yields a different result than "john". Do I have to code for all possible combinations of letters?)
Record Summary page 2 is not showing
I have a 2 column record summary with fields that extend beyond one page. For some reason the Labels and Fields are showing clearly in Page 1 however I cannot see a way to scroll to the second page of the summary. Any ideas? Is the record summary limited to one page. Tell me isn't so!
Error 500: Create Form from Template
I have been unable to create a New Form choosing "From Template" in my application, and then the first form I originally created. I have tried multiple ways to create the Form from the existing Template and each attempt results in Error 500.
Can't update Creator form from Apple or Android device anymore
I have been successfully using Windows IE, Apple, Android browsers to post data to my Creator app for several weeks without issue. Now only Windows/IE works. When I use Apple or Android, I get a "Please Wait" message that never ends, and data does not post. I havent' changed the Creator app. How can I fix this? Thanks
add columns to form fields
Hi, I'm sure the answer is somewhere on here, but I can't find it. I've created Dynamic Content. It's a simple excel sheet. It has 4 columns. When I select it and edit it, there are only 3 columns. I need 4. In future I would suspect that I would need way more than that. What do I do to add columns to it? Thanks!
Image Field, URL value assigned using script
Hi, I have a form, where I have an Image field. I want to run a script to assign each record a URL value to the image field. The issue is that the script seems to do nothing, i.e. the URL string is not written into the field. below the type of script I am talking about, which produces no change in the Image field... thanks for your support... for each F in Fotos { F.Image="URL"; }
Customer Portal, open url passing logginguser
hi, Using the portal, I want to have a stateless form where depending on a picklist selection, the user will be redirected to another form in the same customer portal application. The issue I am having is that by using the openurl function, when the user is redirected to the new form, the loginuser is no longer recognized and is being asked to log in again... how can I direct the user from one form to another in the application without loosing identity? Regards Luis
Rotation on larger mobile devices
Is there no rotation feature on mobile devices? If I use a docked ASUS Transformer, the screen doesn't rotate. I can no longer use a full keyboard for data entry. Is there a way to enable rotation through the Zoho Creator mobile app?
using Formula Field for Totaling or ??
I am trying to use a formula field on a form to total up 9 currency fields to generate a total that the user can see and then I can use to initiate a Payment. I can't seem to get it to accept all the fields? Is there a limit on the number of fields the formula filed will accept. Is there an easier way to do this with a currency field? I am new to Zoho and trying this out for the first time, so any help is appreciated. Thnaks
How do I bring the price from my product/service form to another form linked by a look up field?
Hi, I am trying to figure out how to get the price from the parent form into the child form. I am kind of new to this and haven't been able to figure it out. Any help would be appreciated. Parent Form Form Link Name: Add_Product_Service Fields: Product_Service_Name, Price Child Form Form Link Field: Kit_Sub_Form Fields: Product_Service (Linked by lookup field from parent form), Price (NEEDED FIELD FROM PARENT FORM) Note: The Product_Service and the Price of the child form will be used by a subform
Show summary on submit
I want to show the summary of the inputted data on pressing submit so that users can review it and print it. I tried redirecting the On Submit to the report page, but no success. It just lists all submission.
Column Width for Rich Text Field
In a report it seems that setting a custom column width for a rich text field has no effect. My users type a lot of text and the reports are getting cumbersome to navigate.
Conditional Formatting Not Working
Hi, I am very excited about conditional formatting, but when I applied it to my calendar, and a few reports, Nothing happened. I followed the directions very closely. In this example, the formatting is applied to a report in spreadsheet view, where I want the field "case" highlighted when the date due = today. Can anyone see why this isn't working? Thanks, Amanda
Help With the Right Path in Zoho
Problem: My wife runs a charity, and I'm thinking about using Zoho to capture requests for her product. The product is free, but there is a shipping fee. The charity only helps people that meet certain requirements (income level, number of children, etc.) and the user must submit attached documents proving they meet these requirements. These are then reviewed by staff and, if approved, they are invoiced for shipping and then sent to another group for fulfillment. My Struggle: My issue is that Zoho
How to not save null records from a subform when I click submit
Dear All, I would like to ask you, if a have a subform in which I have set 20 as default entries-records but I only use 3 records, how can I save only these 3 records and not the other 17 which are emty-null?
zoho ed platform
Hi as an educator who uses a variety of blended options to reach and interact with my students and tutors, it would be great to have an integrated Zoho platform something like Wiggio (perhaps). Anyone else interested in this? (Isn't it counter productive to need to choose a forum for such ideas? By definition, they don't fit anywhere!!)
Create a table based on two or more forms.
I would like to create a table from two different ways using columns expenses (Ganancia Bruta,Ganancia neta, etc) in two different ways, for example. Do not know if I explained wellI want use what they I show in the following pictures: want to create a single table with a lot of data from different periods, different columns, different form and think "Auto view" limits me to only what is in that Form Thank in advance!!! Happy Holidays!
Custom function
Hi, I am trying to create a custom function or something like a button that when user execute this function it will input a specific text (URL) into a specific field. please see below screenshot where in the "Update link" field I want to input below url link when user execute the custom action. input.Update_link = "https://creator.zoho.com/mikekokernak/across-platforms-web-proxy/#Form:Update_TV_Station?Update_TVStation=" + 798107000000666628 where 798107000000666628 is the corresponding ID number
Access value of a lookup field
A simplified version of a problem I have: I have two forms Projects and Clients. Projects has a lookup field Client which looks up field Client on form Clients. I want to access the value of Client. In a Field Action on Client on User Input I have the Deluge command 'alert "Entered: "+input.Client' . The message box shows "Entered: 2440810000000112935". How do I get the value of Client. Thanks!
attach a pdf document to a form
hello, I have a service app that I'm working on. It has come to my attention that the end user needs to be able to attach a PDF document. Is there a field type that will allow a PDF document to be uploaded as part of a new entry? Happy New Year, Alan
Embed & controls
I am embedding my databases into my web pages, and all seems okay, except I do not get the "tape recorder" functions at the top right of each page, which allow the viewer to move thru the records a page at a time, instead of individually. Backwards one page, forward one page, first page, last page. What do I need checked "SHOW or HIDE" in order for those functions to appear at the top of every page ?
URL parameter using Equal OR
I would like to know how to pass a parameter in a URL for a view in the form of " variable=A or B or C" in other words, take this URL: https://creator.zohopublic.com/yaxche/catalogo/view-perma/Fotos_2/aYh5B2kTxt3NX2AF4GnaMbPqfeb3qGUy7en5YYeZa1O0DzyRkhkbwq0B2kmfrSQ3juTUf2TDK3mrezZuv7zvBj5p5ksuK3TPheYF?Numero=2 here I am passing the parameter Numero=2, which works fine. The view shows the record where the value of "Numero" equals 2, the issue is that I want to display more than one record, for instance,
Scroll to bottom
Hi, I have a stainless form which have really so many fields (around 50 ) .Usually user does't have to fill up all fields or doesn't need to interact with most of the fields except some fields which might be first 10 fields that user frequently update. So what I am looking for is if I can input a button or something like HTML tag ( Scroll to Top or Scroll to Bottom) so user can go directly on the position of "Update" button of the form which is on the final portion of the form. This way user won't
Extracting information from an email.
Im creating a booking system for a hostel. We receive regular emails every time a booking is made through hostelbookers. Everytime a booking is made an email is sent. What i would like to know is how extract data from an email, every email is written in a set format. I know how to forward the email to the zoho email address so that i can import the message body. But is it possible to tell the database where to extract information from that message body, such as number of people, date?, because the
Conditional Pick list
An elementary building block for databases is to filter a Lookup field by the value of a previous lookup field. Some common examples are: Countries filter for States, States filter for Cities and so forth. This is billed as a very easy database to use any yet there are countless descriptions on how to achieve this tiny task. We should not have to spend hours grubbing through old forums to find an answer! Can someone point me to a simple method, clearly explained, with perhaps two or three examples
Next Page