Saving Lookup field data into new lists.
Hello everybody, I had a question. I have placed a lookup field in my form that has a list of 2000+ players, I wanted to be able to select a couple players from the lookup field then save them to a team record. For example... I select 7 players from the lookup field, save them into a list, name the list, then save it. I would also like to make another form that looks up the list of new teams i made from the prior form, a user be able to select a team, then edit the data accordingly. Like adding a
Rebranding on an Application by Application Basis vs. Subscription
I would like the ability to rebrand applications just like we can now with the added ability to do it on an application by application basis. If I develop an application for use by XYZ company, for example, they might want their logo and URLs displayed versus only being able to use my subscription based logo and URLs, etc. If I had 10 applications, I might have 10 different logos, for example. It would be greatly appreciated if you could make this enhancement. Sincerely, Russell S. Brown
Zoho Mail add on for Zoho Creator
Hi We have just developed a CRM in zoho creator. We want this CRM to manage emails like the zoho mail add on does in zoho crm, can this be done, if so how? It must be possible if you guys have been able to integrate google apps mail in your zoho creator helpdesk
Related records
I wanted to create a view, with the related records of a record showing on the same page.... Which is to say, in a one-to-many relationship, I want the main records and all the related foreign table records showing on the same page.... is this available now?
Sharing Application Doesn't Work Properly
I have an application (INZDB2) that I have shared with one of the people in my organization (see graphic below): The user logs in and can see the application as being shared (see below): But when trying to access the application, the user receives a message saying that they are not allowed to access the application (see below): I have shared access/edit to support for this application. Thanks, Leo Saumure
Does Zoho Creator support Regular Expressions?
I need to parse an XML feed, but I need to use regular expressions to filter out the data I need from the XML, as it is spread throughout strings. I need to apply regex in conditional statements to get exactly the data I need out of the strings. Does Zoho Creator support Regular Expressions? If not, how might I get precise patterns of data out of a string in XML? Thanks.
Unable to make form public
I am trying to make my form public but when I'm clicking 'click here to request for public access' it's not working. What to do now?
URL param: #form vs. form-embed
I have a stateless form. It has a hidden field to accept a URL parameter. One URL works and the other does not. Works: http://creator.zoho.com/ensobase/home/#Form:Task_Manager?DealPreLoadHidden=Deal-Name Does NOT work: http://creator.zoho.com/ensobase/home/form-embed/Task_Manager?DealPreLoadHidden=Deal-Name I need to use the embedded form because I cannot have the application chrome. Maybe there is another way. What am I doing wrong? Thanks, Tony
Error: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Hi, I have sent this message once before, but cannot see a record of it, so I apologise if you have received it multiple times. I am receiving the following message whenever I try to access the scripts tab in Creator: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null' The error occurs only with one of my applications, and I think it is related to a problem with a view "Send midday messages" (not "Send Mid Day Messages"). I accidentally removed all columns from the view, except for a related
"For Each", "Sum" and then "Insert into" issues.
Hello All, Form A = Form with Data that I want to retrieve from. //Form A will have multiple records that are indexed by "Po_No" Form B = Form that I want to pull data into. //Form B will required the muliple records in Form A to be summed with the result being inserted into a record in Form B. I am trying to use "for each r" to pull record specific data from Form A, sum specific fields, and take the total sum data and insert into a field within a new record. I will need to repeat the "for
Forms and URL validation
Does anyone know how to validate the URL entered in a field on a form? I guess really to check for 404 errors? Thanks, Me
Multiselect lookup.
I would like to create a record for each item of the multiselect (lookup field) list which are selected by the user. Because when we select few items in the multiselect lookup field, those item are registered in one record. How can I do that??
training on "creator"
Heard about Zoho from various sources and am particularly interested in "CREATOR" as I run an SME on a bespoke database written 6 years ago. Can anyone point me in the direction of TRAINING ? Doesn't seem to be an extensive help function to fall back on. Are there training courses ? training websites ?
postUrl needs to support XML REST Services
I have an urgent need to interface an application in ZOHO Creator to an online bookkeeping system which supports REST based web services. I was a little surprised to see that the postUrl function only supports maps (key->value) pairs and not the ability to specify an XML body in the POST request. When is this going to be changed? Is there any chance that we can have a special key "data" that simply uses the value in the body. This would allow for backward compatibility in the function call and at
Export data from Zoho Cretor view to Zoho Spreadsheet
I export data from one of my Zoho Creator private views (e.g. Mevi) as a CSV file not requiring login, but Zoho Spreadsheet does not want to accept it through its 'Link external data' feature giving me the message 'Problem in configuring WebData when linking external data'. What an I doing wrong? Thanks for help.
How to manage users in a Creator application
Can anyone help me find out how I can mange users in a Zoho application I have a time management system and I need 3 levels of authority (e.g., User, Supervisor and Admin). When a User logs in they can only see their tasks in the appliaction and update their tasks and they can't say run reports in this application. When an Admin signs in they can see all the tasks of all users in the application and they can run any report they want. How can I create these different levels of user and allow them
problem with hide field from others option
I want to let you guys know if a field is set to "hide from others", it often wont update properly. I noticed this because I couldn't find certain records in a view that had a criteria based on it. For me it was a field called Job Year and it updated on user input of Job Date. After, I was trying to find completed jobs in a given year. May I suggest getting rid of the "hide from others" option. It's just as easy to hide it within the on load script. I don't really see the point of having both. Thanks.
Form layouts
How can we modify the form layout, color and such? Currently, all my forms have two columns. What if I want a compact single column? I've been searching the User's Guide, but haven't found anything. Thanks, Joe
Custom Buttons Deactivated on Form
I have a form (TrialMapCrit) which is a stateless form that previously had no problems. Now, however, the custom buttons are not working after anything on the form is selected (radio buttons). I've tested it in Firefox and Safari but none of the other browsers. Please advise.
Another piece of functionality reported to have stopped working in my Client's Application
@ZOHO Creator Team: I just received an email from one of my clients (who went live in January/February) ... stating that as of the last hour or so, all functionality of a certain type has stopped working. This functionality is that ... I have Single Line Text fields in records with content of the type ... http://creator.zoho.com/MYACCOUNT/MYAPPLICATION/view-perma/MYHTMLVIEW/ContactNumber=105 ... so when he is looking at a List View, a column contains the links to associated child records. He says
Sendmail limit ?
May I ask...when I want to list a html table as below coding to show all the results of picklist (around 30 individual picklists), it failed when there are more than 30 picklists.. html = html + "<tr><td>Item Name</td><td>Price</td><td>Qty (=input.picklistA)</td></tr>"; Item Name <- Is it have a way to let me call them as this is the displayname of picklist such as input.formdata done ? I have tried to rewrite from http://help.zoho.com/portal/en/community/topic/can-the-sendmail-from-a-form-only-send-data-from-the-decision-checkboxes-selected-by-the-user
Permissions
I have created a simple form which I have uploaded onto a website. I have also uploaded the view to the website. The idea being that visitors can view and make simple filtered queries on the database. However the view (on both the website and within Zoho Creator) allow visitors to add, edit and delete records...which I don't want them to do. I haven't checked the boxes on the permissions page. Any ideas?
Pulling information from Zoho Creator
Hi, I am creating a database for customer information: I need to pull the following information EASILY: 1. Birthdays (for birthday promotions) 2. Services they receive. Currently I have services in Checkbox - but maybe that is not the best way to use it. I need help guys!!! Dana
HTML View for each record
How do I generate an HTML view for each record I have? I was hoping to use only one page and depending on the record ID, the HTML page would show the fields specific to that record. I tried adding a "thisID" parameter to the HTML view but that is a type string which can't be compared using == to the type int ID of the record. I want to be able to look at a list view, click on a link in it and have an HTML page open with a summary view (or something along this line) of that record. Is this possible?
Fetcing a SUM would be very helpful
I would love to be able to fetch a sum instead of just seeing it in the view! Using deluge script, I was thinking that if you used the "for each record" to fetch the specific numeric values from a collection/form. Than maybe a built-in numeric function called "SUM ()" to Sum all of those a values to return a specific "SUM" value to a field. This would be very helpful for our business as I use Creator to make invoices and it would save alot of time to not have to manually add or subtract 2 sums to
Employee names
Shouldn't there be a employee database linked to this app too?
Can't find View to edit
Hello, If I click on a request, I see a field called due date. This field is really Deadline_date which is auto-calculated from Priority. I wanted to have user selected Due dates so I created my own field called "Target Due Date". I managed to replace "Due Date" with my custom "Target Due Date" in almost all views. The problem is that I couldn't not find the above mentioned view. To see what I mean, click on a request and you will see a field in the top section called Due Date. I want to replace
Initializing a timestamp data type in a dropdown list fails
I have a date field in one form and use this data to populate a drop-down list in the second. By using the second form "edit - on load" event, I save the previously selected value in a variable then repopulate the list based on other selected values in the second form. I then try to set the date value back to what I saved in the variable and it fails to work. I end up with a correctly populated drop-down but no value initially selected. This technique works for other data types. If you're able to
comparing two dates in a form
i want to be able to compare two dates. The user enters one date in and then, in the same form, after the first date, they enter a second date. I want the fields to compare each other and if they aren't a tleast two weeks apart pop up with an alert. I know how to do the alert but dont know how to compare to dates in an if statement. How do i compare two dates in an if statement? is that how i would do it? I assume that both fields need to make the comparison but how do you deal with the first field
User application
Hi, how can i upload user application in Zoho ? Once done, are they running even if i disconnect my account ? Thanks Massimo
Filter View using URL
Could someone help me construct this openURL statement. The image below kind of shows what I'm trying to do. When the clicks the conflict button on the bottom right of the screen, the application will run the openURL function that will filter the view by the Associate appearing in the lookup (near bottom right of main form) field as well as filtering by the date (date only) appearing in the Start Time field. I've tried many different permutations of the openURL, but just can't get it right. Here's
File upload feature
For the File upload , we can't set only image file (.jpg , .png, .gif) to be uploaded? I don't want user to upload any program file into my server.
MAX Records reached - without adding records ALL OK now
Thank you ZOHO support in particular Ruben who attended to this issue so quickly. Everything is back to normal running smoothly. Thank you for your tips on how I can avoid myself causing this again in the future. Keep up the good work, geatly appreciated. Regards Mark.
MAX Records reached - without adding records
I was just performing a task that involved script but did not involve adding records and I received the following message. Error details: Error occured while executing on click script. The maximum number of records that can be added per day is reached. Please see the usage limits per day int the account setings I checked the Usage Limit Details and it reports that we have not crossed any limits Right now my customers cannot make any enquiries and I cannot make any bookings - Why is this - URGENT
Restrict users from seeing other users records BUT NOT THE ADMINISTRATOR?
So i want to restrict the records that users can see. I have used the code below in my view script to only allow logged in user to see their own records. displayname = "Your Submissions Grid" show all rows from LeadsYour_Closed_Deals_Submission_Form [Agent_Email == zoho.loginuserid] This part is easy and is working just fine. The problem i have is as the administrator i want to see all records and i do not want to need to duplicate all of my views. Using this method it blocks me from
Change in behaviour of combo boxes
Was there a recent change in how combo boxes could be updated? Until recently, I could use script to add records to a table and if the combo box was "-Select-" it would save it without issue. Now, when using script to add records, I get an error message if the combo boxes read "-Select-". Was there a change recently that would result in this behaviour? Leo Saumure
How to restrict zoho account users to complete a form based on choosing another users name in a drop down list
Hello, Thanks for the help in advance. Currently, any user that logs in my Form can choose any user from the drop down field to enter data to complate the form. Is there a way where if Zoho user account A logins in the application and not be able to choose user B, C, but only can choose A. Also, would like user A not be edit current rows for user B of C in my view. Thanksssss D
Mac Safari and Chrome browsers remain unusable in Creator's Free Flow Editor mode due to text artifacts (images included)
As seen in the screenshots below, Creator Free-Flow editor cannot be used in either Mac Safari or Mac Chrome due to uncontrollable text artifacts in the editor window. Works fine in Firefox, but sometimes I need to use Safari or Chrome. I know this problem has been reported a good while ago, but since Safari just released its 5.0 version, I did a fresh test. datazen1@gmail.com Santa Fe, New Mexico US
Funny Character and Favicon showing with javascript embed
Hi, I'm trying to embed a view in my website using the javascript embed code and I'm getting a  character before a £ sign - £25, looks fine in the view within creator. The page I've embeded the javascript code in in also has the Zoho Favicon showing instead of my own. Any advice to solve would be great. Kind Regards Jon
email form help!!!!!!!!!!!!!
how can I create a email form for my website? and how can I create comment box and rating for my video and pictures? thanks
Next Page