Script for lookup of data across different applications
I would like to do a lookup from a separate application. Here is an example: config-module: "Form1" has fields: Global Category, Prefix hr-module: "Form2" has fields: Category and Name --> Category is my lookup field. --> When I lookup a category, I would like to populate from config-module's field Global Category. The issue is, I want to create a function to get the details from the form programatically, it keeps suggesting that there is an error...the problem is that my lookup field (which
Update records from other form
Hello, I have a form (form A) with information about vehicles. These vehicles have to periodically inspected.The date when the vehicle is inspected is filled in. In an other form (form B) I can plan this periodically inspection wich will be shown in a calender. In this form B I would like to add an input field where the new inspection date can be filled in. So when a new inspection date is filled in form B it has to update the inspection date in the record generated by form A. There is a report based
Subform subtotal automatic
Hello, I have made a subform with the following fields: Field 1: Aantal Field 2: Prijs Field 3: Subtotaal I have made the following script for Subtotal: row.Subtotaal = 0.0; row.Subtotaal = (row.Aantal * row.prijs); // calculate grandtotale input.Totaal = 0.0; for each rec in Werkzaamheden_2 { input.Totaal = (input.Totaal + rec.Subtotaal); } input.Totaal = input.Totaal; The script works but subtotaal will not automaticly be filled in when I put a value in: Aantal en Prijs. See attachment
Hyperlink function not working
I just tried to access the hyperlinks in my database and it's not working. Is there an estimated timeframe for a fix. These links are critical to my business. Thanks.
data typing; script error
I have an app with a subform. The whole form looks something like: Client - a lookup Project - a lookup Employee Hrs Rate Bill_Amt (a line of the subform) After entering Employee, I want to lookup the associated Rate and insert in the Rate field above. I am trying some scripting : theRate = Employees[ID == row.Employee].Rate; alert(isNumber(theRate)); //used for debugging returns true. row.Rate =theRate; When I go to save the script, I receive : Error at line number : 3 Expecting
Problem in form
Hello, I'm stuck in a form. In the attachments I have uploaded a print screen of the issue. When I select "Selecteer opdrachtnummer" the value in "Kenteken" has to be filled in. When "Kenteken" is filled in the field under it has to set a variable. The field "Kenteken" in the sub-form "Kosten" is based on the field "Kenteken." The problem is: Why does "Kenteken" right in the top doesn't fill in his value. Probarly there is a value because the field "Kenteken" in the sub-form is based on it.
Passing parameters to embedded form (2)
Hi, I would like to create HTML pages to customize the look and feel of the forms. However, I use navigational URLs to pass information between forms. How can I pass data to the embedded form?
formula field issues
Is there a way to make a formula field calculate properly if one of more of the items it's supposed to sum are blank? For example, say I have three number fields: Group A invitations, Group B invitations, and Group C invitations. If the formula field expression is (Group_A_invitations + Group_B_invitations + Group_C_invitations). but there's no value for Group C because no one from that group was invited, then the formula won't work. I still want the sum of groups A and B though. How can I make this
Picklist not accepting a list
Hi, I have a picklist not accepting a list of string items. The script can be saved fine but at the time of execution it generates an error. To, me nothing seems wrong with the logic here. The list is generated in another application from a database of categories filtered by another field. There seems to be an issue with this way of generating the list because if the list is generated manually with random items like "a", "b", everything works fine. I appreciate your support. here the code: Tecnicas_Lista
HTML script sections in a page
Hi, when creating a page, I added several HTML sections one after another. each section containing a table with pictures and text. At some point I wanted to add one section at the top but the insert HTLM function did not seem to find a spot to add this new HTML section right at the top. My reaction to this was to switch to free flow scripting, add a few lines at the top (to create a space), save and go back to script builder mode. The result is that the builder lost track of the different html
zoho.userid actual BIGINT ID?
I don't need the email address, or the user name, I need the BIGINT number. Can this be accessed?
Other currency field vs chart
Hello, I have a problem. In a field I have selected the currency "EUR" --> €. When I make a Pivot Chart based on the database with the value of the field with lay-out "EUR" -->€, it will show in the Pivot Chart a dollar --> $. How do I change this? See attachment for a printscreen.
Change current index of autonumber field
Hi, We developed and are using an application for orders management since last year. We're using an autonumber field for setting the unique ID for each order. The start index was 20140001, so we could easily identify the year an order was generated. We intended to change this index, this year, for 20150001, but I figure out that this is not possible in Zoho Creator. Can you made this change for us, please? The form is at https://creator.zoho.com/appbuilder/gbpenha/pedidos, and the field name is Codigo.
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.
Next Page