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.
Add the value of a single field to a lockup
I would write on a single field and the value of lockup were the same as the single field, then do a fetch automatically. I wish I could do this because I'll make a public view and not to display data from the lockup to the public, Thanks! if (input.Alta_de_vendedores == null) { if (input.Correo_electronico != null) { ALTA = input.Alta_de_vendedores.toString(); ALTA = input.Correo_electronico; x = Alta_de_vendedores [ID == input.Alta_de_vendedores]; input.Verificacion_Correo
Zoho Creater + WooCommerce + Zapier
I'm running an ecommerce clothing brand, and I'm trying to integrate my WooCommerce store orders with Zoho Creator using Zapier. I've gotten through most of the process, but I'm struggling to figure out how to have my attributes and variations come through to Zoho. Here's an example... Each item of clothing listed on my website is a unique color. No single product has multiple color variations within it, only sizes. Through the Zapier connection, I'm looking to have these fields imported to my Zoho
Display multiple fields on calendar
Is it possible to display an event title and starting time on a monthly calendar report view? I only seem to be able to choose one field. I suppose I could create another field that combines them, like "1:00pm Staff Meeting", but the data is already there, it would be easier to just show a combination of the fields. Bruce Letterle Red Lab Media
Upload excel data without touching master table
Good Morning Please help and advice me in the following issue ... We want to upload excel sheet in the zoho creator, but don't want to do this directly in the master table.. Basically my query is can we upload excel data without touching the master table. and after upload fetch data and apply some criteria like duplicate etc. also. Please advice Thanks Shiv.
Cancel an account
Hello to everyone in the forum. Anybody here know how? or where? to cancel an account on Zoho-Creator or zoho.com
Zoho Creator mobile not displaying report column
I have a very simple Creator app that when I access a report from the mobile version, the last column in the report is not displayed. It displays fine when I access the web-based version on a PC. There are 5 columns in the report and only the first 4 are displayed when I access via the mobile app (Android). Am I doing something wrong, or is this a limitation?
Zoho Creator Application Packages documentation?
Where can I find any documentation on the Zoho Creator Application Packages feature?
Fetch Data from ID
Hi I'm trying to populate a table based on the ID number of a record. I have a table (Main) with People & Courses having lookup values as their records People Courses 3081044 3001505 3150808 3205808 3081044 3045088 I want to fetch records in this table where People = the ID number of the People table when I edit the People table. So; user edits People table (maybe adds a new course that the person needs to do). When they click 'Update', this code kicks in... training_records
How Do I Populate a Notes Field with Iterated or List Values?
I have two tables: Locations CustomerContacts (there are many customer contacts for each location) In a third form, I would like to show all of the CustomerContacts in a "note" field once a Location is selected. I understand how to use the for each and iterate through the CustomerContacts, but I cannot seem to get it to list, or show all of them. How can I do this? Thanks!
passing a variable to a wordpress embedded form
Hello. I am stuck. I use 'WP Estore' and WP Emember to manage my store functionality. I want to pass the sign-in email to a Zoho embedded form on my Wordpress site. I've searched these forums, and found a few that are very similar, but not enough for me to figure out how to pull the variable from Wordpress to Zoho. The Wordpress variable can be called with this WP Emember function: wp_eMember_get_user_details("email"); First time posting, and fairly newbie php programmer. Any ideas? Jason
Zoho Creator - Who can start developing the application
Is it necessary that a developer need to be coding / programing the application? Can a person who does not know coding / programming develop application using Zoho creator?
Sorting a multiselect lookup on success
Hi, Here is a list of options selected in my lookup field called contact type (NB: It is a multiselect) that references my form contact types: Warehouse Accounts Sales Purchases I want it to sort to alphabetical order: Accounts Purchases Sales Warehouse The code I have written on the On Add-> On Success portion is as follows: IDList = List(); for each ContactType in input.Contact_Type { GetDetails = Contact_Types [ID == ContactType]; IDList.add(GetDetails.ID); } GetSortOrder = (Contact_Types[ID
Create report for time spent
Hi, I have in one of the forms start time and it saves it in the DB, MM/DD/YYYY HH:MM:SS then in the reports you have an Add Time when the user finish and submit the report automatically saved by the system with the same format MM/DD/YYYY HH:MM:SS. I'm trying to make a report where it takes form start (MM/DD/YYYY HH:MM:SS) - finished form (MM/DD/YYYY HH:MM:SS) = time spent (HH:MM:SS) I can't figure out how. If you can please help me it would be great. Thanks!
get records from zoho books using "greater than"
Hello, I want to fetch records from zohobooks searching for Invorce IDs greater than the last one fetched. Example below. is it possible? if no, what's the most efficient alternative? Books_Response = zoho.books.getRecords("invoices", "xxxxxxxxxx", "Invoice_ID >" + Last_Invoice_ID); Thanks Luis
Next Page