How to? publishing app to marketplace that requires certain views to be set as public, views within HTML views to display without login.
If you publish an app to the marketplace without code, do the public/private settings for views and forms install with the application? Or would the client need to be instructed to set certain views/forms to public if the app requires it to function as intended? What is the best way to code a printable HTML with an embedded view, so that the user can then embed this HTML view into their website and display it without login? So far I see only two ways, make the form view public and use the "embed
How to add data to Zoho table from HTML view?
I have an HTML view that displays data from a ZOHO table called "Options". The HTML view also displays a radio button in the first column in each row of data in my view. Up to this point everything works fine. From here, what I would like to do is to allow the user to use the radio button to select an item in the HTML view and then save the selected item to a different table called "Selections". There must be a relatively easy way to do this but I am just not sure how to pass the user's selection
Create records in one form from a multiselect lookup field from antother
Wonder if someone can help; I am trying to find a way to select some records from one form and then use these to create new records in another form. At this point I have created a stateless form with a multiselect lookup for my unit "serial number"s and an action button. I have then tried to create a script for the button; 1 for each key in input.Serial_Number 2 { 3 insert into test 4 [ 5 Added_User = zoho.loginuser 6 Serial_Number = input.Serial_Number 7
Making a field required - code not working
I'm trying to make a field required if the check box above it is checked. This is the code I've input, but it comes back with an error. ((input.VAT_registered == "yes") && (input.VAT_number == "")) { alert "Please enter VAT number"; cancel submit; } Please help! Thanks J
Any way to sort forms listing when adding a Lookup drop-down menu?
As the image below illustrates, there seems to be no clear order or logic to the listing of forms and their fields that is displayed when inserting a Lookup drop-down menu into a form. My application has many forms, including many that are not in use, so the listing of forms is long. So, when inserting a Lookup menu into a form and needing to identify the field of a particular form to import from, the long list is unsorted... clearly it would be better if it were alphabetical by form name. Is
Recommendation: allow some simple layout control in live Form views
I'm sure most of us have at one time or another wished we weren't constrained entirely to only one way to have our forms laid out. Currently, like it or not, we must all live with two vertical columns for fields that stack vertically into those columns -- one way. Well, it could be worse, but it sure would be nice to be able to have greater control of that layout with more variety of options. One simple option that would make a world of difference in some forms would be to control the width of
Non documeted limitation - maximum number of Expressions in HTML view in Edit Mode
Dear Zoho Creator Team, What is maximum number of Expressions in HTML view? According to my testings more than 200 and less than 400. And limitation is that HTML view with such number of expressions is loading FOREVER in the browser. Limitation is presented in IE, Firefox, Chrome. Below are described steps to reproduce this behavior. Step 1. Create HTML view: htmlpage Expressions_400_Bug() displayname = "Expressions 400 Bug" content <%{ a = "b";%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%> <%=a%>
Zoho xml rpc request returns success but no record in database
I have problem with my application, when i try to insert record from custom html form from localhost i get success response. But when i try to view records in the database view the record is not there. And if i delete record from my view and then i try to insert new record i get success result and the record is there i can see it in the view. By the way i am sending the post request with php curl and it is working ok Any help with this will be appreciated. Here is the code: $apikey = "xxxxxxxxxxxxxxxxxxxxxx";
Share Bug
I made my application public then reverted to private. Then I attempted to share with a user and got: buzzap/abis is shared with ZC support Cheers, John Whitney
Set subform field only to Display
Hi ZC Team I have a Form with a subform, when I click on Add I have a field on the subform that is completed with a value existing on the parents form. What I want is to show as today but disable the possibility that the user update that Field (is a dropdown field) I was trying at subform level on Load Add disable but it doesn't work, is any way to only display a field in subform and avoid alter it?, please let me know. Thanks a lot. Victor Miranda
Given several applications and many users, how can I associate applications to users?
I have 3 applications and 5 users (u1,..., u5). I want application 1 to be used by users U1, U2 and application 2 to be used by users U4, U5 and application 3 to be used by user U3 only. I will be the admin for them all. Is that possible in ZOHO Creator? Thanks.
Using zoho.adminuser variable instead of static "ownername" in urls
I want to publish an app to the market place without code, ie client can't have edit mode. I have certain html views that happen to have url links that include my app_owner_name. The variable zoho.adminuser returns the username of the application owner. Is there any way to construct an url to a view/form with the variable instead of the static <ownername>? Example: http://creatorexport.zoho.com/myname/app_name/print/printable_HTML_view Where zoho.adminuser replaces "myname" so that anyone who downloads
How do you update a CRM record from a Creator form when you don't know the CRM ID?
Hi I have a script which simply adds a record via a form to Zoho CRM. tenantinfo = { "Salutation" : input.Salutation, "First Name" : input.First_Name, "Last Name" : input.Last_Name, "Mobile" : input.Mobile_Number, "Email" : input.Email_Id, "Date of Birth" : input.Date_of_Birth, "Employment Status" : input.Employment_Status, "Organisation" : input.Organisation, "Monthly Income" : input.Monthly_Income, "National Insurance No." : input.National_Insurance, "Other Street" : input.Current_Address, "Other
Preserve Multi-column Layout for Dynamically Created Radio Buttons
This may have already been mentioned, but I just noticed that setting a 3-column layout is ignored when the radio buttons are dynamically added upon form loading. Thanks, John Whitney
Google Apps UrlFetchApp.fetch to zoho creator session does not close
Hi , Am calling the Zoho Creator get ticket API call using UrlFetchApp.fetch After the call the session remains active on my Zoho Account and as is the case if too many sessions remain open to Zoho the API will stop responding. Anyone know of this issue or knows of a way around it. thanks
Special View Criteria
Sharing a view with a user gives that use full rights to see all the data. What if we only want him to see a sub-set of data? I'm guessing view criteria is not sophisticated enough to handle this. The only way I can figure out how to enable this would be to have a new column in the data with the user's zoho ligin ID and set-up criteria to filter on that. Comments? Cheers, John Whitney
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
On this page: https://creator.zoho.com/webmagnets/view/17/edit/ I am getting this error: [ServletException in:/jsp/edit/view/viewedit.jsp] null'
Help needed- need to total hours worked per person in understandable format
Help needed- need to total hours worked per person in understandable format Anyone know how to do this? I have a formula box that totals the time, but it comes out in seconds, and it would be great to somehow look up each person and get a total in readable hour/minute format. Any ideas? formula zoho end time date-zoho end time date = total time person worked (I have this already) BUT WHAT I really need is a sum of all of the hours that person has put into a work month... Any ideas please help,
In-place editing of a lookup field for multiple records
I have an application for organizing people into focus groups. When a Study is created, the user names 1-n possible focus groups (e.g., "group 1" "group 2"). People are recruited to a study and must be assigned to focus groups. To assign a Person to a focus group, the user needs to look at a variety of background information on each person. Thus, I'd like the interface to look like: (for a given Study) Person 1's name Gender Experience etc... <lookup drop down with possible focus
many mails in input.Mail
Hi, i made a variable Mail, can i put more than one mail in input.Mail? if so, what is the separation, ";" or "," or any aother?thanks
Create a search function that will pull existing records
Situation: I am allowing users to enter membership data. But, if a membership record already exists, I would like for them to search for it and then be redirected to an 'edit' page where they can edit that existing record. I'm not sure how to do this. What I tried: I made a 'search' box where 'on user input' it searches for any record with the information entered and populates the form with the record information. BUT it will save a duplicate copy if you submit it...that's my dilemma. Any help
Does delete or backspacing a Date field to blank create the null value?
The on Input script below is designed to set the penalty field value to 30 if the day of the month is after the 15th, and to 0 if the date is not after the 15th OR if the date is blank (I'm assuming a blank date is null). The problem I am having is that when I delete or highlight and backspace the date to a blank (and then click outside the field to trigger the script) the penalty field is not reverting to 0. Can anyone hazard a guess as to what is wrong with my script? Thanks to Gaev for sending
Simple 'many to many' search example
Hi, I am trying to find a simple example of a many to may searchable database built with creator. For my needs, there are a number of 'instructors'. The only details I need are the full name and the postcodes they serve. Each instructor teaches in a number of 'postcodes'. Each postcode can be served by a number of instructors. The list of current instructors is a lookup from another form so as to always be current. In the end all I want the user to see is a search box. They would input the postcode
View to show latest record for each group of data
Hi, New to creator and just starting on my 1st project. Have some self taught experience of access and SQL but this is a long time ago. Am working on an asset tracker for use by us as an OEM and our customer as they use and distribute our machines. Mostly I need to track current location and current condition. I have a base form for my machine data such as serial number and then some other forms for input of location change and condition change. As the machines are used they will move around to lots
HTML view print problem
Hi, I have a html record view which get parameters from a form, when i wan to print the html record view, i get the following error Not Found The requested URL /bilgain/hr/print/Payslip/&Name=test&Date_field=01/12/11 was not found on this server. this is the print link https://creatorexport.zoho.com/bilgain/hr/print/Payslip/&Name%3Dtest&Date_field%3D01%2F12%2F11
Audit or History of Changes
Is this correct? 1. If I use a combination of getfieldname and getfieldvalues: a. Used in the ON LOAD or VALIDATE - it is null b. Used in the ON SUCCESS - it returns the new value 2. The old. property only works in the VALIDATE Is there any way to marry these two, so I can build a routine that will store the original value of any field that is changed?
Copying text from 1 sub-form to another
Hello, Is it possible to copy text from 1 sub-form to another. For example: I have a 4 forms In the Drawings form I have a sub-form called Materials and the user adds as many material sizes as need. Then in another form called Works_order the user selects the drawing number via a look-up linked to the Drawings form - then from that, can Zoho find all the materials in the Materials form and add them to another sub-form in the Works_order form? I'm basically asking how to come all the "rows" from one
Not sure why this code fails validation.
Background: I wanted to have Zoho assign custom IDs for certain forms so I followed the advice online and created a counter system wherein an Auto_Number form keeps track of the highest IDs and simply adds one to the appropriate counter when a new record is created. I would like to have the ID reset based on the year so that the last ID in 2012 might be 20125689 and on Jan 1 2013 it would automatically become 20130000. I'm trying to achieve this via the scheduler which I have never used before.
How do I delete unwanted column formula?
I have created some unwanted /incorrect column formulas which seem to attach themselves to all Reports associated with the same view. I really don't want them listed but am unable to see how I can delete them, otherwise it looks like they will stay defined forever! Chris
HTML Views Not Showing on iPhone
We created a Creator app with an HTML view. However, the HTML is not appearing on the iPhone or Form/View list even though it shows up on the Desktop computer. Can you tell us how to fix this? Thanks!
how do i make additional fields appear based on a users previos input in a checkbox
I have a checkbox field with various diagnosis. The can check more than one. What I want to do: If the user checks the NPH diagnosis checkbox, then a whole new set of fields should appear for him to fill out. If he doesn´t check that particular checkbox then the additional field wont appear.
Print Single Record
I have read that you have a 'print single record' function in beta which you can add on request. Please could you add to my Train2Drive application (edit access is open....somewhat hopefully!). Thank you
Web page hanging on user Zoho log-in
On a page on my web site I have six embedded reports. When a user comes to the page and logs in, they are presented with a 'Loading... Please Wait' message in each iframe. The page then hangs. Refreshing the page using F5 immediately brings up the content. This feels like a bug? Chris
create a Function Specify Arguments group object drop down list is one selection off !!
Weird issue, maybe me, am using FF latest Create a function Use builder give it a name Specify Arguments: (put something in) In my case i am selecting a group object What ever form i select in the drop down the next one on the list is the one which is written to the function. Its like the drop down is One Value off Thoughts ?
Integrate Zoho Creator with Zoho Calendar?
Zoho Calendar currently has nice functionality that does not seem to be available within Zoho Creator yet. I'm specifically interested in the ability to display multiple calendars as different colors on a single calendar view. Also the ability to easily toggle which calendars are displayed. Is the multiple color coded calendar capability going to be added to Zoho Creator? How can I integrate the two apps so records created and maintained within a Zoho Creator app can automatically be displayed
Add Event to ZOHO Calendar
I tested the zoho.calendar.createEvent task (ref) and have some observations and questions. Documentation: Instruct users to create a calendar name in Z Cal or use an existing one. Also, it would be helpful to provide examples of converting Z Creator date-time into Z Cal accepted format. There should be a way to pull a list of calendar names to populate a drop-down field. Rich-text in descriptions not working: I assume there will also be ways to edit or delete events? Cheers, John Whitney
openurl with reports and passing criteria.
Is is possible to use the openurl to pass a parameter to a report. For example I want a user to see a report that only contains records entered with the same userid. This is easy to do with views but does it work with report-perma? Herb Wexler
Suggestions for can be generated viiew by Deluge
Re Suggestions for generate viiew by Deluge 1, the view through the deluge to define which fields to show or hide; 2, if the define the view of read, write, edit, delete, etc. the better; 3, in deluge through the calculation to generate a new calculated field; Through the deluge to generate viiew can be saved to create many different types ofview, just do an all field of view and then hide it, based on all fields of view can begenerated through the deluge to the various types of view, so that very flexible
How to create fields to enter weekly sold unit for an item
Hi, Our company has about 50 Sku, and we want to keep track of the unit sold for each sku on weekly basis. I want to create an area where it has number fields for me to enter weekly units sold each year, what is the best way to do this? I want to be able to use those information to also create reports comparing the same week from past years.
Problems with Subforms
Until now I have not had a need to investigate subforms. But a need arose to create a time-input manager at work and since many people work on multiple projects, a subform seemed to be the base scenario. But subforms are really buggy! First off, it took a while to find how to update a running total of hours as people used the subform to enter projects. Yoge has a demo in the marketplace showing this. To calculate a running total, you treat the subform as a collection (for each row in SUB_FORM)
Next Page