Scheduled task to update Invoice Payment Status in Creator
Hi Team I have ZC and ZI. ZC currently creates invoices in ZI and keeps a lot of the created invoice ID. I need to set up a scheduled task that runs through records where payment status = "Not Paid" and check each record in Invoice for any change in payment status. If paid it should update the Payment Status to Paid. I can do this for an individual record using GetInvoiceInfo() but how do I nest that inside a For Each function so that it runs through each record and checks/updates? I currently have
Totaling Subform
Hello, On a form I have a subform. In the subform I have fields such as Qnty, Price, Labor and Subtotal. I have set diluge to update the subtotal based on data changed in the other fields, all is good. But now I need a total field to add the Sub_Total fields in the Subform. How can I do this? Iram
Combining 2 strings, and converting to a Date / Time field?
I have an application where a user selects a report date, and then a starting time. I have a date field for the report date, and a drop down menu with 15 minute increments for the starting time. I am trying to combine these two fields, and then place them in a Date / Time field, but I can not get it formatted right. Here is the code I currently have. datetime_string = input.report_date + input.start_time_input; input.start_time = datetime_string.toTime("MM/dd/yyyy"); Which gives me the result
Dropdown list filter issue
Hi All, I feel I should be able to solve this but I'm getting nowhere :( I have dropdown lists of available resources. These resource tables use a lookup for the location of each resource. I want to only show resources available at the user's location in the master form. The master form also uses a lookup for the user's location. When it comes to specifying the filter to only show the user resources available at their location, I just can't make this work. (If I could convert the lookup location
Iphone App for lower resolution Images?
Hello, I am developing a Zoho Creator database and I have an image field which I have been using to upload print screens from Iphone. But now I would like to start taking pictures directly from my Iphone then upload from my camera roll into zoho but I get the error "File image.jpg is too large to upload". I understand these images can be big and I know about the 5MB limitation. Does anyone know of a nice and easy Iphone app that will take low res pictures so that I can upload from my iphone camera
New Bugs: Developer Zone
I have noticed the following irregularities: Please note, the developer account is an OLD account (old price list). 1) When app is republished to a client with an old price list account: All seems to work as it should...HOWEVER, when using the "Copy Data" function in the Developer Zone (client side) from the earlier version to the just installed updated version, all looks fine on screen, but in fact NO DATA was copied. 2) When app is republished to a client with a new price list account: After installing
Need Formula field in Subform
Hello, On a sales form I have a subform to track multiple services. In the subform I have the following fields: quantity, description, price, labor and now I need a Sub-Total field but I can't add a formula field to the subform. I was going to add a Formula field called Sub-Total to perform the following calculation in each row: quantity x (price + labor). Then I need a Grand Total to sum up all row sub totals. How can I do this? Your help is greatly appreciated. Iram
Import to Subform does not work with lookup fields
I created Import to insert records into Main form and subform. it works just fine when subform has regular text fields. However, it does not work if subform has "Lookup Filed". Here is how I defined Lookup AUDIBLE_US - Staff - Name (App name - Form name - Field name) And here is what I have on excel file (again, it works just fine with regular field and I know that I can select these values in my subform: 1st sheet: PRODUCT ID Narrator_SubForm TEST3 1,2 2nd Sheet REC LINK ID NarratorSub 1 Alexander,
Simple database issue
I have a simple database I will use to track orders for my own purposes, this has been setup on zoho. I require a solution to this problem on zoho: I have one CSV file like this: SalesRecord, ProductCode, TrackingNumber 1 . A001, 2, A002 3, A002 4, A003 I have another CSV file like this: ProductCode, TrackingNumber A001, XX345 A002, XX346 A003, XX347 I want to import file 1 and then file 2 to have database records like this: SalesRecord, ProductCode, TrackingNumber 1 . A001, XX345 2, A002, XX346
Help: Pay per user of application
For a new app, I am trying to come up with a payment model. A customer buys a Zoho Creator plan to access Creator. I have an app that I want a customer to pay me per user per month for access to the app. Let's say $25 per user per month. How can I implement this functionality so that a customer of my app cannot add their own users?
Date-Time Operators
For some reason Date-Time Operators is missing in the support content even though it is listed in the outline on top of the page (Type of Operators) The content simply skips them. I need to calculate minutes elapsed out of two date-time fields. I tried simply a substraction (DateTimeField2-DateTimeField1) but issues an error of inpropper estatements. Any help? Thanks Luis
Employee Table and "Zoho.Login User"
Hi All, I'm trying to complete a number of tasks within my request manager tool and whilst I can find several threads that go some way to answer some questions I'm still not sure how to implement the following: The tool I am creating is to track requests for PC's to go out to a customer site or for a request to collect some PC's back to our warehouse. We will be using this across a number of different accounts and would ideally like the one tool to track all accounts. We will also have team members
Modify records from multiple forms
Hello, I have been trying to figure out how to share information across several forms. For example, I have a main form that is used to capture customer information (named Customer) and another that is used to generate an estimate (named Estimate). I am using the lookup tool on my estimate form to reference the customer form and to bring in customer information (named Customer) but I have not figured out how to get the estimate form to publish information to the customer form. This needs to allow
How to count the number of selections in multiselect picklist?
Hello! We have a form (see it live here under Step 2) where the non-prisoner public can select from our list of potential prisoner penpals and give us their email address. (If you use it, please call yourself Test, test@test.com, and only select the Test prisoner records). Currently, we have an email sent whenever a form is submitted to people who review the requested penpals, and only approve it if there are fewer than 5 penpals requested. Ideally, there could be an automatic cutoff built-in.
How do I change the font used in a report?
Can I change the fonts of single lines, dates, email addresses etc. in a report?
Problem with 2 Subforms View in HTML
Hi, I have an HTML view called "Product Offer Sheet" based on my form Create_Products. I fetch and display data from the form = no problem (using: rec = Create_Product [ID == input.id.toLong()]) Then I fetch data of on linked form = Problem (using: for each z in rec.Product_Quotes_ID) And then I fetch data of a subform = no problem (using: for each i in rec.Composition) When I try to save my free-flow script, it cannot and the error is mentionning that my used data (for example: z.Payment_Quotes_Customs_Fee)
Invoice ID Field
Hi Team I have created an invoice within Zoho Invoice from Creator. I want to extract the Invoice ID from the mapped invoice. However the following code to populate Invoice_ID does not work. As a matter of fact Invoice_ID, Invoice_Status and Invoice_Sent_Date do not populate at all (these 3 fields need to be populated right after the invoice gets created). gateWays={ "PayPal" : 1, "Authorise.Net" : "", "GoogleCheckout" : "" }; invCustResponse = zoho.invoice.createcustomer({ "CustomerName" : input.Customer_Name,
Get text from a Zoho CRM field in Zoho Creator
As we know Lookup field in deluge script (input.lookup) gets record ID from lookup table(form) regardless our display settings. To access fields in lookup forms we have to use val = formname[ID == input.lookup].field; My question is, if I use a Zoho CRM field in my form with a field ID like Details_ID how can I get the text (and not the ID) of the selected field? For example this one returns the ID Name = input.Details_ID;
Dead-end ZOHO support on dynamic pick list
list = Product [Category == row.Category] sort by Product_Code ; clear row.Items; row.Items:UI.append(itemlist.Product_Code.getall()) ZOHO acknowledges that the code above at https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html doesn’t work. I’ve waited weeks in vain for support to get back to me with a solution. Any ideas? Thanks.
Populating information from CRM Modules
So I am trying to use code that I have used previously with no luck. In the past I have used the CRM Lookup to populate fields in a creator form from the Leads Module. It works perfect every time. Now I am trying to do the same but pull the information to/from the Accounts module and get a generic error every time I try it. Code that works: crmResp = zoho.crm.getRecordById(("Leads"), input.Zoho_CRM_ID); input.Company = (crmResp.get("Company")).toString(); input.First_Name = (crmResp.get("First
Using a record as a template for a new record
I'm wondering if this is possible and if my idea of how to do it might work. Maybe someone has an example of this they could share? I want to be able to create a new record that pulls all the value from another record (the template record). The simplest way to think of this would be a drop down that when a value is selected will fill in the entire form. I don't want to code this long hand and instead I want the values to be fetched from another record that is a template already filled out appropriately.
Embeding Image In Creator from URL of Image Using Deluge Script
I would like to be able to pull an image into my forms image field using it's URL by Deluge Scripting. Here is the URL of the image I want to pull in: http://s3.amazonaws.com/gimages/san432/4169643/21826/Image_1_ae045da0-acb2-0131-847c-22000a1fb1c7.jpg Is this possible? In other words; I want this image to reside within Zoho Creator, not on another server. Thanks for any help.
Subform field actions not working in parent form
I am creating a sales order form that will have a subform, called products, that has a lookup field that searches ZOHO CRM-Products. The products form also has a quantity field and a price field. I added a field action to the lookup field that populates the price field with the price of the product selected using this: crmResp = zoho.crm.getRecordById("Products", input.Product_ID); x = crmResp.get("Unit Price"); input.Price = x; This works fine. However, when I access the the subform through the
SendMail Not Working
I have a public sendmail form but require users to zoho-login before they can see it. Here's the error Here's the form Cheers, John Whitney
Unable to set correct variable
I am stuck, and in need of some assistance please. Line 5 (VAR_Tool_State) if I understand correctly should return the newest entry that meets the two criteria stated. However it is returning the FIRST entry made for the tool and serial number combination. Any ideas? Support has access. //ASSETS Current Location Lookup VAR_Location = Assets[(Part_Number == input.Part_Number && Serial_Number == input.Serial_Number)].Move_Asset_To; VAR_Assigned_To = Assets[(Part_Number == input.Part_Number && Serial_Number
Company Info on Form
Hello, I created a form in Zoho creator for Invoices. I have added all of the fields necessary. All is good but at the top of the form I would like to include my company name in case I need to print the Invoice. How can I add/embed the following to the top of the form? Invoice My Company Name Address City and State Zip Phone Thanks. Iram
Formula data type doesn't show up as Currency
I have a formula field (Revenue) that is calculated from multiplying a Number field times a Currency field. The result is not showing as a Currency field. Details: Qty is a user-input field, data type is Number Price is a user-input field, data type is Currency (USD) Revenue is a formula field, (Qty * Price) -- it should be shown as a Currency type, but it's showing up as a decimal field. How can I make Revenue show up as a currency data type in my views and reports??? Thanks.
Cannot iterate all values of a subform in HTML view. Only the first one appear
Dear Zoho team, I am working on an HTML view (page) add it to a custom function in a report and it works fine. It is a "Product_Offer_Sheet" HTML. It will fetch data from my Form "Create_Product" No problem about that but in this HTML view, there is one table where I must display the composition of the product which is in a Subform "Composition" of the Form "Create_Product" I did the following code but I can only see the first record of the subform htmlpage Product_Offer_Sheet(id, hidePrint) displayname
Newbie needs expert advice PLEASE!!! :)
Hi All, I have two forms, Job Enquiry and Customer List. In the Job Enquiry I have a dropdown box field that selects if the client is new or existing. If new is selected I want to be able to automatically open the customer list form and complete the add new customer data entry. If possible I would like to be able to select a client company name from a drop-down list in the job enquiry form and the other associated fields from the customer list (I.E. Contact name, telephone number, email, address,
Adding Data From Email (Disclaimer, Signature, Images)
Hi has anyone found a way to get Zoho Creator to ignore footers at the bottom of an email when adding data to a form through email? I have setup an excel file that uploads to our database however I have found many of my clients have a Disclaimer, Signature, Images etc at the bottom of the email. I am getting excel to generate the email as n HTML file however any text after the form information causes Zoho to generate an error. I contacted support and was told the is no work around. This is a huge
Cancel Delete if there are records in another form that are related to the form I am trying to delete
I think this is simple. Basically if someone tries to delete a PO that has a single or multiple time records associated with it I want it to cancel the delete. I am not sure if I need to count and then create a condition off of that count for it to work? For example, rec = Employee_Time [ID == PS_Work_Order_Purchase_Order]; if (rec != null) { alert "There are Labor / Equipment / Material records in the database you cannot delete this PO / WO!!"; cancel delete; }
business rule.
Hi, I am trying to add following business rule. Please let me know how can I do this. Check box1 Check box2 If the check box2 is checked we have to make check box1 as mandatory. Can this be done by creating creator rule or do I need to do this by java script. Thanks in advance.
How to Make HTML Content Editable without JavaScript / jQuery?
Dear Colleagues, My question is general and I do not know if it is possible to do that in Creator. Let's say that I have an html page with a simple table like <table> <tr> <td contenteditable="true">Hello!!</td> </tr> </table> As we know, HTML has an attibute called contenteditable, in which we can edit the data in our page. The problem is that if I change the text and then click the Print button, it returns 'Hello!!' and not the text which I last inserted. I think that this is because
Is there an easier/better way to create a script that repeats n number of times?
nline = List:Int({1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}); cntLst = List:Int(); num = input.n; for each integ in nline { if (!(num == 0)) { cntLst.add(num); num = (num - 1); } } for each ent in cntLst { some proceedure } Any help would be great!
How to determine if the lookup dropdown does not have a selected value
I have a master form: Branch Master - ID - Branch Name Another form - Account Name on Account Branch (Lookup from Account to Branch Master on ID column of Branch Master) On the Account form, when I write this code input.Branch != null to determine that the lookup dropdown has a value, I can't even save the script. How do I determine if a selection has been (or a selection has not been made) made on a lookup dropdown?
Public Access and Login
Hi, I've built an application that I wish to make public and commercialize. Is it possible to customize the registration for my App that combines with your login registration? ie I want to ask additional questions and log them plus send login confirmation with username and password. Key reason is I use the login variables within creator throughout the App and if I make the app public with login I think I lose this variable use, I'm not sure how to get round this. Also want to change the Home option
Duplicates/launching same application multiple times
I'm creating an application that I would like to launch to all students on campus. I would like to relaunch the SAME application every semester to update the students file on which classes they have taken. How can I do this? Also, how can I make sure that every time they fill out this application, their information will automatically update their previous report and not add a duplicate student with the same name? Thanks!!
Subform Bidirectional lookup
Hi Zoho Team, I have the following problem: I have 4 forms (Supplier, Product, Quotation, Order) Supplier has a bidirectional link to Product (One Supplier, Many Products) Product has a bidirectional link to Quotation (One Product, Many Quotations) And now I am working on the bidirectional link between Quotations and Orders (One quotation, Many Orders) But I'm stuck, I want a subform in my Order Form because it allows users to create an Order including several Quotations I can create the lookup field
auto fill field in sub form
Hi I have tried following other posts about auto filling fields but cannot seem to get it working, here's my set-up: Main form: quote_system Sub form: areas Price list form: master_price_list In the sub form, users will fill out rows of data completing a quote, they start by selecting an area (which populates from a lookup field), based on this selection a new lookup field gives them a type from the master_parts_list which in turn gives another dropdown with possible parts (again from the master_parts_list).
Identification of Duplicate Records
What is the most efficient way to identify duplicate records for a large number of records? It does not seem efficient to compare each record to all others because of the maximum number of executable statements per deluge action. Note: I did not enable one record per user due to the type information being gathered. Cheers, John Whitney
Next Page