Alternating table row colors in HTML View?
Hello, I could use some help. I have an HTML view of meetings searched by country and city. Some of the queries will return dozens of records, and the table being all one color makes viewing the records confusing. I would like to alternate the colors of the even and odd table rows but I can't find anything to help me in doing this. I have found this link where the rows are exactly as I would like mine to be: https://creator.zoho.com/sharipriya/testing-criteria/view-embed/Testing_View/zc_HdrClr=green&zc_BdrClr=lime
Display CRM data as text
I have selected a sales order from the CRM in custom app using Creator and I want to display the details of the products ordered in the sales order as text or ideally each item as a checkbox. Thoughts?
Where form results open
My form results are opening on top of the form itself and I am not taken to the next URL. My form is at http://jaxareagolfassn.com/Championships/2012/ClubChampionship/2012ClubChampEntryForm.html but I want the user to be taken to http://jaxareagolfassn.com/Championships/2012/ClubChampionship/ClubChampReservations.htm. What am I doing wrong? Thanks, Barney
Need help with one on one relationship
I have a form PROPERTIES with the fields: Property ID, Address, Buy Price, Tax Assessment, Estimated Sale Price. My acquisition department fills this in. I have a form TAX APPEAL with the fields: Property ID, Current tax, New tax, Taxable sqft. My tax appeal department fills this in, however they need to see the Address, Tax Assessment and Estimated Sale Price in order to analyze the property. I've created a lookup on the TAX APPEAL form so that it is linked to the Property ID on the property form.
function driven link in HTML view
I have a HTML view that i have created to show me all the reports completed for the day prior, I want to be able to add a link in the HTML view that will allow me to update the status of a field in the particular record. Example: "Approved (button)" is clicked > Approval field on the form is then updated to "Approved" What I want to do with this is have in the HTML VIEW (not a zoho list view) the ability to quickly approve a large amount of records from a single screen by clicking a button. I'm not
view criteria for radio button
hi in my app there is two areas where i use radio buttons 1 area (Sale_Result)- many radiobuttons, 2 area (zakaz_vypolnen) - only one radiobutton (to deny uncheck it, if already checked, for managers) how can i make? 1-st view with checked radio in 1 area and unchecked in 2 area 2-nd view with checked radio in 1 area and checked in 2 area === in 2-nd i just use criteria ((zakaz_vypolnen == "да")) and it is enough in 1-st i use - intitial value =1 for unchecked radio in 2 area - criteria ((zakaz_vypolnen.contains("1"))
Need 3 scripts added (paid job)
I need someone who is knowledgeable in adding scripts to a Zoho Creator form to add these criteria to my form. Doesn't allow duplicate entries. Can't seem to do this based on the URL, which is what I need. Records need to automatically drop off (be deleted) once they expire, based on a date. Person submitting must put proper title to the URL or it will not submit. Please let me know if anyone out there an edit my form to do these things. Wendy
Help with API call via PHP curl
I am trying to write a php application on our website that retrieves our list of members from the creator database we have. Unfortunately the info and descriptions I've found so far are rather poor or outdated, so I am working somewhat blind in making this work even in the most recent examples I've emulated. I do successfully retrieve a ticket, and my login, password, apikey are obscured for obvious reasons. My goal is to read records from a view "PHCP_Members_Know_Location" I've already created
Generating a Sports League Season Schedule
Hello, I've been putting together a sports scheduling application for a commercial league (teams are scheduled based upon their venue and time criteria provided to us upon registration) - It works well enough as is, where the time slots are uploaded from a spreadsheet and the teams that are available for the place/time are the choice for "Team 1" and the choice for the opponent "Team 2" is at the same level of playing ability as the first team. No one team can exceed 8 games played, and no match
Summing subform
Hi, I have a subform where I add contacts and it sums the number of them i add in the subform, with the next formula temptotalB = 0; for each record in contactos1 { record.Sub_Total = record.contagem2; temptotalB = (temptotalB + record.Sub_Total); } input.total3 = temptotalB; the columns of the subform are contagem2 Tipo de Contacto Data de Contacto Observações: Sub_Total How can i do this for one condition, for example if a contact doesn´t
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
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
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?
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.
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 *
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
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 =
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.
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;
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
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
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
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.
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
View criteria for last 168 hours/week.
What is the result of the following criteria in a view? Assume today is Thursday at 8:30pm. Will it show only records added in the last 168 hours (since last Thursday at 8:30pm)? Will it show only records added since one minute past midnight last Thursday morning? Will it show only records added since one minute past midnight last Friday morning? Added_Time >= (zoho.currenttime - '1W:0D:0H:0M:0S') Herb Wexler
Need Help for PHP Return Page
Hi I have creator application stateless form, and if i submit the button in my form , then it will goes to my PHP page which was in my server, then if i enter the data in my PHP form , then the page will return back to my Creator application form. I have the below error when i redirecting the page. " An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home " Let me know How to solve this issue. Thanks
Need a developer for Zoho Creator for CRM
I have a client currently using Zoho CRM with Google Apps who would like to have a custom module build with creator for use as an add-on with Zoho CRM. They would like to have a rental equipment module that would integrate with CRM and Quickbooks add-on. Anyone up for the challenge?
Reminder emails to attendees
I see the exciting new ability to add events from Creator to Calendar. https://help.creator.zoho.com/Create-an-Event-in-Zoho-Calendar.html However, I'd like to create events so that attendees automatically get reminder emails at a specific period of time (perhaps 2 days) before the event occurs. How would I do that? Also, is it possible to customize the reminder emails in any way? Also, once I create an event, how would I update or delete it using Creator? And if an attendee declines her attendance,
Anyone know the standard form time out?
Hi folks Can anyone tell me how long it is before a Zoho Creator form assumes you have wandered away and logs you out? I lost a lot of data at a demo the other day because of this (mucho embarrassing!). Also, does anyone know if there's a place you can tweak this setting??
Hide Subform Field based on Group Membership
Hi Is it possible to hide the subform field of a main form conditionally based on whether the logged in user is a member of a certain group? T
Will not import data from google doc or allow me to cut and paste that data
Hi - I have successfully been able to create a new form previously by importing data from a spreadsheet. Tonight when I am trying this I select the document I want - press next and it says loading and then does nothing. Same thing when I try and cut and paste info as an alternative - select paste and no entry is made. Thanks Kendra
Access all products from PurchaseOrders module
Hi, Is there a way to access Product_Details data in PurchaseOrders module via Zoho creator? if there is, could you please guide me as to how to go about it? thanks.
Rich text editor button icon positioning
Lately in Chrome, the RTE is displaying button icons in strange places. Cheers, John Whitney ZOHO Creator Developer
Based on 1st form data need to do some changes in 2nd form
Hi, Based on 1st form data need to do some changes in 2nd form.For example,I have two forms,lets say one is company form & other is employee form.In company form i have one SingleLine control & Checkboxes.So in Employee form i need to show/Hide the data based on Company form textbox & Checkbox selection. Please help me out of this.
Next Page