Course Registration View Help
We have built an application which is used for course registration by our employees. The issue seems very simple, but has been difficult to resolve. The following link is of a simple application that Zoho Support was helping me with, but wasn't completed. The issues with the app is detailed below: I would prefer the when a student clicks register it automatically will register them. Not open a form and they select the course. It does not appear to behave correctly. Example: I registered for Zoho
Pre-filter Reports based on signed-in user's ZOHO ID
When a report is loaded, is it possible to pre-filter the data graphed/tabulated based on the user's ZOHO ID? In other words, hide some of the data as the report is loaded? Use-case: Managers need to view local inventory at their site, but should not see the complete inventory in the company as this is a security policy voilation. Thanks, John M. Whitney
Modifying the grouping names for display
I currently have a view that displays and groups a series of real estate closings. Grouped first by year descending and then by month descending. The group headings show 2012-1 followed by the data then 2012-2, etc. I would like to translate the 2012-1 to 2012 - January, etc. I know how to call the function to convert the numeric value of the month to it's equivalent name but I don't know if it is possible to modify the auto-generated group headings. FYI: I get the year and month information from
Work Hours in a Month
Just sharing a function I made to calculate the number of work hours in a month. It takes the input of a MONTH string (1 to 12) and does the rest based on the current year. MONTHS={"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"}; this_MONTH=MONTHS.get((input.MONTH.toLong() - 1)); DATE_STRING="01-" + this_MONTH + "-" + (zoho.currentdate.getYear()); DATE1=DATE_STRING.toDate(); DATE2=DATE1.addMonth(1); DAYS=((DATE2 - DATE1) / 86400000); HOURS_LIST={1, 2, 3,
Criteria in zoho.reports.updatedata ??
hi i use the zoho.reports.updatedata deluge task from zoho creator. i would lik to use a criteria depending of an input field value. i dont find the good way to write this criteria wich must be a string.... trans1=map(); trans1.put("Agence",input.Agence); trans1.put("AFFECTATION ANALYTIQUE",input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE",input.LIBELLE); trans1.put("AFF-CS-PS",input.AFF_CS_PS); a="AFFECTATION ANALYTIQUE=" + input.AFFECTATION_ANALYTIQUE; mapResponse = zoho.reports.updatedata("BASE","TABLE",trans1,a);
Delete records does not work properly for decision boxes
Hello, I've created a test application to expose this issue, which I have shared for tech support (it is named "delete-bug"). The issue is the following: I create a decision box for my application, and submit it as FALSE into the database. I then run a script to delete the decision box, but it only deletes data if the decision box was marked TRUE. The code is as follows: delete from decision_box_form[ Box1 ]; The only way to get this to work is to compose: delete from decision_box_form[ Box1 == false
'Backup Apps' failed in Creator permanently
Hello Zoho! We have a problems with backup of our app ‘CRM’ in Creator. Trying few times on last week, but still unsuccessfully. Please, help us with a backup. Alexander Smit. Clientbridge.
Login?
Hi! Is there a way to use Zoho as a login screen, where it would return the users name or something if the data matches up correctly? I would then use cookies i quess to store that info, then delete the cookie when they log out. Is this system possible with zoho?
Validating user input in decimal field
In a form, I have added a decimal field to capture "duration" in this format - 00.00 (hh.min). Once user inputs the value, I would like to validate the field to check that the input is in exact format as requested. Can anyone help me with an answer on how to achieve this.
Help with limiting user access
We have 10 case managers with hundreds of clients and are trying to prevent our case managers from seeing any records that are not assigned to them. We have a case manager view created which links their names and email address. Tech support has provided to following code: cm_email=zoho.loginuserid however when this is used in "Set Critera" I (ADMIN) lose access to my whole pipeline view. I have tried to duplicate views unsuccessfully. Thank you in advance for your help on this.
"zc_Header=false" doesn't work in view-embed (since view enhancements)
Hi, Style based URLs: "zc_Header=false" doesn't work in embeded views since view enhancements. Regards, Leszek
Field does not update/update properly on "on input"? / Adding values of selected entries in real time
Hello, It's probably something small that I'm missing here, but I'm trying to get your example application, "calculate-multi-select-price" to update with the price of the items selected in real time. The application is shared with development and is entitled "Copy of Calculate Multi Select Price" (http://creator.zoho.com/andrewkahn.me/copy-of-calculate-multi-select-price) I placed the code from the on success script (which does work properly for On Success only) into On Input: val = 0.0; for each
Urgent ... Client experiencing problem as of this morning !!!!
ZC Support: My client has just reported a problem (a popped up Stateless Form is no longer closing via script) ... nothing has changed on this App for a long time ... I tried to examine the code ... but the system goes into a never ending wait state as soon as I ask to see the code associated with a Button ... on both the Test and Production versions of this Application. According to the client, problem only occurs on machines where the Browser was NOT closed from the previous day !!! There is no
Can the ZOHO Creator Team please explain this situation ?
I just received an email from noreply@zohocreator.com ... here is its content ... Hi scriptedlogic, The user orders@wmxchange.net has been added to the list of users associated with your account. Since the user has shared access to your application, he/she has been added automatically while accessing your application. https://creator.zoho.com/scriptedlogic/sicar-lite/#Form:User_Info Regards, Zoho Creator PS: This is a system generated mail from Zoho Creator. Please do not reply to this mail. When
Api returing wrong value
Hi I m facing a strange issue in my form there is field delivered_date it is empty in my database but when i request through api it returns wrong value.I have attached two screenshots one showing its value in zoho creator view and 2nd one showing value when i request it through php. If i fill value of date field then it starts working fine. Regards
Embed Help
I've made a start from scratch application that I wish to use from a different website. I can't find the Embed Option under the More Actions. I've made it public, even though I don't want it to be. But I still can't find the Embed Option. Any help?
How to create a filter in a database?
Hello, Exactly, that I would like to do is to create a filter: The user will have to choose between different option of language: English, Spanish, French, Deutsh .... In fonction of the answer of the questions the user will be redirected in a different dataform. In the same time, when the user create some filter in the product finder price, type, brand, features.... he could find the correct device. How can we do that? Thanks very much for your help,
scripts broken by a platform update or change (yet again)
@ZOHO Creator Once again I find there are suddenly broken scripts in a business-critical app due to some sort of platform update or change which you have made and which you have not properly tested or warned users about prior to roll out. I have not edited the scripts in question recently. Please roll back the problematic update/changes as a matter of urgency. I have so far only sent one specific issue to support but it appears that these problems affect more than one form/script. Anton
Purpose of Function and Scheduler in Application Home Section
Sorry maybe i missed the announcement, or cant seem to find it What is the purpose and difference of the Function and Scheduler in the Application Home Section as opposed to what i have been using Functions and Scheduler for individual apps ? I have an idea but don't want to waste time writing stuff in the wrong section
Need help for convert string to date or number in HTML view
Hi Why can't convert a string variable to date or number in HTML view by using toDate() or toLong() built-in function? I try to so many times it's can't save the script like bellow: Waiting your help and thanks Stanley
about upload
I'd like to save to record an image file from an external website, using a script to do it without using the upload field, possible?
Hmm, our Creator Pages not working this morning
Hello there- It appears our Creator pages are not working this morning. It's strange, because they were earlier today, but now when we attempt to access the pages, they time out. Any idea what is happening here? Thanks! R~
How to make notes appear in the email sent when the user clicks submit?
I wrote an html code and added it to the form with the field notes and I want it to appear with the rest of the information that is send to me when the user clicks submit. Thank you for your help! :)
Could use some help with challenging script
Hi, I'm at a loss. It seems I'm terrible at math and not much better at scripting Here's my issue: I'm developing matching software for a speed dating like event. There will be roughly 20 people from 2 different categories ranking each other after a series of first round "dates". Think of them as 10 males and 10 females. After the first round, each person will submit their top 5 choices and we will come up with their 3 best matches for the 2nd round of dates based on comparing everyone's top choices.
Problem importing data
Hi, I tried to import data to my Zoho Creator application but was not successfull. Got this error message instead "Import Failed: Unexpected Error. Please report this issue to support@zohocreator.com. Please help. Thanks! Regards, Queenie
zoho.currentdate.subMethod(1) returning wrong value
current date: 03/30/2012 <%=zoho.currentdate.subMonth(1)%> returns 03/01/2012
Application question
I want to develop an application that using one form that can maintain data from many customers who log in separately. The data for each customer is separate and private. Can Zoho handle this? I would also like to aggregate all the data to run queries and monitor. Any suggestions would be appreciated.
Bug in Zoho Forum search function
Seeing one has to use the Zoho Creator forum extensively to get anything done, here is an issue i have found when searching for ideas In the search field use the term "add row" this will give you 16 results U can see the firs page of 10 results Go the the next page, you see nothing..and u can never find the next 6 results. Also with this term u cant sort by date it just goes blank If you use add row in the search field it works and of course i have the time to search the 100 results (NOT)
Custom Action on phone
Is there a way to use a custom action on a view on a phone (Android or Iphone). Currently the view is displayed in Summary style which does not show my Custom Action button. Herb Wexler
Limiting User Access / Views
We are having difficulties in limiting our case manager to viewing only their own records. We have a case manager view where the case manager names are associated to their email addresses. For security reasons we would like to limit each case manager to only see file that are assigned to them. A zoho tech provided the following code: cm_email=zoho.loginuserid which was entered into the pipeline view, and it seemed to work for the agents, however being logged in as admin I could not see any of the
How do you move files from Personal to Shared
I'm new to ZoHo and when I created my apps, I created them under Personal Apps but I would like to move them to Shared Apps. Can this be done or do I need to recreate the apps and all the information already stored?
Verification Code in Firefox repeatedly throws error on correctly entered code
I have seen this issue on the forum, and it keeps being said that there is no issue because support can't reproduce it. Or the other one is to use a "supported" browser. I understand there are a lot of browsers, but keeping up is crucial to the success of your applications, Zoho. My client is using Firefox 10.0.1 and she has sent me multiple screenshots of the verification code repeatedly failing to recognize a correct entry. I provide those screenshots: FORM 1 shows a correct code being entered
2nd Technician added to Zoho Helpdesk not allowed to access the application
On my install of Zoho Creator Help Desk, I have tried to set up another technician. However, when the other technician attemps to log in the following error is rec'd: You have logged in as "user." You are not allowed to access this application. Please click here to login as a different user. Click here to go to your home page. What can I do to fix this? Thanks in advance!
Using zc_LoadIn=dialog to edit and add records from an HTML view
I have an html view and would like to mimic the Edit and Add record found in a standard list view. I can get Edit to work, but the required zc_NextUrl and openUrl("#Script:dialog.close", "same window") in the form definition are clunky at best. I can not get Add record to function, however. The add record form opens in the popup window, but the NextUrl does not cause a refresh and the #Script:dialog.close in OnAdd...OnSuccess does not close the popup. I will respectfully disagree with Gaev (About
Allow more space for form name in edit mode
When in edit mode for a form the form name appears above the code. However only the first 15 characters of the name are shown. Can this be increased or the full name show when the mouse is over the name. Herb Wexler
Carriage Return in list view doesn't show in html view
I have a form with a couple multi-line fields. They commonly get carriage returns just with an "enter" key during input. In a list view, those line feeds show up correctly. But when I pull those fields into an html view with a fetch, the line feeds don't show in the html view. Am I doing something wrong, or is there another way to do this? Thanks for any input...
View Recorded Data in Form Layout
Is "form view" an option?? I don't seem to be able to find a way to view just one record in the form view. It would be nice if I could see the entire record on one scree/view and then hit a button that said next to view the next record. I would also like to be able to edit the record in this view. Surely there's a simple way to do this that I'm overlooking??
Customized forms per user
In Creator can I: -Have different users log on -Allow them to only access a form and a report that has been customized to the user -Not allow them to access data that they have not entered (associated with their log in) -But have all of the data from multiple users dumped into a single database? Thank you
Help on inserting capital names in single text box
Hi, i have a problem, i have a single text box where i insert names, is there anyway i can make the box give error if the name entered does not comply with a list of name i have in a form? or do an if not equals name condition? e.g. i have several names all with capital letters JOHN JAMES EMMA TIM but if the user inserts john or james or James or ja.mes or ema, Ema, Emma, resumming if does not match the name in capital it can´t be inserted.
Only a summary view available with no search feature on mobile devices
Even if we copy the URL and access this through a browser on the mobile device you still only get the summary view, up until yesterday we could access the list view through this method, has something changed?
Next Page