Functionality based URL's - print - in Functions
Having now spent a few hours on this challenge I ask for some advice. I have succesfully created a function as below that allows me to view more information from a specific record. this idea was taken from a sample and modified for our needs. void print.MoreInfo(int LoadNumber) { openUrl("#View:InboundLoadSummary?LoadNumber=" + input.LoadNumber + "&hideprint=true", "same window"); } The concatenation works fine and I noted from the sample that the ZOHO domain, username and appname were
Linking Zoho Creator Apps with CRM
Hi, I'm using the deluge code given on the below link to populate a drop down select field with the vendor details in my Zoho CRM. http://zohocrm.wiki.zoho.com/Linking-Zoho-Creator-Apps-with-CRM.html I have adapted the code slightly, but it will not save and the error message I receive is not much help - "null". The field to be populated is called "Seller1" The code below is the same except I have replaced MYLOGINID, MYPASSWORD, MYAPIKEY and MYCVNAME Can anyone help? Many thanks. responseStr = getUrl(("http://accounts.zoho.com/login?servicename=ZohoCRM&FROM_AGENT=true&LOGIN_ID=MYLOGINID&PASSWORD=MYPASSWORD"));
May I Customize My Form?
I would like to customize a user form like the one attached. The form must be interactive and be able to update my data. Thank you for your quick response.
Can't Delete Function (again)
I encountered another case where I cannot delete a function. When I try to delete the function, it says: Function cannot be deleted. This function is referred in the following places. Please remove the reference,then try deleting the function. In action script--> Notice, there is no name after: "In action script-->" The name of the function is: GetPledgePayment The name of my application is: MyDB I have given support access to the application. Please access my application and delete the function
Need Help Formatting Printout of Student Directory
Hi: I have a seres of Zoho tables for a small school. I need to printout a Student Directory in which the student's name is listed once on the left and the parents are each listed (one per row) underneath. The look needs to somewhat resemble an Excel pivot table where the student names are grouped. Can this be done when setting up a view? Thanks- Charlie Epes
Does Zoho Creator support Soundex (phonetic) algorithms that will display similar sounding values?
E.g., when adding a new company into a database, if the company name is similar, though not exact, to a company already in the database it would be recognized as a potential match and permit a notification message (such as "Did you mean this company?").
Problem importing data into Zoho Creator database
I have a very simple form and am trying to import data into it. I have successfully done this in the past, but this time it silently fails every single time and gives no feedback about what is causing it to fail. I have tested all the obvious things, like data types and field names, and have found no issues. Any ideas for how to test further or how to get explicit feedback about what is killing it? Thanks!
Another Update ... Another case of breaking existing functionality !!!!
Looks like the ZOHO Creator Team decided to update the platform ... ... right in the middle of the day (Eastern Time) ... without any advance notice ... and in keeping with past practices, broke existing functionality !!! When trying to Edit an Application ... free-flow mode ... when you right click on a Form field and then ask to Edit Actions on user Input ... the resulting display goes into a never ending "loading" state. However, when you click on the Share Tab and then choose the event from the
Zoho applicaiton will not Import CSV, XLS in any browser
I've spent hours trying to bulk import 7600 entries into the application. 5900 were successfully added. The application never accepted the full list but did accept ~1000 at a time until 5,900. Now, it will only accept 2 per addition. What's going on with this?
Editing Import Data Feature
Hi, I'm using the Donor app from the market place and the Import Data feature won't let me import records with duplicate emails. Is this a data constraint or code in the Import feature? And how do I change it? Thanks, Michael
Schedules - am I doing something wrong here??
I have made a schedule which is to run daily at 4pm and email everyone the schedule for tomorrows events. It is not working for me. Not getting a single email. Also, it would be nice if the schedule section had a little button to test script to make sure it works - rather than setting the time and waiting a half hour each time to run. Here is my code: WHEN TO DO? Send Schedule { execute event on '2010-04-21' at '16:00' daily } WHAT TO DO? for each Staff_Members in Add_Delete_Staff { sendmail
Get google calendar into Zoho creator database
In my company Google calendar is used, and we would like to import the appointments made in Google calendar into an Zoho creator application. When the data for the appointments is in Zoho creator, then one should be apple to attach extra information. Is this somehow possible? Or one would be able to see our google calendar in a zoho creator form, and then update google calendar from zoho creator by filling out a zoho creator form that sends a .ical file to google calendar. Then one could add recipients
How to add custom action to views without records
I have a Contacts View with a Notes button on each record in the view. When I press the Notes button for "John", it shows the Notes View filtered for the Contact John. However, when I press Add in the Notes View for John's Contact, it does not populate the John's Contact Form ID on the new note. Thus, there is no connection between the Contact John and that new Note that was just created. How can I ensure the Contact Form ID for John is passed to the new Note, to maintain the connection?
Email Data
Ref to http://help.creator.zoho.com/Email-Data.html I think the concept of emailing data would be more usable if Creator would accept email from anyone, if the form is public, and have the option to parse-out the sender, subject and body without having to resort to keyed form fields in the email.
Doodle functionality
Hi there. i am looking for a form in a kind of a 'doodle' for planing meeetings. Has anyone an idea? Thanks
Reports in creator
I am trying to make some graphs in Creator reports and have hit a road block. I have a bunch of events scheduled at differnet times of the day, every day. I have made a graph which shows the count # of the different positions of people involved with each event and also the number of delays starting on time. On the X axis, I have the time from 0-24. Is it possible to give the user options of clicking on certain days or ranges and making it more configurable for the user to get the data they
Form Scheduler
I am setting up a from scheduler and was wondering if there was anyway that when the email goes out it can send the corresponding row to the date. For example I have a row that looks like sales associate job number mail date quantity I have setup the scheduler to email out when that mail date comes, but I want the fields put into the email so they know what job it is. Also is there anyway to make the person it emails out to be the person who is in the sales associate column?
Relationship with relationship entities
Hi, I have the following problem. Forms A, B, C, D, E, F, G, H all collect simple data entities Form I creates a unique entity by lookup to forms A - H Forms J, K collect simple data entities Form L is intended to create an entity by lookup to Forms I, J, K The problem is that all the lookup to form I presents is the ID, which is not very meaningful to the user Can anyone help achieve my intention Barry
LABEL_FORMAT=P not working for the API to sheet for graphing
I tried, based on the documentation in http://help.creator.zoho.com/Creating-charts-using-Zoho-Sheet-API.html, to create labels on the PIE chart, but no variation of upper or lower case on it works. The format should be what? Here's the URL I was generating (replace the $ in front of 0A with a percent sign, as it gets stripped out in this editor): http://sheet.zoho.com/zohochart.do?&title=Excludes Not answered&charttype=PIE&LABEL_FORMAT=P&width=600&height=300&chartdata=Complexity,Count$0ALarge,1$0AModerate,5$0ASmall,5
Prevent user data from being recreated
Hello, I created a patient database witch uses several forms, patient evaluation, contacts, appointments and so on, each form link with each other through the patient name with a Lookup field displayed as "Dropdown (single select)". What happens is that when using the application and selecting one of the patients, that were already registered, from the dropdown: - The fields that i have already filled wont show up, pre-filled like in the form view. - If I write something on those fields they will
View by date
Can I create a view that displays things based on the whether or not the date == today. I have a column with dates in it called date1. I want a dynamic view that will display rows that the date is == today. Is this possible?
Creating multiple forms?______________________
I am at a loss and not able to create a 2nd form without creating a separate table that stores it in a separate Creator Form. I know how to associate many Views to a Form but each Form I create in "Edit Application" creates different table. I've read all the comments but need someone to walk me through the process. Willing to pay and do via Desktop Sharing. I am not very technical but typically can figure things out. This has been a problem. Will Zoho CREATOR come out with a WIZARD to associate
Message to User
I have a Custom Action that should only be used by the Administrator for debugging purposes. I've written the script for this so it only executes the important part of the logged in user is the Administrator. The problem is that the system gives any user the message that it was succesful, even though nothing in the data changed. Is it possible to give the user a specific message like this? if (zoho.adminuser == zoho.loginuser) { do_the_thing; } else { message "Sorry, only the Administrator
How to localize ZOHO login screens
I have noticed the various discussions about non-ZOHO branded login screens, and I am happy to see that ZOHO has come up with a solution that should address most of the concerns. Unfortunately, it seems that while almost any message in the form can be customized (and hence localized), this is not the case with the login screen, and as a result a show-stopper for many international end-users. Is there a way to have the login and sign-up screen localized, and if so, how? And if not, what is the ETA
set input field to content of notes field?
I've created a user agreement form, which has a note field that has the user agreement text. I would like a hidden field that gets assigned the contents of the note field that has the user agreement text upon submit (or load). If the agreement language changes, I need to have a copy of the exact text that was in place when each person "signed" the agreement. When I try to do this on validate, I get this error when trying to save: Field plain does not exist in the form User_Agreement When I try to
Date Time - very simple question.
I have a very simple question which is boggling me. I have a Date-Time field in my form. I have the following function: if ((input.Date_Time == zoho.currentdate)) { Send email... } I want emails sent out only if the date scheduled in the record is todays date. I know my field is a Date-Time field, but for this function, I only care about being the same date. I don't know why I can't figure this out, but its not working for me. Thanks
1 to many tables
I have an application in Access that has many tables, some are one to many, and with look-up tables. Is it possible to import the tables as is? Is it possible to have 1-to-many tables in Zoho? I'm a newbie here.... Thx Rob
Usage Limits
A client asked me to help with his Zoho application. He has several forms that he wants to combine some of the information into a new form. I have written the code but I am now bumping up against the 500 record limit. I may only be hitting the limit because I've run several tests today. However he may hit the limit in a few months. I don't know what subscription level he has. What is the fee to increase the usage limits? Herb Wexler
How can I make a record a url link in a view?
Hello Everyone, I have been searching the forum and knowledgebase for a couple of hours and cannot seem to find anything regarding this. Can records in a list view be a link? I have 2 different forms linked by a "Subject_ID." when I view the view from the second form I have "Subject_ID" as a column and it lists the "Subject_IDs" as records but I want to be able to click on the "Subject_ID" and go that "Subject_ID" in the first form. How can I make a record a url link in a view? Bryan
Use of Dynamically Loaded ListBox Fields !!!
In the past couple of months, my clients have encountered situations related to ... ListBoxes whose options are dynamically loaded in Add/Edit Forms from records in other Tables (Forms) ... that have made the use of such ListBoxes vey unappealing. I have discussed such situations with the ZOHO Creator Team in private ... but there appears to be no urgency in addressing these deficiencies (architecture flaws) ... so I am posting this for the benefit of others who may be using such fields/techniques
Unable to save changes in a couple of my scripts. Error message 12002
I get error message 12002 when trying to save changes into some of my scripts. Besides, while trying to submit a form that uses those scripts, submission fails or gets very slow (about 30 seconds). Thanks, Jaime
update values for new formula field
I added a formula field to a form with existing data. How do I update this field for all existing records. I'm considering adding a temp field and doing a bulk edit to change the temp field and then remove the temp field. This would force a recalc of the formula field. Is there a simpler method? Herb Wexler www.PreventingMediocrity.com
Can't delete a field
I'm trying to delete a field but keep getting the following message: I've tried to delete it on three different PC's but get the same message. Any ideas? Martyn
Radio Button Value not Displayed
When I submit a new record, the value for the radio button does not show up in the View; but it does after I go in and edit, even if I change nothing.
Problem updating
Hi Zoho Team, I have had a good experience so far with Creator. I got some templates from the Market place and configured it for my company's CRM. Right now i have this problem with a form. I can't seem to update it if I am not log in as the Developer. I have set share to all the forms to the users already. When i click the built in edit button, i could edit but when i go thru my custom button, it doens't seem to let me edit my form. the link is creator.zoho.com/enterpriseportal/inovarsales. I hope
is there a way to export addresses into Microsoft Streets/Trips?
I need to export 30 contacts into some mapping software (google, yahoo, or we have streets and trips) to create a drive route for our staff- any suggestions?
Reports and Charts enhancements?
Now that the beta of reports and charts is working better I'd like to post a number of suggestions that would make it much more useful and likely to attract additional subscription income. Issues that hopefully will go away when it's out of beta: a. Reports and Charts are not showing up in the iPhone app. b. Reports and Charts which are added to a tab in the layout are not automatically shared to users who have full sharing privileges to that tab. c. Move all the "Done" and "Cancel" buttons to the
Custom Action-Select Function
I created a function but it does not display in the Select Function dropdown on the Custom Action section of the view. The correct namespace is displayed but the dropdown is blank. I have tried different views and browsers. I am not the owner of the application but have developer/edit access. Herb WExler
Can't add a lookup field.
I am on Windows 7 Ultimate 64-bit, using Internet Explorer 8. I have two forms: one for tracking calls, and one for tracking issue types. The issue type form has one no-dupes field in it. Steps: Go to the call form. Drag the Lookup field to the form: Change the label to Issue Type. Import the "Issue" field from the issue type form. Display it as a multi select field. Click Done. The field displays on the form. Click Access This Application. Error: The field is not displayed. * Click Edit This
View + search with apostrophe + bulk edit = text after the apostrophe is stripped from search.
[eta] My details: Windows 7 Ultimate 64-bit, IE 8.0. This also happens in Google Chrome 4.1 and Firefox 3.5.9. Steps: Go to a view. Click Search. In a text field's search box, select Contains. Enter a string with an apostrophe. For example: can't start Search. Get accurate results. Select a few, and click Bulk Edit. Click Apply. (Changing things or not makes no difference.) Error: The search string now says "can" (without quotes), and the search results have been updated accordingly. I've
Next Page