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 Functional URLs with iCal
Note: I had originally posted this as a question, but found the answer and deleted the forum post. I just discovered that one can use a single events-based database to create multiple ical feeds. In the past, I just created multiple new views of the database and then drafted the ical urls. The more elegant way is to use the functionality-based url criteria to filter the view, then draft the ical url. For example, in my event database, I have these fields: EVENT_SUBJECT, EVENT_ORG, EVENT_BODY, EVENT_START,
What video tutorials would you be interested on?
Hello everyone. Just made a video on how to mass update your database in zoho creator. You can review the posting here. http://www.creatorscripts.com/blogs/post/How-to-Mass-Update-your-database-in-Zoho-Creator/ but i am interested in finding out what other needs are out there to plan my next video tutorial. If you can comment on the post or drop me a note would be greatly appreciated. Francisco Riojas Creator Scripts Smart Software For Maverick Entrepreneurs www.creatorscripts.com
Apps missing from Personal Apps list
In the past 5 years or so, my company created a number of Apps. With some technology and staffing changes, our paid account lapsed for a few months. I just reactivated the account with a new credit card and now a number of the Apps are missing. Most importantly, I need the Diagnostic Form app we created. I left a voicemail for support yesterday morning and haven't heard anything back-- very disappointed with customer service.
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="
USERS CANNOT ATTACH FILES
Since this morning my users cannot attach files. We upload it on subforms, the file loads to 100% and the form hangs up "Wating for Zoho" and it does not advance We have a form with subforms, and in these subforms there are file attachments. Users cannot attach files. WHY DO YOU DAMAGE STUFF THAT IS WORKING??????? FOR NO REASON IT STOPPED THIS MORNING - THIS IS GETTING TOO FREQUENT
Creator Workspace renaming/creation
How do I rename a workspace within Creator? Alternatively, how can I make a new workspace and move my application there?
Change value of HTML page variable with function
Essentially I want to declare a variable in an html page then call a function that will change the value of that variable. Is it possible?
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
How to manage the "Approve Lead" list
I have a problem since my Webforms return a new Lead record which quite often is a DUPLICATE. 1. If I go to Lead/Lead Tools/Approve Lead/Duplicate Lead this shows me a list of Duplicates that need approving but at present I have 1500 records and I have no means of SEARCHING or FILTERING this list to see what does it contain. Any ideas how to manage such a list 2. Is there a way of including Unapproved Leads in my general CRM SEARCH? 3. Is there a way of adding fields to be shown on the Duplicates
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
Backup Schedule
Hi I'm trying to set backup frequency as weekly in Backup apps section in the setup. When i click "Take a new backup" there is only one field "right away" why is no other fields there ?
Form disappeared
Hello. I was editing another form name and reports name and now the form " Add ICD procedure" has disappeared in view mode, but in edit mode i still see all fields and codes.What's wrong i do ? Please help me. Account name zoho_ill Application : My First Application ill@gmx.com Thanks.
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
Customer Portal (New User? Sign Up)
The new user sign-up feature does not send an email to the user upon filling out the form and signing up to complete the registration. Why would this be?
Google Chrome Timer plug-in
Hello Zoho / Community, Found this post about a really helpful tool in Invoice and books. Is there any plan to include it in Creator ? Kind regards, Alfredo Hire an Expert Certified Solution Provider Zoho Creator Certified Developer Servicios Comerciales CASE SA / Certified Solution Provider casemx@sccase.com.mx ******************************************************************************** saranya.r.. Ease your time tracking in Zoho Invoice, with the all new Google Chrome extension in Zoho Invoice • Announcements • 2
Simplified input of the DATE -TIME field
I am using the the Date-Time fileld in my application because it facilitate date and time calculation. But on the other hand the users are complaining about the time being not user freindely or entering wrong timing is recurent. How can I simplified the look and feel of the time entry section ? Something like the date in a separated field and the hours in a dropdown field would be workable for me. But always keeping the same single date-time field? Thanks
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
In report criteria and custom filters: Support for <fieldname> on the *right* side of the criteria
Customer Support confirmed today that *only static values* are available on the right side of the criteria - whether via the UI or if edited directly in the report Definition. ie, <fieldname> <comparator> <static value> . So please add support for <fieldname> <comparator> <fieldname> . Examples: Record_Owner != Added_User Project_Manager == Project_Owner 2015_Sales < 2014_Sales We are aware that as a workaround, for each query needed, can have a dedicated field, filled via formula or deluge, that
Error when attaching files
Since this morning, any user that tries to attach a file to my forms is kicked out of the application. Can you pls do something? Amazing your capacity to create problems out of nothing. My Zoho User ID : 26676849 application cjuridico Raul
Tip: How to work around issues of a Lookup field when it's definition includes appended child fields
When using the very nice feature, in a Lookup field's definition, of appending child attributes, such as Property_Name + ", " + City + ", " + State The result in the dropdown is a NICE combination display that really helps the user identify the correct choice. And, the appended fields are even included in the search-as-you-type. However, the result on Reports is not necessarily good, because that combination is always shown as the field's value. (Or if you use field.name it is not clickable to
Reports
How do I make the records in a report that I share with users not editable by them?
search open url new window and headers
I have created a search form using a stateless form with the following on click: openUrl("https://creator.zoho.com/<myapp>/customer-support/view-perma/Customer_Report/Customer_Name=" + input.Search_Customer, "new window"); Three questions please: This works ok if same window is used. Using new window gives no result - how do I overcome? When I use same window and I get the Customer Report results there are no headers (i.e. dashboard tabs) and I need to use the back button on the browser. How do I
How to reload a page with deluge
Dear all, I have an HTML page which consists of a form (embed form). This form has a lookup field. I would like when I choose something in the lookup field then to reload all the page. Is it possible to do that? If yes, what can I write in the on user input of the lookup? I found that I can use the Navigational URLs. But I do not know if I can use the #Script:page.refresh Furthermore with the usage of reload; in the on user input it reloads only the form
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
My first application in zoho.creator
Hello. I downloaded mail-merge-contacts application but i can't edit this in my control panel. Why ? I need application like this ( https://creator.zoho.com/public/showAppInfo?ownername=fmriorum&callbackUrl=mail-merge ) to realize that idea: User fills out the form and then script produce specific letter with specific blank from form like this and this file we can download in .pdf or .doc. Thanks !
Current month in Report-Pivot-Chart - filter on the current month
HI, let assume I have a table with the following fields: Date (date); Quantity (integer); Should be possible to create a bar graph with: on axis x the date; on axis y the sum of quantity for that date; a filter on the current month? tks, pippo
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.
Select from lookup only entries associated with previous lookup
I have a two lookup fields in my Projects form. The first is Customer, the second Customer Contact (Customer Contact is a subform of Customer). In the form definition I have this code: Customer ( type = picklist values = Customer.ID displayformat = [ Customer_Name ] allow new entries = true [ displayname = "" ] sortorder = ascending searchable = true width =
New added currency NIO is misspelled only in help pages
For the sake of accuracy of the help pages , it's Nicaraguan Cordoba , NOT "Nicaraguan Cordobo..." Thanks Alfredo Hire an Expert Certified Solution Provider Zoho Creator Certified Developer Servicios Comerciales CASE SA / Certified Solution Provider casemx@sccase.com.mx
Cannot create new in Admin Panel
hi Zoho, Now, i created successfully 17 email accounts. But now, cannot, it show Sorry , we are unable to process your request, please contact support@zohomail.com when creating new email account
One payment for multi zoho services
Hello I don't know if there is way to pay one time for different services , I have to pay for Books in different area than Creator than Email ..etc. need one page to pay multi services ! Thanks
Cannot view images
Hello, We have lost our images- just get this: <img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/1434629830485_Screen_shot_2015-06-12_at_10.30.34_AM.png&sharedBy=rachelogg&fieldLinkName=My_Pic'/> Please let me know asap, thank you
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
Next Page