HELP... multi-step trigger-based forms with auto population
I recruit potential vendors for my company through a form on my website. The challenge is that the large amount of info we require (often 50-60 data fields) often leads vendors to submit an incomplete applications or abandon their application entirely. In an effort to minimize incomplete vendor applications and abandonments, I'd like to make application submission less non-intimidating and more authentic. Let's say I have 50 pieces of information I need to collect from potential vendors. Here's
Overtime and Expenses
Can anyone help me create a script to collect overtime and expenses from their forms and auto enter totals into their fields in the time sheet form
Military time to Standard Time
Looking for a conversion formula. Military to standard
Return an error for a custom action
HEllo, i have a report view with an action possible for each record. In my function, i added a if, to perform an action when a certain condition is filled. When the condition is not filled ( in my "else"), i would like to return an error to my application (right now, the success message appears anyway), so the user understands that the condition was not filled. How should I do that ? Should I do it in my function (through a "else"), or somewhere else in zoho creator ? Thank you so much for your answer.
Please consider letting Bulk Edit trigger "On Success" scripts
As we understand, Bulk Edit currently does not trigger any scripting. Please consider letting it trigger OnEdit.OnSuccess scripts since these do not involve any form actions, etc. Currently, when critical items are performed via onEdit.OnSuccess scripting, bulk edit is of no value and even dangerous (even to the admin), since they won't be performed after the bulk edit. We notice that record import DOES trigger OnAdd.OnSuccess scripts - this is great. So hopefully the same is reasonable for bulk
change 24 hour format to 12 hour format
How can I change 24 hour to 12 hour in creator? ex: Zapier value as Appoin = 03/12/2015 11:00:00 PM when I import in into creator the value is Appoin = 03/12/2015 11:00:00 The creator value automatically changed into A.M. I want the actual format whether 03/12/2015 11:00:00 PM or 03/12/2015 23:00:00
Alert Message
Hi, I have created a stateless form with 2 fields From date and To Date. When I give an alert to display the dates OnClick button of the form it does not display anything. However the same alert if I place On User Input of From and To date it shows the alert. I am not able to understand why the alert does not show on OnClick of the button. Can someone clarify. Regards, Milind
appointment form for beauty salon
I need appointment sistem for beauty salon.
Google Charts
hi, I would like to build up a site in Zoho Sites or Weebly with embedded in Forms/Pages/Reports from Zoho Creator (Enterprise Plan). I would like to embed Google Charts in my site as well. How can my Site query my DB in Zoho Creator and use results to generate Google Charts to show in the site? tks, pippo
wildcards and queries
Hi, I have a Table "SALES" with a Field "Name". Name can have the following 4 values: 1 "Name 1" 2 "Name 2" 3 "Name 3" 4 "" I have to pass the Name value in a function "EVALUATION" that execute a Query in "SALES". The query has to filter on "Name" values and if Name is "" has to ignore the filter on "Name" and take all Name Values ("Name 1", "Name 2", "Name 3"). I can see form other post in the Forum that wildcards are not allowed. Is there any trick in order to pass a "*" value
New Application or New Module?
Any tips or advice on when you should stop added modules to an application and to start another application? From my little experience it is easier to manipulate data between modules than between applications. How do you know when a group of modules need to be separated into a new Application?
conditional formatting of a formula field in a report
I have a formula field in a report that show a total of two other fields in the same report. I want to change formatting if that formula field is above a certain number. When I go to custom formatting it no longer gives me the option of greater than or less than. What am I doing wrong?
Updated: Parameter-based query on ID of related record - solutions and bug?
This is a combination question / feature request / workaround. We have several cases of quite-common business need to "view all <other object> related to this record, based accurately, on ID. Such as: in our list of Properties: for any particular property row, to "view all Tasks that have been associated to this Property". (We are OK with the technical setup: creating on the Properties report the custom action "View Tasks" under the Edit pulldown, which calls a custom function, that opens the Tasks
Application Backup - Scheduled?
Due to a recent issue I had with a bad piece of code, that inadvertently deleted MANY records, I am thinking about upgrading my Zoho Creator apps to one of the paid plans so that I have access to create backups. Does anyone know if this backup functionality support "scheduled" backups? Ideally I would like to make a nightly backup that I could restore from if there is an issue. Without the ability to schedule a backup, I am not really sure how the backup functionality would be all that effective,
Copy a record and a subform as a function
Hello I am trying to ma a function that gives me control of copying an old record. Som fields should be as the are in previous record an som should be different. This is no problem but when it comes to make inserts from a subform (which also is included in the form) I can't do it. Can anybody help me? It looks like this void RE_Previous_Record(int Previous_ID) { Previous_Record = Trycklista [ID = input.Previous_ID]; New_Record_ID = insert into Trycklista [ Offert_order = Previous_Record.Offert_order
Can't insert html in page editor
This is an emergent problem. Anytime that I insert html or widget into the page editor my screen turns gray and locks up. I am using Chrome. Any suggestions?
Enter Key Disable?
I have embedded my survey form into the family website to gather information about family members. So far I am very pleased with every aspect of your application and its ease of use. The one thing that is happening that is a bit frustrating is: those filling in the form are hitting the enter key to attempt to go to the next field. When they do this the data is submitted and the form settings open up the home page. They then hit the back button to get the survey back and it creates another record
How to embed a page into Form in zoho creator
Hello can we add a page into form in zoho creator? I know in pages we can embed zoho creator by drag and drop embed form/report wizard. please tell me how can I add a page into form.
Setting date field to null if string date value is empty or null
Hi, I'm recollecting data from CRM and updating in Creator. Some fields could be empty - no problem with strings. But date fields, when they are null, I haven't found the correct way for setting them. I've tried like this: r = zoho.crm.searchRecords("Contacts", "(Last Name|=|" + last_name + ")"); contact = r.get(0); new_id = insert into Persona [ Added_User = zoho.loginuser ... (more fields) Fecha_Alta_Persona = if (c.get("Fecha Alta") != null, c.get("Fecha Alta").toDate(), null)
Can I edit the field name length to be more than 200 characters?
Hi, Just starting out with creator and ran into a little issue with my field name lengths...can this be adjusted >200? Cheers Eric
Drop down list filter stopped working (in past 2 days)
I have a lookup list that is filtered by zoho.loginuserid. This lookup list is related to a database that contains email addresses for each manager. This is the code used as a filter: "email contains zoho.loginuserid" This code has been working since I have created the application over 6 months ago. Did something just change on Zoho's end?
Detail page embedded views (filtered)
Hi, Let’s say I have 2 forms that are linked to each other in a 3rd form. On a html page I show information from fields in Form 1. For example Form 1 is Product categories, here are details listed about this category. Form 2 has the products. Products should be able to be assigned to more than 1 category (unlimited). Form 3 is the linking form. A records contains a lookup field to a product, and a lookup field to a category. On the html page I want to show next to the details of Form 1, an embedded
URGENT! what is with admin interface?
hi try to add radio-button field see example it waits so much time without response has try from firefox/chrome
DB in Creator or Report?
Hi, I am writing an application to collect data using form (with a lot of scripts inside) and show sophisticated reports and graphics. I also need Customer Portal Function and SMS integration. As far as I understand there are at least 2 scenarios: 1) the DB and the Form is in Zoho Creator and the reports are made in Zoho Reports and shown and embedded in Zoho Creator pages or in web pages. 2) the DB is in Zoho Report and the Form is in Zoho Creator. The Reports are in Zoho Report and are shown and
Need Help With Images in HTML View
I'm using an HTML view to produce printed documentation of a supervisor's evaluation of an employee. I want the supervisor's signature to appear on the printed documentation, but I can't seem to get it to display. The supervisor's signature is stored in a field called signature_image in the form Employees The linkname of my HTML view is Supervisor_Visit_Record_HTML Up near the top of the HTML view's script, I have the following: <%{ r = Supervisory_Visits [ID == input.ID_in.toLong()];
how to make on_add/on_success if with "contains" ?
hi need in workflow a rule that will on_add/on_success use condition with "contains" right now workflow rules work with == or != how to make rule in such manner? if ( field_A contains " text_in_field_A ") { ..... }
Best way to update a single record via an ZC HTML Page
I have a ZC HTMl Page that I am creating and have a table where I am listing elements. On each row I would like to have a button that when clicked will update one specific field in the associated record. What is the best way to do this? Thanks!
Embeded report is down for maintenance.
I'm having an issue with embedding reports. I'll embed a report from a different app into an html page in Zoho Creator. I'll share that HTML page to the 'Customer Portal'. When I log into a "Customer" account it will not open, it says it is down for maintenance. It opens fine when I log into my Zoho Creator account.
Is Custom Action passing parameters in Public View Possible ?
Is it possible to create a custom action on a public view that passes parameters to a payment form also with public access? I have a view that's embedded in a webpage. The view has a custom function on each record. The idea is a visitor on my webpage could find a product they like, click the "Buy" custom action button and a form opens that shows what they are about to purchase. They then click the submit button and it takes them to paypal for payment. The trouble im having is from a public view
Managing application for sale on market place
Is it possible to share an application and allow another zoho account to install it but not be able to edit, duplicate or download the application? What im trying to achieve is to be able to install an application on another zoho account where the owner has purchased the application from me but not allow them to edit or duplicate the application. I notice some applications on the zoho market place are for sale. I assume that once purchased someone cant just copy the application and post it online
CRM Opportunity Amount in Creator
Hi, I am trying to get the total Opportunity amount from Zoho CRM for a Sales rep for a particular month and have that information fill up a field in Zoho Creator. I have tried various ways and scripts but was unable to. Can you please point me to the right direction or may be provide me a sample snippet? And I apologize if I have posted this in the wrong place. Thanks, Wadoos.
how to insert bulk records in creator?
i want to insert all the leads data from crm to creator how to achieve this?
Error Messages for Developer
I am listed as the main developer on an application. I created a function and get the following error when I execute the function from the create function screen. At this point I'm not concerned about the actual error but that as a developer I can't see the error message. Now I either need to contact the owner and walk them through the steps to recreate the error or I need the owners credentials to see the error myself. The first is time consuming because the owner is not a programmer. The second
Input Masking
HI, I have a Single Line field "FIELD" that has to contain only digit [0-9] and not contain any other character. Reading other post on the Forum I understand that there is no way to define a mask but on Validate section I can write a Script. The if (FIELD .matches("[0-9]"== false) ...does not work. I don't know the exact number of digit to input in FIELD. Can You help me? tks Pippo
Email
hello I'm new to zoho creator, I'm trying to create forum called leaves which employee can apply for leave, when employee apply for leave I need the form to send me email for approval or rejected. please advice how to achieve this.
zoho creator very slow/does not work
2 hours zoho creator does not work (from Italy).. any update? tks
Chat - email address
Hi, I am using the Customer Portal funcionality. Every Customer has to login with His own email. When the customer open a chat he has to enter an email address. Why don't Zoho automatically assign the email address as the login email? Is there a way not to ask the email address in the chat start up? tks, Pippo
Subform lines limit
For a subform, if there are too many lines, is it going to have performance issues? If a subform has 2,000 lines, can I limit the # of lines to 10 maximum, and page-lize the records, and add in a search function for the subform records?
Is Zoho Creator Integrated with Zoho Subscriptions?
How to call Zoho Subscriptions API[ "create new subscriptions"] from Zoho Creator? https://www.zoho.com/subscriptions/api/v1/#create-a-subscription Do you have any default method or Do I need to call POST api?
Adding new fields on load
Is it possible to make a form dynamic and add fields on load ? For example, if on load i request records from CRM and in the response I have 5 records. I would like to recreate a new input for each record loaded from CRM. Is it possible ? thanks, Guillaume
Next Page