date field default to current date or date created
How can I force a date fiedl to display the date the record is created. I can';t seem to find a deluge function that returns that variable. and If I do, how do I make that the default value for the field. Specifically, I am creating records of items that are shipped, so the "date shipped" needs to default to the current date.
Data not saving
I'm trying to create my first Zoho app. Adding fields to a form works fine, but any changes I make aren't being saved (despite the popup message claiming that changes are being saved). Any ideas why? Thanks!
Lookup field
Hi, i'm new to Zoho Creator and i want to build a form/app witch wil used by my employee. He will fill this form at the job site. Now i've manage to build the app for 80 % only i have a few issue's We have ± 20 customers and each costumer has ± 4 contacts. Now i made a drop down wit the costumers name and mad a rule "when customer field = "customers name"" then show the subform of costumer "costumers name". This subform has 2 drop downs with "sent quote to" "sent .dwg file to". This is working only
please add javascript, css, ajax, and bootstrap support to forms reports and pages
4down vote I wrote an article about how to make calls to the Zoho Creator backend here: http://www.lighthouselogic.com/cross-domain-ajax-requests-to-zoho-creator/ I have used this technique successfully to host a simple html and javascript frontend that talks directly to the Zoho Database.
Integrating zoho creator and zoho invoice
Hi, I am using zoho creator. As for now, I am creating zoho invoice from the script using zoho integration. My question is, I want to know the acknowledgement when the invoices are paid by the customer. How can I get that?
Need a Web Application Developer
Hi, I have a new payment system idea and I need a web developer. Before we begin with, I will always like an NDA agreement, I will also like to discuss the SDLC stage, know my rough cost from the beginning to the end and also, I will like to work with someone that is interested in new innovatiosns and can also contribute his/her own knowlege into the whole idea. We can always be partner, it depends on how interested the developer is.
Function to create record
is a function such as the following possible? I can not seem to get it to work. I am trying to create records in ANOTHER form based on every record in for 1. IE for each record in form1 report, place a record in form2. void scripts.customFunction(fun) { for each <myvariable> in <form> { insert into <form> [ <field> = <expression> ] } }
I found a bug...
Hi, I think I found a bug. On the mobile platform, when I select one or more values in a "Multi Select" field and this is the last field of the subform, the value (s) are not saved. To make sure it was not me the problem, I reversed the field so that it was not the last and my data saved. Tank you! Steph.
decimal number into words?
Hi there, I've been trying to convert a decimal number from a currency field into words to a text field using a function but I just found this solution: click here , which only works for int values... can anyone help me to modify this code so it can work for decimal values or is there any different way to do it? I would really appreciate your help! thanks in advance.
Problems with equalsIgnoreCase?
Hello, I am attempting to revive an App used last year for this coming summer. I have run into an issue with my registration validation and case sensitivity. The equalsIgnoreCase() function does not seem to catch case variations with my entries. Is this something others are experiencing? Thank you for any insight you can share! I check a new entry against my existing entries to ensure a new user does not share a First Name, a Last Name, AND a Phone Number. Here is the code I am using: temp = input.Phone_Number.getAlphaNumeric() ;
Fetching Records by ID if search key from URL is String
Hi, I'm new to Zoho Creator and tried to solve this by digging through the available explanations and posts for quite a while, but I have to admit now that I'm stuck. This is my setup: Form A and Form B contain records of different types of products with some details. In Form C, I select a product from B and assign multiple records from A to it in a subform. Now, I want to offer a search: The user selects a product from B from a dropdown, hits a button and should see - product details for the selected
Import of Data into Creator only seems to work for Administrator???
Is it possible for more than the Administrator to import data on a particular Form or Report in Zoho Creator? It seems that only the Administrator of the App is able to import data into the the App. Is there a way to allow other users to do the same? by Form or Report?
Deluge script and on succes action
Hi all, I have 2 Forms "Buy" and "Sell" with 2 reports ("Available" and "Buy report") based on "Buy" and 1 ("Sell Report") on "Sell". Can someone help me with the code to Fetch the records of "Buy Form" to "Sell form"? i have a lookup field called "Model" , So i can use that to create a relationship with the forms, am i correct? as last, is it possible to have a "On success action" on the "Sell Form" where it takes away the quantity of the "Available report"? Thanks Guys!
Dynamically clear an Image Field
Is there a way to dynamically clear an image field? I need to set up that when the selection in another field is changed that it clears all the information in part of the form, this includes some image fields. I've been able to get everything else cleared, but not the image fields. A sample of the code I'm using is below. if ((input.Customer_Prospect == "Existing Customer") && (input.Status == "Planned")) { input.Comments = ""; hide Comments; hide Number_Of_Images_Required;
Function
Hi all! I have this function: void order.toDelivery(Orders order) { status = true; for each recRow in order.Add_Product { product = Products[ID == recRow.Product_Name]; balanceQuan = product.Available_Stock - recRow.Quantity; status = true; if(balanceQuan <= 0) { status = false; } } if(status) { for each recRow in order.Add_Product { product = Products[ID == recRow.Product_Name];
Multiple filters on report
I have a report that covers a range of dates. The range is based on pay periods, and I need the filter to display the current period. However, I need to keep the previous filters. Bottom line, how can I ensure that the current pay period is the default filter. I don't have a problem changing this manually twice a month. but I can't seem to locate a method of even doing that.
Does Zoho support "Unmanaged Packages" as does Salesforce.com?
I am working with small businesses that will need a lot of the same customizations. I have worked a lot on the SFDC platform and loved the convenience of creating unmanaged packages to quickly install the customization into a clients org. How is this handled in Zoho? Thank you in advance! Larry
Sendmail not working today?
Anyone having trouble with sendmail today? Our app hasn't changed at all and the long established script does everything else it usually does except actually sending an email. Suddenly noticed this problem today. Nothing in the error logs indicating a problem? Many thanks.
Changing the display name of Sendmail From field
Hi, I'm sending out emails from zoho.loginuserid, which happens to be backoffice.assistant@example.com My customer sees it as backoffice.ass because gmail shortens it. I'm looking for a way to specify a user-friendly display name for the Sendmail task.
Data in Subform
Hi guys, I have a subform where i can "add new records" and fetch records from a form to my subform. The first row fetches the record perfectly, but from the second row...it fetches nothing. This is my fetching script: for each rec in Available [ID == input.Product.Model] { input.Product.Supplierl = rec.Supplier_Available; input.Product.Date = rec.Date_Available; input.Product.Price = rec.Price_Available; input.Product.Stock = rec.Price_Stock available; } THis code only fetches
Add or Modify record
I am new to zoho so any help would really be appreciated I have a simple customer form with the usual customer info when i enter the phone number, I would like one of two things to happen If customer is already on file, display all data and allow for modification if not on file, allow for new data to be entered for the customer seems simple enough but i am not sure if i need a subform or can i do this in one main form? Thank you ps: submitted this an hour ago but has not shown up so reposting
Format of pdf in schedules
Hi, The layout of the pdf file generated in schedules are missing several configurations. Sorting, grouping, group count and sums are not performed in the report. please compare the two files enclosed. Thanks in advance for adressing the issue. Brynjulv
Can't use share/unshare deluge task with variable as a component name.
I am trying to write a function that takes an email address and a page name and share the page with the user. I found that using the share/unshare task with a variable like this: componentName = "somePage"; share view(componentName, email);... causes an error, but this works: share view("somePage", email); Is there a way to share/unshare pages without hard-coding all of my page names?
extracting data from xml
Hello I am trying t develop an application where only the specific xml data is required. The xml data is availablle online. Please see the below link. http://www.hmrc.gov.uk/softwaredevelopers/rates/exrates-monthly-0517.xml from this I want only the ratenew field for specific countries. Please let me know how to do this.
Disable "On Success" message
Hello, I'm relatively new to Zoho. I'm wondering if there is a way to deactivate the "On Success" message entirely when adding or updating a form record. Currently, it's taking me to a blank form with the success message and no buttons, I have to hit the "back" button on the browser. I do have code in the "On Success" sections of both the On Add and On Update blocks of the workflow, if that matters. Thanks! Dan
Mobile Phone Apps via Zoho Creator
Good day I am wondering if it is possible to create something similar to the App below in Creator? https://www.i-card.com.au/ Many thanks Emma
Scan disappeared
I had a form which included two fields set to scan both bar codes as well as qr codes.This morning, I re-arranged some fields including the field that reads QR codes. Sadly, when I got to the warehouse, I was unable to scan. Looking at the form designer both are properly enabled. Oh, and I have this problem on both my phone as well as my tablet. Any ideas?
Script for addition
HI all, Can i get a little help pls? I need a Script that will do addition to Sub Totaal for every "Add new record"
stateless form
I think I understand the basic concept of a stateless form. I have not yet attempted to build on, but I do have a question about it's use. Can I use a stateless form to define several system-wide variables? Example: I have technicians in several states and I want them to see only the service tickets in their state. I believe that I can set a filter based on their user name, but I need to set the filter based on the state. So, can I get the user to select a state from a dropdown and pass that
How to split/convert a string into a list/array ?
How can I convert/split a string into a list/array? Example - "how are you" now we will convert this string into a list/array like - {"how", "are", "you"}; How can I do this? Is there any built in functions for this?
Creater zoho.crm.create problem
I am trying to send details to CRM from Creator using deluge "on success" script. This is going to the "Deals" module of CRM. //creating map productDetails = Map(); //inserting details to map productDetails.put("Product Name",product_name); productDetails.put("Unit Price",unite_price); productDetails.put("Quantity in Stock",qty_stock); //sending to CRM crmResp = zoho.crm.create("Products",productDetails); everything works fine and I get the correct response back, but
Creator -> CRM Deals
I have a form that creates an invoice, on the creation of this invoice I want to push data to CRM "potentials" I wrote the following code. (FYI, to debug I entered in the ACTUAL record ID for that field. but still seems to give me a 4401 error. some pretext the date is in MM/dd/yyyy in both CRM & Creator attached is an image of the CRM module with * showing the required fields line 10 is a picklist, this is def not the issue as I can replicate this in other modules with no problems line 6,7,8 pushes
fetch/copy one form sub form data to another sub form
hi all, i have an application where there are 2 forms first is material requisition form (Material_requisition_form) with fields Requisition no. and a subform items required (items_required) with fields Item1 UOM Demanded_quantity 2nd is material issuance note (Material_issuance_note) having a lookup field of material requisition form no. (as parameter) and subform Item Details (Item_details) with fields Item1 UOM Demanded_quantity i want to fetch/copy material requisition form sub form (items_required)
franch accent on a pdf file name
Zoho creator does not let me create a pdf with a french accent in its filename.....it just does not create the pdf file at all.... Does anybody has had this problem béfore ...) ?
Managing same values ' field inside a subform
In a quote form, the subform is a list of products. As the user add a product in a subform, how do I check, right after the product code has been typed in, if the user has not already typed in the same product in any rows above ? We frequently have quotes with up to 400 lines in the quote subform... That is why we would like to help the users by telling him that is has already typed in the product he is adding.
Report Conditional Formatting - Highlight records that where created more than 7 days ago
Hi All I am trying to created a conditioning format criteria to highlight in red all records that where created more than severn days ago. I am using the AddedTime system field in the condition and the operator 'n days ago' and this only highlights records that where created seven days ago only. How do I show records that are seven days old and older? Regards Martin
Send field from creator to crm lookup field
Hi, I am sending an account name from a creator form called Contacts. The Account Name is the name of the company the new contact works for. I am able to send all the data and create a new contact; however, the company name does not show up. The field in CRM for the Account Name is a CRM lookup field. I have the code written so that when the new contact is created, the new company is also created. In my CRM both the new contact and company exist, but the Account Name on the contact is not updating
another newbe question
managing service calls. I have a subform for "trips" some calls require multiple trips. When the main form is displayed the subforms show up as they should with one exception. The ticket number is empty. More important when I view the subform table, that ticket number is also empty. If I manually enter the ticket number it will show up in the report. The ticket number is the link between the form and subform, but I don't remember specifying that fact. So, how do I get the ticket number written
selecting a form or report
I have accumulated a fairly long list of forms and reports.When I want to edit a form I have to scroll down and find it in the list, or use the browser's search function to locate the desired item. Is there a better and/or faster way to locate the form/report?
Pivot Chart dont show dropdown
Hi, I have a rather simple form with date/time field, two drop downs and multiple text field. I want to create a pivot chart with the date/rime field and the drop downs, however I only get the date/time field in list of options?
Next Page