how to append entry to multi-line field?
hi need log all operations with entries. and think using multiline field - to append custom entry on every "on edit - on success operation" how can i append entries to multiline field? see example
Provide "Duplicate" function for Stateless Forms
It would save a lot of time if Sateless forms could be duplicated to create varitaions, instead of rebuilding every time from the master.
Updating a time in a timesheet record but not the date
I have been trying to set up a report where, if you update the time for a record it updates the time but not the date associated with it. I am able to get the time to update properly, but I don't see any way to get around the date updating the Actual_Time, Total_Time, and Lunch_Time due to the zoho.currentdate variable. Any help would be greatly appreciated. date timesheet.strToTime(map timeMap) { hrs = (input.timeMap.get("hrs")).toLong(); mins = (input.timeMap.get(("mins"))).toLong(); timeValue
Updating a form on the iphone app for a field with decimals
The iphone app for creator use a , (comma) instead of a . (fullstop) to indicate the decimals. How do i correct this? Dawi
Using portal URL - Public link
Hi, I've set-up an automated email for portal users to click a link to a form and enter their response, as the form is public this works: <a href='https://creator.zoho.com/" + zoho.appuri + "/form-perma/Form_Name/Record_ID=" + record.ID + "&Email=" + record.Email_Address + "&Event_Details=" + eventDetailsID + "&Availability=Yes'><u>Yes, I’m available</u></a> But I would prefer to use the portal URL without the user having to sign in like: <a href='https://myPortalURL/form-perma/Form_Name/Record_ID="
Brand new to Zoho Creator! Please Help!
I run a flyer delivery service. I'm trying (unsuccessfully) to create an app in zoho to track the flyers going in and out of the office. It's pretty simple, I need to check them in when they come in, and then check them out when they go out. I built an app that can do that. The problem I am having to getting it to automatically figure out the number left by client. This is an example: Let's say "Client A" bring in 1,000 flyers. I would input that into the app. I got that much. Then "Client B" bring
The "Share Data With Peers" option does not appear to work.
Please refer to this: https://www.zoho.com/creator/help/security/manage-roles.html · “ By default, users of the same role cannot access each others data. For example, the VP Engineering cannot access the VP Marketing data and vice versa though they are of the same hierarchy." This appears not to be the case. In my application, users in the same role can see each other’s data, regardless of who ‘owns’ the record. I have “share data with peers” OFF for the role. I have tried deleting the
Upload File Hanging on submit
I have created a simple form to allow account managers to upload an excel invoice and complete details which when submitted then generates an email to finance. Finance should in theory then be able to access the report and download the invoices once a month when they do the invoicing. Unfortunately when the account manager uploads a spreadsheet, completes details and hits submit the details of the file disappear from the box and the page just hangs so is never submitted. If no file is uploaded then
Android app crashes when trying to load reports
Hi, I have a problem with the android app on my tablet (Huawei MediaPad 7) running Android 4.3. It loads forms ok, but it won't load reports. It just crashes every time. It tries loading and then says, "Unfortunately, Zoho Creator has stopped." It does this for every report. I have the app installed on my Samsung Galaxy s5 and it works fine. Please help. Ben Taylor
How to pre-filter dropdown via deluge when is a lookup from a different App?
Please help with why we get errors when querying a form in another app. In "APP2" we have some lookups that are from "APP1" (GREAT that Zoho can do this! :-) In APP2, for the lookup APP1 --> Property, there are a lot of records, and we'd like to pre-filter this lookup, via a "choose_state" dropdown for selecting a single State, and an OnUserInput script that queries the records by that state and sets the UI dropdown. (We've done these before and have no trouble with the details. But never "across
Reports
How do I make the records in a report that I share with users not editable by them?
Send email from a fileld
Hello, I'd like to know how can I send a mail from a fileld in a different form. I have one form to customers register and another form to sales. My ideia is send a mail each new entry on sales form. Thanks a lot! Iedo Brazil
Adding text fields to choices in checkboxes
If I have a Field with check box choices, can I edit the choices so there is another field? For example, if the check box choice is "other" can I add a field for someone to write in what their other option is? Similarly, if someone checks the check box "Food" how would I create a text field that allows them to type in information about that food specifically and elaborate
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
Next Page