Invalid Entries found when using lookup or Zoho Crm fields
Hi, I am on a trial of Zoho to see if I can use it to develop an application for a corporate video company. I am an amature Filemaker pro developer and the intergration with docs, email and already built apps is very promising but I keep hitting brick walls trying to get the solution to a point where I can tell them that it will work for them. I have been attempting to use Zoho Crm fields to link to the Account (but I changed the name to Clients) and when I attempt to submit a field I get the invalid
How find the Modulus function in Zoho creator
Hi, I want to find the Given Number is "PRIME NUMBER" OR "NOT" So, I need this function where I can write the program to find the number is "Prime or Not". I have checked in Google, no where I found this function in Zoho creator application Kindly let me know, Thanking you, Regards Prashanth K
Difficulty in adding new record to Creator via Http web method
Hi, I am new to Zoho Creator. I am trying to add a new record via http post method as given below. The problem is that in respose I get a login page html. protected void btnSubmit_OnClick(object sender, EventArgs e) { var response = Http.Post("https://creator.zoho.com/<USERNAME>/<APPLICATION_NAME>/form-perma/NEWCONTACT/record/add/", new NameValueCollection() { { "authtoken", "<KEY>" }, { "scope", "creatorapi" }, { "First_Name",
[Help, please. Have this problem] We are unable to fetch this data, sorry! Please note that your data is SAFE.
Hi, able to create entries, but cannot view them. Also received this error message. May we seek your kind help fixing this? Thanks, keen to hear from you.
How to enable one value in Radio button field ?
Hi, I want to Enable only one value in Radio button field. Say for example - I have 2 Live forms : Employee_Info forms & Beuro I have an Employee_Info Live Form , Attributes -- Employee ID [ Number ] -- Employee Name [ Single Line ] -- Gender ( Radio field) -- DOB [DATE] Another Live
Fetching data from one lookup to another lookup
Hi Support Team, I have Live Form A , with some Employee data - Employee_ID [NUMBER], - Emp Name [SINGLE LINE], - Salary [NUMBER], - Departments [SINGLE LINE ]. I have another form - B, - with 3 Different Lookup field fetching only Employee_Id and Employee_name,Salary (fetch from - form A) - Hire_Date [ DATE], - DOB [DATE], - Age [DECIMAL] - CALCULATED,
Adding deluge in a pop up window of an alert function
I have a form with a decision box ('Test') When I click this box then it shows me an alert pop up like the following: if (Test) { alert "Something"; } Is it possible when the alert shows me the pop up window, then by clicking the OK of the pop up to automatically untick or deselect the decision box? I think that it is not possible but I would like your opinions.
print button for html page with dynamic tabs
Hi Zoho, I have an html page in my application that is divided to "tabs" (bootstraps, but only using html - no java script unfortunately). I've added "Print" and "PDF" buttons using Settings -> Header option, but those only print the first tab (the tab active by default when loading the page) . This is the style: <style> .tabslegal { position: relative; min-height: 2000px; /* This part sucks */ margin: 25px 0;} .tabsshort { position: relative; min-height: 1200px; /* This part sucks */
How to make multiple columns like a table, and calculate
For example, I need to input Diameter, Length, and pcs to calculate the total volumes of logs (logs calculator), the table is same like this dia, len, pcs, vol, 15, 2.6, 5, 3.14*(15/200)^2*2.6*5 20, 2.6, 7, 3.14*(20/200)^2*2.6*7 then calculate the total volume. How to design form in multiple columns?
Record summary: how to sum numerical records?
My table looks like this: https://dl.dropbox.com/s/dckw0rdxh3mpqml/zohosum1.png And my record summary looks like this: https://dl.dropbox.com/s/1dxvhy24jsxhmtn/zohosum2.png How to sum numeric items from ${Invoided_USD} column, similar to Subtotal in this example? https://www.zoho.com/creator/help/images/record-summary-invoice-details.jpg Also is that https://www.zoho.com/creator/help/images/record-summary-invoice-details.jpg record summary available somewhere as template?
Subform
Hello, My main form "Store Records" contains a subform "Items List". I added a CRM field on the subform related to "Products" Module. Is it possible to have the subform act as follow, 1-Creating 4 fields "Product Name", "Product Description", "Quantity in Stock", and "Qty" which is the number of the selected product to be taken from store. 2-When the user select the CRM product in subform the first 3 fields data will also be fetched and auto filled 3-Subtract the amount taken from store and update
Lookup returns number
I am struggling. Any help is greatly appreciated. I have a stateless form that has a "lookup" drop down menu field in it. I have set up email notifications to send an email "on click" of the button. In the email, all works except the lookup table field. When I reference the lookup field I get the long ID number that must be the unique ID number to reference the lookup table. What I do not get is the input from the user in text as originally input. I have looked through forums and online documentation.
Copy data from a lookup field to another field
Hello, After trying several scripts found on the forum I am still not able to get it working. This is my issue: When adding a new product, First you need to select first from a lookup field the TYPE OF PRODUCT, Upon that selection the next lookup field only show the PRODUCTS from that TYPE OF PRODUCT. Until here all is working fine. The next field "PRODUCT NAME" should automatically be field in with the data from PRODUCTS. So i need a script to copy the data from "PRODUCTS" field to "PRODUCTS NAME"
Insert data from form to subform
I have two forms, Event; Tickets. On the SubForm(it's the Tickets Form) located on the Event Form, I'm able to add "Promoter ID" and "Tickets Sold", to keep track of all tickets sold by a promoter, which then updates the data on the Tickets database. I have added row.Events_ID = input.Event_ID; to "On Add Row" to the SubForm on the events form, so I can also include the events ID, so I can produce proper reports. But, no matter what I do, I can't populate the rows on the subForm with the Form's ID.
Customer Portal Login Issue
Good day, Today I have this problem to access the customer portals, I try in different web browsers and computers but is a general problem. Best Regards,
Missing Application
Hi, I created a form using Zoho Creator, from scratch in August. Now I log in and found all my application and form with data missing as if my account is newly signed up. Please help me to look into the matter. This is urgent! Thanks and regards, Richard
How can I pass crm lookup value from one form to other crm lookup field in other form using open url in Zoho creator?
How can I pass crm lookup value from one form to other crm lookup field in other form using open url? openUrl("#Form:Sample_Shipment?Vendor="+sample.Vendor,"Same Window");
How could the record from import data to associate with subform?
Dear Sirs, I have a form call "New Order" which contains a subform is called "Order Part". For each line in Order Part, there is a subform called "Invoice". Invoice data is imported from an Excel. Would you please let me know how I could link up the invoice with corresponding "Order Part"? Please advise. Thanks & Regards, Clara
Zoho Creator - Allow download of uploaded files from the record edit screen
Is there a way to allow the download of an uploaded file from the record edit screen? Currently, you can only change the file that's there using the [Change] link. Can we make the file name a link to download the file? To share our example, we have users who review a document submission and then make comments. They click an edit link, login and are then shown the edit screen. At that point, it would be ideal if the user can download the document from Creator to review it, update the Zoho record with
Filtering a lookup on checkbox values yields unexpected behavior
In my Personnel form I have a checkbox field named "Options" that has 2 checkboxes: "Foreman" and "Unavailable". Foreman marks an employee as a foreman. Unavailable means that employee is not available to be assigned to a job. The Job Schedule form has a lookup field that sets the foreman for a job. It looks into the Personnel form and has a filter set to only show Foreman who are not Unavailable. This is done by setting the filter to "Options" Contains "Foreman and "Options" does not contain "Unavailable".
Excel import
Hi there I encounter 2 errors during import of excel data. 1) Even though dates data is set correctly both on Excel an Zoho Creator side date field is not imported (see screenshots below) 2) Seems like Zoho modifies the value slightly during the import (see 10478..... value on the screenshots). Modification is very small, but for long numbers it results in import errors because of the length of the field. Setup in Excel: Date is not imported: Date format is correct in Zoho Value is modified (compared
Function for each, in a html page.
I have a code to enter all data "Model" on my subforms, but when I run the code me 5 data appear, all for the first record of my subform. I wish it were 5 data, the 5 Records in my subform. htmlpage Verificador_de_Correos_SP(recId) displayname = "Verificador de Correos SP" content <%{ x = 0; if ((input.recId != null) && (input.recId != "")) { orderRow = Ordenes [ID == input.recId.toLong()]; output2 = ""; output3 = ""; imagen = ""; output
Free-flow Scripting option gone - Please Fix!
Free-flow scripting option disappears after saving custom function the first time. Please fix ASAP.
Auto Fill from CRM to Creator field
Hello, I have a CRM field on my creator app (Sales Order No.). The user can select the created SO from CRM while using creator to enter records, and another CRM field which will be auto filled with account name related to the SO number chosen by user. I need to keep the last selected Sales Order # and the Account name, so the user doesn't need to re-select the same value incase entering multiple records for the same SO/Account. I'm using below code: on user input: crmresp = zoho.crm.getRecordById("SalesOrders" ,input.Sales_Order_No_ID )
Convert a string to a number?
Seems like a simple thing to do, but I can't figure it out. I'm pulling apart an XML file with XPath Builder, and when I assign some data from a node to a variable, it is a string. If the data is actually a number (BIGINT), how do I make the variable it's assigned to a number type instead of a string? Thanks.
Update records in Zoho Creator
Hi, When a subscription is cancelled on Zoho Subcriptions, I want to automatically update a field in Zoho Creator and change the field value to "cancelled". Please assist. Regards, Siya
is it possible to set unrequired to the field using deluge script.?
How to set field as unrequired in deluge script ? i have a field , some time it show and some times it hide , i want to make this field as required when it shows and make this field as unrequired when it hide .
Possibility to Drill Down into More Information?
I am using Zoho Creator and I have a form that I created to hold a list of contacts. The contacts table has approximately 15-20 fields that I defined (name, email, address 1, address 2, etc.). I have created a view of the contacts table that I have embedded into the page of another website. In the view that I created, I only have 4-5 of the 15-20 fields displaying (if I display all the columns in the contacts table the iframe becomes unattractive and has a long horizontal scroll bar). What I am trying
How to get a vendor id from Zoho Books?
I am trying to make a bill from a Zoho Creator list record but does anyone know how to get the vendor id already made in Zoho Books?
Search Form
Hi guys, Can anyone help me to create a Page which has a form with one search field (say, "Country Name") and a button "Search", which opens a Report filtered by the selected Country (same page, below the search form). Is there any easy way of doing it without HTML programming ?
creating a graphical style report
I want to be able to produce reports on properties we inspect. the repots need to be graphically pleasing and will include lot of photos. the reports are done on a room by room basis (average is about 10 rooms) and in each room there will be 10-15 sub items(ie walls, carpets, furniture, lights etc) I want to collectthe data using zoho app creator and this will need to merge with data stored in the main zoho creator database. I have seen other programmes which link directly with an excel template
Get Error 500 After I enter login info
I go through the process of logging in, including two factor authentication, but then I get an error 500 screen. Any ideas?
More than two columns in Forms?
Hi, Is there any way to have more than two fields per row (or two columns)? Is there any plan to make more flexible the form field positioning? Thanks, Fidel Martín
Question conditional formatting (calendar)
Español: Buenas tardes, deseo aplicar formato condicional al calendario, dada la siguiente condiciones. Si la fecha del campo menos la hoy es menor a 7 días. Ingles; Good afternoon , I want to apply conditional formatting to the calendar , given the following conditions. If the field date minus today is less than 7 days. Example: conditional formatting ( "Test" { condition = ( (FECHA_V - zoho.currentdate) < 7 ) format = "color:#ffffff;background-color:#489641;"
Cannot save after editing in spreadsheet mode
Hi everyone, Please refer to the screenshot, after editing multiple records in the writing time column, I tried to click save but nothing happened. Then of course I cannot save my editing. Sometimes it works, but most of the time it doesn't. Please look into the issue and advise. Thank you Regards
URGENT | User does not exist? | USER ID 49606658
Dear Service Provider, None of my user have access to this application except for the app owner socure.bureau@gmail.com Please advise ASAP how this can be fixed. Please find attached print screen
Lookup question
Hi I'm currently writing a booking system for the theatre company that I work for. The image at the bottom of this post may explain it better, so you may want to look at that first!, but my problem is: The initial form ('New Gig') has 2 fields, 'GigID' (autonumber) and 'Event Name' As soon as this form is submitted, it automatically creates a record in the 'Tech' report, autofilling the 'GigID' and 'Event Name' fields (there are actually lots more reports, but just to keep it simple to explain)
Embed Google Drive iFrame in a form
Hello, I'd like embed a Google Drive iFrame in a Note field in a form, but I can see preview correctly and when it save, code disappear and form is without iFrame content. Anyone has any idea? Thank you!
Pivot Tables No Data, Help
List Reports are showing data fine, but our Pivot Tables don't show any data, as if there's nothing in our database. There's also some inconsistencies with "Select/Drag and Drop the Columns"; it's listing some column names wrong. It's as if Pivot Tables is unsynced from our database. Is there anything we can do to fix this?
Dynamically add or remove stages
Is it possible to dynamically add or remove stages from potentials based on another value in the form such as the amount? We have 3 types of potentials (small, medium, and large) each one has a specific set of stages. I would like to only show the stages that are relevant to each size.
Next Page