Schedule - Pdf using wrong page orientation
Hi - I created a couple of reports that look good when I exported as pdf. I set them up as landscape . The issue that I have is when I set up a schedule that distribute them via email. Pdfs are sent as portrait and they look odd. Does anybody know how to make Schedule use the correct page settings for pdfs? thanks
how to select more than one line in "lookup" field
how can i change this function so i can select more than one name? it will only let
Grouping members based on their age
Hi I have a list of members, where I have set up a calculated field that calculates the age base on the input of the year of birth. This gives me a list with different ages. However I would like to make a new calculated field that categorize, based on their age, the members into following categories, 0-29 30-39 40-49 50-59 60+ Any idea how this can be done in ZC Cheers DC
Customizing lookup dropdown contents display style.
I have a form to add records to a table. Part of this form is a lookup list displayed as a drop-down menu with data imported from a table of employees. I currently have it configured to show FirstName LastName - IDNumber. What I would like, is to add a column called PreferredName that is not required, that way, when we have someone that goes by a name other than how they are typically listed (Someone named Otto actually goes by Dale), it can be displayed as FirstName (PreferredName) LastName - IDNumber.
adding a "," format to numbers
we using the number field for "quantities", now can only display numbers with no separators like 20000 or 100000 or 3000000 this is difficult to read. we want to display like in excel 20,000 or 100,000 or 3,000,000 how to make this formatting with the comma character "," ? thanks!
Dependent fields are not updated when items from a multiselect field are removed
Hi, I have created a Multiselect field. I also have a formula field that derives it's value from the multiselect field. The formula field updates correctly when items are selected from the multiselect field. Unfortunately, when items are deselected from the multiselect field the formula field is not updated. This problem also occurs with other types of fields when I make them dependent on the multiselect field. Is this something that could be fixed? Thanks! Mike
going to a specific page
Is there a way to navigate thru an extensive list, by pages or views, instead of the "arrows". I am updating many records, and whenever I stop for the day, I must navigate by the arrows 20 times and more to get to the specific page of 200 records where I left off.
Lookup field - how do i sort the returned list?
i am using the Lookup field currently the data comes in, in the order it is inputed. how can i sort the data? i am a noobie and dont know how to script, so any answers, please keep very basic or documented well
any REFRESH button on page in zoho creator's app?
hi! there is some formulas inside my app in creator. and some calculation is fully done after saving entry in database ("save") how can i add some _refresh_button_ on app's page to make all internal calculations done before saving entry?
Important announcement about the new UI :
Since the introduction of the new UI for apps about 3 months ago, a lot of users have moved their apps to the new UI. Till date, 99.99% of the users have moved their apps to the new UI. For those who are in the old UI : All your apps will be moved to the new UI on Oct 15th, 2012. Thereafter, access to the old UI will not be available. If you would like to try the new UI now, please access any of your apps and click the link that says "Face-lift your apps with new UI" at the top. To know more about
Password-protect an application?
Hello, I am the admin on my account and I have two users (userA and userB). I also have two applications in development (appA and appB). How do I only allow userA to access appA and not appB and vice versa for userB? (What are the differences in the role of developer and user?)
Customize the height of the rows of the view
Html Hi I require a customized view of the high rows of the view inserted , to have more space on the bill, as well as the top of header. attached files
Percentage Sign in Zoho Creator Email
I am trying to insert a % sign symbol into a Zoho Creator email (e.g Tax Rate: 10.5 %) where the rate is a Zoho field. When I have tried to do this the email fails. Here;s the code I am using: ("Tax (" + propertyinfo.Tax_Rate + "%): $" + ((input.Tax.round(2)).toString()) If I take out the % sign it works fine. I have also tried using the ASCI hmtl (%) with the same results.
Sender ID of email submission
Hello, When adding a form entry via email is it possible to retrieve the sender's email address? I now hav e form with a ZC_Subject and a ZC_Content and that works. But it would be nice to be able to tell who had sent the email to the form Greetings, Rob
Link to Uploaded file in HTML view
How do I take an uploaded file from a form and make it a clickable link in an HTML view?
Multiplication problem
Hi Zoho users and team! Hi have some problem with a formula with deluge script (This script is used in a html view). Here is the code: <%wage = (currentJob.Time_allocated_to_Service_Partner_in_hour * hourly_wage1 * Category);%> And here is the error: Error in executing Long_job_description1 view script. Error. Error in executing Set Variable task. Unable to update template variable wage. Error evaluating NUMERIC expression : Error evaluating NUMERIC expression : Unable to perform the operation *
Find & Replace
Is there such a thing in Creator as a Find & Replace routine. Example: Find all occurrences of "abc" in Column "X" and replace found with "PDQ". I know how to search and find, but for something like the example, I must manually perform the change on individual records, as the Group Edit will make all the exact same and will erase any extra data.
test with pictures
I made some tests, containing a few pictures. Now, when my students make the test, they don't see the pictures anymore. What's going wrong?
ZC system crash
My customers can't get quotes, can't make bookings. We can not invoke functions because we now get script errors. Error mesaages appear such as "Error in executing IF rule" and "Error in executing ELSE block" or when a customer tries to make a quote they get "Error occured please contact application owner' Urgent attention required Mark Australia
Button on view form
Newby question...how do i add a button against each record to view that specific record detail in all records view not on the form view... ive seen it on some of the demo apps but cant seem to find how to do it? thanks for your help in advance, hope ive explained it ok.
Searching
Not getting a working answer to my previous question, I'll ask it in a different way. Is there a way to search for the first letter in a column and get it, plus all that follow ? In other words, how can I search for all the "F"'s in a last name field and get all the last names that begin with an "F". A simple search for just that letter ends up with any name with an "f" anywhere within it. Not just at the beginning.
Report Links Not Deleting
I created a report named test pull in my zoho creator application. I have since deleted the report, yet it is still showing the link on my shortcuts bar when I "access the application". This is understandably distarcting as I am concerned if / when I decide to upgrade to the pay for version that any reports I build and subsequently delete will remain as a choice and clutter my toolbar. Please help!!
pictures disappeared in tests
Ik heb een premium account. In juli maakte ik een aantal testen op, met afbeeldingen erin. Toen ik die test dan opvroeg, was alles OK; Nu in september, nu ik ze effectief wil gebruiken, merk ik dat de afbeeldingen verdwenen zijn. Wat is er mis?
zoho creator web form data create into sales force leads
Hi, I have read your post in forum you said You can use a Salesforce web to leads form, if you wish to use a Creator form you'll need to write a postUrl script in the on Success action that does an HTTP post to the Salesforce web to leads form url. Please also consult the Salesforce documentation on Web to Leads forms. My requirement also same as I have a form in Zoho creator when i submit the form the data should be saved in sales force Lead object. I have confusion with post URL script. In this
row or text coloring in list view
currently im using images for status but when I used another database i was able to color the whole row. I have see examples of zoho creator with alternating row colors and I'm wonder if that could be scripted with and if else if statement for each record of contains statement if (status == done) { currentrow.color = (255,0,0) } elseif (status == pending) { currentrow.color = (0,0,255) } else { }
Project guidance for Volunteer Scheduling
We'd like to create what should be a rather simple application - an online site for volunteers to signup for various available positions (for an annual fund raising cycling event). My stumbling block is how to limit the number of specific positions available to volunteers (e.g. there are 15 1pm-5pm food line workers...not 16). How do I structure the database to limit the number of specific positions available? It's not unlike students signing up for a limited number of seats in a class....the
Parent Look-up
I am trying to figure out how to pull other information into a form when 2 forms are linked together. My application is hard to explain but it would be the same way an invoice would work. When you select the name of the item you want to put on the invoice from the drop down list, the rest of the information from the record of the other form is pulled into the invoice. So for example you select the item drop-down list and you choose Battery for example, the cost of the battery is brought into
Updating Records
When Im creating a form if that form is already created instead of not allowing it to be made I just want it to be automatically updated and no new entry added, or delete the old form and add the new one but I can not figure out the script to do so. Any Help would be greatly appreciated
Concatenate a formula field
I am trying to concatenate multiple address fields and put into a formula field. I tried: field1 + field2 input.field1 + input.field2 Neither of them worked. Any ideas?
select all records in multi-select lookup
hello! i have several forms in relationships to one another: A. People = information about each person, including whether they receive newsletter. have a view called "newsletter recipients" with criteria set for just those who receive newsletter. B. Correspondence = letters from each person (bi-directional lookup to A. People) with custom response to letter to be merged into newsletter mailing, field indicating whether the custom response y/n has been merged into the mailing yet C. Newsletter =
Improve View Record Format
Take a look at this page https://creator.zoho.com/buzzap/ncsd/#View:Public_Post_Archive Then select to view a record. There are a number of issues with how the view looks Some of the records scroll horizontally off the page The column headers take up a huge amount of space: the view should scale to minimize the free space The printable view has the same problemsThanks, John Whitney
Auto-select foreign key for multiple forms
Let's say I was taking inventory of the types of pools and elevators a bunch of hotels have. I have 3 tables: Hotel, Pool, Elevator. 1 hotel can have 0 or many pools, and 0 or many elevators. I'd like the user to be able to select the hotel once, then have that selection be the foreign key for the Pool and Elevator, so they don't have to select the Hotel from a dropdown for each record created in the Pool or Elevator table. Is this possible?
How can I add a voting button - e.g., 'Like' button - to a record in a zoho creator view and/or form?
We wish to let users vote for features on the product development list to help us prioritize them.
Integrating CRM information into Creator
I would like to pull key information from a Lead in CRM and populate at Creator Form which i can then add more information. For example, I have a lead and i put basic information about the lead into the Lead module. Then if/when i want, i can create a Creator form called Lead Profile where i can go into much greater depth about that lead but store it outside of CRM so that i dont use up all of my custom fields in CRM. Say that Mary Smith inquires about getting some care for her Mom at home.
Can records be imported from a text file into a search?
I have a set of records in a text file that I want to find in my Zoho data base. I'd like to import those records into a search and then bulk edit the records. I cannot figure out how to import records into a search. It looks like I have to enter search criteria manually, one record at a time. Is there any way to import a set of records into a search? If so, how do I do this? Thanks.
Simple boolean stuck am i not seeing it right
Sorry maybe i am being slow here today for the following if i enter a or b or c they all go to the IF PART am i not saying if not a or b go into the IF PART if ((input.Single_Line_1 != "a") || (input.Single_Line_1 != "b")) { alert "IF PART"; cancel submit; } alert "NO IF PART"; cancel submit;
.Net C# APIs
Hi, Please tell me the steps need to be followed for inserting a record in my form created in ZOHO creator by your REST API. Please provide sample code in .Net C#. Thanks Gurpreet
importing from excel - single field with multiple options
Hi, I am exporting a database into Zoho Creator and I'm struggling with one of the fields. On the spreadsheet, one of my fields has multiple possible answers, for example each line represents a client and each client can have one or more specialisms which I want to be able to capture. At the moment, each word or phrase in this field is separated by a semi-colon on the excel spreadsheet. When I import, Zoho doesn't recognise each phrase as a separate entity. Is there any way of doing this? I want
Create one large form (exceeding the Zoho 47 field limit)
Hi, I am looking to create on large form with approx 160 fields. Basically a large table where a person inputs the findings of an audit. It's important that the results of this audit get collected in one form for consistency and reporting afterwards. Has anyone come across a way of doing this? I would love to hear your feedback if you know of a way. I've attached an example of this form. Many thanks, Eamonn
Lookup field entering the wrong record
Hey there! I just started using Zoho and am totally into it. Anyhow, I have a list of prisoners seeking penpals. The idea is that I have this form Pen-Pal Pairs that so I can associate the "free world" pen-pal with the incarcerated pen-pal, who is already listed in our database (links at top of page): http://www.blackandpink.org/prison-penpals/ I tried it a few times, and I find that the lookup is choosing a similarly named prisoner (ie Michael Young, not Christopher Young) even when I carefully
Next Page