picklist criteria
hi folks, i am trying to add a date criteria to my picklist however i am not quite sure how can it be done. the scenario is i only want the list on form B to show result that match the current input date on form A, so i put something like this in the criteria Date_field == input.Date_field but obviously this was not allowed, hope you guys can help. thanks!
Help with code please
In the following code, Why wont null stay as Null with a capital N when I change it and why wont nacm hide itself when I delete the Mobile field. The url if you want to see in action is https://creator.zoho.com/mrcomputer/mrcomputer/#Form:Job if (input.Mobile != input.Mobile.getAlphaNumeric()) { input.Mobile = input.Mobile.getAlphaNumeric(); } if ((input.Mobile).length() = 11) { show Type_of_text; show RFC_text; show Send_RFC_email; show Customer_contact; show Time_of_contact;
using this </br> in script submits it as text not a next line
Hi we have </br> set in a 'on edit' 'on success' script and it is submitting the the </br> as text instead of next line. I have also tried "</ br>" and "<br />"
Currency symbol (€ - Euro) not showing properly in HTML view
I have to put some € - Euro symbol in HTML view. It was working pretty well but now it shows as : € What can I do to solve that ? Thanks Pascal Veilleux
Subform and Picklist
Hello I have a Subform related to a main form and I want to retrieve information based a third form , I wrote the code below and if a test that from the subform itself this is working, however when I test from the Main Form containing the subform and click on add row and then when I click on Nacionalidad field which is a lookup field trying to reduce the numbers of occurrence the picklist candidato its not working, why is that?, which are the differences testing the subform isolated like a form
Quick Fast Application
Hi, I cannot believe that in the past three hours, I nearly completed an entire platform aimed for the Small and Mid-sized Business (SMB!) I'm anxious to release the product into the marketplace. I'm looking to include future versions of the application into our embedded designs. This turned out to be a fantastic solution! I would like to see Logo Branding available in all versions; the Zoho Corp copyright is already showing in the footer. I would also like to see that copyright link converted
Very much looking forward to it possible to convert the Deluge to android and ios code...
Hi ZC team Very much looking forward to it possible to convert the Deluge to android and ios code services for mobile devices, if possible, will greatly enhance the developer's participation and bring to ZC broaderrange of applications.. Thanks Stanley guo 2011-11-24
Files hosting overpriced... Files hosting should be free.
One should be able to have one's business in the same place. I need a way to have all of my files (like free email services have) in the same place. Right know you'll charge me for every byte of data. It's not affordable, is a mess! Files in my PC and files in ZOHO. I can't afford your file hosting pricing. Is too expensive. A small business can have huge amounts of data, like real estate business, pictures, contracts, legal documents. I need to get organized and zoho is not woking for I cant afford
Display uploaded image in exported pdf
I'm trying to export a pdf that displays an image that was uploaded. When I view the html view online, I can see the images. BUT, when I export the view to the pdf, the image disappears. Do I need to reference the image differently when export it in a pdf? Here is my reference to it: <img src="http://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=rec.Image%>&sharedBy=<%=zoho.adminuser%>&appLinkName=skypro&viewLinkName=Employees_View">
Ability to Add Record to a form in a private application as a shared user through API
Hello, I know in your REST API webpage (http://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html) you state that "Only the owner of the application can add a record to a private Form." but it is also stated that "Any user with an API Key, Ticket and share permission can add a record to a shared Form." I want to ask if its possible for a user, who is not the owner of the application, to add records to a form, in a private application, it has a share permission to? (maybe i'm a little
Fixing chart scale in Creator reports?
Is it possible to inhibit the auto-scaling of the Y axis of charts in Zoho Creator reports? It's really annoying that it rescales when filters are changed as you don't see the relative changes if the chart compensates. If I know the range is 0-5 then I would like to fix the scale at that. Have I missed it, or is this a feature request? regards Simon
Don't want website visitors to edit records
I have set permissions but have not checked edit record. but in my data view (list) I am still seeing bulk edit still available. View OK. Not edit record.
View Criteria error
Hi, I have a form with 2 views, each trying to set a certain criteria to display a set of data. one of the views works fine with the criteria, however, another view always return this error when i set the criteria, no matter in script or ide mode. here is the error msg that come up when i tried to save the script Error modifying the page The following column names are duplicated in this table [t_882922000000021615.Order_Loca_882922000000021617] the code i put are as follow [location == "Ipoh"]
Fetch records based on a form date field then update the collected records
Hi I have a form with a date field so i fetch a range of dates like this rangetocancel = Hospital_Rooms [(Date1 >= anycancel.Admission_Date && Date1 <= anycancel.Discharge_Date)]; seems to work as the collection holds 4 records and there are 4 dates from admission to discharge Then i want to update another field in the same form rangetocancel.room1 = "empty"; BUT it only seems to modify the first date Admission Date not the date range from Admission to Discharge any ideas ?
Relationships between Forms
Can data from a Field "Event Date" entered in FORM A be simultaneously entered in Field "Event Date"in FORM B of the same application? I can get the data in the look-up box on FORM B but that isnt much help.
Custom Filters for a view based on tableA
Hello all, Is it possible to generate a set of custom filters for a view based on the values from a separate table (TABLE A)? TABLE A is used by several forms in my application, and if I only have to update one table, instead of this table, and filters it would be much easier. Jason Rapp
Please help with variable please and show how clever you are.
Hi, Simple scenario... Form A Form B If you run form A an alert comes up saying "You have run form A" If you open form A from form B, I want the alert to say "You run form A from form B" In simple terms the code should be When in form A make a variable called, lets say, xxa=1 and carry it over to form B when in form B say (if xxa=1 then alert "You run form A from form B" else alert "You have run form A") Could one of you clever people show me the correct script for this problem Thanks in advance
How to count records that meet criteria and show in HTML View?
I have an HTML view that acts as a home page for an app. On it, I want to show some usage metrics for the app: - # Available Items - # Expired Items - # Items Added in last 30 days from today Example: "43 Available Items 16 Expired Items 10 Added in Last 30 Days" How can I count these records On Load and display them in the HTML View? Will this slow the view down as more records are added to the app?
Support Named Calendars for iCal Feeds
ref: https://help.zoho.com/portal/en/community/topic/ical-feeds-11-11-2011 ref: https://help.zoho.com/portal/en/community/topic/new-zc-variables-for-the-ical-feed Please add a new user-definable variable for constructing an ical url that enables the definition of a calendar's name. Currently an ical's feed value for X-WR-CALNAME = the view the feed comes from. This is very limiting in the case of generating multiple ical urls from the same view. In the case of established ical feeds from ZOHO Creator,
Email Notification question
Hi, I have a couple of question regarding the email notification 1. Is it not possible to include formdata in the message for the email notification during On-delete - On success event? 2. I wanted to custom display the login name for the from address, here is what i put but it seem not successful "zoho.loginuser<" + zoho.loginuserid + ">" is it possible to put the display name associate with the user name of the login user id? 3. How do we display some of the input field in the subject header
Dark PDF Background
When I export a nested HTML view the background of the PDF is dark like the one below. The HTML view has a white background.
Invoice integration - BillingState/City in invoice function and createEstimate
Is there any way to specify Billing State & City by invoice function ? I referred to the help page and found that I can specify "BillingAddress", but there weren't BillingState or BillingCity. Without these, we need to combine all the address values into "BillingAddress" but it will cause problems when we retrieve those data in templates etc. Also, I want to create estimate in the same way to createinvoice(). Is there any function to create estimate such as createestimate()? If not, will it be supported
Formula field not resolving in reports
I am having problems getting a formula field to work in reports. The formula is to get the season of birth from a DOB field: if((DOB.getMonth() < 3),"Winter",if((DOB.getMonth() < 6),"Spring",if((DOB.getMonth() < 9),"Summer",if((DOB.getMonth() < 12),"Autumn","Winter")))) It works fine in the list, but when I try to report using a pie chart it reports "No data Available" and the legend has 1 item "Unknown". Is this a known issue, or am I doing something wrong?
How do i limit the number of times someone can submit a specific answer.
I have created a basic form with numerous questions. The selection for answers are all the same: Do not use that feature of the product Not important Important Very important How do i limit how many times they can select Very Important? They should only be able to select this 10 times. Thanks!
3 user defined filters, and an automatic filter used to populate multiple fields.
I already have a support ticket on this particular issue, but I thought some other developers may find the information useful if a solution is found. I wish to have multiple fields in my Pulser_Report form. 1. I will need nine pairs of numeric fields that will be named “Run_1_Total_Hours_Below_Rotary” and “Run_1_Total_Circulating_Hours”, “Run_2_Total_Hours_Below_Rotary” and “Run_2_Total_Circulating_Hours”…….. 2. Every pair of fields will be hidden on form load. 3. The operator will
Summation of column in a form field, (NOT IN A VIEW)
Hello all, I am trying to auto populate the field Total_Hours_Below_Rotary in my Pulser_Reports form from the Service_Hours_Below_Rotary in the form Lifetime_Hours. The below code is returning the first value entered in the Service_Hours_Below_Rotary column. What I need to display is the SUM of all entries in the , not just the first entry Service_Hours_Below_Rotary column that match Job_Number, Description,and Serial_Number. for each value in Lifetime_Hours [((Job_Number == input.Job_Number &&
Urgent! need your help that want to make a band diagram of navigation bar in ZC from
Hi Ruben/Akash/Latha I want to make a band diagram of navigation bar in ZC form. I would like to embed an image form in the html page, when I click a picture, the picture links to a FORM or VIEW embedded a iframe in the same html page. I know that if not the picture form can be done, I tried the following methods: In the note field to insert pictures, will add a link to this picture, but did not find the link to open the target in no iframe. Already get a very long time can not be achieved,
Unable to get functional URL to work
I have a application with a View and which to use a functional url to access the view and set the criteria. This seems very streight forward enough accordsing to the documentation, but although my view does display it completly ignores my criteria setting and defaults to displaying all the records. Here is a sample of the url I am construction to limited views to client A https://creator.zoho.com/appowner/appname/#View:View_Name?Client=Client A This format will display the view, however it displays
Picklist from same form?
Hello, I have a contact form where each contact has a recruiter, and each contact can be a recruiter. I want to have a field 'Recruiter' in the contact form, which tracks the recruiter of each contact. I would like the recruiter field to be a pick list of all the contacts. Thus the picklist 'Recruiter' on form 'Contact' refers to the 'Name' field also on form 'Contact' Is this possible? If not, can you see a workaround? Thanks, Kenny
Is it possible to "wrap text" and center row values in pivot tables?
I would like for the header data in pivot table columns to "wrap" with the size of the column like in excel spreadsheets and for the data to be centered. That way horizontal scrolling is at a minimum. Is it possible? Thanks.
What script should I use to open a view with the same criteria?
I have a view with a custom function. the function opens an edit window on click and when the edit is committed it returns the user to the view with the edits implemented. The script that returns the user to the main view is: openUrl("#View:Tasks", "same window"); However, when a user selects a filter to narrow their view and then uses the custom function, the user is returned to the view WITHOUT the previously selected filter. Is there a way to change this script to include the previously selected
database multiple vendors
I want my vendors to input their products in their individual online catalogs. Do each and everyone of them have to be a paid for user? Craig
Help with sub-form please
Hi, I have a sub-form called Status_Board which I insert into my main job form. I have 1 question and 1 problem I could do with some help with 1. Is this the best way to achieve a job status board? 2. In the On Add Row for the sub-form, I have the code 'Status_Board.Report_time = zoho.currenttime;' which always works fine the first time, however, when you add the 2nd, 3rd, 4th, 5th etc row the 'Status_Board.Report_time = zoho.currenttime;' code does strange things. Sometimes it leaves the time field
Publish a counter on the webpage after the form is completed?
I'm using a form as a way of collecting online pledges towards a goal. --#1 -- Is there a way to post the number of people that complete the form to a webpage? --#2 -- Is there a way to make this editable (meaning we collect pledges at events too and need to update the numbers manually as well. Thanks in advance, I like you all.
return a list in a multi-line field
I'm trying to fetch and return a list into a multi-line field, but can't figure out the script. Select a region (radio button) fetch a list of records = region (which I can already do) Return list from the records that = region in a multi-line field (rather than a drop down lookup) so they are easy to see I don't need the list to be selectable, but rather are just for reference.
Creator links not working in FF8
After upgrading to FF8, links in Creator projects are not working properly. For example, when the link for a pdf "Tech_Notes.pdf" is selected, FF8 does not know what to do with it. Response: You have chosen to open DownloadFile.do which is a Adobe Acrobat 7.0 Document (-1 bytes) from: https://creatorexport.zoho.com ===== this same error occurs for *.doc, *.docx files (i.e., the exporter thinks the link is pointing to an Adobe doc) since this is the "filename" for both *.docx and *.pdf files, it is
Insert into record lookup with no value selected causes on success error
Hi Basically i am copying a record and inserting it with a few new fields Problem... any lookup fields from the original record which have no value -select- are causing an on success error If i select a value the selected value gets inserted any suggestions ? Thanks
I can't install any application in Zoho creator from marketplace
I can't install any application in Zoho creator from marketplace. I logged in as :integration1@oscillosoft.com.au, which is a free user. When I want to install an application from Zoho Creator Marketplace, it showed an error message. the message is : Stack overflow at line:10130 Help me if have any solution.
Data in my reports does not match the data in my table views
I have created several reports using the Reports tab in Creator based on 2 different tables in my database. But the data in my reports do not match the data in my tables. I used to be able to "fix" this by going to "More actions/ Regenerate" but now when I do that, I get a message that says you cannot regenerate my reports. (The problem is not isolated to a particular report or a particular table view; it seems to be universal.) App is at: http://creator.zoho.com/kellyanderson/bd, and-although
Referencing Subform Data From Another Form
I have a form called Stores_info. Stores contains a field called Store_ID that is unique for each store. The Stores form contains a subform called Zip_Codes_Served, and the subform consists of one field called Served_Zip_Code. For example, Store_ID #1 serves zip codes 10001, 10002, and 10003. Thus three rows in the Zip_Codes_Served subform for Store_ID #1, with the one of the rows containing Served_Zip_Code = 10001, another containing Served_Zip_Code = 10002, and the third containing Served_Zip_Code
Next Page