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
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
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
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.
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?
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.
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
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!!)
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
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
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
display particular name's profile
i am creating a member details management. in view it displays all members details. if i click a particular member name i wnt to display his profile alone in the page how to do it?
The Creator API is Broken... Again.
I think your API is broken again. Test data1 = postUrl("https://app01.nutshell.com/api/v1/json","{\"method\" : \"getApiForUsername\"}"); input.ResponseBox = data; So what this tells us is that the postUrl method is broken. Can you guys fix this on your end?
Update lookup field using Script Builder
Hi, I need to update a lookup field value based on the value selected in another field, how can I do this? Thanks.
How do I copy the data from another Application
I use the lookup field to get the data from 'another Application' so how can I copy to new form -new field. (Like the pic) I need to get data '8' in cavity field?
Fetch oldest dates
Hello Zoho Creator Users, I have a question for a report functionality. I have build an object list for vehicles. Each vehicle must be periodically inspected for various points. The dates of inspections are known and are located in the future. I would like to make a report which shows the upcoming, most recent, inspecting date. I tried to filter the report, but I can only filter one column. I think I have to make a blanc field, and this field must always fetch the oldest date of all the fields with
Count of new rows in menu
Hi, can i do this? in my ZC dropdown navigation menu, is it possible show last new added rows in view? for example ORDERS New (2) Completed (0) Canceled "2" - the count of new rows in the table view. When i click the table view an then close, the count return to "0"
Formula field format
Can I format a formula field in the report? The field value is the subtraction of two currency fields, but the result is show as long.
Launch view with search criteria
Is it possible to launch a view with a deluge statement with search parameters? For example, I have a view with Contacts and want to launch from a custom action in another view only those contacts that comply with certain criteria (coming from that othet view). can this be done? thanks Henk
Sum when add specific value
Hi, I need create the script to sum $5 every $50 added to the field.
User privileges vs admin privileges
So far, We are using Zoho Creator with 1 same login I would like to set User Privileges 1) admin can do anything 2) Users - see, add and edit info 3) if possible : each user has access to his records (sales orders) depending of a code in a "user" cell in the form (example : the sales rep called LF can see only the records were LF is put in the "sales rep" cell) Is it possible ?
How to add a total ?
How to add a total down on a list with numeric field that changes depending on a selected records ? (dynamic total)
Custom Customer Proposal
Hello I currently have created a Form that collects information for a proposal (Customer Name, Address, Products, Price, etc). I want to create a customized Page that allows me to present that information to the customer. The goal would be to make it so that I can email the proposal to the customer for them to review what we will be doing. I can easily create a custom Page using either Rich Text or HTML but I am struggling on how to populate it with the information from a single record. Do I:
how to autocopy files from entry to dropbox?
hi how can i automate copying files from creator app's entry to my dropbox account?
Daily execution limits
Hi Zoho Creator Sales support: I have a problem with your daily deluge statement execution limits and email sending limits. I pay a monthly subscription fee why do I get daily limits? A monthly limit is more reasonable. On some days I do more development work than others so an aggregated monthly limit makes far more sense.
Daily limit for deluge statements
Hi Zoho Creator Support: How do you calculate the number of deluge statements? One database update per each record counts as a statement? I never figured out and maybe I need to upgrade my subscription? thanks.
iCal feed shows wrong time in Outlook
I created an iCal feed: https://creatorexport.zoho.com/pcmtrials/ctms/ical/RES_COL13IBD08_Scheduled_Visits/3hnaYV0dxFhCG0hR8qeavHf5PEzY0ay41XDtBsq7nrjPPkVkmpdVpERPKwfX3fJ7zpBpBFMktyGsUw3GPKMwQkXyhe5X8gh3EX6P/DTSTART=Visit_Scheduled&DURATION=1&SUMMARY=Site_ID_Subject_ID_Visit_ID When I subscribe to it in Outlook, the times are off by the amount of the offset for my timezone (Mountain Time). That is, a time in Creator that is 08:00:00 Mountain Time, shows in the Outlook calendar as 15:00:00 Mountain
Next Page