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
duplicates
I'm sure it has been asked and answered, but I missed it. How do I find duplicates, based upon one column (name, in this case). Before I found ZOHO, I had my data in several different services, and when they proved unacceptible, had to move it. Each time I moved it, errors such as duplicates crept in. My best day in a long time was to find ZOHO. THANKS. Jim West
updating records in grid view
Hi, for 2 days now, In grid view, I only can updated six records at a time. Anything more than 6, it tries to "save records" for along time unsuccessfully. please help, i need to update 100s of records everyday. i cant do it in an increment of six. it will take the whole day thanks
Hide field from others does not work in a permalink?
Hide field from others does not work in a permalink? In a form oppened from a permalink all fields are visible? is there a way to hide a field here? Cheers Luis
How do I compare two text fields from two forms?
I have written\copied this code below, however, it isn't working. I wonder if it had to do with the fact that they are text fields. if (count (Mrs_Weaver_s_Question_of_the_Day [Question_of_the_Day == input.Question] ) == 0) alert "Question of the Day was not listed. Try again later"; cancel submit; Please advise.
Aggregate values from Multi-select field populated with query-string during function call?
I have a function that works together with a stateless form: void ReverseDeposit(Payment SelectedDepositGroup) { querystring = ""; for each Payment in SelectedDepositGroup { querystring = querystring + "recIDlist=" + Payment.ID + "&"; } openUrl("#Form:ReverseDepositValue?" + querystring, "popup window", "width=600"); } The stateless form has a Multi-select field that gathers the IDs of the selected records of the Payment form in a view. How can I aggregate the value of
reference a field value as part a field name
BACKGROUND INFO: In a form named Payment I have fields with the word Note in their names; one for each month, e.g. JanNote, FebNote, MarNote, etc. Using a function and stateless form I will have a Custom Action allowing the bulk change of a selected Month's Note field in many records. The stateless form has a dropdown field named StatelessMonth with a selection menu of the months, Jan, Feb, Mar, etc., and a single line field named StatelessNote. Upon Submit I want a selected Note field in the Payment
I have a form in zoho creator when I submit the form the data should be saved in salesforce Lead. Is it possible in zoho creator?
Hi, I have a form in zoho creator when I submit the form the data should be saved in salesforce Lead. Is it possible in zoho creator? Thank you
How to get the left x characters of a field?
I am trying to get the first 3 characters of a given field to use in a formula for a 2nd field. I do not see a formula/deluge script that allows for what in Excel would be Left(field, # characters). Can anyone point me in the right direction? For example, I have a Client Name field in a form called Clients. I want to pull the first 3 characters of the Client Name into a 2nd field called Client ID.
Problem with Free-flow script view in IE
I'm using IE 9.08 and just today have had a problem with the free-flow script view. The font used to render the script (and the numbers to the left of the script) make the script unreadable -- they are all symbols. When I view the script in script builder, all is fine. This problem arises for both views and forms. The problem just appeared today. It does not show up in Chrome. As I said, the problem doesn't appear in the ScriptBilder, just in the free-flow script. What font is being used
Please Reply this Can I use My own Domain Name
Hi Team Can I use my own Domain name for eg:- Application Link is http://creator.zoho.com/l3admin/namexYZ/ Is it possible to use my own domain eg: http://mydomain.com/xYZ/ instead of http://creator.zoho.com Please reply this Smitha
Are there dynamic functionality based URLs for ZOHO Reports?
I love the Reports feature added to Creator that integrates ZOHO Reports. I noticed that the URL parameters functionality doesn't seem to work for reports. e.g. http://<your app URL>/#View:<view name>?<field name>=<field name value> The above allows the dynamic filtering of the view based on field values. It doesn't seem to work, however, for #Report:<report name>. Which forces the creation of multiple similar reports to handle various filter criteria (e.g. Totals this Month, Totals last Month).
Zoho Creator printing
When in the Summary View, can I have a page break separating each record? So when I print the Summary View, I got one record on each page. Thanks.
Hide/Show Function Not Working
I have implemented the simple hide/show function on my form to achieve a simple outcome. I want to hide fieldA on load so I have added to the On Load Diluge Editor hide fieldA; I want to show fieldA when fieldB which is a radio box has the option "Yes" selected. I have therefore add to fieldA the following on user input script: if (input.fieldB == "Yes") { show fieldA; } else { hide fieldA; } For the life of me I can not get the simple function to work. Very frustrating. The form doesn't
Published to a client but he does not see the data
Hi, I published an application to a client but forgot to check "with data". I then republished but my client still does not see any data. I did not see an "unpublish" option. Any ideas what I need to do so my client will see the data. Thanks, Alon
Next Page