I need to make my View (HTML) to open a view through the action of a url in html form with a parameter of a text field.
I need to make my View (HTML) to open a view through the action of a url in html formwith a parameter of a text field. The code is below: htmlpage Gerencia_Baixas () displayname = "Manages Low" content <%{%> <span style="FONT-SIZE: medium; "> <strong> Manager Low </ strong> </ span><br /> <br /> <form action="http://creator.zoho.com/bcrosman/gerenciador-de-dados-na-/view-perma/Baixa_de_Estoque_View/Vendedor=FirstName"> <span style="FONT-SIZE: small; "> <strong> Enter the Name of Seller: </ strong></ span>
RSS feed problems
I'm trying to create an RSS feed from a Zoho Creater spreadsheet, but it's not working. According to the W3D Feed Validation Service (http://validator.w3.org/feed/), the feed is invalid. And, the feed won't appear on my desired reader: http://feedostyle.com. The application is public. Here's what Zoho gives me as the feed: https://creatorexport.zoho.com/westdepere.se/data1/rss/data1_View/ Please advise.
Unexpected Behavior with Links to File Attachments
If I have encoded a link to a file attachment using html, the link only works if I also enable the field to be displayed in a view. For example, this works: But this fails: John M. Whitney
Creator "Reports" --- murky, hard to use, missing features... Ughh!
Woof! The so-called Creator "Reports" are the #1 worse designed module of Creator... period. How to use it is vague, confusing and murky at best. The inability to Sum a column at the bottom of a report (i.e. Grand Total) is missing, but there *is* some kind of strange "sum every entry" function that is visually confusing. And the so-called "preview" mode presents a narrow short view window, though the report is likely to contain several columns that need more view width in the preview. Strange
How can I provide alternate language versions of the labels in my public forms?
I want the user to be able to select language from a drop-down, and the form control labels and fixed text immediately change to the language-specific string I've provided. Thanks.
Hide Custom Actions on Permalink
I've noticed that if I provide a permalink that does not require a sign-in, people viewing the permalink can still see the custom action drop-down menu (when custom actions are present) and the custom action button if it is visible in the view. If a non-logged-in user selects a record and uses the custom action drop-down menu it actually carries out the action! I cannot find an option to hide the custom actions. If these cannot be hidden, it seems like a real bug and security issue. Please let me
On Add -> Validate issue!
What I am trying to do is the following: I have a form where people can register whether they are coming to the game or not... They have to fill in there name and they have to enter a date. Now I want to check if a user is already registered before submitting the form. Because duplicates are restricted. I use the following piece of code: if(count(Attendees[name == input.name]) > 0 && input.Date == '26-FEB-2011' || input.Date == '04-MAR-2011') { alert "You are already registered for this date."; }
Zoho Creator getURL hangs and does not return
Hi, I am trying to use getURL to integrate with a bulk SMS provider. The following URL (with actual password etc) works fine from a browser http://bulksms.mysmsmantra.com:8080/WebSMS/SMSAPI.jsp?username=xxx&password=yyy&sendername=Rentoys&mobileno=9199999999&message=Hello+World However when I use it with getUrl, the call hangs and never returns. I have tried passing headers (User-Agent etc) and I have tried simple and detailed response. But none of the options return. Is there any way to debug
IF statements and Email
Hi, im just having a issue with the below bit of code. Recipient=input.Email; Kaituna=false; Rangitaiki=false; Wairoa=false; Tongariro=false; Ohau_Channel=false; Hot_Pools=false; Pickups=false; if(input.Raft_Trips.contains("Kaituna River")) { if(!(input.Pickup.contains(""))) { sendmail [ from:zoho.adminuserid to:Recipient subject:"Booking Confirmation" message:(((((((((((((((("<div style="text-align: left; "> <div style="background-color:
Rearrange the fields in a column chart view
Hi, I'd like to know if is possible to rearrange the fields in the chart view. For example, I have a column chart with 3 columns: Ex, Cx and FO and I'd like to show the columns in these order: Cx, Ex and FO. Is it possible? Thx
Group Lookup Field List records
I am using the lookup field (Student Name) on a form that is based on another form that has multiple records for each student. Thus, I could have five records for the same Jon Smith student. In the lookup field it will list John Smith five times. How do I get the lookup field to group the like records so only one record for each student is displayed in the list?
embeded view open with filter
I am using embedded Creator forms for my site. I know how to add filters for a view and I know how to embed forms. My question is this: is there a way to open an embedded form view which allows you to pre-select a filter, but also allows you to select the other option of the filter while using the view. An example might be better: I have an application that tracks customers and their associated tickets. Tickets are either Active or Closed. From the main form, I would like to add a custom action
RSS feed problems
I'm trying to create an RSS feed from a Zoho Creater spreadsheet, but it's not working. According to the W3D Feed Validation Service (http://validator.w3.org/feed/), the feed is invalid. And, the feed won't appear on my desired reader: http://feedostyle.com. The application is public. Here's what Zoho gives me as the feed: https://creatorexport.zoho.com/westdepere.se/data1/rss/data1_View/ Please advise.
Help writing a deluge script to store variable based on date and frequency conditions?
Hi everyone, I have a form that tracks participants in a treatment program, and depending on what phase they're in would like to filter a view that shows which participants are scheduled to report in for the week. Phase 1 = every Thursday (every week), Phase 2 = Every 2nd and 4th Thursday (every two weeks), Phase III = Every 3rd Thursday (once a month) I was hoping to see if there's a way that I can create a formula to calculate who will be on calendar for the week, something that would result
Dynamically Change Initial Value in Lookup Table
I would like to display the current lookup field selection as the initial value for the next form data entry. As an example this would be useful if entering multiple time entries for an employee (selected from a lookup table of all employees). This initial value would continue to display until a new employee name was selected. Is there a way to do this with Deluge script?
How to send an email when a public user submits a form?
My app allows a public user to create a profile including their email address. How can I get the app to send a welcome email to that user? Sendmail seems to be prevented by the restrictions at https://help.creator.zoho.com/Send-mail.html. Thanks.
Automatically populate a field based on previous field's data?
Hi, I am wondering if it's possible to automatically populate a field based on the previous field's data? We are looking at creating a Library Check-in/out system for the students that come in and out of the library at our school. So for example, we would scan the student's id card and the id numbers would go into the Student ID field. Then we would like the student's name to then appear in the Student's Name field - the name would be based on what the id is. I'm assuming we would have to import
My forms not appearing in mobile.zoho.com
Hi, Not all of my forms are not appearing in mobile.zoho.com. Forms and views from one application appear correctly, but they don't from another. I built the other application yesterday, I built the new one today. Do I have to do something special to make them appear on mobile.zoho.com? Thanks!
Function not saving even though the code was not changed
When i try to save one of my functions ('ViewMatchingAssets') without having touched the code, it throws an error (a variable is supposedly not declared). The apps name is 'BMPM'. I have granted edit access to Zoho. Thanks for your help. Regards, Filip
Criteria Restriction is not working in Views
It appears that the criteria restriction option is not working for views. I have tried this across several applications and all give me the same error message: "Adding criteria failed. Please try after some time or refresh the page and try again." I have refreshed, closed my browser, and even tried using another browser, but nothing is working. Without this, I am unable to add criteria through the script builder or free flow scripting modes.
Can I capture a signature in a form on a mobile device?
Can I capture a signature on a form when using a Creator app on a iPhone? Maybe use a Rich Text Field? Suggestions?
Link to image in new window
After a user chooses a file to upload on a form and submits the form I wanted to create a url that would open a new window with that image in it. Is this possible to do?
Problems with user designations and script actions
I'm running into errors where i get proper results while creating and debugging forms with script while logged into my admin account, but testing the same pages with regular users don't work at all. any help would be appreciated, because if i can't count on the forms and script to work properly i will need to seek an alternative solution.
Serious problem with Views Criteria
This statemetn, entered via "advanced" criteria of a view, used to be accepted and is indeed used within two of my views (zoho.loginuser == CenterCode.UserName && SendTo == "Participant") Now I get the message Adding Criteria failed. Please try after some time or refresh the page and try again. and thi happens on new views I am defining BUT also on the ones where it used to work if I try to save them again !!! Please help as soon as possible. Thanks.
Field does not update for a certain record
I have a field (Overlapping_Search_Profiles) on a form (frmSearch_Profile) which for one record does not update when I do this: colSP.Overlapping_Search_Profiles = ""; and the record is part of the collection. I already checked if the record actually is included in the collection. Zoho has Edit Access. To reproduce do this: 1. In my app (bmpm) go to the section 'Admin' 2. Open the view 'Export View: Profiles' 3. Search for the records with 'aer' in the 'Player' column 4. Open one of the two records
Saving function without having made a change to it returns error
The following function was previously saved in Creator: string otherrecordmanipulations.CountEntityProfiles(string EName, string PName) { countNumber = count(frmSearch_Profile[((((Player_Entity.contains(input.EName) && Player.contains(input.PName)) && !Player.contains(input.PName + ":")) && Status == "Active") && Player_Status != "Passive")]); if (countNumber == 0) { return "none"; } else { return (countNumber).toString(); } } If I click 'Save Script'
Code comment not saved
In one of my scripts (on edit / on success) of the form frmSearch_Profile. I can not include a comment line ("// bla bla") above the line 'thisapp.TestFunc4(IDStr);'. Zoho Creator deletes it... Zoho has Edit Access. Regards, Filip
Number Conversion Function
I need to convert a Hex string to decimal. On doing a Google search for "Zoho hex to decimal" I found this function, apparently in Zoho Sheet: DECIMAL Returns a decimal number, given a text representation and its base radix. Syntax DECIMAL(text; radix) Syntax Description text is text representing a number with the base radix radix (an integer between 2 and 36). Any leading spaces and tabs are ignored. Letters, if any, may be upper or lower case. If radix is 16 (hexadecimal system), any leading 0x,
Marketplace - if you are not logged in you cannot search the marketplace
I happened to be browsing the marketplace today and was not logged in. I could not find a search box! The only option was to browse, which is highly inefficient for hundreds of apps. If you login, you see a search box. Please make this search box available to non-logged in users! Also, when I click the "Post Your Requirement" button, it did not work! In fact nothing happened, I only saw an error in the bottom left hand corner status bar. I was using IE 8. I did go back a second time and this time
Submit form and populate fields in a separate application form.
Please advise if this is possible: On successful submission of a form I want to use the OpenURL in a script to open a form in a different application but populate fields in that form based on the submission from the original form. For example, I have a Findings application with a Priority field and a Tasks application with a Priority field. When a user submits a Result I want the Tasks form to open and populate the Tasks.Priority field with what was submitted from the Findings.Priority field. These
Look up part of a field. Does field value contain a string.
I have an accounts form that allows our reps to enter in an account name. However to avoid non exact duplicates (i.e Global Travel and Global Travel LLC) I would like to have a note field that updates with all possible matches of what ever is typed so far. So for example when global is entered the notes field list Global Adventures, Global Assoc Growers, ect. Basically the same functionality as an auto complete based on a database lookup. Is there anyway to do this?
If condition in a view
Hi! I have a field in a view that depends on the values of two other fields and I need to show diferent values. My if condition is: if (input.Preco_jumbo > input.Preco_continente) { Mais_barato = "Continente"; } else { Mais_barato = "Jumbo"; } My question is where should be this statement? In the form field associated to an action like on add/edit or in the view script?
Multiple forms in single application
I have following different questions: How to create multiple forms in a single application? Is it possible to provide only view rights only to corresponding views of those forms to a person? Can one show or hide different forms within an application based on logged in user? or If this is not possible is it possible to keep only selected fields of forms editable for a logged in user? Please help urgently.
How does the Search Interface actually work?
I am new to the Zoho Developer community, I have a background in scripting although HTML is not my strong point at all. I am trying to create a Search interface and am following the relevant Help options that Zoho have available (https://help.creator.zoho.com/Creating-a-Search-Interface.html and https://help.creator.zoho.com/Create-HTML-Views.html) but it is getting me absolutely nowhere. The templates they have available in the HTML views are so confusing and I am just stuck! All I want to do is
How do I see if a date range falls within or overlaps another date range?
I'm trying to make a school register. The teachers need to be able to print off a weekly sheet which shows on what days each student will be attending. Technically, I think this boils down to seeing if one date range (the period of the student's attendance) falls within another date range (the period of the register - these are needed weekly). Any help from anyone on how to do this would be greatly appreciated :)
Zoho Creator update via API
I tried to update record via API but getting error: "2897 Permission denied to update record" . The application is my own with all correction about apikey Everyone can help me to solve it out. Thanks
Passign params to HTML view
Hi :o) I have created a HTML view that contains a form and a view. This is to represent a hosting account and associated email addresses. The form opens ok with the correct ID number in the address bar - but there is no data in the form and the view is not filtered. The script behind the view is below:- ---------------------------------------------------- htmlpage Hosting_Detail(Id) displayname = "Hosting Detail" content <%{%> <div elName='zc-component' formLinkName='Hosting_account' params='zc_Header=true&zc_SuccMsg=Data
t_483991000002580764] Exception occured while setting value in PreparedStatemen
Please fix this urgently... I've gotten these errors before.. 1 . [t_483991000002580764] Exception occured while setting value in PreparedStatement for the Column [Recurring__483991000004325880] Check whether the datatype for this column is given as specified in the data-dictionary .[t_483991000002580764] Exception occured while setting value in PreparedStatement for the Column [Recurring__483991000004325880] Check whether the datatype for this column is given as specified in the data-dictionary
sharing developer
I wan to share my application with a developer. I have activated a user account to developer. Searched the forum and found the solution saying "Edit permission to......." but this does not show up in my settings. How can I share with a developer??? Kind regards Michael
URL Syntax for subform with multiple arguments
I'm trying to define a function similar to the "Add Attendance," except I want to pass two arguments - one for ID (which works fine by itself) and another one for date (which also works fine by itself). When I try to combine them together in one URL statement, I don't receive any error messages when I save or execute the script. However, neither field passes to my form. This is the URL statement I've keyed: openUrl("#Form:Add_Distribution?Transaction_Date?Transaction_ID" + input.date + "" + input.id
Next Page