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
Using Creator with Zoho Sites
I'm new to Zoho, so forgive me if this is a dumb question. Is it possible to run your "Entire" public and private website using your own domain name with Zoho? I currently use WordPress to sell online classes and subscriptions. The online classes are videos, hosted by Vimeo and embeded in WordPress Pages. The subscriptions are handled by a "Membership" plugin restricting access to custom documents just for that customer. Can I use Zoho for my public site pages (blog, static content pages, forms,
Dudas sobre el limite de uso
Buenas tardes! Realice el pago de la suscripción por paypal , adjunto imagen. Debería tener habilitados 10.000 registros pero solo me dice que tengo disponibles 750. Me podrían explicar?
Maximum fields in a stateless form
Hi I'm doing a booking system for the theatre company that I work for, and the tech section is quite substantial (100+ fields). I've split this up into several forms, but would like to enter the data into one big form (much easier for me) I've got the stateless form working, so that it updates a number of different reports, Do the limits on the maximum number of fields apply to stateless forms, or just to the reports that they're pointing at? It would be good to know this before I spend lots of time
FTP
hi, do you have a solution in ZCREATOR for read/write in a FTP ? thanks you
Time Stamp
I have a notes field on each clients form. I add notes to their record from time to time. Is there any way a time stamp can be added. before the note, each time I edit the notes field? Thank you.
Problem with copying the application
Hi. I was explained in one tutorial, that I should copy Zoho application via the following link into my account: "Once you are logged in, go to this application on Zoho. We will start by cloning the application used for this prototype, which makes life a lot easier. On the application you just opened, click on More Actions > Copy Application. This will make a full copy directly to your account with all the settings already in place." But I do not see any buttons with possibility to copy this application.
Atomicity in Zoho Creator?
I need a unique "order number" for each new order. I use a form's field to keep track of the next "order number" and increment it. string WalkIn.OM.Orders.NewOrderNumber() { g = Global [ID != 0]; temp = g.Next_Order_Num; g.Next_Order_Num = (g.Next_Order_Num + 1); return temp.toString(); } The problem is, when 2 orders are created within 3 seconds apart, they'd get the same order number. Is there anyway to guarantee atomicity for the function above?? What's the right way to implement
CREATOR Grid & Spreadsheet Reports in the NEW UI
I am developing an application that heavily utilizes grid or spreadsheet views for the purpose of QUICK data update without having to open every record. Several weeks ago you could not get creator to accept a value into a field in these views. This has been fixed.....and I was told by email that the grid and spreadsheet report views are fixed. However these issues REMAIN: 1. The grid and spreadsheet are no longer 2 distinct views 2. When there are 20 to 40 or more records....it can take 5-8 seconds
Issues with viewing VIEWS on creator forms in CRM
I recently purchased crm plus. The first two weeks. I could create a tab for a creator from. I could than view ALL views of that form beautifully. Then there was an API issue and you could not view any integrations. That has been corrected. HOWEVER, I currently CAN NOT view ALL the views of a form that has been integrated in crm plus from the crm. No matter what view is selected the same view appears. I have made several calls to tech support with NO feedback on when this might be fixed. This
Date format and decimal separator
Although my application be set for the Brazilian date format, my forms show the months with the abbreviation in English as "Sep" for September instead of "set". I'm also not finding a way to use the comma as the decimal separator. Could you please help me? Thank you!
msg...... invalid entries found (HELP ME)
I'm and my public colleague receiving this msg when we try to add any app record... "invalid entries found please correct and submit again" in zoho creator. HELP ME PLZ as soon as possible
Integration with CRM
There needs to be a way of sharing prospect and client data between applications built with Creator and Zoho CRM. Creator gives the ability to build a full-featured applicaiton to capture and service the contacts/leads/prospects but CRM is needed to manage and follow-up. Last reference to this I can find is from Nov 2007. Any progress?
creator task to Zoho Crm
Trying to get the process clear in my head. We use cam and then creator to log customers equipment. Once a month creator produces a report of equipment that needs servicing. It would be useful if we could put a notification up in the contacts crm to say service due. the best way I guess is via a task. Is this possible and could someone point me in the correct direction of the process. I have searched but I am struggling to think mom the correct terminology.
Find invoice number (Zoho Creator -- Zoho Invoices)
I am using Zoho Creator to create invoices in Zoho Invoices. Zoho Invoices auto-generates the invoice numbers. What code can I use to find the invoice number of the newly-generated invoice ? THE CODING I'VE TRIED: The following line creates the invoices successfully: response = zoho.invoice.create("Invoices", "633994822", values); I would have expected "inv" in the following line to give me the invoice number, but it results in a null value: inv = response.get("invoice_number");
Subforms
Hi Guys, Basically most of my forms require to have subforms that are existing and the user is required to add to some of the fields in the subforms. So data is populated into the subforms and user is required to append to it. The main issue I have is the non-availability of the function to add or delete rows in a subform using deluge script. This causes a number of issues as follows: 1. I have to pre define the number of rows for the user, where sometimes the subform might have more or less. 2.
Add an element to a form by a Custom Action
Hi, in one of my form I have a Custom Action which open a report where some fields are pre-filled (based on the record selected) and there are others that the user should fill. When I press the "submit" button, it adds the fields in the correct form but the report remains open and not closed. I followed this guide: https://www.zoho.com/creator/help/views/editing-records-via-record-id.html My URL is the following: sURL = ((("https://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname)
Using Not In
Hi! I need to load a Drop down with a list of names of people. This list must be a result of a fetch operation in a way that excludes (not in) records in a lookup field related to another form. How can I fetch records excluding (not in) records from another fech operation? Thank you!
Error when exporting to spreadsheet
Hi, When I try to Export my List Report to a Spreadsheet, I get the following error... This site can’t be reached The webpage athttps://app.zohocreator.com/tomroot/southsideassetmgmt/xls/Drawing_Tie_Outmight be temporarily down or it may have moved permanently to a new web address. ERR_INVALID_RESPONSE
Stop Automatic Update of Form Fields
Hi all, I have a form with the following fields: - pieceLength (m) - weightPiece (kg) - weightMetre (kg/m) Depending on the value put inside one of them, the others get updated using the OnUserInput field action. The problem is that if for example I put "pieceLength" = 15 and "weightMetre" = 5 then "weightPiece" is calculated as 5 / 15 = 0.33 but soon after weightPiece is recalculated (because 15 * 0.33 = 4.95 and it's different from 5). What I need is that the fields are correlated, but the changing
Formatting (input masking) phone numbers in ZoHo Creator
I've been searching most of the day for this answer; how do you format the 'field' in a form that displays a ten (10) digit phone number correctly (as is displayed in most web-based forms). I can easily do this using Microsoft Access, however, I don't know how to do this in ZoHo Creator. (123) 456 - 7890 The idea is to just type in all of the numbers and "after updating" the format will be assembled to look like the above example. I keep reading about using 'strings', but since I do not know
Time zones
Is there a way to display views using local time zones instead of the application time zone?
View Records API Mutilple criteria values
When can we have an option to fetch multiple records having different value for a single parameter field accessed through a single API call. For Example, if a user wants to view records for 10 different order numbers, he has to make 10 calls one at a time. This is how it works now. But we should be able to fetch multiple records with a single call, may have an upper limit (say 100). Avinaw
Adding multiple emails to a script
Good morning. I have a small application that on the submit of the form emails to whoever is selected in the record. This script below works great. But I need to send it to multiple emails. I tried to add them and separate them with a comma. But when I try to save the script it gives me an error on line 2. Which is the start of the script. input.Management.Email From : zoho.adminuserid Subject : "PO Number" Message : "<div>Here is your PO number:</div><div><br></div>" + input.PO_number
How to access lookup field values in fetch records
I have an application with a product form ICO. To do a monthly inventory, I created a form Temp_Inv to allow users to enter inventory amounts, in On Load, I fetch records from ICO: for each x in ICO { if (x.Inventory != "Labor") { insert into Temp_Inv [ Added_User = zoho.loginuser MD_Serial = x.MD_Serial Inv_Date = eomonth(today,0).addDay(1) Supplier = x.Supplier Pack_1
Setting Link Name for URL
I would like to set the link name of an inputted url to be the inputted date of a document. User inputs Date_of_Document User inputs Link_to_Document In workflow, on User Input and Update of Date_of_Document I have entered the following code: input.Link_to_Document = input.Link_to_Document + "/'>" + input.Date_of_Document + "</a>"; The Link Name stays blank when the Date of Document is entered, and upon submit it records the full URL link for the Link Name. I would like it to just display the Date
click on text open edit field?
Hi Zoho, I've seen a post directing this here, but I can't find it now.... I have an html page displaying data from different forms, I'd like to have the option to edit the data straight in the html page - meaning when I click on the data, an update field tiny window will pop up next to the text (just for the field that needs to be updated, not for the entire form). I hope I've explained myself well enough. Will appreciate any help.... Thanks Ravid
Next Page