Moving Company App
I am making an app for a moving company I need help I have list with customers that i can add different ones now for the 2nd part i have shipments and i want to create something like an order you would add to a customer into that order i add Crates with specific barcodes and i add a location so kinda like How can i make it so when i click the customer in my report and it would list like all the orders i created for that customer in the report?
Use criteria in "for each" task when using a subform.
Hi Zoho community, I have a "for each" task for sending an email to every row in a subform. On Add it sends an email to all the rows, which is ok, but, On Edit, I need to add criteria in order to send mails only to the rows that where recently added or modified. I have been trying with the code bellow but no success so far. It seems its not possible to use criteria like this when using the task for a subform. for each R in input.Chequeo [R.AddMod = zoho.currentdate] { sendmail (
Multi Dimensional list
Hi I am seeking a small help i have three forms where one field is named as Date. I need to display the data in a html page, combining all data from all three forms sorted by date field Kindly help me with a solution on how to do it Thanks
Limit number of entries per radio button option
Hello - Is there a way for me to limit the number of entries for each specific radio button answer? For example, we have a registration form where people register for a specific 1 hr time slot. We want to allow a maximum of 10 people to register in each time slot and then disable that option. Thoughts?
using Zoho fields in Rich Text possible?
Hi there, I want to use a rich text in a form, where the user can also place zoho fields. The value of the field should then be rendered in the rich text or in an output. Is this possible? For example, if the user could add something like "Dear {!Customer.Firstname}" within the rich text, then I want to be able to render this in an email stating "Dear John" in the email body. Anyone experience with this? Thanks in advance, boudewijn
Zoho AppCreator
Just learned about this new Zoho Product and already have a ton of questions for which there are no answers available in the community. I thought it would be appropriate to create a new AppCreator topic. 1. Can I whitelabel apps i create for iphone and android with my company names/logos instead of Zoho branding graphics? 2. How is AppCreator different from building an app in Creator and sharing it on the Creator Mobile app? That should be a good start for now.
Zoho Creator Sending Additional Emails to Select Database Member. Why!?
We use a script that sends an email out to each member in our client database IF 1) it is a new member OR 2) if we physically select a checkbox that instructs the script to email an update status to a member. (Be aware that the update select button mentioned is reset after every use, thus, it must be physically reset with each update.) However, as of yesterday, indeed, each member updated receives the email, but in addition, and most incorrectly, one particular member, newly added as of yesterday,
Design Question
I have an Service App with several forms. As a service company, I need a way in insure dispatching is done properly.I was thinking of "Zones" based on Zipcodes.(EX 29653 = SC01). My Zipcodes and Zones are both in a dropdowns on the Equipment Form. As new equipment gets added to the database, when a Zipcode is added, the Zone also gets added automatically. I have tried using the If statement; if (input.zipcode == 29653) { Zone = "SC01" } But that would mean I would have a great deal of "If Statements"
how do i create a soap/xml envelope
how can i create a soap envelope of the following form, to send to an external api? <?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<CreateNewProduct xmlns="http://example.com/">
<Login>string</Login>
<Password>string</Password>
<SKU>string</SKU>
<ProductDescription>string</ProductDescription>
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
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",
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?
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"
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,
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".
Free-flow Scripting option gone - Please Fix!
Free-flow scripting option disappears after saving custom function the first time. Please fix ASAP.
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.
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 .
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 ?
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!
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.
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,
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.
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
Next Page