RSVP Form with multiple conditioned pages and access code
I'd like to set up an RSVP form which initially lets users input a couple entries (their name and whether they're attending). At the bottom of this page I'd like them to enter a code so that I can verify only the people who have been invited are rsvping. If they enter the code wrong it shouldn't let them submit the form. If they enter the code correctly, I want them to be directed to a second form that is conditioned on their answer to whether they're attending. Is this possible? Thank you!!!
using Jquery
how can i Use jquery in my html web pages. actually i have developed an html page with jquery effects in zoho creator application. but the effects are not loading . is there any other way of including the script for jquery in zoho or zoho doesn't supports the jquery effects in application's html pages.
How to edit this list ?
Hi How to edit Edit list , for image below I want to edit list to make it Print only instead of Edit, Delete ...etc. Thanks
Email Sender in Zoho Creator
Hello. I would like to change the email sender of an email that's sent from Zoho Creator. I added a user with the wanted email address, put him as administrator of my application, and as primary contact. It still sends with the first email. How to change that ? Thanks, Guillaume
Open Calendar Report as a custom action?
I have a Vacation Request report, which is in summary form and has two custom actions to allow for approval and rejection in the report. I have another report which is in Calendar View. Is it possible to create a custom action button in the Vacation Request report which will open the Calendar Report? Thanks in advance!!! Joy
Dropdown lists - how to filter if it is not a lookup
I have two dropdown fields: Location and Department. I would like the Department dropdown list to display options based on whatever is chosen as the Location. Is this possible? As always, thank you in advance!
Is it possible to access data in another application?
Dears, I want to build new application, which would work with data stored in existing application. Both applications will belong to same user. Is it possible? What is the format (deluge script) for fetch, insert and delete records stored in another application? Thanks in advance!
Dynamic picklists with dynamic filters
Setting a filter on a picklist is a really easy way to dynamically filter results, as other picklists are chosen. I have a number of criteria picklists which narrow the search results of a final picklist. I have the following Status = Active Activity_Type Location Site_Name Equipment (Which contains the list of equipment, which have the above 4 criteria) So my filter looks like: values = Equipment_Record[(((Status == "Active" && Sites.Site_Name == input.Site_Old) && Activity_Type == input.Activity_Type)
'BIGINT' data type
Hello, 1. How can I fix the problem in the following code? if(input.Shipping_Value != null) { temp = Shipping_Value[ID == input.Shipping_Value]; input.Product_Cost_Shipping_Method=temp.Shipping_Method; } The message is: Error at line number : 5 Variable 'Product_Cost_Shipping_Method' is already defined of data type 'STRING' but trying to update 'BIGINT' data type. Thank you
If else code with Improper Statement
1. Hello, Please take a look at the simple If else code and tell me what is wrong: if(input.Product_Cost < 10.00) {input.Shipping_Value.toString() == "Under £10";} else if(input.Product_Cost < 20.00) {input.Shipping_Value == "£10 - £20";} else {input.Shipping_Value == "Over £20";} Shipping_Value is a vlookup field and Product_Cost is a currency field. The message is: Error at line number : 2 Improper Statement Error might be due to missing
How to hide a Section with deluge
Dear All, As we know to write deluge code we use the Form Link Names in general (as inputs etc.). As I can see, when I create a section there is also a Section Link Name. Can I write deluge code for the Sections? As an example, is there any way to hide a section with deluge code in a form?
Zoho Creator Add Llead to CRM or update Date Created field if lead exists.
Our zoho creator application currently adds a new lead to zoho crm when a lead is added to zoho creator. We have a major problem where some leads already exist in zoho CRM and we are ending up with a lot of duplicate leads. The feature in zoho creator where it automatically detects duplicate leads and updates the records is good but our trouble is these leads do not move to the top of zoho crm lead list. Because of this we dont realize that a lead is requesting something from us again. It seems
Does anybody have experience of integrating TAPI phone systems with CRM?
Phonebridge does not do this. Thanks!
Relationships question again! Should be easy for you experts
I am working on a database to track links between people, places and organisations. Form 1 is object which has one field - name Form 2 is link which has two fields I want to relate to two objects. An object can have MANY links. So I'm trying to make a ONE to MANY to ONE relationship. I want to be able to create links from either an object form or a link form. I want to be able to show reports (lists) of links I want object reports to also show the list of links they have so: I have set up
Task Scheduler Sharing/Reminder
Hello, I was wondering if zoho creator can be built to send SMS reminders to recipients. I am aware that creator provides auto email reminders however not every trady uses a computer. Any help on this would be helpful. Thanks
Error updating record with Zoho Creator Mobile App
I have a form that updates a record for an inventory app I've created. It's just a stateless form that queries a record, lets the user change a few fields, then click a button to update and makes the changes. Running it through a web browser, it works perfectly. When I try to run the update I get an error "Error in executing update record task. Unable to update the record Assigned_To. Unable to update the value." Assigned_To is just the first of a few records that need to get updated. It errors on
Remove zoho creator header from public html view
We have a public html view that we are converting to pdf using api. Trouble is the public html view seems to always show a zoho creator header at the top of the page. We want to remove this page. How can we tell zoho creator not to display this header but only display the contends of my html view? Below is an image of the zoho creater header that appears on top of our html page. The orange part is the start of the html code. Everything above this is the header of zoho creator. Can this be removed
Creating lookup reference fields
Not sure if I have described this correctly. I have a form which has a drop down linked to another forms data. However when this has been selected we need two of the fields from the dropped down data to be displayed as references. So they don't need to be saved in this form as this would mess up the integrity of the data. I thought this would have to be a static form that is effectively a duplicate of the actual one but with a couple of additional fields that I can read the bits of reference info
Lookup fields in lookup fields
Within my records I generate a name based on lookup fields selected in the form. For example: Type = Apples, Oranges, Limes Location = South America, USA, Germany From a different form I want to choose from a number of entries that are made of the above selections, and choose them in a drop down. The issue is that the Display fields can only be made up of non lookup fields, which is a real pain, as the selections above identify the type and location, which is perfect for picking it in the dropdown.
API One to Many Relationship
If i have 2 forms when I add data through the REST API is there a way to manually establish the one to many relationship? for example I have a form that tracks purchase orders and another one that tracks items in the purchase order If i were to have the purchase order number in both forms would this allow for the relationship to be created? Thank You.
Schedule attachments
Hello, not run schedule attachements, which in the previous version worked Creator is a simple function and gives error sending mail. Please help! sendmail [ from:zoho.adminuserid to:"sigo.tel3@gmail.com" subject:"SIGO - BACKUP DIARIO " message:"ENVIO AUTOMATICO" content type:HTML attachments :view:BACKUP_DIARIO_TAREAS as XLS ]
Installment
i need to creat a form to payment in installments: example: Price: 500 $ Installments: 5 Initial Date(First Installment): ex 01/01/2000 So with this data i want to create 5 records in a table: first record - Price: 100 $ Date: 01/01/2000 second record - Price: 100 $ Date: 01/02/2000 third record - Price: 100 $ Date: 01/03/2000 forth record - Price: 100 $ Date: 01/04/2000 fifth record - Price: 100 $ Date: 01/05/2000
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.
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
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
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
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
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!
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
Next Page